flipside

    mercury | Flipside Analyst

    mercury

    Joined Oct 5, 2021
    //
    61Upvotes
    @PiroozTrader @piroozman mercury#8660
    DashboardsQueries
    Query
    B - Where LDO come from
    10. nft sale
    terraterra
    ibc
    Top 50 dApps Based on # of transactions scaler
    avalancheavalanche
    evm
    Table 1. Total Wallets Buying NFTs from AB2 Gallery
    Amount bLUNA and bETH is locked as collateral on Anchor Table
    03- daily # of neth accounts transactions
    nearnear
    AlgoFi's AlgoVault Governance Period 3
    01-02-total number of selling
    ethereumethereum
    nft
    evm
    02-04. IBC TO other Chains on a selected time basis
    osmosisosmosis
    ibc
    22-01 top 20 wallets in number of token transfer
    ethereumethereum
    nft
    evm
    08- Realtion Between Algo Pirce and Volume
    21-02. top 20 to wallets in transfer
    ethereumethereum
    nft
    evm
    03-04- order delegates by Average delegated volume
    arbitrumarbitrum
    ethereumethereum
    l2
    evm
    Total Amount of ALGO Collateral Currently Backing the GARD
    Table 2. New Listed Assets on Selected Time Period
    osmosisosmosis
    ibc
    defi
    15- Crossover "NFT Store Front" Sellers/ "Top Shot Market V3" Sellers
    flowflow
    02- trending nft projects based on number of transactions (DapperUtilityCoin)
    flowflow
    07-01-staking (46-49)
    optimismoptimism
    velodrome
    l2
    evm
    dex
    Non-Native vs Native Swaps Fee Grouping by Month (USD)
    04-01- distribution fees in contracts (only in event log)
    ethereumethereum
    avalancheavalanche
    evm
    04-02- distribution fees in contracts (only in contracts table)
    ethereumethereum
    avalancheavalanche
    evm
    06-02- total second action after first action: swap to
    osmosisosmosis
    swaps
    staking
    ibc
    01-2-daily popular dex by transactions copy
    seisei
    swaps
    ibc
    05-01-pools
    osmosisosmosis
    ibc
    3- What are the top 10 most popular to swap FROM or TO gALGO3?
    Table 2. Overall NFT Sales States Grouped By Symbol
    ethereumethereum
    nft
    evm
    10- Top 5 Buyer/Seller on TopShotMarketV3 Marketplace
    flowflow
    02- Swap ATOM To OSMO
    osmosisosmosis
    ibc
    Swap ETH to DPX on Arbitrum Network
    01-daily neth accounts
    nearnear
    03- Top 10 Assets Volume Swapped from USDt(.e)
    nearnear
    swaps
    defi
    01-01-buying and selling cycle
    ethereumethereum
    nft
    evm
    02- total accounts in near
    nearnear
    Sender Distribution by Platform Count
    kyberswap
    woofi
    hashflow
    trader joe
    swaps
    Results of Query to Your Trades Over Time (only last 365 records)
    kyberswap
    woofi
    hashflow
    trader joe
    swaps
    01-01-txs and events
    arbitrumarbitrum
    optimismoptimism
    polygonpolygon
    l2
    evm
    Table 3. Statistic Summary of Transactions Status for some Networks Since 2022-05-09
    flowflow
    ethereumethereum
    evm
    04- Top 10 Wallets Rand Gallery-algo and usd
    06- GROUP BY PURCHASER
    solanasolana
    nft
    Top 15 Pools Based on Traded Volume
    kyberswap
    woofi
    hashflow
    trader joe
    swaps