KaskoazulUSDC Transfer volume high stakes
    Updated 2022-04-14
    with Algorand as (
    select block_timestamp::date as fecha,
    sender,
    count(distinct tx_id) as txs,
    round(sum(tx_message:txn:aamt/pow(10,6)),2) as daily_vol,
    round(daily_vol / txs, 2) as avg_tx,
    round(sum(fee), 3) as daily_fees,
    round(daily_fees / txs, 5) as avg_fee
    from algorand.transactions
    where asset_id = '31566704'
    and tx_type_name = 'asset transfer'
    and fecha >= '2022-01-01'
    and sender in ('ZG54ZBZ5LVWV3MTGOPDSKCBL5LEQTAPUTN5OQQZUMTAYV3JIICA7G3RJZE', '2UEQTE5QDNXPI7M3TU44G6SYKLFWLPQO7EBZM7K7MHMQQMFI4QJPLHQFHM')
    group by 1, 2
    order by 1
    ),


    Solana as (
    select block_timestamp::date as fecha,
    count(distinct tx_id) as txs,
    round(sum(amount),2) as daily_vol,
    round(daily_vol / txs, 2) as avg_tx
    from solana.fact_transfers
    where mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    and fecha >= '2022-01-01'
    group by 1
    order by 1
    ),

    Ethereum as (
    select block_timestamp::date as fecha,
    count(distinct tx_id) as txs,
    round(sum(amount),2) as daily_vol,
    round(sum(amount_usd),2) as daily_vol_usd,
    round(daily_vol / txs, 2) as avg_tx
    Run a query to Download Data