Papasot186. Bridge - Ethereum to Terra - Daily
Updated 2022-11-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select --date_trunc('week',block_timestamp) AS DateWeek,
date_trunc('day',block_timestamp) AS DateDay,
CASE WHEN contract_address = '0xa47c8bf37f92abed4a126bda807a7b7498661acd' THEN 'UST' ELSE 'LUNA' END AS Currency,
count(distinct from_address) AS AddressCount,
count(tx_id) AS TxCount,
sum(amount) AS totalAmount,
sum(totalAmount) over (order by DateDay asc rows between unbounded preceding and current row) as cum_amount
from ethereum.udm_events
where to_address = '0x0000000000000000000000000000000000000000'
and contract_address = '0xa47c8bf37f92abed4a126bda807a7b7498661acd'
and DateDay > '2022-01-01'
group by 1,2
order by 1 desc
Run a query to Download Data