takeabreath$HOP Volume, Trade Count, Avg Trade Size, Turnover Rate
Updated 2024-04-04
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 hop_swaps AS (
SELECT
block_timestamp,
DATE_TRUNC('day', block_timestamp) AS day,
CASE
WHEN token_in = '0xc5102fe9359fd9a28f877a67e36b0f050d81a3cc' THEN DIV0(amount_out_usd, amount_in)
ELSE DIV0(amount_in_usd, amount_out)
END AS price,
MAX(price) OVER (
PARTITION BY day
ORDER BY
block_timestamp
) AS high,
MIN(price) OVER (
PARTITION BY day
ORDER BY
block_timestamp
) AS low,
CASE
WHEN token_in = '0xc5102fe9359fd9a28f877a67e36b0f050d81a3cc' THEN amount_out_usd
ELSE amount_in_usd
END AS amount_usd,
SUM(amount_usd) OVER (
PARTITION BY day
ORDER BY
block_timestamp
) AS volume,
COUNT(block_timestamp) OVER (
PARTITION BY day
ORDER BY
block_timestamp
) AS trade_count,
blockchain,
platform,
CASE
WHEN token_in = '0xc5102fe9359fd9a28f877a67e36b0f050d81a3cc' THEN symbol_out
QueryRunArchived: QueryRun has been archived