-- forked from All - Fee Over time copy @ https://flipsidecrypto.xyz/edit/queries/44bf65cc-7960-492f-8714-8f89468a06ee -- forked from h4wk / All - Fee Over time @ https://flipsidecrypto.xyz/h4wk/q/gTQDf698leXD/all---fee-over-time -- forked from EVM - Fees @ https://flipsidecrypto.xyz/edit/queries/fe3c6b4b-60e1-4eb7-b951-dec1e0520ff3 -- forked from https://flipsidecrypto.xyz/hess/q/blZ-l4FMTnz3/fees with zk_import as ( select * from ( SELECT livequery.live.udf_api ( 'https://api.dune.com/api/v1/query/3145394/results?api_key=nPlMJ4JjTsMZcIo0C6kGSt5rpbcoXujU') as resp) , table(FLATTEN(parse_json(resp:data:"result":"rows")))) , EVM as ( select TO_TIMESTAMP(value:"date") as date, 'Zksync' as chain, 'WETH' as symbol, value:"avg_fee"::string as tx_fee from zk_import a join ethereum.core.dim_dates b on a.value:"date" = b.date_day where date >= current_date() - 31 AND date < current_date() -- and date >= '2023-11-01' UNION ALL select date(block_timestamp) as date, 'Arbitrum' as chain, 'WETH' as symbol, tx_fee from arbitrum.core.fact_transactions -- a join ethereum.core.dim_dates b on a.block_timestamp::date = b.date_day where date >= current_date() - 31 AND date < current_date() -- and block_timestamp::date >= '2023-11-01' and status = 'SUCCESS' UNION ALL select date(block_timestamp) as date, 'Optimism' as chain, 'WETH' as symbol, tx_fee from optimism.core.fact_transactions -- a join ethereum.core.dim_dates b on a.block_timestamp::date = b.date_day where date >= current_date() - 31 AND date < current_date() -- and block_timestamp::date >= '2023-11-01' and status = 'SUCCESS' -- UNION ALL -- select date(block_timestamp) as date, -- 'Polygon' as chain, -- 'WMATIC' as symbol, -- tx_fee -- from polygon.core.fact_transactions --a join ethereum.core.dim_dates b on a.block_timestamp::date = b.date_day -- where date >= current_date() - 31 -- -- and block_timestamp::date >= '2023-11-01' -- and status = 'SUCCESS' UNION ALL select date(block_timestamp) as date, 'Avalanche' as chain, 'WAVAX' as symbol, tx_fee from avalanche.core.fact_transactions -- a join ethereum.core.dim_dates b on a.block_timestamp::date = b.date_day where date >= current_date() - 31 AND date < current_date() -- and block_timestamp::date >= '2023-11-01' and status = 'SUCCESS' -- UNION ALL -- select date(block_timestamp) as date, -- 'BSC' as chain, -- 'WBNB' as symbol, -- tx_fee -- from bsc.core.fact_transactions -- a join ethereum.core.dim_dates b on a.block_timestamp::date = b.date_day -- where date >= current_date() - 31 -- -- and block_timestamp::date >= '2023-11-01' -- and status = 'SUCCESS' UNION ALL select date(block_timestamp) as date, 'Base' as chain, 'WETH' as symbol, tx_fee from base.core.fact_transactions --a join ethereum.core.dim_dates b on a.block_timestamp::date = b.date_day where date >= current_date() - 31 AND date < current_date() -- and block_timestamp::date >= '2023-11-01' and status = 'SUCCESS' UNION ALL select date(block_timestamp) as date, 'Blast' as chain, 'WETH' as symbol, tx_fee from blast.core.fact_transactions --a join ethereum.core.dim_dates b on a.block_timestamp::date = b.date_day where date >= current_date() - 31 AND date < current_date() -- and block_timestamp::date >= '2023-11-01' and status = 'SUCCESS' -- UNION ALL -- select date(block_timestamp) as date, -- 'Ethereum' as chain, -- 'WETH' as symbol, -- tx_fee -- from ethereum.core.fact_transactions --a join ethereum.core.dim_dates b on a.block_timestamp::date = b.date_day -- where date >= current_date() - 31 -- -- and block_timestamp::date >= '2023-11-01' -- and status = 'SUCCESS' UNION select date(block_timestamp) as date, 'Near' as chain, 'NEAR' as symbol, (TRANSACTION_FEE/pow(10,24)) as tx_fee from near.core.fact_transactions a join ethereum.core.dim_dates b on a.block_timestamp::date = b.date_day -- where MONTH_NAME_SHORT = '{{Month_Name}}' -- and block_timestamp::date >= '2023-11-01' where date >= current_date() - 31 AND date < current_date() and tx_succeeded = 'true' UNION select date(block_timestamp) as date, 'Flow' as chain, 'FLOW' as symbol, ((a.event_data:inclusionEffort + a.event_data:executionEffort ) * a.event_data:amount ) as tx_fee from flow.core.fact_events a join ethereum.core.dim_dates b on a.block_timestamp::date = b.date_day -- where MONTH_NAME_SHORT = '{{Month_Name}}' -- and block_timestamp::date >= '2023-11-01' where date >= current_date() - 31 AND date < current_date() -- and TX_SUCCEEDED = 'true' and a.event_type = 'FeesDeducted' and a.tx_succeeded = 'true' ) , price as ( select date(hour) as date, symbol, avg(price) as avg_price from ethereum.price.ez_hourly_token_prices where symbol in ('WETH','WMATIC','WBNB') group by 1,2 UNION ALL select date(hour) as date, symbol, avg(price) as avg_price from ethereum.price.ez_hourly_token_prices where symbol in ('WAVAX') group by 1,2 UNION ALL select date(timestamp) as date, symbol, avg(PRICE_USD) as avg_price from flow.price.fact_prices where symbol = 'FLOW' group by 1,2 UNION select date(timestamp) as date, 'NEAR' as symbol, avg(price_usd) as avg_price from near.price.fact_prices where symbol = 'LINEAR' group by 1,2 ) , evm_base as ( select a.date, chain, tx_fee*avg_price as fee_usd from evm a join price b on a.date = b.date and a.symbol = b.symbol -- WHERE date >= current_date() - 30 ) , evm_final as ( select date, -- 'EVM' as chain, chain, avg(fee_usd) as avg_fee from evm_base where chain != 'Arbitrum' and date < current_date group by 1,2 ) , parallel as ( select date(block_timestamp) as date, 'Aptos' as chain, 'APT' as symbol, (gas_used * gas_unit_price) / pow(10, 8) as tx_fee from aptos.core.fact_transactions --a join ethereum.core.dim_dates b on a.block_timestamp::date = b.date_day where tx_type = 'user_transaction' AND date >= current_date() - 31 -- and block_timestamp::date >= '2023-11-01' and SUCCESS = 'true' UNION ALL select date(block_timestamp) as date, 'Sei' as chain, 'SEI' as symbol, (split(fee,'usei')[0]/pow(10,6)) as tx_fee from sei.core.fact_transactions --a join ethereum.core.dim_dates b on a.block_timestamp::date = b.date_day where date >= current_date() - 30 -- and block_timestamp::date >= '2023-11-01' and TX_SUCCEEDED = 'true' and split(fee,'usei')[0]/pow(10,6) > 0 UNION ALL select date(block_timestamp) as date, 'Solana' as chain, 'SOL' as symbol, (fee/pow(10,9)) as tx_fee from solana.core.fact_transactions --a join ethereum.core.dim_dates b on a.block_timestamp::date = b.date_day where date >= current_date() - 31 -- and block_timestamp::date >= '2023-11-01' and succeeded = 'true' ) , parallel_price as ( Select TO_TIMESTAMP(value[0]::string) as date, 'SEI' as symbol, value[1] as avg_price from ( SELECT livequery.live.udf_api( 'https://api.coingecko.com/api/v3/coins/sei-network/market_chart?vs_currency=usd&days=90&interval=daily&precision=3') as resp ),LATERAL FLATTEN(input => resp:data:prices) UNION ALL SELECT HOUR::date as date, symbol, avg(PRICE) as avg_price FROM aptos.price.ez_hourly_token_prices WHERE symbol = 'APT' GROUP by 1,2 UNION ALL select date(recorded_hour) as date, 'SOL' as symbol, avg(close) as avg_price from solana.price.ez_token_prices_hourly where token_address = 'So11111111111111111111111111111111111111112' and recorded_hour::date >= '2023-11-01' group by 1,2 ) , parallel_base as ( select a.date, chain, tx_fee*avg_price as fee_usd from parallel a join parallel_price b on a.date = b.date and a.symbol = b.symbol WHERE a.date >= current_date() - 31 AND a.date < current_date() ) , parallel_final as ( select date, chain, -- 'Parallel' as chain, avg(fee_usd) as avg_fee from parallel_base where date < current_date AND chain = 'Aptos' group by 1,2 ) select * from evm_final UNION ALL select * from parallel_final

Aptos vs. Near & Flow || Network Performance