Moe1 MSO
    Updated 2022-09-19
    select
    'AVALANCHE' as network ,
    date_trunc(week,block_timestamp) as weeks,
    date_trunc(month,block_timestamp) as months,
    count(distinct CONTRACT_ADDRESS) as count_auctions,
    sum(count_auctions)over( order by weeks ) as cumulative_auctions
    --COUNT(DISTINCT origin_from_address) as user_count
    from
    avalanche.core.fact_token_transfers
    where 1=1
    and origin_to_address ilike '0x438a2b1c6c715fb1b051c04ca65755560d8b8d43'
    --and event_name ilike 'MarketCreated'
    group by weeks,months
    union ALL
    select
    'POLYGON' as network,
    date_trunc(week,block_timestamp) as weeks,
    date_trunc(month,block_timestamp) as months,
    count(distinct CONTRACT_ADDRESS) as count_auctions,
    sum(count_auctions)over( order by weeks ) as cumulative_auctions
    --COUNT(DISTINCT origin_from_address) as user_count
    from
    polygon.core.fact_token_transfers
    where 1=1
    and origin_to_address ilike '0xc040f84cf7046409f92d578ef9040fe45e6ef4be'
    --and event_name ilike 'MarketCreated'
    group by weeks,months

    union ALL
    select
    Run a query to Download Data