Magic Eden Listings Tracking

import requests import json from numpy import * import time import pandas as pd import matplotlib.pyplot as plt response = requests.get("https://api-mainnet.magiceden.dev/v2/collections/theorcs/stats") data = response.json() num = data['listedCount'] limit = 20 #max listings taken is 20 data = [] i=0 while(i<num): response = requests.get("https://api-mainnet.magiceden.dev/v2/collections/theorcs/listings?offset="+str(i)+"&limit=20") data.extend(response.json()) i = len(data) #price_array.extend([data[j]['price'] for j in range(len(data))]) #token_array.extend([data[j]['tokenMint'] for j in range(len(data))])

df = pd.DataFrame(data) df = df.sort_values('price').reset_index(drop=True)

headers = { "Accept": "application/json;q=0.9,image/avif,image/webp,*/*;q=0.8", # "Accept-Encoding": "gzip, deflate, br", "Accept-Language": "en-US,en;q=0.5", "Sec-Fetch-Dest": "document", "Sec-Fetch-Mode": "navigate", "Sec-Fetch-Site": "cross-site", "Upgrade-Insecure-Requests": "1", "User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:99.0) Gecko/20100101 Firefox/99.0", "Alt-Used": "api-mainnet.magiceden.io", "TE": "trailers", "Sec-Fetch-User": "?1" # "Pragma": "no-cache", # "Cache-Control": "no-cache" }

pdaAddressobject

7dXCURDyWmHVfFo1EGYv5XPvqzRproGBsdLyBxeHBZSy0.1%

8cYRkBQhC31PXk8cr3hfCw2u3hzAhhHcFQLtx1ovwssi0.1%

1398 others99.7%

auctionHouseobject

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe100%

6JZffhL3LVyp8mGkreh3riFjjLif57EgucGM4gwUgVQd

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

G7VSW93cVh8kGzyMCRCyiWeBPzzHU1wuPWVk8tMM5Qmj

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

AXYwuBt7BLdR8RiDcBamrB6jCv2VUMUJceungr6V6zgd

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

BqM59WYxLiR6cfdByFVk6LxPq3o32zVMaiXcY9tdfsd3

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

33GV6LL4xVM5f3nLRqpHoUonCH2fr2ZX1LU1uHiztUvS

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

7bBM4vMfGPSA7FppBQ6zzDKv21ZpQHLUUmFAhpwd1PMu

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

CNWdF1Z8hFCyEgHxb7Cdj3ur5mWVKvzocNReFhPhaeYp

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

KZs9V44C3JmMEe29QvBpJZ1gbanh5FqxP9yNt8vPCgb

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

8njW1eHUkoZYHTiVTGf1MMZBCA9okh9dVANtTqSiNkJX

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

AqJ66A63jE86oKxevEyz5simhYctzJKkNzFhZwSDFrKk

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:6: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy

pdaAddressobject

8pnBpxRgfydnNruerfE45ERTLbMopH1zt8djUgMSNQYT1.2%

FaB8HyS56iuqpCe3HzE7t9MZnnM9jyXnsidTFzc5p9Ky1.2%

83 others97.6%

auctionHouseobject

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe100%

747

8pnBpxRgfydnNruerfE45ERTLbMopH1zt8djUgMSNQYT

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

774

FaB8HyS56iuqpCe3HzE7t9MZnnM9jyXnsidTFzc5p9Ky

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

778

6i6ozpUB8VVKsWBhGx5na5dsg4TujFuCEUFjiaVJryGu

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

824

AaJdvJQZyieT6vYEB9u3DAbypt8wcejEXbziqmdHKwsX

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

842

J6MRYruig8o379unxxaHLniKnXhLqE9nVzeWusZp3Xgm

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

861

DuFpeLSzCaAdaWjwB1f74oHFRTGiQLvyU5SkWoaa5Ebm

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

1023

BNkzHZhZwnNe3r9743nt1SHukbS9LSCd1DUqPWiBSETM

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

1028

FNYaT1hVGBt3CPMYoLjJGpbMoo59k6w8Njj1dKJpR6Ff

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

1053

3nhNcHA6Qdnn5wgDbTHGDaRoHSGxEqBDmgdJX7cwN3JH

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

1096

DFCgtjDgi7QzPM5gnoUJMXr2saYAULsHzmxEEdzp57QS

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

pdaAddressobject

7dXCURDyWmHVfFo1EGYv5XPvqzRproGBsdLyBxeHBZSy0.1%

8cYRkBQhC31PXk8cr3hfCw2u3hzAhhHcFQLtx1ovwssi0.1%

1398 others99.7%

auctionHouseobject

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe100%

1020

82eik6TXjNF7zVCnoQvo93w6p7vobqhyrJMNLQAmpPkL

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

1021

2Vav9XgdC6k5JMW3tfMKAL9QzJhDmR7gt4GjTogto6Mp

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

1022

317mVFZHtaDwHSqEgvMHChke7BZrtiXZjbqQnUpnnNUr

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

1023

BNkzHZhZwnNe3r9743nt1SHukbS9LSCd1DUqPWiBSETM

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

1024

8shhNnGJENcKbvqvsYCEbVqUvigi2khYfqmt5C657oY4

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

1025

gogcgpEhazKzKsmUW4KAmf12i6XjBQMLGvxSPC1Tq4k

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

1026

DKGks5tBJF49m86ebGMckYz4oStJJPvUc9GEeFh9AmFx

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

1027

8fCpDK9LYyTRQ2vEAxcgqrB82rnCvn8GtLozpqk9E5bp

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

1028

FNYaT1hVGBt3CPMYoLjJGpbMoo59k6w8Njj1dKJpR6Ff

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

1029

64m5gXtFatkcxNMDkKHkkCQFV7aaTvfzdiNunwmhwbCP

E8cU1WiRWjanGxmn96ewBgk9vPTcL6AEZ1t6F6fkgUWe

data_low_price = df[df['price']<2.3] hist = pd.read_csv('hist.csv').drop_duplicates() data_low_price.to_csv('hist.csv', index=False) merged = data_low_price.merge(hist, how='inner', on='tokenMint') listed_num = len(data_low_price) stay_num = len(merged) old_num = len(hist) in_num = listed_num - stay_num out_num = old_num - stay_num change = listed_num - old_num from datetime import datetime # datetime object containing current date and time now = datetime.now() # dd/mm/YY H:M:S dt_string = now.strftime("%d/%m/%Y %H:%M:%S") an_array = [dt_string, listed_num, change, in_num, out_num] f = open("test.txt", "a") f.write("\n"+str(an_array[0])+","+str(an_array[1])+","+str(an_array[2])+","+str(an_array[3])+","+str(an_array[4])) f.close()

#plot_data = loadtxt('test.txt', delimiter=',', usecols=(1,2,3,4)).transpose() #time_data = loadtxt('test.txt', delimiter=',', usecols=0, dtpye=str) plot_data = pd.read_csv('test.txt', delimiter=',', header=None)

date = array(plot_data[0], dtype=datetime) plot_data = plot_data.drop(0, 1) plot_data = array(plot_data, dtype=int).transpose() length = len(date) if(length > 15): date = date[length-15:] plot_data = plot_data[:, length-15:]

plot_data[0]

fig, (ax1, ax2, ax3, ax4) = plt.subplots(4, 1, sharex=True,figsize=(5,10)) ax1.plot_date(date,plot_data[0],"b-") ax1.set_title("Listed number") ax2.plot_date(date,plot_data[1], "r-") ax2.set_title("Change") ax3.plot_date(date,plot_data[2],"g-") ax3.set_title("Newly listed") ax4.plot_date(date,plot_data[3], "y-") ax4.set_title("Sold/Delisted") fig.autofmt_xdate(rotation=25) fig.savefig('temp.png', dpi=fig.dpi)