flipside

    Simulator for ZkSync Airdrop
    freemartianSimulator for ZkSync Airdrop
    Updated 2023-11-24
    with datas AS(
    SELECT
    chainbase_utils.post(
    '/v1/dw/query',
    { 'query': '
    SELECT * FROM zksync.token_transfers
    WHERE block_timestamp >= "2023-11-23"
    ' }) AS response
    )

    SELECT
    value
    FROM datas, LATERAL FLATTEN (input => response:data:data:result)
    Run a query to Download Data