strawbetty daily volume of USDC that is sent between wallets on each blockchain
    Updated 2022-04-19
    with eth_usdc as (
    select
    block_timestamp::date as date,
    sum(amount) as total_volumes
    from
    ethereum.udm_events
    where
    YEAR(block_timestamp) = 2022
    and contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
    and origin_function_name = 'transfer'
    and event_name = 'transfer'
    and event_type = 'erc20_transfer'
    group by 1)
    , data_algorand as (
    select
    block_timestamp::date as date,
    sum(asset_amount/pow(10, 6)) as total_volumes
    from algorand.asset_transfer_transaction
    where YEAR(block_timestamp) = 2022
    and asset_id = 31566704
    group by 1
    )
    , data_solana as (
    select
    block_timestamp::date as date,
    sum(amount) as total_volumes
    from solana.fact_transfers
    where
    YEAR(block_timestamp) = 2022
    and mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    group by 1
    )
    select 'Ethereum' as labeling, * from eth_usdc
    union all
    select 'Algorand' as labeling, * from data_algorand
    union all
    Run a query to Download Data