pool_name, fee_percent, token0_address, token1_address,

token0_symbol, token1_symbol, token0_name, token1_name,

token0_decimals, token1_decimals

from ethereum.uniswapv3.ez_pools

select block_timestamp::date as date, count(distinct block_id) as blocks, min(block_id) as min_block, max(block_id) as max_block, sum(fee) as fees, count(tx_id) as txns

from solana.core.fact_transactions

where block_timestamp >= '2023-01-01'

and succeeded = True

group by block_timestamp::date

order by date desc

limit 7