flipside

    arbitreum
    drone-mostafaarbitreum
    Updated 2022-07-19
    select TX_HASH ,BLOCK_TIMESTAMP
    from arbitrum.core.fact_transactions
    -- where TO_ADDRESS = '0x1111111254fb6c44bac0bed2854e76f90643097d' -- 1inch
    where TO_ADDRESS = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' -- AAVE
    -- and ORIGIN_FUNCTION_SIGNATURE = '0x7c025200' -- 1inch
    and ORIGIN_FUNCTION_SIGNATURE = '0x095ea7b3' -- AAVE
    and STATUS = 'SUCCESS'
    and BLOCK_TIMESTAMP >= CURRENT_DATE -2 order by BLOCK_TIMESTAMP DESC
    Run a query to Download Data