Opportunities

[5]:

"""
Update Parameters Here
"""
CONTRACT_ADDRESS = "0x9A534628B4062E123cE7Ee2222ec20B86e16Ca8F"
COLLECTION = "MekaVerse"
METHOD = "raritytools"
TOKEN_COL = "TOKEN_ID"  # Use TOKEN_NAME if you prefer to infer token id from token name
NUMBERS_TO_CHECK = 50  # Number of tokens to search for opportunities

[6]:

import time
import requests
import pandas as pd
import matplotlib.pyplot as plt
import matplotlib.cm as cm
import numpy as np

from honestnft_utils import config

# Define variables used throughout
PATH = f"{config.RARITY_FOLDER}/{COLLECTION}_{METHOD}.csv"
ETHER_UNITS = 1e18

"""
Plot params
"""
plt.rcParams.update({"figure.facecolor": "white", "savefig.facecolor": "white"})

# Load rarity database and format
RARITY_DB = pd.read_csv(PATH)
RARITY_DB = RARITY_DB[RARITY_DB["TOKEN_ID"].duplicated() == False]
if TOKEN_COL == "TOKEN_NAME":
    RARITY_DB["TOKEN_ID"] = RARITY_DB["TOKEN_NAME"].str.split("#").str[1].astype(int)

[7]:

"""
Get open bids from OpenSea and plot.
"""


def getOpenseaOrders(token_id, contract_address: str):
    url = "https://api.opensea.io/wyvern/v1/orders"

    querystring = {
        "bundled": "false",
        "include_bundled": "false",
        "is_english": "false",
        "include_invalid": "false",
        "limit": "50",
        "offset": "0",
        "order_by": "created_date",
        "order_direction": "desc",
        "asset_contract_address": contract_address,
        "token_ids": [token_id],
    }

    headers = {"Accept": "application/json", "X-API-KEY": config.OPENSEA_API_KEY}

    response = requests.request("GET", url, headers=headers, params=querystring)
    response_json = response.json()
    return response_json


def plot_all_bids(bid_db: pd.DataFrame) -> None:
    series = []
    max_listings = bid_db["token_ids"].value_counts().max()

    for i in range(1, max_listings + 1):
        n_bids = bid_db.groupby("token_ids").filter(lambda x: len(x) == i)
        series.append(n_bids)

    colors = iter(cm.rainbow(np.linspace(0, 1, len(series))))
    for i in range(0, len(series)):
        plt.scatter(
            series[i]["ranks"], series[i]["bid"], color=next(colors), label=i + 1
        )
        plt.xlabel("rarity rank")
        plt.ylabel("price (ETHER)")
        plt.legend(loc="best")

    plt.show()


def get_all_bids(rarity_db: pd.DataFrame) -> pd.DataFrame:
    token_ids = []
    ranks = []
    bids = []
    numbersToCheck = []

    for x in rarity_db["TOKEN_ID"]:
        numbersToCheck.append(x)

        if len(numbersToCheck) == 15:  # send 15 NFTs at a time to API
            orders = getOpenseaOrders(numbersToCheck, CONTRACT_ADDRESS)
            numbersToCheck = []

            for order in orders["orders"]:
                if order["side"] == 0:
                    tokenId = int(order["asset"]["token_id"])
                    token_ids.append(tokenId)
                    ranks.append(
                        float(rarity_db[rarity_db["TOKEN_ID"] == tokenId]["Rank"])
                    )
                    bids.append(float(order["base_price"]) / ETHER_UNITS)

    bid_db = pd.DataFrame(columns=["token_ids", "ranks", "bid"])
    bid_db["token_ids"] = token_ids
    bid_db["ranks"] = ranks
    bid_db["bid"] = bids
    return bid_db


bid_db = get_all_bids(RARITY_DB.head(NUMBERS_TO_CHECK))
bid_db = bid_db.sort_values(by=["ranks"])

print(bid_db.set_index("token_ids").head(50))
plot_all_bids(bid_db)

           ranks       bid
