PRESALE_PRICE_PER_SMOLE | LAUNCH_PRICE_IN_SOL | ROI_PERCENTAGE (%) | X_RETURNS | |
|---|---|---|---|---|
1 | 0.000001 | 0.000002 | 154.04 | 2.54 |
Motilola$SMOLE Presale ROI AND X Returns
Updated 8 days 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 launch_price AS (
SELECT
hour,
price AS launch_price_usd
FROM solana.price.ez_prices_hourly
WHERE token_address = '9Ttyez3xiruyj6cqaR495hbBkJU6SUWdV6AmQ9MvbyyS'
ORDER BY hour ASC
LIMIT 1
),
sol_price AS (
SELECT
hour,
price AS sol_price_usd
FROM solana.price.ez_prices_hourly
WHERE is_native = TRUE
AND hour::date = '2024-03-21'
LIMIT 1
),
launch_price_in_sol AS (
SELECT
l.hour,
l.launch_price_usd,
s.sol_price_usd,
ROUND(l.launch_price_usd / s.sol_price_usd, 6) AS launch_price_in_sol
FROM launch_price l
CROSS JOIN sol_price s
),
all_transfers AS (
SELECT
SUM(amount) AS total_sol_contributed
FROM solana.core.fact_transfers
WHERE tx_to = 'BL1gBdtuYRYSepKKpoy1GCNSmS1JeGSiNb7tdB2HQzor'
AND block_timestamp >= '2024-03-16 21:47:00'
Last run: 8 days ago
1
33B
19s