TX_HASH | BLOCK_TIMESTAMP | SWAPPER | AMOUNT_IN | AMOUNT_OUT | TOKEN_IN_ADDRESS | TOKEN_OUT_ADDRESS | SYMBOL_IN | SYMBOL_OUT | AMOUNT_IN_USD | AMOUNT_OUT_USD | AMOUNT_USD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0xd7584c9a9b42f6d13ae2f8cd846f5d0884923a369f28029ba9c0782ce8108e52 | 2025-05-06 21:00:11.015 | 0x1db941c201708c7370a62e7899bf674874a993624dd8d3ba3c96c84fa5e90333 | 0.10044013 | 0x357b0b74bc833e95a115ad22604854d6b0fca151cecd94111770e5d6ffc9dc2b | 0xa | APT | 0 | ||||
2 | 0xd7584c9a9b42f6d13ae2f8cd846f5d0884923a369f28029ba9c0782ce8108e52 | 2025-05-06 21:00:11.015 | 0x1db941c201708c7370a62e7899bf674874a993624dd8d3ba3c96c84fa5e90333 | 0.10044013 | 0x357b0b74bc833e95a115ad22604854d6b0fca151cecd94111770e5d6ffc9dc2b | 0x1::aptos_coin::AptosCoin | APT | 0.4831170253 | 0 | |||
3 | 0xd7584c9a9b42f6d13ae2f8cd846f5d0884923a369f28029ba9c0782ce8108e52 | 2025-05-06 21:00:11.015 | 0x1db941c201708c7370a62e7899bf674874a993624dd8d3ba3c96c84fa5e90333 | 0.10044013 | 0x357b0b74bc833e95a115ad22604854d6b0fca151cecd94111770e5d6ffc9dc2b | 0x1::aptos_coin::AptosCoin | APT | 0.4831170253 | 0 |
Afonso_DiazTest
Updated 2025-05-07
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
pricet as (
select
hour::date as date,
token_address,
avg(price) as token_price_usd
from
aptos.price.ez_prices_hourly
group by 1, 2
),
main as (
select
tx_hash,
block_timestamp,
sender as swapper,
event_data:amount_in::bigint / pow(10, token_in.decimals) as amount_in,
event_data:amount_out::bigint / pow(10, token_out.decimals) as amount_out,
c.token_address as token_in_address,
d.token_address as token_out_address,
token_in.symbol as symbol_in,
token_out.symbol as symbol_out
from
aptos.core.fact_transactions a
join
aptos.core.fact_events b using(tx_hash)
left join
aptos.core.dim_tokens token_in on event_data:in_coin = token_in.token_address
left join
aptos.core.dim_tokens token_out on event_data:out_coin = token_out.token_address
join
aptos.core.fact_transfers c using (tx_hash)
join
aptos.core.fact_transfers d using (tx_hash)
where
Last run: 15 days ago
3
903B
7s