saber-jlstabelcoins netfloow on solana
Updated 2022-11-08
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
›
⌄
--credit from jacktheguy
WITH outflow as (
SELECT
CASE
WHEN mint LIKE 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'USDC'
WHEN mint LIKE 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' THEN 'USDT'
END as token1,
sum(amount) as inflow_amount
FROM solana.core.fact_transfers
LEFT outer JOIN solana.core.dim_labels
ON TX_TO = address
WHERE (address_name LIKE '%ftx%'
OR address_name LIKE '%alameda%' )
AND mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')
AND block_timestamp >= '2022-10-01'
GROUP BY 1
),
inflow as (
SELECT
CASE
WHEN mint LIKE 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'USDC'
WHEN mint LIKE 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' THEN 'USDT'
END as token2,
sum(amount) outflow_amount
FROM solana.core.fact_transfers
LEFT outer JOIN solana.core.dim_labels
ON TX_from = address
WHERE (address_name LIKE '%ftx%'
OR address_name LIKE '%alameda%')
AND mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')
AND block_timestamp >= '2022-10-01'
GROUP BY 1 )
SELECT inflow_amount , outflow_amount ,(inflow_amount - outflow_amount) as netflow,token1
from inflow , outflow
Run a query to Download Data