MLDZMNDEXs
    Updated 2022-05-30
    with tb1 as (select
    block_timestamp::date as day,
    l.LABEL_TYPE,
    count(distinct t.FROM_ADDRESS) as user_ETH
    --sum(user_ETH) over (partition by LABEL_TYPE order by day) as grow_rate
    from flipside_prod_db.ethereum_core.fact_transactions t join flipside_prod_db.ethereum_core.dim_labels l on t.TO_ADDRESS= l.address
    where t.block_timestamp>=CURRENT_DATE-60
    and l.label_subtype != 'token_contract'
    and l.LABEL_TYPE in ('dex')
    and t.STATUS = 'SUCCESS'
    group by 1,2),

    tb2 as (select
    block_timestamp::date as day,
    l.LABEL_TYPE,
    count(distinct t.signers[0]) as user_sol
    from solana.fact_transactions t join solana.dim_labels l on t.instructions[0]:programId = l.address
    where t.block_timestamp>=CURRENT_DATE-60
    and l.label_subtype != 'token_contract'
    and l.LABEL_TYPE in ('dex')
    and l.label != 'solana'
    and t.succeeded = TRUE
    group by 1,2)

    select
    tb1.day as day,
    user_sol,
    user_ETH
    from tb1 join tb2 on tb1.day=tb2.day
    Run a query to Download Data