PREVIEW / stock_1min / 2018-02-28
file: by_date/stock_1min/2018/2018-02-28.parquet size: 15.7 MB rows: 1,118,330 symbols: 2,399
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-02-28 04:01:00 | AAPL | Stock | 44.6775 | 44.6775 | 44.6775 | 44.6775 | 400.0 |
| 2018-02-28 04:03:00 | AAPL | Stock | 44.665 | 44.665 | 44.665 | 44.665 | 9328.0 |
| 2018-02-28 04:06:00 | AAPL | Stock | 44.6775 | 44.6775 | 44.675 | 44.675 | 1596.0 |
| 2018-02-28 04:07:00 | AAPL | Stock | 44.675 | 44.675 | 44.675 | 44.675 | 400.0 |
| 2018-02-28 04:08:00 | AAPL | Stock | 44.6625 | 44.675 | 44.6625 | 44.6625 | 9756.0 |
| 2018-02-28 04:14:00 | AAPL | Stock | 44.74 | 44.745 | 44.74 | 44.745 | 5960.0 |
| 2018-02-28 04:21:00 | AAPL | Stock | 44.6975 | 44.6975 | 44.6975 | 44.6975 | 2000.0 |
| 2018-02-28 04:22:00 | AAPL | Stock | 44.6975 | 44.6975 | 44.6975 | 44.6975 | 3800.0 |
| 2018-02-28 04:27:00 | AAPL | Stock | 44.71 | 44.71 | 44.71 | 44.71 | 400.0 |
| 2018-02-28 04:28:00 | AAPL | Stock | 44.71 | 44.71 | 44.71 | 44.71 | 12800.0 |
| 2018-02-28 04:40:00 | AAPL | Stock | 44.71 | 44.71 | 44.71 | 44.71 | 800.0 |
| 2018-02-28 04:50:00 | AAPL | Stock | 44.7375 | 44.7375 | 44.7375 | 44.7375 | 800.0 |
| 2018-02-28 05:04:00 | AAPL | Stock | 44.735 | 44.735 | 44.735 | 44.735 | 400.0 |
| 2018-02-28 05:05:00 | AAPL | Stock | 44.735 | 44.735 | 44.735 | 44.735 | 400.0 |
| 2018-02-28 05:08:00 | AAPL | Stock | 44.71 | 44.71 | 44.705 | 44.705 | 3024.0 |
| 2018-02-28 05:51:00 | AAPL | Stock | 44.6625 | 44.72 | 44.6625 | 44.72 | 1980.0 |
| 2018-02-28 05:55:00 | AAPL | Stock | 44.6425 | 44.6425 | 44.6375 | 44.6375 | 980.0 |
| 2018-02-28 06:07:00 | AAPL | Stock | 44.6275 | 44.6275 | 44.5925 | 44.5925 | 1928.0 |
| 2018-02-28 06:21:00 | AAPL | Stock | 44.695 | 44.695 | 44.695 | 44.695 | 400.0 |
| 2018-02-28 06:41:00 | AAPL | Stock | 44.635 | 44.635 | 44.635 | 44.635 | 1200.0 |
| 2018-02-28 06:45:00 | AAPL | Stock | 44.625 | 44.625 | 44.625 | 44.625 | 880.0 |
| 2018-02-28 07:00:00 | AAPL | Stock | 44.645 | 44.66 | 44.645 | 44.65 | 8632.0 |
| 2018-02-28 07:01:00 | AAPL | Stock | 44.65 | 44.65 | 44.65 | 44.65 | 2000.0 |
| 2018-02-28 07:02:00 | AAPL | Stock | 44.65 | 44.65 | 44.65 | 44.65 | 1200.0 |
| 2018-02-28 07:03:00 | AAPL | Stock | 44.6425 | 44.6425 | 44.6425 | 44.6425 | 400.0 |
| 2018-02-28 07:04:00 | AAPL | Stock | 44.6425 | 44.6425 | 44.6425 | 44.6425 | 1600.0 |
| 2018-02-28 07:05:00 | AAPL | Stock | 44.65 | 44.65 | 44.65 | 44.65 | 400.0 |
| 2018-02-28 07:06:00 | AAPL | Stock | 44.65 | 44.65 | 44.65 | 44.65 | 400.0 |
| 2018-02-28 07:07:00 | AAPL | Stock | 44.6425 | 44.655 | 44.6425 | 44.655 | 2400.0 |
| 2018-02-28 07:09:00 | AAPL | Stock | 44.665 | 44.665 | 44.665 | 44.665 | 2400.0 |
| 2018-02-28 07:10:00 | AAPL | Stock | 44.665 | 44.665 | 44.665 | 44.665 | 3380.0 |
| 2018-02-28 07:11:00 | AAPL | Stock | 44.67 | 44.67 | 44.665 | 44.665 | 3092.0 |
| 2018-02-28 07:15:00 | AAPL | Stock | 44.69 | 44.73 | 44.69 | 44.73 | 15184.0 |
| 2018-02-28 07:17:00 | AAPL | Stock | 44.7 | 44.7 | 44.7 | 44.7 | 400.0 |
| 2018-02-28 07:18:00 | AAPL | Stock | 44.6975 | 44.6975 | 44.6975 | 44.6975 | 1000.0 |
| 2018-02-28 07:20:00 | AAPL | Stock | 44.7 | 44.7 | 44.695 | 44.7 | 4400.0 |
| 2018-02-28 07:21:00 | AAPL | Stock | 44.6975 | 44.6975 | 44.695 | 44.6975 | 3960.0 |
| 2018-02-28 07:26:00 | AAPL | Stock | 44.65 | 44.65 | 44.65 | 44.65 | 800.0 |
| 2018-02-28 07:27:00 | AAPL | Stock | 44.645 | 44.645 | 44.645 | 44.645 | 2000.0 |
| 2018-02-28 07:28:00 | AAPL | Stock | 44.65 | 44.65 | 44.65 | 44.65 | 3588.0 |
| 2018-02-28 07:29:00 | AAPL | Stock | 44.66 | 44.6725 | 44.6425 | 44.6425 | 16936.0 |
| 2018-02-28 07:30:00 | AAPL | Stock | 44.6375 | 44.6425 | 44.6375 | 44.6425 | 3768.0 |
| 2018-02-28 07:36:00 | AAPL | Stock | 44.65 | 44.65 | 44.65 | 44.65 | 800.0 |
| 2018-02-28 07:39:00 | AAPL | Stock | 44.65 | 44.675 | 44.65 | 44.675 | 1600.0 |
| 2018-02-28 07:40:00 | AAPL | Stock | 44.675 | 44.68 | 44.675 | 44.68 | 8796.0 |
| 2018-02-28 07:41:00 | AAPL | Stock | 44.66 | 44.66 | 44.66 | 44.66 | 400.0 |
| 2018-02-28 07:48:00 | AAPL | Stock | 44.6775 | 44.68 | 44.6775 | 44.68 | 5344.0 |
| 2018-02-28 07:49:00 | AAPL | Stock | 44.68 | 44.6875 | 44.68 | 44.6875 | 960.0 |
| 2018-02-28 07:50:00 | AAPL | Stock | 44.685 | 44.7 | 44.685 | 44.7 | 2252.0 |
| 2018-02-28 07:51:00 | AAPL | Stock | 44.7 | 44.7 | 44.7 | 44.7 | 2000.0 |
> showing 50 of 1,118,330 rows — these rows as CSV