0xbrun0test my 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')
CAMELOT WINR-USDC LP: lower('0xaa6d06ceb39132b720b54259b70f41f9c975782a')
Large LP for camelot winr pool: lower('0x6cd370d150ae45066d95af610e251d7ffe7dcf57')
*/
select
block_timestamp, from_address, to_address, raw_amount /1e18 as amount, tx_hash
from arbitrum.core.fact_token_transfers
where CONTRACT_ADDRESS = lower('0xD77B108d4f6cefaa0Cae9506A934e825BEccA46E')
and BLOCK_TIMESTAMP > '2023-03-15'
and (from_address = lower('0xaa396035888d00d3490d4b100548c674b4bca267')
or to_address = lower('0xaa396035888d00d3490d4b100548c674b4bca267')
)
order by BLOCK_TIMESTAMP desc
Run a query to Download Data