KaskoazulUntitled Query
Updated 2022-11-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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