token_ids
6273         2.0  0.756900
6242         3.0  0.756900
7796         5.0  0.756900
8075         6.0  0.800000
4370         9.0  0.756900
7823        11.0  0.756900
3581        13.0  0.755500
7075        14.0  0.755500
7075        14.0  0.756900
7075        14.0  0.800000
1146        15.0  0.755500
1146        15.0  0.800000
3060        16.0  0.821900
7521        17.0  0.756900
4214        18.0  0.756900
4214        18.0  0.755500
6051        19.0  0.800000
6051        19.0  0.756900
5580        20.0  0.756900
7156        22.0  0.755500
7156        22.0  0.756900
7156        22.0  0.800000
945         25.0  0.755500
848         26.0  0.755500
353         27.0  0.811900
8582        29.0  0.699612
6599        30.0  0.756900
6599        30.0  0.755500
2764        31.0  1.700100
5365        32.0  0.756900
6328        34.0  0.756900
6540        35.0  0.755500
6540        35.0  0.756900
7313        37.0  0.756900
3807        39.0  0.755500
7916        40.0  0.756900
987         41.0  0.755500
1070        42.0  0.755500
1070        42.0  0.800000
3005        43.0  0.800000
1924        44.0  1.700100

../_images/notebooks_opportunities_3_1.png

[8]:

def display_orders(rarity_db: pd.DataFrame) -> None:
    print("RANK TOKEN_ID PRICE URL")
    numbersToCheck = []
    for x in rarity_db["TOKEN_ID"]:
        numbersToCheck.append(x)
        if len(numbersToCheck) == 15:
            orders = getOpenseaOrders(numbersToCheck, CONTRACT_ADDRESS)
            numbersToCheck = []
            time.sleep(2)
            for order in orders["orders"]:
                if order["side"] == 1:
                    tokenId = int(order["asset"]["token_id"])
                    price = float(order["current_price"]) / 1e18
                    if price <= 20:
                        current_order = dict()
                        current_order["RANK"] = str(
                            int(rarity_db[rarity_db["TOKEN_ID"] == tokenId]["Rank"])
                        )
                        current_order["TOKEN_ID"] = str(tokenId)
                        current_order["PRICE"] = str(price)
                        current_order[
                            "URL"
                        ] = f"https://opensea.io/assets/{CONTRACT_ADDRESS}/{tokenId}"
                        str_to_print = ""
                        for x in ["RANK", "TOKEN_ID", "PRICE"]:
                            str_to_print += f"{current_order[x]}"
                            str_to_print += " " * (len(x) + 1 - len(current_order[x]))
                        str_to_print += current_order["URL"]
                        print(str_to_print)


display_orders(RARITY_DB.head(NUMBERS_TO_CHECK))

RANK TOKEN_ID PRICE URL
28   1478     5.5   https://opensea.io/assets/0x9A534628B4062E123cE7Ee2222ec20B86e16Ca8F/1478
28   1478     12.0  https://opensea.io/assets/0x9A534628B4062E123cE7Ee2222ec20B86e16Ca8F/1478
42   1070     8.0   https://opensea.io/assets/0x9A534628B4062E123cE7Ee2222ec20B86e16Ca8F/1070
42   1070     9.0   https://opensea.io/assets/0x9A534628B4062E123cE7Ee2222ec20B86e16Ca8F/1070
42   1070     12.0  https://opensea.io/assets/0x9A534628B4062E123cE7Ee2222ec20B86e16Ca8F/1070
42   1070     17.0  https://opensea.io/assets/0x9A534628B4062E123cE7Ee2222ec20B86e16Ca8F/1070
40   7916     12.5  https://opensea.io/assets/0x9A534628B4062E123cE7Ee2222ec20B86e16Ca8F/7916
40   7916     17.5  https://opensea.io/assets/0x9A534628B4062E123cE7Ee2222ec20B86e16Ca8F/7916

[9]:

import numpy as np

A = -0.9
K = 1
B = 5
v = 1
Q = 1.1
C = 1

