flipside

    Q1
    ArioQ1
    Updated 2025-01-29
    with claim_TXs as (
    select
    block_timestamp,
    tx_id,
    tx_to,
    amount
    from solana.core.fact_transfers
    where tx_from = '3HA76bpwHuST6Uo9BouJ4A5GpAiDuerr7QBenUqbXZAL'
    and mint = '2zMMhcVQEXDtdE6vsFS7S7D5oUodfJHE8vd1gnBouauv'
    )
    select
    date_trunc(hour, block_timestamp) as date,
    CONVERT_TIMEZONE('UTC', 'America/New_York', date) as hour,
    sum(amount) as "Claimed $PENGU",
    sum("Claimed $PENGU") over(order by date) as "Cum. Claimed $PENGU",
    count(distinct tx_to) as "# Claimers",
    sum("# Claimers") over(order by date) as "Cum. # Claimers"
    from claim_txs
    where CONVERT_TIMEZONE('UTC', 'America/New_York', block_timestamp) >= '2024-12-17 08:00:00.000'
    group by 1
    order by hour desc
    Last run: 2 months ago
    DATE
    HOUR
    Claimed $PENGU
    Cum. Claimed $PENGU
    # Claimers
    Cum. # Claimers
    1
    		2025-01-29 19:00:00.0002025-01-29 14:00:00.0001145732679002731541375150
    2
    		2025-01-29 18:00:00.0002025-01-29 13:00:00.00046394426789912742401375146
    3
    		2025-01-29 17:00:00.0002025-01-29 12:00:00.0009417026789448798411375106
    4
    		2025-01-29 16:00:00.0002025-01-29 11:00:00.00037123826789354628451375065
    5
    		2025-01-29 15:00:00.0002025-01-29 10:00:00.00012754526788983390351375020
    6
    		2025-01-29 14:00:00.0002025-01-29 09:00:00.00010535126788855845311374985
    7
    		2025-01-29 13:00:00.0002025-01-29 08:00:00.00024301126788750494321374954
    8
    		2025-01-29 12:00:00.0002025-01-29 07:00:00.0009114626788507483461374922
    9
    		2025-01-29 11:00:00.0002025-01-29 06:00:00.00035198826788416337661374876
    10
    		2025-01-29 10:00:00.0002025-01-29 05:00:00.00027219426788064349441374810
    11
    		2025-01-29 09:00:00.0002025-01-29 04:00:00.00036236626787792155481374766
    12
    		2025-01-29 08:00:00.0002025-01-29 03:00:00.00015808526787429789331374718
    13
    		2025-01-29 07:00:00.0002025-01-29 02:00:00.0008922126787271704211374685
    14
    		2025-01-29 06:00:00.0002025-01-29 01:00:00.00029475826787182483361374664
    15
    		2025-01-29 05:00:00.0002025-01-29 00:00:00.00098003926786887725291374628
    16
    		2025-01-29 04:00:00.0002025-01-28 23:00:00.000361313026785907686441374599
    17
    		2025-01-29 03:00:00.0002025-01-28 22:00:00.0001502264826782294556661374555
    18
    		2025-01-29 02:00:00.0002025-01-28 21:00:00.00029570526767271908381374489
    19
    		2025-01-29 01:00:00.0002025-01-28 20:00:00.000271314426766976203251374451
    20
    		2025-01-29 00:00:00.0002025-01-28 19:00:00.000191009826764263059401374426
    ...
    1038
    87KB
    126s