PREVIEW / stock_5min / 2023-08-17
file: by_date/stock_5min/2023/2023-08-17.parquet size: 6.6 MB rows: 400,511 symbols: 1,465
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-08-17 04:00:00 | AAPL | Stock | 176.51 | 176.69 | 176.51 | 176.59 | 3871.0 |
| 2023-08-17 04:05:00 | AAPL | Stock | 176.52 | 176.59 | 176.52 | 176.57 | 1221.0 |
| 2023-08-17 04:10:00 | AAPL | Stock | 176.58 | 176.62 | 176.58 | 176.62 | 870.0 |
| 2023-08-17 04:15:00 | AAPL | Stock | 176.62 | 176.62 | 176.62 | 176.62 | 643.0 |
| 2023-08-17 04:20:00 | AAPL | Stock | 176.62 | 176.65 | 176.62 | 176.65 | 2013.0 |
| 2023-08-17 04:25:00 | AAPL | Stock | 176.6 | 176.63 | 176.6 | 176.63 | 516.0 |
| 2023-08-17 04:30:00 | AAPL | Stock | 176.61 | 176.61 | 176.57 | 176.58 | 450.0 |
| 2023-08-17 04:35:00 | AAPL | Stock | 176.58 | 176.69 | 176.58 | 176.69 | 308.0 |
| 2023-08-17 04:40:00 | AAPL | Stock | 176.69 | 176.69 | 176.69 | 176.69 | 624.0 |
| 2023-08-17 04:45:00 | AAPL | Stock | 176.7 | 176.7 | 176.7 | 176.7 | 400.0 |
| 2023-08-17 04:50:00 | AAPL | Stock | 176.8 | 176.86 | 176.8 | 176.8 | 616.0 |
| 2023-08-17 05:25:00 | AAPL | Stock | 176.76 | 176.76 | 176.76 | 176.76 | 510.0 |
| 2023-08-17 05:35:00 | AAPL | Stock | 176.75 | 176.76 | 176.75 | 176.76 | 285.0 |
| 2023-08-17 05:40:00 | AAPL | Stock | 176.77 | 176.78 | 176.77 | 176.78 | 403.0 |
| 2023-08-17 05:45:00 | AAPL | Stock | 176.67 | 176.71 | 176.65 | 176.71 | 2399.0 |
| 2023-08-17 05:50:00 | AAPL | Stock | 176.68 | 176.68 | 176.68 | 176.68 | 1390.0 |
| 2023-08-17 06:00:00 | AAPL | Stock | 176.7 | 176.83 | 176.7 | 176.83 | 1867.0 |
| 2023-08-17 06:05:00 | AAPL | Stock | 176.82 | 176.82 | 176.82 | 176.82 | 157.0 |
| 2023-08-17 06:10:00 | AAPL | Stock | 176.8 | 176.83 | 176.8 | 176.83 | 900.0 |
| 2023-08-17 06:15:00 | AAPL | Stock | 176.79 | 176.79 | 176.79 | 176.79 | 100.0 |
| 2023-08-17 06:20:00 | AAPL | Stock | 176.8 | 176.83 | 176.8 | 176.83 | 1118.0 |
| 2023-08-17 06:25:00 | AAPL | Stock | 176.89 | 176.89 | 176.86 | 176.86 | 990.0 |
| 2023-08-17 06:30:00 | AAPL | Stock | 176.75 | 176.75 | 176.7 | 176.7 | 2679.0 |
| 2023-08-17 06:45:00 | AAPL | Stock | 176.6 | 176.6 | 176.6 | 176.6 | 418.0 |
| 2023-08-17 06:50:00 | AAPL | Stock | 176.58 | 176.67 | 176.51 | 176.65 | 2871.0 |
| 2023-08-17 07:00:00 | AAPL | Stock | 176.65 | 176.68 | 176.62 | 176.67 | 6442.0 |
| 2023-08-17 07:05:00 | AAPL | Stock | 176.74 | 176.75 | 176.72 | 176.75 | 1649.0 |
| 2023-08-17 07:10:00 | AAPL | Stock | 176.78 | 176.79 | 176.7 | 176.7 | 2958.0 |
| 2023-08-17 07:15:00 | AAPL | Stock | 176.71 | 176.73 | 176.71 | 176.73 | 1765.0 |
| 2023-08-17 07:20:00 | AAPL | Stock | 176.73 | 176.73 | 176.68 | 176.68 | 3598.0 |
| 2023-08-17 07:25:00 | AAPL | Stock | 176.71 | 176.71 | 176.68 | 176.68 | 752.0 |
| 2023-08-17 07:30:00 | AAPL | Stock | 176.66 | 176.66 | 176.6 | 176.6 | 4312.0 |
| 2023-08-17 07:35:00 | AAPL | Stock | 176.58 | 176.61 | 176.58 | 176.6 | 2591.0 |
| 2023-08-17 07:40:00 | AAPL | Stock | 176.59 | 176.62 | 176.59 | 176.62 | 1359.0 |
| 2023-08-17 07:45:00 | AAPL | Stock | 176.64 | 176.74 | 176.64 | 176.73 | 4487.0 |
| 2023-08-17 07:50:00 | AAPL | Stock | 176.71 | 176.71 | 176.69 | 176.69 | 208.0 |
| 2023-08-17 07:55:00 | AAPL | Stock | 176.72 | 176.74 | 176.72 | 176.74 | 200.0 |
| 2023-08-17 08:00:00 | AAPL | Stock | 176.65 | 176.8 | 176.1 | 176.5 | 52093.0 |
| 2023-08-17 08:05:00 | AAPL | Stock | 176.51 | 176.54 | 176.45 | 176.5 | 13311.0 |
| 2023-08-17 08:10:00 | AAPL | Stock | 176.49 | 176.5999 | 176.49 | 176.54 | 5730.0 |
| 2023-08-17 08:15:00 | AAPL | Stock | 176.56 | 176.67 | 176.54 | 176.63 | 5286.0 |
| 2023-08-17 08:20:00 | AAPL | Stock | 176.62 | 176.7 | 176.62 | 176.7 | 2673.0 |
| 2023-08-17 08:25:00 | AAPL | Stock | 176.7 | 176.739 | 176.67 | 176.73 | 4458.0 |
| 2023-08-17 08:30:00 | AAPL | Stock | 176.73 | 176.82 | 176.57 | 176.75 | 216693.0 |
| 2023-08-17 08:35:00 | AAPL | Stock | 176.75 | 176.9 | 176.72 | 176.72 | 32949.0 |
| 2023-08-17 08:40:00 | AAPL | Stock | 176.73 | 176.89 | 176.72 | 176.89 | 13008.0 |
| 2023-08-17 08:45:00 | AAPL | Stock | 176.88 | 176.97 | 176.84 | 176.91 | 14201.0 |
| 2023-08-17 08:50:00 | AAPL | Stock | 176.94 | 176.9772 | 176.84 | 176.9199 | 9700.0 |
| 2023-08-17 08:55:00 | AAPL | Stock | 176.92 | 176.99 | 176.92 | 176.94 | 4862.0 |
| 2023-08-17 09:00:00 | AAPL | Stock | 176.92 | 176.96 | 176.77 | 176.83 | 17685.0 |
> showing 50 of 400,511 rows — these rows as CSV