gsheet AS (

SELECT

livequery.live.udf_api(

'GET',

'https://science.flipsidecrypto.xyz/googlesheets/readsheet',

{ 'Content-Type': 'application/json' },

{ 'sheets_id': '1m2mul3uqGcjYA7RCoUnhLNpRaxNwQH2-P9BzxoZS4gM',

'tab_name': 'ETF' }

) as result

from

dual

),

label as (

select

value:"issuer" :: varchar as issuer,

value:"symbol" :: varchar as symbol,

value:"add" :: varchar as

add

from

gsheet,

lateral flatten (input => result:data)

),

data as (

select

block_timestamp,

'out' as event,

0 - value as value,

pubkey_script_address,

tx_id

from

bitcoin.core.fact_inputs