denze-e7j2NU2023-02-06 11:08 AM
Updated 2023-02-06
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
›
⌄
SELECT
date_trunc('month', block_timestamp) AS time
, nft_address
, project_name
, SUM(price) AS vol_eth
, SUM(creator_fee) AS CE_eth
FROM ethereum.core.ez_nft_sales
WHERE true
AND block_timestamp BETWEEN '2022-01-01' AND '2023-01-01'
-- AND nft_address = '0x059edd72cd353df5106d2b9cc5ab83a52287ac3a'
-- AND tokenid >= 0 AND tokenid <= 1000000 -- Squiggles
-- AND nft_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'
-- -- AND tokenid BETWEEN 78000000 AND 79000000 -- Fidenzas
-- -- AND tokenid BETWEEN 215000000 AND 216000000 -- Gazers
-- AND tokenid BETWEEN 189000000 AND 190000000 -- CryptoNewYorkers
AND nft_address IN (
-- '0xd0a07a76746707f6d6d36d9d5897b14a8e9ed493' -- PVFD
-- '0xc36cf0cfcb5d905b8b513860db0cfe63f6cf9f5c' --Legends Reborn
-- ,'0x57a204aa1042f6e66dd7730813f4024114d74f37' --CyberKongz (Babies)
-- , '0x4d928fada59f3446627c5bea707a81e006cf676f' --VeeCon Tickets
-- , '0xbb869f884186c3cba0ffa89ab84980cb86f8744d' --Queens+Kings LAB by Hackatao
-- , '0x7df64f69544c5bf71171dc5ab69b8602c2ff1e27' --Kitaro World Official
-- , '0x13927739076014913a3a7c207ef84c5be4780014' --VeeFriends Gift Goat x Pop Wonder: The Gift Within The Goat
-- , '0x80336ad7a747236ef41f47ed2c7641828a480baa' --Chimpers
-- , '0x7f36182dee28c45de6072a34d29855bae76dbe2f' --Wolf Game
-- , '0x75e95ba5997eb235f40ecf8347cdb11f18ff640b' --Psychedelics Anonymous Genesis
-- , '0x7bd29408f11d2bfc23c34f18275bbf23bb716bc7' --Meebits
-- , '0x509a050f573be0d5e01a73c3726e17161729558b' --Where My Vans Go
-- , '0xd0fabbba5fd95411a07bb2fdcf31295639376937' --Cel Mates Crime Reports
-- , '0xba30e5f9bb24caa003e9f2f0497ad287fdf95623' --Bored Ape Kennel Club
-- , '0xc73b17179bf0c59cd5860bb25247d1d1092c1088' --QQL Mint Pass
)
AND currency_symbol IN ('ETH', 'WETH')
Run a query to Download Data