RARITY_DB["VALUE"] = A + (
    (K - A) / np.power((C + Q * np.exp(-B * (1 / RARITY_DB["Rank"]))), 1 / v)
)
RARITY_DB["VALUE"] = np.where(RARITY_DB["Rank"] > 96 * 2, 0, RARITY_DB["VALUE"])
RARITY_DB[["Rank", "VALUE"]].sort_values("Rank").plot(
    x="Rank", y="VALUE", figsize=(14, 7), logx=True, grid=True
)
plt.show()

../_images/notebooks_opportunities_5_0.png

[10]:

RARITY_DB = RARITY_DB.sort_values("TOKEN_ID")
RARITY_DB.plot(x="TOKEN_ID", y="VALUE", grid=True, figsize=(14, 7))

[10]:

<AxesSubplot:xlabel='TOKEN_ID'>

../_images/notebooks_opportunities_6_1.png

[11]:

RARITY_DB = RARITY_DB.sort_values("TOKEN_ID")
RARITY_DB["EXPANDING_VALUE"] = RARITY_DB["VALUE"].expanding().sum()
RARITY_DB.plot(x="TOKEN_ID", y="EXPANDING_VALUE", grid=True, figsize=(14, 7))

[11]:

<AxesSubplot:xlabel='TOKEN_ID'>

../_images/notebooks_opportunities_7_1.png

[12]:

pd.set_option("display.max_rows", 100)
RARITY_DB.sort_values("Rank").head(96)

[12]:

	TOKEN_ID	TOKEN_NAME	Color	Meka Type	Helmet	Eyes	Mask	Jaws	Arms	Chest	Colors	Weapon	Material	Status	RARITY_SCORE	Rank	VALUE	EXPANDING_VALUE
