StangFASTbase-05-part3
Updated 2023-09-27
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
›
⌄
-- forked from base-05-part2 @ https://flipsidecrypto.xyz/edit/queries/7247fda8-f29e-48a9-83e2-2a955135ded1
-- forked from base-05 @ https://flipsidecrypto.xyz/edit/queries/1a1ce85e-d875-40d7-88a2-3902aee4a06a
-- forked from base-02-part3 @ https://flipsidecrypto.xyz/edit/queries/838ff35e-7bc6-4ef9-8255-54114f0350fa
-- forked from base-02 @ https://flipsidecrypto.xyz/edit/queries/2934b49b-7e7a-4b2a-be0b-781e4e7accce
-- forked from base-01 @ https://flipsidecrypto.xyz/edit/queries/222502d4-4183-4b9e-845b-7ffba5f83ffd
SELECT
a.block_timestamp AS bt
, a.signers[0] AS us
, a.tx_id AS tx
, split( split( b.value , '.' )[0] , ' ' )[ array_size( split( split( b.value , '.' )[0], ' ' ) ) - 1 ] AS nm
, split( b.value , '.' )[1] AS dm
, case
when dm = 'bonk' then 'BONK'
when dm = 'superteam' then 'SFT'
when dm = 'monke' then 'MONKECLAIM'
else 'SOL'
end
AS tk
, length( nm )
AS ch
, case
when dm = 'bonk' then 69000000
when dm = 'monke' then 1
else d.amount
end
AS am
Run a query to Download Data