binhachonActive Addresses - #3
    Updated 2022-06-05
    with transaction_list as (
    select
    date_trunc('day', block_timestamp) as time_1,
    origin_address as address_1
    from flipside_prod_db.polygon.udm_events
    where block_timestamp::date >= getdate() - interval'{{time}} months'
    group by 1, 2
    union
    select
    date_trunc('day', block_timestamp) as time_1,
    to_address as address_1
    from flipside_prod_db.polygon.udm_events
    where block_timestamp::date >= getdate() - interval'{{time}} months'
    and amount is not null
    group by 1, 2
    ),
    user_list as (
    select
    distinct address_1 as address
    from transaction_list
    ),
    date_list as (
    select
    distinct time_1 as time
    from transaction_list
    ),
    user_list_with_date as (
    select
    time,
    address
    from date_list
    left join user_list
    ),
    user_list_with_date_1 as (
    select
    user_list_with_date.*,
    Run a query to Download Data