PREVIEW / stock_5min / 2019-09-26
file: by_date/stock_5min/2019/2019-09-26.parquet size: 5.4 MB rows: 348,195 symbols: 2,506
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-09-26 04:00:00 | AAPL | Stock | 55.25 | 55.25 | 55.25 | 55.25 | 400.0 |
| 2019-09-26 04:10:00 | AAPL | Stock | 55.2425 | 55.2575 | 55.2425 | 55.2575 | 3200.0 |
| 2019-09-26 04:20:00 | AAPL | Stock | 55.25 | 55.25 | 55.25 | 55.25 | 400.0 |
| 2019-09-26 04:40:00 | AAPL | Stock | 55.2725 | 55.31 | 55.2675 | 55.305 | 7420.0 |
| 2019-09-26 04:45:00 | AAPL | Stock | 55.35 | 55.375 | 55.35 | 55.37 | 6756.0 |
| 2019-09-26 05:25:00 | AAPL | Stock | 55.3 | 55.3 | 55.3 | 55.3 | 436.0 |
| 2019-09-26 05:30:00 | AAPL | Stock | 55.2425 | 55.2425 | 55.2 | 55.235 | 9776.0 |
| 2019-09-26 05:35:00 | AAPL | Stock | 55.2125 | 55.2125 | 55.175 | 55.175 | 4600.0 |
| 2019-09-26 06:10:00 | AAPL | Stock | 55.205 | 55.205 | 55.205 | 55.205 | 800.0 |
| 2019-09-26 06:25:00 | AAPL | Stock | 55.14 | 55.14 | 55.125 | 55.14 | 10736.0 |
| 2019-09-26 06:30:00 | AAPL | Stock | 55.155 | 55.155 | 55.155 | 55.155 | 3996.0 |
| 2019-09-26 06:35:00 | AAPL | Stock | 55.175 | 55.175 | 55.14 | 55.14 | 2544.0 |
| 2019-09-26 06:40:00 | AAPL | Stock | 55.185 | 55.185 | 55.185 | 55.185 | 2788.0 |
| 2019-09-26 06:55:00 | AAPL | Stock | 55.175 | 55.175 | 55.175 | 55.175 | 5592.0 |
| 2019-09-26 07:00:00 | AAPL | Stock | 55.175 | 55.2 | 55.175 | 55.175 | 15400.0 |
| 2019-09-26 07:05:00 | AAPL | Stock | 55.15 | 55.1725 | 55.15 | 55.1725 | 1796.0 |
| 2019-09-26 07:20:00 | AAPL | Stock | 55.2 | 55.2125 | 55.2 | 55.2125 | 6328.0 |
| 2019-09-26 07:25:00 | AAPL | Stock | 55.225 | 55.2325 | 55.225 | 55.2325 | 4400.0 |
| 2019-09-26 07:30:00 | AAPL | Stock | 55.1925 | 55.1925 | 55.1925 | 55.1925 | 400.0 |
| 2019-09-26 07:35:00 | AAPL | Stock | 55.2175 | 55.2225 | 55.2175 | 55.2175 | 1200.0 |
| 2019-09-26 07:40:00 | AAPL | Stock | 55.205 | 55.2075 | 55.1875 | 55.1875 | 2760.0 |
| 2019-09-26 07:45:00 | AAPL | Stock | 55.2125 | 55.225 | 55.21 | 55.21 | 14800.0 |
| 2019-09-26 07:50:00 | AAPL | Stock | 55.2225 | 55.2225 | 55.2225 | 55.2225 | 2800.0 |
| 2019-09-26 07:55:00 | AAPL | Stock | 55.23 | 55.23 | 55.23 | 55.23 | 800.0 |
| 2019-09-26 08:00:00 | AAPL | Stock | 55.1775 | 55.2325 | 55.145 | 55.19 | 68848.0 |
| 2019-09-26 08:05:00 | AAPL | Stock | 55.19 | 55.19 | 55.175 | 55.175 | 18744.0 |
| 2019-09-26 08:10:00 | AAPL | Stock | 55.1625 | 55.1625 | 55.15 | 55.155 | 14380.0 |
| 2019-09-26 08:15:00 | AAPL | Stock | 55.1575 | 55.1875 | 55.155 | 55.1875 | 18284.0 |
| 2019-09-26 08:20:00 | AAPL | Stock | 55.1725 | 55.19 | 55.1625 | 55.1625 | 17416.0 |
| 2019-09-26 08:25:00 | AAPL | Stock | 55.155 | 55.155 | 55.1425 | 55.15 | 8936.0 |
| 2019-09-26 08:30:00 | AAPL | Stock | 55.15 | 55.155 | 55.14 | 55.14 | 9372.0 |
| 2019-09-26 08:35:00 | AAPL | Stock | 55.14 | 55.1475 | 55.08 | 55.105 | 50340.0 |
| 2019-09-26 08:40:00 | AAPL | Stock | 55.0925 | 55.12 | 55.0275 | 55.0975 | 25788.0 |
| 2019-09-26 08:45:00 | AAPL | Stock | 55.095 | 55.1 | 55.05 | 55.06 | 40184.0 |
| 2019-09-26 08:50:00 | AAPL | Stock | 55.0825 | 55.1 | 55.08 | 55.1 | 18800.0 |
| 2019-09-26 08:55:00 | AAPL | Stock | 55.0975 | 55.1575 | 55.0875 | 55.1075 | 8852.0 |
| 2019-09-26 09:00:00 | AAPL | Stock | 55.0775 | 55.1 | 55.05 | 55.05 | 11880.0 |
| 2019-09-26 09:05:00 | AAPL | Stock | 55.0725 | 55.085 | 55.0375 | 55.0375 | 61736.0 |
| 2019-09-26 09:10:00 | AAPL | Stock | 55.025 | 55.0625 | 55.025 | 55.0325 | 59244.0 |
| 2019-09-26 09:15:00 | AAPL | Stock | 55.0325 | 55.0725 | 55.03 | 55.05 | 18820.0 |
| 2019-09-26 09:20:00 | AAPL | Stock | 55.05 | 55.05 | 55.0375 | 55.05 | 24784.0 |
| 2019-09-26 09:25:00 | AAPL | Stock | 55.05 | 55.05 | 54.9575 | 54.9575 | 63732.0 |
| 2019-09-26 09:30:00 | AAPL | Stock | 54.97 | 55.0375 | 54.75 | 54.7675 | 3031420.0 |
| 2019-09-26 09:35:00 | AAPL | Stock | 54.7675 | 54.8625 | 54.7075 | 54.8112 | 1829892.0 |
| 2019-09-26 09:40:00 | AAPL | Stock | 54.81 | 54.8675 | 54.725 | 54.801 | 1152756.0 |
| 2019-09-26 09:45:00 | AAPL | Stock | 54.7925 | 54.8675 | 54.755 | 54.86 | 969628.0 |
| 2019-09-26 09:50:00 | AAPL | Stock | 54.855 | 54.8555 | 54.7425 | 54.7555 | 895352.0 |
| 2019-09-26 09:55:00 | AAPL | Stock | 54.7518 | 54.8275 | 54.735 | 54.8075 | 1023836.0 |
| 2019-09-26 10:00:00 | AAPL | Stock | 54.8088 | 54.915 | 54.79 | 54.8798 | 1205280.0 |
| 2019-09-26 10:05:00 | AAPL | Stock | 54.8875 | 54.94 | 54.815 | 54.88 | 909864.0 |
> showing 50 of 348,195 rows — these rows as CSV