ramishoowtoken.v2.ref-finance.near / meta-pool.near
    Updated 2022-10-25
    select TX_RECEIVER as "names" ,BLOCK_TIMESTAMP::date as "time" , count(distinct TX_HASH) as "Transactions", count(distinct TX_SIGNER)as "Transactors" , sum (TRANSACTION_FEE) /1e18 as "Transaction fees", sum(GAS_USED) /1e18as "Gas used"from near.core.fact_transactions
    where BLOCK_TIMESTAMP::date > CURRENT_DATE - interval '90 days' and (TX_RECEIVER='meta-pool.near' or TX_RECEIVER= 'token.v2.ref-finance.near') group by TX_RECEIVER , BLOCK_TIMESTAMP::date
    Run a query to Download Data