flipside

    Workspace
    clayopWorkspace
    Updated 2022-12-27
    /*
    SELECT * FROM ethereum.core.ez_token_transfers
    WHERE FROM_ADDRESS = '0xe670847efdf5e8e9b6e5d552b185d1ff7b0dc462'
    AND TO_ADDRESS = '0xef3eceaed90bfa4812103f3651b6fea66cfb94ed'
    ORDER BY BLOCK_NUMBER ASC


    SELECT FROM_ADDRESS, TO_ADDRESS, SUM(AMOUNT) AS TOTAL_AMOUNT
    FROM ethereum.core.ez_token_transfers
    WHERE FROM_ADDRESS = '0x9660a85b4c70fec00071dd2cf28b2220d79ffa28' OR TO_ADDRESS = '0x9660a85b4c70fec00071dd2cf28b2220d79ffa28'
    AND SYMBOL = 'USDT'
    GROUP BY FROM_ADDRESS, TO_ADDRESS
    ORDER BY TOTAL_AMOUNT DESC



    SELECT FROM_ADDRESS, SUM(AMOUNT) FROM ethereum.core.ez_token_transfers
    WHERE TO_ADDRESS = '0xbb5e639a18631e38df1569e1fd2dc81c6d1ce1d4' AND SYMBOL = 'WEMIX' AND ORIGIN_FUNCTION_SIGNATURE = '0x5ae401dc'
    GROUP BY 1
    ORDER BY 2 DESC



    SELECT * FROM terra.classic.ez_transfers
    WHERE EVENT_CURRENCY = 'LUNA' AND EVENT_AMOUNT > 283139 AND EVENT_AMOUNT < 510140 AND DATE(BLOCK_TIMESTAMP) = '2022-05-11' AND EVENT_TO = 'terra13yxhrk08qvdf5zdc9ss5mwsg5sf7zva9xrgwgc'





    select block_id, block_timestamp,
    offer_currency, token_0_amount, token_0_amount_usd, price0_usd,
    ask_currency, token_1_amount, token_1_amount_usd, price1_usd,
    tx_id, swap_pair, trader
    from terra.classic.ez_swaps
    where offer_currency in ('LUNA') and ask_currency in ('UST')
    Run a query to Download Data