flipside

    Daily Transactions by Event (Mint, Burn)
    SniperDaily Transactions by Event (Mint, Burn)
    Updated 2025-04-18
    select
    trunc(BLOCK_TIMESTAMP::date,'day') as daily,
    case
    when EVENT_NAME = 'RodMintedBatch' then 'Rod Minted'
    when EVENT_NAME = 'ChestMintedBatch' then 'Chest Minted'
    when EVENT_NAME = 'ChestBurned' then 'Chest Burned'
    when EVENT_NAME = 'FishBurnedBatch' then 'Fish Burned'
    when EVENT_NAME = 'FishMintedBatch' then 'Fish Minted'
    -- else 'other'
    end as "event",
    -- EVENT_NAME,
    count(DISTINCT tx_hash ) as Transactions,
    from ronin.core.ez_decoded_event_logs where
    CONTRACT_ADDRESS in (
    '0x4079da822e8972982b8569e38cdf719a21069934',--fish
    '0x9c76fc5bd894e7f51c422f072675c876d5998a9e',--chests
    '0x77ce5148b7ad284e431175ad7258b54a64816da6'--rods
    -- '0x3fa1e076bd4e7f4b7469ad1646332c09b275082d'-- Fishing Frenzy Founders Pass
    )
    and TX_SUCCEEDED='TRUE'
    and BLOCK_TIMESTAMP::date>= '2025-03-21'
    --and EVENT_NAME not in ('TokensMintedWithSignature','Transfer','OwnershipTransferred','RoleGranted','ChestTierUpdated','DefaultRoyaltySet','RoleRevoked')
    and EVENT_NAME in ('RodMintedBatch','ChestMintedBatch','FishBurnedBatch','FishMintedBatch','ChestBurned')
    group by 1,2
    Last run: 11 days ago
    DAILY
    event
    TRANSACTIONS
    1
    		2025-03-21 00:00:00.000Rod Minted4586
    2
    		2025-04-12 00:00:00.000Rod Minted1098
    3
    		2025-03-22 00:00:00.000Fish Burned133
    4
    		2025-03-21 00:00:00.000Fish Minted145
    5
    		2025-04-02 00:00:00.000Chest Minted6
    6
    		2025-04-04 00:00:00.000Chest Minted8
    7
    		2025-04-02 00:00:00.000Rod Minted1
    8
    		2025-04-13 00:00:00.000Chest Burned882
    9
    		2025-03-22 00:00:00.000Rod Minted1619
    10
    		2025-04-09 00:00:00.000Chest Burned3362
    11
    		2025-04-08 00:00:00.000Fish Minted5
    12
    		2025-04-03 00:00:00.000Chest Minted12
    13
    		2025-04-08 00:00:00.000Chest Burned14
    14
    		2025-03-25 00:00:00.000Rod Minted5400
    15
    		2025-04-15 00:00:00.000Chest Minted317
    16
    		2025-03-26 00:00:00.000Chest Minted40
    17
    		2025-03-24 00:00:00.000Rod Minted2657
    18
    		2025-04-04 00:00:00.000Chest Burned3
    19
    		2025-04-15 00:00:00.000Rod Minted882
    20
    		2025-04-09 00:00:00.000Chest Minted3335
    97
    4KB
    4s