jonestrinhUntitled Query
    Updated 2022-12-12
    with wallet as (
    select
    distinct(address) as name
    from crosschain.core.address_tags
    where tag_name IN ('wallet billionaire', 'wallet millionaire')
    and creator = 'flipside'
    and blockchain = 'ethereum')

    select
    date_trunc('day', block_timestamp) as daytime,
    sum (amount_out_usd) + sum(amount_in_usd) as activity
    from ethereum.core.ez_dex_swaps
    where tx_to in (select name from wallet)
    and daytime >= current_date - interval '30 day'
    and symbol_in in ('USDT', 'USDC', 'DAI', 'BUSD', 'MIM', 'FRAX')
    and symbol_out in ('USDT', 'USDC', 'DAI', 'BUSD', 'MIM', 'FRAX')
    group by 1


    Run a query to Download Data