flipside

    1
    yasmin-n-d-r-h1
    Updated 2022-07-22
    SELECT DATE_TRUNC('day', BLOCK_TIMESTAMP) as date, TX_RECEIVER as
    contract,COUNT(TXN_HASH) as total_TX,
    sum(TRANSACTION_FEE/pow(10,24)) as FEE
    FROM flipside_prod_db.mdao_near.transactions
    WHERE date >= DATEADD(MONTH, -1, GETDATE())
    GROUP BY date, contract
    HAVING FEE> 10



    Run a query to Download Data