ErsvanHashs
Updated 2022-07-19
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select timestamp, lag(timestamp,1) over (/*partition by tx_hash*/ order by timestamp) as test
--select timestamp, LAG(timestamp) OVER (ORDER BY timestamp) as test
from (
select timestamp,tx_hash,name from tokenflow_starknet.decoded.events
where tx_hash in
('0x3de7f1de421ad17a7f38ce65447760ac72c9682e8ef74cc6ef6586ebce475c0',
'0x19d66ef89add5665e6914e2abf43b8b0918ce41770796e82902611c679f3b80',
'0x7f4e8bb495dedc85cabe3890024bfd7518ec38b1e0beda1bc8f8cd91a36126')
order by 1
)
Run a query to Download Data