rw2023$MSU Scouting
    Updated 2023-05-23
    -- forked from $MSU Team @ https://flipsidecrypto.xyz/edit/queries/d98d44d6-135c-439a-9167-1394cbd746ca

    -- forked from $MSU Private Sale @ https://flipsidecrypto.xyz/edit/queries/0a3a5bd1-b1ed-4353-92d1-78e04d9c4603

    -- forked from $MSU Ecosystem @ https://flipsidecrypto.xyz/edit/queries/62deb06f-9d62-473c-91bb-f1fa18fbd79e

    -- forked from $MSU Rewards @ https://flipsidecrypto.xyz/edit/queries/1fabafa4-bf18-4c5e-9aa1-2fa76c86eeb8

    -- forked from $MSU Gate address @ https://flipsidecrypto.xyz/edit/queries/8a2f0d0b-d558-48d0-8589-da97921a2101

    -- forked from $MSU Quickswap address @ https://flipsidecrypto.xyz/edit/queries/bb5271d2-ad14-406a-a43c-46d548f5c2e8

    -- forked from $MSU Top Holders @ https://flipsidecrypto.xyz/edit/queries/60941a6a-0be8-4b11-ae1f-f5f64ab15c6f

    -- forked from $AURY Mint Address @ https://flipsidecrypto.xyz/edit/queries/f8c72d64-9530-4da5-8af2-b0d982100aee

    WITH
    msu_in AS (
    SELECT
    date_trunc('day', block_timestamp) as date,
    SUM(amount) AS volume_in
    FROM polygon.core.ez_token_transfers
    WHERE contract_address ilike '0xe8377A076adAbb3F9838afB77Bee96Eac101ffB1'
    AND to_address ilike '0x3317b22aD951EdA895897FcD7866Da7755867784'
    AND block_timestamp >= '2021-01-23'
    GROUP BY 1
    ),
    msu_out AS (
    SELECT
    date_trunc('day', block_timestamp) as date,
    - SUM(amount) AS volume_out
    FROM polygon.core.ez_token_transfers
    WHERE contract_address ilike '0xe8377A076adAbb3F9838afB77Bee96Eac101ffB1'
    AND from_address ilike '0x3317b22aD951EdA895897FcD7866Da7755867784'
    AND block_timestamp >= '2021-01-23'
    GROUP BY 1
    Run a query to Download Data