block_timestamp::date as _date,

count(tokenid) as num_moonbirds_minted,

sum(mint_price_usd) as total_usd_spent,

sum(mint_price_eth) as total_eth_spent,

sum(TX_FEE) as total_gas_paid

FROM ethereum.core.ez_nft_mints

WHERE nft_address = lower('0x23581767a106ae21c074b2276D25e5C3e136a68b')

GROUP BY _date

ORDER BY num_moonbirds_minted DESC