0xbrun0test winr_transfers
    Updated 2023-04-02
    /*
    WINR TOKEN ADDRESS: lower('0xD77B108d4f6cefaa0Cae9506A934e825BEccA46E')

    First transaction:
    tx_hash = 0x25507124ca3a358e49f5e8fdd6e8301a59b70e6c88c89aa6c12029e1edd4ad41
    - mint
    amount :
    125000000000000000000000000
    remainingSupply :
    875000000000000000000000000


    CAMELOT WINR-USDC LP: lower('0xaa6d06ceb39132b720b54259b70f41f9c975782a')

    Large LP for camelot winr pool: lower('0x6cd370d150ae45066d95af610e251d7ffe7dcf57')
    */
    select *
    from arbitrum.core.fact_token_transfers
    where CONTRACT_ADDRESS = lower('0xD77B108d4f6cefaa0Cae9506A934e825BEccA46E')
    and BLOCK_TIMESTAMP < '2023-03-16'
    order by BLOCK_TIMESTAMP asc
    Run a query to Download Data