fb3ce38c-7bfe-475c-bca8-3f1e44ae80a6Untitled Query
Updated 2023-04-10
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
›
⌄
SELECT
COUNT(TO_ADDRESS) TOTAL_VOLUME,
SUM(AVAX_VALUE) AS total_sales,
BLOCK_TIMESTAMP::DATE day_agg,
CASE WHEN TO_ADDRESS = '0xc28f1550160478a7fb3b085f25d4b179e08e649a' THEN 'NFTrade'
WHEN TO_ADDRESS IN ('0x11ac3118309a7215c6d87c7c396e2df333ae3a9c', '0xeff2357c9e40103ac4d268b32de478e4fbbfc4f0') THEN 'Kalao'
WHEN TO_ADDRESS IN ('0xcf91b99548b1c17dd1095c0680e20de380635e20','0x8927985b358692815e18f2138964679dca5d3b79') THEN 'Chikn'
WHEN TO_ADDRESS = '0xae079eda901f7727d0715aff8f82ba8295719977' THEN 'JoePegs'
WHEN TO_ADDRESS = '0xbcb09cdb2011fea0591b52e52085bb102e4a082a' THEN 'Campfire'
WHEN TO_ADDRESS = lower('0x00000000006c3852cbEf3e08E8dF289169EdE581') THEN 'OpenSea'
END AS market
FROM avalanche.core.fact_transactions trans
WHERE TO_ADDRESS IN ('0xc28f1550160478a7fb3b085f25d4b179e08e649a', -- NFTrade
'0x11ac3118309a7215c6d87c7c396e2df333ae3a9c', -- Kalao v1
'0xeff2357c9e40103ac4d268b32de478e4fbbfc4f0', -- Kalao v2
'0xcf91b99548b1c17dd1095c0680e20de380635e20', -- Roostr
'0x8927985b358692815e18f2138964679dca5d3b79', -- Chikn
'0xae079eda901f7727d0715aff8f82ba8295719977', -- joepegs
'0xbcb09cdb2011fea0591b52e52085bb102e4a082a', -- Campfire.exchange
lower('0x00000000006c3852cbEf3e08E8dF289169EdE581') -- OpenSea
)
AND status ='SUCCESS'
GROUP BY day_agg, market
ORDER BY day_agg DESC
Run a query to Download Data