HOUR | PROJECT_NAME | TRANSACTIONS | USERS | AMOUNT | |
|---|---|---|---|---|---|
1 | 2024-02-17 00:00:00.000 | pancakeswap | 1 | 1 | 293.546 |
2 | 2024-02-17 00:00:00.000 | metamask | 3 | 3 | 61.433 |
3 | 2024-02-17 01:00:00.000 | pancakeswap | 3 | 2 | 84.2746 |
4 | 2024-02-17 01:00:00.000 | li.fi | 2 | 2 | 30.9314 |
5 | 2024-02-17 01:00:00.000 | metamask | 1 | 1 | 18.6037 |
6 | 2024-02-17 02:00:00.000 | pancakeswap | 5 | 5 | 270.1797 |
7 | 2024-02-17 02:00:00.000 | mexc | 1 | 1 | 13.3511 |
8 | 2024-02-17 03:00:00.000 | gate.io | 1 | 1 | 329.312 |
9 | 2024-02-17 03:00:00.000 | pancakeswap | 4 | 4 | 48.9188 |
10 | 2024-02-17 03:00:00.000 | li.fi | 1 | 1 | 11.51 |
11 | 2024-02-17 04:00:00.000 | metamask | 2 | 2 | 66.4879 |
12 | 2024-02-17 04:00:00.000 | 0x | 1 | 1 | 50 |
13 | 2024-02-17 04:00:00.000 | pancakeswap | 1 | 1 | 9.6638 |
14 | 2024-02-17 05:00:00.000 | pancakeswap | 12 | 12 | 142.2501 |
15 | 2024-02-17 05:00:00.000 | paraswap | 1 | 1 | 39.6759 |
16 | 2024-02-17 05:00:00.000 | bybit | 1 | 1 | 30 |
17 | 2024-02-17 05:00:00.000 | metamask | 1 | 1 | 14.1028 |
18 | 2024-02-17 06:00:00.000 | pancakeswap | 12 | 12 | 151.9967 |
19 | 2024-02-17 06:00:00.000 | metamask | 1 | 1 | 33.8527 |
20 | 2024-02-17 07:00:00.000 | pancakeswap | 14 | 14 | 245.14375 |
freemartianHourly 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: about 1 year agoAuto-refreshes every 12 hours
63
3KB
23s