rezarwz# of packs in each category
    Updated 2024-12-27
    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
    DATE
    CATEGORY
    # of cards
    1
    2024-05-02 00:00:00.000Floating price6585
    2
    2024-07-20 00:00:00.000FREE102
    3
    2024-08-17 00:00:00.000Floating price65
    4
    2024-11-02 00:00:00.000FREE67
    5
    2024-11-29 00:00:00.000FREE2021
    6
    2024-05-07 00:00:00.0000.033 ETH3905
    7
    2024-05-07 00:00:00.000FREE565
    8
    2024-07-05 00:00:00.000Floating price5
    9
    2024-09-19 00:00:00.000FREE6883
    10
    2024-09-22 00:00:00.000Floating price180
    11
    2024-10-04 00:00:00.000Floating price2500
    12
    2024-07-16 00:00:00.000FREE32
    13
    2024-05-26 00:00:00.000Floating price55
    14
    2024-08-31 00:00:00.000Floating price535
    15
    2024-09-20 00:00:00.000FREE672
    16
    2024-10-27 00:00:00.000FREE42
    17
    2024-11-04 00:00:00.000Floating price10
    18
    2024-05-01 00:00:00.0000.033 ETH58100
    19
    2024-06-20 00:00:00.000FREE745
    20
    2024-09-22 00:00:00.000FREE95
    ...
    469
    20KB
    10s