datavortexTraders Categories
Updated 2024-11-02
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 SolanaTransactions AS (
SELECT
swapper AS "LeadingSwapper",
COALESCE(swap_from_amount_usd, 0) AS "TransactionVolume"
FROM
solana.defi.ez_dex_swaps
WHERE
block_timestamp BETWEEN '2024-10-01'
AND '2024-10-31'
),
EthereumTransactions AS (
SELECT
origin_from_address AS "LeadingSwapper",
COALESCE(amount_in_usd, 0) AS "TransactionVolume"
FROM
ethereum.defi.ez_dex_swaps
WHERE
block_timestamp BETWEEN '2024-10-01'
AND '2024-10-31'
),
SolanaTraderVolume AS (
SELECT
"LeadingSwapper",
SUM(COALESCE("TransactionVolume", 0)) AS "TotalVolumeSolana"
FROM
SolanaTransactions
GROUP BY
"LeadingSwapper"
),
EthereumTraderVolume AS (
SELECT
"LeadingSwapper",
SUM(COALESCE("TransactionVolume", 0)) AS "TotalVolumeEthereum"
FROM
EthereumTransactions
GROUP BY
QueryRunArchived: QueryRun has been archived