USERS | TYPE | |
|---|---|---|
1 | 907 | Polymarket users |
2 | 5602 | New users |
Hessishshuffle 4
Updated 20 hours ago
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 eclipse_txs_buy as
(select AMOUNT/1e6 as usd,
a.TX_FROM as user,
a.TX_ID
from eclipse.core.fact_transfers a
where a.BLOCK_TIMESTAMP::date >= '2024-12-04' and
a.TX_FROM != 'AF2sa2kFHgZF8oMDzP8aUCveM5T1LpRBDC3eP4zW7w5R' and
a.MINT = 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE' and
a.SUCCEEDED = 'TRUE'
and
a.tx_id in
(select DISTINCT tx_id
from eclipse.core.fact_events_inner
where a.BLOCK_TIMESTAMP::date >= '2024-12-04' and
EVENT_TYPE = 'transferChecked'
and INSTRUCTION_PROGRAM_ID = 'E98KDQN4NuhPcj4KD82pZj122KxYZ9dNhsNaAbPXLkeY')),
eclipse_txs_sell as
(select AMOUNT/1e6 as usd,
a.TX_to as user,
a.TX_ID
from eclipse.core.fact_transfers a
where a.BLOCK_TIMESTAMP::date >= '2024-12-04' and
a.TX_FROM = 'AF2sa2kFHgZF8oMDzP8aUCveM5T1LpRBDC3eP4zW7w5R' and
a.MINT = 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE' and
a.SUCCEEDED = 'TRUE'
and
a.tx_id in
(select DISTINCT tx_id
from eclipse.core.fact_events_inner
where a.BLOCK_TIMESTAMP::date >= '2024-12-04' and
EVENT_TYPE = 'transferChecked'
and INSTRUCTION_PROGRAM_ID = 'E98KDQN4NuhPcj4KD82pZj122KxYZ9dNhsNaAbPXLkeY')),
Last run: about 20 hours ago
2
45B
94s