saadiqToken IDs traded
Updated 2023-03-01
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
›
⌄
SELECT
project_name,
left(block_timestamp, 7) as month,
min(block_timestamp),
count(DISTINCT tokenid) as count
FROM
ethereum.core.ez_nft_sales
WHERE
nft_address IN (
'0x23581767a106ae21c074b2276d25e5c3e136a68b',
'0x8a90cab2b38dba80c64b7734e58ee1db38b8992e',
'0xed5af388653567af2f388e6224dc7c4b3241c544',
'0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d',
'0xbd3531da5cf5857e7cfaa92426877b022e612cf8',
'0x1a92f7381b9f03921564a437210bb9396471050c',
'0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b'
)
and month >= '2022-06'
and month < left(CURRENT_DATE, 7)
GROUP BY
nft_address,
project_name,
month
order by
month desc;
-- Moonbirds: 0x23581767a106ae21c074b2276d25e5c3e136a68b
-- Doodles: 0x8a90cab2b38dba80c64b7734e58ee1db38b8992e
-- BAYC: 0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d
-- Azukis: 0xed5af388653567af2f388e6224dc7c4b3241c544
-- CloneX: 0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b
-- Pudgies: 0xbd3531da5cf5857e7cfaa92426877b022e612cf8
-- Cool Cats: 0x1a92f7381b9f03921564a437210bb9396471050c
Run a query to Download Data