ORDERBOOK | BLOCK_TIMESTAMP | OPTIONS | |
|---|---|---|---|
1 | 5ceCcEQ2PjYMXbsh956GZZPC5R1sZGnw4UBaJpVdDPE4 | 2024-01-23 02:59:20.000 | 1 |
2 | 5ceCcEQ2PjYMXbsh956GZZPC5R1sZGnw4UBaJpVdDPE4 | 2024-01-23 16:55:40.000 | 1 |
3 | 5ceCcEQ2PjYMXbsh956GZZPC5R1sZGnw4UBaJpVdDPE4 | 2024-01-23 10:46:50.000 | 2 |
4 | 5ceCcEQ2PjYMXbsh956GZZPC5R1sZGnw4UBaJpVdDPE4 | 2024-01-23 13:08:51.000 | 1 |
5 | 5ceCcEQ2PjYMXbsh956GZZPC5R1sZGnw4UBaJpVdDPE4 | 2024-01-23 22:00:33.000 | 3 |
6 | 5ceCcEQ2PjYMXbsh956GZZPC5R1sZGnw4UBaJpVdDPE4 | 2024-01-23 21:44:14.000 | 2 |
7 | EGdryU8HzwqhT8NpPno6CVT8D2Nr2CL4gJTF57NvX1UV | 2024-01-23 18:10:51.000 | 1 |
8 | 5ceCcEQ2PjYMXbsh956GZZPC5R1sZGnw4UBaJpVdDPE4 | 2024-01-23 18:17:55.000 | 1 |
9 | EKPqEMbgMuf6qD69FMGnQamW2f5vCssDrqmoXJAiyjW1 | 2024-01-23 00:10:57.000 | 1 |
10 | 5ceCcEQ2PjYMXbsh956GZZPC5R1sZGnw4UBaJpVdDPE4 | 2024-01-23 07:56:43.000 | 1 |
11 | Mad Lads | 2024-01-23 17:10:02.000 | 1 |
12 | 5SmBrw3z7wqXTZXxxZXRLDoiqY6yRzN57hiLULnRGihA | 2024-01-23 22:29:23.000 | 1 |
13 | 5ceCcEQ2PjYMXbsh956GZZPC5R1sZGnw4UBaJpVdDPE4 | 2024-01-23 00:37:54.000 | 1 |
14 | HvKjuxwvwtep6BfEdbw18wQ1wZjPVZMeibDnWs3RAzZS | 2024-01-01 20:13:14.000 | 1 |
15 | 5ceCcEQ2PjYMXbsh956GZZPC5R1sZGnw4UBaJpVdDPE4 | 2024-01-26 12:20:52.000 | 1 |
16 | 5wnPJvyhgTMRU94MPxNLSLeYkfzCJeXMtvEjPrwPiB6A | 2024-01-26 19:11:59.000 | 1 |
17 | EKPqEMbgMuf6qD69FMGnQamW2f5vCssDrqmoXJAiyjW1 | 2024-01-26 09:08:37.000 | 1 |
18 | EKPqEMbgMuf6qD69FMGnQamW2f5vCssDrqmoXJAiyjW1 | 2024-01-26 12:55:00.000 | 1 |
19 | 5ceCcEQ2PjYMXbsh956GZZPC5R1sZGnw4UBaJpVdDPE4 | 2024-01-26 12:26:41.000 | 1 |
20 | EGdryU8HzwqhT8NpPno6CVT8D2Nr2CL4gJTF57NvX1UV | 2024-01-26 03:04:19.000 | 1 |
FlorentGtensor options
Updated 2024-02-08
99
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
›
⌄
WITH taken as (
SELECT
BLOCK_TIMESTAMP,
instruction['accounts'][3] as orderstate
FROM solana.core.fact_events
WHERE PROGRAM_ID = 'TLoCKic2wGJm7VhZKumih4Lc35fUhYqVMgA4j389Buk'
AND LEFT(INSTRUCTION['data'], 5) = '23BSb'
),
offered as (
SELECT
DISTINCT instruction['accounts'][1] as orderstate,
CASE
WHEN instruction['accounts'][3] = 'CtXrSG5dzVbRoBpDyAhM69p7tjNuL3oTy18PfoKNQHyy' THEN 'Claynosaurz'
WHEN instruction['accounts'][3] = '3PJCoXPcswZEx8ZimR2xiQvr6sJGJWTp3cpsLhhc7pmP' THEN 'Mad Lads'
ELSE instruction['accounts'][3]
END AS orderbook -- to check
FROM solana.core.fact_events
WHERE PROGRAM_ID = 'TLoCKic2wGJm7VhZKumih4Lc35fUhYqVMgA4j389Buk'
AND LEFT(INSTRUCTION['data'], 5) = 'PYHjY'
)
SELECT orderbook,
block_timestamp,
count(t.orderstate) as options
FROM taken t
LEFT JOIN offered o ON t.orderstate = o.orderstate
GROUP BY 1, 2
Last run: over 1 year ago
...
6776
499KB
10s