winnie-fsnew title
Updated 2024-03-14
9
1
2
3
4
5
6
7
8
9
›
⌄
-- forked from spacebar / 2024-03-12 11:12 AM @ https://flipsidecrypto.xyz/spacebar/q/6KUE8yK-BNNz/2024-03-12-11-12-am
SELECT CEIL(DATEDIFF('minute',min_date,CURRENT_TIMESTAMP)/1440) as "Days Since Launch" FROM (
SELECT MIN(block_timestamp) as min_date FROM blast.core.fact_event_logs
where LOWER(contract_address) = LOWER('0x5ff315aa82a8b2b435f866d20ecd46959999bdcd')
and LOWER(topics[0]) = LOWER('0x621d62c6c0c4a0c35e883c6b27ad50ecc3093f08bfaf8aa5f58127d351feeb21')
) x
QueryRunArchived: QueryRun has been archived