DAYS | TXS | USERS | Paid Fee (ETH) | Paid Fee (USD) | |
|---|---|---|---|---|---|
1 | 2021-11-16 00:00:00.000 | 69 | 18 | 0 | 0 |
2 | 2021-11-17 00:00:00.000 | 130 | 19 | 0 | 0 |
3 | 2021-11-18 00:00:00.000 | 191 | 39 | 0 | 0 |
4 | 2021-11-19 00:00:00.000 | 154 | 53 | 0 | 0 |
5 | 2021-11-20 00:00:00.000 | 153 | 56 | 0 | 0 |
6 | 2021-11-21 00:00:00.000 | 150 | 69 | 0 | 0 |
7 | 2021-11-22 00:00:00.000 | 153 | 75 | 0 | 0 |
8 | 2021-11-23 00:00:00.000 | 153 | 87 | 0 | 0 |
9 | 2021-11-24 00:00:00.000 | 298 | 92 | 0 | 0 |
10 | 2021-11-25 00:00:00.000 | 1311 | 141 | 0 | 0 |
11 | 2021-11-26 00:00:00.000 | 1727 | 308 | 0 | 0 |
12 | 2021-11-27 00:00:00.000 | 153 | 31 | 0 | 0 |
13 | 2021-11-28 00:00:00.000 | 154 | 53 | 0 | 0 |
14 | 2021-11-29 00:00:00.000 | 162 | 52 | 0 | 0 |
15 | 2021-11-30 00:00:00.000 | 149 | 66 | 0 | 0 |
16 | 2021-12-01 00:00:00.000 | 195 | 79 | 0 | 0 |
17 | 2021-12-02 00:00:00.000 | 285 | 94 | 0 | 0 |
18 | 2021-12-03 00:00:00.000 | 209 | 89 | 0 | 0 |
19 | 2021-12-04 00:00:00.000 | 158 | 90 | 0 | 0 |
20 | 2021-12-05 00:00:00.000 | 198 | 94 | 0 | 0 |
mamad-5XN3k3stark1
Updated 2024-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with pricet as (
SELECT
HOUR::date as pdate,
avg(price) as usd
from crosschain.price.ez_hourly_token_prices
where SYMBOL = 'WETH'
group by 1
)
SELECT
date_trunc('day', TIMESTAMP) as days,
count(distinct tx_hash) as txs,
count(distinct CONTRACT) as users,
sum(ACTUAL_FEE/pow(10,18)) as "Paid Fee (ETH)",
sum((ACTUAL_FEE * usd)/pow(10,18)) as "Paid Fee (USD)"
from external.tokenflow_starknet.decoded_transactions
left join pricet on pdate = TIMESTAMP::date
where CHAIN_ID = 'mainnet'
and TIMESTAMP < current_date
group by 1
order by 1 asc
Last run: about 1 year ago
...
808
49KB
37s