algo_ahab-4V8aSZzkml copy
Updated 2024-07-26
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH address_list AS (
SELECT '0x17b153aa3abe80655b558e52e478f0b3968bff16' AS address UNION ALL SELECT '0x5d48ae24e96ca893e7de05a277d6a90c35588e5f' UNION ALL SELECT '0xf404806324dec457a0c5a8fb49302c8707b48386' UNION ALL SELECT '0x099206266a54d4d7a41fb5eb5b687ebf7ac153b6' UNION ALL SELECT '0x8f1ef2c70a61cae8dd54d25be7b44c2e581c6b33' UNION ALL SELECT '0x12b42bcbf7d017e6fc811896ac35546f7c00a3bd' UNION ALL SELECT '0xe2defbbd57b9a81ff9dee266e45492348fc8b2f8' UNION ALL SELECT '0xb08a93741a2f4f3897f2d9db6caf0f6212c7a5d4' UNION ALL SELECT '0xca95b7f44c35dbedf586ae05f165779eea23db36' UNION ALL SELECT '0xf820502be44549169a4bc136afafd714d1d25708' UNION ALL SELECT '0x3dc12115d9d30be692a169ae75deada74eeacd69' UNION ALL SELECT '0xfdfb48a407d436530e2732df52d39c9c63995e42' UNION ALL SELECT '0x7e87c3ea18097bb096f9d7a1a5cf4521207c0fa6' UNION ALL SELECT '0xdfc3653588183f0d5c79a42776830106486b8a34' UNION ALL SELECT '0xd0d50bd6933668d962f8b601b155a5a6a2d2d178' UNION ALL SELECT '0xb9f1a414cd3e820968fd51840b26cc149a4f24bd' UNION ALL SELECT '0x90875d559db224225ac6d63507fa7b370b70dd26' UNION ALL SELECT '0x278ad2617a315a184dec06b7d57d9fa84034cadb' UNION ALL SELECT '0xa43b3a7fc3be6fea9c605f7cedc73d4d8f928e4b' UNION ALL SELECT '0x5acf811f58ae94c8a049fc977cfa4949e43d5264' UNION ALL SELECT '0xe6dd0608f6f9bf589470a7be991e25e3d76e62ee' UNION ALL SELECT '0xe156e01502fda3a467e713f3b49ce72c726d06af' UNION ALL SELECT '0x1531b0467896ade3b46a111999da55a83922c7fc' UNION ALL SELECT '0x1fe729426df3d04c033cd59771d2ac4e1e5e046a' UNION ALL SELECT '0x4597306b1ccfa70af7c2b479c3d7c6246566d5f7' UNION ALL SELECT '0x11fb06e3ed9a12ebbb1345326448aa01d78731d6' UNION ALL SELECT '0x684bf2573a3fbb92f656787c6ec5b5e7844f29b2' UNION ALL SELECT '0xebbbe02e2b41c17870152a27e8bee518211854d9' UNION ALL SELECT '0x4daf24cb5ac80f56df1c342f77fe3f5a364645ed' UNION ALL SELECT '0x9f8aba64beacb170cebfa0d1366d040051e51215' UNION ALL SELECT '0xdcf57a5b6a8a41231858b242c163a77d1579edec' UNION ALL SELECT '0x6c3200e8b067ec14e737da32fae6d902116ab50d' UNION ALL SELECT '0x2d14297b7ebc1c16ce9d09247c2287afa454046f' UNION ALL SELECT '0xea481d5f0015d67f32854e45fe8f3af7b54c5575' UNION ALL SELECT '0x95631d64b8825cec13956b7afeb8d797f103c372' UNION ALL
),
combined_transfers AS (
SELECT
TX_HASH,
BLOCK_TIMESTAMP,
FROM_ADDRESS,
TO_ADDRESS,
AMOUNT,
AMOUNT_USD,
'ETH' AS SYMBOL,
'native' AS TRANSFER_TYPE
FROM
ethereum.core.ez_native_transfers
WHERE
(LOWER(FROM_ADDRESS) IN (SELECT LOWER(address) FROM address_list)
OR LOWER(TO_ADDRESS) IN (SELECT LOWER(address) FROM address_list))
AND BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '1 day'
AND AMOUNT_USD >= 100
UNION ALL
SELECT
TX_HASH,
BLOCK_TIMESTAMP,
FROM_ADDRESS,
TO_ADDRESS,
AMOUNT,
AMOUNT_USD,
SYMBOL,
'token' AS TRANSFER_TYPE
FROM
ethereum.core.ez_token_transfers
WHERE
QueryRunArchived: QueryRun has been archived