with token_prices AS (

SELECT token_address

, symbol

, hour

, price AS price_usd

FROM ethereum.core.fact_hourly_token_prices

),

token_transfers AS (

SELECT tx_hash

, count(*) AS transfers

FROM ethereum.core.ez_token_transfers

GROUP BY tx_hash

HAVING transfers > 2

),

lending_pools AS (

SELECT DISTINCT lending_pool_address FROM ethereum.sushi.ez_borrowing

UNION

SELECT DISTINCT lending_pool_address FROM ethereum.sushi.ez_lending

),

token_supply AS (

SELECT contract_address

, symbol

, sum(amount) AS supply

FROM (

SELECT contract_address

, symbol

, sum(amount) AS amount

FROM ethereum.core.ez_token_transfers

WHERE contract_address IN (SELECT lending_pool_address FROM lending_pools)

AND from_address = '0x0000000000000000000000000000000000000000'

GROUP BY 1,2