DATE | ITEM_PURCHASED | SALES | TOTAL_BUYERS | TOTAL_AMOUNT | |
|---|---|---|---|---|---|
1 | 2025-04-12 00:00:00.000 | Owners Club Hoodie | 21 | 21 | 27300 |
2 | 2025-04-12 00:00:00.000 | Everything on Bitcoin T-shirt | 7 | 7 | 4900 |
3 | 2025-04-12 00:00:00.000 | Mezo Cap | 15 | 15 | 4500 |
4 | 2025-04-11 00:00:00.000 | Owners Club Hoodie | 143 | 141 | 185900 |
5 | 2025-04-11 00:00:00.000 | Everything on Bitcoin T-shirt | 121 | 116 | 84700 |
6 | 2025-04-11 00:00:00.000 | Mezo Cap | 228 | 223 | 68400 |
7 | 2025-04-10 00:00:00.000 | Owners Club Hoodie | 167 | 166 | 217100 |
8 | 2025-04-10 00:00:00.000 | Everything on Bitcoin T-shirt | 162 | 160 | 113400 |
9 | 2025-04-10 00:00:00.000 | Mezo Cap | 266 | 264 | 79800 |
10 | 2025-04-09 00:00:00.000 | Owners Club Hoodie | 245 | 243 | 318500 |
11 | 2025-04-09 00:00:00.000 | Everything on Bitcoin T-shirt | 207 | 205 | 144900 |
12 | 2025-04-09 00:00:00.000 | Mezo Cap | 257 | 255 | 77100 |
13 | 2025-04-08 00:00:00.000 | Owners Club Hoodie | 211 | 208 | 274300 |
14 | 2025-04-08 00:00:00.000 | Everything on Bitcoin T-shirt | 226 | 223 | 158200 |
15 | 2025-04-08 00:00:00.000 | Mezo Cap | 299 | 285 | 89700 |
16 | 2025-04-07 00:00:00.000 | Owners Club Hoodie | 157 | 157 | 204100 |
17 | 2025-04-07 00:00:00.000 | Everything on Bitcoin T-shirt | 152 | 151 | 106400 |
18 | 2025-04-07 00:00:00.000 | Mezo Cap | 258 | 257 | 77400 |
19 | 2025-04-06 00:00:00.000 | Owners Club Hoodie | 204 | 204 | 265200 |
20 | 2025-04-06 00:00:00.000 | Everything on Bitcoin T-shirt | 173 | 169 | 121100 |
zyroqs5
Updated 2025-04-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT
DATE(block_timestamp) AS date,
CASE
WHEN ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18 = 100 THEN 'Taho x Mezo NFT'
WHEN ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18 = 300 THEN 'Mezo Cap'
WHEN ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18 = 700 THEN 'Everything on Bitcoin T-shirt'
WHEN ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18 = 1300 THEN 'Owners Club Hoodie'
ELSE 'Unknown Item'
END AS item_purchased,
COUNT(DISTINCT tx_hash) AS sales,
COUNT(DISTINCT '0x' || SUBSTR(topics[1], 27)) AS total_buyers,
SUM(ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64))::NUMERIC / 1e18) AS total_amount -- Sum of amounts
FROM
mezo.testnet.fact_event_logs
WHERE
CONTRACT_ADDRESS = LOWER('0x637e22A1EBbca50EA2d34027c238317fD10003eB')
AND topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
AND '0x' || SUBSTR(topics[2], 27) = '0xd6626dcca8aa760b227e02b2391aaaecf9371c5d'
GROUP BY
DATE(block_timestamp), item_purchased
ORDER BY
date DESC, total_amount DESC;
Last run: 13 days ago
45
3KB
31s