PREVIEW / stock_5min / 2019-12-06
file: by_date/stock_5min/2019/2019-12-06.parquet size: 5.9 MB rows: 370,925 symbols: 2,485
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-12-06 04:00:00 | AAPL | Stock | 66.5 | 66.5925 | 66.5 | 66.575 | 4180.0 |
| 2019-12-06 04:05:00 | AAPL | Stock | 66.66 | 66.66 | 66.66 | 66.66 | 800.0 |
| 2019-12-06 04:10:00 | AAPL | Stock | 66.675 | 66.6825 | 66.65 | 66.65 | 4856.0 |
| 2019-12-06 04:15:00 | AAPL | Stock | 66.65 | 66.65 | 66.64 | 66.64 | 800.0 |
| 2019-12-06 04:25:00 | AAPL | Stock | 66.625 | 66.625 | 66.6225 | 66.6225 | 3200.0 |
| 2019-12-06 04:35:00 | AAPL | Stock | 66.65 | 66.65 | 66.65 | 66.65 | 1200.0 |
| 2019-12-06 04:50:00 | AAPL | Stock | 66.6475 | 66.65 | 66.6475 | 66.65 | 4772.0 |
| 2019-12-06 06:35:00 | AAPL | Stock | 66.625 | 66.625 | 66.625 | 66.625 | 1220.0 |
| 2019-12-06 06:45:00 | AAPL | Stock | 66.6225 | 66.6225 | 66.6225 | 66.6225 | 400.0 |
| 2019-12-06 06:50:00 | AAPL | Stock | 66.63 | 66.63 | 66.63 | 66.63 | 400.0 |
| 2019-12-06 06:55:00 | AAPL | Stock | 66.6475 | 66.65 | 66.6475 | 66.65 | 5600.0 |
| 2019-12-06 07:00:00 | AAPL | Stock | 66.62 | 66.63 | 66.575 | 66.6075 | 26728.0 |
| 2019-12-06 07:05:00 | AAPL | Stock | 66.6075 | 66.6075 | 66.5775 | 66.5775 | 9200.0 |
| 2019-12-06 07:10:00 | AAPL | Stock | 66.5375 | 66.5375 | 66.4975 | 66.4975 | 11536.0 |
| 2019-12-06 07:15:00 | AAPL | Stock | 66.4975 | 66.5 | 66.4975 | 66.5 | 4360.0 |
| 2019-12-06 07:20:00 | AAPL | Stock | 66.4975 | 66.5125 | 66.4975 | 66.5125 | 3536.0 |
| 2019-12-06 07:25:00 | AAPL | Stock | 66.5025 | 66.5025 | 66.4775 | 66.48 | 29680.0 |
| 2019-12-06 07:30:00 | AAPL | Stock | 66.48 | 66.5225 | 66.4375 | 66.5225 | 22400.0 |
| 2019-12-06 07:35:00 | AAPL | Stock | 66.525 | 66.5425 | 66.525 | 66.5325 | 9456.0 |
| 2019-12-06 07:40:00 | AAPL | Stock | 66.525 | 66.5725 | 66.525 | 66.5425 | 17040.0 |
| 2019-12-06 07:45:00 | AAPL | Stock | 66.5375 | 66.55 | 66.5075 | 66.55 | 9336.0 |
| 2019-12-06 07:50:00 | AAPL | Stock | 66.5525 | 66.575 | 66.5375 | 66.575 | 10392.0 |
| 2019-12-06 07:55:00 | AAPL | Stock | 66.5325 | 66.5325 | 66.5325 | 66.5325 | 800.0 |
| 2019-12-06 08:00:00 | AAPL | Stock | 66.5275 | 66.6375 | 66.4775 | 66.5375 | 59804.0 |
| 2019-12-06 08:05:00 | AAPL | Stock | 66.5275 | 66.55 | 66.5275 | 66.55 | 13928.0 |
| 2019-12-06 08:10:00 | AAPL | Stock | 66.55 | 66.55 | 66.505 | 66.53 | 5800.0 |
| 2019-12-06 08:15:00 | AAPL | Stock | 66.513 | 66.5425 | 66.4975 | 66.4975 | 20472.0 |
| 2019-12-06 08:20:00 | AAPL | Stock | 66.5 | 66.5 | 66.475 | 66.5 | 38512.0 |
| 2019-12-06 08:25:00 | AAPL | Stock | 66.5 | 66.5225 | 66.5 | 66.5225 | 6008.0 |
| 2019-12-06 08:30:00 | AAPL | Stock | 66.5375 | 66.6875 | 66.48 | 66.65 | 368588.0 |
| 2019-12-06 08:35:00 | AAPL | Stock | 66.65 | 66.6975 | 66.6065 | 66.69 | 135360.0 |
| 2019-12-06 08:40:00 | AAPL | Stock | 66.6875 | 66.8025 | 66.6875 | 66.7725 | 156496.0 |
| 2019-12-06 08:45:00 | AAPL | Stock | 66.765 | 66.7825 | 66.705 | 66.7725 | 100692.0 |
| 2019-12-06 08:50:00 | AAPL | Stock | 66.7725 | 66.825 | 66.725 | 66.7875 | 36152.0 |
| 2019-12-06 08:55:00 | AAPL | Stock | 66.8125 | 66.825 | 66.75 | 66.7725 | 46524.0 |
| 2019-12-06 09:00:00 | AAPL | Stock | 66.775 | 66.7925 | 66.7575 | 66.785 | 31424.0 |
| 2019-12-06 09:05:00 | AAPL | Stock | 66.8 | 66.8225 | 66.765 | 66.7975 | 41080.0 |
| 2019-12-06 09:10:00 | AAPL | Stock | 66.7875 | 66.8175 | 66.7875 | 66.8075 | 26160.0 |
| 2019-12-06 09:15:00 | AAPL | Stock | 66.815 | 66.8225 | 66.775 | 66.775 | 61068.0 |
| 2019-12-06 09:20:00 | AAPL | Stock | 66.785 | 66.786 | 66.75 | 66.7525 | 116816.0 |
| 2019-12-06 09:25:00 | AAPL | Stock | 66.7625 | 66.88 | 66.7625 | 66.8775 | 112472.0 |
| 2019-12-06 09:30:00 | AAPL | Stock | 66.8775 | 67.1725 | 66.825 | 67.11 | 5947652.0 |
| 2019-12-06 09:35:00 | AAPL | Stock | 67.1075 | 67.135 | 66.9675 | 67.02 | 2078440.0 |
| 2019-12-06 09:40:00 | AAPL | Stock | 67.015 | 67.1475 | 67.015 | 67.1075 | 1505576.0 |
| 2019-12-06 09:45:00 | AAPL | Stock | 67.1125 | 67.2875 | 67.11 | 67.2625 | 2570640.0 |
| 2019-12-06 09:50:00 | AAPL | Stock | 67.2648 | 67.2975 | 67.1675 | 67.1975 | 1874244.0 |
| 2019-12-06 09:55:00 | AAPL | Stock | 67.195 | 67.29 | 67.1825 | 67.2745 | 1428836.0 |
| 2019-12-06 10:00:00 | AAPL | Stock | 67.2725 | 67.3382 | 67.265 | 67.2775 | 1438412.0 |
| 2019-12-06 10:05:00 | AAPL | Stock | 67.275 | 67.34 | 67.2525 | 67.2992 | 1101976.0 |
| 2019-12-06 10:10:00 | AAPL | Stock | 67.3 | 67.32 | 67.24 | 67.2775 | 1034900.0 |
> showing 50 of 370,925 rows — these rows as CSV