Updated 2022-08-08Copy Reference Fork
9
1
2
3
4
5
6
›
⌄
select sum(eth_value) as total_uniswap_total_vol from optimism.core.fact_event_logs a
join optimism.core.fact_transactions b on a.tx_hash = b.tx_hash
where a.tx_status = 'SUCCESS'
and a.ORIGIN_TO_ADDRESS = lower ('0xE592427A0AEce92De3Edee1F18E0157C05861564')
and a.block_timestamp::date >= '2022-07-01' and a.block_timestamp::date <= '2022-07-31'
and a.ORIGIN_FUNCTION_SIGNATURE = '0x414bf389'
Run a query to Download Data