(SELECT date(block_timestamp) as day, count(*) as total_txs

from mdao_harmony.txs

-- where token_name = 'ONE'

GROUP by 1 )

SELECT * from

(SELECT date(timestamp) as day_, avg(price) as avg_price

from mdao_harmony.tokenprice_one

GROUP by 1 )

inner join dailY_txs

on day = day_

LIMIT 100