Using a materialized view as another materialized view as base timeout / OOM

If this helps, here are the sizes and partitions for the hourlies:

{
    "query": "select * from table_storage() where tableName ilike '%holdings_hourly%'",
    "columns": [
        {
            "name": "tableName",
            "type": "STRING"
        },
        {
            "name": "walEnabled",
            "type": "BOOLEAN"
        },
        {
            "name": "partitionBy",
            "type": "STRING"
        },
        {
            "name": "partitionCount",
            "type": "LONG"
        },
        {
            "name": "rowCount",
            "type": "LONG"
        },
        {
            "name": "diskSize",
            "type": "LONG"
        }
    ],
    "dataset": [
        [
            "holdings_hourly",
            true,
            "DAY",
            "292",
            "227751696",
            "32975724015"
        ]
    ]
}

and partitions (here is a small subset, but assume they are all balanced like this image):