BRIDGING_FEES_APT | BRIDGING_FEES_USD | |
|---|---|---|
1 | 22.207917 | 137.307158871 |
zyroqf1
Updated 6 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH prices AS (
SELECT
DATE_TRUNC('{{granularity}}', HOUR) AS date,
AVG(PRICE) AS avg_price
FROM aptos.price.ez_prices_hourly
WHERE TOKEN_ADDRESS = '0x1::aptos_coin::AptosCoin'
GROUP BY DATE_TRUNC('{{granularity}}', HOUR)
)
SELECT
SUM((t.gas_used * t.gas_unit_price) / 1e8) AS bridging_fees_apt,
SUM((t.gas_used * t.gas_unit_price) / 1e8 * p.avg_price) AS bridging_fees_usd
FROM aptos.defi.ez_bridge_activity b
LEFT JOIN aptos.core.fact_transactions t
ON b.tx_hash = t.tx_hash
LEFT JOIN prices p
ON DATE_TRUNC('{{granularity}}', b.block_timestamp) = p.date
WHERE b.block_timestamp > CURRENT_DATE - INTERVAL '{{trading_period}} days';
Last run: 6 days ago
1
27B
107s