mrwildcatsushiswap: WETH/THOR Pool
Updated 2022-09-12
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
30
31
32
33
›
⌄
--https://docs.thorswap.finance/thorswap/usdthor-token/usdthor
-- https://etherscan.io/address/0x3D3F13F2529eC3C84B2940155EffBf9b39a8f3Ec
-- old contract 0xae1Fc3947Ee83aeb3b7fEC237BCC1D194C88BC24
-- new contract 0x3D3F13F2529eC3C84B2940155EffBf9b39a8f3Ec
-- 0xEF0881eC094552b2e128Cf945EF17a6752B4Ec5d new contract??
-- token address 0x3d3f13f2529ec3c84b2940155effbf9b39a8f3ec
--select * from ethereum.core.fact_transactions where to_address = lower('0xae1Fc3947Ee83aeb3b7fEC237BCC1D194C88BC24')
/*select distinct(origin_function_signature), count(tx_hash) from ethereum.core.fact_transactions where to_address = lower('0xae1Fc3947Ee83aeb3b7fEC237BCC1D194C88BC24')
and status = 'SUCCESS'
group by 1
order by 2 desc*/
-- top origin function signature transactions
--0x8dbdbe6d, 154
--0x18fccc76, 149
--0xd1abb907, 107
--select * from ethereum.core.fact_transactions where to_address = lower('0xae1Fc3947Ee83aeb3b7fEC237BCC1D194C88BC24') and origin_function_signature = '0x8dbdbe6d' -- deposit
--select * from ethereum.core.fact_transactions where to_address = lower('0xae1Fc3947Ee83aeb3b7fEC237BCC1D194C88BC24') and origin_function_signature = '0x18fccc76' -- harvest
--select * from ethereum.core.fact_transactions where to_address = lower('0xae1Fc3947Ee83aeb3b7fEC237BCC1D194C88BC24') and origin_function_signature = '0xd1abb907' --withdrawAndHarvest
--SELECT * from ethereum.core.fact_token_transfers where to_address = lower('0xae1Fc3947Ee83aeb3b7fEC237BCC1D194C88BC24') -- primer contrato
--SELECT * from ethereum.core.fact_token_transfers where to_address = lower('0xEF0881eC094552b2e128Cf945EF17a6752B4Ec5d')
--and contract_address = '0x3d3f13f2529ec3c84b2940155effbf9b39a8f3ec'-- segundo contrato
--SELECT * from ethereum.core.fact_token_transfers where to_address = lower('0xae1Fc3947Ee83aeb3b7fEC237BCC1D194C88BC24') and contract_address = '0x3d3f13f2529ec3c84b2940155effbf9b39a8f3ec'
--select *, raw_amount/10e18 from ethereum.core.fact_token_transfers where tx_hash = '0x92e636f5a3a4081925eba71c66cb5a6eede8f7da4b3b05b6c0ea9813ee6faca7'
select * from ethereum.core.fact_traces where tx_hash = '0x92e636f5a3a4081925eba71c66cb5a6eede8f7da4b3b05b6c0ea9813ee6faca7'
Run a query to Download Data