select

--*

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

sum(case when value:instructions[2]:parsed:info:mint = 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim'

AND value:instructions[2]:parsed:info:authority != 'NPCxfjPxh6pvRJbGbWZjxfkqWfGBvKkqPbtiJar3mom'

then value:instructions[2]:parsed:info:tokenAmount:uiAmount end) AS fuel_bought,

sum(case when value:instructions[1]:parsed:info:mint = 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim'

then value:instructions[1]:parsed:info:tokenAmount:uiAmount end) AS fuel_sold,

fuel_bought - zeroifnull(fuel_sold) AS fuel_bought_net

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

WHERE (instructions[0]:programId::string = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg'

OR instructions[1]:programId::string = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg')

AND succeeded = 'true'

AND block_timestamp >= '2022-07-22' AND block_timestamp < '2022-10-01'

group by 1

order by 1 desc

),

fuel_pre as (

select

--*

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

sum(value:uiTokenAmount:uiAmount) AS fuel_pre

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

WHERE (instructions[0]:programId::string = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW'

OR instructions[1]:programId::string = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW'

OR instructions[2]:programId::string = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW'

OR instructions[3]:programId::string = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW')