PREVIEW / stock_5min / 2018-01-09
file: by_date/stock_5min/2018/2018-01-09.parquet size: 5.8 MB rows: 367,460 symbols: 2,909
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 |
|---|---|---|---|---|---|---|---|
| 2018-01-09 04:40:00 | AAPL | Stock | 43.6975 | 43.6975 | 43.6975 | 43.6975 | 760.0 |
| 2018-01-09 04:50:00 | AAPL | Stock | 43.6275 | 43.6275 | 43.6275 | 43.6275 | 1284.0 |
| 2018-01-09 05:30:00 | AAPL | Stock | 43.625 | 43.625 | 43.625 | 43.625 | 400.0 |
| 2018-01-09 06:10:00 | AAPL | Stock | 43.6 | 43.6625 | 43.5875 | 43.6 | 37800.0 |
| 2018-01-09 06:35:00 | AAPL | Stock | 43.65 | 43.65 | 43.65 | 43.65 | 1200.0 |
| 2018-01-09 06:55:00 | AAPL | Stock | 43.6325 | 43.6325 | 43.6325 | 43.6325 | 400.0 |
| 2018-01-09 07:00:00 | AAPL | Stock | 43.625 | 43.6575 | 43.625 | 43.6575 | 2400.0 |
| 2018-01-09 07:05:00 | AAPL | Stock | 43.6625 | 43.675 | 43.6625 | 43.675 | 1720.0 |
| 2018-01-09 07:10:00 | AAPL | Stock | 43.6525 | 43.6575 | 43.65 | 43.6575 | 8632.0 |
| 2018-01-09 07:15:00 | AAPL | Stock | 43.6575 | 43.6575 | 43.64 | 43.64 | 7440.0 |
| 2018-01-09 07:20:00 | AAPL | Stock | 43.6475 | 43.6475 | 43.6475 | 43.6475 | 400.0 |
| 2018-01-09 07:25:00 | AAPL | Stock | 43.645 | 43.67 | 43.645 | 43.6575 | 14320.0 |
| 2018-01-09 07:30:00 | AAPL | Stock | 43.6525 | 43.6525 | 43.6525 | 43.6525 | 400.0 |
| 2018-01-09 07:35:00 | AAPL | Stock | 43.6675 | 43.6675 | 43.6675 | 43.6675 | 4000.0 |
| 2018-01-09 07:40:00 | AAPL | Stock | 43.6625 | 43.6625 | 43.65 | 43.6625 | 5592.0 |
| 2018-01-09 07:45:00 | AAPL | Stock | 43.6625 | 43.6625 | 43.6625 | 43.6625 | 2816.0 |
| 2018-01-09 07:50:00 | AAPL | Stock | 43.6625 | 43.6625 | 43.595 | 43.615 | 89468.0 |
| 2018-01-09 07:55:00 | AAPL | Stock | 43.615 | 43.635 | 43.61 | 43.635 | 2580.0 |
| 2018-01-09 08:00:00 | AAPL | Stock | 43.675 | 43.675 | 43.6 | 43.64 | 23356.0 |
| 2018-01-09 08:05:00 | AAPL | Stock | 43.6275 | 43.675 | 43.6275 | 43.675 | 15464.0 |
| 2018-01-09 08:10:00 | AAPL | Stock | 43.655 | 43.655 | 43.655 | 43.655 | 18092.0 |
| 2018-01-09 08:15:00 | AAPL | Stock | 43.6275 | 43.6275 | 43.615 | 43.615 | 8616.0 |
| 2018-01-09 08:20:00 | AAPL | Stock | 43.6175 | 43.6475 | 43.6175 | 43.6475 | 4832.0 |
| 2018-01-09 08:25:00 | AAPL | Stock | 43.65 | 43.68 | 43.65 | 43.675 | 12120.0 |
| 2018-01-09 08:30:00 | AAPL | Stock | 43.665 | 43.665 | 43.65 | 43.66 | 3820.0 |
| 2018-01-09 08:35:00 | AAPL | Stock | 43.665 | 43.7 | 43.665 | 43.7 | 23564.0 |
| 2018-01-09 08:40:00 | AAPL | Stock | 43.695 | 43.7225 | 43.6875 | 43.6875 | 75752.0 |
| 2018-01-09 08:45:00 | AAPL | Stock | 43.6875 | 43.6875 | 43.6875 | 43.6875 | 800.0 |
| 2018-01-09 08:50:00 | AAPL | Stock | 43.68 | 43.695 | 43.68 | 43.695 | 10296.0 |
| 2018-01-09 08:55:00 | AAPL | Stock | 43.7025 | 43.7125 | 43.68 | 43.68 | 16960.0 |
| 2018-01-09 09:00:00 | AAPL | Stock | 43.68 | 43.6875 | 43.67 | 43.6875 | 15140.0 |
| 2018-01-09 09:05:00 | AAPL | Stock | 43.6875 | 43.6875 | 43.675 | 43.675 | 5600.0 |
| 2018-01-09 09:10:00 | AAPL | Stock | 43.6825 | 43.6875 | 43.6675 | 43.6875 | 18152.0 |
| 2018-01-09 09:15:00 | AAPL | Stock | 43.6925 | 43.695 | 43.6675 | 43.675 | 30924.0 |
| 2018-01-09 09:20:00 | AAPL | Stock | 43.6675 | 43.6675 | 43.65 | 43.6575 | 20180.0 |
| 2018-01-09 09:25:00 | AAPL | Stock | 43.64 | 43.6525 | 43.6275 | 43.64 | 61968.0 |
| 2018-01-09 09:30:00 | AAPL | Stock | 43.6375 | 43.7125 | 43.625 | 43.6512 | 3447504.0 |
| 2018-01-09 09:35:00 | AAPL | Stock | 43.6525 | 43.67 | 43.5175 | 43.5275 | 2335420.0 |
| 2018-01-09 09:40:00 | AAPL | Stock | 43.5275 | 43.5325 | 43.4425 | 43.4475 | 2146284.0 |
| 2018-01-09 09:45:00 | AAPL | Stock | 43.4475 | 43.5125 | 43.3525 | 43.4675 | 2659564.0 |
| 2018-01-09 09:50:00 | AAPL | Stock | 43.4625 | 43.5225 | 43.37 | 43.475 | 2804216.0 |
| 2018-01-09 09:55:00 | AAPL | Stock | 43.47 | 43.52 | 43.405 | 43.405 | 1299108.0 |
| 2018-01-09 10:00:00 | AAPL | Stock | 43.4075 | 43.4225 | 43.3525 | 43.415 | 1975248.0 |
| 2018-01-09 10:05:00 | AAPL | Stock | 43.4162 | 43.4975 | 43.415 | 43.4888 | 1090056.0 |
| 2018-01-09 10:10:00 | AAPL | Stock | 43.4873 | 43.515 | 43.47 | 43.4975 | 991400.0 |
| 2018-01-09 10:15:00 | AAPL | Stock | 43.4975 | 43.5462 | 43.4925 | 43.53 | 1414388.0 |
| 2018-01-09 10:20:00 | AAPL | Stock | 43.5338 | 43.5425 | 43.4778 | 43.4925 | 935956.0 |
| 2018-01-09 10:25:00 | AAPL | Stock | 43.4925 | 43.5 | 43.4275 | 43.45 | 1031252.0 |
| 2018-01-09 10:30:00 | AAPL | Stock | 43.4525 | 43.4875 | 43.4525 | 43.46 | 709812.0 |
| 2018-01-09 10:35:00 | AAPL | Stock | 43.4575 | 43.48 | 43.3875 | 43.402 | 1124296.0 |
> showing 50 of 367,460 rows — these rows as CSV