barbodDaily Active Wallets use UST Vs DAI
    Updated 2022-05-10
    with tab1 as (
    select
    date_trunc('day', block_timestamp) as date1,
    count(distinct trader) as count1


    from terra.swaps
    where token_0_currency like 'UST' or token_1_currency like 'UST'
    group by 1
    )

    , tab2 as (
    select
    date_trunc('day', block_timestamp) date2,
    count(distinct sender) as count2


    from ethereum_core.ez_dex_swaps
    where symbol_in like 'DAI' or symbol_out like 'DAI'
    group by 1
    )

    select
    date1,
    count1 as UST,
    count2 as DAI
    from tab1 left outer join tab2 on date1 = date2
    Run a query to Download Data