mariyaYet Another Acme Question
    Updated 2022-04-22
    with solana as (
    SELECT
    date(block_timestamp) as date,
    count(DISTINCT tx_id) as counter,
    ROUND(sum(amount), 1) as volume,
    'solana' as chain
    from solana.fact_transfers
    where mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- usd coin
    and date(block_timestamp) >= '2022-01-01'
    and amount > 0
    GROUP BY date
    ),
    algorand as (
    SELECT
    date(block_timestamp) as date,
    count(DISTINCT tx_group_id) as counter,
    ROUND(sum(asset_amount)::float/1e6, 1) as volume,
    'algorand' as chain
    from algorand.asset_transfer_transaction
    where date(block_timestamp) >= '2022-01-01'
    and asset_amount > 0
    and asset_amount is not NULL
    and asset_id = '31566704' -- USDC
    GROUP BY date
    ),
    ethereum as (
    SELECT
    date(block_timestamp) as date,
    count(DISTINCT tx_id) as counter,
    ROUND(sum(amount), 1) as volume,
    'ethereum' as chain
    from ethereum.udm_events
    where date(block_timestamp) >= '2022-01-01'
    and amount > 0
    and contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' -- USDC
    and event_name = 'transfer'
    Run a query to Download Data