Deebs-DeFi-j9fRbzWhale Volume MCB
Updated 2023-12-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
›
⌄
-- forked from MCB Token Volume and Price @ https://flipsidecrypto.xyz/edit/queries/ebfcca91-775e-45ff-90ea-5f0464d9134c
with swapvolume as(
select
Sender as whale,
token_in as token_address,
amount_in_usd as swap_volume_USD,
amount_in as token_amount,
date_trunc('week', block_timestamp) as date
from
arbitrum.defi.ez_dex_swaps
WHERE token_in='0x4e352cf164e64adcbad318c3a1e222e9eba4ce42'
AND amount_in_usd>10000
union
all
select
Sender as whale,
token_out as token_address,
amount_out_usd as swap_volume_USD,
amount_out as token_amount,
date_trunc('week', block_timestamp) as date
from
arbitrum.defi.ez_dex_swaps
WHERE token_out='0x4e352cf164e64adcbad318c3a1e222e9eba4ce42'
AND amount_out_usd>10000
),
prices as(
SELECT
date_trunc('week', hour) as date,
avg(price) as price
FROM crosschain.price.ez_hourly_token_prices
WHERE token_address='0x4e352cf164e64adcbad318c3a1e222e9eba4ce42'
GROUP BY 1
)
select
Run a query to Download Data