picaso | Flipside Analyst

    picaso

    Joined Oct 25, 2024
    //
    79Upvotes
    Query
    -- Swaps per Hour of Day
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    111
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    -- Top 10 Tokens by Input Volume
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    -- Query 1: Overall Analysis of $BRRR Transactions in the Last 3 Months
    nearnear
    lending
    defi
    Active Users
    nearnear
    lending
    defi
    -- Query: User Segmentation Based on USD Value
    nearnear
    lending
    defi
    -- Top 5 Trading Pairs by Swap Count
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    -- Query: Daily Analysis of $BRRR Transactions in the Last 3 Months
    nearnear
    lending
    defi
    silky-harlequin
    inkink
    evm
    -- Query 3: Weekly Trends of $BRRR Transactions in the Last 3 Months
    nearnear
    lending
    defi
    -- Total Volume (USD) in the Last Year
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    preliminary-olive
    nearnear
    -- Daily Volume vs. Swap Count
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    -- Weekly Volume Trend (Input-Based)
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    -- Query: Whales in the Last 1 Year
    nearnear
    lending
    defi
    -- Top 10 Most Active Wallets
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    -- Daily and Cumulative Unique Transactions
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    smooth-ivory
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    competitive-chocolate
    nearnear
    -- Daily Unique Pools
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    User Retention Analysis
    solanasolana
    swaps
    -- Query 4: Top 5 Users by Transaction Volume in the Last 3 Months
    nearnear
    lending
    defi
    abstract-teal
    nearnear
    favourable-blue
    nearnear
    lending
    defi
    -- Query: High-Value Users in the Last 1 Year
    nearnear
    lending
    defi
    -- Average Swap Size (USD)
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    sore-tomato
    inkink
    evm
    vocational-emerald
    nearnear
    independent-teal
    nearnear
    lending
    defi
    Daily Unique Swappers (Last 3 Months)
    solanasolana
    swaps
    -- User Segmentation by Trade Size (USD)
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    -- Query: User Segmentation Based on $BRRR Amount (Updated Ranges)
    nearnear
    lending
    defi
    fascinating-indigo
    nearnear
    -- Top 10 Tokens by Output Volume
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    -- Query: Daily Correlation Between $BRRR Price and Lending Volume
    nearnear
    lending
    defi
    -- Query 6: Analysis of Retail Users (Less Than 100 $BRRR)
    nearnear
    lending
    defi
    coloured-sapphire
    nearnear
    first_transaction_date
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    -- Count of Unique Active Users
    sushisushi
    balancerbalancer
    gnosisgnosis
    curvecurve
    swaps
    -- Query 2: Distribution of Actions (Deposit, Withdraw, etc.) in the Last 3 Months
    nearnear
    lending
    defi