vendettaAvalanche Benqi
Updated 2024-09-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
date_trunc('month',block_timestamp) AS date,
COUNT(DISTINCT tx_hash) AS transactions,
COUNT(DISTINCT to_address) AS wallets,
SUM(raw_amount / POW(10, 18)) AS volume
FROM
avalanche.core.fact_token_transfers
WHERE block_timestamp::date >= '2023-01-01'
and contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be' --avax
AND from_address = '0x0000000000000000000000000000000000000000'
GROUP BY
date
ORDER BY
date asc
QueryRunArchived: QueryRun has been archived