with price as (select

d.value:"DAY" as day,

d.value:"Greed price" as greed_price

from (

select livequery.live.udf_api(

'https://flipsidecrypto.xyz/api/v1/queries/2cebaa4b-5d80-4982-88b7-61f59c6d11a6/data/latest'

):"data" as data

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

select

count(distinct ORIGIN_FROM_ADDRESS) as players,

sum(amount) as spend_greed,

sum((amount*greed_price)) as spend_usd,

avg((amount*greed_price)) as avg_spend,

spend_usd/players as avg_usd_per_player,

spend_usd / count(distinct BLOCK_TIMESTAMP::date) as avg_spend_per_day

from blast.core.ez_token_transfers s

left join price p on s.block_timestamp::date = p.day

where CONTRACT_ADDRESS = '0xe6a062fba3918376500a602c800b1e0307420457'

and SYMBOL = 'GREED'

and TO_ADDRESS = '0x0000000000000000000000000000000000000000'