TRANSACTIONS | USERS | AMOUNT | |
|---|---|---|---|
1 | 167 | 165 | 4846.321001557 |
freemartianTotal sell DMAIL
Updated 2024-02-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH claim AS (
SELECT
block_timestamp,
tx_hash,
to_address,
raw_amount/pow(10,18) AS amount
-- FROM bsc.core.fact_decoded_event_logs
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
),
sell AS (
SELECT
block_timestamp,
tx_hash,
from_address,
to_address,
contract_address,
raw_amount/pow(10,18) AS amount,
address_name,
project_name
FROM bsc.core.fact_token_transfers t
INNER JOIN bsc.core.dim_labels l ON l.address = t.to_address
WHERE from_address IN(SELECT to_address FROM claim)
AND contract_address = '0xcc6f1e1b87cfcbe9221808d2d85c501aab0b5192'
AND block_timestamp::date >= current_date
)
Last run: over 1 year agoAuto-refreshes every 12 hours
1
26B
14s