DATE | CATEGORY | # of cards | |
---|---|---|---|
1 | 2024-05-02 00:00:00.000 | Floating price | 6585 |
2 | 2024-07-20 00:00:00.000 | FREE | 102 |
3 | 2024-08-17 00:00:00.000 | Floating price | 65 |
4 | 2024-11-02 00:00:00.000 | FREE | 67 |
5 | 2024-11-29 00:00:00.000 | FREE | 2021 |
6 | 2024-05-07 00:00:00.000 | 0.033 ETH | 3905 |
7 | 2024-05-07 00:00:00.000 | FREE | 565 |
8 | 2024-07-05 00:00:00.000 | Floating price | 5 |
9 | 2024-09-19 00:00:00.000 | FREE | 6883 |
10 | 2024-09-22 00:00:00.000 | Floating price | 180 |
11 | 2024-10-04 00:00:00.000 | Floating price | 2500 |
12 | 2024-07-16 00:00:00.000 | FREE | 32 |
13 | 2024-05-26 00:00:00.000 | Floating price | 55 |
14 | 2024-08-31 00:00:00.000 | Floating price | 535 |
15 | 2024-09-20 00:00:00.000 | FREE | 672 |
16 | 2024-10-27 00:00:00.000 | FREE | 42 |
17 | 2024-11-04 00:00:00.000 | Floating price | 10 |
18 | 2024-05-01 00:00:00.000 | 0.033 ETH | 58100 |
19 | 2024-06-20 00:00:00.000 | FREE | 745 |
20 | 2024-09-22 00:00:00.000 | FREE | 95 |
rezarwz# of packs in each category
Updated 2024-12-27
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 Total_mints as (
SELECT
ORIGIN_FROM_ADDRESS as ua,
block_timestamp,
TX_HASH,
DECODED_LOG: price / pow(10, 18) as pack_price,
DECODED_LOG: firstTokenId as firstTokenId,
DECODED_LOG: lastTokenId as lastTokenId,
DECODED_LOG: lastTokenId - DECODED_LOG: firstTokenId + 1 as total_card
FROM
blast.core.ez_decoded_event_logs
where
CONTRACT_ADDRESS = '0x86b58ca576c24f79ad1e5459aee01d40bea22828'
and EVENT_NAME = 'Mint'
),
LVL_UPS AS (
SELECT
ORIGIN_FROM_ADDRESS as ua,
block_timestamp,
TX_HASH,
value as burned_token_id,
DECODED_LOG: mintedTokenId as mintedTokenId
FROM
blast.core.ez_decoded_event_logs,
LATERAL FLATTEN(input => DECODED_LOG:burntTokenIds) f
WHERE
CONTRACT_ADDRESS = '0x86b58ca576c24f79ad1e5459aee01d40bea22828'
and EVENT_NAME = 'LevelUp'
),
lvl_up_r as(
SELECT
ua,
tx_hash,
block_timestamp,
count(DISTINCT burned_token_id) as burned_count,
count(DISTINCT mintedTokenId) as minted_count
Last run: 25 days ago
...
469
20KB
10s