tab1 AS

SELECT

a.value:"rank"::string AS "rank"

, a.value:"address"::string AS "address"

, a.value:"owner"::string AS "owner"

, a.value:"amount"::integer / power( 10 , 6 ) AS "amount"

FROM

(

SELECT livequery.live.udf_api( 'https://public-api.solscan.io/token/holders?tokenAddress=BaoawH9p2J8yUK9r5YXQs3hQwmUJgscACjmTkh8rMwYL&limit=100&offset=0' ):"data":"data" AS data

) live

JOIN

lateral flatten ( input => live.data ) a

ORDER BY 1 ASC

,

tab2 AS

SELECT

a.value / power( 10 , 6 ) AS "supply"

FROM

(

SELECT livequery.live.udf_api( 'https://public-api.solscan.io/token/meta?tokenAddress=BaoawH9p2J8yUK9r5YXQs3hQwmUJgscACjmTkh8rMwYL' ):"data" AS data

) live

JOIN

lateral flatten ( input => live.data ) a

WHERE

a.key = 'supply'

,

tab3 AS

SELECT