geminilightdaily_
Updated 2023-04-19
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
›
⌄
-- WITH active_wallets AS (
-- SELECT DISTINCT nft_from_address AS wallet, DATE_TRUNC('day', block_timestamp) AS date
-- FROM ethereum.core.ez_nft_mints
-- UNION ALL
-- SELECT DISTINCT nft_to_address AS wallet, DATE_TRUNC('day', block_timestamp) AS date
-- FROM ethereum.core.ez_nft_mints
-- UNION ALL
-- SELECT DISTINCT nft_from_address AS wallet, DATE_TRUNC('day', block_timestamp) AS date
-- FROM ethereum.core.ez_nft_transfers
-- UNION ALL
-- SELECT DISTINCT nft_to_address AS wallet, DATE_TRUNC('day', block_timestamp) AS date
-- FROM ethereum.core.ez_nft_transfers
-- )
-- , date_range AS (
-- SELECT DISTINCT DATE_TRUNC('day', block_timestamp) AS date
-- FROM ethereum.core.ez_nft_sales
-- WHERE block_timestamp >= '2017-01-01'
-- AND block_timestamp <= CURRENT_TIMESTAMP
-- )
-- SELECT d.date, COUNT(DISTINCT a.wallet) AS num_active_wallets
-- FROM date_range d
-- LEFT JOIN active_wallets a ON d.date = a.date
-- GROUP BY d.date
-- ORDER BY d.date
WITH
active_wallets AS (
SELECT DISTINCT
nft_from_address AS wallet
FROM
ez_nft_sales
WHERE
date <= current_date() AND date >= dateadd(day, -30, current_date())
UNION
SELECT DISTINCT
Run a query to Download Data