saeedmzn[Pac Finance] transactions over time
    Updated 2024-09-07
    with eth_transfers as (
    select
    ORIGIN_FROM_ADDRESS wallet,
    TRACE_INDEX EVENT_INDEX ,
    'ETH' symbol ,
    AMOUNT,
    AMOUNT_USD,
    BLOCK_TIMESTAMP,
    TX_HASH ,
    from_address,
    TO_ADDRESS
    from blast.core.ez_native_transfers
    where ORIGIN_TO_ADDRESS = '0xfde98ab7a6602ad55462297d952ce25b58743140'
    ),
    token_transfers as (
    select ORIGIN_FROM_ADDRESS wallet,
    EVENT_INDEX ,
    SYMBOL,
    AMOUNT,
    AMOUNT_USD,
    BLOCK_TIMESTAMP,
    TX_HASH,
    from_address,
    TO_ADDRESS
    from blast.core.ez_token_transfers
    where ORIGIN_TO_ADDRESS = '0xfde98ab7a6602ad55462297d952ce25b58743140'
    ),
    all_transfers as (
    select * from eth_transfers
    UNION
    select * from token_transfers
    ),
    leverage_deposit_tx as (
    select DISTINCT tx_hash ,
    'LeverageDeposit' type
    from blast.core.ez_decoded_event_logs
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived