PREVIEW / stock_5min / 2018-08-08
file: by_date/stock_5min/2018/2018-08-08.parquet size: 5.5 MB rows: 350,795 symbols: 2,774
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-08-08 04:00:00 | AAPL | Stock | 51.7 | 51.7 | 51.7 | 51.7 | 6400.0 |
| 2018-08-08 04:05:00 | AAPL | Stock | 51.69 | 51.6925 | 51.665 | 51.665 | 1436.0 |
| 2018-08-08 04:35:00 | AAPL | Stock | 51.675 | 51.675 | 51.675 | 51.675 | 2000.0 |
| 2018-08-08 04:40:00 | AAPL | Stock | 51.63 | 51.675 | 51.625 | 51.675 | 5196.0 |
| 2018-08-08 04:45:00 | AAPL | Stock | 51.6725 | 51.675 | 51.6725 | 51.675 | 1448.0 |
| 2018-08-08 04:50:00 | AAPL | Stock | 51.6225 | 51.6225 | 51.615 | 51.615 | 1600.0 |
| 2018-08-08 05:25:00 | AAPL | Stock | 51.69 | 51.69 | 51.69 | 51.69 | 400.0 |
| 2018-08-08 05:30:00 | AAPL | Stock | 51.65 | 51.65 | 51.65 | 51.65 | 1200.0 |
| 2018-08-08 05:35:00 | AAPL | Stock | 51.625 | 51.625 | 51.625 | 51.625 | 1600.0 |
| 2018-08-08 05:40:00 | AAPL | Stock | 51.65 | 51.75 | 51.65 | 51.675 | 15172.0 |
| 2018-08-08 05:50:00 | AAPL | Stock | 51.6575 | 51.6575 | 51.625 | 51.625 | 4724.0 |
| 2018-08-08 05:55:00 | AAPL | Stock | 51.625 | 51.625 | 51.625 | 51.625 | 400.0 |
| 2018-08-08 06:15:00 | AAPL | Stock | 51.625 | 51.625 | 51.625 | 51.625 | 800.0 |
| 2018-08-08 06:25:00 | AAPL | Stock | 51.6275 | 51.6275 | 51.55 | 51.55 | 7836.0 |
| 2018-08-08 06:30:00 | AAPL | Stock | 51.55 | 51.64 | 51.55 | 51.64 | 1200.0 |
| 2018-08-08 06:35:00 | AAPL | Stock | 51.64 | 51.64 | 51.64 | 51.64 | 8000.0 |
| 2018-08-08 06:40:00 | AAPL | Stock | 51.6375 | 51.6375 | 51.6375 | 51.6375 | 2528.0 |
| 2018-08-08 06:45:00 | AAPL | Stock | 51.6375 | 51.6475 | 51.6375 | 51.6475 | 8800.0 |
| 2018-08-08 06:50:00 | AAPL | Stock | 51.6475 | 51.655 | 51.6475 | 51.655 | 2400.0 |
| 2018-08-08 06:55:00 | AAPL | Stock | 51.6475 | 51.665 | 51.6475 | 51.665 | 5328.0 |
| 2018-08-08 07:00:00 | AAPL | Stock | 51.665 | 51.7575 | 51.665 | 51.74 | 30528.0 |
| 2018-08-08 07:05:00 | AAPL | Stock | 51.715 | 51.745 | 51.7125 | 51.7425 | 19912.0 |
| 2018-08-08 07:10:00 | AAPL | Stock | 51.7475 | 51.7475 | 51.7375 | 51.745 | 32400.0 |
| 2018-08-08 07:15:00 | AAPL | Stock | 51.75 | 51.75 | 51.7475 | 51.7475 | 11840.0 |
| 2018-08-08 07:20:00 | AAPL | Stock | 51.745 | 51.75 | 51.725 | 51.725 | 15640.0 |
| 2018-08-08 07:25:00 | AAPL | Stock | 51.735 | 51.735 | 51.7325 | 51.7325 | 4720.0 |
| 2018-08-08 07:30:00 | AAPL | Stock | 51.745 | 51.7475 | 51.7325 | 51.7325 | 7804.0 |
| 2018-08-08 07:35:00 | AAPL | Stock | 51.7325 | 51.7375 | 51.715 | 51.715 | 14568.0 |
| 2018-08-08 07:40:00 | AAPL | Stock | 51.735 | 51.7375 | 51.735 | 51.7375 | 3604.0 |
| 2018-08-08 07:45:00 | AAPL | Stock | 51.72 | 51.7375 | 51.72 | 51.7275 | 4288.0 |
| 2018-08-08 07:50:00 | AAPL | Stock | 51.715 | 51.715 | 51.6925 | 51.7125 | 7944.0 |
| 2018-08-08 07:55:00 | AAPL | Stock | 51.6875 | 51.6875 | 51.625 | 51.625 | 40588.0 |
| 2018-08-08 08:00:00 | AAPL | Stock | 51.745 | 51.7625 | 51.625 | 51.625 | 39376.0 |
| 2018-08-08 08:05:00 | AAPL | Stock | 51.625 | 51.6325 | 51.615 | 51.62 | 6240.0 |
| 2018-08-08 08:10:00 | AAPL | Stock | 51.62 | 51.6625 | 51.62 | 51.66 | 16840.0 |
| 2018-08-08 08:15:00 | AAPL | Stock | 51.6625 | 51.6725 | 51.63 | 51.6625 | 10008.0 |
| 2018-08-08 08:20:00 | AAPL | Stock | 51.65 | 51.65 | 51.625 | 51.6325 | 7780.0 |
| 2018-08-08 08:25:00 | AAPL | Stock | 51.625 | 51.625 | 51.6075 | 51.6075 | 18948.0 |
| 2018-08-08 08:30:00 | AAPL | Stock | 51.6175 | 51.62 | 51.605 | 51.605 | 8800.0 |
| 2018-08-08 08:35:00 | AAPL | Stock | 51.6025 | 51.6025 | 51.6 | 51.6 | 11704.0 |
| 2018-08-08 08:40:00 | AAPL | Stock | 51.6075 | 51.6075 | 51.585 | 51.59 | 20304.0 |
| 2018-08-08 08:45:00 | AAPL | Stock | 51.5752 | 51.595 | 51.5752 | 51.5825 | 20788.0 |
| 2018-08-08 08:50:00 | AAPL | Stock | 51.58 | 51.6125 | 51.58 | 51.5925 | 10412.0 |
| 2018-08-08 08:55:00 | AAPL | Stock | 51.6 | 51.6025 | 51.58 | 51.6 | 7980.0 |
| 2018-08-08 09:00:00 | AAPL | Stock | 51.61 | 51.6275 | 51.6025 | 51.6125 | 60976.0 |
| 2018-08-08 09:05:00 | AAPL | Stock | 51.605 | 51.6075 | 51.5875 | 51.6075 | 6160.0 |
| 2018-08-08 09:10:00 | AAPL | Stock | 51.6075 | 51.6125 | 51.6 | 51.61 | 5668.0 |
| 2018-08-08 09:15:00 | AAPL | Stock | 51.6 | 51.6225 | 51.6 | 51.6225 | 6004.0 |
| 2018-08-08 09:20:00 | AAPL | Stock | 51.6225 | 51.6225 | 51.6175 | 51.6175 | 5600.0 |
| 2018-08-08 09:25:00 | AAPL | Stock | 51.6075 | 51.6075 | 51.475 | 51.51 | 540036.0 |
> showing 50 of 350,795 rows — these rows as CSV