KaskoazulUntitled Query
    Updated 2022-11-11
    select tx.block_timestamp::date as fecha,--tx.tx_group_id,
    tx.inner_tx,
    count(distinct tx.tx_id) as txs,
    sum(tx.fee) as fees,
    sum(tx.asset_amount) as amount
    from algorand.core.fact_transaction tx
    left join algorand.core.ez_transfer tf
    on tx.tx_id = tf.tx_id
    where tx.block_timestamp >= CURRENT_DATE - 30
    group by 1,2

    -- select * from algorand.core.ez_transfer where tx_id in ('KPL5SVJIA3JGDFZVOBAQFDUD3H3T3SZDKHWGCA3EMGOC2U5QGKQA')

    --select INNER_TX, sum(fee) from algorand.core.fact_transaction where block_timestamp >= CURRENT_DATE - 10 group by 1
    Run a query to Download Data