telperionAirdrop By User (YAWN)
    Updated 2024-12-04
    -- 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
    TO_ADDRESS
    AMT
    VALUE
    1
    0x9d3b2dad44c672470eb7f7ff64cb3ad329b24a22227239.57.096689585
    2
    0x83e895aae6aaf2de0e459c04790548767a3640a0171001.85.340386214
    3
    0x059478b19209cd1a7afa8695497e9395d0d4aa29170887.85.336825994
    4
    0xd27eb5a15cb3f2701175b1e25b37f069bbaa2c25114001.23.560257476
    5
    0x2c29894efeae7b81f29df367f8526de5c7e5e2ad114001.23.560257476
    6
    0x2f2e9273f8e39f586b29fbd93c03f8120c9087eb114001.23.560257476
    7
    0xce3f2bfafa57d7bde77530f4ef5c456c16d9ea90114001.23.560257476
    8
    0xeb83434dff69a33ef92693506f3c733b57f16136114001.23.560257476
    9
    0x45510869038967402ca2311f73f72b8eaa6ac023114001.23.560257476
    10
    0x20109d75a6ed9ff874e8bd00ca7a4c4483f175c6107731.13.364442253
    11
    0x010167c0bd4ebb24182ad5c82d90912da4cf9307862182.69258814
    12
    0x2fdcbe5b371fe9188fa377c49d6994fd80ba5af585500.92.670193107
    13
    0x1274882dfb1c7df5badd689b08556e471b3de4ea72766.12.272485303
    14
    0xe16a5433a219c227571183807df39bbb43e27d1d61302.51.914477075
    15
    0xfd23b5c55810cd39ba39baebebdb2d24c71d7b9b59850.61.869134238
    16
    0xa37d4b05dccf43ebc69b1848e081af84326ac95f59850.61.869134238
    17
    0x8131f0c025d615ec568abf92e1ee9c84d9208791582451.81899135
    18
    0x6f9158d5eb46ad0d94a26aac3d7c29ef1f41c98657017.71.780662771
    19
    0x15e4a6accdcb021c8000908bdf080735e8a15bc257000.61.780128738
    20
    0x347ad31363d2b775d20b23a1539bfe8706c39ee357000.61.780128738
    ...
    552
    36KB
    7s