freemartianTotal Claimed DMAIL
Updated 2024-02-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH claim AS (
SELECT
block_timestamp,
tx_hash,
to_address,
raw_amount/pow(10,18) AS amount
FROM bsc.core.fact_token_transfers
WHERE from_address = '0x26f5f3b28ecbbbfe64167df7c7a3590f90c90af9'
AND contract_address = '0xcc6f1e1b87cfcbe9221808d2d85c501aab0b5192'
AND block_timestamp::date >= '2024-01-29'
ORDER BY block_timestamp ASC
)
SELECT
count(DISTINCT to_address) AS users,
SUM(amount) AS token_amount
from claim
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived