TO_ADDRESS | AMT | VALUE | |
---|---|---|---|
1 | 0x9d3b2dad44c672470eb7f7ff64cb3ad329b24a22 | 227239.5 | 7.096689585 |
2 | 0x83e895aae6aaf2de0e459c04790548767a3640a0 | 171001.8 | 5.340386214 |
3 | 0x059478b19209cd1a7afa8695497e9395d0d4aa29 | 170887.8 | 5.336825994 |
4 | 0xd27eb5a15cb3f2701175b1e25b37f069bbaa2c25 | 114001.2 | 3.560257476 |
5 | 0x2c29894efeae7b81f29df367f8526de5c7e5e2ad | 114001.2 | 3.560257476 |
6 | 0x2f2e9273f8e39f586b29fbd93c03f8120c9087eb | 114001.2 | 3.560257476 |
7 | 0xce3f2bfafa57d7bde77530f4ef5c456c16d9ea90 | 114001.2 | 3.560257476 |
8 | 0xeb83434dff69a33ef92693506f3c733b57f16136 | 114001.2 | 3.560257476 |
9 | 0x45510869038967402ca2311f73f72b8eaa6ac023 | 114001.2 | 3.560257476 |
10 | 0x20109d75a6ed9ff874e8bd00ca7a4c4483f175c6 | 107731.1 | 3.364442253 |
11 | 0x010167c0bd4ebb24182ad5c82d90912da4cf9307 | 86218 | 2.69258814 |
12 | 0x2fdcbe5b371fe9188fa377c49d6994fd80ba5af5 | 85500.9 | 2.670193107 |
13 | 0x1274882dfb1c7df5badd689b08556e471b3de4ea | 72766.1 | 2.272485303 |
14 | 0xe16a5433a219c227571183807df39bbb43e27d1d | 61302.5 | 1.914477075 |
15 | 0xfd23b5c55810cd39ba39baebebdb2d24c71d7b9b | 59850.6 | 1.869134238 |
16 | 0xa37d4b05dccf43ebc69b1848e081af84326ac95f | 59850.6 | 1.869134238 |
17 | 0x8131f0c025d615ec568abf92e1ee9c84d9208791 | 58245 | 1.81899135 |
18 | 0x6f9158d5eb46ad0d94a26aac3d7c29ef1f41c986 | 57017.7 | 1.780662771 |
19 | 0x15e4a6accdcb021c8000908bdf080735e8a15bc2 | 57000.6 | 1.780128738 |
20 | 0x347ad31363d2b775d20b23a1539bfe8706c39ee3 | 57000.6 | 1.780128738 |
telperionAirdrop By User (YAWN)
Updated 2024-12-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- forked from Airdrop By User (Neiro) @ https://flipsidecrypto.xyz/studio/queries/a874e5f8-ed23-48f9-816a-4d396e5f3137
SELECT
concat(left(topics[2],2),right(topics[2],40)) as to_address,
utils.udf_hex_to_int(data)::int/1000000000000000000 as amt,
(SELECT price FROM ethereum.price.ez_prices_hourly
where token_address = lower('0x881d4C8618D68872fA404518B2460eA839A02a6a') order by hour desc limit 1)*(utils.udf_hex_to_int(data)::int/1000000000000000000) as value
FROM
ethereum.core.fact_event_logs
where tx_hash in
('0x45e5e1e1ad4097673ad3bb1c2ae71d002a6f52b18378191f3895e5445eae615d',
'0xc1049f2aab4cf79b8a1dfe43d6a5c4f16f854bbe764ab1ffc128aa2aa90db39f',
'0xae629bb2aa7d756436cd001c00a91f017e147e57111ffcc7648465927f771fba',
'0x5709192e985397dca16c1c5d5443d76a930d9d658d58afa1cd8b577ba2651429')
and concat(left(topics[2],2),right(topics[2],40)) <> lower('0x88888c037DF4527933fa8Ab203a89e1e6E58db70')
ORDER BY amt desc
Last run: about 1 month ago
...
552
36KB
7s