nitsStarkWAre Blocks
Updated 2022-06-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with txs as
(SELECT DISTINCT tx_hash
from ethereum.core.fact_event_logs
where origin_from_address = '0x2c169dfe5fbba12957bdd0ba47d9cedbfe260ca7' and contract_address = '0xc662c410c0ecf747543f5ba90660f6abebd9c8c4')
-- and origin_function_signature = '0x13f4a5b6'
SELECT date(block_timestamp) as day, sum(tx_fee) as total_fee, sum(total_fee) over (order by day) as cumulative_fees
from ethereum.core.fact_transactions
where tx_hash in (SELECT * from txs )
GROUP by 1
limit 300
-- tokenflow_eth.hextoint
Run a query to Download Data