--select count(distinct tx_hash) from ethereum.aave.ez_flashloans
select * from ethereum.aave.ez_flashloans
where
tx_hash not in (select distinct tx_hash from ethereum.core.ez_dex_swaps where year(block_timestamp)=2021)
--tx_hash in (select distinct tx_hash from ethereum.core.fact_event_logs where ORIGIN_FUNCTION_SIGNATURE in ('0xe8e33700', '0xf305d719', '0xded9382a', '0x2195995c', '0x02751cec', '0xbaa2abde', '0x5b0d5984', '0xaf2979eb') and year(block_timestamp)=2021)
and
year(block_timestamp) = 2021