select date(block_timestamp) as the_date, count(*) num_trans, sum(amount)*50 total_sales_matic, sum(amount_usd)*50 total_sales_usd,
avg(amount)*50 avg_matic_sales from polygon.core.ez_matic_transfers where MATIC_FROM_ADDRESS='0xdef1c0ded9bec7f1a1670819833240f027b25eff'
and MATIC_TO_ADDRESS='0xca9337244b5f04cb946391bc8b8a980e988f9a6a'
and block_timestamp > '2022-11-01'
group by the_date