with cte1 AS (

livequery.live.udf_api(

'GET',

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

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

{

'sheets_id' : '1qvNORmqkdAEzJCQHh2RPWbThMDCROxY5p3vRWN7eJGc',

'tab_name' : 'byToken'

}

) as response

, my_data AS (

SELECT

value:date_str::date AS date

, value:pool_token::text AS pool_token

-- , value:increase_calls::integer AS increase_calls

-- , value:inc_users::integer AS inc_users

-- , value:opens::integer AS opens

-- , value:add_collateral_actions::integer AS add_collateral_actions

-- , value:added_collateral::float AS added_collateral

-- , value:long_collateral::float AS long_collateral

-- , value:short_collateral::float AS short_collateral

, value:increase_fees_usd::float AS increase_fees_usd

-- , value:positions::integer AS positions

-- , value:longs::integer AS longs

-- , value:shorts::integer AS shorts

-- , value:inc_position_size_usd::float AS inc_position_size_usd

-- , value:inc_long_position_size_usd::float AS inc_long_position_size_usd

-- , value:inc_short_position_size_usd::float AS inc_short_position_size_usd

-- , value:decrease_calls::integer AS decrease_calls

-- , value:reduce_collateral_actions::integer AS reduce_collateral_actions

-- , value:full_close_actions::integer AS full_close_actions