PREVIEW / stock_5min / 2023-03-27
file: by_date/stock_5min/2023/2023-03-27.parquet size: 6.6 MB rows: 410,294 symbols: 1,770
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 |
|---|---|---|---|---|---|---|---|
| 2023-03-27 04:00:00 | AAPL | Stock | 160.25 | 160.25 | 159.38 | 159.55 | 5297.0 |
| 2023-03-27 04:05:00 | AAPL | Stock | 159.55 | 159.59 | 159.55 | 159.59 | 389.0 |
| 2023-03-27 04:10:00 | AAPL | Stock | 159.85 | 159.95 | 159.76 | 159.95 | 3131.0 |
| 2023-03-27 04:15:00 | AAPL | Stock | 159.84 | 159.89 | 159.84 | 159.89 | 400.0 |
| 2023-03-27 04:20:00 | AAPL | Stock | 159.86 | 159.87 | 159.81 | 159.83 | 6428.0 |
| 2023-03-27 04:25:00 | AAPL | Stock | 159.74 | 159.74 | 159.73 | 159.73 | 300.0 |
| 2023-03-27 04:35:00 | AAPL | Stock | 159.77 | 159.85 | 159.77 | 159.82 | 836.0 |
| 2023-03-27 04:40:00 | AAPL | Stock | 159.82 | 159.82 | 159.75 | 159.75 | 1963.0 |
| 2023-03-27 04:45:00 | AAPL | Stock | 159.8 | 159.8 | 159.8 | 159.8 | 100.0 |
| 2023-03-27 04:50:00 | AAPL | Stock | 159.73 | 159.84 | 159.73 | 159.84 | 1622.0 |
| 2023-03-27 04:55:00 | AAPL | Stock | 159.83 | 159.83 | 159.82 | 159.82 | 200.0 |
| 2023-03-27 05:00:00 | AAPL | Stock | 159.79 | 159.79 | 159.79 | 159.79 | 134.0 |
| 2023-03-27 05:10:00 | AAPL | Stock | 159.81 | 159.81 | 159.52 | 159.61 | 2882.0 |
| 2023-03-27 05:15:00 | AAPL | Stock | 159.71 | 159.71 | 159.71 | 159.71 | 749.0 |
| 2023-03-27 05:20:00 | AAPL | Stock | 159.71 | 159.75 | 159.71 | 159.75 | 1446.0 |
| 2023-03-27 05:25:00 | AAPL | Stock | 159.7 | 159.7 | 159.7 | 159.7 | 411.0 |
| 2023-03-27 05:30:00 | AAPL | Stock | 159.7 | 159.7 | 159.66 | 159.66 | 258.0 |
| 2023-03-27 05:35:00 | AAPL | Stock | 159.66 | 159.69 | 159.66 | 159.66 | 600.0 |
| 2023-03-27 05:40:00 | AAPL | Stock | 159.62 | 159.68 | 159.62 | 159.68 | 640.0 |
| 2023-03-27 05:45:00 | AAPL | Stock | 159.78 | 159.87 | 159.78 | 159.87 | 3897.0 |
| 2023-03-27 05:50:00 | AAPL | Stock | 159.84 | 159.84 | 159.63 | 159.63 | 992.0 |
| 2023-03-27 05:55:00 | AAPL | Stock | 159.63 | 159.63 | 159.6 | 159.6 | 817.0 |
| 2023-03-27 06:00:00 | AAPL | Stock | 159.77 | 159.87 | 159.77 | 159.87 | 934.0 |
| 2023-03-27 06:10:00 | AAPL | Stock | 159.95 | 160.11 | 159.86 | 159.89 | 5065.0 |
| 2023-03-27 06:20:00 | AAPL | Stock | 159.87 | 159.87 | 159.86 | 159.86 | 309.0 |
| 2023-03-27 06:25:00 | AAPL | Stock | 159.88 | 159.88 | 159.85 | 159.85 | 641.0 |
| 2023-03-27 06:30:00 | AAPL | Stock | 159.8 | 159.8 | 159.66 | 159.66 | 405.0 |
| 2023-03-27 06:35:00 | AAPL | Stock | 159.82 | 159.84 | 159.82 | 159.84 | 400.0 |
| 2023-03-27 06:40:00 | AAPL | Stock | 159.81 | 159.81 | 159.8 | 159.8 | 250.0 |
| 2023-03-27 06:45:00 | AAPL | Stock | 159.77 | 159.9 | 159.77 | 159.9 | 257.0 |
| 2023-03-27 06:50:00 | AAPL | Stock | 159.84 | 159.84 | 159.84 | 159.84 | 100.0 |
| 2023-03-27 07:00:00 | AAPL | Stock | 159.88 | 160.0 | 159.85 | 159.86 | 15356.0 |
| 2023-03-27 07:05:00 | AAPL | Stock | 159.86 | 160.1 | 159.84 | 160.05 | 9415.0 |
| 2023-03-27 07:10:00 | AAPL | Stock | 160.1 | 160.18 | 160.1 | 160.17 | 2523.0 |
| 2023-03-27 07:15:00 | AAPL | Stock | 160.15 | 160.22 | 160.1 | 160.22 | 7367.0 |
| 2023-03-27 07:20:00 | AAPL | Stock | 160.21 | 160.21 | 160.1 | 160.1 | 1387.0 |
| 2023-03-27 07:25:00 | AAPL | Stock | 160.08 | 160.19 | 160.08 | 160.18 | 3285.0 |
| 2023-03-27 07:30:00 | AAPL | Stock | 160.15 | 160.15 | 160.05 | 160.06 | 5494.0 |
| 2023-03-27 07:35:00 | AAPL | Stock | 160.06 | 160.06 | 160.0 | 160.06 | 19245.0 |
| 2023-03-27 07:40:00 | AAPL | Stock | 160.12 | 160.15 | 159.97 | 160.07 | 18029.0 |
| 2023-03-27 07:45:00 | AAPL | Stock | 160.05 | 160.12 | 160.03 | 160.03 | 7335.0 |
| 2023-03-27 07:50:00 | AAPL | Stock | 160.05 | 160.05 | 159.92 | 159.92 | 6588.0 |
| 2023-03-27 07:55:00 | AAPL | Stock | 159.99 | 160.12 | 159.97 | 160.12 | 2051.0 |
| 2023-03-27 08:00:00 | AAPL | Stock | 160.11 | 160.25 | 159.84 | 159.94 | 70833.0 |
| 2023-03-27 08:05:00 | AAPL | Stock | 159.95 | 160.15 | 159.94 | 160.07 | 12623.0 |
| 2023-03-27 08:10:00 | AAPL | Stock | 160.05 | 160.1 | 160.0 | 160.0 | 4631.0 |
| 2023-03-27 08:15:00 | AAPL | Stock | 160.05 | 160.05 | 159.8 | 159.89 | 18800.0 |
| 2023-03-27 08:20:00 | AAPL | Stock | 159.88 | 159.93 | 159.85 | 159.92 | 4465.0 |
| 2023-03-27 08:25:00 | AAPL | Stock | 159.95 | 159.97 | 159.9 | 159.92 | 12449.0 |
| 2023-03-27 08:30:00 | AAPL | Stock | 159.92 | 159.9499 | 159.84 | 159.9 | 8107.0 |
> showing 50 of 410,294 rows — these rows as CSV