StangFASTbase-05-part3
    Updated 2023-09-27
    -- 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