DAY | TAG | DAILY_NUM_SWAPS | DAILY_TOTAL_VOLUME | |
|---|---|---|---|---|
1 | 2023-04-05 00:00:00.000 | buy | 2 | 0 |
2 | 2023-04-05 00:00:00.000 | sell | 4 | 0 |
3 | 2023-04-06 00:00:00.000 | buy | 1168 | 684004.590167144 |
4 | 2023-04-06 00:00:00.000 | sell | 982 | -722241.242160983 |
5 | 2023-04-07 00:00:00.000 | buy | 574 | 339155.279599992 |
6 | 2023-04-07 00:00:00.000 | sell | 512 | -305875.063150165 |
7 | 2023-04-08 00:00:00.000 | buy | 831 | 179624.664239381 |
8 | 2023-04-08 00:00:00.000 | sell | 785 | -189991.344201203 |
9 | 2023-04-09 00:00:00.000 | buy | 556 | 218859.952858342 |
10 | 2023-04-09 00:00:00.000 | sell | 529 | -257301.123044477 |
11 | 2023-04-10 00:00:00.000 | buy | 943 | 422059.513414498 |
12 | 2023-04-10 00:00:00.000 | sell | 914 | -509543.213628189 |
13 | 2023-04-11 00:00:00.000 | buy | 1339 | 319637.07026937 |
14 | 2023-04-11 00:00:00.000 | sell | 1314 | -292398.935748836 |
15 | 2023-04-12 00:00:00.000 | buy | 1064 | 340277.975207361 |
16 | 2023-04-12 00:00:00.000 | sell | 1027 | -221489.1791963 |
17 | 2023-04-13 00:00:00.000 | buy | 1877 | 818357.790475727 |
18 | 2023-04-13 00:00:00.000 | sell | 1870 | -850690.567838694 |
19 | 2023-04-14 00:00:00.000 | buy | 2083 | 921130.80901562 |
20 | 2023-04-14 00:00:00.000 | sell | 2027 | -888765.997571245 |
Kruys-Collinsfree-white
Updated 2025-03-09
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 base AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
CASE
WHEN token_in = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD' THEN 'sell'
WHEN token_out = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD' THEN 'buy'
END AS tag,
amount_in_usd,
amount_out_usd
FROM
aptos.defi.ez_dex_swaps
WHERE
token_in = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD'
OR token_out = '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_coin::MOD'
),
daily_swaps AS (
SELECT
day,
tag,
COUNT(*) AS num_swaps,
SUM(CASE WHEN tag = 'buy' THEN COALESCE(amount_in_usd, amount_out_usd, 0) ELSE COALESCE(-amount_in_usd, -amount_out_usd, 0) END) AS total_volume
FROM
base
GROUP BY
day, tag
)
SELECT
day,
tag,
num_swaps AS daily_num_swaps,
total_volume AS daily_total_volume
FROM
daily_swaps
ORDER BY
day, tag;
Last run: about 2 months ago
...
1410
78KB
3s