SandeshHolograph contracts deployed over time
    Updated 2024-04-15
    -- forked from Holograph consolidated wallets @ https://flipsidecrypto.xyz/edit/queries/8bead0ad-52e3-468e-9670-24152bf72631

    with raw_transfers as (
    select 'Ethereum' as chain, livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/381fda6e-5d57-4e31-8f04-69625b991a58/latest-run') as resp
    union
    select 'Optimism' as chain, livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/cd7290cb-f38b-4936-98b6-67649cbfd1eb/latest-run') as response
    union
    select 'BSC' as chain, livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/6c6fbeb4-7948-4f03-8442-c33c23ca8aeb/latest-run') as response
    union
    select 'Polygon' as chain, livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/22bd07ae-d8de-44f9-87a7-8850206baabb/latest-run') as response
    union
    select 'Arbitrum' as chain, livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/308f9495-d62c-4f84-87cc-7772eb0e3c17/latest-run') as response
    union
    select 'Avalanche' as chain, livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/f2d563cb-344a-4a9b-8686-7fa68ece24e0/latest-run') as response
    union
    select 'Base' as chain, livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/9de387c8-9d67-4d9f-85e1-fa634b1ad493/latest-run') as response

    ),

    flattened_wallets as (
    select
    chain,
    value[0] as date,
    -- value[1] as contracts_deployed,
    value[2] as cummulative_contracts_deployed
    from
    raw_transfers, lateral FLATTEN (input=> resp:data:result:rows)
    -- where wallets is not null
    )

    SELECT
    DATE,
    "'Polygon'" as Polygon,
    "'Base'" as Base,
    "'Ethereum'" as Ethereum,
    "'Optimism'" as Optimism,
    QueryRunArchived: QueryRun has been archived