CryptoLioninflow outflow
Updated 2022-11-28
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
›
⌄
WITH inflows as (
SELECT
date_trunc('day',block_timestamp) as day,
SUM(amount_usd) as inflow_sum
FROM ethereum.udm_events
WHERE to_address = '0xab8e74017a8cc7c15ffccd726603790d26d7deca'
AND block_timestamp > getdate() - interval '60 days'
AND contract_address = '0xdbdb4d16eda451d0503b854cf79d55697f90c8df' --alcx
GROUP BY 1
),
outflows as (
SELECT
date_trunc('day',block_timestamp) as day,
SUM(amount_usd) as outflow_sum
FROM ethereum.udm_events
WHERE from_address = '0xab8e74017a8cc7c15ffccd726603790d26d7deca'
AND block_timestamp > getdate() - interval '60 days'
AND contract_address = '0xdbdb4d16eda451d0503b854cf79d55697f90c8df' --alcx
GROUP BY 1
)
SELECT
i.day,
outflow_sum,
inflow_sum
FROM inflows i LEFT OUTER JOIN outflows o ON i.day = o.day
AND i.day >= '2021-02-26'
GROUP BY 1 , 2 , 3
Run a query to Download Data