nickpCoral
    Updated 2024-12-05


    -- spoke address 0xA4cE01bD7Dd91DA968a7C4A8D04282a3f5eA06bB

    with base_from_transactions as(
    select topics[0], * from base.core.fact_event_logs
    where tx_hash = lower('0x8648100c3438f828e8725379440037f188e83af9af37556b10d13c5d36d36f01')
    ANd block_timestamp::date > '2024-11-01'
    and contract_address = lower('0xA4cE01bD7Dd91DA968a7C4A8D04282a3f5eA06bB')
    and topics[0] = '0x181de28643611afcf1cb4c095a1ef99c157e78437294f478c978e4a56e1ca77e'
    )

    select tt.block_timestamp::date, tt.tx_hash, tt.origin_from_address as from_address, tt.symbol, tt.amount_usd, 'base' as chain
    from base.core.ez_token_transfers tt
    inner join base_from_transactions bt on bt.tx_hash = tt.tx_hash and bt.contract_address = tt.to_address
    where
    tt.block_timestamp::date > '2024-11-01'
    and tt.to_address = '0xa4ce01bd7dd91da968a7c4a8d04282a3f5ea06bb'

    Last run: 30 days ago
    TT.BLOCK_TIMESTAMP::DATE
    TX_HASH
    FROM_ADDRESS
    SYMBOL
    AMOUNT_USD
    CHAIN
    1
    2024-12-04 00:00:00.0000x8648100c3438f828e8725379440037f188e83af9af37556b10d13c5d36d36f010x9c1931a1b1aa6363f681720499d082a545867b62USDC144.537404814base
    1
    171B
    7s