ORIGIN_FROM_ADDRESS as player,

min(BLOCK_TIMESTAMP) as first_spin,

count(distinct tx_hash) as no_deposits,

sum(AMOUNT) as vol_ETH,

sum(AMOUNT_USD) as vol_usd

from blast.core.ez_native_transfers

where ORIGIN_TO_ADDRESS = '0x965d03b148e82e8c99049bfcdc85ee360e0315b1'

and IDENTIFIER = 'CALL_ORIGIN'

group by 1

),

tb2 as (select

ORIGIN_FROM_ADDRESS as player,

count(distinct tx_hash) as no_claims,

sum(AMOUNT) as prize_ETH,

sum(AMOUNT_USD) as prize_usd

from blast.core.ez_native_transfers

where ORIGIN_TO_ADDRESS = '0x965d03b148e82e8c99049bfcdc85ee360e0315b1'

and IDENTIFIER = 'CALL_0_0'

and ORIGIN_TO_ADDRESS = FROM_ADDRESS

group by 1

),

balls as (with raw as (select

d.value as raw_date

from(

select livequery.live.udf_api (

'https://api.blastballoon.xyz/v1/user/all?limit=5000&page=1&key=E5Qah2lniqErFXxhEk0ELRkpWziUwd6EcGjY1tJ4evQ%3D'

) as data

) responses join lateral flatten (input => responses.data:data) d