tomingNew Tokens Tracker - Latest Data Available copy
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
›
⌄
-- forked from marqu / New Tokens Tracker - Latest Data Available @ https://flipsidecrypto.xyz/marqu/q/frXDwpHCiHfv/new-tokens-tracker---latest-data-available
with
solana as (
select
'Solana' as chain,
block_id,
block_timestamp,
floor(datediff('minute',block_timestamp, current_timestamp()) / 60) as hours,
mod(datediff('minute',block_timestamp, current_timestamp()), 60.0) as minutes,
concat(iff(hours < 10, concat('0',hours::string), hours ::string),
':',
iff(minutes < 10, concat('0',minutes::string), minutes ::string)
) as lag,
block_hash
from solana.core.fact_blocks
inner join solana.core.fact_events
using(block_id, block_timestamp)
where block_timestamp ::date >= current_date() - 2
order by block_timestamp desc nulls last
limit 1
),
polygon as (
select
'Polygon' as chain,
block_number as block_id,
block_timestamp,
floor(datediff('minute',block_timestamp, current_timestamp()) / 60) as hours,
mod(datediff('minute',block_timestamp, current_timestamp()), 60.0) as minutes,
Run a query to Download Data