freemartianHourly mints
    Updated 2025-04-21
    with temp1 AS(
    SELECT
    *
    FROM eclipse.core.fact_events_inner

    WHERE instruction_PROGRAM_ID = 'RariUNM3vz1rwxPg8UJyRAN7rSKXxgd2ncS2ddCa4ZE'
    AND instruction:parsed:info:destination = '25EdY4Q6ejAT5FRuK71pjvxitq88vQwcggEHbUnrEYvx'
    AND block_timestamp::date >= '2025-01-01'
    ),
    temp2 as(
    SELECT
    *
    FROM eclipse.core.fact_events_inner
    WHERE instruction_PROGRAM_ID = 'RariUNM3vz1rwxPg8UJyRAN7rSKXxgd2ncS2ddCa4ZE'
    AND instruction:parsed:info:destination = 'AsSKqK7CkxFUf3KaoQzzr8ZLPm5fFguUtVE5QwGALQQn'
    AND block_timestamp::date >= '2025-01-01'

    ),

    all_temps AS(
    SELECT temp1.*
    FROM temp1
    left JOIN temp2 on (temp1.tx_id = temp2.tx_id)
    ),
    all_minters AS(
    SELECT
    block_timestamp, tx_id, signers[0] as minter,
    FROM eclipse.core.fact_events_inner
    WHERE event_type = 'mintTo'
    AND INSTRUCTION:program = 'spl-token'
    AND block_timestamp::date >= '2025-01-01'
    AND tx_id IN (SELECT tx_id FROM all_temps)
    )

    SELECT
    date_trunc('hour',block_timestamp) AS time,
    Last run: 14 days agoAuto-refreshes every 1 hour
    TIME
    MINTS
    MINTERS
    ETH_MINT_PRICES
    1
    2025-01-19 01:00:00.000650.0039
    2
    2025-01-17 06:00:00.00045430.02925
    3
    2025-01-23 08:00:00.00021210.01365
    4
    2025-01-17 04:00:00.00025250.01625
    5
    2025-01-20 23:00:00.00027260.01755
    6
    2025-01-17 14:00:00.00022220.0143
    7
    2025-01-17 03:00:00.00029270.01885
    8
    2025-01-20 04:00:00.000220.0013
    9
    2025-01-16 16:00:00.0001781570.1157
    10
    2025-01-16 14:00:00.0001771420.11505
    11
    2025-01-17 12:00:00.00025250.01625
    12
    2025-01-23 10:00:00.00023220.01495
    13
    2025-01-21 10:00:00.00023230.01495
    14
    2025-01-21 16:00:00.00019170.01235
    15
    2025-01-23 02:00:00.000660.0039
    16
    2025-01-22 11:00:00.000750.00455
    17
    2025-01-19 10:00:00.0001090.0065
    18
    2025-01-18 09:00:00.00022220.0143
    19
    2025-01-21 08:00:00.00043380.02795
    20
    2025-01-18 23:00:00.00014140.0091
    ...
    168
    7KB
    10s