smartymetricsalltime trade volume
Updated 2024-10-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
30
31
32
33
34
35
36
›
⌄
-- 0xb755506531786c8ac63b756bab1ac387bacb0c04 ZARP South Africa
-- 0x39aa39c021dfbae8fac545936693ac917d5e7563 CUSDC compound,finance
with cusdc as (
SELECT
platform,
date_trunc('month', block_timestamp) as month,
sum(round(amount_in_usd + amount_out_usd)) over(partition by month) as volume,
(CASE WHEN token_out = '0x39aa39c021dfbae8fac545936693ac917d5e7563' THEN symbol_out ELSE symbol_in END) AS symbol,
origin_from_address AS trader,
(CASE WHEN min(block_timestamp::date) over(partition by trader) >= '2024-01-01' THEN 'New Trader' ELSE 'Old Trader' END) AS trader_type
FROM ethereum.defi.ez_dex_swaps
WHERE
token_out = lower('0x39aa39c021dfbae8fac545936693ac917d5e7563')
OR
token_in = lower('0x39aa39c021dfbae8fac545936693ac917d5e7563')
), zarp as (
SELECT
platform,
date_trunc('month', block_timestamp) as month,
sum(round(amount_in_usd + amount_out_usd)) over(partition by month) as volume,
(CASE WHEN token_out = '0xb755506531786c8ac63b756bab1ac387bacb0c04' THEN symbol_out ELSE symbol_in END) AS symbol,
origin_from_address AS trader,
(CASE WHEN min(block_timestamp::date) over(partition by trader) >= '2024-01-01' THEN 'New Trader' ELSE 'Old Trader' END) AS trader_type
FROM ethereum.defi.ez_dex_swaps
WHERE
token_out = lower('0xb755506531786c8ac63b756bab1ac387bacb0c04')
OR
token_in = lower('0xb755506531786c8ac63b756bab1ac387bacb0c04')
) --, new_trader AS (
-- SELECT
-- origin_from_address AS trader,
-- (CASE WHEN min(block_timestamp::date) over(partition by trader) >= '2024-01-01' THEN 'New Trader' ELSE 'Old Trader' END) AS trader_type,
-- date_trunc('month', block_timestamp) AS month
-- FROM ethereum.defi.ez_dex_swaps
-- )
QueryRunArchived: QueryRun has been archived