samtop pairs - error copy
Updated 2024-10-29
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 TheLaughingMan / top pairs - error @ https://flipsidecrypto.xyz/TheLaughingMan/q/LQVgnm4X11Sh/top-pairs---error
-- forked from top pairs @ https://flipsidecrypto.xyz/studio/queries/a1a642ef-ed24-4203-ba8e-957d06fe4579
-- forked from summary stats @ https://flipsidecrypto.xyz/studio/queries/f4083419-d81f-46fd-b33f-ca8e75860447
-- forked from summary stats test (no edge) @ https://flipsidecrypto.xyz/studio/queries/164ece5b-50d0-4186-b27d-2866887d8a47
----SEI Orderfill events-----
with sei_products as (
with base as (
select livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/a1356916-5e5f-4952-8390-1711fd4e3b16/latest-run') as resp
)
SELECT
VALUE[0] as block_number
,VALUE[1] as block_timestamp
,VALUE[2] as tx_hash
,VALUE[3]:: STRING AS product_id
,VALUE[4] as product_type
,VALUE[5] as ticker_id
,VALUE[6] as symbol
,VALUE[7] as NAME
from base, lateral FLATTEN (input=> resp:data:result:rows)
),
logs AS (
SELECT
*
FROM
sei.core_evm.fact_event_logs
WHERE 1=1
AND block_timestamp>='2024-08-14'
AND block_timestamp BETWEEN '{{start_date}}' AND '{{end_date}}'
QueryRunArchived: QueryRun has been archived