keshanTerra 160 q4
Updated 2022-03-07
9
1
2
3
4
5
6
7
8
›
⌄
with new_addresses as (select distinct address from terra.daily_balances
where date = current_date
and address not in (select distinct address from terra.daily_balances
where date = CURRENT_DATE - 91)),
txs as (select value as address, tx_to, tx_id, block_timestamp from terra.transactions cross join lateral flatten(tx_from) order by t)
select * from txs where address in (select * from new_addresses) order by block_timestamp
Run a query to Download Data