ramishoowUntitled Query
    Updated 2022-10-19
    select count(*) as "count", tx_receiver as "Transactions of each DEX "from near.core.fact_transactions
    where tx_receiver in ('v2.ref-finance.near','v2.perp.spin-fi.near','spot.spin-fi.near','v1.pembrock.near','boostfarm.ref-labs.near','staking.v1.pembrock.near',
    'token.v2.ref-finance.near','near','meta-pool.near','contract.main.burrow.near','v1.jumbo_exchange.near','claiming-v1.jumbo_exchange.near',
    'linear-protocol.near','xtoken.ref-finance.near','token.jumbo_exchange.near','farming-v1.jumbo_exchange.near','v2-nearx.stader-labs.near',
    'nearx.stader-labs.near','rewards.v1.pembrock.near','v3.oin_finance.near','ref-finance.sputnik-dao.near','nearx-price-feed.stader-labs.near')
    and block_timestamp::date > getdate() - interval '3 month' group by 2
    Run a query to Download Data