PREVIEW / stock_5min / 2019-06-05
file: by_date/stock_5min/2019/2019-06-05.parquet size: 5.7 MB rows: 359,993 symbols: 2,592
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-06-05 04:05:00 | AAPL | Stock | 45.4975 | 45.4975 | 45.4975 | 45.4975 | 2000.0 |
| 2019-06-05 04:10:00 | AAPL | Stock | 45.4975 | 45.4975 | 45.4975 | 45.4975 | 492.0 |
| 2019-06-05 04:15:00 | AAPL | Stock | 45.49 | 45.49 | 45.4675 | 45.4675 | 16400.0 |
| 2019-06-05 04:25:00 | AAPL | Stock | 45.4225 | 45.4225 | 45.42 | 45.42 | 976.0 |
| 2019-06-05 04:30:00 | AAPL | Stock | 45.5 | 45.5 | 45.5 | 45.5 | 3484.0 |
| 2019-06-05 04:40:00 | AAPL | Stock | 45.435 | 45.435 | 45.435 | 45.435 | 800.0 |
| 2019-06-05 04:50:00 | AAPL | Stock | 45.4525 | 45.5 | 45.4525 | 45.5 | 5960.0 |
| 2019-06-05 05:00:00 | AAPL | Stock | 45.495 | 45.5 | 45.4875 | 45.49 | 10200.0 |
| 2019-06-05 05:05:00 | AAPL | Stock | 45.4775 | 45.4775 | 45.4175 | 45.4375 | 12800.0 |
| 2019-06-05 05:10:00 | AAPL | Stock | 45.435 | 45.4375 | 45.415 | 45.415 | 13400.0 |
| 2019-06-05 05:20:00 | AAPL | Stock | 45.4375 | 45.485 | 45.4375 | 45.4725 | 6824.0 |
| 2019-06-05 05:25:00 | AAPL | Stock | 45.4725 | 45.675 | 45.4725 | 45.625 | 51912.0 |
| 2019-06-05 05:30:00 | AAPL | Stock | 45.6125 | 45.6525 | 45.6125 | 45.6275 | 4000.0 |
| 2019-06-05 05:35:00 | AAPL | Stock | 45.625 | 45.625 | 45.625 | 45.625 | 1192.0 |
| 2019-06-05 05:40:00 | AAPL | Stock | 45.67 | 45.675 | 45.6175 | 45.675 | 1200.0 |
| 2019-06-05 05:45:00 | AAPL | Stock | 45.625 | 45.625 | 45.625 | 45.625 | 1724.0 |
| 2019-06-05 05:55:00 | AAPL | Stock | 45.625 | 45.625 | 45.625 | 45.625 | 1628.0 |
| 2019-06-05 06:00:00 | AAPL | Stock | 45.6875 | 45.6875 | 45.595 | 45.595 | 3444.0 |
| 2019-06-05 06:05:00 | AAPL | Stock | 45.6025 | 45.605 | 45.6025 | 45.605 | 4000.0 |
| 2019-06-05 06:10:00 | AAPL | Stock | 45.635 | 45.635 | 45.6125 | 45.615 | 5620.0 |
| 2019-06-05 06:25:00 | AAPL | Stock | 45.6 | 45.6 | 45.6 | 45.6 | 400.0 |
| 2019-06-05 06:35:00 | AAPL | Stock | 45.6125 | 45.625 | 45.6 | 45.625 | 17472.0 |
| 2019-06-05 06:40:00 | AAPL | Stock | 45.625 | 45.625 | 45.625 | 45.625 | 4916.0 |
| 2019-06-05 06:45:00 | AAPL | Stock | 45.625 | 45.625 | 45.625 | 45.625 | 8404.0 |
| 2019-06-05 06:55:00 | AAPL | Stock | 45.74 | 45.75 | 45.665 | 45.665 | 10032.0 |
| 2019-06-05 07:00:00 | AAPL | Stock | 45.6675 | 45.7075 | 45.6675 | 45.6975 | 28476.0 |
| 2019-06-05 07:05:00 | AAPL | Stock | 45.6925 | 45.695 | 45.685 | 45.6875 | 50176.0 |
| 2019-06-05 07:10:00 | AAPL | Stock | 45.665 | 45.72 | 45.65 | 45.6775 | 18648.0 |
| 2019-06-05 07:15:00 | AAPL | Stock | 45.7125 | 45.7225 | 45.6775 | 45.6775 | 72588.0 |
| 2019-06-05 07:20:00 | AAPL | Stock | 45.675 | 45.775 | 45.675 | 45.775 | 25036.0 |
| 2019-06-05 07:25:00 | AAPL | Stock | 45.7925 | 45.7925 | 45.725 | 45.725 | 26708.0 |
| 2019-06-05 07:30:00 | AAPL | Stock | 45.72 | 45.72 | 45.6525 | 45.6525 | 23692.0 |
| 2019-06-05 07:35:00 | AAPL | Stock | 45.6525 | 45.6625 | 45.6375 | 45.6625 | 21940.0 |
| 2019-06-05 07:40:00 | AAPL | Stock | 45.685 | 45.7675 | 45.685 | 45.7625 | 30128.0 |
| 2019-06-05 07:45:00 | AAPL | Stock | 45.7675 | 45.8475 | 45.7575 | 45.815 | 45200.0 |
| 2019-06-05 07:50:00 | AAPL | Stock | 45.845 | 45.87 | 45.75 | 45.8375 | 83688.0 |
| 2019-06-05 07:55:00 | AAPL | Stock | 45.8475 | 45.97 | 45.8475 | 45.9575 | 81892.0 |
| 2019-06-05 08:00:00 | AAPL | Stock | 45.725 | 46.0625 | 45.6355 | 46.05 | 299180.0 |
| 2019-06-05 08:05:00 | AAPL | Stock | 46.06 | 46.0875 | 45.98 | 45.98 | 95028.0 |
| 2019-06-05 08:10:00 | AAPL | Stock | 45.98 | 46.0225 | 45.9575 | 46.0225 | 37540.0 |
| 2019-06-05 08:15:00 | AAPL | Stock | 46.0 | 46.0 | 45.8325 | 45.895 | 241264.0 |
| 2019-06-05 08:20:00 | AAPL | Stock | 45.905 | 45.9375 | 45.8103 | 45.8475 | 158460.0 |
| 2019-06-05 08:25:00 | AAPL | Stock | 45.8475 | 45.8625 | 45.7875 | 45.7875 | 82400.0 |
| 2019-06-05 08:30:00 | AAPL | Stock | 45.8175 | 45.825 | 45.75 | 45.8125 | 103480.0 |
| 2019-06-05 08:35:00 | AAPL | Stock | 45.79 | 45.925 | 45.7822 | 45.8675 | 70620.0 |
| 2019-06-05 08:40:00 | AAPL | Stock | 45.8725 | 45.97 | 45.8625 | 45.9125 | 46960.0 |
| 2019-06-05 08:45:00 | AAPL | Stock | 45.9025 | 45.9225 | 45.8625 | 45.8875 | 61428.0 |
| 2019-06-05 08:50:00 | AAPL | Stock | 45.8875 | 45.8875 | 45.83 | 45.875 | 55228.0 |
| 2019-06-05 08:55:00 | AAPL | Stock | 45.8525 | 45.9125 | 45.85 | 45.8725 | 35052.0 |
| 2019-06-05 09:00:00 | AAPL | Stock | 45.875 | 45.925 | 45.8725 | 45.925 | 25696.0 |
> showing 50 of 359,993 rows — these rows as CSV