Aula_7.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "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>DATE</th>\n",
       "      <th>CURRENCY</th>\n",
       "      <th>px_last</th>\n",
       "      <th>px_open</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>FB US Equity</th>\n",
       "      <td>2020-08-17</td>\n",
       "      <td>USD</td>\n",
       "      <td>261.220001</td>\n",
       "      <td>262.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IBM US Equity</th>\n",
       "      <td>2020-08-17</td>\n",
       "      <td>USD</td>\n",
       "      <td>124.690002</td>\n",
       "      <td>125.25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    DATE CURRENCY     px_last  px_open\n",
       "ID                                                    \n",
       "FB US Equity  2020-08-17      USD  261.220001   262.50\n",
       "IBM US Equity 2020-08-17      USD  124.690002   125.25"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import bql\n",
    "bq = bql.Service()\n",
    "request = \"get(px_last, px_open)for(['FB US Equity', 'IBM US Equity'])\"\n",
    "response = bq.execute(request)\n",
    "df = bql.combined_df(response) # Joining PX_Last and PX_Open\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Accessing individual dataframes:\n",
    "df_0 = response[0].df()\n",
    "df_1 = response[1].df()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "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>DATE</th>\n",
       "      <th>CURRENCY</th>\n",
       "      <th>px_last</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>FB US Equity</th>\n",
       "      <td>2020-08-17</td>\n",
       "      <td>USD</td>\n",
       "      <td>261.220001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IBM US Equity</th>\n",
       "      <td>2020-08-17</td>\n",
       "      <td>USD</td>\n",
       "      <td>124.690002</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    DATE CURRENCY     px_last\n",
       "ID                                           \n",
       "FB US Equity  2020-08-17      USD  261.220001\n",
       "IBM US Equity 2020-08-17      USD  124.690002"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# PX_LAST:\n",
    "df_0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "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>DATE</th>\n",
       "      <th>CURRENCY</th>\n",
       "      <th>px_open</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>FB US Equity</th>\n",
       "      <td>2020-08-17</td>\n",
       "      <td>USD</td>\n",
       "      <td>262.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IBM US Equity</th>\n",
       "      <td>2020-08-17</td>\n",
       "      <td>USD</td>\n",
       "      <td>125.25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    DATE CURRENCY  px_open\n",
       "ID                                        \n",
       "FB US Equity  2020-08-17      USD   262.50\n",
       "IBM US Equity 2020-08-17      USD   125.25"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# PX_OPEN:\n",
    "df_1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "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>DATE</th>\n",
       "      <th>CURRENCY</th>\n",
       "      <th>PX_OPEN(dates=RANGE(-2D,0D))</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>UBER US Equity</th>\n",
       "      <td>2020-08-15</td>\n",
       "      <td>USD</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UBER US Equity</th>\n",
       "      <td>2020-08-16</td>\n",
       "      <td>USD</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>UBER US Equity</th>\n",
       "      <td>2020-08-17</td>\n",
       "      <td>USD</td>\n",
       "      <td>30.049999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LYFT US Equity</th>\n",
       "      <td>2020-08-15</td>\n",
       "      <td>USD</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LYFT US Equity</th>\n",
       "      <td>2020-08-16</td>\n",
       "      <td>USD</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LYFT US Equity</th>\n",
       "      <td>2020-08-17</td>\n",
       "      <td>USD</td>\n",
       "      <td>28.358999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NFLX US Equity</th>\n",
       "      <td>2020-08-15</td>\n",
       "      <td>USD</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NFLX US Equity</th>\n",
       "      <td>2020-08-16</td>\n",
       "      <td>USD</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NFLX US Equity</th>\n",
       "      <td>2020-08-17</td>\n",
       "      <td>USD</td>\n",
       "      <td>484.190002</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     DATE CURRENCY  PX_OPEN(dates=RANGE(-2D,0D))\n",
       "ID                                                              \n",
       "UBER US Equity 2020-08-15      USD                           NaN\n",
       "UBER US Equity 2020-08-16      USD                           NaN\n",
       "UBER US Equity 2020-08-17      USD                     30.049999\n",
       "LYFT US Equity 2020-08-15      USD                           NaN\n",
       "LYFT US Equity 2020-08-16      USD                           NaN\n",
       "LYFT US Equity 2020-08-17      USD                     28.358999\n",
       "NFLX US Equity 2020-08-15      USD                           NaN\n",
       "NFLX US Equity 2020-08-16      USD                           NaN\n",
       "NFLX US Equity 2020-08-17      USD                    484.190002"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Exercise:\n",
    "bql_item1 = bq.data.px_last(dates='today')\n",
    "bql_item2 = bq.data.px_open(dates=bq.func.range('-2D', '0D'))\n",
    "bql_item3 = bq.data.px_high(dates='2020-01-02')\n",
    "bql_items = [bql_item1, bql_item2, bql_item3]\n",
    "\n",
    "bql_universe = ['UBER US Equity', 'LYFT US Equity', 'NFLX US Equity']\n",
    "\n",
    "bql_request = bql.Request(bql_universe, bql_items)\n",
    "bql_response = bq.execute(bql_request)\n",
    "df = bql_response[1].df()\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (sandboxed)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}