PREVIEW / stock_5min / 2016-01-13
file: by_date/stock_5min/2016/2016-01-13.parquet size: 5.7 MB rows: 374,756 symbols: 3,397
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 |
|---|---|---|---|---|---|---|---|
| 2016-01-13 04:00:00 | AAPL | Stock | 25.2375 | 25.25 | 25.2375 | 25.25 | 5840.0 |
| 2016-01-13 04:05:00 | AAPL | Stock | 25.225 | 25.24 | 25.225 | 25.24 | 1600.0 |
| 2016-01-13 04:20:00 | AAPL | Stock | 25.24 | 25.24 | 25.2225 | 25.2225 | 1040.0 |
| 2016-01-13 04:25:00 | AAPL | Stock | 25.225 | 25.225 | 25.225 | 25.225 | 728.0 |
| 2016-01-13 04:30:00 | AAPL | Stock | 25.2025 | 25.2475 | 25.2 | 25.24 | 6632.0 |
| 2016-01-13 04:35:00 | AAPL | Stock | 25.2325 | 25.2325 | 25.2 | 25.2 | 4828.0 |
| 2016-01-13 04:40:00 | AAPL | Stock | 25.2225 | 25.225 | 25.2225 | 25.225 | 3152.0 |
| 2016-01-13 04:45:00 | AAPL | Stock | 25.18 | 25.21 | 25.18 | 25.21 | 1708.0 |
| 2016-01-13 04:50:00 | AAPL | Stock | 25.1925 | 25.2125 | 25.19 | 25.2125 | 4000.0 |
| 2016-01-13 04:55:00 | AAPL | Stock | 25.19 | 25.19 | 25.19 | 25.19 | 1500.0 |
| 2016-01-13 05:10:00 | AAPL | Stock | 25.2125 | 25.2175 | 25.2125 | 25.2175 | 3740.0 |
| 2016-01-13 05:20:00 | AAPL | Stock | 25.14 | 25.14 | 25.135 | 25.135 | 2400.0 |
| 2016-01-13 05:25:00 | AAPL | Stock | 25.185 | 25.1925 | 25.165 | 25.165 | 2400.0 |
| 2016-01-13 05:50:00 | AAPL | Stock | 25.175 | 25.22 | 25.175 | 25.22 | 29560.0 |
| 2016-01-13 05:55:00 | AAPL | Stock | 25.1875 | 25.1875 | 25.1875 | 25.1875 | 400.0 |
| 2016-01-13 06:00:00 | AAPL | Stock | 25.1925 | 25.225 | 25.1525 | 25.1625 | 49140.0 |
| 2016-01-13 06:05:00 | AAPL | Stock | 25.1575 | 25.175 | 25.1575 | 25.175 | 2692.0 |
| 2016-01-13 06:10:00 | AAPL | Stock | 25.175 | 25.175 | 25.165 | 25.1725 | 3156.0 |
| 2016-01-13 06:15:00 | AAPL | Stock | 25.185 | 25.1875 | 25.185 | 25.1875 | 5200.0 |
| 2016-01-13 06:20:00 | AAPL | Stock | 25.1725 | 25.1725 | 25.1725 | 25.1725 | 428.0 |
| 2016-01-13 06:25:00 | AAPL | Stock | 25.1725 | 25.1725 | 25.1725 | 25.1725 | 1120.0 |
| 2016-01-13 06:30:00 | AAPL | Stock | 25.15 | 25.15 | 25.1 | 25.1 | 22200.0 |
| 2016-01-13 06:35:00 | AAPL | Stock | 25.1125 | 25.1125 | 25.11 | 25.1125 | 4180.0 |
| 2016-01-13 06:40:00 | AAPL | Stock | 25.135 | 25.135 | 25.135 | 25.135 | 1000.0 |
| 2016-01-13 06:50:00 | AAPL | Stock | 25.1325 | 25.1325 | 25.1325 | 25.1325 | 400.0 |
| 2016-01-13 06:55:00 | AAPL | Stock | 25.135 | 25.135 | 25.1225 | 25.1225 | 800.0 |
| 2016-01-13 07:00:00 | AAPL | Stock | 25.135 | 25.135 | 25.135 | 25.135 | 1200.0 |
| 2016-01-13 07:05:00 | AAPL | Stock | 25.16 | 25.16 | 25.1525 | 25.1525 | 800.0 |
| 2016-01-13 07:10:00 | AAPL | Stock | 25.165 | 25.1725 | 25.1375 | 25.1375 | 23440.0 |
| 2016-01-13 07:15:00 | AAPL | Stock | 25.1575 | 25.1575 | 25.1575 | 25.1575 | 400.0 |
| 2016-01-13 07:20:00 | AAPL | Stock | 25.1375 | 25.1525 | 25.0875 | 25.1225 | 8636.0 |
| 2016-01-13 07:25:00 | AAPL | Stock | 25.1475 | 25.1625 | 25.1375 | 25.1625 | 24668.0 |
| 2016-01-13 07:30:00 | AAPL | Stock | 25.1625 | 25.1625 | 25.16 | 25.1625 | 12000.0 |
| 2016-01-13 07:35:00 | AAPL | Stock | 25.16 | 25.16 | 25.1375 | 25.1475 | 20012.0 |
| 2016-01-13 07:40:00 | AAPL | Stock | 25.13 | 25.135 | 25.105 | 25.1175 | 6880.0 |
| 2016-01-13 07:45:00 | AAPL | Stock | 25.1125 | 25.135 | 25.1125 | 25.125 | 9700.0 |
| 2016-01-13 07:50:00 | AAPL | Stock | 25.1275 | 25.14 | 25.12 | 25.12 | 17160.0 |
| 2016-01-13 07:55:00 | AAPL | Stock | 25.12 | 25.12 | 25.1 | 25.1 | 10800.0 |
| 2016-01-13 08:00:00 | AAPL | Stock | 25.1 | 25.205 | 25.0775 | 25.085 | 72416.0 |
| 2016-01-13 08:05:00 | AAPL | Stock | 25.1 | 25.105 | 25.075 | 25.1025 | 83544.0 |
| 2016-01-13 08:10:00 | AAPL | Stock | 25.11 | 25.12 | 25.0925 | 25.12 | 32800.0 |
| 2016-01-13 08:15:00 | AAPL | Stock | 25.125 | 25.1275 | 25.1125 | 25.12 | 33964.0 |
| 2016-01-13 08:20:00 | AAPL | Stock | 25.1075 | 25.1325 | 25.1075 | 25.13 | 30264.0 |
| 2016-01-13 08:25:00 | AAPL | Stock | 25.125 | 25.1375 | 25.125 | 25.1275 | 30464.0 |
| 2016-01-13 08:30:00 | AAPL | Stock | 25.135 | 25.155 | 25.135 | 25.15 | 41900.0 |
| 2016-01-13 08:35:00 | AAPL | Stock | 25.145 | 25.1675 | 25.145 | 25.1675 | 47740.0 |
| 2016-01-13 08:40:00 | AAPL | Stock | 25.1675 | 25.1675 | 25.13 | 25.14 | 28728.0 |
| 2016-01-13 08:45:00 | AAPL | Stock | 25.14 | 25.155 | 25.14 | 25.15 | 25000.0 |
| 2016-01-13 08:50:00 | AAPL | Stock | 25.1425 | 25.16 | 25.115 | 25.115 | 39780.0 |
| 2016-01-13 08:55:00 | AAPL | Stock | 25.115 | 25.115 | 25.0725 | 25.085 | 83876.0 |
> showing 50 of 374,756 rows — these rows as CSV