ramishoowUntitled Query
Updated 2022-10-19
9
1
2
3
4
5
6
›
⌄
select count(distinct tx_signer) "user", 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