marqu1 month txs and fees all chains
Updated 2024-01-07
999
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
›
⌄
-- forked from World Cup - [all] cumul network fees bars @ https://flipsidecrypto.xyz/edit/queries/fc304e41-9cb4-4e09-ab71-645e3c446f9f
with
-- gas_algorand as (
-- select
-- block_timestamp,
-- block_id as block_number,
-- tx_id as tx_hash,
-- tx_sender as spender,
-- fee as fee_native,
-- fee * price_usd as fee_usd,
-- price_usd,
-- 'ALGO' as token,
-- 'Algorand' as blockchain
-- from algorand.core.fact_transaction txs
-- left join algorand.core.ez_price_pool_balances prices
-- on date_trunc('hour',txs.block_timestamp) = prices.block_hour
-- where fee > 0
-- and block_timestamp ::date >= current_date() - interval '{{months}} months'
-- ),
gas_ethereum as (
select
block_timestamp,
block_number,
tx_hash,
from_address as spender,
tx_fee as fee_native,
tx_fee * price as fee_usd,
price as price_usd,
QueryRunArchived: QueryRun has been archived