CarlOwOsgas per mill
Updated 2022-11-15
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 eth AS (
SELECT
1e6 * SUM(tx_fee*price) / SUM(eth_value*price) AS gas_per_mill
FROM
ethereum.core.fact_transactions JOIN ethereum.core.fact_hourly_token_prices ON hour = DATE_TRUNC('HOUR', block_timestamp)
WHERE
block_timestamp >= CURRENT_DATE-30
AND token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
),
op AS (
SELECT
1e6 * SUM(tx_fee*price) / SUM(eth_value*price) AS gas_per_mill
FROM
optimism.core.fact_transactions JOIN optimism.core.fact_hourly_token_prices ON hour = DATE_TRUNC('HOUR', block_timestamp)
WHERE
block_timestamp >= CURRENT_DATE-30
AND token_address = '0x4200000000000000000000000000000000000006'
),
/*sol AS (
SELECT
1e6 * SUM(fee*1e-9*close) / SUM(t.amount*1e-9*close) AS gas_per_mill
FROM
solana.core.fact_transactions
JOIN solana.core.fact_token_prices_hourly ON recorded_hour = DATE_TRUNC('HOUR', block_timestamp)
LEFT JOIN solana.core.fact_transfers t USING(tx_id)
WHERE
block_timestamp >= CURRENT_DATE-30
AND symbol = 'SOL'
AND t.mint = 'So11111111111111111111111111111111111111112'
),*/
algo AS (
SELECT
1e6 * SUM(fee*price_usd) / SUM(amount*1e-6*price_usd) AS gas_per_mill
FROM
algorand.core.fact_transaction JOIN algorand.core.ez_price_pool_balances ON block_hour = DATE_TRUNC('HOUR', block_timestamp)
WHERE
Run a query to Download Data