theericstoneUnique Transaction Initiators and Fees
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
tr.date,
tr.from_label_type,
tr.daily_fees_usd,
tr.initiators,
tr.daily_fees_usd / tr.initiators as fees_per_user,
tr.daily_fees_usd / tr.transactions as fees_per_transaction
from
( select
date_trunc('day',block_timestamp) as date,
from_label_type,
sum(fee_usd) as daily_fees_usd,
count(distinct tx_id) as transactions,
count( distinct from_address ) as initiators
from
gold.ethereum_transactions
where block_timestamap > getdate() - interval '8 weeks'
group by 1,2
order by 1,2 desc
)tr;
Run a query to Download Data