PREVIEW / stock_5min / 2015-03-27
file: by_date/stock_5min/2015/2015-03-27.parquet size: 5.3 MB rows: 352,722 symbols: 3,476
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 |
|---|---|---|---|---|---|---|---|
| 2015-03-27 04:00:00 | AAPL | Stock | 31.0875 | 31.125 | 31.0875 | 31.125 | 2400.0 |
| 2015-03-27 04:05:00 | AAPL | Stock | 31.1375 | 31.1475 | 31.1375 | 31.1475 | 1600.0 |
| 2015-03-27 04:10:00 | AAPL | Stock | 31.2 | 31.2 | 31.2 | 31.2 | 5600.0 |
| 2015-03-27 04:15:00 | AAPL | Stock | 31.1475 | 31.1475 | 31.1475 | 31.1475 | 2000.0 |
| 2015-03-27 04:40:00 | AAPL | Stock | 31.175 | 31.175 | 31.175 | 31.175 | 2000.0 |
| 2015-03-27 04:45:00 | AAPL | Stock | 31.1975 | 31.1975 | 31.1975 | 31.1975 | 400.0 |
| 2015-03-27 04:55:00 | AAPL | Stock | 31.1375 | 31.1375 | 31.1025 | 31.1025 | 2000.0 |
| 2015-03-27 05:15:00 | AAPL | Stock | 31.15 | 31.15 | 31.15 | 31.15 | 400.0 |
| 2015-03-27 05:25:00 | AAPL | Stock | 31.1025 | 31.1025 | 31.0875 | 31.0875 | 13316.0 |
| 2015-03-27 05:30:00 | AAPL | Stock | 31.1 | 31.1025 | 31.1 | 31.1 | 1700.0 |
| 2015-03-27 05:35:00 | AAPL | Stock | 31.1 | 31.1 | 31.1 | 31.1 | 2000.0 |
| 2015-03-27 05:40:00 | AAPL | Stock | 31.145 | 31.165 | 31.145 | 31.165 | 8400.0 |
| 2015-03-27 05:45:00 | AAPL | Stock | 31.1625 | 31.1625 | 31.1625 | 31.1625 | 19200.0 |
| 2015-03-27 05:50:00 | AAPL | Stock | 31.1375 | 31.1375 | 31.1 | 31.1 | 2400.0 |
| 2015-03-27 05:55:00 | AAPL | Stock | 31.1 | 31.1 | 31.1 | 31.1 | 2000.0 |
| 2015-03-27 06:00:00 | AAPL | Stock | 31.1 | 31.1 | 31.1 | 31.1 | 1640.0 |
| 2015-03-27 06:05:00 | AAPL | Stock | 31.14 | 31.14 | 31.14 | 31.14 | 400.0 |
| 2015-03-27 06:10:00 | AAPL | Stock | 31.1175 | 31.1175 | 31.1175 | 31.1175 | 3068.0 |
| 2015-03-27 06:15:00 | AAPL | Stock | 31.14 | 31.14 | 31.14 | 31.14 | 2000.0 |
| 2015-03-27 06:20:00 | AAPL | Stock | 31.1125 | 31.125 | 31.1025 | 31.1025 | 15400.0 |
| 2015-03-27 06:25:00 | AAPL | Stock | 31.1025 | 31.1125 | 31.1 | 31.1125 | 11616.0 |
| 2015-03-27 06:40:00 | AAPL | Stock | 31.145 | 31.145 | 31.1 | 31.1025 | 4784.0 |
| 2015-03-27 06:45:00 | AAPL | Stock | 31.135 | 31.1375 | 31.135 | 31.1375 | 800.0 |
| 2015-03-27 06:50:00 | AAPL | Stock | 31.115 | 31.115 | 31.115 | 31.115 | 400.0 |
| 2015-03-27 06:55:00 | AAPL | Stock | 31.125 | 31.14 | 31.125 | 31.125 | 2532.0 |
| 2015-03-27 07:00:00 | AAPL | Stock | 31.125 | 31.14 | 31.125 | 31.14 | 800.0 |
| 2015-03-27 07:05:00 | AAPL | Stock | 31.14 | 31.14 | 31.14 | 31.14 | 3988.0 |
| 2015-03-27 07:10:00 | AAPL | Stock | 31.1575 | 31.165 | 31.1575 | 31.1625 | 7200.0 |
| 2015-03-27 07:20:00 | AAPL | Stock | 31.1575 | 31.1575 | 31.1325 | 31.1325 | 3360.0 |
| 2015-03-27 07:25:00 | AAPL | Stock | 31.135 | 31.135 | 31.1175 | 31.1175 | 19360.0 |
| 2015-03-27 07:30:00 | AAPL | Stock | 31.1225 | 31.145 | 31.1225 | 31.145 | 3440.0 |
| 2015-03-27 07:35:00 | AAPL | Stock | 31.125 | 31.125 | 31.125 | 31.125 | 2000.0 |
| 2015-03-27 07:40:00 | AAPL | Stock | 31.1425 | 31.1425 | 31.1425 | 31.1425 | 4000.0 |
| 2015-03-27 07:45:00 | AAPL | Stock | 31.1425 | 31.145 | 31.1425 | 31.145 | 1360.0 |
| 2015-03-27 07:50:00 | AAPL | Stock | 31.145 | 31.145 | 31.145 | 31.145 | 2400.0 |
| 2015-03-27 07:55:00 | AAPL | Stock | 31.1575 | 31.1575 | 31.145 | 31.145 | 4400.0 |
| 2015-03-27 08:00:00 | AAPL | Stock | 31.145 | 31.165 | 31.105 | 31.1225 | 98084.0 |
| 2015-03-27 08:05:00 | AAPL | Stock | 31.1225 | 31.1375 | 31.1225 | 31.1375 | 31492.0 |
| 2015-03-27 08:10:00 | AAPL | Stock | 31.135 | 31.1425 | 31.135 | 31.1422 | 29448.0 |
| 2015-03-27 08:15:00 | AAPL | Stock | 31.1425 | 31.1525 | 31.1375 | 31.15 | 34320.0 |
| 2015-03-27 08:20:00 | AAPL | Stock | 31.145 | 31.145 | 31.1325 | 31.1325 | 37976.0 |
| 2015-03-27 08:25:00 | AAPL | Stock | 31.14 | 31.1575 | 31.14 | 31.1525 | 32796.0 |
| 2015-03-27 08:30:00 | AAPL | Stock | 31.1575 | 31.16 | 31.145 | 31.1525 | 41120.0 |
| 2015-03-27 08:35:00 | AAPL | Stock | 31.1525 | 31.1525 | 31.1025 | 31.115 | 74372.0 |
| 2015-03-27 08:40:00 | AAPL | Stock | 31.1175 | 31.12 | 31.105 | 31.1125 | 23472.0 |
| 2015-03-27 08:45:00 | AAPL | Stock | 31.1125 | 31.14 | 31.1125 | 31.14 | 13800.0 |
| 2015-03-27 08:50:00 | AAPL | Stock | 31.135 | 31.1425 | 31.13 | 31.13 | 13588.0 |
| 2015-03-27 08:55:00 | AAPL | Stock | 31.1375 | 31.1398 | 31.13 | 31.13 | 2200.0 |
| 2015-03-27 09:00:00 | AAPL | Stock | 31.1275 | 31.1275 | 31.1025 | 31.1025 | 50880.0 |
| 2015-03-27 09:05:00 | AAPL | Stock | 31.1025 | 31.1125 | 31.1 | 31.1 | 5400.0 |
> showing 50 of 352,722 rows — these rows as CSV