PREVIEW / stock_5min / 2021-07-13
file: by_date/stock_5min/2021/2021-07-13.parquet size: 7.4 MB rows: 458,088 symbols: 2,891
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 |
|---|---|---|---|---|---|---|---|
| 2021-07-13 04:00:00 | AAPL | Stock | 144.0 | 144.15 | 143.86 | 143.9 | 12549.0 |
| 2021-07-13 04:05:00 | AAPL | Stock | 143.9 | 144.01 | 143.9 | 143.96 | 2744.0 |
| 2021-07-13 04:10:00 | AAPL | Stock | 144.0 | 144.17 | 144.0 | 144.17 | 450.0 |
| 2021-07-13 04:15:00 | AAPL | Stock | 144.03 | 144.03 | 144.03 | 144.03 | 204.0 |
| 2021-07-13 04:20:00 | AAPL | Stock | 144.06 | 144.2 | 144.06 | 144.16 | 715.0 |
| 2021-07-13 04:25:00 | AAPL | Stock | 144.19 | 144.2 | 144.19 | 144.2 | 942.0 |
| 2021-07-13 04:30:00 | AAPL | Stock | 144.2 | 144.24 | 144.19 | 144.19 | 2436.0 |
| 2021-07-13 04:35:00 | AAPL | Stock | 144.18 | 144.18 | 144.18 | 144.18 | 100.0 |
| 2021-07-13 04:45:00 | AAPL | Stock | 144.2 | 144.27 | 144.2 | 144.22 | 2767.0 |
| 2021-07-13 04:50:00 | AAPL | Stock | 144.2 | 144.28 | 144.2 | 144.28 | 783.0 |
| 2021-07-13 04:55:00 | AAPL | Stock | 144.42 | 144.42 | 144.41 | 144.41 | 1165.0 |
| 2021-07-13 05:00:00 | AAPL | Stock | 144.47 | 144.47 | 144.4 | 144.45 | 1273.0 |
| 2021-07-13 05:05:00 | AAPL | Stock | 144.43 | 144.43 | 144.42 | 144.42 | 806.0 |
| 2021-07-13 05:10:00 | AAPL | Stock | 144.42 | 144.45 | 144.42 | 144.45 | 546.0 |
| 2021-07-13 05:15:00 | AAPL | Stock | 144.5 | 144.71 | 144.5 | 144.71 | 1188.0 |
| 2021-07-13 05:25:00 | AAPL | Stock | 144.61 | 144.68 | 144.6 | 144.61 | 1146.0 |
| 2021-07-13 05:30:00 | AAPL | Stock | 144.68 | 144.68 | 144.62 | 144.62 | 300.0 |
| 2021-07-13 05:35:00 | AAPL | Stock | 144.6 | 144.69 | 144.6 | 144.69 | 1063.0 |
| 2021-07-13 05:40:00 | AAPL | Stock | 144.69 | 144.69 | 144.6 | 144.6 | 1611.0 |
| 2021-07-13 05:45:00 | AAPL | Stock | 144.66 | 144.66 | 144.66 | 144.66 | 200.0 |
| 2021-07-13 05:55:00 | AAPL | Stock | 144.66 | 144.8 | 144.66 | 144.8 | 3073.0 |
| 2021-07-13 06:00:00 | AAPL | Stock | 144.8 | 144.85 | 144.8 | 144.8 | 2515.0 |
| 2021-07-13 06:05:00 | AAPL | Stock | 144.81 | 144.81 | 144.66 | 144.66 | 6253.0 |
| 2021-07-13 06:10:00 | AAPL | Stock | 144.65 | 144.65 | 144.6 | 144.6 | 400.0 |
| 2021-07-13 06:15:00 | AAPL | Stock | 144.59 | 144.59 | 144.58 | 144.58 | 200.0 |
| 2021-07-13 06:20:00 | AAPL | Stock | 144.65 | 144.65 | 144.65 | 144.65 | 298.0 |
| 2021-07-13 06:25:00 | AAPL | Stock | 144.57 | 144.57 | 144.57 | 144.57 | 400.0 |
| 2021-07-13 06:30:00 | AAPL | Stock | 144.6 | 144.68 | 144.6 | 144.68 | 1591.0 |
| 2021-07-13 06:35:00 | AAPL | Stock | 144.61 | 144.61 | 144.6 | 144.6 | 4387.0 |
| 2021-07-13 06:40:00 | AAPL | Stock | 144.68 | 144.69 | 144.68 | 144.69 | 200.0 |
| 2021-07-13 06:45:00 | AAPL | Stock | 144.7 | 144.7 | 144.67 | 144.68 | 2323.0 |
| 2021-07-13 06:55:00 | AAPL | Stock | 144.68 | 144.7 | 144.68 | 144.7 | 943.0 |
| 2021-07-13 07:00:00 | AAPL | Stock | 144.71 | 144.9 | 144.7 | 144.7 | 9753.0 |
| 2021-07-13 07:05:00 | AAPL | Stock | 144.74 | 144.8 | 144.74 | 144.8 | 6559.0 |
| 2021-07-13 07:10:00 | AAPL | Stock | 144.79 | 144.98 | 144.79 | 144.95 | 19749.0 |
| 2021-07-13 07:15:00 | AAPL | Stock | 144.97 | 144.97 | 144.91 | 144.91 | 3196.0 |
| 2021-07-13 07:20:00 | AAPL | Stock | 144.94 | 144.99 | 144.94 | 144.99 | 9899.0 |
| 2021-07-13 07:25:00 | AAPL | Stock | 144.99 | 144.99 | 144.96 | 144.96 | 6745.0 |
| 2021-07-13 07:30:00 | AAPL | Stock | 144.97 | 144.97 | 144.96 | 144.96 | 600.0 |
| 2021-07-13 07:35:00 | AAPL | Stock | 144.97 | 144.97 | 144.95 | 144.95 | 3635.0 |
| 2021-07-13 07:40:00 | AAPL | Stock | 144.95 | 144.95 | 144.89 | 144.91 | 9645.0 |
| 2021-07-13 07:45:00 | AAPL | Stock | 144.89 | 144.95 | 144.89 | 144.95 | 2347.0 |
| 2021-07-13 07:50:00 | AAPL | Stock | 144.95 | 144.95 | 144.85 | 144.9 | 5049.0 |
| 2021-07-13 07:55:00 | AAPL | Stock | 144.87 | 144.9 | 144.87 | 144.87 | 1780.0 |
| 2021-07-13 08:00:00 | AAPL | Stock | 144.8701 | 145.0 | 144.139 | 144.77 | 87964.0 |
| 2021-07-13 08:05:00 | AAPL | Stock | 144.75 | 144.81 | 144.7242 | 144.78 | 18322.0 |
| 2021-07-13 08:10:00 | AAPL | Stock | 144.77 | 144.78 | 144.73 | 144.73 | 8273.0 |
| 2021-07-13 08:15:00 | AAPL | Stock | 144.75 | 144.78 | 144.7337 | 144.7499 | 6521.0 |
| 2021-07-13 08:20:00 | AAPL | Stock | 144.72 | 144.7342 | 144.68 | 144.69 | 18571.0 |
| 2021-07-13 08:25:00 | AAPL | Stock | 144.69 | 144.75 | 144.68 | 144.7 | 13239.0 |
> showing 50 of 458,088 rows — these rows as CSV