alirsnyk-02
Updated 2022-11-19
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 FTX
AS (
SELECT address_name
,label
,address
FROM ethereum.core.dim_labels
WHERE address_name ilike '%ftx%'
OR label ilike '%ftx%'
OR label ilike '%alameda research%'
)
,inflow
AS (
SELECT block_timestamp::DATE AS DATE
,sum(amount_usd) AS vol_in
,count(DISTINCT (tx_hash)) AS tx_inflow
FROM ethereum.core.ez_token_transfers
WHERE block_timestamp >= CURRENT_DATE -7
AND to_address IN (
SELECT DISTINCT address
FROM ftx
)
AND from_address NOT IN (
SELECT DISTINCT address
FROM ftx
)
AND amount_usd < 100000
GROUP BY 1
UNION
SELECT block_timestamp::DATE AS DATE
,sum(amount_usd) AS vol_in
,count(DISTINCT (tx_hash)) AS tx_inflow
FROM ethereum.core.ez_eth_transfers
WHERE block_timestamp >= CURRENT_DATE -7
AND eth_to_address IN (
Run a query to Download Data