jackguyBinance Stablecoin Saga
Updated 2023-04-14
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 tab1 as (
SELECT
platform,
pool_address
FROM ethereum.core.dim_dex_liquidity_pools
WHERE TOKEN0_SYMBOL LIKE 'BUSD'
OR TOKEN1_SYMBOL LIKE 'BUSD'
UNION
SELECT
COLUMN1 as platform,
COLUMN2 as pool_address
FROM (
SELECT
*
FROM
VALUES
('Curve', '0x4807862AA8b2bF68830e4C8dc86D0e9A998e085a'),
('Curve', '0x8fdb0bb9365a46b145db80d0b1c5c5e979c84190'),
('Curve', '0x79a8C46DeA5aDa233ABaFFD40F3A0A2B1e5A4F27')
)
)
SELECT
*,
sum(BUSD_TVL_DELTA) over (partition by platform order by day) as BUSD_TVL
FROM (
SELECT
day,
platform,
sum(CASE WHEN tx_type LIKE 'tx_in' THEN volume ELSE -1 * volume END) as BUSD_TVL_DELTA,
sum(CASE WHEN tx_type LIKE 'tx_in' THEN volume END) - sum(CASE WHEN tx_type LIKE 'tx_out' THEN volume END) as out_1
FROM (
Run a query to Download Data