Arashhgrant 3
Updated 2023-02-12Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- terra1tu5z28h9ssattvsltlzt5c8r2mvs2006qvq3tvjk5c8fxve85xss84w8vr mdao
--terra1sjgx7q6mx9e5jjg8dcm498w7reuzufghqvucc8d7d3ad4z2fra4q9l574a terra finder
select
date_trunc('day',BLOCK_TIMESTAMP) as date ,
TX_ID ,
case
when
RECEIVER='terra1tu5z28h9ssattvsltlzt5c8r2mvs2006qvq3tvjk5c8fxve85xss84w8vr' then 'metricsdao' else RECEIVER end as recieverr,
AMOUNT/1e6 as volume
from
terra.core.ez_transfers
where
SENDER='terra1sjgx7q6mx9e5jjg8dcm498w7reuzufghqvucc8d7d3ad4z2fra4q9l574a'
Run a query to Download Data