flipside

    nvalkov | Flipside Analyst

    nvalkov

    Joined Nov 22, 2022
    //
    0Upvotes
    DashboardsQueries
    Query
    15.02 Meme Lab by 6529 - Card 3 All Tra
    ethereumethereum
    nft
    evm
    29.01 My first 6529 mint
    ethereumethereum
    nft
    evm
    2023-02-15 06:30 PM
    ethereumethereum
    evm
    Session 3 Comparing block_timestamp to date to date range
    ethereumethereum
    nft
    evm
    SUCCESSFUL! TRIAL 1
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    ADDRESS - COUNT POSITION Times
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    First Transfers for CA (SELECT *) + Function Signatures 2023-07-26 10:39 AM
    ethereumethereum
    evm
    Session 4 - Getting Function Signatures count
    ethereumethereum
    evm
    HOW MANY COMMON TOKENS BETWEEN {Address} and ADDIES? 2023-07-19 10:32 PM
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    NFT Mints from a specific contract
    ethereumethereum
    nft
    evm
    s SHITCOIN 1ST BLOCK TXS 2023-07-19 08:57 PM
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    Session 3 Opensea platform fees by Currency truncated by hour counting Non-ETH/WETH as Other
    ethereumethereum
    nft
    evm
    Active wallets and Transactions on ETH in Oct 22
    ethereumethereum
    evm
    2023-06-28 Gas-Adjusted PnL of Addresses who bought {{Token}} (Updated from 2023-06-23)
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    14.02 UINTS Sales by Price
    ethereumethereum
    nft
    evm
    First Transfers for CA + Function Signatures 2023-07-26 10:00 AM
    ethereumethereum
    evm
    FORK 2023-06-28 Gas-Adjusted PnL of Addresses who bought {{Token}} (Updated from 2023-06-23) copy copy copy
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    15.02 Meme Lab by 6529 - Card 4 All Tra copy copy
    ethereumethereum
    nft
    evm
    Session 4 - Extract Function Signature (first 10 characters) using 'substr' and ethereum.core.fact_transactions
    ethereumethereum
    evm
    Template DATE_TRUNC 2023-07-22 03:42 PM
    ethereumethereum
    evm
    FKYEAH IT WORKS! 21062023
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    NFT SALES on Opensea Oct 22
    ethereumethereum
    nft
    evm
    Finding the Label of an address
    ethereumethereum
    evm
    TOKENS from ADDIES from this BLOCK - How many common ADDIES?
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    DATE_TRUNC 1h Address first Bought 2023-07-22
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    Latest 100 transactions
    ethereumethereum
    evm
    Address - ORDER BY TIME FROM LATEST 2023-06-21 15:38 Gas-Adjusted PnL for {{Address}} copy
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    2023-06-29 12:02 AM
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    DATE_TRUNC 3h Address first Bought 2023-07-22 04:23 PM
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    TRYING TO FIX FORK UPDATED 2023-06-28 Gas-Adjusted PnL of Addresses who bought {{Token}} (Updated from 2023-06-23) copy
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    Platform fees on Opensea (in ETH)
    ethereumethereum
    nft
    evm
    PnL + Gas
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    SHITCOIN 1ST 2 BLOCKS TXS 2023-07-19 08:57 PM
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    FORK 2023-06-23 Gas-Adjusted PnL of Addresses who bought {{Token}} copy
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    HOW MANY COMMON BLOCKS? 2023-07-19 09:35 PM
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    Recent 6529 mints
    ethereumethereum
    nft
    evm
    2023-06-29 01:22 AM
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    Address - ORDER BY TIME, BETWEEN DATES 2023-06-21 15:38 Gas-Adjusted PnL for {{Address}}
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    Multiple Tokens - WR% 2023-07-08 PnL for Addresses holding Tokens
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    ETH/WETH by day
    ethereumethereum
    nft
    evm