PREVIEW / stock_5min / 2018-01-16
file: by_date/stock_5min/2018/2018-01-16.parquet size: 6.1 MB rows: 385,323 symbols: 2,914
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-16 04:00:00 | AAPL | Stock | 44.35 | 44.4 | 44.35 | 44.4 | 10600.0 |
| 2018-01-16 04:05:00 | AAPL | Stock | 44.45 | 44.5 | 44.4 | 44.5 | 29764.0 |
| 2018-01-16 04:10:00 | AAPL | Stock | 44.5 | 44.6 | 44.5 | 44.6 | 13848.0 |
| 2018-01-16 04:15:00 | AAPL | Stock | 44.57 | 44.575 | 44.57 | 44.575 | 9336.0 |
| 2018-01-16 04:25:00 | AAPL | Stock | 44.5625 | 44.5625 | 44.5625 | 44.5625 | 1920.0 |
| 2018-01-16 04:35:00 | AAPL | Stock | 44.575 | 44.575 | 44.575 | 44.575 | 800.0 |
| 2018-01-16 04:50:00 | AAPL | Stock | 44.5625 | 44.5625 | 44.5625 | 44.5625 | 1200.0 |
| 2018-01-16 05:00:00 | AAPL | Stock | 44.525 | 44.525 | 44.525 | 44.525 | 400.0 |
| 2018-01-16 05:10:00 | AAPL | Stock | 44.55 | 44.55 | 44.55 | 44.55 | 400.0 |
| 2018-01-16 05:20:00 | AAPL | Stock | 44.5 | 44.5 | 44.5 | 44.5 | 400.0 |
| 2018-01-16 05:25:00 | AAPL | Stock | 44.505 | 44.505 | 44.5 | 44.5 | 2984.0 |
| 2018-01-16 05:35:00 | AAPL | Stock | 44.5025 | 44.5025 | 44.5 | 44.5 | 1504.0 |
| 2018-01-16 05:45:00 | AAPL | Stock | 44.55 | 44.55 | 44.55 | 44.55 | 1600.0 |
| 2018-01-16 05:50:00 | AAPL | Stock | 44.5175 | 44.5175 | 44.5175 | 44.5175 | 400.0 |
| 2018-01-16 06:00:00 | AAPL | Stock | 44.5375 | 44.5625 | 44.5375 | 44.5625 | 20800.0 |
| 2018-01-16 06:05:00 | AAPL | Stock | 44.5625 | 44.575 | 44.55 | 44.55 | 5132.0 |
| 2018-01-16 06:15:00 | AAPL | Stock | 44.575 | 44.575 | 44.575 | 44.575 | 4000.0 |
| 2018-01-16 06:20:00 | AAPL | Stock | 44.5725 | 44.5725 | 44.5675 | 44.5725 | 8776.0 |
| 2018-01-16 06:25:00 | AAPL | Stock | 44.57 | 44.57 | 44.5425 | 44.5425 | 3860.0 |
| 2018-01-16 06:30:00 | AAPL | Stock | 44.5625 | 44.5625 | 44.5375 | 44.5375 | 7600.0 |
| 2018-01-16 06:35:00 | AAPL | Stock | 44.55 | 44.5625 | 44.55 | 44.55 | 6300.0 |
| 2018-01-16 06:45:00 | AAPL | Stock | 44.5725 | 44.575 | 44.5725 | 44.575 | 1748.0 |
| 2018-01-16 06:50:00 | AAPL | Stock | 44.575 | 44.575 | 44.575 | 44.575 | 400.0 |
| 2018-01-16 06:55:00 | AAPL | Stock | 44.5875 | 44.5975 | 44.5875 | 44.5975 | 5180.0 |
| 2018-01-16 07:00:00 | AAPL | Stock | 44.56 | 44.5975 | 44.5 | 44.5 | 53892.0 |
| 2018-01-16 07:05:00 | AAPL | Stock | 44.525 | 44.545 | 44.525 | 44.5275 | 9520.0 |
| 2018-01-16 07:10:00 | AAPL | Stock | 44.5425 | 44.5875 | 44.5 | 44.5625 | 16576.0 |
| 2018-01-16 07:15:00 | AAPL | Stock | 44.5625 | 44.5625 | 44.5125 | 44.5325 | 10520.0 |
| 2018-01-16 07:20:00 | AAPL | Stock | 44.5125 | 44.5375 | 44.5 | 44.5375 | 11260.0 |
| 2018-01-16 07:25:00 | AAPL | Stock | 44.5375 | 44.5375 | 44.535 | 44.535 | 2300.0 |
| 2018-01-16 07:30:00 | AAPL | Stock | 44.5375 | 44.55 | 44.5375 | 44.55 | 20000.0 |
| 2018-01-16 07:35:00 | AAPL | Stock | 44.55 | 44.595 | 44.55 | 44.595 | 8312.0 |
| 2018-01-16 07:40:00 | AAPL | Stock | 44.5925 | 44.6 | 44.58 | 44.6 | 24300.0 |
| 2018-01-16 07:45:00 | AAPL | Stock | 44.6 | 44.6 | 44.5875 | 44.595 | 7200.0 |
| 2018-01-16 07:50:00 | AAPL | Stock | 44.5875 | 44.5975 | 44.58 | 44.5975 | 11884.0 |
| 2018-01-16 07:55:00 | AAPL | Stock | 44.5825 | 44.63 | 44.5825 | 44.625 | 25036.0 |
| 2018-01-16 08:00:00 | AAPL | Stock | 44.5375 | 44.63 | 44.515 | 44.625 | 47876.0 |
| 2018-01-16 08:05:00 | AAPL | Stock | 44.6175 | 44.63 | 44.6175 | 44.6175 | 34340.0 |
| 2018-01-16 08:10:00 | AAPL | Stock | 44.63 | 44.64 | 44.6125 | 44.64 | 15860.0 |
| 2018-01-16 08:15:00 | AAPL | Stock | 44.65 | 44.6625 | 44.615 | 44.625 | 54064.0 |
| 2018-01-16 08:20:00 | AAPL | Stock | 44.605 | 44.625 | 44.5875 | 44.6 | 32152.0 |
| 2018-01-16 08:25:00 | AAPL | Stock | 44.6025 | 44.62 | 44.5925 | 44.5975 | 26288.0 |
| 2018-01-16 08:30:00 | AAPL | Stock | 44.585 | 44.6375 | 44.585 | 44.6375 | 31744.0 |
| 2018-01-16 08:35:00 | AAPL | Stock | 44.625 | 44.625 | 44.6 | 44.625 | 16060.0 |
| 2018-01-16 08:40:00 | AAPL | Stock | 44.62 | 44.62 | 44.575 | 44.575 | 34164.0 |
| 2018-01-16 08:45:00 | AAPL | Stock | 44.585 | 44.5875 | 44.57 | 44.5825 | 19972.0 |
| 2018-01-16 08:50:00 | AAPL | Stock | 44.57 | 44.6 | 44.555 | 44.5975 | 11176.0 |
| 2018-01-16 08:55:00 | AAPL | Stock | 44.58 | 44.6 | 44.58 | 44.585 | 8392.0 |
| 2018-01-16 09:00:00 | AAPL | Stock | 44.575 | 44.6 | 44.56 | 44.585 | 44016.0 |
| 2018-01-16 09:05:00 | AAPL | Stock | 44.59 | 44.59 | 44.525 | 44.5375 | 46852.0 |
> showing 50 of 385,323 rows — these rows as CSV