elenahooMars - Fields transaction count and amount
Updated 2022-03-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with fields as (
select
date_trunc('day', block_timestamp) as date
, count(tx_id) as tx_count
, sum(amount_usd) as usd_amount
from terra.transfer_events
where
sender in ('terra12dq4wmfcsnz6ycep6ek4umtuaj6luhfp256hyu', -- Mars Fields MIR UST
'terra1vapq79y9cqghqny7zt72g4qukndz282uvqwtz6', --ANC UST
'terra1kztywx50wv38r58unxj9p6k3pgr2ux6w5x68md') --Luna UST
or recipient in ('terra12dq4wmfcsnz6ycep6ek4umtuaj6luhfp256hyu',
'terra1vapq79y9cqghqny7zt72g4qukndz282uvqwtz6',
'terra1kztywx50wv38r58unxj9p6k3pgr2ux6w5x68md')
group by 1
order by 1 asc
)
select * from fields
where date <= CURRENT_DATE - INTERVAL '1 DAY'
order by date asc
Run a query to Download Data