0	1922	Meka #1922	22.557379	25474.800000	2769.000000	4392.206897	3639.257143	4899.000000	5789.727273	7492.588235	75.191263	2.002830	3.749603	63687.000000	118247.080623	1	0.986021	3.604848
1	6273	Meka #6273	22.557379	25474.800000	2769.000000	4392.206897	3639.257143	4899.000000	5789.727273	7492.588235	75.191263	2.002830	3.749603	63687.000000	118247.080623	2	0.842650	9.637673
2	6242	Meka #6242	22.557379	25474.800000	2769.000000	4392.206897	3639.257143	4899.000000	5789.727273	7492.588235	75.191263	2.002830	3.749603	63687.000000	118247.080623	3	0.673156	8.795023
3	2370	Meka #2370	6368.700000	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	16.933528	2.002830	299.703529	23.008309	7973.017538	4	0.544696	4.484454
4	7796	Meka #7796	6368.700000	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	77.196364	2.002830	299.703529	23.008309	7920.337911	5	0.452633	11.435928
5	8075	Meka #8075	6368.700000	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	24.618090	2.002830	299.703529	23.008309	7867.759638	6	0.385471	12.301125
6	1784	Meka #1784	22.557379	42.600000	207.675000	366.017241	94.937143	341.790698	190.870130	247.008403	75.191263	1013.586207	3639.257143	23.008309	6264.498916	7	0.334972	2.618826
7	2423	Meka #2423	22.557379	77.509533	159.750000	140.176816	143.654887	145.514851	598.937304	212.054384	75.191263	549.025862	3639.257143	23.008309	5786.637733	8	0.295880	4.829874
8	4370	Meka #4370	22.557379	56.443427	188.795455	387.547667	131.539415	74.604061	81.545455	31.838194	75.191263	549.025862	3639.257143	23.008309	5261.353629	9	0.264838	6.849237
9	3139	Meka #3139	22.557379	18.327194	202.609756	18.050165	52.742857	24.742424	145.959511	51.673022	75.191263	878.441379	3639.257143	23.008309	5152.560404	10	0.239646	5.697806
10	7823	Meka #7823	22.557379	56.443427	296.678571	231.168784	88.762369	74.604061	140.074047	153.957293	75.191263	199.645768	3639.257143	23.008309	5001.348414	11	0.218825	11.654753
11	1559	Meka #1559	477.652500	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	3032.714286	2.002830	299.703529	23.008309	4984.808333	12	0.201344	2.053527
12	3581	Meka #3581	22.557379	42.600000	207.675000	26.300640	198.504935	244.950000	190.870130	42.491049	75.191263	2.002830	3639.257143	23.008309	4715.408678	13	0.186469	6.088539
13	7075	Meka #7075	22.557379	18.327194	93.337079	63.655172	73.768726	38.984085	45.232244	51.673022	75.191263	185.586207	3639.257143	23.008309	4330.577824	14	0.173665	10.346878
14	1146	Meka #1146	477.652500	42.600000	28.159322	11.548309	56.568764	341.790698	25.770299	24.247858	3032.714286	2.002830	91.966787	23.008309	4158.029963	15	0.162530	1.257959
15	3060	Meka #3060	477.652500	56.443427	32.576471	148.051918	36.392571	16.348165	140.074047	31.838194	3032.714286	2.002830	91.966787	23.008309	4089.069504	16	0.152762	5.438099
16	7521	Meka #7521	477.652500	77.509533	95.482759	33.873061	34.224989	20.188187	62.255132	212.054384	3032.714286	2.002830	3.749603	23.008309	4074.715572	17	0.144124	10.781852
17	4214	Meka #4214	477.652500	56.443427	91.285714	20.588470	59.659953	141.317308	40.868663	31.838194	3032.714286	2.002830	91.966787	23.008309	4069.346441	18	0.136432	6.512091
18	6051	Meka #6051	477.652500	18.327194	148.339286	18.050165	11.577700	10.241812	14.832777	51.673022	3032.714286	219.610345	3.749603	23.008309	4029.776999	19	0.129541	8.095144
19	5580	Meka #5580	477.652500	56.443427	127.800000	20.588470	21.576623	16.348165	81.545455	153.957293	3032.714286	2.002830	3.749603	23.008309	4017.386960	20	0.123331	7.593515
20	8489	Meka #8489	477.652500	42.600000	25.718266	26.300640	13.925729	62.540426	190.870130	24.247858	3032.714286	2.002830	91.966787	23.008309	4013.547761	21	0.117708	12.694856
21	7156	Meka #7156	477.652500	42.600000	43.492147	11.548309	13.925729	62.540426	25.770299	247.008403	3032.714286	2.002830	3.749603	23.008309	3986.012841	22	0.112591	10.497936
22	396	Meka #396	1592.175000	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	239.424812	549.025862	299.703529	23.008309	3966.006854	23	0.107917	0.312133
23	2710	Meka #2710	477.652500	42.600000	11.618182	26.300640	13.925729	188.423077	25.770299	24.247858	3032.714286	2.002830	3.749603	23.008309	3872.013313	24	0.103629	4.994812
24	945	Meka #945	1592.175000	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	239.424812	549.025862	299.703529	23.008309	3853.064391	25	0.099682	0.913200
25	848	Meka #848	1592.175000	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	239.424812	549.025862	299.703529	23.008309	3853.064391	26	0.096038	0.738489
26	353	Meka #353	477.652500	56.443427	32.576471	52.081505	21.576623	74.604061	40.868663	31.838194	3032.714286	2.002830	3.749603	23.008309	3849.116471	27	0.092662	0.176648
27	1478	Meka #1478	477.652500	18.327194	17.163223	47.059360	17.412714	56.745174	45.232244	51.673022	3032.714286	2.002830	3.749603	23.008309	3792.740459	28	0.089526	1.694554
28	8582	Meka #8582	477.652500	18.327194	17.163223	70.463212	73.768726	10.241812	14.832777	10.391939	3032.714286	2.002830	3.749603	23.008309	3754.316411	29	0.086606	12.781462
29	6599	Meka #6599	1592.175000	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	24.618090	549.025862	299.703529	23.008309	3751.200132	30	0.083880	9.917421
30	2764	Meka #2764	22.557379	56.443427	32.576471	171.124944	88.762369	141.317308	110.631731	70.243015	75.191263	598.937304	2315.890909	23.008309	3706.684429	31	0.081329	5.094850
31	5365	Meka #5365	477.652500	18.327194	41.123762	6.594905	36.884363	24.742424	26.599053	10.391939	3032.714286	2.002830	3.749603	23.008309	3703.791170	32	0.078937	7.277281
32	1281	Meka #1281	477.652500	18.327194	17.163223	18.050165	20.995714	15.042989	40.393446	24.432353	3032.714286	2.002830	3.749603	23.008309	3693.532613	33	0.076690	1.429433
33	6328	Meka #6328	477.652500	18.327194	35.199153	18.050165	11.577700	33.176072	14.832777	10.391939	3032.714286	2.002830	3.749603	23.008309	3680.682529	34	0.074575	9.712248
34	6540	Meka #6540	477.652500	18.327194	17.163223	6.594905	17.412714	10.241812	40.393446	24.432353	3032.714286	2.002830	3.749603	23.008309	3673.693175	35	0.072581	9.833541
35	7616	Meka #7616	1592.175000	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	24.618090	549.025862	299.703529	23.008309	3638.257669	36	0.070697	10.949602
36	7313	Meka #7313	1592.175000	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	24.618090	549.025862	299.703529	23.008309	3638.257669	37	0.068914	10.618146
37	1532	Meka #1532	61.434405	42.600000	28.159322	26.300640	27.091244	56.095420	25.172727	24.247858	3032.714286	253.396552	3.749603	23.008309	3603.970366	38	0.067226	1.852182
38	3807	Meka #3807	61.434405	18.327194	35.199153	6.594905	36.884363	56.745174	40.393446	24.432353	3032.714286	2.002830	91.966787	23.008309	3429.703205	39	0.065624	6.314335
39	7916	Meka #7916	1592.175000	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	239.424812	2.002830	299.703529	23.008309	3418.983822	40	0.064102	11.790013
40	987	Meka #987	1592.175000	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	239.424812	2.002830	299.703529	23.008309	3418.983822	41	0.062654	0.994321
41	1070	Meka #1070	88.865581	18.327194	20.561881	6.594905	89.489930	15.042989	26.599053	10.391939	3032.714286	73.203448	3.749603	23.008309	3408.549119	42	0.061275	1.055596
42	3005	Meka #3005	61.434405	42.600000	47.468571	11.548309	27.091244	56.095420	25.172727	24.247858	3032.714286	2.002830	3.749603	23.008309	3357.133563	43	0.059960	5.285338
43	1924	Meka #1924	955.305000	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	239.424812	549.025862	299.703529	23.008309	3329.136854	44	0.058705	3.663552
44	2232	Meka #2232	22.557379	42.600000	28.159322	366.017241	27.091244	85.447674	25.770299	42.491049	75.191263	244.011494	2315.890909	23.008309	3298.236185	45	0.057505	3.914725
45	5162	Meka #5162	955.305000	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	239.424812	549.025862	299.703529	23.008309	3216.194391	46	0.056358	7.120600
46	939	Meka #939	1592.175000	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	24.618090	2.002830	299.703529	23.008309	3204.177101	47	0.055260	0.813518
47	5402	Meka #5402	1592.175000	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	24.618090	2.002830	299.703529	23.008309	3204.177101	48	0.054207	7.349877
48	737	Meka #737	1592.175000	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	16.933528	2.002830	299.703529	23.008309	3196.492538	49	0.053197	0.587056
49	3503	Meka #3503	22.557379	77.509533	41.123762	33.873061	188.237438	20.188187	62.255132	30.212049	75.191263	268.910626	2315.890909	23.008309	3158.957650	50	0.052228	5.861357
50	7180	Meka #7180	1469.700000	42.600000	28.159322	11.548309	108.096747	341.790698	25.770299	42.491049	16.933528	1013.586207	3.749603	23.008309	3127.434071	51	0.051296	10.549232
51	1175	Meka #1175	22.557379	18.327194	83.909091	18.050165	17.412714	33.176072	26.599053	51.673022	75.191263	439.220690	2315.890909	23.008309	3125.015862	52	0.050401	1.334881
52	2422	Meka #2422	1592.175000	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	24.618090	2.002830	299.703529	23.008309	3091.234638	53	0.049539	4.533993
53	1706	Meka #1706	1469.700000	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	16.933528	2.002830	299.703529	23.008309	3074.017538	54	0.048709	2.248676
54	519	Meka #519	22.557379	18.327194	148.339286	85.010456	11.577700	10.241812	45.232244	39.643324	75.191263	248.615485	2315.890909	23.008309	3043.635362	55	0.047909	0.402215
55	7922	Meka #7922	22.557379	56.443427	91.285714	148.051918	68.665229	16.348165	81.545455	123.504202	75.191263	2.002830	2315.890909	23.008309	3024.494800	56	0.047138	11.837152
56	6840	Meka #6840	22.557379	18.327194	83.909091	117.648399	73.768726	33.176072	45.232244	39.643324	75.191263	129.182556	2315.890909	23.008309	2977.535467	57	0.046394	10.106867
57	5677	Meka #5677	1469.700000	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	16.933528	2.002830	299.703529	23.008309	2961.075075	58	0.045676	7.740732
58	5791	Meka #5791	1469.700000	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	16.933528	2.002830	299.703529	23.008309	2961.075075	59	0.044982	7.836400
59	3636	Meka #3636	22.557379	18.327194	115.375000	85.010456	52.742857	15.042989	26.599053	39.643324	75.191263	98.332990	2315.890909	23.008309	2887.721724	60	0.044311	6.132850
60	5930	Meka #5930	22.557379	42.600000	28.159322	26.300640	27.091244	244.950000	25.770299	42.491049	75.191263	2.002830	2315.890909	23.008309	2876.013245	61	0.043662	7.907200
61	5661	Meka #5661	22.557379	77.509533	159.750000	55.833139	188.237438	20.188187	598.937304	30.212049	75.191263	2.002830	1592.175000	23.008309	2845.602432	62	0.043034	7.675747
62	3489	Meka #3489	22.557379	42.600000	28.159322	26.300640	13.925729	62.540426	25.770299	42.491049	75.191263	130.461591	2315.890909	23.008309	2808.896916	63	0.042426	5.809129
63	8060	Meka #8060	22.557379	18.327194	115.375000	47.059360	73.768726	10.241812	40.393446	39.643324	75.191263	2.002830	2315.890909	23.008309	2783.459553	64	0.041837	11.915654
64	1564	Meka #1564	477.652500	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	239.424812	549.025862	299.703529	23.008309	2738.541891	65	0.041266	2.094793
65	3578	Meka #3578	955.305000	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	239.424812	2.002830	299.703529	23.008309	2669.171359	66	0.040713	5.902069
66	3377	Meka #3377	955.305000	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	239.424812	2.002830	299.703529	23.008309	2669.171359	67	0.040176	5.766703
67	7561	Meka #7561	1469.700000	56.443427	91.285714	20.588470	88.762369	141.317308	81.545455	70.243015	16.933528	549.025862	3.749603	23.008309	2612.603060	68	0.039655	10.840727
68	1633	Meka #1633	477.652500	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	24.618090	549.025862	299.703529	23.008309	2523.735169	69	0.039148	2.176532
69	8390	Meka #8390	22.557379	56.443427	32.576471	199.645768	68.665229	16.348165	110.631731	31.838194	75.191263	268.910626	1592.175000	23.008309	2497.991562	70	0.038657	12.487047
70	7577	Meka #7577	22.557379	56.443427	296.678571	20.588470	88.762369	74.604061	140.074047	31.838194	75.191263	2.002830	1592.175000	23.008309	2423.923921	71	0.038179	10.878906
71	8108	Meka #8108	22.557379	77.509533	95.482759	178.062442	143.654887	93.611465	62.255132	30.212049	75.191263	2.002830	1592.175000	23.008309	2395.723049	72	0.037714	12.338839
72	1435	Meka #1435	22.557379	56.443427	188.795455	20.588470	36.392571	16.348165	81.545455	70.243015	75.191263	199.645768	1592.175000	23.008309	2382.934276	73	0.037263	1.548473
73	5968	Meka #5968	1469.700000	42.600000	47.468571	113.591558	13.925729	341.790698	25.770299	247.008403	16.933528	2.002830	3.749603	23.008309	2347.549529	74	0.036823	7.965603
74	1467	Meka #1467	22.557379	77.509533	95.482759	178.062442	34.224989	145.514851	62.255132	30.212049	75.191263	2.002830	1592.175000	23.008309	2338.196537	75	0.036395	1.605028
75	4482	Meka #4482	477.652500	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	239.424812	2.002830	299.703529	23.008309	2304.461322	76	0.035979	6.915213
76	4104	Meka #4104	477.652500	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	239.424812	2.002830	299.703529	23.008309	2304.461322	77	0.035573	6.375659
77	1754	Meka #1754	35.316266	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	239.424812	549.025862	299.703529	23.008309	2296.205657	78	0.035178	2.283854
78	3644	Meka #3644	22.557379	56.443427	136.180328	148.051918	21.576623	141.317308	40.868663	31.838194	75.191263	2.002830	1592.175000	23.008309	2291.211242	79	0.034792	6.167642
79	6786	Meka #6786	22.557379	77.509533	41.123762	55.833139	94.937143	20.188187	62.255132	212.054384	75.191263	2.002830	1592.175000	23.008309	2278.836062	80	0.034417	10.060473
80	740	Meka #740	22.557379	56.443427	127.800000	171.124944	59.659953	74.604061	40.868663	31.838194	75.191263	2.002830	1592.175000	23.008309	2277.274024	81	0.034050	0.621106
81	7709	Meka #7709	53.072500	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	16.933528	549.025862	299.703529	23.008309	2204.413070	82	0.033693	10.983295
82	3699	Meka #3699	53.072500	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	16.933528	549.025862	299.703529	23.008309	2204.413070	83	0.033344	6.225847
83	6674	Meka #6674	33.228000	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	24.618090	549.025862	299.703529	23.008309	2192.253132	84	0.033003	9.950424
84	5276	Meka #5276	477.652500	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	239.424812	2.002830	299.703529	23.008309	2191.518859	85	0.032671	7.173136
85	6774	Meka #6774	22.557379	56.443427	32.576471	52.081505	59.659953	74.604061	40.868663	153.957293	75.191263	2.002830	1592.175000	23.008309	2185.126154	86	0.032346	10.006657
86	610	Meka #610	33.228000	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	16.933528	549.025862	299.703529	23.008309	2184.568570	87	0.032029	0.480394
87	1492	Meka #1492	27.570130	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	16.933528	549.025862	299.703529	23.008309	2178.910700	88	0.031719	1.726273
88	8395	Meka #8395	27.570130	18.327194	97.729412	376.474877	128.444370	172.905882	204.343316	264.444291	16.933528	549.025862	299.703529	23.008309	2178.910700	89	0.031415	12.518462
89	7058	Meka #7058	22.557379	77.509533	41.123762	55.833139	34.224989	20.188187	62.255132	165.277682	75.191263	2.002830	1592.175000	23.008309	2171.347205	90	0.031119	10.173214
90	2194	Meka #2194	22.557379	77.509533	41.123762	286.448276	642.221849	145.514851	598.937304	30.212049	75.191263	2.002830	223.463158	23.008309	2168.190565	91	0.030829	3.833019
91	5435	Meka #5435	35.316266	77.509533	95.482759	89.636875	1213.085714	145.514851	40.113584	212.054384	24.618090	199.645768	3.749603	23.008309	2159.735738	92	0.030546	7.380422
92	2769	Meka #2769	22.557379	77.509533	41.123762	33.873061	34.224989	20.188187	173.691818	30.212049	75.191263	2.002830	1592.175000	23.008309	2125.758182	93	0.030268	5.125118
93	4471	Meka #4471	22.557379	77.509533	95.482759	89.636875	34.224989	20.188187	62.255132	30.212049	75.191263	2.002830	1592.175000	23.008309	2124.444306	94	0.029997	6.879234
94	680	Meka #680	17.028610	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	77.196364	549.025862	299.703529	23.008309	2115.689552	95	0.029731	0.533859
95	8468	Meka #8468	53.072500	18.327194	97.729412	263.532414	128.444370	172.905882	204.343316	264.444291	16.933528	549.025862	299.703529	23.008309	2091.470607	96	0.029470	12.547933