jeffy2030prizes
Updated 2025-01-26Copy Reference Fork
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
30
31
32
33
34
35
36
›
⌄
WITH all_txs AS (
SELECT
flattened.VALUE AS val,
flattened.VALUE:parsed:info:lamports / 1000000000 AS eth,
LOG_MESSAGES,
f.ACCOUNT_KEYS,
flattened.*,
TX_ID,
SIGNERS,
SUCCEEDED
FROM
eclipse.core.fact_transactions f,
TABLE(FLATTEN(input => INSTRUCTIONS)) AS flattened
WHERE
f.ACCOUNT_KEYS[1]:pubkey = 'H8ypTdHmhn95ytZSanT1yzmDWW2aiQVVundsqbiAczEd'
ORDER BY
f.BLOCK_TIMESTAMP::DATE DESC
),
info AS (
SELECT
'4.2M LAIKA' AS name, 'sideprize_49_4.2M LAIKA' AS prize, 'Laika' AS token, 4.2 * 1000000 AS amount, 'LaihKXA47apnS599tyEyasY2REfEzBNe4heunANhsMx' AS contract
UNION ALL
SELECT
'5M LAIKA', 'sideprize_4_5M LAIKA' AS prize, 'Laika' AS token, 4.5 * 1000000 AS amount, 'LaihKXA47apnS599tyEyasY2REfEzBNe4heunANhsMx' AS contract
UNION ALL
SELECT
'10M LAIKA', 'sideprize_24_10M LAIKA' AS prize, 'Laika' AS token, 10 * 1000000 AS amount, 'LaihKXA47apnS599tyEyasY2REfEzBNe4heunANhsMx' AS contract
UNION ALL
SELECT
'2.5M MOON', 'sideprize_14_2.5M MOON' AS prize, 'MoonCoin' AS token, 2.5 * 1000000 AS amount, 'HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL' AS contract
UNION ALL
SELECT
'5M MOON', 'sideprize_40_5M MOON' AS prize, 'MoonCoin' AS token, 5 * 1000000 AS amount, 'HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL' AS contract
UNION ALL
SELECT
QueryRunArchived: QueryRun has been archived