Meme Coin | Total Holder | Fully diluted MarketCap | Price | ATL | ATH | percentage from ATH | percentage from ATL | Total Supply. | Avg Holding (USD) | Contract | Price (24h) | Price (7d) | Price (30d) | Twitter | Total Holders | Fully diluted market cap | Total Supply | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SHROOMY | 10.6 K | 1.49 M | 0.00160697 | 0.00012483 | 0.00225475 | -29 | 1187 | 927.91 M | 141 | 0x0c5e2d1c98cd265c751e02f8f3293bc5764f9111 | 0.85 | 5.99 | 20.88 | ShroomyProject | 10583 | 1491121 | 927908200 |
LordkingSHROOMY
Updated 2025-03-08
999
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 contract_info AS (
SELECT * FROM (
VALUES
-- HIGH MC
('0x0c5e2d1c98cd265c751e02f8f3293bc5764f9111', ' SHROOMY', 'ShroomyProject' )
) AS t (contract_address, token_name, twitter)
),
price AS (
SELECT
c.contract_address AS token_address,
p.price
FROM contract_info c
JOIN ink.price.ez_prices_hourly p
ON LOWER(c.contract_address) = lower(p.token_address)
WHERE (hour, p.token_address) IN (
SELECT MAX(hour), token_address
FROM ink.price.ez_prices_hourly
WHERE token_address IN (SELECT LOWER(contract_address) FROM contract_info)
GROUP BY token_address
)
),
min_max as (
select
distinct c.contract_address AS contract_address,
c.token_name ,
min(p.price) as min_price ,
max(p.price) as max_price
FROM contract_info c
Last run: about 2 months ago
1
191B
2s