PREVIEW / stock_1min / 2018-06-26
file: by_date/stock_1min/2018/2018-06-26.parquet size: 15.5 MB rows: 1,106,549 symbols: 2,356
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-06-26 04:04:00 | AAPL | Stock | 45.825 | 45.825 | 45.825 | 45.825 | 600.0 |
| 2018-06-26 04:37:00 | AAPL | Stock | 45.775 | 45.775 | 45.775 | 45.775 | 3880.0 |
| 2018-06-26 05:06:00 | AAPL | Stock | 45.725 | 45.725 | 45.725 | 45.725 | 400.0 |
| 2018-06-26 05:21:00 | AAPL | Stock | 45.7375 | 45.7375 | 45.7375 | 45.7375 | 1548.0 |
| 2018-06-26 05:22:00 | AAPL | Stock | 45.7375 | 45.7375 | 45.7375 | 45.7375 | 1200.0 |
| 2018-06-26 05:23:00 | AAPL | Stock | 45.755 | 45.755 | 45.755 | 45.755 | 1200.0 |
| 2018-06-26 05:27:00 | AAPL | Stock | 45.755 | 45.755 | 45.755 | 45.755 | 800.0 |
| 2018-06-26 05:45:00 | AAPL | Stock | 45.6975 | 45.6975 | 45.6975 | 45.6975 | 5200.0 |
| 2018-06-26 05:49:00 | AAPL | Stock | 45.695 | 45.6975 | 45.695 | 45.6975 | 13284.0 |
| 2018-06-26 05:56:00 | AAPL | Stock | 45.6975 | 45.6975 | 45.6975 | 45.6975 | 1492.0 |
| 2018-06-26 06:01:00 | AAPL | Stock | 45.755 | 45.755 | 45.755 | 45.755 | 400.0 |
| 2018-06-26 06:06:00 | AAPL | Stock | 45.7025 | 45.7025 | 45.6975 | 45.6975 | 1200.0 |
| 2018-06-26 06:09:00 | AAPL | Stock | 45.655 | 45.655 | 45.655 | 45.655 | 6060.0 |
| 2018-06-26 06:30:00 | AAPL | Stock | 45.6675 | 45.675 | 45.6675 | 45.675 | 6388.0 |
| 2018-06-26 06:46:00 | AAPL | Stock | 45.7125 | 45.7125 | 45.7125 | 45.7125 | 400.0 |
| 2018-06-26 06:48:00 | AAPL | Stock | 45.73 | 45.73 | 45.7125 | 45.7125 | 9504.0 |
| 2018-06-26 07:00:00 | AAPL | Stock | 45.6875 | 45.75 | 45.6875 | 45.7475 | 8408.0 |
| 2018-06-26 07:04:00 | AAPL | Stock | 45.745 | 45.745 | 45.745 | 45.745 | 4000.0 |
| 2018-06-26 07:05:00 | AAPL | Stock | 45.7475 | 45.7475 | 45.7475 | 45.7475 | 456.0 |
| 2018-06-26 07:06:00 | AAPL | Stock | 45.7025 | 45.7025 | 45.7025 | 45.7025 | 1228.0 |
| 2018-06-26 07:07:00 | AAPL | Stock | 45.7375 | 45.7375 | 45.7375 | 45.7375 | 800.0 |
| 2018-06-26 07:10:00 | AAPL | Stock | 45.7375 | 45.7375 | 45.7375 | 45.7375 | 400.0 |
| 2018-06-26 07:12:00 | AAPL | Stock | 45.7125 | 45.7125 | 45.7 | 45.705 | 7844.0 |
| 2018-06-26 07:13:00 | AAPL | Stock | 45.7 | 45.7 | 45.7 | 45.7 | 400.0 |
| 2018-06-26 07:14:00 | AAPL | Stock | 45.72 | 45.72 | 45.7 | 45.7 | 2392.0 |
| 2018-06-26 07:26:00 | AAPL | Stock | 45.6875 | 45.6875 | 45.6875 | 45.6875 | 8000.0 |
| 2018-06-26 07:30:00 | AAPL | Stock | 45.665 | 45.675 | 45.65 | 45.675 | 3368.0 |
| 2018-06-26 07:31:00 | AAPL | Stock | 45.655 | 45.655 | 45.6525 | 45.6525 | 800.0 |
| 2018-06-26 07:36:00 | AAPL | Stock | 45.6525 | 45.6525 | 45.6525 | 45.6525 | 400.0 |
| 2018-06-26 07:38:00 | AAPL | Stock | 45.655 | 45.6575 | 45.65 | 45.6575 | 7976.0 |
| 2018-06-26 07:39:00 | AAPL | Stock | 45.65 | 45.65 | 45.6475 | 45.6475 | 1800.0 |
| 2018-06-26 07:40:00 | AAPL | Stock | 45.64 | 45.64 | 45.64 | 45.64 | 400.0 |
| 2018-06-26 07:42:00 | AAPL | Stock | 45.64 | 45.6525 | 45.6375 | 45.6525 | 2800.0 |
| 2018-06-26 07:43:00 | AAPL | Stock | 45.6525 | 45.6525 | 45.635 | 45.635 | 2936.0 |
| 2018-06-26 07:45:00 | AAPL | Stock | 45.64 | 45.64 | 45.64 | 45.64 | 800.0 |
| 2018-06-26 07:46:00 | AAPL | Stock | 45.655 | 45.665 | 45.655 | 45.665 | 1200.0 |
| 2018-06-26 07:49:00 | AAPL | Stock | 45.65 | 45.65 | 45.65 | 45.65 | 5376.0 |
| 2018-06-26 07:50:00 | AAPL | Stock | 45.65 | 45.65 | 45.65 | 45.65 | 1424.0 |
| 2018-06-26 07:55:00 | AAPL | Stock | 45.65 | 45.65 | 45.65 | 45.65 | 1600.0 |
| 2018-06-26 07:58:00 | AAPL | Stock | 45.6725 | 45.6725 | 45.6725 | 45.6725 | 1024.0 |
| 2018-06-26 08:00:00 | AAPL | Stock | 45.75 | 45.75 | 45.6375 | 45.6625 | 44600.0 |
| 2018-06-26 08:01:00 | AAPL | Stock | 45.6875 | 45.695 | 45.6875 | 45.695 | 3156.0 |
| 2018-06-26 08:03:00 | AAPL | Stock | 45.7 | 45.7 | 45.7 | 45.7 | 648.0 |
| 2018-06-26 08:04:00 | AAPL | Stock | 45.7 | 45.7 | 45.7 | 45.7 | 552.0 |
| 2018-06-26 08:05:00 | AAPL | Stock | 45.6875 | 45.6875 | 45.6875 | 45.6875 | 2400.0 |
| 2018-06-26 08:06:00 | AAPL | Stock | 45.6975 | 45.7375 | 45.675 | 45.675 | 40488.0 |
| 2018-06-26 08:08:00 | AAPL | Stock | 45.7 | 45.7 | 45.7 | 45.7 | 4124.0 |
| 2018-06-26 08:09:00 | AAPL | Stock | 45.72 | 45.72 | 45.72 | 45.72 | 400.0 |
| 2018-06-26 08:11:00 | AAPL | Stock | 45.72 | 45.725 | 45.72 | 45.725 | 3000.0 |
| 2018-06-26 08:12:00 | AAPL | Stock | 45.735 | 45.75 | 45.735 | 45.75 | 5412.0 |
> showing 50 of 1,106,549 rows — these rows as CSV