select min(block_number), max(block_number)

from ethereum.defi.ez_dex_swaps

select block_number

, sum(amount_usd) as lending_amount_usd

, count(distinct borrower) as lending_borrower_count

from ethereum.defi.ez_lending_borrows

where block_number >= 18151921

and block_number <=18251921

group by block_number

select block_number

, sum(amount_usd) as liq_amount_usd

, count(distinct borrower) as liq_borrower_count

from ethereum.defi.ez_lending_liquidations

where block_number >= 18151921

and block_number <=18251921

group by block_number

select s.block_number

, sum(s.total_fees_usd) as nft_total_fees_usd

, count(distinct s.buyer_address) as nft_buyer_count

, count(distinct s.seller_address) as nft_seller_count

, sum(m.nft_count) as nft_mint_count

, count(distinct m.nft_to_address) as nft_mint_to_count

from ethereum.nft.ez_nft_sales s

join ethereum.nft.ez_nft_mints m on m.block_number=s.block_number

where s.block_number >= 7711117

and s.block_number <=18251921

group by s.block_number

order by s.block_number asc