CHAIN | BLOCK_ID | BLOCK_TIMESTAMP | LAG (HH:MM) | BLOCK_HASH | |
|---|---|---|---|---|---|
1 | Arbitrum | 179548208 | 2024-02-11 04:36:38.000 | 00:22 | 0x4d16cc12bc4ff3f3a3f99df321ed930b073866ed38c2d5eac2d06513c8629786 |
2 | Solana | 247425073 | 2024-02-11 04:36:14.000 | 00:22 | HQFSsPvdi2N6Not3UnLMkomvKHbV78k3j7Ztrgy4ihBb |
3 | Polygon | 53378076 | 2024-02-11 04:26:31.000 | 00:32 | 0xa6a00301af56202586f975f93b33a1b0a3fcb92110efb0f55e1bf8e803ebe675 |
4 | Ethereum | 19202418 | 2024-02-11 04:21:47.000 | 00:37 | 0x945c918f17ea71f9ad0e7d2a09420933919ff69ee08f5f65aae9a79bc1f2bca7 |
tomingNew Tokens Tracker - Latest Data Available copy
Updated 2024-02-11
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,
Last run: over 1 year ago
4
478B
21s