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
QueryRunArchived: QueryRun has been archived