0xbrun0test winr_transfers
Updated 2023-04-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
⌄
/*
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