flipside

    Try Quests to earn FLOWTry Quests to earn FLOW
    Share

    Swaps activity on Flow

    This dashboard covers the daily swap activity on Flow blockchain according to the specified parameter days_back (by default 180 days).

    Introduction:

    Flow is a fast, decentralized and developer-friendly blockchain, purposely built to support decentralized apps (DApps), games and the digital assets they run on. It’s designed for scalability and faster speed without sharding techniques, which makes it ideal for crypto-based games and NFT collectibles. learn more

    Swapping refers to exchanging a cryptocurrency that you already have into a different one.

    This dashboard tracks the swap activity on Flow blockchain on daily basis. During the analysis I'll dive into the following activity metrics:

    • swapped volume USD
    • number of swaps
    • unique and new users
    • median and average swap amount
    • swaps per user

    In addition, I have provided a breakdown of users and tokens by different metrics and examined how this breakdown has changed over time.

    Methodology:

    To perform this dashboard I have used Flipside flow.core.ez_swaps and flow.core.fact_hourly_prices tables from the Flow scheme.

    flow.core.ez_swaps table contains all the swap activities. For analysing the amount of swapped tokens in USD we need to pull up the daily average token prices from flow.core.fact_hourly_prices.

    New users were defined by their first date of interacting with swap protocols using min(block_timestamp) statement within the all swaps in the table.