flipside

    picaso | Flipside Analyst

    picaso

    Joined Oct 25, 2024
    //
    149Upvotes
    @missohared picaso.eth
    DashboardsQueries
    Query
    query 5 Temporal Patterns Analysis
    nearnear
    swaps
    defi
    Largest Lockup Deposit Account
    nearnear
    staking
    governance
    Total Transaction Count and Volume USD
    nearnear
    -- Weekly Stake and Unstake User and Transaction Counts on MetaPool (6-Month Data)
    nearnear
    -- Query 1: Overall Analysis of $BRRR Transactions in the Last 3 Months
    nearnear
    lending
    defi
    Top 5 Bridges on NEAR by Transaction Count and Value
    nearnear
    defi
    bridging
    Total Staking Balance Over Time
    nearnear
    staking
    governance
    -- Query: Daily Analysis of $BRRR Transactions in the Last 3 Months
    nearnear
    lending
    defi
    -- Query 3: Weekly Trends of $BRRR Transactions in the Last 3 Months
    nearnear
    lending
    defi
    -- Daily Stake and Unstake Percentages on TruFin Protocol (6-Month Data)
    nearnear
    -- User Distribution by Staking Tiers on Linear Protocol (6-Month Data)
    nearnear
    Transaction Success and Failure Rates (weekly)
    nearnear
    query 4 Pool Performance Analysis
    nearnear
    swaps
    defi
    query 7 hours
    nearnear
    swaps
    defi
    -- Top 10 Stakers on Linear Protocol (6-Month Data)
    nearnear
    Correlation Between Staking Balance and Lockup Actions
    nearnear
    staking
    governance
    -- Query 4: Top 5 Users by Transaction Volume in the Last 3 Months
    nearnear
    lending
    defi
    -- Weekly Stake, Unstake, and Reward Activity on MetaPool (6-Month Data)
    nearnear
    Number of Unique Addresses (From 2024)
    nearnear
    staking
    governance
    Average Staking Balance Per Address
    nearnear
    staking
    governance
    favourable-blue
    nearnear
    lending
    defi
    daily tvl and cumulative
    nearnear
    -- Weekly Stake and Unstake User and Transaction Counts on Linear Protocol (6-Month Data)
    nearnear
    vocational-emerald
    nearnear
    Platforms and Chains by Transaction Volume and Success Rate
    nearnear
    defi
    bridging
    Weekly Changes and Volume Comparison
    nearnear
    swaps
    defi
    Total Dolphin Transactions
    nearnear
    swaps
    defi
    suspicious-beige
    nearnear
    defi
    bridging
    -- Daily Stake and Unstake Percentages on Linear Protocol (6-Month Data)
    nearnear
    Average Lockup Deposit Per Account
    nearnear
    staking
    governance
    -- Weekly Stake, Unstake, and Reward Activity on Linear Protocol (6-Month Data)
    nearnear
    Daily Total Staking Balance in 2024
    nearnear
    staking
    governance
    query 11 general stat
    nearnear
    swaps
    defi
    -- Query: Daily Correlation Between $BRRR Price and Lending Volume
    nearnear
    lending
    defi
    intents and normal transaction
    nearnear
    parliamentary-salmon
    nearnear
    -- User Distribution by Staking Tiers on MetaPool (6-Month Data)
    nearnear
    Top Dolphin Traders' Most Swapped Token Pairs
    nearnear
    swaps
    defi
    coloured-sapphire
    nearnear
    -- Query 2: Distribution of Actions (Deposit, Withdraw, etc.) in the Last 3 Months
    nearnear
    lending
    defi