SniperTotal amount of users are swapping via MetaMask vs Sushi swap and Uniswap
    Updated 2022-06-25
    -- wITH logs AS(
    -- SELECT logs.BLOCK_TIMESTAMP,
    -- logs.TX_HASH,
    -- logs.CONTRACT_ADDRESS,
    -- logs.ORIGIN_FROM_ADDRESS,
    -- logs.ORIGIN_TO_ADDRESS,
    -- logs.EVENT_INPUTS:from::string as from_address,
    -- logs.EVENT_INPUTS:to::string as to_address,
    -- logs.EVENT_INPUTS:value::string as value,
    -- lb.LABEL AS platform,
    -- CASE WHEN lb.ADDRESS = lower('0x881d40237659c251811cec9c364ef91dc08d300c') THEN 1 ELSE 2 END AS type
    -- FROM ethereum.core.fact_event_logs logs
    -- JOIN ethereum.core.dim_labels lb on lb.ADDRESS = ORIGIN_TO_ADDRESS AND lb.LABEL_TYPE = 'dex' AND lb.LABEL_SUBTYPE = 'swap_contract'
    -- WHERE TX_STATUS = 'SUCCESS'
    -- AND EVENT_REMOVED = 'false'
    -- -- AND ORIGIN_TO_ADDRESS = lower('0x881d40237659c251811cec9c364ef91dc08d300c')
    -- )

    -- SELECT platform, COUNT(DISTINCT from_address) swaps_count
    -- FROM logs
    -- WHERE from_address = ORIGIN_FROM_ADDRESS
    -- GROUP BY type, platform
    -- ORDER BY type ASC, 2 DESC
    -- LIMIT 20


    -- WITH logs AS(
    -- SELECT logs.BLOCK_TIMESTAMP,
    -- logs.TX_HASH,
    -- logs.CONTRACT_ADDRESS,
    -- logs.ORIGIN_FROM_ADDRESS,
    -- logs.ORIGIN_TO_ADDRESS,
    -- logs.EVENT_INPUTS:from::string as from_address,
    -- logs.EVENT_INPUTS:to::string as to_address,
    -- (logs.EVENT_INPUTS:value) / pow(10, 18) as value,
    -- lb.LABEL AS platform,
    Run a query to Download Data