Kruys-Collinsunaware-lime copy copy
Updated 2024-12-17
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 unaware-lime copy @ https://flipsidecrypto.xyz/studio/queries/897f0e02-b7c4-4219-a984-32599f9c8aa6
-- forked from unaware-lime @ https://flipsidecrypto.xyz/studio/queries/9f557ed4-98b0-4b49-a12e-9ffd5f9edab9
WITH CRABS AS (
SELECT
block_timestamp,
sender as trader,
symbol_out,
symbol_in,
SUM(COALESCE(amount_in_usd, amount_out_usd, 0)) AS total_trade_volume
FROM kaia.defi.ez_dex_swaps
WHERE COALESCE(amount_in_usd, amount_out_usd, 0) BETWEEN 1000 AND 9999
AND DATE_TRUNC('day', block_timestamp) >= '2024-01-01'
GROUP BY 1, 2, 3, 4
ORDER BY 5 DESC
),
crabs_24H AS (
SELECT DISTINCT trader
FROM crabs
WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '1 day'
),
crabs_7D AS (
SELECT DISTINCT trader
FROM crabs
WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '7 days'
),
crabs_30D AS (
SELECT DISTINCT trader
FROM crabs
WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 days'
),
crabs_90D AS (
SELECT DISTINCT trader
FROM crabs
WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '90 days'
QueryRunArchived: QueryRun has been archived