winnie-fsLaunch Price copy
Updated 2024-01-12
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
›
⌄
-- editing this query...
-- forked from crypto_edgar / Launch Price @ https://staging.flipsidecrypto.xyz/crypto_edgar/q/2023-05-19-09-10-am-C-ODmi
WITH
token_launch as (
SELECT
DECODED_LOG:amount0 / POW(10, 18) AS INITIAL_AMOUNT_PSYOPS,
DECODED_LOG:amount1 / POW(10, 18) AS INITIAL_AMOUNT_WETH,
1850.4 AS WETH_PRICE,
(INITIAL_AMOUNT_WETH * WETH_PRICE) / INITIAL_AMOUNT_PSYOPS AS PSYOPS_PRICE_LAUNCH
FROM
ethereum.core.ez_decoded_event_logs
WHERE
BLOCK_TIMESTAMP >= '2023-05-18'
AND TX_HASH = '0xc96182b24279f79187c90e1dc32ef8d25b414340d4094a98eef3437ba62bf9a0'
AND EVENT_NAME = 'Mint'
)
SELECT
*
FROM
token_launch
QueryRunArchived: QueryRun has been archived