select

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

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

sum(case when value:parsed:info:mint::string = 'ARCoQ9dndpg6wE2rRexzfwgJR3NoWWhpcww3xQcQLukg'

AND value:parsed:type = 'burn'

then value:parsed:info:amount

end) as ARCO_burn_amount,

sum(case when value:parsed:info:mint::string = 'MASS9GqtJz6ABisAxcUn3FeR4phMqH1XfG6LPKJePog'

AND value:parsed:type = 'burn'

then value:parsed:info:amount

end) as BIOMASS_burn_amount,

sum(case when value:parsed:info:mint::string = 'CARBWKWvxEuMcq3MqCxYfi7UoFVpL9c4rsQS99tw6i4X'

AND value:parsed:type = 'burn'

then value:parsed:info:amount

end) as CARBON_burn_amount,

sum(case when value:parsed:info:mint::string = 'CUore1tNkiubxSwDEtLc3Ybs1xfWLs8uGjyydUYZ25xc'

AND value:parsed:type = 'burn'

then value:parsed:info:amount

end) as CUORE_burn_amount,

sum(case when value:parsed:info:mint::string = 'DMNDKqygEN3WXKVrAD4ofkYBc4CKNRhFUbXP4VK7a944'

AND value:parsed:type = 'burn'

then value:parsed:info:amount

end) as DIAMOND_burn_amount,

sum(case when value:parsed:info:mint::string = 'HYDR4EPHJcDPcaLYUcNCtrXUdt1PnaN4MvE655pevBYp'

AND value:parsed:type = 'burn'

then value:parsed:info:amount

end) as HYG_burn_amount,

sum(case when value:parsed:info:mint::string = 'FeorejFjRRAfusN9Fg3WjEZ1dRCf74o6xwT5vDt3R34J'

AND value:parsed:type = 'burn'

then value:parsed:info:amount

end) as FEORE_burn_amount,

sum(case when value:parsed:info:mint::string = 'LUMACqD5LaKjs1AeuJYToybasTXoYQ7YkxJEc4jowNj'

AND value:parsed:type = 'burn'

then value:parsed:info:amount

end) as LUMAN_burn_amount,