SELECT

COUNT(DISTINCT tx_hash) AS uniswap_tx_count,

DATE_TRUNC('month', block_timestamp) AS month

FROM crosschain.defi.ez_dex_swaps

WHERE platform like 'uniswap%'

AND blockchain = 'ethereum'

AND block_timestamp >= '2020-01-01'

GROUP BY month

),

eth_txs AS (

SELECT

DATE_TRUNC('month', block_timestamp_hour) AS month,

SUM(transaction_count_success) AS eth_tx_count

FROM crosschain.stats.ez_core_metrics_hourly

WHERE blockchain = 'ethereum'

AND block_timestamp_hour >= '2020-01-01'

GROUP BY month

SELECT

u_eth.month,

eth.eth_tx_count,

u_eth.uniswap_tx_count,

(u_eth.uniswap_tx_count::float / eth.eth_tx_count::float) * 100 AS uniswap_eth_market_share

FROM uniswap_eth u_eth

LEFT JOIN eth_txs eth ON u_eth.month = eth.month

ORDER BY u_eth.month;