jackguyDeans list Treasury 1-1
Updated 2024-06-03
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
›
⌄
with token_flow as (
SELECT
date_trunc('day', day) as day,
sum(CASE when tx_type like 'in' then volume
else 0 end
) as inflow,
sum(CASE when tx_type like 'out' then volume
else 0 end
) as outflow,
sum(
CASE when tx_type like 'in' then volume
else -1 * volume end
) as net_inflow
FROM (
SELECT
date(block_timestamp) as day,
'in' as tx_type,
sum(amount) as volume
FROM solana.core.fact_transfers
WHERE tx_to in (
'7A6CrNWAFFBpQTBRo5fULibqqB3MouNLgbVBf8D3MJAx',
'FAEYozsZVkxhXwG1HnVJn58Ks3dff31zjtA8b3KezFJ6',
'GT8mMx9sUwxgZcTQLtnCZ7X4p2PCg965cW36EzqdAJKg',
'EF7cbbwC4mPnSvcPKCsjsh42nsMKLuAzhBToZkJAieBe',
'AReaS1MyNi5xHfu9BZ9HGUyjmmmBNJMV369FpmgJPjri',
'Aqz7UK6VCUaSosh72qQxV6vSpb7CKaegrkdu5eq3JRQM',
'83amAjBioFDKo8T8yq6AXWxVyAWkVbLsVBahpS2K2hps',
'5cuphHT3qwYrifbsNuMHPBAzEgBKn1NoFCTyU9c4VWEB',
'3ZfK44kHJ8jGs1Ni9ntt5wRN2FaXtkzUzWqVg4nMKXzk',
'EFJr68nHAgLUfNagqCWp3rnusyf8u5xKWLzLXJTdrC1q'
)
AND mint LIKE 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
AND block_timestamp > '2022-01-01'
GROUP BY 1,2