select

--*

--/*

date_trunc('day', block_timestamp::date) as date,

sum(case when value:parsed:info:destination::string = '9XG3rmbcJD7BDp9G4cF3z5oXdqR7WJwfRz9PCFEcNM9a'

then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) as DAO_USDC,

sum(DAO_USDC) over (order by date) as DAO_USDC_cum,

sum(case when value:parsed:info:destination::string = 'GT4m62ZDFVSQDXqBpQby5rYxs53CTw3LamzE9wxR2YLv'

AND date = '2022-10-07'

then value:parsed:info:tokenAmount:uiAmount + 254767457.22

ELSE value:parsed:info:tokenAmount:uiAmount end) as DAO_ATLAS1,

sum(case when value:parsed:info:destination::string = '3mZq4Q6CoeMuws6iAbBtXUAxhbXxAUw5tBQkSHScpKKx'

then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) as DAO_ATLAS2,

DAO_ATLAS1 + DAO_ATLAS2 as DAO_ATLAS3,

sum(DAO_ATLAS3) over (order by date) as DAO_ATLAS_cum

--*/

from solana.core.fact_transactions, lateral flatten(input => instructions)

WHERE value:parsed:info:authority::string IN ('feesQYAaH3wjGUUQYD959mmi5pY8HSz3F5C3SVc1fp3', 'NPCxfjPxh6pvRJbGbWZjxfkqWfGBvKkqPbtiJar3mom')

--AND tx_id = '4RabDUwiiWSQFUUF9Sa8jEjtfitUivJYh9xvXPi5iDUhnVJvYHBTNFWbkG6pr8JwwKsYnBES6AFoJFSN6cKhfwLp'

AND succeeded = 'true'

AND value:parsed:info:destination::string IN ('9XG3rmbcJD7BDp9G4cF3z5oXdqR7WJwfRz9PCFEcNM9a', 'GT4m62ZDFVSQDXqBpQby5rYxs53CTw3LamzE9wxR2YLv', '3mZq4Q6CoeMuws6iAbBtXUAxhbXxAUw5tBQkSHScpKKx')

AND block_timestamp > '2022-10-07' AND block_timestamp < '2023-01-01'

group by 1

order by 1 desc

),

atlas_price as (

select

date_trunc('day', block_timestamp::date) as date,

sum(swap_from_amount) as value_from,

sum(swap_to_amount) as value_to,

value_to / value_from as avg_atlas_price