dexes_contracts.sql

select *
from `bigquery-public-data.crypto_ethereum.logs`
where (address in ('0x39755357759ce0d7f32dc8dc45414cca409ae24e', '0x794e6e91555438afc3ccf1c5076a74f42133d08d', '0x8fd3121013a07c57f0d69646e86e7a4880b467b7', '0x4572f2554421bd64bef1c22c8a81840e8d496bea', '0x4aea7cf559f67cedcad07e12ae6bc00f07e8cf65', '0x8d12a197cb00d4747a1fe03395095ce2a5cc6819', '0x818e6fecd516ecc3849daf6845e3ec868087b755', '0x12459c951127e0c374ff9105dda097662a027093', '0x4f833a24e1f95d70f028921e27040ca56e09ab0b', '0x080bf510fcbf18b91105470639e9561022937712', '0x61935cbdd02287b511119ddb11aeb42f1593b7ef', '0x79a8c46dea5ada233abaffd40f3a0a2b1e5a4f27', '0x79a8c46dea5ada233abaffd40f3a0a2b1e5a4f27', '0xa2b47e3d5c44877cca798226b7b8118f9bfb7a56', '0xa2b47e3d5c44877cca798226b7b8118f9bfb7a56', '0x06364f10b501e868329afbc005b3492902d6c763', '0x06364f10b501e868329afbc005b3492902d6c763', '0x93054188d876f558f4a66b2ef1d97d16edf0895b', '0x7fc77b5c7614e1533320ea6ddc2eb61fa00a9714', '0xa5407eae9ba41422680e2e00537571bcc53efbfd', '0xa5407eae9ba41422680e2e00537571bcc53efbfd', '0x52ea46506b9cc5ef470c5bf89f17dc28bb35d85c', '0x52ea46506b9cc5ef470c5bf89f17dc28bb35d85c', '0x45f783cce6b7ff23b2ab2d70e416cdb7d6055f51', '0x45f783cce6b7ff23b2ab2d70e416cdb7d6055f51', '0x11111254369792b2ca5d084ab5eea397ca8fa48b',
'0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f') or 
topics[SAFE_OFFSET(0)] in ('0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822', '0x908fb5ee8f16c6bc9bc3690973819f32a4d4b10188134543c88706e0e1d43378', '0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822', '0x86c49b5d8577da08444947f1427d23ef191cfabf2c0788f93324d79e926a9302')
)
and date(block_timestamp) = '2020-10-23'