shreex2023-07-03 12:57 PM
    Updated 2023-07-03
    select
    origin_from_address as address,
    (event_inputs:amount0/pow(10,18)) as amount,
    event_inputs,
    tx_hash
    from
    arbitrum.core.fact_event_logs
    where
    contract_address='0xaebdca1bc8d89177ebe2308d62af5e74885dccc3' and block_timestamp >= '2023-01-01'
    order by 2 desc

    LIMIT 100