PREVIEW / stock_5min / 2023-07-12
file: by_date/stock_5min/2023/2023-07-12.parquet size: 6.9 MB rows: 419,477 symbols: 1,543
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-07-12 04:00:00 | AAPL | Stock | 188.3 | 188.48 | 188.3 | 188.4 | 1831.0 |
| 2023-07-12 04:10:00 | AAPL | Stock | 188.46 | 188.47 | 188.43 | 188.47 | 634.0 |
| 2023-07-12 04:15:00 | AAPL | Stock | 188.47 | 188.5 | 188.47 | 188.5 | 416.0 |
| 2023-07-12 04:20:00 | AAPL | Stock | 188.46 | 188.48 | 188.36 | 188.36 | 1198.0 |
| 2023-07-12 04:25:00 | AAPL | Stock | 188.37 | 188.37 | 188.37 | 188.37 | 195.0 |
| 2023-07-12 04:30:00 | AAPL | Stock | 188.44 | 188.45 | 188.4 | 188.4 | 589.0 |
| 2023-07-12 04:35:00 | AAPL | Stock | 188.4 | 188.4 | 188.4 | 188.4 | 530.0 |
| 2023-07-12 04:40:00 | AAPL | Stock | 188.4 | 188.4 | 188.4 | 188.4 | 209.0 |
| 2023-07-12 04:50:00 | AAPL | Stock | 188.43 | 188.43 | 188.43 | 188.43 | 200.0 |
| 2023-07-12 05:00:00 | AAPL | Stock | 188.46 | 188.46 | 188.45 | 188.46 | 3924.0 |
| 2023-07-12 05:05:00 | AAPL | Stock | 188.64 | 188.64 | 188.64 | 188.64 | 100.0 |
| 2023-07-12 05:10:00 | AAPL | Stock | 188.7 | 188.79 | 188.7 | 188.79 | 4078.0 |
| 2023-07-12 05:15:00 | AAPL | Stock | 188.79 | 188.79 | 188.75 | 188.75 | 667.0 |
| 2023-07-12 05:25:00 | AAPL | Stock | 188.68 | 188.68 | 188.67 | 188.67 | 308.0 |
| 2023-07-12 05:30:00 | AAPL | Stock | 188.73 | 188.73 | 188.69 | 188.69 | 710.0 |
| 2023-07-12 05:35:00 | AAPL | Stock | 188.63 | 188.63 | 188.63 | 188.63 | 200.0 |
| 2023-07-12 05:45:00 | AAPL | Stock | 188.66 | 188.67 | 188.66 | 188.66 | 500.0 |
| 2023-07-12 05:50:00 | AAPL | Stock | 188.6 | 188.6 | 188.59 | 188.59 | 1350.0 |
| 2023-07-12 05:55:00 | AAPL | Stock | 188.61 | 188.61 | 188.61 | 188.61 | 140.0 |
| 2023-07-12 06:00:00 | AAPL | Stock | 188.53 | 188.53 | 188.51 | 188.51 | 972.0 |
| 2023-07-12 06:05:00 | AAPL | Stock | 188.43 | 188.46 | 188.43 | 188.43 | 877.0 |
| 2023-07-12 06:10:00 | AAPL | Stock | 188.47 | 188.47 | 188.47 | 188.47 | 103.0 |
| 2023-07-12 06:15:00 | AAPL | Stock | 188.45 | 188.5 | 188.45 | 188.45 | 1704.0 |
| 2023-07-12 06:20:00 | AAPL | Stock | 188.5 | 188.5 | 188.5 | 188.5 | 701.0 |
| 2023-07-12 06:25:00 | AAPL | Stock | 188.5 | 188.5 | 188.45 | 188.5 | 1935.0 |
| 2023-07-12 06:30:00 | AAPL | Stock | 188.53 | 188.53 | 188.51 | 188.51 | 350.0 |
| 2023-07-12 06:35:00 | AAPL | Stock | 188.55 | 188.55 | 188.55 | 188.55 | 100.0 |
| 2023-07-12 06:40:00 | AAPL | Stock | 188.54 | 188.62 | 188.51 | 188.62 | 778.0 |
| 2023-07-12 06:45:00 | AAPL | Stock | 188.64 | 188.64 | 188.62 | 188.62 | 1655.0 |
| 2023-07-12 06:50:00 | AAPL | Stock | 188.52 | 188.52 | 188.5 | 188.5 | 520.0 |
| 2023-07-12 07:00:00 | AAPL | Stock | 188.52 | 188.67 | 188.52 | 188.65 | 1302.0 |
| 2023-07-12 07:05:00 | AAPL | Stock | 188.6 | 188.6 | 188.52 | 188.6 | 2102.0 |
| 2023-07-12 07:10:00 | AAPL | Stock | 188.64 | 188.64 | 188.61 | 188.61 | 320.0 |
| 2023-07-12 07:15:00 | AAPL | Stock | 188.63 | 188.68 | 188.63 | 188.68 | 2450.0 |
| 2023-07-12 07:20:00 | AAPL | Stock | 188.67 | 188.68 | 188.66 | 188.66 | 2155.0 |
| 2023-07-12 07:25:00 | AAPL | Stock | 188.68 | 188.71 | 188.68 | 188.71 | 1009.0 |
| 2023-07-12 07:30:00 | AAPL | Stock | 188.74 | 188.74 | 188.68 | 188.69 | 3901.0 |
| 2023-07-12 07:35:00 | AAPL | Stock | 188.68 | 188.7 | 188.63 | 188.66 | 3178.0 |
| 2023-07-12 07:40:00 | AAPL | Stock | 188.66 | 188.66 | 188.63 | 188.64 | 1021.0 |
| 2023-07-12 07:45:00 | AAPL | Stock | 188.65 | 188.7 | 188.65 | 188.7 | 502.0 |
| 2023-07-12 07:50:00 | AAPL | Stock | 188.65 | 188.65 | 188.65 | 188.65 | 135.0 |
| 2023-07-12 07:55:00 | AAPL | Stock | 188.68 | 188.69 | 188.65 | 188.65 | 800.0 |
| 2023-07-12 08:00:00 | AAPL | Stock | 188.59 | 188.75 | 188.11 | 188.45 | 27640.0 |
| 2023-07-12 08:05:00 | AAPL | Stock | 188.67 | 188.67 | 188.62 | 188.66 | 9576.0 |
| 2023-07-12 08:10:00 | AAPL | Stock | 188.66 | 188.68 | 188.64 | 188.68 | 2881.0 |
| 2023-07-12 08:15:00 | AAPL | Stock | 188.69 | 188.69 | 188.65 | 188.69 | 4375.0 |
| 2023-07-12 08:20:00 | AAPL | Stock | 188.7 | 188.75 | 188.65 | 188.69 | 4521.0 |
| 2023-07-12 08:25:00 | AAPL | Stock | 188.67 | 188.8 | 188.63 | 188.8 | 20813.0 |
| 2023-07-12 08:30:00 | AAPL | Stock | 188.81 | 189.5 | 188.7 | 189.13 | 138361.0 |
| 2023-07-12 08:35:00 | AAPL | Stock | 189.07 | 189.45 | 189.07 | 189.3 | 96894.0 |
> showing 50 of 419,477 rows — these rows as CSV