PREVIEW / stock_5min / 2022-05-04
file: by_date/stock_5min/2022/2022-05-04.parquet size: 7.2 MB rows: 447,956 symbols: 2,448
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 |
|---|---|---|---|---|---|---|---|
| 2022-05-04 04:00:00 | AAPL | Stock | 159.88 | 159.88 | 159.7 | 159.7 | 1006.0 |
| 2022-05-04 04:05:00 | AAPL | Stock | 159.6 | 159.72 | 159.6 | 159.72 | 1406.0 |
| 2022-05-04 04:10:00 | AAPL | Stock | 159.75 | 159.8 | 159.75 | 159.77 | 1617.0 |
| 2022-05-04 04:15:00 | AAPL | Stock | 159.75 | 159.75 | 159.68 | 159.68 | 836.0 |
| 2022-05-04 04:20:00 | AAPL | Stock | 159.6 | 159.6 | 159.6 | 159.6 | 280.0 |
| 2022-05-04 04:25:00 | AAPL | Stock | 159.6 | 159.6 | 159.6 | 159.6 | 658.0 |
| 2022-05-04 04:30:00 | AAPL | Stock | 159.65 | 159.65 | 159.64 | 159.64 | 200.0 |
| 2022-05-04 04:35:00 | AAPL | Stock | 159.43 | 159.43 | 159.43 | 159.43 | 418.0 |
| 2022-05-04 04:55:00 | AAPL | Stock | 159.55 | 159.55 | 159.52 | 159.52 | 388.0 |
| 2022-05-04 05:00:00 | AAPL | Stock | 159.38 | 159.38 | 159.38 | 159.38 | 122.0 |
| 2022-05-04 05:05:00 | AAPL | Stock | 159.22 | 159.22 | 159.22 | 159.22 | 100.0 |
| 2022-05-04 05:20:00 | AAPL | Stock | 159.28 | 159.28 | 159.25 | 159.25 | 338.0 |
| 2022-05-04 05:25:00 | AAPL | Stock | 159.33 | 159.6 | 159.33 | 159.6 | 876.0 |
| 2022-05-04 05:30:00 | AAPL | Stock | 159.6 | 159.6 | 159.6 | 159.6 | 124.0 |
| 2022-05-04 05:35:00 | AAPL | Stock | 159.47 | 159.47 | 159.47 | 159.47 | 227.0 |
| 2022-05-04 05:40:00 | AAPL | Stock | 159.54 | 159.54 | 159.54 | 159.54 | 305.0 |
| 2022-05-04 05:45:00 | AAPL | Stock | 159.67 | 159.7 | 159.67 | 159.7 | 420.0 |
| 2022-05-04 05:50:00 | AAPL | Stock | 159.7 | 159.7 | 159.7 | 159.7 | 134.0 |
| 2022-05-04 05:55:00 | AAPL | Stock | 159.7 | 159.75 | 159.67 | 159.67 | 1207.0 |
| 2022-05-04 06:00:00 | AAPL | Stock | 159.75 | 159.85 | 159.75 | 159.85 | 928.0 |
| 2022-05-04 06:05:00 | AAPL | Stock | 159.82 | 159.82 | 159.82 | 159.82 | 175.0 |
| 2022-05-04 06:15:00 | AAPL | Stock | 159.8 | 159.8 | 159.8 | 159.8 | 113.0 |
| 2022-05-04 06:20:00 | AAPL | Stock | 159.75 | 159.75 | 159.75 | 159.75 | 338.0 |
| 2022-05-04 06:25:00 | AAPL | Stock | 159.67 | 159.67 | 159.67 | 159.67 | 400.0 |
| 2022-05-04 06:30:00 | AAPL | Stock | 159.63 | 159.63 | 159.63 | 159.63 | 499.0 |
| 2022-05-04 06:35:00 | AAPL | Stock | 159.7 | 159.77 | 159.68 | 159.73 | 2091.0 |
| 2022-05-04 06:40:00 | AAPL | Stock | 159.75 | 159.79 | 159.75 | 159.79 | 883.0 |
| 2022-05-04 06:45:00 | AAPL | Stock | 159.73 | 159.73 | 159.73 | 159.73 | 347.0 |
| 2022-05-04 06:50:00 | AAPL | Stock | 159.81 | 159.81 | 159.73 | 159.73 | 2079.0 |
| 2022-05-04 06:55:00 | AAPL | Stock | 159.85 | 160.0 | 159.85 | 159.94 | 2268.0 |
| 2022-05-04 07:00:00 | AAPL | Stock | 159.84 | 159.95 | 159.75 | 159.75 | 17155.0 |
| 2022-05-04 07:05:00 | AAPL | Stock | 159.73 | 159.75 | 159.69 | 159.75 | 6523.0 |
| 2022-05-04 07:10:00 | AAPL | Stock | 159.73 | 159.8 | 159.73 | 159.8 | 1574.0 |
| 2022-05-04 07:20:00 | AAPL | Stock | 159.87 | 160.1 | 159.87 | 160.05 | 7613.0 |
| 2022-05-04 07:25:00 | AAPL | Stock | 160.14 | 160.16 | 160.0 | 160.0 | 3891.0 |
| 2022-05-04 07:30:00 | AAPL | Stock | 160.1 | 160.16 | 160.05 | 160.11 | 6247.0 |
| 2022-05-04 07:35:00 | AAPL | Stock | 160.13 | 160.13 | 160.09 | 160.09 | 3938.0 |
| 2022-05-04 07:40:00 | AAPL | Stock | 160.1 | 160.1 | 160.0 | 160.0 | 5297.0 |
| 2022-05-04 07:45:00 | AAPL | Stock | 159.91 | 159.94 | 159.91 | 159.91 | 500.0 |
| 2022-05-04 07:50:00 | AAPL | Stock | 159.93 | 159.96 | 159.87 | 159.88 | 2357.0 |
| 2022-05-04 07:55:00 | AAPL | Stock | 159.84 | 159.84 | 159.81 | 159.81 | 1163.0 |
| 2022-05-04 08:00:00 | AAPL | Stock | 159.9452 | 160.17 | 159.73 | 159.8601 | 67738.0 |
| 2022-05-04 08:05:00 | AAPL | Stock | 159.87 | 159.9309 | 159.87 | 159.91 | 4437.0 |
| 2022-05-04 08:10:00 | AAPL | Stock | 159.91 | 159.91 | 159.75 | 159.77 | 25364.0 |
| 2022-05-04 08:15:00 | AAPL | Stock | 159.9 | 159.9 | 159.72 | 159.75 | 9762.0 |
| 2022-05-04 08:20:00 | AAPL | Stock | 159.73 | 159.73 | 159.51 | 159.5504 | 9308.0 |
| 2022-05-04 08:25:00 | AAPL | Stock | 159.55 | 159.68 | 159.55 | 159.63 | 4289.0 |
| 2022-05-04 08:30:00 | AAPL | Stock | 159.68 | 159.82 | 159.48 | 159.55 | 1393813.0 |
| 2022-05-04 08:35:00 | AAPL | Stock | 159.5 | 159.65 | 159.5 | 159.65 | 7124.0 |
| 2022-05-04 08:40:00 | AAPL | Stock | 159.63 | 159.63 | 159.55 | 159.55 | 9589.0 |
> showing 50 of 447,956 rows — these rows as CSV