AntonidasLatest 20 Token Transfers on INK
Updated 2025-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
-- forked from logs_count_daily @ https://flipsidecrypto.xyz/studio/queries/6ef827a7-c4a4-458f-bb96-255815d8f88b
-- forked from transaction_count_daily @ https://flipsidecrypto.xyz/studio/queries/913126d6-e26f-4ed6-a729-ad603efe1a9d
-- forked from block_count_daily @ https://flipsidecrypto.xyz/studio/queries/81b4b3ed-6051-4367-b070-313e9ae06712
select
block_timestamp
, concat('https://explorer.inkonchain.com/tx/',tx_hash) as tx_hash
, contract_address as token_address
, concat('0x', RIGHT(topic_1,40)) as from_address
, concat('0x', RIGHT(topic_2,40)) as to_address
, ethereum.public.udf_hex_to_int(data)::float as quantity
from ink.core.fact_event_logs
where topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and topics[3] is null
order by block_timestamp desc
limit 20
QueryRunArchived: QueryRun has been archived