fb3ce38c-7bfe-475c-bca8-3f1e44ae80a62023-09-26 04:41 PM copy copy
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
›
⌄
-- forked from 2023-09-26 04:41 PM copy @ https://flipsidecrypto.xyz/edit/queries/809c0612-0f94-47b9-b2cc-acaaa0f6a6d9
SELECT
COUNT(from_address)Total_transactions,
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
FROM polygon.core.fact_transactions
WHERE FROM_ADDRESS ='0x610123c1f5e34974c63343c84973cd5603b08e7c'
AND pack_drop <> 'other'
GROUP BY contract,pack_drop
LIMIT 100
Run a query to Download Data