CATEGORY | USERS | PRIME_AMOUNT | PRIME_AMOUNT_USD | |
|---|---|---|---|---|
1 | Between 1K & 5K $PRIME | 151 | 300555 | 2590283.74 |
2 | Between 100 & 500 $PRIME | 755 | 160739 | 1583299.68 |
3 | Between 500 & 1K $PRIME | 163 | 112456 | 1111609.8 |
4 | Between 5K & 10K $PRIME | 14 | 90659 | 738732.05 |
5 | Less Than 100 $PRIME | 23613 | 136334.25 | 1126223.5315 |
6 | Between 10K & 10K $PRIME | 10 | 160755 | 1194353.37 |
freemartianUsers In Each Category ($PRIME)
Updated 55 minutes 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
prices AS(
SELECT
hour,
price,
symbol,
ROW_NUMBER() OVER (ORDER BY hour DESC) AS row_num
FROM base.price.ez_prices_hourly
WHERE symbol ilike 'PRIME'
AND hour::date = current_date
qualify row_num = 1
),
deposits AS(
SELECT
block_timestamp,
tx_hash,
from_address,
amount,
amount_usd
FROM base.core.ez_token_transfers
WHERE origin_function_signature = '0xf104489f'
-- AND tx_hash = '0x2a55c1f0ee935ef663aa3e8d1d78099606c267ba8813d000e360ece2cf947c53'
AND block_timestamp::date >= '2024-06-01'
AND to_address = lower('0x75a44a70ccb0e886e25084be14bd45af57915451')
),
withdraws AS (
SELECT
block_timestamp,
tx_hash,
to_address,
amount,
amount_usd
FROM base.core.ez_token_transfers
WHERE origin_function_signature = '0x427a0a17'
Last run: about 1 hour agoAuto-refreshes every 1 hour
6
301B
69s