06_scrape_historic_data_for_assets.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import requests\n",
    "import json\n",
    "from datetime import datetime, timedelta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "bearer_token = 'aaaa'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Request for 541983310278725782 on 2024-01-31 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-01-31 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-01-31 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-01-31 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-01-31 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-01 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-01 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-01 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-01 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-01 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-02 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-02 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-02 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-02 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-02 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-03 failed with status code 429.\n",
      "Request for 541792416037150809 on 2024-02-03 failed with status code 429.\n",
      "Request for 541480930594258894 on 2024-02-03 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-03 failed with status code 429.\n",
      "Request for 541560923639711466 on 2024-02-03 failed with status code 429.\n",
      "Request for 541983310278725782 on 2024-02-04 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-04 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-04 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-04 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-04 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-05 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-05 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-05 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-05 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-05 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-06 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-06 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-06 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-06 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-06 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-07 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-07 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-07 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-07 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-07 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-08 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-08 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-08 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-08 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-08 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-09 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-09 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-09 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-09 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-09 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-10 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-10 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-10 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-10 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-10 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-11 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-11 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-11 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-11 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-11 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-12 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-12 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-12 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-12 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-12 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-13 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-13 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-13 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-13 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-13 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-14 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-14 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-14 failed with status code 429.\n",
      "Request for 541261957970628703 on 2024-02-14 failed with status code 429.\n",
      "Request for 541560923639711466 on 2024-02-14 failed with status code 429.\n",
      "Request for 541983310278725782 on 2024-02-15 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-15 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-15 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-15 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-15 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-16 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-16 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-16 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-16 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-16 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-17 failed with status code 429.\n",
      "Request for 541792416037150809 on 2024-02-17 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-17 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-17 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-17 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-18 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-18 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-18 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-18 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-18 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-19 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-19 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-19 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-19 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-19 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-20 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-20 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-20 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-20 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-20 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-21 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-21 failed with status code 429.\n",
      "Request for 541480930594258894 on 2024-02-21 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-21 failed with status code 429.\n",
      "Request for 541560923639711466 on 2024-02-21 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-22 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-22 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-22 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-22 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-22 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-23 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-23 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-23 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-23 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-23 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-24 failed with status code 429.\n",
      "Request for 541792416037150809 on 2024-02-24 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-24 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-24 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-24 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-25 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-25 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-25 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-25 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-25 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-26 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-26 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-26 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-26 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-26 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-27 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-27 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-27 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-27 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-27 failed with status code 429.\n",
      "Request for 541983310278725782 on 2024-02-28 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-28 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-28 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-28 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-28 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-02-29 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-02-29 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-02-29 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-02-29 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-02-29 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-01 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-01 failed with status code 429.\n",
      "Request for 541480930594258894 on 2024-03-01 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-01 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-01 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-02 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-02 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-02 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-02 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-02 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-03 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-03 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-03 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-03 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-03 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-04 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-04 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-04 failed with status code 429.\n",
      "Request for 541261957970628703 on 2024-03-04 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-04 failed with status code 429.\n",
      "Request for 541983310278725782 on 2024-03-05 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-05 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-05 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-05 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-05 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-06 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-06 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-06 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-06 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-06 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-07 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-07 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-07 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-07 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-07 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-08 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-08 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-08 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-08 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-08 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-09 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-09 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-09 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-09 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-09 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-10 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-10 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-10 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-10 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-10 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-11 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-11 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-11 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-11 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-11 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-12 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-12 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-12 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-12 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-12 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-13 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-13 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-13 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-13 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-13 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-14 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-14 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-14 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-14 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-14 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-15 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-15 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-15 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-15 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-15 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-16 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-16 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-16 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-16 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-16 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-17 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-17 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-17 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-17 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-17 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-18 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-18 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-18 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-18 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-18 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-19 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-19 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-19 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-19 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-19 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-20 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-20 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-20 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-20 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-20 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-21 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-21 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-21 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-21 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-21 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-22 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-22 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-22 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-22 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-22 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-23 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-23 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-23 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-23 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-23 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-24 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-24 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-24 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-24 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-24 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-25 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-25 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-25 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-25 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-25 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-26 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-26 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-26 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-26 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-26 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-27 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-27 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-27 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-27 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-27 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-28 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-28 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-28 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-28 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-28 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-29 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-29 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-29 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-29 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-29 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-30 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-30 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-30 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-30 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-30 failed with status code 400.\n",
      "Request for 541983310278725782 on 2024-03-31 failed with status code 400.\n",
      "Request for 541792416037150809 on 2024-03-31 failed with status code 400.\n",
      "Request for 541480930594258894 on 2024-03-31 failed with status code 400.\n",
      "Request for 541261957970628703 on 2024-03-31 failed with status code 400.\n",
      "Request for 541560923639711466 on 2024-03-31 failed with status code 400.\n"
     ]
    }
   ],
   "source": [
    "# Define the EAN numbers and the date range\n",
    "ean_numbers = ['541983310278725782', '541792416037150809', '541480930594258894', '541261957970628703', '541560923639711466']\n",
    "start_date = datetime(2024, 1, 31)\n",
    "end_date = datetime(2024, 3, 31)\n",
    "\n",
    "headers = {\n",
    "    'Host': 'api-acc.traxes.io',\n",
    "    'User-Agent': 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:15.0) Gecko/20100101 Firefox/15.0.1',\n",
    "    'Accept': 'application/json',\n",
    "    'Accept-Encoding': 'gzip, deflate, br',\n",
    "    'Connection': 'keep-alive',\n",
    "    'X-Requested-With': 'XMLHttpRequest',\n",
    "    'Authorization': f'Bearer {bearer_token}',\n",
    "}\n",
    "\n",
    "\n",
    "# Loop over each date in the range\n",
    "date = start_date\n",
    "while date <= end_date:\n",
    "    # Format the date as a string\n",
    "    date_str = date.strftime('%Y-%m-%d')\n",
    "\n",
    "    # Loop over each EAN number\n",
    "    for ean in ean_numbers:\n",
    "\n",
    "        # check if the file already exists\n",
    "        if os.path.exists(f'data_assets/{ean}_{date_str}.json'):\n",
    "            print(f'File {ean}_{date_str}.json already exists -- skip!')\n",
    "            continue\n",
    "\n",
    "        # Define the URL for the request\n",
    "        url = f'https://api-acc.traxes.io/hack24/prprd/assets/states?ean={ean}&startDate={date_str}T00:00:00Z&endDate={date_str}T23:59:00Z'\n",
    "\n",
    "        # Make the GET request\n",
    "        response = requests.get(url, headers=headers)\n",
    "\n",
    "        # Check if the request was successful\n",
    "        if response.status_code == 200:\n",
    "            # Save the response as a JSON file\n",
    "            with open(f'data_assets/{ean}_{date_str}.json', 'w') as f:\n",
    "                json.dump(response.json(), f)\n",
    "                print(f'Request for {ean} on {date_str} successful.')\n",
    "        else:\n",
    "            print(f'Request for {ean} on {date_str} failed with status code {response.status_code}.')\n",
    "\n",
    "\n",
    "    # Move to the next date\n",
    "    date += timedelta(days=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}