adriaparcerisasTRAD token activity
Updated 2023-05-01
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 wallet_outflows AS (
SELECT
trunc(block_timestamp,'day')as day,
from_address AS wallet_address,
-SUM(AMOUNT_USD) AS outflow
FROM ethereum.core.ez_token_transfers
WHERE contract_address = lower('0x2718fEDFc22CC6d727932c8424993218B0AcB859') and from_address != origin_from_address and to_address = origin_from_address --and EVENT_TYPE = 'erc20_transfer'
and amount_usd>0 and amount_usd<1e6
GROUP BY 1,2
),
wallet_inflows as (
SELECT
trunc(block_timestamp,'day')as day,
to_address AS wallet_address,
SUM(AMOUNT_USD) AS inflow
FROM ethereum.core.ez_token_transfers
WHERE contract_address = lower('0x2718fEDFc22CC6d727932c8424993218B0AcB859') --and from_address != origin_from_address and to_address = origin_from_address --and EVENT_TYPE = 'erc20_transfer'
and amount_usd>0 and amount_usd<1e6
GROUP BY 1,2
),
wallet_flows as (
SELECT
ifnull(x.day,y.day) as days,
ifnull(x.wallet_address,y.wallet_address) as wallet,
ifnull(inflow,0) as inflow,
ifnull(outflow,0) as outflow
from wallet_inflows x
join wallet_outflows y on x.day=y.day and x.wallet_address=y.wallet_address
--where inflow>0 and outflow>0
)
,
swap_outflows AS (
SELECT
Run a query to Download Data