case when currency_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then price / pow(10,18) else price end as volume_a,

from ethereum.core.ez_nft_sales

where block_timestamp >= CURRENT_TIMESTAMP - interval '24 hours'

and nft_address = '0x595a8974c1473717c4b5d456350cd594d9bda687'

order by block_timestamp