Untitled Query copy

mmichalsUntitled Query copy

Updated 2023-11-09

-- forked from 0x8845975A133043F7e3deEFdb554FABA624Ff693F / Untitled Query @ https://flipsidecrypto.xyz/0x8845975A133043F7e3deEFdb554FABA624Ff693F/q/zs5LyI6nYzy2/untitled-query

-- select * from arbitrum.core.fact_transactions WHERE to_address like '0xb87a436b93ffe9d75c5cfa7bacfff96430b09868' and block_timestamp > '2023-11-07 00:00:00.000'

--and BLOCK_TIMESTAMP > '2023-06-02 22:00:00'

--and from_address like '%a83c'

--BLOCK_TIMESTAMP = '2022-12-21 23:38:15'

--arbitrum.core.fact_transactions

--FROM_ADDRESS LIKE '0xe7a1%'

--polygon.core.fact_transactions

-- select * from arbitrum.core.fact_transactions WHERE from_address like '0x65b1b%' and block_timestamp > '2023-11-07 00:00:00.000'

--0x93661a79fb85c4721410c87611b2e2474887232910e511ea57e545e81f99145e - transaction

--0x65b1b96bd01926d3d60dd3c8bc452f22819443a9 - adres

SELECT *

from arbitrum.core.fact_transactions

WHERE block_timestamp > '2023-11-08 19:46:00.000'

and block_timestamp < '2023-11-08 19:48:00.000'

and status = 'SUCCESS'

--GROUP BY 1

--ORDER BY 2

select * from arbitrum.core.fact_decoded_event_logs

WHERE tx_hash = '0xdf611729e8bf6d7138cbe136c9451d7ba337b21f8edb4e2e39793c88d5299172'

Run a query to Download Data