PREVIEW / stock_5min / 2017-02-22
file: by_date/stock_5min/2017/2017-02-22.parquet size: 5.5 MB rows: 356,836 symbols: 3,113
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2017-02-22 04:00:00 | AAPL | Stock | 34.1625 | 34.1625 | 34.1625 | 34.1625 | 1600.0 |
| 2017-02-22 04:30:00 | AAPL | Stock | 34.1375 | 34.1375 | 34.1375 | 34.1375 | 984.0 |
| 2017-02-22 04:40:00 | AAPL | Stock | 34.1375 | 34.1375 | 34.1375 | 34.1375 | 2400.0 |
| 2017-02-22 05:05:00 | AAPL | Stock | 34.1275 | 34.1275 | 34.1275 | 34.1275 | 556.0 |
| 2017-02-22 05:20:00 | AAPL | Stock | 34.1475 | 34.1475 | 34.1475 | 34.1475 | 400.0 |
| 2017-02-22 05:25:00 | AAPL | Stock | 34.1275 | 34.1275 | 34.1275 | 34.1275 | 1444.0 |
| 2017-02-22 05:30:00 | AAPL | Stock | 34.12 | 34.12 | 34.12 | 34.12 | 968.0 |
| 2017-02-22 05:35:00 | AAPL | Stock | 34.11 | 34.11 | 34.1075 | 34.1075 | 1184.0 |
| 2017-02-22 06:05:00 | AAPL | Stock | 34.135 | 34.145 | 34.1225 | 34.145 | 2060.0 |
| 2017-02-22 06:25:00 | AAPL | Stock | 34.095 | 34.095 | 34.095 | 34.095 | 732.0 |
| 2017-02-22 06:30:00 | AAPL | Stock | 34.0875 | 34.0875 | 34.0825 | 34.0825 | 2360.0 |
| 2017-02-22 06:35:00 | AAPL | Stock | 34.0825 | 34.0825 | 34.0825 | 34.0825 | 428.0 |
| 2017-02-22 06:40:00 | AAPL | Stock | 34.0825 | 34.0825 | 34.0825 | 34.0825 | 400.0 |
| 2017-02-22 06:45:00 | AAPL | Stock | 34.0975 | 34.0975 | 34.0925 | 34.0925 | 4000.0 |
| 2017-02-22 06:50:00 | AAPL | Stock | 34.0925 | 34.0925 | 34.0825 | 34.0925 | 4348.0 |
| 2017-02-22 06:55:00 | AAPL | Stock | 34.0825 | 34.0825 | 34.0825 | 34.0825 | 5480.0 |
| 2017-02-22 07:00:00 | AAPL | Stock | 34.0925 | 34.0925 | 34.0825 | 34.0825 | 15836.0 |
| 2017-02-22 07:05:00 | AAPL | Stock | 34.075 | 34.075 | 34.075 | 34.075 | 4000.0 |
| 2017-02-22 07:15:00 | AAPL | Stock | 34.075 | 34.075 | 34.075 | 34.075 | 4104.0 |
| 2017-02-22 07:25:00 | AAPL | Stock | 34.075 | 34.1 | 34.075 | 34.1 | 15112.0 |
| 2017-02-22 07:30:00 | AAPL | Stock | 34.1 | 34.1 | 34.1 | 34.1 | 400.0 |
| 2017-02-22 07:35:00 | AAPL | Stock | 34.0875 | 34.0875 | 34.0875 | 34.0875 | 3280.0 |
| 2017-02-22 07:40:00 | AAPL | Stock | 34.0975 | 34.0975 | 34.0975 | 34.0975 | 1400.0 |
| 2017-02-22 07:50:00 | AAPL | Stock | 34.11 | 34.1125 | 34.1075 | 34.11 | 5560.0 |
| 2017-02-22 07:55:00 | AAPL | Stock | 34.11 | 34.11 | 34.085 | 34.0975 | 9320.0 |
| 2017-02-22 08:00:00 | AAPL | Stock | 34.1075 | 34.1225 | 34.075 | 34.1225 | 34200.0 |
| 2017-02-22 08:05:00 | AAPL | Stock | 34.1225 | 34.1275 | 34.1175 | 34.125 | 12600.0 |
| 2017-02-22 08:10:00 | AAPL | Stock | 34.125 | 34.135 | 34.115 | 34.115 | 2800.0 |
| 2017-02-22 08:15:00 | AAPL | Stock | 34.1325 | 34.1325 | 34.1225 | 34.125 | 3600.0 |
| 2017-02-22 08:20:00 | AAPL | Stock | 34.1175 | 34.1325 | 34.1175 | 34.1325 | 9052.0 |
| 2017-02-22 08:25:00 | AAPL | Stock | 34.12 | 34.12 | 34.11 | 34.11 | 3200.0 |
| 2017-02-22 08:30:00 | AAPL | Stock | 34.1125 | 34.1125 | 34.1125 | 34.1125 | 3060.0 |
| 2017-02-22 08:35:00 | AAPL | Stock | 34.1225 | 34.1225 | 34.1075 | 34.12 | 26164.0 |
| 2017-02-22 08:40:00 | AAPL | Stock | 34.1225 | 34.1275 | 34.1225 | 34.125 | 17820.0 |
| 2017-02-22 08:45:00 | AAPL | Stock | 34.1275 | 34.1275 | 34.1125 | 34.1125 | 1200.0 |
| 2017-02-22 08:50:00 | AAPL | Stock | 34.12 | 34.12 | 34.1025 | 34.1025 | 13376.0 |
| 2017-02-22 08:55:00 | AAPL | Stock | 34.11 | 34.11 | 34.11 | 34.11 | 800.0 |
| 2017-02-22 09:00:00 | AAPL | Stock | 34.11 | 34.11 | 34.1025 | 34.1025 | 2932.0 |
| 2017-02-22 09:05:00 | AAPL | Stock | 34.1125 | 34.1125 | 34.1 | 34.1 | 4980.0 |
| 2017-02-22 09:10:00 | AAPL | Stock | 34.1 | 34.1125 | 34.0925 | 34.0925 | 30972.0 |
| 2017-02-22 09:15:00 | AAPL | Stock | 34.1 | 34.1125 | 34.1 | 34.1125 | 4268.0 |
| 2017-02-22 09:20:00 | AAPL | Stock | 34.125 | 34.125 | 34.1025 | 34.1025 | 9660.0 |
| 2017-02-22 09:25:00 | AAPL | Stock | 34.105 | 34.135 | 34.1 | 34.1025 | 94780.0 |
| 2017-02-22 09:30:00 | AAPL | Stock | 34.115 | 34.15 | 34.075 | 34.11 | 4042080.0 |
| 2017-02-22 09:35:00 | AAPL | Stock | 34.1075 | 34.1375 | 34.0812 | 34.0975 | 2008548.0 |
| 2017-02-22 09:40:00 | AAPL | Stock | 34.0875 | 34.09 | 34.0275 | 34.0462 | 2344252.0 |
| 2017-02-22 09:45:00 | AAPL | Stock | 34.045 | 34.085 | 34.04 | 34.0588 | 1310788.0 |
| 2017-02-22 09:50:00 | AAPL | Stock | 34.0575 | 34.0775 | 34.0375 | 34.0492 | 1187464.0 |
| 2017-02-22 09:55:00 | AAPL | Stock | 34.0475 | 34.095 | 34.045 | 34.087 | 772644.0 |
| 2017-02-22 10:00:00 | AAPL | Stock | 34.0875 | 34.1128 | 34.0825 | 34.1 | 1027344.0 |
> showing 50 of 356,836 rows — these rows as CSV