select

--*

DATE(block_timestamp) AS date,

sum(case when value:parsed:info:authority = signers[0]::string

AND value:parsed:info:mint = 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim'

AND value:parsed:type = 'transferChecked'

then value:parsed:info:tokenAmount:uiAmount

when value:parsed:info:authority != signers[0]::string

AND value:parsed:info:mint = 'fueL3hBZjLLLJHiFH9cqZoozTG3XQZ53diwFPwbzNim'

AND value:parsed:type = 'transferChecked'

then value:parsed:info:tokenAmount:uiAmount*-1 end) AS fuel_refill,

sum(case when value:parsed:info:authority = signers[0]::string

AND value:parsed:info:mint = 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG'

AND value:parsed:type = 'transferChecked'

then value:parsed:info:tokenAmount:uiAmount

when value:parsed:info:authority != signers[0]::string

AND value:parsed:info:mint = 'foodQJAztMzX1DKpLaiounNe2BDMds5RNuPC6jsNrDG'

AND value:parsed:type = 'transferChecked'

then value:parsed:info:tokenAmount:uiAmount*-1 end) AS food_refill,

sum(case when value:parsed:info:authority = signers[0]::string

AND value:parsed:info:mint = 'ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK'

AND value:parsed:type = 'transferChecked'

then value:parsed:info:tokenAmount:uiAmount

when value:parsed:info:authority != signers[0]::string

AND value:parsed:info:mint = 'ammoK8AkX2wnebQb35cDAZtTkvsXQbi82cGeTnUvvfK'

AND value:parsed:type = 'transferChecked'

then value:parsed:info:tokenAmount:uiAmount*-1 end) AS ammo_refill,

sum(case when value:parsed:info:authority = signers[0]::string

AND value:parsed:info:mint = 'tooLsNYLiVqzg8o4m3L2Uetbn62mvMWRqkog6PQeYKL'

then value:parsed:info:tokenAmount:uiAmount

when value:parsed:info:authority != signers[0]::string

AND value:parsed:info:mint = 'tooLsNYLiVqzg8o4m3L2Uetbn62mvMWRqkog6PQeYKL'

then value:parsed:info:tokenAmount:uiAmount*-1 end) AS tool_refill,

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

avg(fuel_refill) over (order by date rows between 6 preceding and current row) as avg_fuel_refill,