PREVIEW / stock_5min / 2017-11-28
file: by_date/stock_5min/2017/2017-11-28.parquet size: 5.7 MB rows: 365,928 symbols: 2,958
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-11-28 05:50:00 | AAPL | Stock | 43.4875 | 43.495 | 43.4875 | 43.495 | 800.0 |
| 2017-11-28 05:55:00 | AAPL | Stock | 43.495 | 43.495 | 43.495 | 43.495 | 400.0 |
| 2017-11-28 06:20:00 | AAPL | Stock | 43.4875 | 43.505 | 43.4875 | 43.505 | 2000.0 |
| 2017-11-28 06:25:00 | AAPL | Stock | 43.5 | 43.5 | 43.5 | 43.5 | 400.0 |
| 2017-11-28 06:35:00 | AAPL | Stock | 43.5 | 43.5 | 43.5 | 43.5 | 400.0 |
| 2017-11-28 06:40:00 | AAPL | Stock | 43.5225 | 43.5225 | 43.5225 | 43.5225 | 400.0 |
| 2017-11-28 06:55:00 | AAPL | Stock | 43.57 | 43.5725 | 43.57 | 43.5725 | 2000.0 |
| 2017-11-28 07:00:00 | AAPL | Stock | 43.525 | 43.5625 | 43.525 | 43.5625 | 6320.0 |
| 2017-11-28 07:05:00 | AAPL | Stock | 43.5675 | 43.595 | 43.5675 | 43.595 | 12124.0 |
| 2017-11-28 07:10:00 | AAPL | Stock | 43.6225 | 43.625 | 43.6125 | 43.6125 | 41980.0 |
| 2017-11-28 07:15:00 | AAPL | Stock | 43.6 | 43.6 | 43.5975 | 43.5975 | 1772.0 |
| 2017-11-28 07:20:00 | AAPL | Stock | 43.6 | 43.6 | 43.595 | 43.595 | 2936.0 |
| 2017-11-28 07:30:00 | AAPL | Stock | 43.6125 | 43.6125 | 43.6025 | 43.6025 | 800.0 |
| 2017-11-28 07:35:00 | AAPL | Stock | 43.62 | 43.625 | 43.62 | 43.625 | 2664.0 |
| 2017-11-28 07:40:00 | AAPL | Stock | 43.625 | 43.625 | 43.625 | 43.625 | 1652.0 |
| 2017-11-28 07:50:00 | AAPL | Stock | 43.625 | 43.625 | 43.625 | 43.625 | 4400.0 |
| 2017-11-28 07:55:00 | AAPL | Stock | 43.6125 | 43.6125 | 43.6125 | 43.6125 | 2800.0 |
| 2017-11-28 08:00:00 | AAPL | Stock | 43.5225 | 43.6875 | 43.5225 | 43.575 | 1659008.0 |
| 2017-11-28 08:05:00 | AAPL | Stock | 43.575 | 43.575 | 43.575 | 43.575 | 10000.0 |
| 2017-11-28 08:10:00 | AAPL | Stock | 43.595 | 43.61 | 43.595 | 43.61 | 5580.0 |
| 2017-11-28 08:15:00 | AAPL | Stock | 43.61 | 43.6225 | 43.6025 | 43.6175 | 10000.0 |
| 2017-11-28 08:20:00 | AAPL | Stock | 43.6175 | 43.625 | 43.6175 | 43.625 | 13984.0 |
| 2017-11-28 08:25:00 | AAPL | Stock | 43.6175 | 43.6175 | 43.5975 | 43.5975 | 22360.0 |
| 2017-11-28 08:30:00 | AAPL | Stock | 43.6 | 43.6 | 43.575 | 43.575 | 48068.0 |
| 2017-11-28 08:35:00 | AAPL | Stock | 43.5725 | 43.58 | 43.55 | 43.55 | 45312.0 |
| 2017-11-28 08:40:00 | AAPL | Stock | 43.55 | 43.5625 | 43.5275 | 43.5625 | 68736.0 |
| 2017-11-28 08:45:00 | AAPL | Stock | 43.56 | 43.5625 | 43.56 | 43.5625 | 7748.0 |
| 2017-11-28 08:50:00 | AAPL | Stock | 43.55 | 43.5975 | 43.55 | 43.5975 | 8068.0 |
| 2017-11-28 08:55:00 | AAPL | Stock | 43.58 | 43.605 | 43.58 | 43.605 | 10504.0 |
| 2017-11-28 09:00:00 | AAPL | Stock | 43.585 | 43.6325 | 43.585 | 43.6325 | 68952.0 |
| 2017-11-28 09:05:00 | AAPL | Stock | 43.6325 | 43.6375 | 43.63 | 43.63 | 11984.0 |
| 2017-11-28 09:10:00 | AAPL | Stock | 43.6075 | 43.6075 | 43.5875 | 43.5875 | 9216.0 |
| 2017-11-28 09:15:00 | AAPL | Stock | 43.62 | 43.62 | 43.6 | 43.6 | 11508.0 |
| 2017-11-28 09:25:00 | AAPL | Stock | 43.5925 | 43.6075 | 43.525 | 43.545 | 274248.0 |
| 2017-11-28 09:30:00 | AAPL | Stock | 43.5625 | 43.6575 | 43.5225 | 43.6475 | 3454568.0 |
| 2017-11-28 09:35:00 | AAPL | Stock | 43.65 | 43.7175 | 43.5525 | 43.5868 | 2435952.0 |
| 2017-11-28 09:40:00 | AAPL | Stock | 43.59 | 43.6825 | 43.5525 | 43.6825 | 1410928.0 |
| 2017-11-28 09:45:00 | AAPL | Stock | 43.68 | 43.695 | 43.475 | 43.525 | 2243876.0 |
| 2017-11-28 09:50:00 | AAPL | Stock | 43.5225 | 43.5715 | 43.495 | 43.5075 | 1263956.0 |
| 2017-11-28 09:55:00 | AAPL | Stock | 43.505 | 43.5097 | 43.45 | 43.4725 | 1132712.0 |
| 2017-11-28 10:00:00 | AAPL | Stock | 43.47 | 43.5 | 43.4025 | 43.4485 | 1451384.0 |
| 2017-11-28 10:05:00 | AAPL | Stock | 43.4475 | 43.4875 | 43.4275 | 43.4825 | 854412.0 |
| 2017-11-28 10:10:00 | AAPL | Stock | 43.4825 | 43.485 | 43.4512 | 43.475 | 731384.0 |
| 2017-11-28 10:15:00 | AAPL | Stock | 43.4742 | 43.485 | 43.45 | 43.4565 | 517548.0 |
| 2017-11-28 10:20:00 | AAPL | Stock | 43.4562 | 43.4825 | 43.455 | 43.4725 | 511328.0 |
| 2017-11-28 10:25:00 | AAPL | Stock | 43.4725 | 43.49 | 43.4625 | 43.47 | 558816.0 |
| 2017-11-28 10:30:00 | AAPL | Stock | 43.4725 | 43.53 | 43.4725 | 43.515 | 690272.0 |
| 2017-11-28 10:35:00 | AAPL | Stock | 43.5165 | 43.55 | 43.495 | 43.5175 | 823056.0 |
| 2017-11-28 10:40:00 | AAPL | Stock | 43.52 | 43.55 | 43.4375 | 43.465 | 1318152.0 |
| 2017-11-28 10:45:00 | AAPL | Stock | 43.4625 | 43.465 | 43.415 | 43.4312 | 1283896.0 |
> showing 50 of 365,928 rows — these rows as CSV