Updates | Users | Total Cost [APT] | Total Cost [USD] | Average Cost | |
|---|---|---|---|---|---|
1 | 42361231 | 17520 | 69222.92675623 | 543581.316770964 | 0.01283204723 |
alitaslimiUsers and Fees
Updated 2025-01-02
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
prices as (
select
hour,
avg(price) as price
from
aptos.price.ez_prices_hourly
where
token_address = '0x1::aptos_coin::AptosCoin'
group by
hour
),
events as (
select
block_timestamp,
tx_hash,
tx_type,
split_part(payload_function, '::', 1) as payload_address,
split_part(payload_function, '::', 2) as payload_module,
split_part(payload_function, '::', 3) as payload_resource,
event_data
from
aptos.core.fact_events
where
success
and event_module = 'event'
and event_resource = 'PriceFeedUpdate'
and event_address = '0x7e783b349d3e89cf5931af376ebeadbfab855b3fa239b7ada8f5a92fbea6b387'
),
transactions as (
select
block_timestamp,
tx_hash,
sender,
gas_used,
gas_unit_price,
Last run: 2 months ago
1
64B
226s