Darthvader | Flipside Analyst

    Darthvader

    Joined Mar 25, 2022
    //
    30Upvotes
    Query
    01- most gas used
    Total Lent Stablecoins Volume in Algorand
    01-02-01- TOP 10 BLOCK
    ethereumethereum
    evm
    02- Mint TST Token
    06-01- Number of Actions by NU Users
    ethereumethereum
    evm
    01-deposit
    sushisushi
    ethereumethereum
    evm
    dex
    defi
    Table 1. Total Amount Staked ETH Since Beginning
    Table 1. Number of Applications Calls and # of Wallets on Algorand in the First Half of 2022 Compared to the 2nd Half of 2021
    UST's depeg affecting on Swap from stablecoins to other assets
    02- most tx
    03-02-WITHDRAW VS ETH PRICE and scatter
    sushisushi
    ethereumethereum
    optimismoptimism
    swaps
    l2
    03- most FEE
    04-01- FEE, PRICE, TX
    flowflow
    ethereumethereum
    solanasolana
    evm
    Table 1. Total activation and inactivation nodes
    06- pivot most gas used MONTHLY
    Synth Utilisation
    01-15-17
    ethereumethereum
    optimismoptimism
    l2
    evm
    3-Volume of Burned LUNA By Terra Ecosystem on a Weekly Basis
    05- most gas used MONTHLY
    Table 1. Overal States of Bridging 'TO' or 'FROM' Optimism Metrics
    ethereumethereum
    evm
    6-01-top 10 wallets ethereum in amount
    sushisushi
    ethereumethereum
    optimismoptimism
    swaps
    l2
    03-02- L1 WETH Gateway-e2db-DISTINCT WALLETS
    ethereumethereum
    evm
    1- Number of transactions to or from gALGO3
    01-05- L1 ERC20 Gateway-0eec-TOP VOLUME IN USD BY SYMBOL
    ethereumethereum
    evm
    03 -Swapped Asset amount from STBL in Volatile Week
    05-01- Number of Actions by Users
    ethereumethereum
    evm
    05- Popular event Contracts on Flow only on fact_event table
    flowflow
    03- transferred DAI categories
    Velodrome Locks sample query
    optimismoptimism
    l2
    evm
    Borrowing Stablecoins in Algorand on a Weekly Basis
    07-03-total nft sales on 4 hourly basis
    ethereumethereum
    nft
    evm
    Chart 1. Token Allocation of DAI Vault
    1-Volume of Burned LUNA By All Users on a Weekly Basis
    UST's depeg affecting on Swap to stablecoins from other assets
    Table 1. Created New Wallets in May and Those Wallets With More Than 1 ALGO
    03-Swapped from (Separately) QUERY
    06- Daily stablecoins transfer
    Total Block Rewards vs Swap Fees on a Pool Basis
    Table 1- Example of NFT Sales Transactions in Opensea
    polygonpolygon
    evm
    03-Number of Users Staking Algo to Mint gAlgo3 on a Daily Basis