ohmFraxBorrowers.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "outputs": [],
   "source": [
    "from datetime import datetime\n",
    "import datetime as dt\n",
    "import time\n",
    "from subgrounds.subgraph import SyntheticField, FieldPath\n",
    "from subgrounds.subgrounds import Subgrounds\n",
    "import pandas as pd\n",
    "import duckdb as db\n",
    "import IPython as ip\n",
    "import  os as os"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "outputs": [
    {
     "data": {
      "text/plain": "'D:\\\\Dropbox\\\\Documents\\\\Edgecaser LLC\\\\Projects\\\\Olympus\\\\Econohmetrics\\\\Lending'"
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "global file\n",
    "file = input('Selet a folder to save output') ##enter your file path here - the file is in the repo \"summary_stats.csv\".\n",
    "file"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "outputs": [],
   "source": [
    "sg = Subgrounds()\n",
    "apiKey = input('API Key, please')"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "outputs": [],
   "source": [
    "#https://api.thegraph.com/subgraphs/name/frax-finance-data/fraxlend-subgraph---mainnet\n",
    "#'https://gateway.thegraph.com/api/'+apiKey+'/subgraphs/id/GELTrjPJYEzxyp6Y2CtEaYpGHcJNrJA6i5Ci4KfJSEsf'\n",
    "\n",
    "frax = sg.load_api('https://gateway.thegraph.com/api/'+apiKey+'/subgraphs/id/GELTrjPJYEzxyp6Y2CtEaYpGHcJNrJA6i5Ci4KfJSEsf')"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "outputs": [],
   "source": [
    "fraxPoolQuery = frax.Query.pairs(\n",
    "        orderBy='id',\n",
    "        orderDirection='desc',\n",
    "        first=1000,\n",
    "        #skip = 500,\n",
    "        where={ 'symbol': 'fFRAX(gOHM)-11' }\n",
    ")\n"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "outputs": [
    {
     "data": {
      "text/plain": "                                   pairs_positions_id  \\\n0   0x66bf36dba79d4606039f04b32946a260bcd3ff52-0x0...   \n1   0x66bf36dba79d4606039f04b32946a260bcd3ff52-0x0...   \n2   0x66bf36dba79d4606039f04b32946a260bcd3ff52-0x0...   \n3   0x66bf36dba79d4606039f04b32946a260bcd3ff52-0x0...   \n4   0x66bf36dba79d4606039f04b32946a260bcd3ff52-0x0...   \n..                                                ...   \n95  0x66bf36dba79d4606039f04b32946a260bcd3ff52-0xd...   \n96  0x66bf36dba79d4606039f04b32946a260bcd3ff52-0xd...   \n97  0x66bf36dba79d4606039f04b32946a260bcd3ff52-0xd...   \n98  0x66bf36dba79d4606039f04b32946a260bcd3ff52-0xd...   \n99  0x66bf36dba79d4606039f04b32946a260bcd3ff52-0xd...   \n\n                       pairs_positions_pair_id  \\\n0   0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n1   0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n2   0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n3   0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n4   0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n..                                         ...   \n95  0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n96  0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n97  0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n98  0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n99  0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n\n                       pairs_positions_user_id  \\\n0   0x002525a77d262dd11ec63c9146a821b11564ce29   \n1   0x0056d1fd2ca3c0f3a7b6ed6cdd1f1f104b4bf9a9   \n2   0x03da5c3b75503a1dda58e2bd23d4726b5ee8dd26   \n3   0x0430c0cd447397d5411aea19933165bd96c46fe3   \n4   0x044a9c43e95aa9fd28eea25131a62b602d304f1f   \n..                                         ...   \n95  0xd22a1c6cc90d6c45e81bb94c641f400ce51674e1   \n96  0xd50ec16851b00e48333699d66856207a416819f0   \n97  0xd6bf9d9079139dbb3a4fdb84b07efc75ea77838f   \n98  0xd6ee257dc510ff6682fa54689d87ace46c8c79cf   \n99  0xd84e11bee5d555ccd905817cb8cbbd5b6e6c4f0d   \n\n   pairs_positions_borrowedAssetShare  \\\n0                                   0   \n1                                   0   \n2            603451010180821502480014   \n3            449162045059532282112442   \n4             39553030322272277177842   \n..                                ...   \n95                                  1   \n96                                  0   \n97                                  0   \n98                5806674184474418752   \n99                                  0   \n\n   pairs_positions_depositedCollateralAmount pairs_positions_lentAssetShare  \\\n0                                          0       323481593503624709745993   \n1                                          0                              0   \n2                      450000000000000000000                              0   \n3                      294490000000000000000                              0   \n4                       40000000000000000000                              0   \n..                                       ...                            ...   \n95                          8726469452777320                              0   \n96                                         0                              0   \n97                                         0        24940628625507646481048   \n98                          3539531962187219                              0   \n99                                         0         5326174593375284588216   \n\n    pairs_positions_block  pairs_positions_timestamp  \\\n0                16438134                 1674098507   \n1                16532117                 1675232159   \n2                16307544                 1672523423   \n3                16544254                 1675378871   \n4                16490447                 1674729563   \n..                    ...                        ...   \n95               16349773                 1673032619   \n96               16402137                 1673664299   \n97               16270488                 1672076531   \n98               16112012                 1670163767   \n99               16507710                 1674937763   \n\n                                      pairs_id  \\\n0   0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n1   0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n2   0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n3   0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n4   0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n..                                         ...   \n95  0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n96  0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n97  0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n98  0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n99  0x66bf36dba79d4606039f04b32946a260bcd3ff52   \n\n                                           pairs_name    pairs_symbol  \\\n0   Fraxlend Interest Bearing FRAX (Governance OHM...  fFRAX(gOHM)-11   \n1   Fraxlend Interest Bearing FRAX (Governance OHM...  fFRAX(gOHM)-11   \n2   Fraxlend Interest Bearing FRAX (Governance OHM...  fFRAX(gOHM)-11   \n3   Fraxlend Interest Bearing FRAX (Governance OHM...  fFRAX(gOHM)-11   \n4   Fraxlend Interest Bearing FRAX (Governance OHM...  fFRAX(gOHM)-11   \n..                                                ...             ...   \n95  Fraxlend Interest Bearing FRAX (Governance OHM...  fFRAX(gOHM)-11   \n96  Fraxlend Interest Bearing FRAX (Governance OHM...  fFRAX(gOHM)-11   \n97  Fraxlend Interest Bearing FRAX (Governance OHM...  fFRAX(gOHM)-11   \n98  Fraxlend Interest Bearing FRAX (Governance OHM...  fFRAX(gOHM)-11   \n99  Fraxlend Interest Bearing FRAX (Governance OHM...  fFRAX(gOHM)-11   \n\n                                pairs_asset_id  \\\n0   0x853d955acef822db058eb8505911ed77f175b99e   \n1   0x853d955acef822db058eb8505911ed77f175b99e   \n2   0x853d955acef822db058eb8505911ed77f175b99e   \n3   0x853d955acef822db058eb8505911ed77f175b99e   \n4   0x853d955acef822db058eb8505911ed77f175b99e   \n..                                         ...   \n95  0x853d955acef822db058eb8505911ed77f175b99e   \n96  0x853d955acef822db058eb8505911ed77f175b99e   \n97  0x853d955acef822db058eb8505911ed77f175b99e   \n98  0x853d955acef822db058eb8505911ed77f175b99e   \n99  0x853d955acef822db058eb8505911ed77f175b99e   \n\n                           pairs_asset_address  pairs_asset_decimals  \\\n0   0x853d955acef822db058eb8505911ed77f175b99e                    18   \n1   0x853d955acef822db058eb8505911ed77f175b99e                    18   \n2   0x853d955acef822db058eb8505911ed77f175b99e                    18   \n3   0x853d955acef822db058eb8505911ed77f175b99e                    18   \n4   0x853d955acef822db058eb8505911ed77f175b99e                    18   \n..                                         ...                   ...   \n95  0x853d955acef822db058eb8505911ed77f175b99e                    18   \n96  0x853d955acef822db058eb8505911ed77f175b99e                    18   \n97  0x853d955acef822db058eb8505911ed77f175b99e                    18   \n98  0x853d955acef822db058eb8505911ed77f175b99e                    18   \n99  0x853d955acef822db058eb8505911ed77f175b99e                    18   \n\n   pairs_asset_name pairs_asset_symbol       pairs_asset_totalSupply  \\\n0              Frax               FRAX  1491128187367401878671217133   \n1              Frax               FRAX  1491128187367401878671217133   \n2              Frax               FRAX  1491128187367401878671217133   \n3              Frax               FRAX  1491128187367401878671217133   \n4              Frax               FRAX  1491128187367401878671217133   \n..              ...                ...                           ...   \n95             Frax               FRAX  1491128187367401878671217133   \n96             Frax               FRAX  1491128187367401878671217133   \n97             Frax               FRAX  1491128187367401878671217133   \n98             Frax               FRAX  1491128187367401878671217133   \n99             Frax               FRAX  1491128187367401878671217133   \n\n    pairs_asset_pairAssetCount  pairs_asset_pairCollateralCount  \n0                           12                                0  \n1                           12                                0  \n2                           12                                0  \n3                           12                                0  \n4                           12                                0  \n..                         ...                              ...  \n95                          12                                0  \n96                          12                                0  \n97                          12                                0  \n98                          12                                0  \n99                          12                                0  \n\n[100 rows x 19 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>pairs_positions_id</th>\n      <th>pairs_positions_pair_id</th>\n      <th>pairs_positions_user_id</th>\n      <th>pairs_positions_borrowedAssetShare</th>\n      <th>pairs_positions_depositedCollateralAmount</th>\n      <th>pairs_positions_lentAssetShare</th>\n      <th>pairs_positions_block</th>\n      <th>pairs_positions_timestamp</th>\n      <th>pairs_id</th>\n      <th>pairs_name</th>\n      <th>pairs_symbol</th>\n      <th>pairs_asset_id</th>\n      <th>pairs_asset_address</th>\n      <th>pairs_asset_decimals</th>\n      <th>pairs_asset_name</th>\n      <th>pairs_asset_symbol</th>\n      <th>pairs_asset_totalSupply</th>\n      <th>pairs_asset_pairAssetCount</th>\n      <th>pairs_asset_pairCollateralCount</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-0x0...</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>0x002525a77d262dd11ec63c9146a821b11564ce29</td>\n      <td>0</td>\n      <td>0</td>\n      <td>323481593503624709745993</td>\n      <td>16438134</td>\n      <td>1674098507</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>Fraxlend Interest Bearing FRAX (Governance OHM...</td>\n      <td>fFRAX(gOHM)-11</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>18</td>\n      <td>Frax</td>\n      <td>FRAX</td>\n      <td>1491128187367401878671217133</td>\n      <td>12</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-0x0...</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>0x0056d1fd2ca3c0f3a7b6ed6cdd1f1f104b4bf9a9</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>16532117</td>\n      <td>1675232159</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>Fraxlend Interest Bearing FRAX (Governance OHM...</td>\n      <td>fFRAX(gOHM)-11</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>18</td>\n      <td>Frax</td>\n      <td>FRAX</td>\n      <td>1491128187367401878671217133</td>\n      <td>12</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-0x0...</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>0x03da5c3b75503a1dda58e2bd23d4726b5ee8dd26</td>\n      <td>603451010180821502480014</td>\n      <td>450000000000000000000</td>\n      <td>0</td>\n      <td>16307544</td>\n      <td>1672523423</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>Fraxlend Interest Bearing FRAX (Governance OHM...</td>\n      <td>fFRAX(gOHM)-11</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>18</td>\n      <td>Frax</td>\n      <td>FRAX</td>\n      <td>1491128187367401878671217133</td>\n      <td>12</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-0x0...</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>0x0430c0cd447397d5411aea19933165bd96c46fe3</td>\n      <td>449162045059532282112442</td>\n      <td>294490000000000000000</td>\n      <td>0</td>\n      <td>16544254</td>\n      <td>1675378871</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>Fraxlend Interest Bearing FRAX (Governance OHM...</td>\n      <td>fFRAX(gOHM)-11</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>18</td>\n      <td>Frax</td>\n      <td>FRAX</td>\n      <td>1491128187367401878671217133</td>\n      <td>12</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-0x0...</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>0x044a9c43e95aa9fd28eea25131a62b602d304f1f</td>\n      <td>39553030322272277177842</td>\n      <td>40000000000000000000</td>\n      <td>0</td>\n      <td>16490447</td>\n      <td>1674729563</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>Fraxlend Interest Bearing FRAX (Governance OHM...</td>\n      <td>fFRAX(gOHM)-11</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>18</td>\n      <td>Frax</td>\n      <td>FRAX</td>\n      <td>1491128187367401878671217133</td>\n      <td>12</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>95</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-0xd...</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>0xd22a1c6cc90d6c45e81bb94c641f400ce51674e1</td>\n      <td>1</td>\n      <td>8726469452777320</td>\n      <td>0</td>\n      <td>16349773</td>\n      <td>1673032619</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>Fraxlend Interest Bearing FRAX (Governance OHM...</td>\n      <td>fFRAX(gOHM)-11</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>18</td>\n      <td>Frax</td>\n      <td>FRAX</td>\n      <td>1491128187367401878671217133</td>\n      <td>12</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>96</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-0xd...</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>0xd50ec16851b00e48333699d66856207a416819f0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>0</td>\n      <td>16402137</td>\n      <td>1673664299</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>Fraxlend Interest Bearing FRAX (Governance OHM...</td>\n      <td>fFRAX(gOHM)-11</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>18</td>\n      <td>Frax</td>\n      <td>FRAX</td>\n      <td>1491128187367401878671217133</td>\n      <td>12</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>97</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-0xd...</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>0xd6bf9d9079139dbb3a4fdb84b07efc75ea77838f</td>\n      <td>0</td>\n      <td>0</td>\n      <td>24940628625507646481048</td>\n      <td>16270488</td>\n      <td>1672076531</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>Fraxlend Interest Bearing FRAX (Governance OHM...</td>\n      <td>fFRAX(gOHM)-11</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>18</td>\n      <td>Frax</td>\n      <td>FRAX</td>\n      <td>1491128187367401878671217133</td>\n      <td>12</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>98</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-0xd...</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>0xd6ee257dc510ff6682fa54689d87ace46c8c79cf</td>\n      <td>5806674184474418752</td>\n      <td>3539531962187219</td>\n      <td>0</td>\n      <td>16112012</td>\n      <td>1670163767</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>Fraxlend Interest Bearing FRAX (Governance OHM...</td>\n      <td>fFRAX(gOHM)-11</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>18</td>\n      <td>Frax</td>\n      <td>FRAX</td>\n      <td>1491128187367401878671217133</td>\n      <td>12</td>\n      <td>0</td>\n    </tr>\n    <tr>\n      <th>99</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-0xd...</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>0xd84e11bee5d555ccd905817cb8cbbd5b6e6c4f0d</td>\n      <td>0</td>\n      <td>0</td>\n      <td>5326174593375284588216</td>\n      <td>16507710</td>\n      <td>1674937763</td>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52</td>\n      <td>Fraxlend Interest Bearing FRAX (Governance OHM...</td>\n      <td>fFRAX(gOHM)-11</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>18</td>\n      <td>Frax</td>\n      <td>FRAX</td>\n      <td>1491128187367401878671217133</td>\n      <td>12</td>\n      <td>0</td>\n    </tr>\n  </tbody>\n</table>\n<p>100 rows × 19 columns</p>\n</div>"
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "listLength=0\n",
    "ticker = 1\n",
    "frax_borrowers_db = pd.DataFrame()\n",
    "fraxPools = sg.query_df([\n",
    "\n",
    "    fraxPoolQuery.positions\n",
    "    ,fraxPoolQuery.id\n",
    "    ,fraxPoolQuery.name\n",
    "    ,fraxPoolQuery.symbol\n",
    "    ,fraxPoolQuery.asset\n",
    "\n",
    "]\n",
    ")\n",
    "\n",
    "listLength = len(fraxPools)\n",
    "userdb_length = len(fraxPools)\n",
    "frax_borrowers_db = fraxPools\n",
    "\n",
    "\n",
    "fraxPools.head(200)"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Done. Total Records collected:  100\n"
     ]
    }
   ],
   "source": [
    "while listLength>999:\n",
    "    #listLength=0\n",
    "    skipValue = (ticker)*(1000)\n",
    "    fraxPoolQuery = frax.Query.pairs(\n",
    "            orderBy='id',\n",
    "            orderDirection='desc',\n",
    "            skip =(skipValue),\n",
    "            first=1000,\n",
    "            where={ 'symbol': 'fFRAX(gOHM)-11' }\n",
    "    )\n",
    "\n",
    "    fraxPools = sg.query_df([\n",
    "\n",
    "        fraxPoolQuery.positions\n",
    "        ,fraxPoolQuery.id\n",
    "        ,fraxPoolQuery.name\n",
    "        ,fraxPoolQuery.symbol\n",
    "        ,fraxPoolQuery.asset\n",
    "\n",
    "    ]\n",
    "    )\n",
    "\n",
    "    frax_borrowers_db=pd.concat([frax_borrowers_db, fraxPools])\n",
    "    recordTimestamp = pool_list.iat[ticker,7]\n",
    "    ticker = ticker+1\n",
    "    userdb_length = len(frax_borrowers_db)\n",
    "    listLength = len(fraxPools)\n",
    "    userid = fraxPools.iat[ticker,2]\n",
    "    print(\"records collected: \", listLength, \" - latest user: \",userid , \" - userdb length: \", userdb_length, \" - latest record from: \", recordTimestamp)\n",
    "print(\"Done. Total Records collected: \", userdb_length)"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "outputs": [],
   "source": [
    "fraxBorrowersDbTimed= db.query(\"select \"\n",
    "                   \"    * \"\n",
    "                        \" ,to_timestamp(pairs_positions_timestamp) dateTime \"\n",
    "                   \"From frax_borrowers_db \"\n",
    "                   #\"where lower(liquidityPools_name) like lower('%olympus%') \"\n",
    "                    #    \"or lower(pairs_token1_symbol) like lower('%OHM%')  \"\n",
    "                   #\" limit 100 \"\n",
    "                   ).df()"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "outputs": [],
   "source": [
    "fraxBorrowersDbTimed.head(10)"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "outputs": [
    {
     "data": {
      "text/plain": "'D:\\\\Dropbox\\\\Documents\\\\Edgecaser LLC\\\\Projects\\\\Olympus\\\\Econohmetrics\\\\Lending/frax_borrowers_snapshotFeb-04-2023100records.csv'"
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path =file+'/frax_borrowers_snapshot'+str(date.today().strftime(\"%b-%d-%Y\"))+str(len(frax_borrowers_db))+'records.csv'\n",
    "path"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "outputs": [],
   "source": [
    "fraxBorrowersDbTimed.to_csv(path, index = False)"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "actionListLength=0\n",
    "actionTicker = 0\n",
    "fraxUsersDb = pd.DataFrame()\n",
    "actionsQuery = frax.Query.actions(\n",
    "         orderBy='id'\n",
    "        ,orderDirection='desc'\n",
    "        ,first=1000\n",
    "        #,skip = 1000\n",
    "        #,where = [frax.Query.actions.token.id == '0x66bf36dba79d4606039f04b32946a260bcd3ff52']\n",
    "        ,where={ 'pair': '0x66bf36dba79d4606039f04b32946a260bcd3ff52' }\n",
    "        #,where = {'positions.pairid':'0x66bf36dba79d4606039f04b32946a260bcd3ff52'}\n",
    "    #{'users_positions_pair_id':'0x66bf36dba79d4606039f04b32946a260bcd3ff52'}\n",
    "\n",
    ")\n",
    "\n",
    "actions= sg.query_df([\n",
    "    actionsQuery.id\n",
    "    ,actionsQuery.type\n",
    "    ,actionsQuery.amount\n",
    "    ,actionsQuery.share\n",
    "    ,actionsQuery.timestamp\n",
    "    ,actionsQuery.block\n",
    "    ,actionsQuery.token\n",
    "    ,actionsQuery.root\n",
    "    ]\n",
    ")\n",
    "\n",
    "actionListLength = len(actions)\n",
    "actionsDbLength = len(actions)\n",
    "actionsDb = actions\n",
    "\n",
    "\n",
    "\n",
    "actionsDb.head(1000)"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "iterations:  0 Lines skipped:  0 records collected:  1000  - latest recordID:  removeCollateral   0x12a8cb34e5cb26d0ee0b0cc211aabb0b03f636409dbd8e967dfed28e6eea90ba  - actions DB length:  1000  - latest record from:  2023-02-10 14:42:47 0 days ago\n",
      "iterations:  1 Lines skipped:  1000 records collected:  1000  - latest recordID:  repayAsset   0xc7c1739911ae71f7726d1d32214edb8161a341f7fcd7dc6d466681da295491ec  - actions DB length:  2000  - latest record from:  2023-02-10 14:41:35 0 days ago\n",
      "iterations:  2 Lines skipped:  2000 records collected:  1000  - latest recordID:  repayAsset   0x40e939c94b527bd4eb9f8f102cfe3c179b61f0da6bb7bb6a5ee815af6d2eaa11  - actions DB length:  3000  - latest record from:  2023-02-10 09:15:35 0 days ago\n",
      "iterations:  3 Lines skipped:  3000 records collected:  1000  - latest recordID:  borrowAsset   0x6dc275d27f2cbca7232c6fa9019ea1c84a3983636a7c102b0759efc8f5662b44  - actions DB length:  4000  - latest record from:  2023-02-10 09:14:11 0 days ago\n",
      "iterations:  4 Lines skipped:  4000 records collected:  1000  - latest recordID:  repayAsset   0x83e2ea08ec4f8a38735c7ad01954ce62ae9f79b84e7d8aadec3c4296ae5cc3bf  - actions DB length:  5000  - latest record from:  2023-02-10 08:51:11 0 days ago\n",
      "iterations:  5 Lines skipped:  5000 records collected:  1000  - latest recordID:  removeCollateral   0x004795cddb57f7037626cc0ca26e84c7507dde798b5a88696faec6b2f4ba4cf4  - actions DB length:  6000  - latest record from:  2023-02-10 08:47:23 0 days ago\n",
      "iterations:  6 Lines skipped:  6000 records collected:  1000  - latest recordID:  removeCollateral   0x17df17ec4b65d028374f6407d7998a40e2a4fdca7cbeb09bd9e8d4844efa6107  - actions DB length:  7000  - latest record from:  2023-02-10 05:46:59 0 days ago\n",
      "iterations:  7 Lines skipped:  7000 records collected:  1000  - latest recordID:  borrowAsset   0xd76a5cb0e7219544a326f05a05bc08f8e79de4947c20d926adf59efa1c0d396b  - actions DB length:  8000  - latest record from:  2023-02-10 05:28:11 0 days ago\n",
      "iterations:  8 Lines skipped:  8000 records collected:  1000  - latest recordID:  repayAsset   0x5dee647c2e8ebfad8bac45dd1ca3eab67b4841ef169283d0e759391177ad006b  - actions DB length:  9000  - latest record from:  2023-02-10 04:42:35 0 days ago\n",
      "iterations:  9 Lines skipped:  9000 records collected:  1000  - latest recordID:  borrowAsset   0xd35638a578d8f0b2134f2e09f085f4d4d2dbb1494604fc0dbd819234e3390aaf+1  - actions DB length:  10000  - latest record from:  2023-02-09 14:44:11 1 days ago\n",
      "iterations:  10 Lines skipped:  10000 records collected:  1000  - latest recordID:  addCollateral   0xd35638a578d8f0b2134f2e09f085f4d4d2dbb1494604fc0dbd819234e3390aaf  - actions DB length:  11000  - latest record from:  2023-02-09 14:44:11 1 days ago\n",
      "iterations:  11 Lines skipped:  11000 records collected:  1000  - latest recordID:  borrowAsset   0x3092d76c46045fdcf57272151e55e1b105bd4b7d4063c71cd786bf1ce5df9205  - actions DB length:  12000  - latest record from:  2023-02-09 14:41:47 1 days ago\n",
      "iterations:  12 Lines skipped:  12000 records collected:  1000  - latest recordID:  borrowAsset   0xa20176fd6cb8470bb538af582d7d97e27bbf75135d8ac2f0342c67e7a4b25bc8+1  - actions DB length:  13000  - latest record from:  2023-02-09 13:41:11 1 days ago\n",
      "iterations:  13 Lines skipped:  13000 records collected:  1000  - latest recordID:  addCollateral   0xa20176fd6cb8470bb538af582d7d97e27bbf75135d8ac2f0342c67e7a4b25bc8  - actions DB length:  14000  - latest record from:  2023-02-09 13:41:11 1 days ago\n",
      "iterations:  14 Lines skipped:  14000 records collected:  1000  - latest recordID:  borrowAsset   0x2dc9bc4f7c7ac1708768d1f6f6e6a41b8fb4964fd89410ef265d79d104d66384+1  - actions DB length:  15000  - latest record from:  2023-02-09 12:12:59 1 days ago\n",
      "iterations:  15 Lines skipped:  15000 records collected:  1000  - latest recordID:  addCollateral   0x2dc9bc4f7c7ac1708768d1f6f6e6a41b8fb4964fd89410ef265d79d104d66384  - actions DB length:  16000  - latest record from:  2023-02-09 12:12:59 1 days ago\n",
      "iterations:  16 Lines skipped:  16000 records collected:  1000  - latest recordID:  borrowAsset   0x5dea5a1baef298676a0c47666ca76db0d00637a96750e0d04f97f4f11e555127  - actions DB length:  17000  - latest record from:  2023-02-09 11:55:47 1 days ago\n",
      "iterations:  17 Lines skipped:  17000 records collected:  1000  - latest recordID:  borrowAsset   0x2c4738e7f57d0ef25cef1541393689e07f7f01b8774ac93e4925eb72eb813047+1  - actions DB length:  18000  - latest record from:  2023-02-09 11:31:47 1 days ago\n",
      "iterations:  18 Lines skipped:  18000 records collected:  1000  - latest recordID:  addCollateral   0x2c4738e7f57d0ef25cef1541393689e07f7f01b8774ac93e4925eb72eb813047  - actions DB length:  19000  - latest record from:  2023-02-09 11:31:47 1 days ago\n",
      "iterations:  19 Lines skipped:  19000 records collected:  1000  - latest recordID:  borrowAsset   0x5ab8113bf249f443569eb7a2bf142308a907e50b70ddd36e4e8e7042877c6eff+1  - actions DB length:  20000  - latest record from:  2023-02-09 10:48:59 1 days ago\n",
      "iterations:  20 Lines skipped:  20000 records collected:  1000  - latest recordID:  addCollateral   0x5ab8113bf249f443569eb7a2bf142308a907e50b70ddd36e4e8e7042877c6eff  - actions DB length:  21000  - latest record from:  2023-02-09 10:48:59 1 days ago\n",
      "iterations:  21 Lines skipped:  21000 records collected:  1000  - latest recordID:  borrowAsset   0x45dbb93901bca44a7d83c1ba9aec12bc1450a48f70b65b310782e7b9c69e5857+1  - actions DB length:  22000  - latest record from:  2023-02-09 07:25:47 1 days ago\n",
      "iterations:  22 Lines skipped:  22000 records collected:  1000  - latest recordID:  addCollateral   0x45dbb93901bca44a7d83c1ba9aec12bc1450a48f70b65b310782e7b9c69e5857  - actions DB length:  23000  - latest record from:  2023-02-09 07:25:47 1 days ago\n",
      "iterations:  23 Lines skipped:  23000 records collected:  1000  - latest recordID:  borrowAsset   0xd643ca592784c258342d02d2e22b4480e6b806a75d77fdbc7790b33eb4702268+1  - actions DB length:  24000  - latest record from:  2023-02-09 04:55:11 1 days ago\n",
      "iterations:  24 Lines skipped:  24000 records collected:  1000  - latest recordID:  addCollateral   0xd643ca592784c258342d02d2e22b4480e6b806a75d77fdbc7790b33eb4702268  - actions DB length:  25000  - latest record from:  2023-02-09 04:55:11 1 days ago\n",
      "iterations:  25 Lines skipped:  25000 records collected:  1000  - latest recordID:  removeCollateral   0x6d8ce1e40ed662ba3327b182f9d9ffae9443fb13bfbb3e03dd5908727d60e7f8  - actions DB length:  26000  - latest record from:  2023-02-09 04:10:11 1 days ago\n",
      "iterations:  26 Lines skipped:  26000 records collected:  1000  - latest recordID:  removeCollateral   0x57883c70bcdb43a1aa8e169295aeac57f30c288c03e6b96a9e2827e551261b9f  - actions DB length:  27000  - latest record from:  2023-02-08 22:44:59 2 days ago\n",
      "iterations:  27 Lines skipped:  27000 records collected:  1000  - latest recordID:  removeCollateral   0xf1391d046913eca25021c8eb8974d370089e1cdc74f77bd8898f56c7330d5039  - actions DB length:  28000  - latest record from:  2023-02-08 22:40:35 2 days ago\n",
      "iterations:  28 Lines skipped:  28000 records collected:  1000  - latest recordID:  repayAsset   0x7f9a9b4079f340cc010ddcf1ccbac3db2e1ea4e29adb9fec370000858744d38c  - actions DB length:  29000  - latest record from:  2023-02-08 22:39:47 2 days ago\n",
      "iterations:  29 Lines skipped:  29000 records collected:  1000  - latest recordID:  borrowAsset   0x4017bc338022ebff43c95d17cd8ae339d3663b31aa7bc715be25e2a2e873d75c+1  - actions DB length:  30000  - latest record from:  2023-02-08 19:39:47 2 days ago\n",
      "iterations:  30 Lines skipped:  30000 records collected:  1000  - latest recordID:  addCollateral   0x4017bc338022ebff43c95d17cd8ae339d3663b31aa7bc715be25e2a2e873d75c  - actions DB length:  31000  - latest record from:  2023-02-08 19:39:47 2 days ago\n",
      "iterations:  31 Lines skipped:  31000 records collected:  1000  - latest recordID:  removeCollateral   0xb2dc4e73b817320ffcf34c86dc9d411786e37f8af2ad739fe9eba048b40c0126  - actions DB length:  32000  - latest record from:  2023-02-08 16:01:59 2 days ago\n",
      "iterations:  32 Lines skipped:  32000 records collected:  1000  - latest recordID:  repayAsset   0xbc537609adb35fdd165f22a83da392b898080e7e2b7046c595d42bb37e971e77  - actions DB length:  33000  - latest record from:  2023-02-08 16:00:35 2 days ago\n",
      "iterations:  33 Lines skipped:  33000 records collected:  1000  - latest recordID:  borrowAsset   0x7df62271c4a8279ff7bf52964c87454584b629575af66e377b9b53694f5b0112+1  - actions DB length:  34000  - latest record from:  2023-02-08 13:00:59 2 days ago\n",
      "iterations:  34 Lines skipped:  34000 records collected:  1000  - latest recordID:  addCollateral   0x7df62271c4a8279ff7bf52964c87454584b629575af66e377b9b53694f5b0112  - actions DB length:  35000  - latest record from:  2023-02-08 13:00:59 2 days ago\n",
      "iterations:  35 Lines skipped:  35000 records collected:  1000  - latest recordID:  borrowAsset   0x24436c0d5c6419ffac45c32d4115128f4075a9ace8720bf12dc8048de6086a42+1  - actions DB length:  36000  - latest record from:  2023-02-08 12:07:47 2 days ago\n",
      "iterations:  36 Lines skipped:  36000 records collected:  1000  - latest recordID:  addCollateral   0x24436c0d5c6419ffac45c32d4115128f4075a9ace8720bf12dc8048de6086a42  - actions DB length:  37000  - latest record from:  2023-02-08 12:07:47 2 days ago\n",
      "iterations:  37 Lines skipped:  37000 records collected:  1000  - latest recordID:  borrowAsset   0x5520cee4dfed2595a6f9d0de5f3b8f26b874112fa11efa5347785b23ceca27ab  - actions DB length:  38000  - latest record from:  2023-02-08 12:04:23 2 days ago\n",
      "iterations:  38 Lines skipped:  38000 records collected:  1000  - latest recordID:  borrowAsset   0x4e156dda6a27c39160c859b3b5327334d50c02b8d09fa3fa4c08164344f17217+1  - actions DB length:  39000  - latest record from:  2023-02-08 11:58:59 2 days ago\n",
      "iterations:  39 Lines skipped:  39000 records collected:  1000  - latest recordID:  addCollateral   0x4e156dda6a27c39160c859b3b5327334d50c02b8d09fa3fa4c08164344f17217  - actions DB length:  40000  - latest record from:  2023-02-08 11:58:59 2 days ago\n",
      "iterations:  40 Lines skipped:  40000 records collected:  1000  - latest recordID:  borrowAsset   0x4b3964dc8e347cb40ffbac555be28c2261df0f076aa61d4972a9fb5942151d2f  - actions DB length:  41000  - latest record from:  2023-02-08 11:56:23 2 days ago\n",
      "iterations:  41 Lines skipped:  41000 records collected:  1000  - latest recordID:  borrowAsset   0xfd08d4987b9ba88e59c23667c6c177ffeaab6f7d1af18194b1fa540212efd1b8+1  - actions DB length:  42000  - latest record from:  2023-02-08 08:38:11 2 days ago\n",
      "iterations:  42 Lines skipped:  42000 records collected:  1000  - latest recordID:  addCollateral   0xfd08d4987b9ba88e59c23667c6c177ffeaab6f7d1af18194b1fa540212efd1b8  - actions DB length:  43000  - latest record from:  2023-02-08 08:38:11 2 days ago\n",
      "iterations:  43 Lines skipped:  43000 records collected:  1000  - latest recordID:  repayAsset   0x87953dce0f55cdd157c52fb9ce2ede8c34012f0c2c2922e3f7e2d784bafc7f9b  - actions DB length:  44000  - latest record from:  2023-02-07 18:50:11 3 days ago\n",
      "iterations:  44 Lines skipped:  44000 records collected:  1000  - latest recordID:  removeCollateral   0xf7b38e66cb9f10e080eece1db80bd31c70298121a6df5fcb6436976b3f02b5ed  - actions DB length:  45000  - latest record from:  2023-02-07 17:43:23 3 days ago\n",
      "iterations:  45 Lines skipped:  45000 records collected:  1000  - latest recordID:  addCollateral   0x0509d1c3f87fb34f957cf8f474166a4960baf6b7f3209794fb850d826ab2b5c3  - actions DB length:  46000  - latest record from:  2023-02-07 14:24:59 3 days ago\n",
      "iterations:  46 Lines skipped:  46000 records collected:  1000  - latest recordID:  borrowAsset   0x16f81815f26c71a21323e3cf68772f0f2250263a2307559bda56ed0c697da404  - actions DB length:  47000  - latest record from:  2023-02-07 14:22:59 3 days ago\n",
      "iterations:  47 Lines skipped:  47000 records collected:  1000  - latest recordID:  borrowAsset   0x6d2b4b3ab5d7d7b20dc8abdb7ab009303a9f2614f03093afbc00ff83b256b55b+1  - actions DB length:  48000  - latest record from:  2023-02-07 14:22:11 3 days ago\n",
      "iterations:  48 Lines skipped:  48000 records collected:  1000  - latest recordID:  addCollateral   0x6d2b4b3ab5d7d7b20dc8abdb7ab009303a9f2614f03093afbc00ff83b256b55b  - actions DB length:  49000  - latest record from:  2023-02-07 14:22:11 3 days ago\n",
      "iterations:  49 Lines skipped:  49000 records collected:  1000  - latest recordID:  borrowAsset   0x5b9cb6e3e76280f768a0a171db73925c98489b3f25193e28eae3bb0bffbc0547+1  - actions DB length:  50000  - latest record from:  2023-02-07 10:35:23 3 days ago\n",
      "iterations:  50 Lines skipped:  50000 records collected:  1000  - latest recordID:  addCollateral   0x5b9cb6e3e76280f768a0a171db73925c98489b3f25193e28eae3bb0bffbc0547  - actions DB length:  51000  - latest record from:  2023-02-07 10:35:23 3 days ago\n",
      "iterations:  51 Lines skipped:  51000 records collected:  1000  - latest recordID:  borrowAsset   0x9be2488f1c1bd4e912249b7977d2112c7c778f8f4eddde715d4f335cef8a1ed2+1  - actions DB length:  52000  - latest record from:  2023-02-07 06:01:11 3 days ago\n",
      "iterations:  52 Lines skipped:  52000 records collected:  1000  - latest recordID:  addCollateral   0x9be2488f1c1bd4e912249b7977d2112c7c778f8f4eddde715d4f335cef8a1ed2  - actions DB length:  53000  - latest record from:  2023-02-07 06:01:11 3 days ago\n",
      "iterations:  53 Lines skipped:  53000 records collected:  1000  - latest recordID:  borrowAsset   0xbefa2e59d3e8d0c431dfac8ce9aca2e00fb0a17e66a56512be1b47b740d95089  - actions DB length:  54000  - latest record from:  2023-02-07 05:58:47 3 days ago\n",
      "iterations:  54 Lines skipped:  54000 records collected:  1000  - latest recordID:  repayAsset   0x780b2ae8e35f8c6155032b8211eb8e1fbdb0011af9147f5b05d5886cfd120ac5  - actions DB length:  55000  - latest record from:  2023-02-06 21:37:23 4 days ago\n",
      "iterations:  55 Lines skipped:  55000 records collected:  1000  - latest recordID:  borrowAsset   0x834ce05c7b0e411a74bac4beaead4639905451289a4762e6639336546f6f57aa  - actions DB length:  56000  - latest record from:  2023-02-06 19:18:11 4 days ago\n",
      "iterations:  56 Lines skipped:  56000 records collected:  1000  - latest recordID:  borrowAsset   0xd824db46f2929d7f851c883c6d8a16309ed1c6a4467b6199dc28d0bdc3e109f4+1  - actions DB length:  57000  - latest record from:  2023-02-06 19:17:23 4 days ago\n",
      "iterations:  57 Lines skipped:  57000 records collected:  1000  - latest recordID:  addCollateral   0xd824db46f2929d7f851c883c6d8a16309ed1c6a4467b6199dc28d0bdc3e109f4  - actions DB length:  58000  - latest record from:  2023-02-06 19:17:23 4 days ago\n",
      "iterations:  58 Lines skipped:  58000 records collected:  1000  - latest recordID:  removeAsset   0x364fc3214b25629d0d134c2a62aac9aaac6436dc219bbfc58c57798bc55871dd  - actions DB length:  59000  - latest record from:  2023-02-06 15:01:11 4 days ago\n",
      "iterations:  59 Lines skipped:  59000 records collected:  1000  - latest recordID:  borrowAsset   0x326e0444e2ccf71f1285954fdbbcc855c29485f92ea0a6d490a515a40dff7aec+1  - actions DB length:  60000  - latest record from:  2023-02-06 10:45:11 4 days ago\n",
      "iterations:  60 Lines skipped:  60000 records collected:  1000  - latest recordID:  addCollateral   0x326e0444e2ccf71f1285954fdbbcc855c29485f92ea0a6d490a515a40dff7aec  - actions DB length:  61000  - latest record from:  2023-02-06 10:45:11 4 days ago\n",
      "iterations:  61 Lines skipped:  61000 records collected:  1000  - latest recordID:  borrowAsset   0x6b99b9e2f74062143534c02a79920d1c33f6d56fcd051943e76778982bd2cdd9+1  - actions DB length:  62000  - latest record from:  2023-02-06 09:02:23 4 days ago\n",
      "iterations:  62 Lines skipped:  62000 records collected:  1000  - latest recordID:  addCollateral   0x6b99b9e2f74062143534c02a79920d1c33f6d56fcd051943e76778982bd2cdd9  - actions DB length:  63000  - latest record from:  2023-02-06 09:02:23 4 days ago\n",
      "iterations:  63 Lines skipped:  63000 records collected:  1000  - latest recordID:  removeCollateral   0x0b18b1c7c3dafc9ef9f513f540f1de376325ceec3962a5e8de18978a72efbebf  - actions DB length:  64000  - latest record from:  2023-02-06 08:52:11 4 days ago\n",
      "iterations:  64 Lines skipped:  64000 records collected:  1000  - latest recordID:  borrowAsset   0x996d854115a22865e3a5ac1a4ee49b33ce889ea4b8e6c67d764cf64804d315d3+1  - actions DB length:  65000  - latest record from:  2023-02-06 03:42:11 4 days ago\n",
      "iterations:  65 Lines skipped:  65000 records collected:  1000  - latest recordID:  addCollateral   0x996d854115a22865e3a5ac1a4ee49b33ce889ea4b8e6c67d764cf64804d315d3  - actions DB length:  66000  - latest record from:  2023-02-06 03:42:11 4 days ago\n",
      "iterations:  66 Lines skipped:  66000 records collected:  1000  - latest recordID:  removeCollateral   0x552a52cd82bbebd0c5c0a9927eb3038c02786eef571b471364e4bc58a8777051  - actions DB length:  67000  - latest record from:  2023-02-06 03:38:11 4 days ago\n",
      "iterations:  67 Lines skipped:  67000 records collected:  1000  - latest recordID:  addAsset   0xcbda7b3075b591cb56f138137c3a0473f29c824ed257f65f51fa421717b8431b  - actions DB length:  68000  - latest record from:  2023-02-05 21:13:59 5 days ago\n",
      "iterations:  68 Lines skipped:  68000 records collected:  1000  - latest recordID:  removeCollateral   0x60c347a83d10615197b96f4d23f6760e8947668d8ea33377c3f6d700b0999bc8  - actions DB length:  69000  - latest record from:  2023-02-05 16:27:35 5 days ago\n",
      "iterations:  69 Lines skipped:  69000 records collected:  1000  - latest recordID:  repayAsset   0xea0b3054fc21bd86b06f4f015561d14f12fa49c1e1127bf5b614a843de9b7c64  - actions DB length:  70000  - latest record from:  2023-02-05 16:25:23 5 days ago\n",
      "iterations:  70 Lines skipped:  70000 records collected:  1000  - latest recordID:  removeCollateral   0xc0e0cbfdf272c9176ad6fc9d5b25cdf33bfaafba6c8c22ebe91250778aec9e8b  - actions DB length:  71000  - latest record from:  2023-02-05 14:09:23 5 days ago\n",
      "iterations:  71 Lines skipped:  71000 records collected:  1000  - latest recordID:  repayAsset   0xbbc80a25645a9e2dc1d704832a11c0d442d7022d59a4d6959718d04bf3e7d0cc  - actions DB length:  72000  - latest record from:  2023-02-05 14:04:11 5 days ago\n",
      "iterations:  72 Lines skipped:  72000 records collected:  1000  - latest recordID:  borrowAsset   0xa979b2ca17af70bdbe5f6804cbfbdd885d26175a6ab19ae94c4b909aa3446e81  - actions DB length:  73000  - latest record from:  2023-02-05 11:39:11 5 days ago\n",
      "iterations:  73 Lines skipped:  73000 records collected:  1000  - latest recordID:  addCollateral   0xf79086c46e8db29afdfa2f26bc6f6e4f4ea9a58cdce3a7227379e7bfa00d2c92  - actions DB length:  74000  - latest record from:  2023-02-05 11:35:47 5 days ago\n",
      "iterations:  74 Lines skipped:  74000 records collected:  1000  - latest recordID:  borrowAsset   0x20a5beee4b3159a97bec055f86cb38f6418a693c87cff1ce8832610b2113ab71+1  - actions DB length:  75000  - latest record from:  2023-02-05 09:38:11 5 days ago\n",
      "iterations:  75 Lines skipped:  75000 records collected:  1000  - latest recordID:  addCollateral   0x20a5beee4b3159a97bec055f86cb38f6418a693c87cff1ce8832610b2113ab71  - actions DB length:  76000  - latest record from:  2023-02-05 09:38:11 5 days ago\n",
      "iterations:  76 Lines skipped:  76000 records collected:  1000  - latest recordID:  removeAsset   0x203a5a3c0c301fcd1a1439ef77d214f0ed7fc0b4796cf656671874f695449d70  - actions DB length:  77000  - latest record from:  2023-02-05 09:19:11 5 days ago\n",
      "iterations:  77 Lines skipped:  77000 records collected:  1000  - latest recordID:  removeAsset   0xc9ad8e2eab317298ee30b2bdb483effb0e40293e8ced5e2c82d93e4b98afe755  - actions DB length:  78000  - latest record from:  2023-02-05 01:32:11 5 days ago\n",
      "iterations:  78 Lines skipped:  78000 records collected:  1000  - latest recordID:  removeAsset   0x77d537ee18009ccc59d95c2704aa35615ea7501716a436ffbbad7687a145600a  - actions DB length:  79000  - latest record from:  2023-02-05 00:14:59 5 days ago\n",
      "iterations:  79 Lines skipped:  79000 records collected:  1000  - latest recordID:  addAsset   0x34def1c3f26d7857d5a1777b3065112f0802c95ee52bf46d1cba579861a3c649  - actions DB length:  80000  - latest record from:  2023-02-03 11:11:35 7 days ago\n",
      "iterations:  80 Lines skipped:  80000 records collected:  1000  - latest recordID:  removeAsset   0xc8471a07381cc2fbab59ee374586cea332bf39132a7f22b54fc50d6db2e59d30  - actions DB length:  81000  - latest record from:  2023-02-03 10:50:23 7 days ago\n",
      "iterations:  81 Lines skipped:  81000 records collected:  1000  - latest recordID:  addAsset   0xdea09eb1f1c443979719b5c2123fb80050c787851768fdfe0265ac690d589041  - actions DB length:  82000  - latest record from:  2023-02-03 08:56:59 7 days ago\n",
      "iterations:  82 Lines skipped:  82000 records collected:  1000  - latest recordID:  borrowAsset   0xab89c1a653789aac01381cdf75975ab768411978fe1d3ad38171a29cd2fffc3a  - actions DB length:  83000  - latest record from:  2023-02-03 07:31:23 7 days ago\n",
      "iterations:  83 Lines skipped:  83000 records collected:  1000  - latest recordID:  borrowAsset   0x2b4448fd953c5accbab7d852020be209da0f5eb8307119d96a6a90db2ee6e8d7+1  - actions DB length:  84000  - latest record from:  2023-02-02 15:47:35 8 days ago\n",
      "iterations:  84 Lines skipped:  84000 records collected:  1000  - latest recordID:  addCollateral   0x2b4448fd953c5accbab7d852020be209da0f5eb8307119d96a6a90db2ee6e8d7  - actions DB length:  85000  - latest record from:  2023-02-02 15:47:35 8 days ago\n",
      "iterations:  85 Lines skipped:  85000 records collected:  1000  - latest recordID:  borrowAsset   0xd4b76291ca09549fa743fa83438a482f74730e480b8c4c061a10d7d7cee2f473  - actions DB length:  86000  - latest record from:  2023-02-02 15:01:11 8 days ago\n",
      "iterations:  86 Lines skipped:  86000 records collected:  1000  - latest recordID:  addCollateral   0x561d220422d20801fc65fefe683669eaf3e5fba6e4a8b35648e2109d79d8172b  - actions DB length:  87000  - latest record from:  2023-02-02 14:59:59 8 days ago\n",
      "iterations:  87 Lines skipped:  87000 records collected:  1000  - latest recordID:  borrowAsset   0x37f5137e3d9f012fd557e769aafc97bb1aa9d6519dc6a4f1ef36689c4c22f227  - actions DB length:  88000  - latest record from:  2023-02-02 14:54:47 8 days ago\n",
      "iterations:  88 Lines skipped:  88000 records collected:  1000  - latest recordID:  addCollateral   0xf121ac2f8ca25a303edb67091899460e6454f3f0a0afa66c31c730206d59587f  - actions DB length:  89000  - latest record from:  2023-02-02 14:53:59 8 days ago\n",
      "iterations:  89 Lines skipped:  89000 records collected:  1000  - latest recordID:  borrowAsset   0xc3dc02ee3cadd2ffb49e08af9305d2d8d8cd03ff3425816e6f28ccb75ca98475+1  - actions DB length:  90000  - latest record from:  2023-02-02 08:22:47 8 days ago\n",
      "iterations:  90 Lines skipped:  90000 records collected:  1000  - latest recordID:  addCollateral   0xc3dc02ee3cadd2ffb49e08af9305d2d8d8cd03ff3425816e6f28ccb75ca98475  - actions DB length:  91000  - latest record from:  2023-02-02 08:22:47 8 days ago\n",
      "iterations:  91 Lines skipped:  91000 records collected:  1000  - latest recordID:  borrowAsset   0x507874609d7eff32999ea66304d4d137ae8f1854fce52653d113ac80b4099778+1  - actions DB length:  92000  - latest record from:  2023-02-02 08:21:47 8 days ago\n",
      "iterations:  92 Lines skipped:  92000 records collected:  1000  - latest recordID:  addCollateral   0x507874609d7eff32999ea66304d4d137ae8f1854fce52653d113ac80b4099778  - actions DB length:  93000  - latest record from:  2023-02-02 08:21:47 8 days ago\n",
      "iterations:  93 Lines skipped:  93000 records collected:  1000  - latest recordID:  borrowAsset   0x333db65350964ed518ca0542b69b7cac675bc43f888727e6247e9c79e58c133c+1  - actions DB length:  94000  - latest record from:  2023-02-02 07:42:47 8 days ago\n",
      "iterations:  94 Lines skipped:  94000 records collected:  1000  - latest recordID:  addCollateral   0x333db65350964ed518ca0542b69b7cac675bc43f888727e6247e9c79e58c133c  - actions DB length:  95000  - latest record from:  2023-02-02 07:42:47 8 days ago\n",
      "iterations:  95 Lines skipped:  95000 records collected:  1000  - latest recordID:  borrowAsset   0x66a8ab00fe08a5204dbc4870d92d82cb4e5973525c58f76185cada22155c6865+1  - actions DB length:  96000  - latest record from:  2023-02-01 22:54:11 9 days ago\n",
      "iterations:  96 Lines skipped:  96000 records collected:  1000  - latest recordID:  addCollateral   0x66a8ab00fe08a5204dbc4870d92d82cb4e5973525c58f76185cada22155c6865  - actions DB length:  97000  - latest record from:  2023-02-01 22:54:11 9 days ago\n",
      "iterations:  97 Lines skipped:  97000 records collected:  1000  - latest recordID:  removeCollateral   0xbb5b4f513dcc2988c382a6a4a89906d01fe51bda47a2ffcc760a05762e2e4e9d  - actions DB length:  98000  - latest record from:  2023-02-01 21:34:23 9 days ago\n",
      "iterations:  98 Lines skipped:  98000 records collected:  1000  - latest recordID:  repayAsset   0xbc551659bec3d5aa222e74772d7af57e22adbb0265b7107e3cadbd7d39adcb93  - actions DB length:  99000  - latest record from:  2023-02-01 21:31:59 9 days ago\n",
      "iterations:  99 Lines skipped:  99000 records collected:  1000  - latest recordID:  borrowAsset   0xf99a05c329600918085e1b16c083ce5ae78ebffbe92897c92e121445cf2dd393  - actions DB length:  100000  - latest record from:  2023-02-01 18:34:59 9 days ago\n",
      "iterations:  100 Lines skipped:  100000 records collected:  1000  - latest recordID:  borrowAsset   0x03f55917c68857379d4805da693c7e4b5166b52b5b3adf2154d7206a5243dcf9  - actions DB length:  101000  - latest record from:  2023-02-01 16:54:47 9 days ago\n",
      "iterations:  101 Lines skipped:  101000 records collected:  1000  - latest recordID:  borrowAsset   0xc38d788823d01d7c34369e15962737ac808d80ef0cae930b28b40a38017cecc7  - actions DB length:  102000  - latest record from:  2023-02-01 13:01:35 9 days ago\n",
      "iterations:  102 Lines skipped:  102000 records collected:  1000  - latest recordID:  borrowAsset   0x26f7fd2ab436b9370a1b272345625be420f6895b1f58a933388b062e908b7375+1  - actions DB length:  103000  - latest record from:  2023-02-01 11:15:59 9 days ago\n",
      "iterations:  103 Lines skipped:  103000 records collected:  1000  - latest recordID:  addCollateral   0x26f7fd2ab436b9370a1b272345625be420f6895b1f58a933388b062e908b7375  - actions DB length:  104000  - latest record from:  2023-02-01 11:15:59 9 days ago\n",
      "iterations:  104 Lines skipped:  104000 records collected:  1000  - latest recordID:  removeAsset   0x2eabecd26a862fbfde0548df11eb2a3d6e2e07db38102415c55cae2df4c8a97a  - actions DB length:  105000  - latest record from:  2023-02-01 04:18:47 9 days ago\n",
      "iterations:  105 Lines skipped:  105000 records collected:  1000  - latest recordID:  removeAsset   0x64cd3f39e4424f168067d4ec7e4d6cb3a33b16a45affac42819a0f75aeabfdf4  - actions DB length:  106000  - latest record from:  2023-01-31 22:15:59 10 days ago\n",
      "iterations:  106 Lines skipped:  106000 records collected:  1000  - latest recordID:  borrowAsset   0x5b54915efb1fc5ec53fd70cb5dfe5cd1f0b63e4e4f246643ecc63dbd42d911cc+1  - actions DB length:  107000  - latest record from:  2023-01-31 16:48:59 10 days ago\n",
      "iterations:  107 Lines skipped:  107000 records collected:  1000  - latest recordID:  addCollateral   0x5b54915efb1fc5ec53fd70cb5dfe5cd1f0b63e4e4f246643ecc63dbd42d911cc  - actions DB length:  108000  - latest record from:  2023-01-31 16:48:59 10 days ago\n",
      "iterations:  108 Lines skipped:  108000 records collected:  1000  - latest recordID:  borrowAsset   0xb96734f96cd7d10ef3e099c366e019e04d4e04dd0e5825fef1ebe284fbdb1255  - actions DB length:  109000  - latest record from:  2023-01-31 16:46:47 10 days ago\n",
      "iterations:  109 Lines skipped:  109000 records collected:  1000  - latest recordID:  removeCollateral   0x8b38fcf78a096afd1c13f8367a8c29a9ee6de56b227933dac5a0b6a43c156639  - actions DB length:  110000  - latest record from:  2023-01-31 15:17:47 10 days ago\n",
      "iterations:  110 Lines skipped:  110000 records collected:  1000  - latest recordID:  borrowAsset   0x3f9dd85fe8726e91a22fcf2608395bbfe31457aac66693980c4961f32754d8c5  - actions DB length:  111000  - latest record from:  2023-01-31 11:19:11 10 days ago\n",
      "iterations:  111 Lines skipped:  111000 records collected:  1000  - latest recordID:  removeCollateral   0x3620ee62c513ce22c389c669837b6892edec06c212a5564faf6d6b716fb2e196  - actions DB length:  112000  - latest record from:  2023-01-31 11:03:23 10 days ago\n",
      "iterations:  112 Lines skipped:  112000 records collected:  1000  - latest recordID:  repayAsset   0x39d2e0dda120f10e067a19746b003e04ffd5738e2b8f8e0eaa5b86220a9ee7f0  - actions DB length:  113000  - latest record from:  2023-01-31 11:01:35 10 days ago\n",
      "iterations:  113 Lines skipped:  113000 records collected:  1000  - latest recordID:  removeCollateral   0x1ac69cd5cfc7a573065ce8303713aa391cafdcfa79f4456237f56db03f289605  - actions DB length:  114000  - latest record from:  2023-01-31 10:36:59 10 days ago\n",
      "iterations:  114 Lines skipped:  114000 records collected:  1000  - latest recordID:  repayAsset   0x2fa96a80ff4bff9c280c580010faaa9259d137ae459788780cc6f5f33ad25e24  - actions DB length:  115000  - latest record from:  2023-01-31 10:36:11 10 days ago\n",
      "iterations:  115 Lines skipped:  115000 records collected:  1000  - latest recordID:  removeAsset   0x24205218451b7ed0efb6de43a9c2aa0983fefcf7592ff2b4134e65ccffdaaa69  - actions DB length:  116000  - latest record from:  2023-01-31 10:30:47 10 days ago\n",
      "iterations:  116 Lines skipped:  116000 records collected:  1000  - latest recordID:  removeCollateral   0x4651d18a4d016e014a90f9db37b37d22979af9687dee18d99490d7fb61f0cee8  - actions DB length:  117000  - latest record from:  2023-01-31 06:39:47 10 days ago\n",
      "iterations:  117 Lines skipped:  117000 records collected:  1000  - latest recordID:  repayAsset   0xc3d1f2a03fdf879f70fea95fb65fa33512d6b2039963fd3892508f364cdd818b  - actions DB length:  118000  - latest record from:  2023-01-31 06:38:59 10 days ago\n",
      "iterations:  118 Lines skipped:  118000 records collected:  1000  - latest recordID:  borrowAsset   0xdde3beeb021c06b8f00659281dc2b2f150f6c38a3918f271591d84d50d664c85  - actions DB length:  119000  - latest record from:  2023-01-31 05:54:11 10 days ago\n",
      "iterations:  119 Lines skipped:  119000 records collected:  1000  - latest recordID:  removeCollateral   0x6d63493438806283fae73326820511d858a911e16e8d0456c425fb05e29e50bb  - actions DB length:  120000  - latest record from:  2023-01-31 03:24:47 10 days ago\n",
      "iterations:  120 Lines skipped:  120000 records collected:  1000  - latest recordID:  repayAsset   0x7ff20ac7dbf4eeabb6b51ea6b0b7ab3fa048bef1f6cd77b670ca2ddb2de42d7a  - actions DB length:  121000  - latest record from:  2023-01-31 03:24:11 10 days ago\n",
      "iterations:  121 Lines skipped:  121000 records collected:  1000  - latest recordID:  removeCollateral   0x38069e05261fc9ae203c5d2b6dca4658c7bb8dd856f1af87ed0d40df985eb24b  - actions DB length:  122000  - latest record from:  2023-01-31 00:26:11 10 days ago\n",
      "iterations:  122 Lines skipped:  122000 records collected:  1000  - latest recordID:  repayAsset   0x67e1ccc44736eb0c79b8d95c2cd635c189194ace49109b99b7ebdabf55acfdbd  - actions DB length:  123000  - latest record from:  2023-01-31 00:25:23 10 days ago\n",
      "iterations:  123 Lines skipped:  123000 records collected:  1000  - latest recordID:  removeCollateral   0xcdd8e49256df990f24e8811a4fd4999bc34356bc42ac29fb9bcc7782baa1cc2e  - actions DB length:  124000  - latest record from:  2023-01-30 17:35:59 11 days ago\n",
      "iterations:  124 Lines skipped:  124000 records collected:  1000  - latest recordID:  repayAsset   0xa0e6a9c8d172ea5a865df0d06a654953109d278876588d7c266d2f10ddb3ce4e  - actions DB length:  125000  - latest record from:  2023-01-30 17:27:47 11 days ago\n",
      "iterations:  125 Lines skipped:  125000 records collected:  1000  - latest recordID:  addAsset   0xa98494dbf8f20b5d0baf934b8e02f2068fb1436b6b57e4f7ca6c1005582afba8  - actions DB length:  126000  - latest record from:  2023-01-30 15:08:59 11 days ago\n",
      "iterations:  126 Lines skipped:  126000 records collected:  1000  - latest recordID:  addAsset   0x86e0d0e313fd87fb890da24c1eaeae7e83f8ea8791ef26451016a375bdaa97fb  - actions DB length:  127000  - latest record from:  2023-01-30 14:56:35 11 days ago\n",
      "iterations:  127 Lines skipped:  127000 records collected:  1000  - latest recordID:  borrowAsset   0xb762c343ba7caaf725fc219afb1b2b88652a50347c0a45ad8293c912aad4f360+1  - actions DB length:  128000  - latest record from:  2023-01-30 13:58:47 11 days ago\n",
      "iterations:  128 Lines skipped:  128000 records collected:  1000  - latest recordID:  addCollateral   0xb762c343ba7caaf725fc219afb1b2b88652a50347c0a45ad8293c912aad4f360  - actions DB length:  129000  - latest record from:  2023-01-30 13:58:47 11 days ago\n",
      "iterations:  129 Lines skipped:  129000 records collected:  1000  - latest recordID:  borrowAsset   0xcb488c0f31012d6ba649789562bbd7ba9ac0a4244aecae8f9a42cb511710fc84+1  - actions DB length:  130000  - latest record from:  2023-01-30 13:05:59 11 days ago\n",
      "iterations:  130 Lines skipped:  130000 records collected:  1000  - latest recordID:  addCollateral   0xcb488c0f31012d6ba649789562bbd7ba9ac0a4244aecae8f9a42cb511710fc84  - actions DB length:  131000  - latest record from:  2023-01-30 13:05:59 11 days ago\n",
      "iterations:  131 Lines skipped:  131000 records collected:  1000  - latest recordID:  addAsset   0x81c60c0301fed169a5eeee7739100fc83bf3d8e744500c9c9e37be1d31544729  - actions DB length:  132000  - latest record from:  2023-01-30 12:14:47 11 days ago\n",
      "iterations:  132 Lines skipped:  132000 records collected:  1000  - latest recordID:  repayAsset   0xd02d1e2223a9bb8288f8afd6e91a9fcd444e06db0f30a4f545a0c12fdefaf788  - actions DB length:  133000  - latest record from:  2023-01-30 11:18:59 11 days ago\n",
      "iterations:  133 Lines skipped:  133000 records collected:  1000  - latest recordID:  borrowAsset   0xb019c269f340d0182a2c38b01c25baa2bdb86c26ff32d10eea50d85de88e050b+1  - actions DB length:  134000  - latest record from:  2023-01-30 11:15:47 11 days ago\n",
      "iterations:  134 Lines skipped:  134000 records collected:  1000  - latest recordID:  addCollateral   0xb019c269f340d0182a2c38b01c25baa2bdb86c26ff32d10eea50d85de88e050b  - actions DB length:  135000  - latest record from:  2023-01-30 11:15:47 11 days ago\n",
      "iterations:  135 Lines skipped:  135000 records collected:  1000  - latest recordID:  removeCollateral   0x5c3636b95d45d40c1602ce895781517c7bda636e57fd8f67bc71b357c1d7a26b  - actions DB length:  136000  - latest record from:  2023-01-30 11:13:11 11 days ago\n",
      "iterations:  136 Lines skipped:  136000 records collected:  1000  - latest recordID:  removeAsset   0x6f00c50394c743c376fb4196f686e6f1a244991e01273ce80d85f53fd604209e  - actions DB length:  137000  - latest record from:  2023-01-30 10:21:59 11 days ago\n",
      "iterations:  137 Lines skipped:  137000 records collected:  1000  - latest recordID:  addAsset   0xce4366f2b230132cc3eca24b357f611a935a05f9c71db4f0f82c6751c9d024ef  - actions DB length:  138000  - latest record from:  2023-01-30 10:19:23 11 days ago\n",
      "iterations:  138 Lines skipped:  138000 records collected:  1000  - latest recordID:  borrowAsset   0xa0889721b0bfc7a8f345594323cf31bd0699312e2a16ed79febbaaa7bc6738b3+1  - actions DB length:  139000  - latest record from:  2023-01-30 10:09:59 11 days ago\n",
      "iterations:  139 Lines skipped:  139000 records collected:  1000  - latest recordID:  addCollateral   0xa0889721b0bfc7a8f345594323cf31bd0699312e2a16ed79febbaaa7bc6738b3  - actions DB length:  140000  - latest record from:  2023-01-30 10:09:59 11 days ago\n",
      "iterations:  140 Lines skipped:  140000 records collected:  1000  - latest recordID:  addAsset   0xfd6a50689b490e598386670f601d5323e1559ec0a1f040d6b7e1bfa9bc9d0a35  - actions DB length:  141000  - latest record from:  2023-01-30 10:04:23 11 days ago\n",
      "iterations:  141 Lines skipped:  141000 records collected:  1000  - latest recordID:  borrowAsset   0xcad74f96f5d001948501bcaaa1fde0e1b29d69974690dd7f5601a3be7bb6208f+1  - actions DB length:  142000  - latest record from:  2023-01-30 09:42:47 11 days ago\n",
      "iterations:  142 Lines skipped:  142000 records collected:  1000  - latest recordID:  addCollateral   0xcad74f96f5d001948501bcaaa1fde0e1b29d69974690dd7f5601a3be7bb6208f  - actions DB length:  143000  - latest record from:  2023-01-30 09:42:47 11 days ago\n",
      "iterations:  143 Lines skipped:  143000 records collected:  1000  - latest recordID:  borrowAsset   0x117b987a167e6bbf925887931623acb0d5111ee60ab90b760b0a7e442b37d22a+1  - actions DB length:  144000  - latest record from:  2023-01-30 09:37:23 11 days ago\n",
      "iterations:  144 Lines skipped:  144000 records collected:  1000  - latest recordID:  addCollateral   0x117b987a167e6bbf925887931623acb0d5111ee60ab90b760b0a7e442b37d22a  - actions DB length:  145000  - latest record from:  2023-01-30 09:37:23 11 days ago\n",
      "iterations:  145 Lines skipped:  145000 records collected:  1000  - latest recordID:  addAsset   0x984fcfc404bcbd7bd4a250b569285176fc6c41588bd2c185d62444afbdccecba  - actions DB length:  146000  - latest record from:  2023-01-30 08:15:23 11 days ago\n",
      "iterations:  146 Lines skipped:  146000 records collected:  1000  - latest recordID:  borrowAsset   0x9009bdb40b144cefea3025da53f1719fcc88b45789b8b26ac6ee6bf8fddc2b58  - actions DB length:  147000  - latest record from:  2023-01-30 06:19:35 11 days ago\n",
      "iterations:  147 Lines skipped:  147000 records collected:  1000  - latest recordID:  addAsset   0xa6498530b23f7c167a0458b584d903fc3674a8eafb263087348aa5d5313d2510  - actions DB length:  148000  - latest record from:  2023-01-30 05:54:11 11 days ago\n",
      "iterations:  148 Lines skipped:  148000 records collected:  1000  - latest recordID:  borrowAsset   0x00c9203154ead117956a5674fc6442d532e1f568956acf4a842e5f4544453edd+1  - actions DB length:  149000  - latest record from:  2023-01-30 03:11:47 11 days ago\n",
      "iterations:  149 Lines skipped:  149000 records collected:  1000  - latest recordID:  addCollateral   0x00c9203154ead117956a5674fc6442d532e1f568956acf4a842e5f4544453edd  - actions DB length:  150000  - latest record from:  2023-01-30 03:11:47 11 days ago\n",
      "iterations:  150 Lines skipped:  150000 records collected:  1000  - latest recordID:  removeCollateral   0xda11a6b0d87a14503fb837c873e3b03787fa11b1cee43b87c44a5a4eb788588a  - actions DB length:  151000  - latest record from:  2023-01-29 20:12:11 12 days ago\n",
      "iterations:  151 Lines skipped:  151000 records collected:  1000  - latest recordID:  repayAsset   0xa485b88b2785e32d1c0fc44f2b729fe68796f64e5c4e77f470bd3c81fb638ccb  - actions DB length:  152000  - latest record from:  2023-01-29 20:10:59 12 days ago\n",
      "iterations:  152 Lines skipped:  152000 records collected:  1000  - latest recordID:  repayAsset   0x7a2b9ce4d27f0d55aba0b23b2a6f7e2d990a7a95b86f2e1e2461eeeeb8aefccb  - actions DB length:  153000  - latest record from:  2023-01-29 20:09:59 12 days ago\n",
      "iterations:  153 Lines skipped:  153000 records collected:  1000  - latest recordID:  removeCollateral   0x8eaec0043e12ac03d5156000a030a4cf009e8f20403a6616fd7a50054ba5f173  - actions DB length:  154000  - latest record from:  2023-01-29 20:06:35 12 days ago\n",
      "iterations:  154 Lines skipped:  154000 records collected:  1000  - latest recordID:  repayAsset   0xc6c5ba5f24860cf7ad01d89a16379879644e15adb766b8a9085b6039fc98e0c1  - actions DB length:  155000  - latest record from:  2023-01-29 20:05:59 12 days ago\n",
      "iterations:  155 Lines skipped:  155000 records collected:  1000  - latest recordID:  removeCollateral   0x89951bd394ce27428ddfc3d0aeb7ce8eed85f27ecb6f00e52784bf6fd584621a  - actions DB length:  156000  - latest record from:  2023-01-29 20:00:11 12 days ago\n",
      "iterations:  156 Lines skipped:  156000 records collected:  1000  - latest recordID:  addAsset   0xfb6960860fccf3868bb4a146fdd455e78b895e48cb897e7e81d6cc6b51097374  - actions DB length:  157000  - latest record from:  2023-01-29 17:31:59 12 days ago\n",
      "iterations:  157 Lines skipped:  157000 records collected:  1000  - latest recordID:  borrowAsset   0x4e64144863feb7aeef178c857da2a3eb9c5344441e76a1e2f54ee2e54de0292b+1  - actions DB length:  158000  - latest record from:  2023-01-29 17:11:11 12 days ago\n",
      "iterations:  158 Lines skipped:  158000 records collected:  1000  - latest recordID:  addCollateral   0x4e64144863feb7aeef178c857da2a3eb9c5344441e76a1e2f54ee2e54de0292b  - actions DB length:  159000  - latest record from:  2023-01-29 17:11:11 12 days ago\n",
      "iterations:  159 Lines skipped:  159000 records collected:  1000  - latest recordID:  borrowAsset   0x8050f675a5a2230c4e276780727fd28ac50ff5aeeae1b8b27f650f74f74d15de  - actions DB length:  160000  - latest record from:  2023-01-29 17:09:47 12 days ago\n",
      "iterations:  160 Lines skipped:  160000 records collected:  1000  - latest recordID:  borrowAsset   0x9ded14039cfbe71d257bf940e6446cb6e4b84ce3c5e03c3d7e744f357b3e3a22+1  - actions DB length:  161000  - latest record from:  2023-01-29 12:51:59 12 days ago\n",
      "iterations:  161 Lines skipped:  161000 records collected:  1000  - latest recordID:  addCollateral   0x9ded14039cfbe71d257bf940e6446cb6e4b84ce3c5e03c3d7e744f357b3e3a22  - actions DB length:  162000  - latest record from:  2023-01-29 12:51:59 12 days ago\n",
      "iterations:  162 Lines skipped:  162000 records collected:  1000  - latest recordID:  removeAsset   0x300497dedab365bc5e89859aa3658407e968c15fc2644a3b82f82ca2bfb66791  - actions DB length:  163000  - latest record from:  2023-01-29 12:36:47 12 days ago\n",
      "iterations:  163 Lines skipped:  163000 records collected:  1000  - latest recordID:  repayAsset   0x3ec25a2edac08032910923a0e9684cdcf44bb27c9edd2b468eee29f5234cc036  - actions DB length:  164000  - latest record from:  2023-01-29 10:38:23 12 days ago\n",
      "iterations:  164 Lines skipped:  164000 records collected:  1000  - latest recordID:  removeAsset   0x138b846ce4e027dfe0a5229019f93c903a0d9fb2f3bd191c5b2e0c609e0a2731  - actions DB length:  165000  - latest record from:  2023-01-29 09:40:59 12 days ago\n",
      "iterations:  165 Lines skipped:  165000 records collected:  1000  - latest recordID:  borrowAsset   0xf26b0b5d8213192588a1e263b85ebc0c19ef815ccf4176c12d42b4db196b25fb  - actions DB length:  166000  - latest record from:  2023-01-29 09:16:35 12 days ago\n",
      "iterations:  166 Lines skipped:  166000 records collected:  1000  - latest recordID:  borrowAsset   0x367cbd3d6a90a55ee10003edfb8614643f75d0f1aa81480b674c0f56b1aa7611+1  - actions DB length:  167000  - latest record from:  2023-01-29 09:15:59 12 days ago\n",
      "iterations:  167 Lines skipped:  167000 records collected:  1000  - latest recordID:  addCollateral   0x367cbd3d6a90a55ee10003edfb8614643f75d0f1aa81480b674c0f56b1aa7611  - actions DB length:  168000  - latest record from:  2023-01-29 09:15:59 12 days ago\n",
      "iterations:  168 Lines skipped:  168000 records collected:  1000  - latest recordID:  borrowAsset   0x0b1ef544270323931d6c529967aa8af9b7050a201f4110378e4a0a8c3f7a9f15  - actions DB length:  169000  - latest record from:  2023-01-29 09:14:47 12 days ago\n",
      "iterations:  169 Lines skipped:  169000 records collected:  1000  - latest recordID:  removeAsset   0xd455ccfeeac88c33d369faf855885455b0d87f7c5d00bee4acc7d91bbd85f29e  - actions DB length:  170000  - latest record from:  2023-01-29 06:53:59 12 days ago\n",
      "iterations:  170 Lines skipped:  170000 records collected:  1000  - latest recordID:  borrowAsset   0x23d31ea5f3a1fba025c398eeb08de147b5bf09b0b36fd87cb1d7f524a7b09499+1  - actions DB length:  171000  - latest record from:  2023-01-28 13:46:59 13 days ago\n",
      "iterations:  171 Lines skipped:  171000 records collected:  1000  - latest recordID:  addCollateral   0x23d31ea5f3a1fba025c398eeb08de147b5bf09b0b36fd87cb1d7f524a7b09499  - actions DB length:  172000  - latest record from:  2023-01-28 13:46:59 13 days ago\n",
      "iterations:  172 Lines skipped:  172000 records collected:  1000  - latest recordID:  removeCollateral   0xf872e2deb9544fed4e23733debe362d88cb44026ab9adf434d05bdc3d33988ba  - actions DB length:  173000  - latest record from:  2023-01-28 12:56:23 13 days ago\n",
      "iterations:  173 Lines skipped:  173000 records collected:  1000  - latest recordID:  addAsset   0x95550f6d6f6c17fca583242bcbdd54389648e13a414b76d3936b423776bc588a  - actions DB length:  174000  - latest record from:  2023-01-28 12:29:23 13 days ago\n",
      "iterations:  174 Lines skipped:  174000 records collected:  1000  - latest recordID:  borrowAsset   0xad25ebe4b1becb395eb0f1e1c85ca94f4d3efdee4874408d5a4d55f87c29257f+1  - actions DB length:  175000  - latest record from:  2023-01-27 09:40:11 14 days ago\n",
      "iterations:  175 Lines skipped:  175000 records collected:  1000  - latest recordID:  addCollateral   0xad25ebe4b1becb395eb0f1e1c85ca94f4d3efdee4874408d5a4d55f87c29257f  - actions DB length:  176000  - latest record from:  2023-01-27 09:40:11 14 days ago\n",
      "iterations:  176 Lines skipped:  176000 records collected:  1000  - latest recordID:  borrowAsset   0xd2640e90d1a46aa392b42d6ecaf52c2650284f8e71cdfa60c5198d87f07afb79+1  - actions DB length:  177000  - latest record from:  2023-01-27 06:33:59 14 days ago\n",
      "iterations:  177 Lines skipped:  177000 records collected:  1000  - latest recordID:  addCollateral   0xd2640e90d1a46aa392b42d6ecaf52c2650284f8e71cdfa60c5198d87f07afb79  - actions DB length:  178000  - latest record from:  2023-01-27 06:33:59 14 days ago\n",
      "iterations:  178 Lines skipped:  178000 records collected:  1000  - latest recordID:  removeAsset   0x73fc1dafef2f8ea53fa1ab442a8ef07510a0368130ad2b9d955a65629749a410  - actions DB length:  179000  - latest record from:  2023-01-27 04:31:35 14 days ago\n",
      "iterations:  179 Lines skipped:  179000 records collected:  1000  - latest recordID:  borrowAsset   0x38c758afd10bd55fc310e374f7f52237e839a9bab0b3a74ef17a3cccd76b2741+1  - actions DB length:  180000  - latest record from:  2023-01-26 17:57:11 15 days ago\n",
      "iterations:  180 Lines skipped:  180000 records collected:  1000  - latest recordID:  addCollateral   0x38c758afd10bd55fc310e374f7f52237e839a9bab0b3a74ef17a3cccd76b2741  - actions DB length:  181000  - latest record from:  2023-01-26 17:57:11 15 days ago\n",
      "iterations:  181 Lines skipped:  181000 records collected:  1000  - latest recordID:  removeCollateral   0xdc2c385e00d5997affffb49e10327009aa5bf9a3cd8e4b2aa64ca2201172c329  - actions DB length:  182000  - latest record from:  2023-01-26 16:57:23 15 days ago\n",
      "iterations:  182 Lines skipped:  182000 records collected:  1000  - latest recordID:  borrowAsset   0x460d33fa9bd03fc3dcf892d3bdb74ca8774cc20d4bbb63cfc4d7577b44b98c7c  - actions DB length:  183000  - latest record from:  2023-01-26 14:18:47 15 days ago\n",
      "iterations:  183 Lines skipped:  183000 records collected:  1000  - latest recordID:  removeCollateral   0x33de61df37e83e86f20ca6c1b245c753e415d1be7441c8d8c64710e422b24f7a  - actions DB length:  184000  - latest record from:  2023-01-26 12:44:11 15 days ago\n",
      "iterations:  184 Lines skipped:  184000 records collected:  1000  - latest recordID:  repayAsset   0xa12fb236c45bf339bdf36cbcb13c7ae44e7ca97ac486143643635eabb4876907  - actions DB length:  185000  - latest record from:  2023-01-26 12:42:47 15 days ago\n",
      "iterations:  185 Lines skipped:  185000 records collected:  1000  - latest recordID:  borrowAsset   0x6bdac83d4e1480ede4153fc63186a108078c8dd8de6a35e6b29ba25f2acf347d  - actions DB length:  186000  - latest record from:  2023-01-26 12:36:59 15 days ago\n",
      "iterations:  186 Lines skipped:  186000 records collected:  1000  - latest recordID:  borrowAsset   0x32ebb0fd3e85620656962354025d1fe63b5599c5afa9f7d505beaa92d192b902  - actions DB length:  187000  - latest record from:  2023-01-26 06:58:35 15 days ago\n",
      "iterations:  187 Lines skipped:  187000 records collected:  1000  - latest recordID:  addAsset   0x21d541d24e806094005c8424c4cd99ded740b06197f59ba911d8b98dc32f1105  - actions DB length:  188000  - latest record from:  2023-01-26 06:38:47 15 days ago\n",
      "iterations:  188 Lines skipped:  188000 records collected:  1000  - latest recordID:  borrowAsset   0x1607d81d51333d223190e0346001d4cb119c58bd6f8cbca495ff799e9f3c47b5  - actions DB length:  189000  - latest record from:  2023-01-26 06:06:59 15 days ago\n",
      "iterations:  189 Lines skipped:  189000 records collected:  1000  - latest recordID:  removeCollateral   0x7ad5ad423cc17771937c7d98ff5dcfb833226ec43251e627176881d8cbebed44  - actions DB length:  190000  - latest record from:  2023-01-26 06:00:59 15 days ago\n",
      "iterations:  190 Lines skipped:  190000 records collected:  1000  - latest recordID:  removeCollateral   0x6fdfa651f461787a7d66bf8d5ceec574f190b2fd2cb8d6f046b275be24adb56e  - actions DB length:  191000  - latest record from:  2023-01-26 05:48:47 15 days ago\n",
      "iterations:  191 Lines skipped:  191000 records collected:  1000  - latest recordID:  borrowAsset   0x8fbd9ed9f23e817a98a71ff4c37e9cfe6e1a682e50983d98f4addbe5b41196e0+1  - actions DB length:  192000  - latest record from:  2023-01-26 03:51:11 15 days ago\n",
      "iterations:  192 Lines skipped:  192000 records collected:  1000  - latest recordID:  addCollateral   0x8fbd9ed9f23e817a98a71ff4c37e9cfe6e1a682e50983d98f4addbe5b41196e0  - actions DB length:  193000  - latest record from:  2023-01-26 03:51:11 15 days ago\n",
      "iterations:  193 Lines skipped:  193000 records collected:  1000  - latest recordID:  borrowAsset   0xee376200e715c6c5f759c281cf94079f96ec50f667d0f51a9f61eb542c718491  - actions DB length:  194000  - latest record from:  2023-01-26 02:39:23 15 days ago\n",
      "iterations:  194 Lines skipped:  194000 records collected:  1000  - latest recordID:  addCollateral   0xb29a0dfff24aaef06861b69d20a41d8df80554bae829d3e16dd7143acf66b24d  - actions DB length:  195000  - latest record from:  2023-01-26 02:36:23 15 days ago\n",
      "iterations:  195 Lines skipped:  195000 records collected:  1000  - latest recordID:  addCollateral   0x9a0ce98b3daefb436073ccd8e3750d70a4013f44a7110277c07f58234317cc4a  - actions DB length:  196000  - latest record from:  2023-01-25 15:41:59 16 days ago\n",
      "iterations:  196 Lines skipped:  196000 records collected:  1000  - latest recordID:  borrowAsset   0x06b1f874b3b0444a7c7b48524d8a4537021fdd1592b2ab54c914f0441b78a284  - actions DB length:  197000  - latest record from:  2023-01-25 15:35:23 16 days ago\n",
      "iterations:  197 Lines skipped:  197000 records collected:  1000  - latest recordID:  borrowAsset   0xb984c468dfe971a60156c1d3cd4f58881e918b64ef18a717892617c1c77f8f00  - actions DB length:  198000  - latest record from:  2023-01-25 12:39:47 16 days ago\n",
      "iterations:  198 Lines skipped:  198000 records collected:  1000  - latest recordID:  borrowAsset   0x369edade729ed5bd71f3dd52a25b3506a41e1deeb1687a7e5e54a5eb2a3d8618  - actions DB length:  199000  - latest record from:  2023-01-25 12:36:35 16 days ago\n",
      "iterations:  199 Lines skipped:  199000 records collected:  1000  - latest recordID:  addAsset   0x0abd7c47061632a186ecea8bec4231bc340c01971bcdf10148c99889affd331a  - actions DB length:  200000  - latest record from:  2023-01-25 07:52:59 16 days ago\n",
      "iterations:  200 Lines skipped:  200000 records collected:  1000  - latest recordID:  removeAsset   0x681c3b71291aabed9d25ab9882ca0279f65d530b20884e9809224dd3b3b38a3a  - actions DB length:  201000  - latest record from:  2023-01-25 00:10:35 17 days ago\n",
      "iterations:  201 Lines skipped:  201000 records collected:  1000  - latest recordID:  borrowAsset   0x8a270186763feef09a1a07a2b84e3d09b985abef451b00bac49349caa15cac70+1  - actions DB length:  202000  - latest record from:  2023-01-24 19:37:35 17 days ago\n",
      "iterations:  202 Lines skipped:  202000 records collected:  1000  - latest recordID:  addCollateral   0x8a270186763feef09a1a07a2b84e3d09b985abef451b00bac49349caa15cac70  - actions DB length:  203000  - latest record from:  2023-01-24 19:37:35 17 days ago\n",
      "iterations:  203 Lines skipped:  203000 records collected:  1000  - latest recordID:  borrowAsset   0x9eb930c388325704d1d580f4c11802712a543e34f90a772c59342bc1571db577+1  - actions DB length:  204000  - latest record from:  2023-01-24 18:06:11 17 days ago\n",
      "iterations:  204 Lines skipped:  204000 records collected:  1000  - latest recordID:  addCollateral   0x9eb930c388325704d1d580f4c11802712a543e34f90a772c59342bc1571db577  - actions DB length:  205000  - latest record from:  2023-01-24 18:06:11 17 days ago\n",
      "iterations:  205 Lines skipped:  205000 records collected:  1000  - latest recordID:  borrowAsset   0xc94553ec769713acc8a94bc2c77839381e444a53d07706ec285c6c1afd2735ea+1  - actions DB length:  206000  - latest record from:  2023-01-24 17:47:35 17 days ago\n",
      "iterations:  206 Lines skipped:  206000 records collected:  1000  - latest recordID:  addCollateral   0xc94553ec769713acc8a94bc2c77839381e444a53d07706ec285c6c1afd2735ea  - actions DB length:  207000  - latest record from:  2023-01-24 17:47:35 17 days ago\n",
      "iterations:  207 Lines skipped:  207000 records collected:  1000  - latest recordID:  addAsset   0xb010bd34956101ae6d1c62818885499c46396a88f689132a8800ea15f176db0d  - actions DB length:  208000  - latest record from:  2023-01-24 13:46:47 17 days ago\n",
      "iterations:  208 Lines skipped:  208000 records collected:  1000  - latest recordID:  borrowAsset   0xc6ebc75658d1958b2c61ccbc7c7a82eaead8a95de74242dcbce185fa60820fda+1  - actions DB length:  209000  - latest record from:  2023-01-23 16:03:59 18 days ago\n",
      "iterations:  209 Lines skipped:  209000 records collected:  1000  - latest recordID:  addCollateral   0xc6ebc75658d1958b2c61ccbc7c7a82eaead8a95de74242dcbce185fa60820fda  - actions DB length:  210000  - latest record from:  2023-01-23 16:03:59 18 days ago\n",
      "iterations:  210 Lines skipped:  210000 records collected:  1000  - latest recordID:  removeCollateral   0xb03a2856d37f5eea58e5a69ca2a26a683a18c31a9129c09f16a543342afb2081  - actions DB length:  211000  - latest record from:  2023-01-23 15:43:47 18 days ago\n",
      "iterations:  211 Lines skipped:  211000 records collected:  1000  - latest recordID:  borrowAsset   0x1ad635e17337c663732f656586d178120258bee4f116e3561a88d21a6652d2ba+1  - actions DB length:  212000  - latest record from:  2023-01-23 13:50:35 18 days ago\n",
      "iterations:  212 Lines skipped:  212000 records collected:  1000  - latest recordID:  addCollateral   0x1ad635e17337c663732f656586d178120258bee4f116e3561a88d21a6652d2ba  - actions DB length:  213000  - latest record from:  2023-01-23 13:50:35 18 days ago\n",
      "iterations:  213 Lines skipped:  213000 records collected:  1000  - latest recordID:  removeCollateral   0xbe00b9055dd99e5184284bdcb5a881dfed688471882e14fde56be6a2981b81e7  - actions DB length:  214000  - latest record from:  2023-01-23 13:27:11 18 days ago\n",
      "iterations:  214 Lines skipped:  214000 records collected:  1000  - latest recordID:  borrowAsset   0xb6f709749a171f8aa5cb2e4a9c2cc7a2e6b0090fb056219b697d65e007b7628c  - actions DB length:  215000  - latest record from:  2023-01-23 07:28:59 18 days ago\n",
      "iterations:  215 Lines skipped:  215000 records collected:  1000  - latest recordID:  addCollateral   0x3a1095973c1009ccc805da8e1b9c8a97514e545c0c2b14b16cfec4597e2e2c03  - actions DB length:  216000  - latest record from:  2023-01-23 07:05:23 18 days ago\n",
      "iterations:  216 Lines skipped:  216000 records collected:  1000  - latest recordID:  removeCollateral   0x63d3ea521fd69a86fd286175f94623ed06bd8e07177238484bb7eb0bd15e244c  - actions DB length:  217000  - latest record from:  2023-01-23 01:30:11 18 days ago\n",
      "iterations:  217 Lines skipped:  217000 records collected:  1000  - latest recordID:  repayAsset   0x4ef0b001904ebddd48a9e91fb794e8ccc8f3b0de2073b7fbf19f11b2694fcd68  - actions DB length:  218000  - latest record from:  2023-01-23 01:29:23 18 days ago\n",
      "iterations:  218 Lines skipped:  218000 records collected:  1000  - latest recordID:  removeCollateral   0x0c0c39257e85d91800c8b470a0f257949cb9e61c4e6ea3bb28703c1d6588d5db  - actions DB length:  219000  - latest record from:  2023-01-22 22:29:35 19 days ago\n",
      "iterations:  219 Lines skipped:  219000 records collected:  1000  - latest recordID:  repayAsset   0x76fdce57728e9d26a6439858f5f97b72d8dc18a882a02df3f6f3d1f578fd2a4d  - actions DB length:  220000  - latest record from:  2023-01-22 22:27:59 19 days ago\n",
      "iterations:  220 Lines skipped:  220000 records collected:  1000  - latest recordID:  repayAsset   0x9f9ba2939a4c6ffc3d1c0d6652260426f188f3ee03b31d66402f0a51d5ef3533  - actions DB length:  221000  - latest record from:  2023-01-22 22:26:47 19 days ago\n",
      "iterations:  221 Lines skipped:  221000 records collected:  1000  - latest recordID:  borrowAsset   0xd5bc93f88cff048b09c458e13192a234306368aa8a0b7236ee90d42a853c4017  - actions DB length:  222000  - latest record from:  2023-01-22 11:04:59 19 days ago\n",
      "iterations:  222 Lines skipped:  222000 records collected:  1000  - latest recordID:  addCollateral   0xb160341648a752965d24c32f7696a3e6b33c07f31c838f372933df9bba9cf5e0  - actions DB length:  223000  - latest record from:  2023-01-22 02:44:35 19 days ago\n",
      "iterations:  223 Lines skipped:  223000 records collected:  1000  - latest recordID:  borrowAsset   0xf6cc58234aa05881fe3a0aa5cea059535dc5993af8e078776465dd78a402d18b  - actions DB length:  224000  - latest record from:  2023-01-22 02:41:47 19 days ago\n",
      "iterations:  224 Lines skipped:  224000 records collected:  1000  - latest recordID:  addCollateral   0xafd0637b931041ae219c3873b71b71572cbf8f1885a46d93171fe916d90b6b3c  - actions DB length:  225000  - latest record from:  2023-01-22 02:40:11 19 days ago\n",
      "iterations:  225 Lines skipped:  225000 records collected:  1000  - latest recordID:  borrowAsset   0xff674f10275b0bfcee60bd69c9f8010e610f84cb03f54a1d20a9a038416bcc08  - actions DB length:  226000  - latest record from:  2023-01-22 02:33:35 19 days ago\n",
      "iterations:  226 Lines skipped:  226000 records collected:  1000  - latest recordID:  removeCollateral   0x6392701438de8d556e14ab394f4b371834ec1917d7032f626781f0d2fd26f7bc  - actions DB length:  227000  - latest record from:  2023-01-21 14:19:35 20 days ago\n",
      "iterations:  227 Lines skipped:  227000 records collected:  1000  - latest recordID:  addCollateral   0xebfa828bb0607a35d36bbe169ca050f2979389f3f32a05bfe26b9934ef907900  - actions DB length:  228000  - latest record from:  2023-01-21 13:18:11 20 days ago\n",
      "iterations:  228 Lines skipped:  228000 records collected:  1000  - latest recordID:  removeAsset   0x29c86fe1f682b3f721c5343a3809a62e6e3b256e4e4421c95932a321e89a3802  - actions DB length:  229000  - latest record from:  2023-01-21 11:15:59 20 days ago\n",
      "iterations:  229 Lines skipped:  229000 records collected:  1000  - latest recordID:  borrowAsset   0x77a5c92f2068e1c54264885579540a0cdf73c8afb5ca671ff9311fbb1e37fc5a  - actions DB length:  230000  - latest record from:  2023-01-21 10:19:23 20 days ago\n",
      "iterations:  230 Lines skipped:  230000 records collected:  1000  - latest recordID:  borrowAsset   0xbaffcedf02b0fc9788ce3953a4e66cf3898200a0328667f564e2574296d8aeaa  - actions DB length:  231000  - latest record from:  2023-01-21 05:08:47 20 days ago\n",
      "iterations:  231 Lines skipped:  231000 records collected:  1000  - latest recordID:  removeCollateral   0xe7edc1ecd1320c549f4c7453155da43bcf3a4f2268241f019df9df87dee617a9  - actions DB length:  232000  - latest record from:  2023-01-21 02:45:35 20 days ago\n",
      "iterations:  232 Lines skipped:  232000 records collected:  1000  - latest recordID:  repayAsset   0xf90fea66de466328d613712a7d8daa814c2290492cbc5c93b36ab716b5945943  - actions DB length:  233000  - latest record from:  2023-01-21 02:42:47 20 days ago\n",
      "iterations:  233 Lines skipped:  233000 records collected:  1000  - latest recordID:  borrowAsset   0xfcf6f8fa9df9ec782e44058a361be102714f0aa7fe5eb24bc44711408eb6fcc4+1  - actions DB length:  234000  - latest record from:  2023-01-20 22:52:11 21 days ago\n",
      "iterations:  234 Lines skipped:  234000 records collected:  1000  - latest recordID:  addCollateral   0xfcf6f8fa9df9ec782e44058a361be102714f0aa7fe5eb24bc44711408eb6fcc4  - actions DB length:  235000  - latest record from:  2023-01-20 22:52:11 21 days ago\n",
      "iterations:  235 Lines skipped:  235000 records collected:  1000  - latest recordID:  addAsset   0x16a6f47e49ede8b2dda4b02cc899f29565324da0a0688921440aaf2b35ce73e3+1  - actions DB length:  236000  - latest record from:  2023-01-20 18:41:35 21 days ago\n",
      "iterations:  236 Lines skipped:  236000 records collected:  1000  - latest recordID:  removeAsset   0x16a6f47e49ede8b2dda4b02cc899f29565324da0a0688921440aaf2b35ce73e3  - actions DB length:  237000  - latest record from:  2023-01-20 18:41:35 21 days ago\n",
      "iterations:  237 Lines skipped:  237000 records collected:  1000  - latest recordID:  addAsset   0xfeb54394d817e03ccd318a836eb104027541f9e950772a227f4b7911c4b23e30+1  - actions DB length:  238000  - latest record from:  2023-01-20 18:40:23 21 days ago\n",
      "iterations:  238 Lines skipped:  238000 records collected:  1000  - latest recordID:  removeAsset   0xfeb54394d817e03ccd318a836eb104027541f9e950772a227f4b7911c4b23e30  - actions DB length:  239000  - latest record from:  2023-01-20 18:40:23 21 days ago\n",
      "iterations:  239 Lines skipped:  239000 records collected:  1000  - latest recordID:  borrowAsset   0xcf61dda8b1c814853c758001601b489bf7275c89a543bf51f4e0ea398c50d838  - actions DB length:  240000  - latest record from:  2023-01-20 17:13:23 21 days ago\n",
      "iterations:  240 Lines skipped:  240000 records collected:  1000  - latest recordID:  repayAsset   0xa7f581354071e5d4065bbe0c81eaa0650f1dd66cedffd048106933fd94383cf3  - actions DB length:  241000  - latest record from:  2023-01-20 17:04:59 21 days ago\n",
      "iterations:  241 Lines skipped:  241000 records collected:  1000  - latest recordID:  borrowAsset   0x12814e23d06d14925d564c84e3b10cb0eba032907bb4c94c903719e4cd0f8172  - actions DB length:  242000  - latest record from:  2023-01-20 15:42:35 21 days ago\n",
      "iterations:  242 Lines skipped:  242000 records collected:  1000  - latest recordID:  removeAsset   0x1b2d5fb492314e28758706dab22db744634c862f4e395fbec7e15ade2f9d3ffc  - actions DB length:  243000  - latest record from:  2023-01-20 06:25:23 21 days ago\n",
      "iterations:  243 Lines skipped:  243000 records collected:  1000  - latest recordID:  repayAsset   0xbae58b11bf18476ba9ee45bb6888bf026af5414b9c4ab0871b53ae04085e3958  - actions DB length:  244000  - latest record from:  2023-01-19 23:35:35 22 days ago\n",
      "iterations:  244 Lines skipped:  244000 records collected:  1000  - latest recordID:  repayAsset   0x56658b51462c13ccafc5968f8f4764a2ec62eeb76abf3fb425eaaaff0c2cc9a3  - actions DB length:  245000  - latest record from:  2023-01-19 20:14:35 22 days ago\n",
      "iterations:  245 Lines skipped:  245000 records collected:  1000  - latest recordID:  borrowAsset   0x8bef55b3495f6ebde0fb7bf110ef9dacd6c148687ebf7cfd5bf7af358bf432cd+1  - actions DB length:  246000  - latest record from:  2023-01-19 10:24:23 22 days ago\n",
      "iterations:  246 Lines skipped:  246000 records collected:  1000  - latest recordID:  addCollateral   0x8bef55b3495f6ebde0fb7bf110ef9dacd6c148687ebf7cfd5bf7af358bf432cd  - actions DB length:  247000  - latest record from:  2023-01-19 10:24:23 22 days ago\n",
      "iterations:  247 Lines skipped:  247000 records collected:  1000  - latest recordID:  removeAsset   0x15c1834d11c5b004f11d6224547e5d63ab4ae8f09e1318b3e3db723f1841f041  - actions DB length:  248000  - latest record from:  2023-01-19 03:26:47 22 days ago\n",
      "iterations:  248 Lines skipped:  248000 records collected:  1000  - latest recordID:  addAsset   0xb9ba221c036591d51f1dc4463576ed6cccadbceb130ae63c786d20147d2ec136  - actions DB length:  249000  - latest record from:  2023-01-18 19:21:47 23 days ago\n",
      "iterations:  249 Lines skipped:  249000 records collected:  1000  - latest recordID:  borrowAsset   0xb8b71e06c5af60c05f45e456c385f10e1a435fa53512ae0c4fe1f5ed9bb9abfc+1  - actions DB length:  250000  - latest record from:  2023-01-18 14:30:59 23 days ago\n",
      "iterations:  250 Lines skipped:  250000 records collected:  1000  - latest recordID:  addCollateral   0xb8b71e06c5af60c05f45e456c385f10e1a435fa53512ae0c4fe1f5ed9bb9abfc  - actions DB length:  251000  - latest record from:  2023-01-18 14:30:59 23 days ago\n",
      "iterations:  251 Lines skipped:  251000 records collected:  1000  - latest recordID:  borrowAsset   0x9c29ada5aa3e38fe871b1ce8521cda91fe9fe263623bf94b18d1134ec46c19f1  - actions DB length:  252000  - latest record from:  2023-01-18 12:24:11 23 days ago\n",
      "iterations:  252 Lines skipped:  252000 records collected:  1000  - latest recordID:  borrowAsset   0xbe905db775ba4f975d9904ef380d329a098499e62b4f868022a16eaa1f7c579f+1  - actions DB length:  253000  - latest record from:  2023-01-18 10:25:47 23 days ago\n",
      "iterations:  253 Lines skipped:  253000 records collected:  1000  - latest recordID:  addCollateral   0xbe905db775ba4f975d9904ef380d329a098499e62b4f868022a16eaa1f7c579f  - actions DB length:  254000  - latest record from:  2023-01-18 10:25:47 23 days ago\n",
      "iterations:  254 Lines skipped:  254000 records collected:  1000  - latest recordID:  borrowAsset   0x177e04577b8e91124fb854181bbeedcefc660331a79424b30fc3db76b26e1f45  - actions DB length:  255000  - latest record from:  2023-01-18 10:12:35 23 days ago\n",
      "iterations:  255 Lines skipped:  255000 records collected:  1000  - latest recordID:  borrowAsset   0xf64b0aac80c97e30e560d040b237eec4b2272db02739bb157aca938dd9436fe6+1  - actions DB length:  256000  - latest record from:  2023-01-18 09:02:59 23 days ago\n",
      "iterations:  256 Lines skipped:  256000 records collected:  1000  - latest recordID:  addCollateral   0xf64b0aac80c97e30e560d040b237eec4b2272db02739bb157aca938dd9436fe6  - actions DB length:  257000  - latest record from:  2023-01-18 09:02:59 23 days ago\n",
      "iterations:  257 Lines skipped:  257000 records collected:  1000  - latest recordID:  removeCollateral   0x147ad8ff181623a8569f07f84ac4538d3f85aa74761b0353b5313ba1edbbf7d9  - actions DB length:  258000  - latest record from:  2023-01-18 09:00:11 23 days ago\n",
      "iterations:  258 Lines skipped:  258000 records collected:  1000  - latest recordID:  borrowAsset   0x5deab7fd4212373a76d85426b658612b5c97523100e43fb074bfe86ef3d114b8+1  - actions DB length:  259000  - latest record from:  2023-01-18 08:52:35 23 days ago\n",
      "iterations:  259 Lines skipped:  259000 records collected:  1000  - latest recordID:  addCollateral   0x5deab7fd4212373a76d85426b658612b5c97523100e43fb074bfe86ef3d114b8  - actions DB length:  260000  - latest record from:  2023-01-18 08:52:35 23 days ago\n"
     ]
    },
    {
     "ename": "KeyboardInterrupt",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001B[1;31m---------------------------------------------------------------------------\u001B[0m",
      "\u001B[1;31mKeyboardInterrupt\u001B[0m                         Traceback (most recent call last)",
      "Input \u001B[1;32mIn [5]\u001B[0m, in \u001B[0;36m<cell line: 10>\u001B[1;34m()\u001B[0m\n\u001B[0;32m     12\u001B[0m skipValue \u001B[38;5;241m=\u001B[39m (actionTicker)\u001B[38;5;241m*\u001B[39m(\u001B[38;5;241m1000\u001B[39m)\n\u001B[0;32m     13\u001B[0m actionsQuery \u001B[38;5;241m=\u001B[39m frax\u001B[38;5;241m.\u001B[39mQuery\u001B[38;5;241m.\u001B[39mactions(\n\u001B[0;32m     14\u001B[0m      orderBy\u001B[38;5;241m=\u001B[39m\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mtimestamp\u001B[39m\u001B[38;5;124m'\u001B[39m\n\u001B[0;32m     15\u001B[0m     ,orderDirection\u001B[38;5;241m=\u001B[39m\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mdesc\u001B[39m\u001B[38;5;124m'\u001B[39m\n\u001B[1;32m   (...)\u001B[0m\n\u001B[0;32m     22\u001B[0m \n\u001B[0;32m     23\u001B[0m )\n\u001B[1;32m---> 24\u001B[0m actions\u001B[38;5;241m=\u001B[39m \u001B[43msg\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mquery_df\u001B[49m\u001B[43m(\u001B[49m\u001B[43m[\u001B[49m\n\u001B[0;32m     25\u001B[0m \u001B[43m    \u001B[49m\u001B[43mactionsQuery\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mid\u001B[49m\n\u001B[0;32m     26\u001B[0m \u001B[43m    \u001B[49m\u001B[43m,\u001B[49m\u001B[43mactionsQuery\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mtype\u001B[49m\n\u001B[0;32m     27\u001B[0m \u001B[43m    \u001B[49m\u001B[43m,\u001B[49m\u001B[43mactionsQuery\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mamount\u001B[49m\n\u001B[0;32m     28\u001B[0m \u001B[43m    \u001B[49m\u001B[43m,\u001B[49m\u001B[43mactionsQuery\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mshare\u001B[49m\n\u001B[0;32m     29\u001B[0m \u001B[43m    \u001B[49m\u001B[43m,\u001B[49m\u001B[43mactionsQuery\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mtimestamp\u001B[49m\n\u001B[0;32m     30\u001B[0m \u001B[43m    \u001B[49m\u001B[43m,\u001B[49m\u001B[43mactionsQuery\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mblock\u001B[49m\n\u001B[0;32m     31\u001B[0m \u001B[43m    \u001B[49m\u001B[43m,\u001B[49m\u001B[43mactionsQuery\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mtoken\u001B[49m\n\u001B[0;32m     32\u001B[0m \u001B[43m    \u001B[49m\u001B[43m,\u001B[49m\u001B[43mactionsQuery\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mroot\u001B[49m\n\u001B[0;32m     33\u001B[0m \u001B[43m    \u001B[49m\u001B[43m]\u001B[49m\n\u001B[0;32m     34\u001B[0m \u001B[43m\u001B[49m\u001B[43m)\u001B[49m\n\u001B[0;32m     36\u001B[0m actions\u001B[38;5;241m.\u001B[39msort_values(by\u001B[38;5;241m=\u001B[39m[\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mactions_timestamp\u001B[39m\u001B[38;5;124m'\u001B[39m])\n\u001B[0;32m     38\u001B[0m actionsDb\u001B[38;5;241m=\u001B[39mpd\u001B[38;5;241m.\u001B[39mconcat([actionsDb, actions])\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\subgrounds\\subgrounds.py:355\u001B[0m, in \u001B[0;36mSubgrounds.query_df\u001B[1;34m(self, fpaths, columns, concat, pagination_strategy)\u001B[0m\n\u001B[0;32m    284\u001B[0m \u001B[38;5;124;03m\"\"\"Same as :func:`Subgrounds.query` but formats the response data into a\u001B[39;00m\n\u001B[0;32m    285\u001B[0m \u001B[38;5;124;03mPandas DataFrame. If the response data cannot be flattened to a single query\u001B[39;00m\n\u001B[0;32m    286\u001B[0m \u001B[38;5;124;03m(e.g.: when querying multiple list fields that return different entities),\u001B[39;00m\n\u001B[1;32m   (...)\u001B[0m\n\u001B[0;32m    347\u001B[0m \u001B[38;5;124;03m    9       1643213196  2610.686563\u001B[39;00m\n\u001B[0;32m    348\u001B[0m \u001B[38;5;124;03m\"\"\"\u001B[39;00m\n\u001B[0;32m    349\u001B[0m fpaths \u001B[38;5;241m=\u001B[39m \u001B[38;5;28mlist\u001B[39m(\n\u001B[0;32m    350\u001B[0m   [fpaths]\n\u001B[0;32m    351\u001B[0m   \u001B[38;5;241m|\u001B[39m traverse\n\u001B[0;32m    352\u001B[0m   \u001B[38;5;241m|\u001B[39m \u001B[38;5;28mmap\u001B[39m(FieldPath\u001B[38;5;241m.\u001B[39m_auto_select)\n\u001B[0;32m    353\u001B[0m   \u001B[38;5;241m|\u001B[39m traverse\n\u001B[0;32m    354\u001B[0m )\n\u001B[1;32m--> 355\u001B[0m json_data \u001B[38;5;241m=\u001B[39m \u001B[38;5;28;43mself\u001B[39;49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mquery_json\u001B[49m\u001B[43m(\u001B[49m\u001B[43mfpaths\u001B[49m\u001B[43m,\u001B[49m\u001B[43m \u001B[49m\u001B[43mpagination_strategy\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[43mpagination_strategy\u001B[49m\u001B[43m)\u001B[49m\n\u001B[0;32m    356\u001B[0m \u001B[38;5;28;01mreturn\u001B[39;00m df_of_json(json_data, fpaths, columns, concat)\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\subgrounds\\subgrounds.py:249\u001B[0m, in \u001B[0;36mSubgrounds.query_json\u001B[1;34m(self, fpaths, pagination_strategy)\u001B[0m\n\u001B[0;32m    242\u001B[0m fpaths \u001B[38;5;241m=\u001B[39m \u001B[38;5;28mlist\u001B[39m(\n\u001B[0;32m    243\u001B[0m   [fpaths]\n\u001B[0;32m    244\u001B[0m   \u001B[38;5;241m|\u001B[39m traverse\n\u001B[0;32m    245\u001B[0m   \u001B[38;5;241m|\u001B[39m \u001B[38;5;28mmap\u001B[39m(FieldPath\u001B[38;5;241m.\u001B[39m_auto_select)\n\u001B[0;32m    246\u001B[0m   \u001B[38;5;241m|\u001B[39m traverse\n\u001B[0;32m    247\u001B[0m )\n\u001B[0;32m    248\u001B[0m req \u001B[38;5;241m=\u001B[39m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39mmk_request(fpaths)\n\u001B[1;32m--> 249\u001B[0m \u001B[38;5;28;01mreturn\u001B[39;00m \u001B[38;5;28;43mself\u001B[39;49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mexecute\u001B[49m\u001B[43m(\u001B[49m\u001B[43mreq\u001B[49m\u001B[43m,\u001B[49m\u001B[43m \u001B[49m\u001B[43mpagination_strategy\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[43mpagination_strategy\u001B[49m\u001B[43m)\u001B[49m\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\subgrounds\\subgrounds.py:174\u001B[0m, in \u001B[0;36mSubgrounds.execute\u001B[1;34m(self, req, pagination_strategy)\u001B[0m\n\u001B[0;32m    164\u001B[0m   \u001B[38;5;28;01mmatch\u001B[39;00m transforms:\n\u001B[0;32m    165\u001B[0m     \u001B[38;5;28;01mcase\u001B[39;00m []:\n\u001B[0;32m    166\u001B[0m       \u001B[38;5;28;01mreturn\u001B[39;00m \u001B[38;5;28mlist\u001B[39m(req\u001B[38;5;241m.\u001B[39mdocuments \u001B[38;5;241m|\u001B[39m \u001B[38;5;28mmap\u001B[39m(\u001B[38;5;28;01mlambda\u001B[39;00m doc: transform_doc(\u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39msubgraphs[doc\u001B[38;5;241m.\u001B[39murl]\u001B[38;5;241m.\u001B[39m_transforms, doc)))\n\u001B[1;32m   (...)\u001B[0m\n\u001B[0;32m    169\u001B[0m       data \u001B[38;5;241m=\u001B[39m transform_req(rest, new_req)\n\u001B[0;32m    170\u001B[0m       \u001B[38;5;28;01mreturn\u001B[39;00m transform\u001B[38;5;241m.\u001B[39mtransform_response(req, data)\n\u001B[0;32m    172\u001B[0m   \u001B[38;5;28;01massert\u001B[39;00m \u001B[38;5;28;01mFalse\u001B[39;00m  \u001B[38;5;66;03m# Suppress mypy missing return statement warning\u001B[39;00m\n\u001B[1;32m--> 174\u001B[0m \u001B[38;5;28;01mreturn\u001B[39;00m \u001B[43mtransform_req\u001B[49m\u001B[43m(\u001B[49m\u001B[38;5;28;43mself\u001B[39;49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mglobal_transforms\u001B[49m\u001B[43m,\u001B[49m\u001B[43m \u001B[49m\u001B[43mreq\u001B[49m\u001B[43m)\u001B[49m\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\subgrounds\\subgrounds.py:166\u001B[0m, in \u001B[0;36mSubgrounds.execute.<locals>.transform_req\u001B[1;34m(transforms, req)\u001B[0m\n\u001B[0;32m    163\u001B[0m \u001B[38;5;28;01mdef\u001B[39;00m \u001B[38;5;21mtransform_req\u001B[39m(transforms: \u001B[38;5;28mlist\u001B[39m[RequestTransform], req: DataRequest) \u001B[38;5;241m-\u001B[39m\u001B[38;5;241m>\u001B[39m \u001B[38;5;28mlist\u001B[39m[\u001B[38;5;28mdict\u001B[39m]:\n\u001B[0;32m    164\u001B[0m   \u001B[38;5;28;01mmatch\u001B[39;00m transforms:\n\u001B[0;32m    165\u001B[0m     \u001B[38;5;28;01mcase\u001B[39;00m []:\n\u001B[1;32m--> 166\u001B[0m       \u001B[38;5;28;01mreturn\u001B[39;00m \u001B[38;5;28;43mlist\u001B[39;49m\u001B[43m(\u001B[49m\u001B[43mreq\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mdocuments\u001B[49m\u001B[43m \u001B[49m\u001B[38;5;241;43m|\u001B[39;49m\u001B[43m \u001B[49m\u001B[38;5;28;43mmap\u001B[39;49m\u001B[43m(\u001B[49m\u001B[38;5;28;43;01mlambda\u001B[39;49;00m\u001B[43m \u001B[49m\u001B[43mdoc\u001B[49m\u001B[43m:\u001B[49m\u001B[43m \u001B[49m\u001B[43mtransform_doc\u001B[49m\u001B[43m(\u001B[49m\u001B[38;5;28;43mself\u001B[39;49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43msubgraphs\u001B[49m\u001B[43m[\u001B[49m\u001B[43mdoc\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43murl\u001B[49m\u001B[43m]\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43m_transforms\u001B[49m\u001B[43m,\u001B[49m\u001B[43m \u001B[49m\u001B[43mdoc\u001B[49m\u001B[43m)\u001B[49m\u001B[43m)\u001B[49m\u001B[43m)\u001B[49m\n\u001B[0;32m    167\u001B[0m     \u001B[38;5;28;01mcase\u001B[39;00m [transform, \u001B[38;5;241m*\u001B[39mrest]:\n\u001B[0;32m    168\u001B[0m       new_req \u001B[38;5;241m=\u001B[39m transform\u001B[38;5;241m.\u001B[39mtransform_request(req)\n\u001B[0;32m    169\u001B[0m       data \u001B[38;5;241m=\u001B[39m transform_req(rest, new_req)\n\u001B[0;32m    170\u001B[0m       \u001B[38;5;28;01mreturn\u001B[39;00m transform\u001B[38;5;241m.\u001B[39mtransform_response(req, data)\n\u001B[0;32m    172\u001B[0m   \u001B[38;5;28;01massert\u001B[39;00m \u001B[38;5;28;01mFalse\u001B[39;00m\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\subgrounds\\subgrounds.py:166\u001B[0m, in \u001B[0;36mSubgrounds.execute.<locals>.transform_req.<locals>.<lambda>\u001B[1;34m(doc)\u001B[0m\n\u001B[0;32m    163\u001B[0m \u001B[38;5;28;01mdef\u001B[39;00m \u001B[38;5;21mtransform_req\u001B[39m(transforms: \u001B[38;5;28mlist\u001B[39m[RequestTransform], req: DataRequest) \u001B[38;5;241m-\u001B[39m\u001B[38;5;241m>\u001B[39m \u001B[38;5;28mlist\u001B[39m[\u001B[38;5;28mdict\u001B[39m]:\n\u001B[0;32m    164\u001B[0m   \u001B[38;5;28;01mmatch\u001B[39;00m transforms:\n\u001B[0;32m    165\u001B[0m     \u001B[38;5;28;01mcase\u001B[39;00m []:\n\u001B[1;32m--> 166\u001B[0m       \u001B[38;5;28;01mreturn\u001B[39;00m \u001B[38;5;28mlist\u001B[39m(req\u001B[38;5;241m.\u001B[39mdocuments \u001B[38;5;241m|\u001B[39m \u001B[38;5;28mmap\u001B[39m(\u001B[38;5;28;01mlambda\u001B[39;00m doc: \u001B[43mtransform_doc\u001B[49m\u001B[43m(\u001B[49m\u001B[38;5;28;43mself\u001B[39;49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43msubgraphs\u001B[49m\u001B[43m[\u001B[49m\u001B[43mdoc\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43murl\u001B[49m\u001B[43m]\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43m_transforms\u001B[49m\u001B[43m,\u001B[49m\u001B[43m \u001B[49m\u001B[43mdoc\u001B[49m\u001B[43m)\u001B[49m))\n\u001B[0;32m    167\u001B[0m     \u001B[38;5;28;01mcase\u001B[39;00m [transform, \u001B[38;5;241m*\u001B[39mrest]:\n\u001B[0;32m    168\u001B[0m       new_req \u001B[38;5;241m=\u001B[39m transform\u001B[38;5;241m.\u001B[39mtransform_request(req)\n\u001B[0;32m    169\u001B[0m       data \u001B[38;5;241m=\u001B[39m transform_req(rest, new_req)\n\u001B[0;32m    170\u001B[0m       \u001B[38;5;28;01mreturn\u001B[39;00m transform\u001B[38;5;241m.\u001B[39mtransform_response(req, data)\n\u001B[0;32m    172\u001B[0m   \u001B[38;5;28;01massert\u001B[39;00m \u001B[38;5;28;01mFalse\u001B[39;00m\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\subgrounds\\subgrounds.py:158\u001B[0m, in \u001B[0;36mSubgrounds.execute.<locals>.transform_doc\u001B[1;34m(transforms, doc)\u001B[0m\n\u001B[0;32m    151\u001B[0m \u001B[38;5;28;01mdef\u001B[39;00m \u001B[38;5;21mtransform_doc\u001B[39m(transforms: \u001B[38;5;28mlist\u001B[39m[DocumentTransform], doc: Document) \u001B[38;5;241m-\u001B[39m\u001B[38;5;241m>\u001B[39m \u001B[38;5;28mdict\u001B[39m:\n\u001B[0;32m    152\u001B[0m   logger\u001B[38;5;241m.\u001B[39mdebug(\u001B[38;5;124mf\u001B[39m\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mexecute.transform_doc: doc = \u001B[39m\u001B[38;5;130;01m\\n\u001B[39;00m\u001B[38;5;132;01m{\u001B[39;00mdoc\u001B[38;5;241m.\u001B[39mgraphql\u001B[38;5;132;01m}\u001B[39;00m\u001B[38;5;124m'\u001B[39m)\n\u001B[0;32m    153\u001B[0m   \u001B[38;5;28;01mmatch\u001B[39;00m transforms:\n\u001B[0;32m    154\u001B[0m     \u001B[38;5;28;01mcase\u001B[39;00m []:\n\u001B[0;32m    155\u001B[0m       \u001B[38;5;28;01mreturn\u001B[39;00m execute_document(doc)\n\u001B[0;32m    156\u001B[0m     \u001B[38;5;28;01mcase\u001B[39;00m [transform, \u001B[38;5;241m*\u001B[39mrest]:\n\u001B[0;32m    157\u001B[0m       new_doc \u001B[38;5;241m=\u001B[39m transform\u001B[38;5;241m.\u001B[39mtransform_document(doc)\n\u001B[1;32m--> 158\u001B[0m       data \u001B[38;5;241m=\u001B[39m \u001B[43mtransform_doc\u001B[49m\u001B[43m(\u001B[49m\u001B[43mrest\u001B[49m\u001B[43m,\u001B[49m\u001B[43m \u001B[49m\u001B[43mnew_doc\u001B[49m\u001B[43m)\u001B[49m\n\u001B[0;32m    159\u001B[0m       \u001B[38;5;28;01mreturn\u001B[39;00m transform\u001B[38;5;241m.\u001B[39mtransform_response(doc, data)\n\u001B[0;32m    161\u001B[0m   \u001B[38;5;28;01massert\u001B[39;00m \u001B[38;5;28;01mFalse\u001B[39;00m\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\subgrounds\\subgrounds.py:158\u001B[0m, in \u001B[0;36mSubgrounds.execute.<locals>.transform_doc\u001B[1;34m(transforms, doc)\u001B[0m\n\u001B[0;32m    151\u001B[0m \u001B[38;5;28;01mdef\u001B[39;00m \u001B[38;5;21mtransform_doc\u001B[39m(transforms: \u001B[38;5;28mlist\u001B[39m[DocumentTransform], doc: Document) \u001B[38;5;241m-\u001B[39m\u001B[38;5;241m>\u001B[39m \u001B[38;5;28mdict\u001B[39m:\n\u001B[0;32m    152\u001B[0m   logger\u001B[38;5;241m.\u001B[39mdebug(\u001B[38;5;124mf\u001B[39m\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mexecute.transform_doc: doc = \u001B[39m\u001B[38;5;130;01m\\n\u001B[39;00m\u001B[38;5;132;01m{\u001B[39;00mdoc\u001B[38;5;241m.\u001B[39mgraphql\u001B[38;5;132;01m}\u001B[39;00m\u001B[38;5;124m'\u001B[39m)\n\u001B[0;32m    153\u001B[0m   \u001B[38;5;28;01mmatch\u001B[39;00m transforms:\n\u001B[0;32m    154\u001B[0m     \u001B[38;5;28;01mcase\u001B[39;00m []:\n\u001B[0;32m    155\u001B[0m       \u001B[38;5;28;01mreturn\u001B[39;00m execute_document(doc)\n\u001B[0;32m    156\u001B[0m     \u001B[38;5;28;01mcase\u001B[39;00m [transform, \u001B[38;5;241m*\u001B[39mrest]:\n\u001B[0;32m    157\u001B[0m       new_doc \u001B[38;5;241m=\u001B[39m transform\u001B[38;5;241m.\u001B[39mtransform_document(doc)\n\u001B[1;32m--> 158\u001B[0m       data \u001B[38;5;241m=\u001B[39m \u001B[43mtransform_doc\u001B[49m\u001B[43m(\u001B[49m\u001B[43mrest\u001B[49m\u001B[43m,\u001B[49m\u001B[43m \u001B[49m\u001B[43mnew_doc\u001B[49m\u001B[43m)\u001B[49m\n\u001B[0;32m    159\u001B[0m       \u001B[38;5;28;01mreturn\u001B[39;00m transform\u001B[38;5;241m.\u001B[39mtransform_response(doc, data)\n\u001B[0;32m    161\u001B[0m   \u001B[38;5;28;01massert\u001B[39;00m \u001B[38;5;28;01mFalse\u001B[39;00m\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\subgrounds\\subgrounds.py:155\u001B[0m, in \u001B[0;36mSubgrounds.execute.<locals>.transform_doc\u001B[1;34m(transforms, doc)\u001B[0m\n\u001B[0;32m    151\u001B[0m \u001B[38;5;28;01mdef\u001B[39;00m \u001B[38;5;21mtransform_doc\u001B[39m(transforms: \u001B[38;5;28mlist\u001B[39m[DocumentTransform], doc: Document) \u001B[38;5;241m-\u001B[39m\u001B[38;5;241m>\u001B[39m \u001B[38;5;28mdict\u001B[39m:\n\u001B[0;32m    152\u001B[0m   logger\u001B[38;5;241m.\u001B[39mdebug(\u001B[38;5;124mf\u001B[39m\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mexecute.transform_doc: doc = \u001B[39m\u001B[38;5;130;01m\\n\u001B[39;00m\u001B[38;5;132;01m{\u001B[39;00mdoc\u001B[38;5;241m.\u001B[39mgraphql\u001B[38;5;132;01m}\u001B[39;00m\u001B[38;5;124m'\u001B[39m)\n\u001B[0;32m    153\u001B[0m   \u001B[38;5;28;01mmatch\u001B[39;00m transforms:\n\u001B[0;32m    154\u001B[0m     \u001B[38;5;28;01mcase\u001B[39;00m []:\n\u001B[1;32m--> 155\u001B[0m       \u001B[38;5;28;01mreturn\u001B[39;00m \u001B[43mexecute_document\u001B[49m\u001B[43m(\u001B[49m\u001B[43mdoc\u001B[49m\u001B[43m)\u001B[49m\n\u001B[0;32m    156\u001B[0m     \u001B[38;5;28;01mcase\u001B[39;00m [transform, \u001B[38;5;241m*\u001B[39mrest]:\n\u001B[0;32m    157\u001B[0m       new_doc \u001B[38;5;241m=\u001B[39m transform\u001B[38;5;241m.\u001B[39mtransform_document(doc)\n\u001B[0;32m    158\u001B[0m       data \u001B[38;5;241m=\u001B[39m transform_doc(rest, new_doc)\n\u001B[0;32m    159\u001B[0m       \u001B[38;5;28;01mreturn\u001B[39;00m transform\u001B[38;5;241m.\u001B[39mtransform_response(doc, data)\n\u001B[0;32m    161\u001B[0m   \u001B[38;5;28;01massert\u001B[39;00m \u001B[38;5;28;01mFalse\u001B[39;00m\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\subgrounds\\subgrounds.py:149\u001B[0m, in \u001B[0;36mSubgrounds.execute.<locals>.execute_document\u001B[1;34m(doc)\u001B[0m\n\u001B[0;32m    147\u001B[0m   \u001B[38;5;28;01mreturn\u001B[39;00m paginate(subgraph\u001B[38;5;241m.\u001B[39m_schema, doc, pagination_strategy\u001B[38;5;241m=\u001B[39mpagination_strategy)\n\u001B[0;32m    148\u001B[0m \u001B[38;5;28;01melse\u001B[39;00m:\n\u001B[1;32m--> 149\u001B[0m   \u001B[38;5;28;01mreturn\u001B[39;00m \u001B[43mclient\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mquery\u001B[49m\u001B[43m(\u001B[49m\u001B[43mdoc\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43murl\u001B[49m\u001B[43m,\u001B[49m\u001B[43m \u001B[49m\u001B[43mdoc\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mgraphql\u001B[49m\u001B[43m,\u001B[49m\u001B[43m \u001B[49m\u001B[43mvariables\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[43mdoc\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mvariables\u001B[49m\u001B[43m)\u001B[49m\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\subgrounds\\client.py:154\u001B[0m, in \u001B[0;36mquery\u001B[1;34m(url, query_str, variables)\u001B[0m\n\u001B[0;32m    134\u001B[0m \u001B[38;5;124;03m\"\"\" Executes the GraphQL query :attr:`query_str` with variables\u001B[39;00m\n\u001B[0;32m    135\u001B[0m \u001B[38;5;124;03m:attr:`variables` against the API served at :attr:`url` and returns the\u001B[39;00m\n\u001B[0;32m    136\u001B[0m \u001B[38;5;124;03mresponse data. In case of errors, an exception containing the error message is\u001B[39;00m\n\u001B[1;32m   (...)\u001B[0m\n\u001B[0;32m    149\u001B[0m \u001B[38;5;124;03m  dict[str, Any]: Response data\u001B[39;00m\n\u001B[0;32m    150\u001B[0m \u001B[38;5;124;03m\"\"\"\u001B[39;00m\n\u001B[0;32m    151\u001B[0m logger\u001B[38;5;241m.\u001B[39minfo(\n\u001B[0;32m    152\u001B[0m   \u001B[38;5;124mf\u001B[39m\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mclient.query: url = \u001B[39m\u001B[38;5;132;01m{\u001B[39;00murl\u001B[38;5;132;01m}\u001B[39;00m\u001B[38;5;124m, variables = \u001B[39m\u001B[38;5;132;01m{\u001B[39;00mvariables\u001B[38;5;132;01m}\u001B[39;00m\u001B[38;5;130;01m\\n\u001B[39;00m\u001B[38;5;132;01m{\u001B[39;00mquery_str\u001B[38;5;132;01m}\u001B[39;00m\u001B[38;5;124m'\u001B[39m\n\u001B[0;32m    153\u001B[0m )\n\u001B[1;32m--> 154\u001B[0m resp \u001B[38;5;241m=\u001B[39m \u001B[43mrequests\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mpost\u001B[49m\u001B[43m(\u001B[49m\n\u001B[0;32m    155\u001B[0m \u001B[43m  \u001B[49m\u001B[43murl\u001B[49m\u001B[43m,\u001B[49m\n\u001B[0;32m    156\u001B[0m \u001B[43m  \u001B[49m\u001B[43mjson\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[43m(\u001B[49m\n\u001B[0;32m    157\u001B[0m \u001B[43m    \u001B[49m\u001B[43m{\u001B[49m\u001B[38;5;124;43m'\u001B[39;49m\u001B[38;5;124;43mquery\u001B[39;49m\u001B[38;5;124;43m'\u001B[39;49m\u001B[43m:\u001B[49m\u001B[43m \u001B[49m\u001B[43mquery_str\u001B[49m\u001B[43m}\u001B[49m\n\u001B[0;32m    158\u001B[0m \u001B[43m    \u001B[49m\u001B[38;5;28;43;01mif\u001B[39;49;00m\u001B[43m \u001B[49m\u001B[43mvariables\u001B[49m\u001B[43m \u001B[49m\u001B[38;5;241;43m==\u001B[39;49m\u001B[43m \u001B[49m\u001B[43m{\u001B[49m\u001B[43m}\u001B[49m\n\u001B[0;32m    159\u001B[0m \u001B[43m    \u001B[49m\u001B[38;5;28;43;01melse\u001B[39;49;00m\u001B[43m \u001B[49m\u001B[43m{\u001B[49m\u001B[38;5;124;43m'\u001B[39;49m\u001B[38;5;124;43mquery\u001B[39;49m\u001B[38;5;124;43m'\u001B[39;49m\u001B[43m:\u001B[49m\u001B[43m \u001B[49m\u001B[43mquery_str\u001B[49m\u001B[43m,\u001B[49m\u001B[43m \u001B[49m\u001B[38;5;124;43m'\u001B[39;49m\u001B[38;5;124;43mvariables\u001B[39;49m\u001B[38;5;124;43m'\u001B[39;49m\u001B[43m:\u001B[49m\u001B[43m \u001B[49m\u001B[43mvariables\u001B[49m\u001B[43m}\u001B[49m\n\u001B[0;32m    160\u001B[0m \u001B[43m  \u001B[49m\u001B[43m)\u001B[49m\u001B[43m,\u001B[49m\n\u001B[0;32m    161\u001B[0m \u001B[43m  \u001B[49m\u001B[43mheaders\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[43m{\u001B[49m\u001B[38;5;124;43m'\u001B[39;49m\u001B[38;5;124;43mContent-Type\u001B[39;49m\u001B[38;5;124;43m'\u001B[39;49m\u001B[43m:\u001B[49m\u001B[43m \u001B[49m\u001B[38;5;124;43m'\u001B[39;49m\u001B[38;5;124;43mapplication/json\u001B[39;49m\u001B[38;5;124;43m'\u001B[39;49m\u001B[43m}\u001B[49m\n\u001B[0;32m    162\u001B[0m \u001B[43m\u001B[49m\u001B[43m)\u001B[49m\u001B[38;5;241m.\u001B[39mjson()\n\u001B[0;32m    164\u001B[0m \u001B[38;5;28;01mtry\u001B[39;00m:\n\u001B[0;32m    165\u001B[0m   \u001B[38;5;28;01mreturn\u001B[39;00m resp[\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mdata\u001B[39m\u001B[38;5;124m'\u001B[39m]\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\requests\\api.py:117\u001B[0m, in \u001B[0;36mpost\u001B[1;34m(url, data, json, **kwargs)\u001B[0m\n\u001B[0;32m    105\u001B[0m \u001B[38;5;28;01mdef\u001B[39;00m \u001B[38;5;21mpost\u001B[39m(url, data\u001B[38;5;241m=\u001B[39m\u001B[38;5;28;01mNone\u001B[39;00m, json\u001B[38;5;241m=\u001B[39m\u001B[38;5;28;01mNone\u001B[39;00m, \u001B[38;5;241m*\u001B[39m\u001B[38;5;241m*\u001B[39mkwargs):\n\u001B[0;32m    106\u001B[0m     \u001B[38;5;124mr\u001B[39m\u001B[38;5;124;03m\"\"\"Sends a POST request.\u001B[39;00m\n\u001B[0;32m    107\u001B[0m \n\u001B[0;32m    108\u001B[0m \u001B[38;5;124;03m    :param url: URL for the new :class:`Request` object.\u001B[39;00m\n\u001B[1;32m   (...)\u001B[0m\n\u001B[0;32m    114\u001B[0m \u001B[38;5;124;03m    :rtype: requests.Response\u001B[39;00m\n\u001B[0;32m    115\u001B[0m \u001B[38;5;124;03m    \"\"\"\u001B[39;00m\n\u001B[1;32m--> 117\u001B[0m     \u001B[38;5;28;01mreturn\u001B[39;00m request(\u001B[38;5;124m'\u001B[39m\u001B[38;5;124mpost\u001B[39m\u001B[38;5;124m'\u001B[39m, url, data\u001B[38;5;241m=\u001B[39mdata, json\u001B[38;5;241m=\u001B[39mjson, \u001B[38;5;241m*\u001B[39m\u001B[38;5;241m*\u001B[39mkwargs)\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\requests\\api.py:61\u001B[0m, in \u001B[0;36mrequest\u001B[1;34m(method, url, **kwargs)\u001B[0m\n\u001B[0;32m     57\u001B[0m \u001B[38;5;66;03m# By using the 'with' statement we are sure the session is closed, thus we\u001B[39;00m\n\u001B[0;32m     58\u001B[0m \u001B[38;5;66;03m# avoid leaving sockets open which can trigger a ResourceWarning in some\u001B[39;00m\n\u001B[0;32m     59\u001B[0m \u001B[38;5;66;03m# cases, and look like a memory leak in others.\u001B[39;00m\n\u001B[0;32m     60\u001B[0m \u001B[38;5;28;01mwith\u001B[39;00m sessions\u001B[38;5;241m.\u001B[39mSession() \u001B[38;5;28;01mas\u001B[39;00m session:\n\u001B[1;32m---> 61\u001B[0m     \u001B[38;5;28;01mreturn\u001B[39;00m session\u001B[38;5;241m.\u001B[39mrequest(method\u001B[38;5;241m=\u001B[39mmethod, url\u001B[38;5;241m=\u001B[39murl, \u001B[38;5;241m*\u001B[39m\u001B[38;5;241m*\u001B[39mkwargs)\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\requests\\sessions.py:529\u001B[0m, in \u001B[0;36mSession.request\u001B[1;34m(self, method, url, params, data, headers, cookies, files, auth, timeout, allow_redirects, proxies, hooks, stream, verify, cert, json)\u001B[0m\n\u001B[0;32m    524\u001B[0m send_kwargs \u001B[38;5;241m=\u001B[39m {\n\u001B[0;32m    525\u001B[0m     \u001B[38;5;124m'\u001B[39m\u001B[38;5;124mtimeout\u001B[39m\u001B[38;5;124m'\u001B[39m: timeout,\n\u001B[0;32m    526\u001B[0m     \u001B[38;5;124m'\u001B[39m\u001B[38;5;124mallow_redirects\u001B[39m\u001B[38;5;124m'\u001B[39m: allow_redirects,\n\u001B[0;32m    527\u001B[0m }\n\u001B[0;32m    528\u001B[0m send_kwargs\u001B[38;5;241m.\u001B[39mupdate(settings)\n\u001B[1;32m--> 529\u001B[0m resp \u001B[38;5;241m=\u001B[39m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39msend(prep, \u001B[38;5;241m*\u001B[39m\u001B[38;5;241m*\u001B[39msend_kwargs)\n\u001B[0;32m    531\u001B[0m \u001B[38;5;28;01mreturn\u001B[39;00m resp\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\requests\\sessions.py:645\u001B[0m, in \u001B[0;36mSession.send\u001B[1;34m(self, request, **kwargs)\u001B[0m\n\u001B[0;32m    642\u001B[0m start \u001B[38;5;241m=\u001B[39m preferred_clock()\n\u001B[0;32m    644\u001B[0m \u001B[38;5;66;03m# Send the request\u001B[39;00m\n\u001B[1;32m--> 645\u001B[0m r \u001B[38;5;241m=\u001B[39m adapter\u001B[38;5;241m.\u001B[39msend(request, \u001B[38;5;241m*\u001B[39m\u001B[38;5;241m*\u001B[39mkwargs)\n\u001B[0;32m    647\u001B[0m \u001B[38;5;66;03m# Total elapsed time of the request (approximately)\u001B[39;00m\n\u001B[0;32m    648\u001B[0m elapsed \u001B[38;5;241m=\u001B[39m preferred_clock() \u001B[38;5;241m-\u001B[39m start\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\requests\\adapters.py:440\u001B[0m, in \u001B[0;36mHTTPAdapter.send\u001B[1;34m(self, request, stream, timeout, verify, cert, proxies)\u001B[0m\n\u001B[0;32m    438\u001B[0m \u001B[38;5;28;01mtry\u001B[39;00m:\n\u001B[0;32m    439\u001B[0m     \u001B[38;5;28;01mif\u001B[39;00m \u001B[38;5;129;01mnot\u001B[39;00m chunked:\n\u001B[1;32m--> 440\u001B[0m         resp \u001B[38;5;241m=\u001B[39m \u001B[43mconn\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43murlopen\u001B[49m\u001B[43m(\u001B[49m\n\u001B[0;32m    441\u001B[0m \u001B[43m            \u001B[49m\u001B[43mmethod\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[43mrequest\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mmethod\u001B[49m\u001B[43m,\u001B[49m\n\u001B[0;32m    442\u001B[0m \u001B[43m            \u001B[49m\u001B[43murl\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[43murl\u001B[49m\u001B[43m,\u001B[49m\n\u001B[0;32m    443\u001B[0m \u001B[43m            \u001B[49m\u001B[43mbody\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[43mrequest\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mbody\u001B[49m\u001B[43m,\u001B[49m\n\u001B[0;32m    444\u001B[0m \u001B[43m            \u001B[49m\u001B[43mheaders\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[43mrequest\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mheaders\u001B[49m\u001B[43m,\u001B[49m\n\u001B[0;32m    445\u001B[0m \u001B[43m            \u001B[49m\u001B[43mredirect\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[38;5;28;43;01mFalse\u001B[39;49;00m\u001B[43m,\u001B[49m\n\u001B[0;32m    446\u001B[0m \u001B[43m            \u001B[49m\u001B[43massert_same_host\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[38;5;28;43;01mFalse\u001B[39;49;00m\u001B[43m,\u001B[49m\n\u001B[0;32m    447\u001B[0m \u001B[43m            \u001B[49m\u001B[43mpreload_content\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[38;5;28;43;01mFalse\u001B[39;49;00m\u001B[43m,\u001B[49m\n\u001B[0;32m    448\u001B[0m \u001B[43m            \u001B[49m\u001B[43mdecode_content\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[38;5;28;43;01mFalse\u001B[39;49;00m\u001B[43m,\u001B[49m\n\u001B[0;32m    449\u001B[0m \u001B[43m            \u001B[49m\u001B[43mretries\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[38;5;28;43mself\u001B[39;49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mmax_retries\u001B[49m\u001B[43m,\u001B[49m\n\u001B[0;32m    450\u001B[0m \u001B[43m            \u001B[49m\u001B[43mtimeout\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[43mtimeout\u001B[49m\n\u001B[0;32m    451\u001B[0m \u001B[43m        \u001B[49m\u001B[43m)\u001B[49m\n\u001B[0;32m    453\u001B[0m     \u001B[38;5;66;03m# Send the request.\u001B[39;00m\n\u001B[0;32m    454\u001B[0m     \u001B[38;5;28;01melse\u001B[39;00m:\n\u001B[0;32m    455\u001B[0m         \u001B[38;5;28;01mif\u001B[39;00m \u001B[38;5;28mhasattr\u001B[39m(conn, \u001B[38;5;124m'\u001B[39m\u001B[38;5;124mproxy_pool\u001B[39m\u001B[38;5;124m'\u001B[39m):\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\urllib3\\connectionpool.py:703\u001B[0m, in \u001B[0;36mHTTPConnectionPool.urlopen\u001B[1;34m(self, method, url, body, headers, retries, redirect, assert_same_host, timeout, pool_timeout, release_conn, chunked, body_pos, **response_kw)\u001B[0m\n\u001B[0;32m    700\u001B[0m     \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39m_prepare_proxy(conn)\n\u001B[0;32m    702\u001B[0m \u001B[38;5;66;03m# Make the request on the httplib connection object.\u001B[39;00m\n\u001B[1;32m--> 703\u001B[0m httplib_response \u001B[38;5;241m=\u001B[39m \u001B[38;5;28;43mself\u001B[39;49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43m_make_request\u001B[49m\u001B[43m(\u001B[49m\n\u001B[0;32m    704\u001B[0m \u001B[43m    \u001B[49m\u001B[43mconn\u001B[49m\u001B[43m,\u001B[49m\n\u001B[0;32m    705\u001B[0m \u001B[43m    \u001B[49m\u001B[43mmethod\u001B[49m\u001B[43m,\u001B[49m\n\u001B[0;32m    706\u001B[0m \u001B[43m    \u001B[49m\u001B[43murl\u001B[49m\u001B[43m,\u001B[49m\n\u001B[0;32m    707\u001B[0m \u001B[43m    \u001B[49m\u001B[43mtimeout\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[43mtimeout_obj\u001B[49m\u001B[43m,\u001B[49m\n\u001B[0;32m    708\u001B[0m \u001B[43m    \u001B[49m\u001B[43mbody\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[43mbody\u001B[49m\u001B[43m,\u001B[49m\n\u001B[0;32m    709\u001B[0m \u001B[43m    \u001B[49m\u001B[43mheaders\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[43mheaders\u001B[49m\u001B[43m,\u001B[49m\n\u001B[0;32m    710\u001B[0m \u001B[43m    \u001B[49m\u001B[43mchunked\u001B[49m\u001B[38;5;241;43m=\u001B[39;49m\u001B[43mchunked\u001B[49m\u001B[43m,\u001B[49m\n\u001B[0;32m    711\u001B[0m \u001B[43m\u001B[49m\u001B[43m)\u001B[49m\n\u001B[0;32m    713\u001B[0m \u001B[38;5;66;03m# If we're going to release the connection in ``finally:``, then\u001B[39;00m\n\u001B[0;32m    714\u001B[0m \u001B[38;5;66;03m# the response doesn't need to know about the connection. Otherwise\u001B[39;00m\n\u001B[0;32m    715\u001B[0m \u001B[38;5;66;03m# it will also try to release it and we'll have a double-release\u001B[39;00m\n\u001B[0;32m    716\u001B[0m \u001B[38;5;66;03m# mess.\u001B[39;00m\n\u001B[0;32m    717\u001B[0m response_conn \u001B[38;5;241m=\u001B[39m conn \u001B[38;5;28;01mif\u001B[39;00m \u001B[38;5;129;01mnot\u001B[39;00m release_conn \u001B[38;5;28;01melse\u001B[39;00m \u001B[38;5;28;01mNone\u001B[39;00m\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\urllib3\\connectionpool.py:449\u001B[0m, in \u001B[0;36mHTTPConnectionPool._make_request\u001B[1;34m(self, conn, method, url, timeout, chunked, **httplib_request_kw)\u001B[0m\n\u001B[0;32m    444\u001B[0m             httplib_response \u001B[38;5;241m=\u001B[39m conn\u001B[38;5;241m.\u001B[39mgetresponse()\n\u001B[0;32m    445\u001B[0m         \u001B[38;5;28;01mexcept\u001B[39;00m \u001B[38;5;167;01mBaseException\u001B[39;00m \u001B[38;5;28;01mas\u001B[39;00m e:\n\u001B[0;32m    446\u001B[0m             \u001B[38;5;66;03m# Remove the TypeError from the exception chain in\u001B[39;00m\n\u001B[0;32m    447\u001B[0m             \u001B[38;5;66;03m# Python 3 (including for exceptions like SystemExit).\u001B[39;00m\n\u001B[0;32m    448\u001B[0m             \u001B[38;5;66;03m# Otherwise it looks like a bug in the code.\u001B[39;00m\n\u001B[1;32m--> 449\u001B[0m             \u001B[43msix\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mraise_from\u001B[49m\u001B[43m(\u001B[49m\u001B[43me\u001B[49m\u001B[43m,\u001B[49m\u001B[43m \u001B[49m\u001B[38;5;28;43;01mNone\u001B[39;49;00m\u001B[43m)\u001B[49m\n\u001B[0;32m    450\u001B[0m \u001B[38;5;28;01mexcept\u001B[39;00m (SocketTimeout, BaseSSLError, SocketError) \u001B[38;5;28;01mas\u001B[39;00m e:\n\u001B[0;32m    451\u001B[0m     \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39m_raise_timeout(err\u001B[38;5;241m=\u001B[39me, url\u001B[38;5;241m=\u001B[39murl, timeout_value\u001B[38;5;241m=\u001B[39mread_timeout)\n",
      "File \u001B[1;32m<string>:3\u001B[0m, in \u001B[0;36mraise_from\u001B[1;34m(value, from_value)\u001B[0m\n",
      "File \u001B[1;32m~\\PycharmProjects\\pythonProject\\venv\\lib\\site-packages\\urllib3\\connectionpool.py:444\u001B[0m, in \u001B[0;36mHTTPConnectionPool._make_request\u001B[1;34m(self, conn, method, url, timeout, chunked, **httplib_request_kw)\u001B[0m\n\u001B[0;32m    441\u001B[0m \u001B[38;5;28;01mexcept\u001B[39;00m \u001B[38;5;167;01mTypeError\u001B[39;00m:\n\u001B[0;32m    442\u001B[0m     \u001B[38;5;66;03m# Python 3\u001B[39;00m\n\u001B[0;32m    443\u001B[0m     \u001B[38;5;28;01mtry\u001B[39;00m:\n\u001B[1;32m--> 444\u001B[0m         httplib_response \u001B[38;5;241m=\u001B[39m \u001B[43mconn\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mgetresponse\u001B[49m\u001B[43m(\u001B[49m\u001B[43m)\u001B[49m\n\u001B[0;32m    445\u001B[0m     \u001B[38;5;28;01mexcept\u001B[39;00m \u001B[38;5;167;01mBaseException\u001B[39;00m \u001B[38;5;28;01mas\u001B[39;00m e:\n\u001B[0;32m    446\u001B[0m         \u001B[38;5;66;03m# Remove the TypeError from the exception chain in\u001B[39;00m\n\u001B[0;32m    447\u001B[0m         \u001B[38;5;66;03m# Python 3 (including for exceptions like SystemExit).\u001B[39;00m\n\u001B[0;32m    448\u001B[0m         \u001B[38;5;66;03m# Otherwise it looks like a bug in the code.\u001B[39;00m\n\u001B[0;32m    449\u001B[0m         six\u001B[38;5;241m.\u001B[39mraise_from(e, \u001B[38;5;28;01mNone\u001B[39;00m)\n",
      "File \u001B[1;32m~\\AppData\\Local\\Programs\\Python\\Python310\\lib\\http\\client.py:1368\u001B[0m, in \u001B[0;36mHTTPConnection.getresponse\u001B[1;34m(self)\u001B[0m\n\u001B[0;32m   1366\u001B[0m \u001B[38;5;28;01mtry\u001B[39;00m:\n\u001B[0;32m   1367\u001B[0m     \u001B[38;5;28;01mtry\u001B[39;00m:\n\u001B[1;32m-> 1368\u001B[0m         \u001B[43mresponse\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mbegin\u001B[49m\u001B[43m(\u001B[49m\u001B[43m)\u001B[49m\n\u001B[0;32m   1369\u001B[0m     \u001B[38;5;28;01mexcept\u001B[39;00m \u001B[38;5;167;01mConnectionError\u001B[39;00m:\n\u001B[0;32m   1370\u001B[0m         \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39mclose()\n",
      "File \u001B[1;32m~\\AppData\\Local\\Programs\\Python\\Python310\\lib\\http\\client.py:317\u001B[0m, in \u001B[0;36mHTTPResponse.begin\u001B[1;34m(self)\u001B[0m\n\u001B[0;32m    315\u001B[0m \u001B[38;5;66;03m# read until we get a non-100 response\u001B[39;00m\n\u001B[0;32m    316\u001B[0m \u001B[38;5;28;01mwhile\u001B[39;00m \u001B[38;5;28;01mTrue\u001B[39;00m:\n\u001B[1;32m--> 317\u001B[0m     version, status, reason \u001B[38;5;241m=\u001B[39m \u001B[38;5;28;43mself\u001B[39;49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43m_read_status\u001B[49m\u001B[43m(\u001B[49m\u001B[43m)\u001B[49m\n\u001B[0;32m    318\u001B[0m     \u001B[38;5;28;01mif\u001B[39;00m status \u001B[38;5;241m!=\u001B[39m CONTINUE:\n\u001B[0;32m    319\u001B[0m         \u001B[38;5;28;01mbreak\u001B[39;00m\n",
      "File \u001B[1;32m~\\AppData\\Local\\Programs\\Python\\Python310\\lib\\http\\client.py:278\u001B[0m, in \u001B[0;36mHTTPResponse._read_status\u001B[1;34m(self)\u001B[0m\n\u001B[0;32m    277\u001B[0m \u001B[38;5;28;01mdef\u001B[39;00m \u001B[38;5;21m_read_status\u001B[39m(\u001B[38;5;28mself\u001B[39m):\n\u001B[1;32m--> 278\u001B[0m     line \u001B[38;5;241m=\u001B[39m \u001B[38;5;28mstr\u001B[39m(\u001B[38;5;28;43mself\u001B[39;49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mfp\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mreadline\u001B[49m\u001B[43m(\u001B[49m\u001B[43m_MAXLINE\u001B[49m\u001B[43m \u001B[49m\u001B[38;5;241;43m+\u001B[39;49m\u001B[43m \u001B[49m\u001B[38;5;241;43m1\u001B[39;49m\u001B[43m)\u001B[49m, \u001B[38;5;124m\"\u001B[39m\u001B[38;5;124miso-8859-1\u001B[39m\u001B[38;5;124m\"\u001B[39m)\n\u001B[0;32m    279\u001B[0m     \u001B[38;5;28;01mif\u001B[39;00m \u001B[38;5;28mlen\u001B[39m(line) \u001B[38;5;241m>\u001B[39m _MAXLINE:\n\u001B[0;32m    280\u001B[0m         \u001B[38;5;28;01mraise\u001B[39;00m LineTooLong(\u001B[38;5;124m\"\u001B[39m\u001B[38;5;124mstatus line\u001B[39m\u001B[38;5;124m\"\u001B[39m)\n",
      "File \u001B[1;32m~\\AppData\\Local\\Programs\\Python\\Python310\\lib\\socket.py:705\u001B[0m, in \u001B[0;36mSocketIO.readinto\u001B[1;34m(self, b)\u001B[0m\n\u001B[0;32m    703\u001B[0m \u001B[38;5;28;01mwhile\u001B[39;00m \u001B[38;5;28;01mTrue\u001B[39;00m:\n\u001B[0;32m    704\u001B[0m     \u001B[38;5;28;01mtry\u001B[39;00m:\n\u001B[1;32m--> 705\u001B[0m         \u001B[38;5;28;01mreturn\u001B[39;00m \u001B[38;5;28;43mself\u001B[39;49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43m_sock\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mrecv_into\u001B[49m\u001B[43m(\u001B[49m\u001B[43mb\u001B[49m\u001B[43m)\u001B[49m\n\u001B[0;32m    706\u001B[0m     \u001B[38;5;28;01mexcept\u001B[39;00m timeout:\n\u001B[0;32m    707\u001B[0m         \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39m_timeout_occurred \u001B[38;5;241m=\u001B[39m \u001B[38;5;28;01mTrue\u001B[39;00m\n",
      "File \u001B[1;32m~\\AppData\\Local\\Programs\\Python\\Python310\\lib\\ssl.py:1273\u001B[0m, in \u001B[0;36mSSLSocket.recv_into\u001B[1;34m(self, buffer, nbytes, flags)\u001B[0m\n\u001B[0;32m   1269\u001B[0m     \u001B[38;5;28;01mif\u001B[39;00m flags \u001B[38;5;241m!=\u001B[39m \u001B[38;5;241m0\u001B[39m:\n\u001B[0;32m   1270\u001B[0m         \u001B[38;5;28;01mraise\u001B[39;00m \u001B[38;5;167;01mValueError\u001B[39;00m(\n\u001B[0;32m   1271\u001B[0m           \u001B[38;5;124m\"\u001B[39m\u001B[38;5;124mnon-zero flags not allowed in calls to recv_into() on \u001B[39m\u001B[38;5;132;01m%s\u001B[39;00m\u001B[38;5;124m\"\u001B[39m \u001B[38;5;241m%\u001B[39m\n\u001B[0;32m   1272\u001B[0m           \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39m\u001B[38;5;18m__class__\u001B[39m)\n\u001B[1;32m-> 1273\u001B[0m     \u001B[38;5;28;01mreturn\u001B[39;00m \u001B[38;5;28;43mself\u001B[39;49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mread\u001B[49m\u001B[43m(\u001B[49m\u001B[43mnbytes\u001B[49m\u001B[43m,\u001B[49m\u001B[43m \u001B[49m\u001B[43mbuffer\u001B[49m\u001B[43m)\u001B[49m\n\u001B[0;32m   1274\u001B[0m \u001B[38;5;28;01melse\u001B[39;00m:\n\u001B[0;32m   1275\u001B[0m     \u001B[38;5;28;01mreturn\u001B[39;00m \u001B[38;5;28msuper\u001B[39m()\u001B[38;5;241m.\u001B[39mrecv_into(buffer, nbytes, flags)\n",
      "File \u001B[1;32m~\\AppData\\Local\\Programs\\Python\\Python310\\lib\\ssl.py:1129\u001B[0m, in \u001B[0;36mSSLSocket.read\u001B[1;34m(self, len, buffer)\u001B[0m\n\u001B[0;32m   1127\u001B[0m \u001B[38;5;28;01mtry\u001B[39;00m:\n\u001B[0;32m   1128\u001B[0m     \u001B[38;5;28;01mif\u001B[39;00m buffer \u001B[38;5;129;01mis\u001B[39;00m \u001B[38;5;129;01mnot\u001B[39;00m \u001B[38;5;28;01mNone\u001B[39;00m:\n\u001B[1;32m-> 1129\u001B[0m         \u001B[38;5;28;01mreturn\u001B[39;00m \u001B[38;5;28;43mself\u001B[39;49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43m_sslobj\u001B[49m\u001B[38;5;241;43m.\u001B[39;49m\u001B[43mread\u001B[49m\u001B[43m(\u001B[49m\u001B[38;5;28;43mlen\u001B[39;49m\u001B[43m,\u001B[49m\u001B[43m \u001B[49m\u001B[43mbuffer\u001B[49m\u001B[43m)\u001B[49m\n\u001B[0;32m   1130\u001B[0m     \u001B[38;5;28;01melse\u001B[39;00m:\n\u001B[0;32m   1131\u001B[0m         \u001B[38;5;28;01mreturn\u001B[39;00m \u001B[38;5;28mself\u001B[39m\u001B[38;5;241m.\u001B[39m_sslobj\u001B[38;5;241m.\u001B[39mread(\u001B[38;5;28mlen\u001B[39m)\n",
      "\u001B[1;31mKeyboardInterrupt\u001B[0m: "
     ]
    }
   ],
   "source": [
    "actionListLength=0\n",
    "actionTicker = 0\n",
    "fraxUsersDb = pd.DataFrame()\n",
    "actionsDb = pd.DataFrame()\n",
    "actionListLength = 1000\n",
    "datediff = 0\n",
    "now=0\n",
    "daysAgo=0\n",
    "daysLimit = 45\n",
    "while daysAgo<=daysLimit:\n",
    "    #listLength=0\n",
    "    skipValue = (actionTicker)*(1000)\n",
    "    actionsQuery = frax.Query.actions(\n",
    "         orderBy='timestamp'\n",
    "        ,orderDirection='desc'\n",
    "        ,first=1000\n",
    "        ,skipValue = skipValue\n",
    "        #,where = [frax.Query.actions.token.id == '0x66bf36dba79d4606039f04b32946a260bcd3ff52']\n",
    "        ,where={ 'pair': '0x66bf36dba79d4606039f04b32946a260bcd3ff52' }\n",
    "        #,where = {'positions.pairid':'0x66bf36dba79d4606039f04b32946a260bcd3ff52'}\n",
    "    #{'users_positions_pair_id':'0x66bf36dba79d4606039f04b32946a260bcd3ff52'}\n",
    "\n",
    "    )\n",
    "    actions= sg.query_df([\n",
    "        actionsQuery.id\n",
    "        ,actionsQuery.type\n",
    "        ,actionsQuery.amount\n",
    "        ,actionsQuery.share\n",
    "        ,actionsQuery.timestamp\n",
    "        ,actionsQuery.block\n",
    "        ,actionsQuery.token\n",
    "        ,actionsQuery.root\n",
    "        ]\n",
    "    )\n",
    "\n",
    "    actions.sort_values(by=['actions_timestamp'])\n",
    "\n",
    "    actionsDb=pd.concat([actionsDb, actions])\n",
    "    recordTimestamp1 = actionsDb.iat[actionTicker,4]\n",
    "    recordTimestamp = dt.datetime.fromtimestamp( recordTimestamp1 )\n",
    "    now = (int(dt.datetime.utcnow().timestamp()))\n",
    "    datediff=abs(int(now) - recordTimestamp1)\n",
    "    daysAgo = int(datediff/86400)\n",
    "    actionsDbLength = len(actionsDb)\n",
    "    actionListLength = len(actions)\n",
    "    recordID = actionsDb.iat[actionTicker,0]\n",
    "    action = actionsDb.iat[actionTicker,1]\n",
    "    print(\"iterations: \", actionTicker, \"Lines skipped: \",skipValue, \"records collected: \", actionListLength, \" - latest recordID: \",action, \" \", recordID , \" - actions DB length: \", actionsDbLength, \" - latest record from: \", recordTimestamp, daysAgo,\"days ago\")\n",
    "    #print(\"iterations: \", actionTicker, \"records collected: \", actionListLength, \" - userdb length: \", actionsDbLength)\n",
    "    actionTicker = actionTicker+1\n",
    "print(\"Done. Total Records collected: \", actionsDbLength)"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "outputs": [
    {
     "data": {
      "text/plain": "                                          actions_id      actions_type  \\\n0  0x326e0444e2ccf71f1285954fdbbcc855c29485f92ea0...       borrowAsset   \n1  0x326e0444e2ccf71f1285954fdbbcc855c29485f92ea0...     addCollateral   \n2  0x6b99b9e2f74062143534c02a79920d1c33f6d56fcd05...       borrowAsset   \n3  0x6b99b9e2f74062143534c02a79920d1c33f6d56fcd05...     addCollateral   \n4  0x0b18b1c7c3dafc9ef9f513f540f1de376325ceec3962...  removeCollateral   \n5  0x996d854115a22865e3a5ac1a4ee49b33ce889ea4b8e6...       borrowAsset   \n6  0x996d854115a22865e3a5ac1a4ee49b33ce889ea4b8e6...     addCollateral   \n7  0x552a52cd82bbebd0c5c0a9927eb3038c02786eef571b...  removeCollateral   \n8  0xcbda7b3075b591cb56f138137c3a0473f29c824ed257...          addAsset   \n9  0x60c347a83d10615197b96f4d23f6760e8947668d8ea3...  removeCollateral   \n\n            actions_amount           actions_share  actions_timestamp  \\\n0                        0                       0         1675709111   \n1     14182144364954926399    14182144364954926399         1675709111   \n2                        0                       0         1675702943   \n3      5624982836867777518     5624982836867777518         1675702943   \n4     20000000000000000000    20000000000000000000         1675702331   \n5                        0                       0         1675683731   \n6     15016879628137734463    15016879628137734463         1675683731   \n7     15000000000000000000    15000000000000000000         1675683491   \n8  10003561872284456726924  9893649550897731715443         1675660439   \n9     57028659821449127926    57028659821449127926         1675643255   \n\n   actions_block                            actions_token_id  \\\n0       16571623  0x853d955acef822db058eb8505911ed77f175b99e   \n1       16571623  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n2       16571111  0x853d955acef822db058eb8505911ed77f175b99e   \n3       16571111  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n4       16571060  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n5       16569517  0x853d955acef822db058eb8505911ed77f175b99e   \n6       16569517  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n7       16569497  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n8       16567585  0x853d955acef822db058eb8505911ed77f175b99e   \n9       16566160  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n\n                        actions_token_address  actions_token_decimals  \\\n0  0x853d955acef822db058eb8505911ed77f175b99e                      18   \n1  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f                      18   \n2  0x853d955acef822db058eb8505911ed77f175b99e                      18   \n3  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f                      18   \n4  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f                      18   \n5  0x853d955acef822db058eb8505911ed77f175b99e                      18   \n6  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f                      18   \n7  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f                      18   \n8  0x853d955acef822db058eb8505911ed77f175b99e                      18   \n9  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f                      18   \n\n  actions_token_name actions_token_symbol     actions_token_totalSupply  \\\n0               Frax                 FRAX  1491128187367401878671217133   \n1     Governance OHM                 gOHM       71757394079134961624973   \n2               Frax                 FRAX  1491128187367401878671217133   \n3     Governance OHM                 gOHM       71757394079134961624973   \n4     Governance OHM                 gOHM       71757394079134961624973   \n5               Frax                 FRAX  1491128187367401878671217133   \n6     Governance OHM                 gOHM       71757394079134961624973   \n7     Governance OHM                 gOHM       71757394079134961624973   \n8               Frax                 FRAX  1491128187367401878671217133   \n9     Governance OHM                 gOHM       71757394079134961624973   \n\n   actions_token_pairAssetCount  actions_token_pairCollateralCount  \\\n0                            12                                  0   \n1                             0                                  1   \n2                            12                                  0   \n3                             0                                  1   \n4                             0                                  1   \n5                            12                                  0   \n6                             0                                  1   \n7                             0                                  1   \n8                            12                                  0   \n9                             0                                  1   \n\n                              actions_root_id  \\\n0  0xc0e0de939f26e71683452467942aff455ca153e3   \n1  0xc0e0de939f26e71683452467942aff455ca153e3   \n2  0xc0e0de939f26e71683452467942aff455ca153e3   \n3  0xc0e0de939f26e71683452467942aff455ca153e3   \n4  0xc0e0de939f26e71683452467942aff455ca153e3   \n5  0xc0e0de939f26e71683452467942aff455ca153e3   \n6  0xc0e0de939f26e71683452467942aff455ca153e3   \n7  0xc0e0de939f26e71683452467942aff455ca153e3   \n8  0x8a7f162daac546997cc36b6b7c528a21800507b9   \n9  0x46535cbc3fa574c32ea392d4f89c518290597072   \n\n                         actions_root_address            dateTime  \n0  0xc0e0de939f26e71683452467942aff455ca153e3 2023-02-06 18:45:11  \n1  0xc0e0de939f26e71683452467942aff455ca153e3 2023-02-06 18:45:11  \n2  0xc0e0de939f26e71683452467942aff455ca153e3 2023-02-06 17:02:23  \n3  0xc0e0de939f26e71683452467942aff455ca153e3 2023-02-06 17:02:23  \n4  0xc0e0de939f26e71683452467942aff455ca153e3 2023-02-06 16:52:11  \n5  0xc0e0de939f26e71683452467942aff455ca153e3 2023-02-06 11:42:11  \n6  0xc0e0de939f26e71683452467942aff455ca153e3 2023-02-06 11:42:11  \n7  0xc0e0de939f26e71683452467942aff455ca153e3 2023-02-06 11:38:11  \n8  0x8a7f162daac546997cc36b6b7c528a21800507b9 2023-02-06 05:13:59  \n9  0x46535cbc3fa574c32ea392d4f89c518290597072 2023-02-06 00:27:35  ",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>actions_id</th>\n      <th>actions_type</th>\n      <th>actions_amount</th>\n      <th>actions_share</th>\n      <th>actions_timestamp</th>\n      <th>actions_block</th>\n      <th>actions_token_id</th>\n      <th>actions_token_address</th>\n      <th>actions_token_decimals</th>\n      <th>actions_token_name</th>\n      <th>actions_token_symbol</th>\n      <th>actions_token_totalSupply</th>\n      <th>actions_token_pairAssetCount</th>\n      <th>actions_token_pairCollateralCount</th>\n      <th>actions_root_id</th>\n      <th>actions_root_address</th>\n      <th>dateTime</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>0x326e0444e2ccf71f1285954fdbbcc855c29485f92ea0...</td>\n      <td>borrowAsset</td>\n      <td>0</td>\n      <td>0</td>\n      <td>1675709111</td>\n      <td>16571623</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>18</td>\n      <td>Frax</td>\n      <td>FRAX</td>\n      <td>1491128187367401878671217133</td>\n      <td>12</td>\n      <td>0</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>2023-02-06 18:45:11</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>0x326e0444e2ccf71f1285954fdbbcc855c29485f92ea0...</td>\n      <td>addCollateral</td>\n      <td>14182144364954926399</td>\n      <td>14182144364954926399</td>\n      <td>1675709111</td>\n      <td>16571623</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>18</td>\n      <td>Governance OHM</td>\n      <td>gOHM</td>\n      <td>71757394079134961624973</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>2023-02-06 18:45:11</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>0x6b99b9e2f74062143534c02a79920d1c33f6d56fcd05...</td>\n      <td>borrowAsset</td>\n      <td>0</td>\n      <td>0</td>\n      <td>1675702943</td>\n      <td>16571111</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>18</td>\n      <td>Frax</td>\n      <td>FRAX</td>\n      <td>1491128187367401878671217133</td>\n      <td>12</td>\n      <td>0</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>2023-02-06 17:02:23</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>0x6b99b9e2f74062143534c02a79920d1c33f6d56fcd05...</td>\n      <td>addCollateral</td>\n      <td>5624982836867777518</td>\n      <td>5624982836867777518</td>\n      <td>1675702943</td>\n      <td>16571111</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>18</td>\n      <td>Governance OHM</td>\n      <td>gOHM</td>\n      <td>71757394079134961624973</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>2023-02-06 17:02:23</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>0x0b18b1c7c3dafc9ef9f513f540f1de376325ceec3962...</td>\n      <td>removeCollateral</td>\n      <td>20000000000000000000</td>\n      <td>20000000000000000000</td>\n      <td>1675702331</td>\n      <td>16571060</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>18</td>\n      <td>Governance OHM</td>\n      <td>gOHM</td>\n      <td>71757394079134961624973</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>2023-02-06 16:52:11</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>0x996d854115a22865e3a5ac1a4ee49b33ce889ea4b8e6...</td>\n      <td>borrowAsset</td>\n      <td>0</td>\n      <td>0</td>\n      <td>1675683731</td>\n      <td>16569517</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>18</td>\n      <td>Frax</td>\n      <td>FRAX</td>\n      <td>1491128187367401878671217133</td>\n      <td>12</td>\n      <td>0</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>2023-02-06 11:42:11</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>0x996d854115a22865e3a5ac1a4ee49b33ce889ea4b8e6...</td>\n      <td>addCollateral</td>\n      <td>15016879628137734463</td>\n      <td>15016879628137734463</td>\n      <td>1675683731</td>\n      <td>16569517</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>18</td>\n      <td>Governance OHM</td>\n      <td>gOHM</td>\n      <td>71757394079134961624973</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>2023-02-06 11:42:11</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>0x552a52cd82bbebd0c5c0a9927eb3038c02786eef571b...</td>\n      <td>removeCollateral</td>\n      <td>15000000000000000000</td>\n      <td>15000000000000000000</td>\n      <td>1675683491</td>\n      <td>16569497</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>18</td>\n      <td>Governance OHM</td>\n      <td>gOHM</td>\n      <td>71757394079134961624973</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>0xc0e0de939f26e71683452467942aff455ca153e3</td>\n      <td>2023-02-06 11:38:11</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>0xcbda7b3075b591cb56f138137c3a0473f29c824ed257...</td>\n      <td>addAsset</td>\n      <td>10003561872284456726924</td>\n      <td>9893649550897731715443</td>\n      <td>1675660439</td>\n      <td>16567585</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>0x853d955acef822db058eb8505911ed77f175b99e</td>\n      <td>18</td>\n      <td>Frax</td>\n      <td>FRAX</td>\n      <td>1491128187367401878671217133</td>\n      <td>12</td>\n      <td>0</td>\n      <td>0x8a7f162daac546997cc36b6b7c528a21800507b9</td>\n      <td>0x8a7f162daac546997cc36b6b7c528a21800507b9</td>\n      <td>2023-02-06 05:13:59</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>0x60c347a83d10615197b96f4d23f6760e8947668d8ea3...</td>\n      <td>removeCollateral</td>\n      <td>57028659821449127926</td>\n      <td>57028659821449127926</td>\n      <td>1675643255</td>\n      <td>16566160</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>18</td>\n      <td>Governance OHM</td>\n      <td>gOHM</td>\n      <td>71757394079134961624973</td>\n      <td>0</td>\n      <td>1</td>\n      <td>0x46535cbc3fa574c32ea392d4f89c518290597072</td>\n      <td>0x46535cbc3fa574c32ea392d4f89c518290597072</td>\n      <td>2023-02-06 00:27:35</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "    actionsDbTimed = db.query(\"select \"\n",
    "                   \"    * \"\n",
    "                        \" ,to_timestamp(actions_timestamp) dateTime \"\n",
    "                   \"From actionsDb \"\n",
    "                   #\"where lower(liquidityPools_name) like lower('%olympus%') \"\n",
    "                    #    \"or lower(pairs_token1_symbol) like lower('%OHM%')  \"\n",
    "                   #\" limit 100 \"\n",
    "                   ).df()\n",
    "actionsDbTimed.head(10)"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "outputs": [
    {
     "data": {
      "text/plain": "590000"
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(actionsDbTimed)"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "outputs": [],
   "source": [
    "path =file+'/fraxLendingActions '+str(dt.datetime.today().strftime(\"%b-%d-%Y\"))+\"_\"+str(actionsDbLength)+'records.csv'\n",
    "actionsDbTimed.to_csv(path, index = False)"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "outputs": [],
   "source": [
    "path =file+'/fraxLendingActions '+'records.csv'\n",
    "actionsDbTimed.to_csv(path, index = False, sep='|')"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "iterations:  0 Lines skipped:  0 records collected:  70  - latest recordID:  0   0x66bf36dba79d4606039f04b32946a260bcd3ff52-Recent  - pairSnapshots DB length:  70  - latest record from:  2023-02-06 03:42:11 0 days ago\n",
      "iterations:  1 Lines skipped:  1000 records collected:  70  - latest recordID:  0   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19394  - pairSnapshots DB length:  140  - latest record from:  2023-02-06 03:42:11 0 days ago\n",
      "iterations:  2 Lines skipped:  2000 records collected:  70  - latest recordID:  0   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19393  - pairSnapshots DB length:  210  - latest record from:  2023-02-05 14:09:23 1 days ago\n",
      "iterations:  3 Lines skipped:  3000 records collected:  70  - latest recordID:  0   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19392  - pairSnapshots DB length:  280  - latest record from:  2023-02-03 11:11:35 3 days ago\n",
      "iterations:  4 Lines skipped:  4000 records collected:  70  - latest recordID:  0   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19391  - pairSnapshots DB length:  350  - latest record from:  2023-02-03 11:11:35 3 days ago\n",
      "iterations:  5 Lines skipped:  5000 records collected:  70  - latest recordID:  0   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19390  - pairSnapshots DB length:  420  - latest record from:  2023-02-02 15:47:35 3 days ago\n",
      "iterations:  6 Lines skipped:  6000 records collected:  70  - latest recordID:  0   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19389  - pairSnapshots DB length:  490  - latest record from:  2023-02-01 13:01:35 5 days ago\n",
      "iterations:  7 Lines skipped:  7000 records collected:  70  - latest recordID:  0   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19388  - pairSnapshots DB length:  560  - latest record from:  2023-01-31 15:17:47 6 days ago\n",
      "iterations:  8 Lines skipped:  8000 records collected:  70  - latest recordID:  0   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19387  - pairSnapshots DB length:  630  - latest record from:  2023-01-30 15:08:59 7 days ago\n",
      "iterations:  9 Lines skipped:  9000 records collected:  70  - latest recordID:  0   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19386  - pairSnapshots DB length:  700  - latest record from:  2023-01-29 12:51:59 8 days ago\n",
      "iterations:  10 Lines skipped:  10000 records collected:  70  - latest recordID:  0   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19385  - pairSnapshots DB length:  770  - latest record from:  2023-01-28 13:46:59 9 days ago\n",
      "iterations:  11 Lines skipped:  11000 records collected:  70  - latest recordID:  0   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19384  - pairSnapshots DB length:  840  - latest record from:  2023-01-27 09:40:11 10 days ago\n",
      "iterations:  12 Lines skipped:  12000 records collected:  70  - latest recordID:  0   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19383  - pairSnapshots DB length:  910  - latest record from:  2023-01-26 14:18:47 11 days ago\n",
      "Done. Total Records collected:  910\n"
     ]
    }
   ],
   "source": [
    "pairSnapshotsListLength=0\n",
    "pairSnapshotsTicker = 0\n",
    "Snapshots = pd.DataFrame()\n",
    "pairSnapshotsDb = pd.DataFrame()\n",
    "pairSnapshotsListLength = 1000\n",
    "datediff = 0\n",
    "now=0\n",
    "daysAgo=0\n",
    "daysLimit = 10\n",
    "while daysAgo<=daysLimit:\n",
    "    #listLength=0\n",
    "    skipValue = (pairSnapshotsTicker)*(1000)\n",
    "    pairsQuery = frax.Query.pairPerDays(\n",
    "         orderBy='id'\n",
    "        ,orderDirection='desc'\n",
    "        ,first=1000\n",
    "        ,skipValue = skipValue\n",
    "        #,where = [frax.Query.pairs.token.id == '0x66bf36dba79d4606039f04b32946a260bcd3ff52']\n",
    "        ,where={ 'pair': '0x66bf36dba79d4606039f04b32946a260bcd3ff52' }\n",
    "        #,where = {'positions.pairid':'0x66bf36dba79d4606039f04b32946a260bcd3ff52'}\n",
    "    #{'users_positions_pair_id':'0x66bf36dba79d4606039f04b32946a260bcd3ff52'}\n",
    "\n",
    "    )\n",
    "    Snapshots= sg.query_df([\n",
    "    pairsQuery.id\n",
    "    ,pairsQuery.feeToProtocolRate\n",
    "    ,pairsQuery.exchangeRate\n",
    "    ,pairsQuery.totalAssetAmount\n",
    "    ,pairsQuery.totalAssetShare\n",
    "    ,pairsQuery.totalCollateral\n",
    "    ,pairsQuery.totalBorrowAmount\n",
    "    ,pairsQuery.totalBorrowShare\n",
    "    ,pairsQuery.interestPerSecond\n",
    "    ,pairsQuery.utilization\n",
    "    ,pairsQuery.totalFeesAmount\n",
    "    ,pairsQuery.totalFeesShare\n",
    "    ,pairsQuery.lastAccrued\n",
    "    ,pairsQuery.block\n",
    "    ,pairsQuery.timestamp\n",
    "    ,pairsQuery.totalAssetValue\n",
    "    ,pairsQuery.totalCollateralValue\n",
    "    ,pairsQuery.totalBorrowValue\n",
    "    ,pairsQuery.pair\n",
    "    ]\n",
    "    )\n",
    "\n",
    "    Snapshots.sort_values(by=['pairPerDays_timestamp'])\n",
    "\n",
    "    pairSnapshotsDb=pd.concat([pairSnapshotsDb, Snapshots])\n",
    "    recordTimestamp1 = pairSnapshotsDb.iat[pairSnapshotsTicker,14]\n",
    "    recordTimestamp = dt.datetime.fromtimestamp( recordTimestamp1 )\n",
    "    now = (int(dt.datetime.utcnow().timestamp()))\n",
    "    datediff=abs(int(now) - recordTimestamp1)\n",
    "    daysAgo = int(datediff/86400)\n",
    "    pairSnapshotsDbLength = len(pairSnapshotsDb)\n",
    "    pairSnapshotsListLength = len(Snapshots)\n",
    "    recordID = pairSnapshotsDb.iat[pairSnapshotsTicker,0]\n",
    "    Snapshot = pairSnapshotsDb.iat[pairSnapshotsTicker,1]\n",
    "    print(\"iterations: \", pairSnapshotsTicker, \"Lines skipped: \",skipValue, \"records collected: \", pairSnapshotsListLength, \" - latest recordID: \",Snapshot, \" \", recordID , \" - pairSnapshots DB length: \", pairSnapshotsDbLength, \" - latest record from: \", recordTimestamp, daysAgo,\"days ago\")\n",
    "    #print(\"iterations: \", pairSnapshotsTicker, \"records collected: \", pairSnapshotsListLength, \" - userdb length: \", pairSnapshotsDbLength)\n",
    "    pairSnapshotsTicker = pairSnapshotsTicker+1\n",
    "print(\"Done. Total Records collected: \", pairSnapshotsDbLength)"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "outputs": [
    {
     "data": {
      "text/plain": "                                       pairPerDays_id  \\\n0   0x66bf36dba79d4606039f04b32946a260bcd3ff52-Recent   \n1    0x66bf36dba79d4606039f04b32946a260bcd3ff52-19394   \n2    0x66bf36dba79d4606039f04b32946a260bcd3ff52-19393   \n3    0x66bf36dba79d4606039f04b32946a260bcd3ff52-19392   \n4    0x66bf36dba79d4606039f04b32946a260bcd3ff52-19391   \n..                                                ...   \n25   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19370   \n26   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19369   \n27   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19368   \n28   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19367   \n29   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19366   \n\n    pairPerDays_feeToProtocolRate  pairPerDays_exchangeRate  \\\n0                               0           378598625391174   \n1                               0           378598625391174   \n2                               0           377009678318845   \n3                               0           373230132881322   \n4                               0           371484059105352   \n..                            ...                       ...   \n25                              0           394257586229087   \n26                              0           392522297654423   \n27                              0           390202832135753   \n28                              0           392549279161835   \n29                              0           398563953162388   \n\n   pairPerDays_totalAssetAmount pairPerDays_totalAssetShare  \\\n0     5280086202144364598060510   5221735875627766849451543   \n1     5280086202144364598060510   5221735875627766849451543   \n2     5269555437061868527795234   5211842226076869117736100   \n3     5484118901795781114380335   5424893382984559197436993   \n4     5483306551383955793169109   5424893382984559197436993   \n..                          ...                         ...   \n25    3769506009128316844732055   3743636880569887635903017   \n26    3768783056742577989066325   3743636880569887635903017   \n27    3772097247799298824461855   3747645767185548934357620   \n28    3763951968475928984418921   3740260829919593185891851   \n29    3763275624939759435458855   3740260829919593185891851   \n\n   pairPerDays_totalCollateral pairPerDays_totalBorrowAmount  \\\n0       2871749508706389979756     3817405194006035456842015   \n1       2871749508706389979756     3817405194006035456842015   \n2       2928761288899701373219     3891258997768849163757994   \n3       2871396249000222713940     3815424164193771798690190   \n4       2871396249000222713940     3814611813781946477478964   \n..                         ...                           ...   \n25      2598487227279649783181     2985506330988914905569928   \n26      3098351600700038412837     3047439598934799283226564   \n27      3072025670023382939663     3041758705583430613336022   \n28      2889041491557320289663     2949221122676609777648004   \n29      2889041491557320289663     2948753779167067414396685   \n\n   pairPerDays_totalBorrowShare  pairPerDays_interestPerSecond  \\\n0     3764682156881214069264682                     2552048824   \n1     3764682156881214069264682                     2552048824   \n2     3838045654801718108307370                     2604183369   \n3     3764064557625067245333646                     2466440955   \n4     3764064557625067245333646                     2472561394   \n..                          ...                            ...   \n25    2960472394661636465849282                     2681766198   \n26    3022601695336403755677749                     2734593747   \n27    3017680522664336424194896                     2727552198   \n28    2926563029840310325579647                     2654701724   \n29    2926770444351808876827306                     2654765449   \n\n    pairPerDays_utilization  ...              pairPerDays_pair_collateral_id  \\\n0                     72298  ...  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n1                     72298  ...  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n2                     73844  ...  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n3                     69572  ...  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n4                     69567  ...  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n..                      ...  ...                                         ...   \n25                    79201  ...  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n26                    80860  ...  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n27                    80638  ...  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n28                    78354  ...  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n29                    78356  ...  0x0ab87046fbb341d058f17cbc4c1133f25a20a52f   \n\n     pairPerDays_pair_oracleMultiplyAddress_id  \\\n0   0x0000000000000000000000000000000000000000   \n1   0x0000000000000000000000000000000000000000   \n2   0x0000000000000000000000000000000000000000   \n3   0x0000000000000000000000000000000000000000   \n4   0x0000000000000000000000000000000000000000   \n..                                         ...   \n25  0x0000000000000000000000000000000000000000   \n26  0x0000000000000000000000000000000000000000   \n27  0x0000000000000000000000000000000000000000   \n28  0x0000000000000000000000000000000000000000   \n29  0x0000000000000000000000000000000000000000   \n\n       pairPerDays_pair_oracleDivideAddress_id  \\\n0   0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n1   0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n2   0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n3   0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n4   0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n..                                         ...   \n25  0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n26  0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n27  0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n28  0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n29  0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n\n              pairPerDays_pair_rateContract_id  pairPerDays_pair_maxLTV  \\\n0   0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n1   0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n2   0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n3   0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n4   0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n..                                         ...                      ...   \n25  0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n26  0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n27  0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n28  0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n29  0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n\n   pairPerDays_pair_liquidationFee pairPerDays_pair_maturity  \\\n0                            10000                         0   \n1                            10000                         0   \n2                            10000                         0   \n3                            10000                         0   \n4                            10000                         0   \n..                             ...                       ...   \n25                           10000                         0   \n26                           10000                         0   \n27                           10000                         0   \n28                           10000                         0   \n29                           10000                         0   \n\n   pairPerDays_pair_pauseStatus pairPerDays_pair_lenderWhitelistActive  \\\n0                         False                                  False   \n1                         False                                  False   \n2                         False                                  False   \n3                         False                                  False   \n4                         False                                  False   \n..                          ...                                    ...   \n25                        False                                  False   \n26                        False                                  False   \n27                        False                                  False   \n28                        False                                  False   \n29                        False                                  False   \n\n   pairPerDays_pair_borrowerWhitelistActive  \n0                                     False  \n1                                     False  \n2                                     False  \n3                                     False  \n4                                     False  \n..                                      ...  \n25                                    False  \n26                                    False  \n27                                    False  \n28                                    False  \n29                                    False  \n\n[100 rows x 33 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>pairPerDays_id</th>\n      <th>pairPerDays_feeToProtocolRate</th>\n      <th>pairPerDays_exchangeRate</th>\n      <th>pairPerDays_totalAssetAmount</th>\n      <th>pairPerDays_totalAssetShare</th>\n      <th>pairPerDays_totalCollateral</th>\n      <th>pairPerDays_totalBorrowAmount</th>\n      <th>pairPerDays_totalBorrowShare</th>\n      <th>pairPerDays_interestPerSecond</th>\n      <th>pairPerDays_utilization</th>\n      <th>...</th>\n      <th>pairPerDays_pair_collateral_id</th>\n      <th>pairPerDays_pair_oracleMultiplyAddress_id</th>\n      <th>pairPerDays_pair_oracleDivideAddress_id</th>\n      <th>pairPerDays_pair_rateContract_id</th>\n      <th>pairPerDays_pair_maxLTV</th>\n      <th>pairPerDays_pair_liquidationFee</th>\n      <th>pairPerDays_pair_maturity</th>\n      <th>pairPerDays_pair_pauseStatus</th>\n      <th>pairPerDays_pair_lenderWhitelistActive</th>\n      <th>pairPerDays_pair_borrowerWhitelistActive</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-Recent</td>\n      <td>0</td>\n      <td>378598625391174</td>\n      <td>5280086202144364598060510</td>\n      <td>5221735875627766849451543</td>\n      <td>2871749508706389979756</td>\n      <td>3817405194006035456842015</td>\n      <td>3764682156881214069264682</td>\n      <td>2552048824</td>\n      <td>72298</td>\n      <td>...</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19394</td>\n      <td>0</td>\n      <td>378598625391174</td>\n      <td>5280086202144364598060510</td>\n      <td>5221735875627766849451543</td>\n      <td>2871749508706389979756</td>\n      <td>3817405194006035456842015</td>\n      <td>3764682156881214069264682</td>\n      <td>2552048824</td>\n      <td>72298</td>\n      <td>...</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19393</td>\n      <td>0</td>\n      <td>377009678318845</td>\n      <td>5269555437061868527795234</td>\n      <td>5211842226076869117736100</td>\n      <td>2928761288899701373219</td>\n      <td>3891258997768849163757994</td>\n      <td>3838045654801718108307370</td>\n      <td>2604183369</td>\n      <td>73844</td>\n      <td>...</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19392</td>\n      <td>0</td>\n      <td>373230132881322</td>\n      <td>5484118901795781114380335</td>\n      <td>5424893382984559197436993</td>\n      <td>2871396249000222713940</td>\n      <td>3815424164193771798690190</td>\n      <td>3764064557625067245333646</td>\n      <td>2466440955</td>\n      <td>69572</td>\n      <td>...</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19391</td>\n      <td>0</td>\n      <td>371484059105352</td>\n      <td>5483306551383955793169109</td>\n      <td>5424893382984559197436993</td>\n      <td>2871396249000222713940</td>\n      <td>3814611813781946477478964</td>\n      <td>3764064557625067245333646</td>\n      <td>2472561394</td>\n      <td>69567</td>\n      <td>...</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19370</td>\n      <td>0</td>\n      <td>394257586229087</td>\n      <td>3769506009128316844732055</td>\n      <td>3743636880569887635903017</td>\n      <td>2598487227279649783181</td>\n      <td>2985506330988914905569928</td>\n      <td>2960472394661636465849282</td>\n      <td>2681766198</td>\n      <td>79201</td>\n      <td>...</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19369</td>\n      <td>0</td>\n      <td>392522297654423</td>\n      <td>3768783056742577989066325</td>\n      <td>3743636880569887635903017</td>\n      <td>3098351600700038412837</td>\n      <td>3047439598934799283226564</td>\n      <td>3022601695336403755677749</td>\n      <td>2734593747</td>\n      <td>80860</td>\n      <td>...</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19368</td>\n      <td>0</td>\n      <td>390202832135753</td>\n      <td>3772097247799298824461855</td>\n      <td>3747645767185548934357620</td>\n      <td>3072025670023382939663</td>\n      <td>3041758705583430613336022</td>\n      <td>3017680522664336424194896</td>\n      <td>2727552198</td>\n      <td>80638</td>\n      <td>...</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>28</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19367</td>\n      <td>0</td>\n      <td>392549279161835</td>\n      <td>3763951968475928984418921</td>\n      <td>3740260829919593185891851</td>\n      <td>2889041491557320289663</td>\n      <td>2949221122676609777648004</td>\n      <td>2926563029840310325579647</td>\n      <td>2654701724</td>\n      <td>78354</td>\n      <td>...</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19366</td>\n      <td>0</td>\n      <td>398563953162388</td>\n      <td>3763275624939759435458855</td>\n      <td>3740260829919593185891851</td>\n      <td>2889041491557320289663</td>\n      <td>2948753779167067414396685</td>\n      <td>2926770444351808876827306</td>\n      <td>2654765449</td>\n      <td>78356</td>\n      <td>...</td>\n      <td>0x0ab87046fbb341d058f17cbc4c1133f25a20a52f</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n    </tr>\n  </tbody>\n</table>\n<p>100 rows × 33 columns</p>\n</div>"
     },
     "execution_count": 154,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pairSnapshotsDb.head(100)"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 161,
   "outputs": [],
   "source": [
    "pairSnapshotsDbTimed= db.query(\"select \"\n",
    "                   \"    * \"\n",
    "                        \" ,to_timestamp(pairPerDays_timestamp) dateTime \"\n",
    "                   \"From pairSnapshotsDb \"\n",
    "                   #\"where lower(liquidityPools_name) like lower('%olympus%') \"\n",
    "                    #    \"or lower(pairs_token1_symbol) like lower('%OHM%')  \"\n",
    "                   #\" limit 100 \"\n",
    "                   ).df()"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 163,
   "outputs": [
    {
     "data": {
      "text/plain": "                                      pairPerDays_id  \\\n0  0x66bf36dba79d4606039f04b32946a260bcd3ff52-Recent   \n1   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19394   \n2   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19393   \n3   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19392   \n4   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19391   \n5   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19390   \n6   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19389   \n7   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19388   \n8   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19387   \n9   0x66bf36dba79d4606039f04b32946a260bcd3ff52-19386   \n\n   pairPerDays_feeToProtocolRate  pairPerDays_exchangeRate  \\\n0                              0           378598625391174   \n1                              0           378598625391174   \n2                              0           377009678318845   \n3                              0           373230132881322   \n4                              0           371484059105352   \n5                              0           379977310487020   \n6                              0           369834307482639   \n7                              0           374594674478781   \n8                              0           376376436751781   \n9                              0           380956501968266   \n\n  pairPerDays_totalAssetAmount pairPerDays_totalAssetShare  \\\n0    5280086202144364598060510   5221735875627766849451543   \n1    5280086202144364598060510   5221735875627766849451543   \n2    5269555437061868527795234   5211842226076869117736100   \n3    5484118901795781114380335   5424893382984559197436993   \n4    5483306551383955793169109   5424893382984559197436993   \n5    4816201802622832766867731   4765762362290230125371079   \n6    4815365157700629955830927   4765762362290230125371079   \n7    4848840947594879136698838   4799711827175470439563071   \n8    5201297211409334638041165   5149544551785194536055311   \n9    4303109010317084252730568   4261663494444799969417854   \n\n  pairPerDays_totalCollateral pairPerDays_totalBorrowAmount  \\\n0      2871749508706389979756     3817405194006035456842015   \n1      2871749508706389979756     3817405194006035456842015   \n2      2928761288899701373219     3891258997768849163757994   \n3      2871396249000222713940     3815424164193771798690190   \n4      2871396249000222713940     3814611813781946477478964   \n5      2871396249000222713940     3803715309440297078075951   \n6      2769643478398845209789     3614217455792091021428730   \n7      2766691373183494736394     3602060346966370328633407   \n8      3349886103121754949579     4227562062539122586681971   \n9      2836262438996680073790     3559871178565761741287239   \n\n  pairPerDays_totalBorrowShare  pairPerDays_interestPerSecond  \\\n0    3764682156881214069264682                     2552048824   \n1    3764682156881214069264682                     2552048824   \n2    3838045654801718108307370                     2604183369   \n3    3764064557625067245333646                     2466440955   \n4    3764064557625067245333646                     2472561394   \n5    3754196288125436912823119                     2787021398   \n6    3567987511864932737642253                     2656476392   \n7    3556798190663145950919979                     2630922564   \n8    4175428908652678180379330                     2863717386   \n9    3517251931244162407710746                     2793501845   \n\n   pairPerDays_utilization  ...   pairPerDays_pair_oracleMultiplyAddress_id  \\\n0                    72298  ...  0x0000000000000000000000000000000000000000   \n1                    72298  ...  0x0000000000000000000000000000000000000000   \n2                    73844  ...  0x0000000000000000000000000000000000000000   \n3                    69572  ...  0x0000000000000000000000000000000000000000   \n4                    69567  ...  0x0000000000000000000000000000000000000000   \n5                    78977  ...  0x0000000000000000000000000000000000000000   \n6                    75055  ...  0x0000000000000000000000000000000000000000   \n7                    74287  ...  0x0000000000000000000000000000000000000000   \n8                    81278  ...  0x0000000000000000000000000000000000000000   \n9                    82727  ...  0x0000000000000000000000000000000000000000   \n\n      pairPerDays_pair_oracleDivideAddress_id  \\\n0  0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n1  0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n2  0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n3  0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n4  0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n5  0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n6  0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n7  0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n8  0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n9  0xe893297a9d4310976424fd0b25f53ac2b6464fe3   \n\n             pairPerDays_pair_rateContract_id  pairPerDays_pair_maxLTV  \\\n0  0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n1  0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n2  0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n3  0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n4  0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n5  0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n6  0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n7  0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n8  0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n9  0x18500cb1f2fe7a40ebda393383a0b8548a31f261                    75000   \n\n   pairPerDays_pair_liquidationFee pairPerDays_pair_maturity  \\\n0                            10000                         0   \n1                            10000                         0   \n2                            10000                         0   \n3                            10000                         0   \n4                            10000                         0   \n5                            10000                         0   \n6                            10000                         0   \n7                            10000                         0   \n8                            10000                         0   \n9                            10000                         0   \n\n  pairPerDays_pair_pauseStatus pairPerDays_pair_lenderWhitelistActive  \\\n0                        False                                  False   \n1                        False                                  False   \n2                        False                                  False   \n3                        False                                  False   \n4                        False                                  False   \n5                        False                                  False   \n6                        False                                  False   \n7                        False                                  False   \n8                        False                                  False   \n9                        False                                  False   \n\n  pairPerDays_pair_borrowerWhitelistActive            dateTime  \n0                                    False 2023-02-06 11:42:11  \n1                                    False 2023-02-06 11:42:11  \n2                                    False 2023-02-05 22:09:23  \n3                                    False 2023-02-03 19:11:35  \n4                                    False 2023-02-03 19:11:35  \n5                                    False 2023-02-02 23:47:35  \n6                                    False 2023-02-01 21:01:35  \n7                                    False 2023-01-31 23:17:47  \n8                                    False 2023-01-30 23:08:59  \n9                                    False 2023-01-29 20:51:59  \n\n[10 rows x 34 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>pairPerDays_id</th>\n      <th>pairPerDays_feeToProtocolRate</th>\n      <th>pairPerDays_exchangeRate</th>\n      <th>pairPerDays_totalAssetAmount</th>\n      <th>pairPerDays_totalAssetShare</th>\n      <th>pairPerDays_totalCollateral</th>\n      <th>pairPerDays_totalBorrowAmount</th>\n      <th>pairPerDays_totalBorrowShare</th>\n      <th>pairPerDays_interestPerSecond</th>\n      <th>pairPerDays_utilization</th>\n      <th>...</th>\n      <th>pairPerDays_pair_oracleMultiplyAddress_id</th>\n      <th>pairPerDays_pair_oracleDivideAddress_id</th>\n      <th>pairPerDays_pair_rateContract_id</th>\n      <th>pairPerDays_pair_maxLTV</th>\n      <th>pairPerDays_pair_liquidationFee</th>\n      <th>pairPerDays_pair_maturity</th>\n      <th>pairPerDays_pair_pauseStatus</th>\n      <th>pairPerDays_pair_lenderWhitelistActive</th>\n      <th>pairPerDays_pair_borrowerWhitelistActive</th>\n      <th>dateTime</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-Recent</td>\n      <td>0</td>\n      <td>378598625391174</td>\n      <td>5280086202144364598060510</td>\n      <td>5221735875627766849451543</td>\n      <td>2871749508706389979756</td>\n      <td>3817405194006035456842015</td>\n      <td>3764682156881214069264682</td>\n      <td>2552048824</td>\n      <td>72298</td>\n      <td>...</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2023-02-06 11:42:11</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19394</td>\n      <td>0</td>\n      <td>378598625391174</td>\n      <td>5280086202144364598060510</td>\n      <td>5221735875627766849451543</td>\n      <td>2871749508706389979756</td>\n      <td>3817405194006035456842015</td>\n      <td>3764682156881214069264682</td>\n      <td>2552048824</td>\n      <td>72298</td>\n      <td>...</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2023-02-06 11:42:11</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19393</td>\n      <td>0</td>\n      <td>377009678318845</td>\n      <td>5269555437061868527795234</td>\n      <td>5211842226076869117736100</td>\n      <td>2928761288899701373219</td>\n      <td>3891258997768849163757994</td>\n      <td>3838045654801718108307370</td>\n      <td>2604183369</td>\n      <td>73844</td>\n      <td>...</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2023-02-05 22:09:23</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19392</td>\n      <td>0</td>\n      <td>373230132881322</td>\n      <td>5484118901795781114380335</td>\n      <td>5424893382984559197436993</td>\n      <td>2871396249000222713940</td>\n      <td>3815424164193771798690190</td>\n      <td>3764064557625067245333646</td>\n      <td>2466440955</td>\n      <td>69572</td>\n      <td>...</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2023-02-03 19:11:35</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19391</td>\n      <td>0</td>\n      <td>371484059105352</td>\n      <td>5483306551383955793169109</td>\n      <td>5424893382984559197436993</td>\n      <td>2871396249000222713940</td>\n      <td>3814611813781946477478964</td>\n      <td>3764064557625067245333646</td>\n      <td>2472561394</td>\n      <td>69567</td>\n      <td>...</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2023-02-03 19:11:35</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19390</td>\n      <td>0</td>\n      <td>379977310487020</td>\n      <td>4816201802622832766867731</td>\n      <td>4765762362290230125371079</td>\n      <td>2871396249000222713940</td>\n      <td>3803715309440297078075951</td>\n      <td>3754196288125436912823119</td>\n      <td>2787021398</td>\n      <td>78977</td>\n      <td>...</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2023-02-02 23:47:35</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19389</td>\n      <td>0</td>\n      <td>369834307482639</td>\n      <td>4815365157700629955830927</td>\n      <td>4765762362290230125371079</td>\n      <td>2769643478398845209789</td>\n      <td>3614217455792091021428730</td>\n      <td>3567987511864932737642253</td>\n      <td>2656476392</td>\n      <td>75055</td>\n      <td>...</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2023-02-01 21:01:35</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19388</td>\n      <td>0</td>\n      <td>374594674478781</td>\n      <td>4848840947594879136698838</td>\n      <td>4799711827175470439563071</td>\n      <td>2766691373183494736394</td>\n      <td>3602060346966370328633407</td>\n      <td>3556798190663145950919979</td>\n      <td>2630922564</td>\n      <td>74287</td>\n      <td>...</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2023-01-31 23:17:47</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19387</td>\n      <td>0</td>\n      <td>376376436751781</td>\n      <td>5201297211409334638041165</td>\n      <td>5149544551785194536055311</td>\n      <td>3349886103121754949579</td>\n      <td>4227562062539122586681971</td>\n      <td>4175428908652678180379330</td>\n      <td>2863717386</td>\n      <td>81278</td>\n      <td>...</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2023-01-30 23:08:59</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>0x66bf36dba79d4606039f04b32946a260bcd3ff52-19386</td>\n      <td>0</td>\n      <td>380956501968266</td>\n      <td>4303109010317084252730568</td>\n      <td>4261663494444799969417854</td>\n      <td>2836262438996680073790</td>\n      <td>3559871178565761741287239</td>\n      <td>3517251931244162407710746</td>\n      <td>2793501845</td>\n      <td>82727</td>\n      <td>...</td>\n      <td>0x0000000000000000000000000000000000000000</td>\n      <td>0xe893297a9d4310976424fd0b25f53ac2b6464fe3</td>\n      <td>0x18500cb1f2fe7a40ebda393383a0b8548a31f261</td>\n      <td>75000</td>\n      <td>10000</td>\n      <td>0</td>\n      <td>False</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2023-01-29 20:51:59</td>\n    </tr>\n  </tbody>\n</table>\n<p>10 rows × 34 columns</p>\n</div>"
     },
     "execution_count": 163,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pairSnapshotsDbTimed.head(10)"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 162,
   "outputs": [],
   "source": [
    "#path =file+'/frax_pairs_daily_snapshot '+str(date.today().strftime(\"%b-%d-%Y\"))+str(pairSnapshotsDbLength)+'records.csv'\n",
    "path =file+'/frax_pairs_daily_snapshot '+str(date.today().strftime(\"%b-%d-%Y\"))+\"_\"+str(pairSnapshotsDbLength)+'records.csv'\n",
    "pairSnapshotsDbTimed.to_csv(path, index = False)"
   ],
   "metadata": {
    "collapsed": false
   }
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "outputs": [],
   "source": [],
   "metadata": {
    "collapsed": false
   }
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}