tubaecciSeiyans Volume Over Time
Updated 2024-11-03
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 sales AS(
SELECT
SUM(amount) AS "total volume $sei"
FROM sei.nft.ez_nft_sales
WHERE nft_address = 'sei1g2a0q3tddzs7vf7lk45c2tgufsaqerxmsdr2cprth3mjtuqxm60qdmravc'
AND event_type = 'sale'
),
m1 AS(
SELECT
SUM(amount) AS "1 month volume $sei"
FROM sei.nft.ez_nft_sales
WHERE nft_address = 'sei1g2a0q3tddzs7vf7lk45c2tgufsaqerxmsdr2cprth3mjtuqxm60qdmravc'
AND block_timestamp > current_timestamp - INTERVAL '1 month'
AND event_type = 'sale'
),
d7 AS(
SELECT
SUM(amount) AS "7 days volume $sei"
FROM sei.nft.ez_nft_sales
WHERE nft_address = 'sei1g2a0q3tddzs7vf7lk45c2tgufsaqerxmsdr2cprth3mjtuqxm60qdmravc'
AND block_timestamp > current_timestamp - INTERVAL '7 day'
AND event_type = 'sale'
),
h24 AS(
SELECT
SUM(amount) AS "24H volume $sei"
FROM sei.nft.ez_nft_sales
WHERE nft_address = 'sei1g2a0q3tddzs7vf7lk45c2tgufsaqerxmsdr2cprth3mjtuqxm60qdmravc'
AND block_timestamp > current_timestamp - INTERVAL '1 day'
AND event_type = 'sale'
)
SELECT *
FROM sales, m1, d7, h24;
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived