PREVIEW / stock_5min / 2019-02-14
file: by_date/stock_5min/2019/2019-02-14.parquet size: 5.6 MB rows: 354,311 symbols: 2,647
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-14 04:00:00 | AAPL | Stock | 42.6525 | 42.695 | 42.6475 | 42.6925 | 9956.0 |
| 2019-02-14 04:05:00 | AAPL | Stock | 42.6925 | 42.6925 | 42.6925 | 42.6925 | 800.0 |
| 2019-02-14 04:10:00 | AAPL | Stock | 42.7225 | 42.7225 | 42.7225 | 42.7225 | 400.0 |
| 2019-02-14 04:15:00 | AAPL | Stock | 42.72 | 42.72 | 42.6625 | 42.6625 | 4132.0 |
| 2019-02-14 04:20:00 | AAPL | Stock | 42.695 | 42.695 | 42.695 | 42.695 | 400.0 |
| 2019-02-14 04:30:00 | AAPL | Stock | 42.6775 | 42.6775 | 42.6775 | 42.6775 | 400.0 |
| 2019-02-14 04:50:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 400.0 |
| 2019-02-14 05:40:00 | AAPL | Stock | 42.6425 | 42.6425 | 42.6425 | 42.6425 | 400.0 |
| 2019-02-14 05:50:00 | AAPL | Stock | 42.64 | 42.64 | 42.64 | 42.64 | 1996.0 |
| 2019-02-14 06:20:00 | AAPL | Stock | 42.6575 | 42.6625 | 42.625 | 42.625 | 2800.0 |
| 2019-02-14 06:25:00 | AAPL | Stock | 42.6725 | 42.675 | 42.6725 | 42.675 | 11600.0 |
| 2019-02-14 07:00:00 | AAPL | Stock | 42.6275 | 42.65 | 42.6275 | 42.63 | 9404.0 |
| 2019-02-14 07:05:00 | AAPL | Stock | 42.63 | 42.63 | 42.63 | 42.63 | 400.0 |
| 2019-02-14 07:10:00 | AAPL | Stock | 42.625 | 42.6375 | 42.625 | 42.6375 | 6200.0 |
| 2019-02-14 07:20:00 | AAPL | Stock | 42.655 | 42.67 | 42.655 | 42.67 | 7480.0 |
| 2019-02-14 07:25:00 | AAPL | Stock | 42.66 | 42.66 | 42.66 | 42.66 | 1200.0 |
| 2019-02-14 07:30:00 | AAPL | Stock | 42.655 | 42.66 | 42.655 | 42.66 | 1356.0 |
| 2019-02-14 07:35:00 | AAPL | Stock | 42.6425 | 42.6425 | 42.63 | 42.63 | 6004.0 |
| 2019-02-14 07:40:00 | AAPL | Stock | 42.635 | 42.65 | 42.605 | 42.625 | 22740.0 |
| 2019-02-14 07:45:00 | AAPL | Stock | 42.615 | 42.615 | 42.615 | 42.615 | 1944.0 |
| 2019-02-14 07:50:00 | AAPL | Stock | 42.615 | 42.62 | 42.615 | 42.62 | 1996.0 |
| 2019-02-14 07:55:00 | AAPL | Stock | 42.605 | 42.605 | 42.605 | 42.605 | 400.0 |
| 2019-02-14 08:00:00 | AAPL | Stock | 42.6375 | 42.6475 | 42.6 | 42.625 | 20680.0 |
| 2019-02-14 08:05:00 | AAPL | Stock | 42.6575 | 42.6575 | 42.6125 | 42.645 | 2400.0 |
| 2019-02-14 08:10:00 | AAPL | Stock | 42.645 | 42.645 | 42.63 | 42.63 | 1600.0 |
| 2019-02-14 08:15:00 | AAPL | Stock | 42.6375 | 42.6375 | 42.6375 | 42.6375 | 2000.0 |
| 2019-02-14 08:20:00 | AAPL | Stock | 42.65 | 42.65 | 42.6125 | 42.6125 | 17496.0 |
| 2019-02-14 08:25:00 | AAPL | Stock | 42.615 | 42.645 | 42.615 | 42.635 | 4556.0 |
| 2019-02-14 08:30:00 | AAPL | Stock | 42.6375 | 42.6375 | 42.5875 | 42.5875 | 15004.0 |
| 2019-02-14 08:35:00 | AAPL | Stock | 42.6025 | 42.6025 | 42.515 | 42.5175 | 25344.0 |
| 2019-02-14 08:40:00 | AAPL | Stock | 42.5275 | 42.545 | 42.4025 | 42.47 | 35296.0 |
| 2019-02-14 08:45:00 | AAPL | Stock | 42.4528 | 42.5 | 42.425 | 42.435 | 57500.0 |
| 2019-02-14 08:50:00 | AAPL | Stock | 42.4525 | 42.4725 | 42.4275 | 42.4725 | 9444.0 |
| 2019-02-14 08:55:00 | AAPL | Stock | 42.45 | 42.45 | 42.3925 | 42.4 | 27836.0 |
| 2019-02-14 09:00:00 | AAPL | Stock | 42.4 | 42.4 | 42.2875 | 42.3125 | 82408.0 |
| 2019-02-14 09:05:00 | AAPL | Stock | 42.3275 | 42.37 | 42.315 | 42.36 | 33376.0 |
| 2019-02-14 09:10:00 | AAPL | Stock | 42.3425 | 42.37 | 42.335 | 42.35 | 19208.0 |
| 2019-02-14 09:15:00 | AAPL | Stock | 42.36 | 42.365 | 42.35 | 42.35 | 9424.0 |
| 2019-02-14 09:20:00 | AAPL | Stock | 42.3525 | 42.4 | 42.345 | 42.36 | 77184.0 |
| 2019-02-14 09:25:00 | AAPL | Stock | 42.3575 | 42.4725 | 42.35 | 42.4725 | 74716.0 |
| 2019-02-14 09:30:00 | AAPL | Stock | 42.4275 | 42.5525 | 42.345 | 42.5475 | 3888632.0 |
| 2019-02-14 09:35:00 | AAPL | Stock | 42.545 | 42.69 | 42.492 | 42.6025 | 2259808.0 |
| 2019-02-14 09:40:00 | AAPL | Stock | 42.6025 | 42.6325 | 42.52 | 42.5288 | 1625888.0 |
| 2019-02-14 09:45:00 | AAPL | Stock | 42.53 | 42.5875 | 42.4175 | 42.555 | 1563980.0 |
| 2019-02-14 09:50:00 | AAPL | Stock | 42.5575 | 42.645 | 42.5288 | 42.615 | 1268200.0 |
| 2019-02-14 09:55:00 | AAPL | Stock | 42.6175 | 42.7 | 42.6002 | 42.6638 | 1396984.0 |
| 2019-02-14 10:00:00 | AAPL | Stock | 42.6638 | 42.7225 | 42.61 | 42.7175 | 1521900.0 |
| 2019-02-14 10:05:00 | AAPL | Stock | 42.715 | 42.75 | 42.66 | 42.675 | 1735592.0 |
| 2019-02-14 10:10:00 | AAPL | Stock | 42.6738 | 42.77 | 42.635 | 42.755 | 1576408.0 |
| 2019-02-14 10:15:00 | AAPL | Stock | 42.755 | 42.8155 | 42.75 | 42.805 | 1403460.0 |
> showing 50 of 354,311 rows — these rows as CSV