for Daily comparison of hashes

lidofor Daily comparison of hashes

Updated 2025-02-11

SELECT *

-- DISTINCT tx_hash, sum(VALUE) as value

FROM ethereum.core.fact_traces

where (FROM_ADDRESS in (

'0xae7ab96520de3a18e5e111b5eaab095312d7fe84', -- stETH

'0xb9d7934878b5fb9610b3fe8a5e441e8fad7e293f',-- withdrawal vault

'0x388c818ca8b9251b393131c08a736a67ccb19297'

)

or TO_ADDRESS in (

'0xae7ab96520de3a18e5e111b5eaab095312d7fe84', -- stETH

'0xb9d7934878b5fb9610b3fe8a5e441e8fad7e293f',-- withdrawal vault

'0x388c818ca8b9251b393131c08a736a67ccb19297'

))

and TYPE = 'CALL'

and BLOCK_TIMESTAMP:: date = '2024-12-20' -- change here

-- and TX_STATUS = 'SUCCESS'

AND TRACE_STATUS = 'SUCCESS'

AND VALUE != 0

-- GROUP BY 1

QueryRunArchived: QueryRun has been archived

flipside