PREVIEW / stock_5min / 2019-06-07
file: by_date/stock_5min/2019/2019-06-07.parquet size: 5.6 MB rows: 353,686 symbols: 2,607
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-06-07 04:00:00 | AAPL | Stock | 46.4275 | 46.4275 | 46.4275 | 46.4275 | 400.0 |
| 2019-06-07 04:05:00 | AAPL | Stock | 46.4575 | 46.4575 | 46.4575 | 46.4575 | 400.0 |
| 2019-06-07 04:10:00 | AAPL | Stock | 46.475 | 46.475 | 46.475 | 46.475 | 400.0 |
| 2019-06-07 04:15:00 | AAPL | Stock | 46.475 | 46.475 | 46.475 | 46.475 | 1108.0 |
| 2019-06-07 04:20:00 | AAPL | Stock | 46.54 | 46.575 | 46.5275 | 46.55 | 7304.0 |
| 2019-06-07 04:30:00 | AAPL | Stock | 46.575 | 46.6 | 46.575 | 46.6 | 4788.0 |
| 2019-06-07 04:35:00 | AAPL | Stock | 46.6 | 46.6 | 46.6 | 46.6 | 400.0 |
| 2019-06-07 04:40:00 | AAPL | Stock | 46.5975 | 46.5975 | 46.5975 | 46.5975 | 400.0 |
| 2019-06-07 04:45:00 | AAPL | Stock | 46.5975 | 46.6 | 46.5975 | 46.6 | 4232.0 |
| 2019-06-07 04:50:00 | AAPL | Stock | 46.6 | 46.6 | 46.6 | 46.6 | 1860.0 |
| 2019-06-07 04:55:00 | AAPL | Stock | 46.625 | 46.625 | 46.625 | 46.625 | 400.0 |
| 2019-06-07 05:00:00 | AAPL | Stock | 46.63 | 46.645 | 46.63 | 46.645 | 1600.0 |
| 2019-06-07 05:05:00 | AAPL | Stock | 46.645 | 46.645 | 46.645 | 46.645 | 2356.0 |
| 2019-06-07 05:45:00 | AAPL | Stock | 46.6575 | 46.6575 | 46.6575 | 46.6575 | 400.0 |
| 2019-06-07 06:00:00 | AAPL | Stock | 46.65 | 46.655 | 46.6475 | 46.6475 | 4504.0 |
| 2019-06-07 06:15:00 | AAPL | Stock | 46.595 | 46.595 | 46.595 | 46.595 | 400.0 |
| 2019-06-07 06:25:00 | AAPL | Stock | 46.595 | 46.595 | 46.595 | 46.595 | 400.0 |
| 2019-06-07 06:30:00 | AAPL | Stock | 46.6375 | 46.6375 | 46.6375 | 46.6375 | 820.0 |
| 2019-06-07 06:35:00 | AAPL | Stock | 46.6375 | 46.6375 | 46.6375 | 46.6375 | 400.0 |
| 2019-06-07 06:40:00 | AAPL | Stock | 46.6125 | 46.6125 | 46.585 | 46.585 | 1632.0 |
| 2019-06-07 06:45:00 | AAPL | Stock | 46.6225 | 46.6225 | 46.6225 | 46.6225 | 800.0 |
| 2019-06-07 06:50:00 | AAPL | Stock | 46.6225 | 46.6375 | 46.6225 | 46.6375 | 21764.0 |
| 2019-06-07 06:55:00 | AAPL | Stock | 46.6 | 46.6 | 46.6 | 46.6 | 400.0 |
| 2019-06-07 07:00:00 | AAPL | Stock | 46.5925 | 46.615 | 46.5675 | 46.6075 | 12716.0 |
| 2019-06-07 07:05:00 | AAPL | Stock | 46.5975 | 46.6 | 46.5975 | 46.6 | 2352.0 |
| 2019-06-07 07:10:00 | AAPL | Stock | 46.5875 | 46.5875 | 46.585 | 46.585 | 1200.0 |
| 2019-06-07 07:15:00 | AAPL | Stock | 46.585 | 46.585 | 46.55 | 46.55 | 11520.0 |
| 2019-06-07 07:20:00 | AAPL | Stock | 46.5375 | 46.5375 | 46.5375 | 46.5375 | 400.0 |
| 2019-06-07 07:25:00 | AAPL | Stock | 46.5375 | 46.5525 | 46.5375 | 46.55 | 8212.0 |
| 2019-06-07 07:30:00 | AAPL | Stock | 46.525 | 46.525 | 46.4725 | 46.48 | 18532.0 |
| 2019-06-07 07:35:00 | AAPL | Stock | 46.475 | 46.5125 | 46.475 | 46.5125 | 3208.0 |
| 2019-06-07 07:40:00 | AAPL | Stock | 46.525 | 46.55 | 46.5025 | 46.5025 | 3856.0 |
| 2019-06-07 07:45:00 | AAPL | Stock | 46.4875 | 46.4875 | 46.4875 | 46.4875 | 400.0 |
| 2019-06-07 07:50:00 | AAPL | Stock | 46.48 | 46.48 | 46.4675 | 46.4675 | 1320.0 |
| 2019-06-07 07:55:00 | AAPL | Stock | 46.4675 | 46.4675 | 46.4675 | 46.4675 | 4320.0 |
| 2019-06-07 08:00:00 | AAPL | Stock | 46.6118 | 46.625 | 46.42 | 46.45 | 100136.0 |
| 2019-06-07 08:05:00 | AAPL | Stock | 46.475 | 46.475 | 46.45 | 46.4625 | 20512.0 |
| 2019-06-07 08:10:00 | AAPL | Stock | 46.4725 | 46.4725 | 46.45 | 46.4725 | 34904.0 |
| 2019-06-07 08:15:00 | AAPL | Stock | 46.4325 | 46.47 | 46.4325 | 46.46 | 5480.0 |
| 2019-06-07 08:20:00 | AAPL | Stock | 46.475 | 46.4975 | 46.4625 | 46.495 | 23172.0 |
| 2019-06-07 08:25:00 | AAPL | Stock | 46.4725 | 46.5 | 46.3825 | 46.5 | 74800.0 |
| 2019-06-07 08:30:00 | AAPL | Stock | 46.47 | 46.495 | 46.305 | 46.3478 | 169176.0 |
| 2019-06-07 08:35:00 | AAPL | Stock | 46.355 | 46.375 | 46.305 | 46.37 | 65104.0 |
| 2019-06-07 08:40:00 | AAPL | Stock | 46.35 | 46.4275 | 46.3125 | 46.425 | 43792.0 |
| 2019-06-07 08:45:00 | AAPL | Stock | 46.355 | 46.4875 | 46.355 | 46.4875 | 46704.0 |
| 2019-06-07 08:50:00 | AAPL | Stock | 46.47 | 46.9 | 46.47 | 46.655 | 244712.0 |
| 2019-06-07 08:55:00 | AAPL | Stock | 46.6375 | 46.7 | 46.595 | 46.595 | 70352.0 |
| 2019-06-07 09:00:00 | AAPL | Stock | 46.5525 | 46.5875 | 46.48 | 46.545 | 64848.0 |
| 2019-06-07 09:05:00 | AAPL | Stock | 46.5625 | 46.6238 | 46.5375 | 46.5875 | 35024.0 |
| 2019-06-07 09:10:00 | AAPL | Stock | 46.571 | 46.575 | 46.495 | 46.575 | 64376.0 |
> showing 50 of 353,686 rows — these rows as CSV