Spectertoken transfre
Updated 2024-11-15
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
--MINT
SELECT Date_trunc('month', Block_timestamp) AS month,
COUNT(DISTINCT tx_hash) AS total_transfer,
SUM(total_transfer) OVER (ORDER BY Month) AS cum_transfrer,
SUM(Amount_usd) AS total_volume,
SUM(total_volume) OVER (ORDER BY Month) AS cum_volume
FROM blast.core.ez_token_transfers
WHERE contract_address = '0x4300000000000000000000000000000000000003'
--AND from_address = '0x0000000000000000000000000000000000000000'
GROUP BY month
ORDER BY month desc
QueryRunArchived: QueryRun has been archived