scottincryptoLlama Treasury Token Transfers
Updated 2022-12-01
999
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
›
⌄
with xfers_in as (
select
date_trunc('day', block_timestamp) as block_day
, to_address as wallet
, contract_address
, symbol
, sum(raw_amount) as raw_amount_in
, sum(amount) as amount_in
from ethereum.core.ez_token_transfers
where to_address in ('0xb428c6812e53f843185986472bb7c1e25632e0f7', '0xa519a7ce7b24333055781133b13532aeabfac81b')
and block_timestamp > '2021-06-13'
and symbol is not null
group by block_day, to_address, contract_address, symbol
union all
select
date_trunc('day', block_timestamp) as block_day
, eth_to_address as wallet
, '0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee' as contract_address
, 'ETH' as symbol
, sum(amount) as raw_amount_in
, sum(amount) as amount_in
from ethereum.core.ez_eth_transfers
where eth_to_address in ('0xb428c6812e53f843185986472bb7c1e25632e0f7', '0xa519a7ce7b24333055781133b13532aeabfac81b')
group by block_day, eth_to_address, contract_address, symbol
)
, xfers_out as (
select
date_trunc('day', block_timestamp) as block_day
, from_address as wallet
, contract_address
, symbol
, sum(raw_amount) as raw_amount_out
, sum(amount) as amount_out
from ethereum.core.ez_token_transfers
where from_address in (select distinct wallet from xfers_in)
Run a query to Download Data