anomoneShuttle - UST Inflow
Updated 2022-07-07
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
date_trunc('day', block_timestamp) as date,
SUM(EVENT_AMOUNT) as "UST Inflow",
SUM("UST Inflow") Over ( Order by Date) as Cum_Inflow
FROM terra.transfers
WHERE EVENT_TO = 'terra13yxhrk08qvdf5zdc9ss5mwsg5sf7zva9xrgwgc' --shuttle ethereum bridge
AND tx_status = 'SUCCEEDED'
AND EVENT_CURRENCY = 'UST'
GROUP BY date_trunc('day', block_timestamp)
Run a query to Download Data