Hessishwct - imp1
    Updated 2024-12-25
    with claims as
    (select
    BLOCK_TIMESTAMP,
    AMOUNT,
    TO_ADDRESS,
    TX_HASH
    from optimism.core.ez_token_transfers
    where
    BLOCK_NUMBER >= 128519313 and
    ORIGIN_FUNCTION_SIGNATURE = '0xb69d1a08'
    and CONTRACT_ADDRESS = '0xef4461891dfb3ac8572ccf7c794664a8dd927945'
    and ORIGIN_TO_ADDRESS = '0x4ee97a759aaca2edf9c1445223b6cd17c2ed3fb4'
    and FROM_ADDRESS = '0xa86ca428512d0a18828898d2e656e9eb1b6ba6e7')

    select
    date_trunc('day',block_timestamp) as time,
    count(DISTINCT tx_hash) as txs,
    '$WCT claims' as type
    from claims
    GROUP by all


    union

    select
    date_trunc('day',block_timestamp) as time,
    count(DISTINCT tx_hash) as txs,
    'Other txs' as type
    from optimism.core.fact_transactions
    where
    BLOCK_NUMBER >= 128519313
    and
    tx_hash not in (SELECT DISTINCT TX_HASH from claims)
    GROUP by all


    Last run: about 2 months ago
    TIME
    TXS
    TYPE
    1
    2024-12-22 00:00:00.000304$WCT claims
    2
    2024-12-03 00:00:00.0001083318Other txs
    3
    2024-12-18 00:00:00.000540$WCT claims
    4
    2024-12-01 00:00:00.0002060$WCT claims
    5
    2024-12-10 00:00:00.000470$WCT claims
    6
    2024-11-26 00:00:00.000310247Other txs
    7
    2024-12-23 00:00:00.0001104266Other txs
    8
    2024-12-11 00:00:00.000315$WCT claims
    9
    2024-12-02 00:00:00.0001391$WCT claims
    10
    2024-12-05 00:00:00.0001018583Other txs
    11
    2024-12-17 00:00:00.0001136949Other txs
    12
    2024-12-09 00:00:00.000520$WCT claims
    13
    2024-12-19 00:00:00.0001169992Other txs
    14
    2024-12-21 00:00:00.0001199039Other txs
    15
    2024-12-08 00:00:00.000555$WCT claims
    16
    2024-12-20 00:00:00.0001138237Other txs
    17
    2024-12-24 00:00:00.0001026771Other txs
    18
    2024-12-10 00:00:00.0001158271Other txs
    19
    2024-12-23 00:00:00.000216$WCT claims
    20
    2024-11-30 00:00:00.000990414Other txs
    60
    3KB
    9s