CSV编写器未从API调用写入新的JSON值

Question

我正在尝试将API调用的JSON结果保存到CSV。API处于for循环中，它减去一天，然后重新运行API以获得比特币的价格。然后，它应该将每个API调用保存到CSV中的一行，但它目前只保存了最后一个API调用。

如何让它为每个返回的API调用写一行？

import requests
import json
import csv

timestampCurrent = 1550698057
timestampOneWeekAgo = 1550161800
oneDay = 86400

for timestamp in range(timestampCurrent, timestampOneWeekAgo, -oneDay):
    print(timestamp)

    base_url = "https://api.gemini.com/v1/trades/btcusd"
    payload = {'timestamp' : timestamp,
                'limit_trades' : '1'}

    r = requests.get(url = base_url, params = payload)

    time = r.json()

    print(time)

# open a file for writing
bitcoincsv = open('/Users/kanye_west/Desktop/Code/Python/BitcoinTracker/bitcoinyear.csv', 'w')

# create csv writer object
csvwriter = csv.writer(bitcoincsv)

count = 0

for year in time:

    if count == 0:

        header = year.keys()
        csvwriter.writerow(header)
        count += 1

    csvwriter.writerow(year.values())

    bitcoincsv.close()

# append csv results
# save CSV file

Answer 1

这应该是可行的。

import requests
import csv

URL = 'https://api.gemini.com/v1/trades/btcusd'

TIMESTAMP_CURRENT = 1550698057
TIMESTAMP_ONE_WEEK_AGO = 1550161800
ONE_DAY = 86400


def get_time_slot_data(timestamp):
    r = requests.get(URL, params={'timestamp': timestamp, 'limit_trades': '1'})
    if r.status_code == 200:
        return r.json()


with open('gemini.csv', 'wb') as out:
    headers_written = False
    writer = csv.writer(out)
    for timestamp in range(TIMESTAMP_CURRENT, TIMESTAMP_ONE_WEEK_AGO, -ONE_DAY):
        daily_data = get_time_slot_data(timestamp)
        if not headers_written and daily_data:
            writer.writerow(daily_data[0].keys())
            headers_written = True
        if daily_data:
            for entry in daily_data:
                writer.writerow(entry.values())