NakedCollector2023-10-23 03:16 PM copy
999
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
›
⌄
-- forked from 2023-10-23 03:16 PM @ https://flipsidecrypto.xyz/edit/queries/7ed6e096-0f0a-4687-8d07-c9ca8756fe65
-- Find the earliest and latest sale transactions for each NFT project by address
WITH EarliestAndLatestDates AS (
SELECT
nft_address,
project_name,
MIN(DATE(block_timestamp)) AS earliest_date,
MAX(DATE(block_timestamp)) AS latest_date
FROM
ETHEREUM.core.ez_nft_sales
WHERE
event_type IN ('sale', 'bid_won')
and nft_address in(
'0x28472a58a490c5e09a238847f66a68a47cc76f0f',
'0x455c732fee7b5c3b09531439b598ead4817d5274',
'0xba0c9cf4da821dba98407cc4f9c11f6c7a5f9bbc',
'0xd71b53fe1df51075c5a965956cdc87421c2ffed7',
'0x68f4ba8018216542ac2ab8125166be66304dd71c',
'0x57c4d987431a4582a5e3ce9a3a9a5f1e9f55757c',
'0xeb6c5accafd8515c1b9e4c794bdc41532c5543ec',
'0x4bd77619a75c8eda181e3587339e7011da75bf0e',
'0x5d26060847445efb92c6f03d1382bcdd07b67280',
'0xc216f9db5fe192406652b43ca7bbb969ecfd573e',
'0xcd041f40d497038e2da65988b7d7e2c0d9244619',
'0xd4190dd1da460fc7bc41a792e688604778820ac9',
'0x0e220a4f3957c17a2e780922dbc13cb2c9aa4274',
'0x78d61c684a992b0289bbfe58aaa2659f667907f8',
'0xc3ae6e60a37a5f7d6d68e60c45b1ae50da233bd4',
'0x572e33ffa523865791ab1c26b42a86ac244df784',
'0xe8f88d16f24255fcfab25959705d724406d67d9d',
'0xcd1f6be81f1dc58558f44bbc5ca4cc43cbb1ec05',
'0x283c0bba69ebd4643cfce761b34b0206e75b2091',
'0x76cf1fc9fcdabcb3a3c01409529eb1ba59b93add',
--NIKE
'0x86825dfca7a6224cfbd2da48e85df2fc3aa7c4b1',
Run a query to Download Data