Papasot186. Bridge - Terra to Ethereum - Daily
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- original code written by brian.terra
-- This fork aims to answer a slightly different bounty
select
date_trunc('day',block_timestamp) AS DateDay,
event_currency AS currency,
count(distinct event_to) AS AddressCount,
count(tx_id) AS TxCount,
sum(event_amount) as total_Amount,
sum(total_Amount) over (order by DateDay asc rows between unbounded preceding and current row) as cum_amount,
sum(event_amount_usd) AS totalUSD
from terra.transfers
where event_from = 'terra13yxhrk08qvdf5zdc9ss5mwsg5sf7zva9xrgwgc'
AND event_currency = 'UST'
AND tx_status = 'SUCCEEDED'
AND DateDay > '2022-01-01'
group by 1,2
order by 1 desc
Run a query to Download Data