WITH r4_prices AS (

--*

date_trunc('hour', block_timestamp) as date,

----------------------------------------------------

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

AND (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) / inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount > 0.0001

AND (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) / inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount < 0.01

then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount)

end) as fuel_atlas_amount,

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

AND (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) / inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount > 0.0001

AND (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) / inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount < 0.01

then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount

end) as fuel_amount,

fuel_atlas_amount / fuel_amount as fuel_price,

--------------------------------------------------------------

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG'

AND (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) / inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount > 0.0001

AND (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) / inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount < 0.01

then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount)

end) as food_atlas_amount,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG'

AND (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) / inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount > 0.0001

AND (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) / inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount < 0.01

then inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount

end) as food_amount,

food_atlas_amount / food_amount as food_price,

--------------------------------------------------------------

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK'

AND (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) / inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount > 0.0001

AND (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount) / inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount < 0.1

then (inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount + inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount)

end) as ammo_atlas_amount,

sum(case when inner_instruction:instructions[2]:parsed:info:mint::string = 'ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK'