flipside

    Spiltadavid | Flipside Analyst

    Spiltadavid

    Joined Feb 7, 2022
    //
    1Upvotes
    @Arpdavid091 arbi7#0979
    DashboardsQueries
    Query
    Untitled Query
    Untitled Query
    Cumulative Number of Deployed New Contracts
    terraterra
    ibc
    Top 10 tokens in NEAR->Tokens swap since November 4th
    nearnear
    swaps
    defi
    DEFI Staked Users
    solanasolana
    staking
    Top 5 projects of Magic Eden based on volume(from
    solanasolana
    nft
    Trend in the Volume of Sales of NFT over 2022
    ethereumethereum
    nft
    evm
    FIFA+Collect Collection Check
    nft
    algorand
    ETH daily price
    Untitled Query
    osmosisosmosis
    ibc
    total transactions
    ethereumethereum
    evm
    Untitled Query
    with op as( SELECT sum(amount) as optimism_eth, sum(amount_usd) as optimism_eth_usd_volume FROM optimism.core.ez_eth_transfers WHERE block_timestamp >= CURRENT_DATE - 90 ), arb as ( SELECT sum(amount) as arbitrum_eth, sum(amount_usd) as arbitrum_eth_usd_volume FROM arbitrum.core.ez_eth_transfers WHERE block_timestamp >= CURRENT_DATE - 90 ) select o.optimism_eth, o.optimism_eth_usd_volume, a.arbitrum_eth, a.arbitrum_eth_usd_volume from op o JOIN arb a
    arbitrumarbitrum
    optimismoptimism
    l2
    evm
    Depositors and Withdrawers
    uniswapv3uniswapv3
    ethereumethereum
    evm
    dex
    defi
    Average and Median # of Actions
    nearnear
    Untitled Query
    Untitled Query
    increase in total number of users
    nearnear
    Deposit ETH Amount
    makermaker
    ethereumethereum
    mkr
    evm
    defi
    Volume of The Bridges Before and After Collapse
    axelaraxelar
    ibc
    Daily NEAR NFT Sales
    nearnear
    Overtime Markets - Volume
    optimismoptimism
    l2
    evm
    Projects and The No. of Contracts Deployed
    terraterra
    ibc
    Outflows Destinations From FTX To Ethereum (By TX Count)
    ethereumethereum
    evm
    555
    osmosisosmosis
    ibc
    Axellar holders
    axelaraxelar
    ibc
    Daily number of unique users that transfer to-from airswap
    ethereumethereum
    evm
    Daily Number of Transactions & Users
    gnosisgnosis
    evm
    Tokens Swapped To
    solanasolana
    swaps
    Untitled Query
    succeeded rate in orca
    solanasolana
    swaps
    Axelar Scavenger Hunt2
    osmosisosmosis
    ibc
    Average Time (Days) Between Bridges Breakdown by Destination Chain (Axelar Satelite)
    axelaraxelar
    ibc
    step95 : deposite asset to Bentobox and borrowing
    Untitled Query
    Flow NFT Collections by Buyers and Sales Volume
    flowflow
    nft
    Untitled Query
    Users Staking Behaviour on Solana Before and After FTX Saga
    solanasolana
    staking
    Untitled Query
    bscbsc
    ethereumethereum
    avalancheavalanche
    polygonpolygon
    evm
    Daily "bridge out" active users
    terraterra
    ibc