Updated 2023-05-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
⌄
⌄
/* 0x30E7348163016B3b6E1621A3Cb40e8CF33CE97db */
select *,
date_trunc('hour', block_timestamp) as tx_date,
case
when origin_function_signature = '0x46a657d9' then 'open_position'
when origin_function_signature = '0x8f58aa15' then 'modify_position'
else 'batch'
end as transaction_type
from arbitrum.core.fact_transactions
where to_address = LOWER('0x30E7348163016B3b6E1621A3Cb40e8CF33CE97db')
/* early trader 0x48CB99F4268086FF5De3eFF5Ce7291E3C0aDc358
early testor 0x8D9312068B952F034C58b4feCFEb977E8E692F4D
early supporter 0xfb345B9D2bE55247921b3e6959Deded72aCe6da0 */
/* nft holders
select *,
date_trunc('hour', block_timestamp) as tx_date,
case
when contract_address = LOWER('0x48CB99F4268086FF5De3eFF5Ce7291E3C0aDc358') then 'trader'
when contract_address = LOWER('0x8D9312068B952F034C58b4feCFEb977E8E692F4D') then 'early testor'
else 'supporterarbitrum.core.fact_token_transfers'
end as transaction_type
from arbitrum.core.ez_token_transfers
where ORIGIN_FROM_ADDRESS in (LOWER('0x48CB99F4268086FF5De3eFF5Ce7291E3C0aDc358'),
LOWER('0x8D9312068B952F034C58b4feCFEb977E8E692F4D'),
LOWER('0xfb345B9D2bE55247921b3e6959Deded72aCe6da0'))*/
Run a query to Download Data