KaskoazulUSDC Transfer volume fees :(
    Updated 2022-04-14
    with Algorand as (
    select block_timestamp::date as fecha,
    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'
    group by 1
    order by 1
    ),

    Solana_data as (
    select tf.block_timestamp::date as fecha,
    tf.tx_id,
    tf.amount,
    tc.fee/pow(10,9) as fee
    from solana.fact_transfers tf
    left join solana.fact_transactions tc
    on tf.tx_id = tc.tx_id
    where mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    and fecha >= '2022-01-01'
    limit 500
    ),

    Solana as (
    select fecha,
    count(distinct tx_id) as txs,
    round(sum(amount),2) as daily_vol,
    round(daily_vol / txs, 2) as avg_tx,
    round(sum(fee), 3) as daily_fees,
    daily_fees / txs as avg_fee
    from Solana_data
    Run a query to Download Data