SYMBOL,

sum(FLASHLOAN_AMOUNT_USD) as loan_volume,

sum(PREMIUM_AMOUNT_USD) as fee_volume,

count(DISTINCT TX_ID) as loans

FROM flipside_prod_db.aave.flashloans

WHERE block_timestamp > '2022-01-01'

GROUP BY 1