fb3ce38c-7bfe-475c-bca8-3f1e44ae80a62023-09-26 04:41 PM copy
Updated 2023-10-02
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
›
⌄
SELECT
COUNT(from_address)total_moments_minted,
To_address AS contract,
CASE WHEN LOWER(TO_ADDRESS) ='0xca28251acf27e55fdbfbf997397a28db122e70b2'
THEN 'Base (BRKWY)'
WHEN LOWER(TO_ADDRESS) ='0x88f685878261a3c29e6015e1560c01aa148e1d5b'
THEN 'Base 2022-23 Expansion Pack (BRKWY)'
WHEN LOWER(TO_ADDRESS)='0x78cda9b5fa2b74274c83747083f319c14584b53b'
THEN 'Preseason Starter Pack (BRKWY)'
WHEN LOWER(TO_ADDRESS)='0xabae4022c87bc74f4b2c525f52710fbd5822160f'
THEN 'The Hunt for Stanley 2023 Debut LE (BRKWY)'
WHEN LOWER(TO_ADDRESS)='0xa6536e1947e3c8317c2b13f7692936d52783e1a4'
THEN 'Inaugural Founding Fan Base Pack (BRKWY)'
ELSE 'other'
END AS pack_drop,
DATE_TRUNC('hour', block_timestamp) AS date
FROM polygon.core.fact_transactions
WHERE FROM_ADDRESS ='0x610123c1f5e34974c63343c84973cd5603b08e7c'
AND pack_drop <> 'other'
GROUP BY contract,pack_drop,date
Run a query to Download Data