theericstoneFind LFG_reserve address
Updated 2022-03-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- commented out how i found the lfg address...
--select sender as address,
-- sender_address_label as address_label,
-- sender_address_name as address_name,
-- 'inbound' as direction,
-- currency,
-- amount,
-- amount_usd from
-- terra.transfer_events
-- where block_timestamp > '2022-02-17' and block_timestamp < '2022-02-19'
-- and recipient = 'terra1tmnqgvg567ypvsvk6rwsga3srp7e3lg6u0elp8' -- anchor reserves address
--and amount > 1000000;
with outbounds as (
select recipient as address,
recipient_label as address_label,
recipient_address_name as address_name,
'outbound' as direction,
currency,
sum(amount) * -1 as amount,
sum(amount_usd) * -1 as amount_usd FROM
terra.transfer_events
where
block_timestamp > current_date - 100
and sender = 'terra13h0qevzm8r5q0yknaamlq6m3k8kuluce7yf5lj'
group by 1,2,3,4,5
),
inbounds as (
select sender as address,
sender_address_label as address_label,
sender_address_name as address_name,
'inbound' as direction,
currency,
sum(amount) as amount,
sum(amount_usd) as amount_usd FROM
Run a query to Download Data