jojo

import requests
import json
#from prettytable import PrettyTable
#import mysql.connector
import pymysql
import time
conn = pymysql.connect(user='', password='',
                                  host='amazonaws.com',
                                  database='')
cursor = conn.cursor()
startTime = time.time()
while True:
    UR: = "https://api.coinmarketcap.com/v1/ticker/"
    request = requests.get(URL)
    data = request.json()
    for x in data:
        name = x['name']
        symbol = x['symbol']
        price_usd_data = x['price_usd']
        rank = int(x['rank'])
        query2 = "INSERT INTO price_usd (name, symbol, rank, 5_min) VALUES (%s, %s, %s, %s); "
        print(query2)
       # time.sleep(5)
        cursor.execute(query2, (name, symbol, rank, price_usd_data))
        query3 = "INSERT INTO price_usd (30_min) VALUES (%s) WHERE (symbol=%s); "
        time.sleep(2)
        cursor.execute(query3 (price_usd_data), (symbol))
        conn.commit()
    cursor.close()
    conn.close()