PREVIEW / stock_5min / 2023-10-31
file: by_date/stock_5min/2023/2023-10-31.parquet size: 6.3 MB rows: 387,562 symbols: 1,340
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-10-31 04:00:00 | AAPL | Stock | 169.6 | 169.6 | 169.4 | 169.41 | 2501.0 |
| 2023-10-31 04:05:00 | AAPL | Stock | 169.28 | 169.28 | 169.28 | 169.28 | 952.0 |
| 2023-10-31 04:10:00 | AAPL | Stock | 169.48 | 169.48 | 169.47 | 169.48 | 1050.0 |
| 2023-10-31 04:15:00 | AAPL | Stock | 169.42 | 169.46 | 169.42 | 169.42 | 334.0 |
| 2023-10-31 04:20:00 | AAPL | Stock | 169.42 | 169.42 | 169.39 | 169.39 | 474.0 |
| 2023-10-31 04:25:00 | AAPL | Stock | 169.47 | 169.48 | 169.45 | 169.45 | 553.0 |
| 2023-10-31 04:30:00 | AAPL | Stock | 169.56 | 169.59 | 169.54 | 169.54 | 920.0 |
| 2023-10-31 04:35:00 | AAPL | Stock | 169.55 | 169.6 | 169.55 | 169.6 | 550.0 |
| 2023-10-31 04:40:00 | AAPL | Stock | 169.73 | 169.73 | 169.73 | 169.73 | 750.0 |
| 2023-10-31 04:50:00 | AAPL | Stock | 169.71 | 169.8 | 169.71 | 169.8 | 3783.0 |
| 2023-10-31 05:00:00 | AAPL | Stock | 169.76 | 169.76 | 169.76 | 169.76 | 100.0 |
| 2023-10-31 05:05:00 | AAPL | Stock | 169.8 | 169.8 | 169.7 | 169.7 | 1499.0 |
| 2023-10-31 05:15:00 | AAPL | Stock | 169.65 | 169.65 | 169.65 | 169.65 | 150.0 |
| 2023-10-31 05:25:00 | AAPL | Stock | 169.6 | 169.6 | 169.6 | 169.6 | 510.0 |
| 2023-10-31 05:30:00 | AAPL | Stock | 169.63 | 169.75 | 169.63 | 169.75 | 846.0 |
| 2023-10-31 05:40:00 | AAPL | Stock | 169.77 | 169.82 | 169.77 | 169.82 | 1363.0 |
| 2023-10-31 05:45:00 | AAPL | Stock | 169.79 | 169.79 | 169.78 | 169.78 | 1387.0 |
| 2023-10-31 05:50:00 | AAPL | Stock | 169.76 | 169.8 | 169.76 | 169.8 | 500.0 |
| 2023-10-31 05:55:00 | AAPL | Stock | 169.82 | 169.82 | 169.8 | 169.8 | 770.0 |
| 2023-10-31 06:00:00 | AAPL | Stock | 169.88 | 169.9 | 169.88 | 169.9 | 469.0 |
| 2023-10-31 06:10:00 | AAPL | Stock | 169.88 | 169.96 | 169.88 | 169.96 | 284.0 |
| 2023-10-31 06:15:00 | AAPL | Stock | 169.96 | 170.0 | 169.96 | 170.0 | 911.0 |
| 2023-10-31 06:20:00 | AAPL | Stock | 170.15 | 170.15 | 170.13 | 170.13 | 272.0 |
| 2023-10-31 06:25:00 | AAPL | Stock | 170.0 | 170.0 | 170.0 | 170.0 | 224.0 |
| 2023-10-31 06:30:00 | AAPL | Stock | 170.0 | 170.0 | 169.98 | 169.98 | 591.0 |
| 2023-10-31 06:35:00 | AAPL | Stock | 169.82 | 169.82 | 169.81 | 169.81 | 1008.0 |
| 2023-10-31 06:40:00 | AAPL | Stock | 169.95 | 169.95 | 169.95 | 169.95 | 100.0 |
| 2023-10-31 07:00:00 | AAPL | Stock | 169.91 | 170.0 | 169.9 | 169.99 | 4048.0 |
| 2023-10-31 07:05:00 | AAPL | Stock | 169.99 | 169.99 | 169.85 | 169.85 | 2354.0 |
| 2023-10-31 07:10:00 | AAPL | Stock | 169.88 | 170.1 | 169.86 | 170.1 | 3514.0 |
| 2023-10-31 07:15:00 | AAPL | Stock | 170.07 | 170.07 | 170.03 | 170.03 | 229.0 |
| 2023-10-31 07:20:00 | AAPL | Stock | 170.01 | 170.01 | 169.81 | 169.81 | 24758.0 |
| 2023-10-31 07:25:00 | AAPL | Stock | 169.91 | 169.91 | 169.63 | 169.68 | 4832.0 |
| 2023-10-31 07:30:00 | AAPL | Stock | 169.73 | 169.73 | 169.73 | 169.73 | 200.0 |
| 2023-10-31 07:35:00 | AAPL | Stock | 169.74 | 169.74 | 169.6 | 169.6 | 1630.0 |
| 2023-10-31 07:40:00 | AAPL | Stock | 169.6 | 169.62 | 169.5 | 169.5 | 2792.0 |
| 2023-10-31 07:45:00 | AAPL | Stock | 169.55 | 169.63 | 169.55 | 169.55 | 2490.0 |
| 2023-10-31 07:50:00 | AAPL | Stock | 169.55 | 169.57 | 169.52 | 169.57 | 1320.0 |
| 2023-10-31 07:55:00 | AAPL | Stock | 169.57 | 169.57 | 169.5 | 169.5 | 3873.0 |
| 2023-10-31 08:00:00 | AAPL | Stock | 169.45 | 170.05 | 168.52 | 169.65 | 84188.0 |
| 2023-10-31 08:05:00 | AAPL | Stock | 169.65 | 169.74 | 169.6 | 169.74 | 6070.0 |
| 2023-10-31 08:10:00 | AAPL | Stock | 169.7 | 169.78 | 169.7 | 169.72 | 6305.0 |
| 2023-10-31 08:15:00 | AAPL | Stock | 169.74 | 169.93 | 169.72 | 169.79 | 7461.0 |
| 2023-10-31 08:20:00 | AAPL | Stock | 169.85 | 170.0 | 169.85 | 170.0 | 12129.0 |
| 2023-10-31 08:25:00 | AAPL | Stock | 170.085 | 170.19 | 170.0001 | 170.13 | 20166.0 |
| 2023-10-31 08:30:00 | AAPL | Stock | 170.02 | 170.02 | 169.59 | 169.74 | 32127.0 |
| 2023-10-31 08:35:00 | AAPL | Stock | 169.71 | 169.78 | 169.64 | 169.71 | 12123.0 |
| 2023-10-31 08:40:00 | AAPL | Stock | 169.7 | 169.72 | 169.5 | 169.57 | 7284.0 |
| 2023-10-31 08:45:00 | AAPL | Stock | 169.57 | 169.61 | 169.45 | 169.6092 | 17806.0 |
| 2023-10-31 08:50:00 | AAPL | Stock | 169.59 | 169.59 | 169.4 | 169.43 | 5336.0 |
> showing 50 of 387,562 rows — these rows as CSV