PREVIEW / stock_5min / 2019-11-29
file: by_date/stock_5min/2019/2019-11-29.parquet size: 3.4 MB rows: 205,261 symbols: 2,458
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-11-29 04:00:00 | AAPL | Stock | 66.675 | 66.675 | 66.675 | 66.675 | 484.0 |
| 2019-11-29 04:05:00 | AAPL | Stock | 66.75 | 66.75 | 66.75 | 66.75 | 400.0 |
| 2019-11-29 04:10:00 | AAPL | Stock | 66.75 | 66.75 | 66.75 | 66.75 | 400.0 |
| 2019-11-29 04:15:00 | AAPL | Stock | 66.75 | 66.75 | 66.75 | 66.75 | 1600.0 |
| 2019-11-29 04:25:00 | AAPL | Stock | 66.7475 | 66.75 | 66.7475 | 66.75 | 800.0 |
| 2019-11-29 04:40:00 | AAPL | Stock | 66.7 | 66.7 | 66.7 | 66.7 | 664.0 |
| 2019-11-29 04:45:00 | AAPL | Stock | 66.7 | 66.7 | 66.7 | 66.7 | 800.0 |
| 2019-11-29 05:10:00 | AAPL | Stock | 66.735 | 66.75 | 66.735 | 66.75 | 2160.0 |
| 2019-11-29 05:15:00 | AAPL | Stock | 66.755 | 66.755 | 66.75 | 66.75 | 6712.0 |
| 2019-11-29 05:25:00 | AAPL | Stock | 66.7925 | 66.7925 | 66.7925 | 66.7925 | 1828.0 |
| 2019-11-29 05:40:00 | AAPL | Stock | 66.75 | 66.75 | 66.75 | 66.75 | 4324.0 |
| 2019-11-29 05:55:00 | AAPL | Stock | 66.775 | 66.775 | 66.775 | 66.775 | 4000.0 |
| 2019-11-29 06:05:00 | AAPL | Stock | 66.7825 | 66.7825 | 66.7825 | 66.7825 | 1468.0 |
| 2019-11-29 06:25:00 | AAPL | Stock | 66.7825 | 66.7825 | 66.7825 | 66.7825 | 8400.0 |
| 2019-11-29 06:40:00 | AAPL | Stock | 66.8375 | 66.8375 | 66.8375 | 66.8375 | 4000.0 |
| 2019-11-29 06:50:00 | AAPL | Stock | 66.8375 | 66.8375 | 66.8375 | 66.8375 | 3200.0 |
| 2019-11-29 07:00:00 | AAPL | Stock | 66.775 | 66.8625 | 66.775 | 66.8025 | 20028.0 |
| 2019-11-29 07:05:00 | AAPL | Stock | 66.8 | 66.8 | 66.7875 | 66.7875 | 12000.0 |
| 2019-11-29 07:10:00 | AAPL | Stock | 66.775 | 66.775 | 66.7525 | 66.7525 | 940.0 |
| 2019-11-29 07:15:00 | AAPL | Stock | 66.75 | 66.755 | 66.725 | 66.755 | 9900.0 |
| 2019-11-29 07:20:00 | AAPL | Stock | 66.775 | 66.775 | 66.775 | 66.775 | 400.0 |
| 2019-11-29 07:25:00 | AAPL | Stock | 66.8 | 66.8 | 66.8 | 66.8 | 400.0 |
| 2019-11-29 07:30:00 | AAPL | Stock | 66.8175 | 66.8175 | 66.79 | 66.815 | 2976.0 |
| 2019-11-29 07:40:00 | AAPL | Stock | 66.7775 | 66.785 | 66.7675 | 66.785 | 3508.0 |
| 2019-11-29 07:45:00 | AAPL | Stock | 66.7575 | 66.77 | 66.7575 | 66.7625 | 4892.0 |
| 2019-11-29 07:55:00 | AAPL | Stock | 66.765 | 66.765 | 66.765 | 66.765 | 400.0 |
| 2019-11-29 08:00:00 | AAPL | Stock | 66.78 | 66.85 | 66.725 | 66.75 | 95208.0 |
| 2019-11-29 08:05:00 | AAPL | Stock | 66.7675 | 66.7925 | 66.7675 | 66.7925 | 15004.0 |
| 2019-11-29 08:10:00 | AAPL | Stock | 66.75 | 66.765 | 66.75 | 66.765 | 3000.0 |
| 2019-11-29 08:15:00 | AAPL | Stock | 66.775 | 66.775 | 66.7625 | 66.7625 | 3860.0 |
| 2019-11-29 08:20:00 | AAPL | Stock | 66.7725 | 66.7725 | 66.7675 | 66.7725 | 5696.0 |
| 2019-11-29 08:25:00 | AAPL | Stock | 66.7502 | 66.7502 | 66.75 | 66.75 | 1948.0 |
| 2019-11-29 08:30:00 | AAPL | Stock | 66.75 | 66.7725 | 66.75 | 66.77 | 6672.0 |
| 2019-11-29 08:35:00 | AAPL | Stock | 66.7675 | 66.77 | 66.7675 | 66.77 | 1480.0 |
| 2019-11-29 08:40:00 | AAPL | Stock | 66.7725 | 66.7775 | 66.7725 | 66.775 | 11816.0 |
| 2019-11-29 08:45:00 | AAPL | Stock | 66.7775 | 66.7775 | 66.7775 | 66.7775 | 400.0 |
| 2019-11-29 08:50:00 | AAPL | Stock | 66.775 | 66.7875 | 66.765 | 66.765 | 6416.0 |
| 2019-11-29 08:55:00 | AAPL | Stock | 66.78 | 66.78 | 66.7628 | 66.7628 | 4600.0 |
| 2019-11-29 09:00:00 | AAPL | Stock | 66.7525 | 66.775 | 66.75 | 66.775 | 13148.0 |
| 2019-11-29 09:05:00 | AAPL | Stock | 66.76 | 66.76 | 66.76 | 66.76 | 400.0 |
| 2019-11-29 09:10:00 | AAPL | Stock | 66.76 | 66.76 | 66.745 | 66.76 | 22504.0 |
| 2019-11-29 09:15:00 | AAPL | Stock | 66.7575 | 66.7575 | 66.7475 | 66.7475 | 10096.0 |
| 2019-11-29 09:20:00 | AAPL | Stock | 66.7325 | 66.75 | 66.725 | 66.7375 | 16668.0 |
| 2019-11-29 09:25:00 | AAPL | Stock | 66.735 | 66.7525 | 66.565 | 66.57 | 103164.0 |
| 2019-11-29 09:30:00 | AAPL | Stock | 66.65 | 66.719 | 66.5325 | 66.57 | 2889412.0 |
| 2019-11-29 09:35:00 | AAPL | Stock | 66.575 | 66.6995 | 66.475 | 66.6675 | 1497708.0 |
| 2019-11-29 09:40:00 | AAPL | Stock | 66.66 | 66.81 | 66.61 | 66.8045 | 1474132.0 |
| 2019-11-29 09:45:00 | AAPL | Stock | 66.805 | 66.8125 | 66.675 | 66.7088 | 1015324.0 |
| 2019-11-29 09:50:00 | AAPL | Stock | 66.7025 | 66.84 | 66.6925 | 66.8275 | 603468.0 |
| 2019-11-29 09:55:00 | AAPL | Stock | 66.8298 | 66.9075 | 66.8175 | 66.86 | 942868.0 |
> showing 50 of 205,261 rows — these rows as CSV