CASE

WHEN contract_value = 'terra1lxx40s29qvkrcj8fsa3yzyehy7w50umdvvnls2r830rys6lu2zns63eelv' THEN 'ROAR'

WHEN contract_value = 'terra1rc6ssp5rym7a0hg29xpj4cc9e67tl56kg5jyzgl9qrhfxxc2ugvsnrkala' THEN 'SEAS'

WHEN contract_value = 'terra1nsuqsk6kh58ulczatwev87ttq2z6r3pusulg9r24mfj2fvtzd4uq3exn26' THEN 'ASTRO'

WHEN contract_value = 'terra1e9s5m6vrl9ms75q0862llq2vcsz8r43czm36s6xnn3vh8dfmwe0s3c86e8' THEN 'xTPT'

WHEN contract_value = 'terra1gy73st560m2j0esw5c5rjmr899hvtv4rhh4seeajt3clfhr4aupszjss4j' THEN 'VKR'

WHEN contract_value = 'terra1t4p3u8khpd7f8qzurwyafxt648dya6mp6vur3vaapswt6m24gkuqrfdhar' THEN 'CAPA'

WHEN contract_value = 'terra1564y9uxzhast8sk5n47teypy4mxy7fg5vne2msuztsft7qk3pj9sxxuxmc' THEN 'TFLOKI'

WHEN contract_value = 'terra1yrxlwkpf42uz646puplelpsflhwsz6fqfayr96xrhmjy9vysgluqc9qp56' THEN 'bUST'

WHEN contract_value = 'terra17gck626vgax9jpe6utm7dhx4vdzawfkt0jhru03l7a3dzu98wedsfad4sz' THEN 'dUST'

WHEN contract_value = 'terra1x62mjnme4y0rdnag3r8rfgjuutsqlkkyuh4ndgex0wl3wue25uksau39q8' THEN 'xASTRO'

WHEN contract_value = 'terra13j2k5rfkg0qhk58vz63cze0uze4hwswlrfnm0fa4rnyggjyfrcnqcrs5z2' THEN 'TPT'

WHEN contract_value = 'terra1x4fj4j5pu0pw65efl67ch400pfhmdxk0y2gmhqupep0laegkvzlqlap2wl' THEN 'DOCS'

WHEN contract_value = 'terra1hfvehvkj2hejuj2almw2h5m7vmehwl8lzpljwksxcdlujkcerhzqgfvdzv' THEN 'LAT'

WHEN contract_value = 'uluna' THEN 'LUNA'

ELSE contract_value

END as token_claimed,

COUNT(DISTINCT TX_ID) as claims,

SUM(amount_value)/1000000 as claim_amount

((SELECT

block_id,

block_timestamp,

contract_tx_id as tx_id,

CAST(contract_value as text) as contract_value,

CAST(action_value as text) as action_value,

CAST(amount_value as int) as amount_value

block_id,

block_timestamp,

tx_id as contract_tx_id,

a.key as contract_key,

SPLIT_PART(contract_key, '_', -1) AS contract_index,

a.value as contract_value