crypto_edgarLucky Buy Investigation copy
Updated 2023-10-01
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 Lucky Buy Investigation @ https://flipsidecrypto.xyz/edit/queries/f8c7d377-3790-4a9e-985a-fc0c33e76e7a
WITH
-- meegos_mint as (
-- select
-- BLOCK_TIMESTAMP,
-- TX_ID,
-- CASE
-- WHEN ARRAY_SIZE(instructions [1] :accounts) > 1 THEN instructions [1] :accounts [6] :: varchar
-- ELSE instructions [2] :accounts [6] :: varchar
-- END AS MINT,
-- CASE
-- WHEN ARRAY_SIZE(instructions [1] :accounts) > 1 THEN instructions [1] :accounts [5] :: varchar
-- ELSE instructions [2] :accounts [5] :: varchar
-- END AS TX_TO
-- from
-- solana.core.fact_transactions
-- where
-- SUCCEEDED
-- AND BLOCK_TIMESTAMP BETWEEN TIMESTAMP '2023-08-21'
-- AND CURRENT_TIMESTAMP
-- AND (
-- instructions [1] :accounts [3] = 'DYPHVB6gNNHPn1qQzEyQGkZPCVMx3DAKLq8v4n4bjgEp'
-- OR instructions [2] :accounts [3] = 'DYPHVB6gNNHPn1qQzEyQGkZPCVMx3DAKLq8v4n4bjgEp'
-- )
-- AND array_size(INNER_INSTRUCTIONS [0] :instructions) > 1
-- ),
-- reavers_mint as (
-- select
-- BLOCK_TIMESTAMP,
-- TX_ID,
-- instructions [1] :accounts [10] :: varchar AS MINT,
-- instructions [1] :accounts [2] :: varchar AS TX_TO
-- from
-- solana.core.fact_transactions
-- where
-- SUCCEEDED
Run a query to Download Data