0xGembusQuiz 4
Updated 2022-12-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- SELECT ethereum.public.udf_hex_to_int(substr(data,3,10))
-- FROM ethereum.core.fact_event_logs
-- WHERE block_timestamp::date = '2022-08-24'
-- AND tx_hash = '0x56cf02194da2afc277ab20852a4287890f7ea8d8c42691fe0b2e0f5a5aa273c3'
-- AND topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
-- 82476460109
select sum(eth_value) from ethereum.core.fact_traces
where tx_hash='0x81d4b35b512ee5239bc071d6270ef1245bb6e4d2c606ccc1f35a77bd303ff4a3'
and eth_value >0
and identifier !='CALL_ORIGIN'
and to_address ='0x148ef557738b8bc51bd19ee1365d9d04bd46ab04'
Run a query to Download Data