permaryphilosophical-cyan
Updated 2025-03-13
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc ('day', block_timestamp) as date,
count (distinct from_address) as "Tactics Buyers",
sum(amount) as total_weth,
sum(amount_usd) as "Volume",
SUM(SUM(amount_usd)) OVER (ORDER BY date_trunc('day', block_timestamp)) AS "Cumulative Volume"
from blast.core.ez_token_transfers
where to_address =lower('0x4aF1f00F50EfBFcDF7a8F2ac02e9BC24825438Ac')
and contract_address = '0x4300000000000000000000000000000000000004'
group by date
order by date desc;
QueryRunArchived: QueryRun has been archived