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 | COQ | 104.3 K | 42.11 M | 6.066e-7 | 8.7e-8 | 0.000006408 | -91 | 595 | 69420 B | 404 | 0x420FcA0121DC28039145009570975747295f2329 | -1.55 | 4.58 | -1.67 | CoqInuAvax | 104346 | 42107534 | 69420000000000 |
LordkingCOQ
Updated 8 days ago
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
('0x420FcA0121DC28039145009570975747295f2329', ' COQ', 'CoqInuAvax' )
) AS t (contract_address, token_name, twitter)
),
price AS (
SELECT
c.contract_address AS token_address,
p.price
FROM contract_info c
JOIN avalanche.price.ez_prices_hourly p
ON LOWER(c.contract_address) = p.token_address
WHERE (hour, p.token_address) IN (
SELECT MAX(hour), token_address
FROM avalanche.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
JOIN avalanche.price.ez_prices_hourly p
Last run: 8 days ago
1
186B
8s