mercury | Flipside Analyst

    mercury

    Joined Oct 5, 2021
    //
    61Upvotes
    Query
    Top 20 Trader by # of Swaps
    kyberswap
    woofi
    hashflow
    trader joe
    swaps
    3-2 comparison flow with ethereum
    cosmoscosmos
    flowflow
    ethereumethereum
    avalancheavalanche
    ibc
    01- overall for platforms and pool copy
    kyberswap
    woofi
    hashflow
    trader joe
    swaps
    02- Transactions data over time
    avalancheavalanche
    evm
    Top 50 dApps Based on # of Active Users
    avalancheavalanche
    evm
    6-2-2. ratio burn and mint Charts on a selected time Granularity (17-20)
    avalancheavalanche
    evm
    2-2-1. Swap and Transfer Charts on a selected time Granularity (1-6:1)
    avalancheavalanche
    evm
    5-2. top 10 transfer volume
    avalancheavalanche
    evm
    04-top 20 pools by # of volume
    kyberswap
    woofi
    hashflow
    trader joe
    swaps
    Top 50 Contracts Based on Contracts Fees
    avalancheavalanche
    evm
    Top 50 dApps Based on # of transactions scaler
    avalancheavalanche
    evm
    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
    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
    Top 15 Pools Based on Traded Volume
    kyberswap
    woofi
    hashflow
    trader joe
    swaps
    04-top 20 symbol out by volume
    kyberswap
    woofi
    hashflow
    trader joe
    swaps
    Top 50 Contracts Based on # of New Users
    avalancheavalanche
    evm
    Table 1. Number of Contracts types (Addresses) in Avalanche
    avalancheavalanche
    evm
    8-1. top 10 mint transactions
    avalancheavalanche
    evm
    04-03- distribution fees in contracts over time (Based on Event Log Table)
    ethereumethereum
    avalancheavalanche
    evm
    Over Time for symbol out
    kyberswap
    woofi
    hashflow
    trader joe
    swaps
    1-2- Specific Contract Over Time
    ethereumethereum
    avalancheavalanche
    evm
    04-04- distribution fees in contracts over time (Based on Contracts Table)
    ethereumethereum
    avalancheavalanche
    evm
    01-top 15 pools-platform by # of swaps
    kyberswap
    woofi
    hashflow
    trader joe
    swaps
    5-1. top 10 transfer transactions
    avalancheavalanche
    evm
    05-02- distribution fees in dapps contracts over tiem
    ethereumethereum
    avalancheavalanche
    evm
    Top 15 Symbols OUT by Volume
    kyberswap
    woofi
    hashflow
    trader joe
    swaps
    Top 50 Contracts Based on # of Active Users
    avalancheavalanche
    evm
    03-top 20 pools by # of senders
    kyberswap
    woofi
    hashflow
    trader joe
    swaps
    07. Mint and Burn Charts on a Daily Basis(11-16:2)
    avalancheavalanche
    evm
    2-1-1. average Swap and Transfer on a selected time Granularity
    avalancheavalanche
    evm
    Table 5. Top 20 Contracts by # of Active Wallets on Contracts
    ethereumethereum
    avalancheavalanche
    evm
    11-1. Mint Distribution
    avalancheavalanche
    evm
    Top 50 dApps Based on # of New Users
    avalancheavalanche
    evm
    1-2- Specific dapp Over Time
    ethereumethereum
    avalancheavalanche
    evm
    Table 2. Overall States of Mint and Burn USDC in Avalanche Network
    avalancheavalanche
    evm
    Table 4. Top 20 Contracts by Average Generated Fees
    ethereumethereum
    avalancheavalanche
    evm
    Over Time for pools
    kyberswap
    woofi
    hashflow
    trader joe
    swaps
    Table 14. Top 20 Users by Generated Fees on Specific dApp Contract(s)
    ethereumethereum
    avalancheavalanche
    evm