lj10242024-01-08 04:20 PM
Updated 2024-01-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
CAST(
REGEXP_SUBSTR(
CAST(LOG_MESSAGES AS STRING),
'Extra lamports in stake balance: (\d+)'
) AS INT
) AS ExtraLamports,
*
FROM
solana.core.fact_transactions
WHERE
SUCCEEDED = TRUE
AND BLOCK_TIMESTAMP > date_trunc('month', dateadd('month', -1, CURRENT_DATE))
AND BLOCK_TIMESTAMP < date_trunc('month', CURRENT_DATE)
AND CAST(LOG_MESSAGES AS STRING) LIKE '%Extra lamports in stake balance%'
limit 1
QueryRunArchived: QueryRun has been archived