PREVIEW / stock_5min / 2024-10-09
file: by_date/stock_5min/2024/2024-10-09.parquet size: 6.6 MB rows: 390,656 symbols: 762
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 |
|---|---|---|---|---|---|---|---|
| 2024-10-09 04:00:00 | AAPL | Stock | 225.12 | 225.12 | 225.03 | 225.03 | 971.0 |
| 2024-10-09 04:05:00 | AAPL | Stock | 224.87 | 224.87 | 224.74 | 224.74 | 510.0 |
| 2024-10-09 04:10:00 | AAPL | Stock | 224.76 | 224.76 | 224.75 | 224.75 | 498.0 |
| 2024-10-09 04:15:00 | AAPL | Stock | 224.62 | 224.65 | 224.62 | 224.65 | 300.0 |
| 2024-10-09 04:20:00 | AAPL | Stock | 224.61 | 224.61 | 224.61 | 224.61 | 318.0 |
| 2024-10-09 04:25:00 | AAPL | Stock | 224.68 | 224.69 | 224.5 | 224.56 | 479.0 |
| 2024-10-09 04:30:00 | AAPL | Stock | 224.45 | 224.45 | 224.45 | 224.45 | 300.0 |
| 2024-10-09 04:35:00 | AAPL | Stock | 224.51 | 224.51 | 224.51 | 224.51 | 200.0 |
| 2024-10-09 04:55:00 | AAPL | Stock | 224.68 | 224.72 | 224.68 | 224.72 | 420.0 |
| 2024-10-09 05:05:00 | AAPL | Stock | 224.83 | 224.83 | 224.82 | 224.82 | 333.0 |
| 2024-10-09 05:10:00 | AAPL | Stock | 224.88 | 224.88 | 224.88 | 224.88 | 220.0 |
| 2024-10-09 05:15:00 | AAPL | Stock | 224.89 | 224.89 | 224.89 | 224.89 | 300.0 |
| 2024-10-09 05:35:00 | AAPL | Stock | 225.0 | 225.0 | 225.0 | 225.0 | 718.0 |
| 2024-10-09 05:40:00 | AAPL | Stock | 225.03 | 225.03 | 225.03 | 225.03 | 187.0 |
| 2024-10-09 05:45:00 | AAPL | Stock | 225.06 | 225.16 | 225.06 | 225.16 | 1136.0 |
| 2024-10-09 05:50:00 | AAPL | Stock | 225.25 | 225.26 | 225.25 | 225.25 | 513.0 |
| 2024-10-09 05:55:00 | AAPL | Stock | 225.13 | 225.13 | 225.13 | 225.13 | 187.0 |
| 2024-10-09 06:00:00 | AAPL | Stock | 224.99 | 224.99 | 224.94 | 224.94 | 794.0 |
| 2024-10-09 06:05:00 | AAPL | Stock | 224.93 | 224.97 | 224.93 | 224.97 | 604.0 |
| 2024-10-09 06:10:00 | AAPL | Stock | 225.01 | 225.1 | 225.01 | 225.1 | 300.0 |
| 2024-10-09 06:15:00 | AAPL | Stock | 225.15 | 225.15 | 225.15 | 225.15 | 377.0 |
| 2024-10-09 06:30:00 | AAPL | Stock | 225.15 | 225.15 | 225.15 | 225.15 | 698.0 |
| 2024-10-09 06:50:00 | AAPL | Stock | 225.15 | 225.17 | 225.15 | 225.17 | 600.0 |
| 2024-10-09 06:55:00 | AAPL | Stock | 225.15 | 225.15 | 225.0 | 225.0 | 1199.0 |
| 2024-10-09 07:00:00 | AAPL | Stock | 225.14 | 225.3 | 225.14 | 225.25 | 2308.0 |
| 2024-10-09 07:05:00 | AAPL | Stock | 225.22 | 225.25 | 225.13 | 225.24 | 1164.0 |
| 2024-10-09 07:10:00 | AAPL | Stock | 225.23 | 225.24 | 225.22 | 225.23 | 755.0 |
| 2024-10-09 07:15:00 | AAPL | Stock | 225.11 | 225.2 | 225.1 | 225.2 | 1346.0 |
| 2024-10-09 07:20:00 | AAPL | Stock | 225.26 | 225.33 | 225.25 | 225.33 | 510.0 |
| 2024-10-09 07:25:00 | AAPL | Stock | 225.36 | 225.37 | 225.27 | 225.27 | 2372.0 |
| 2024-10-09 07:30:00 | AAPL | Stock | 225.29 | 225.3 | 225.25 | 225.25 | 2726.0 |
| 2024-10-09 07:35:00 | AAPL | Stock | 225.29 | 225.34 | 225.29 | 225.34 | 1078.0 |
| 2024-10-09 07:45:00 | AAPL | Stock | 225.47 | 225.5 | 225.47 | 225.5 | 689.0 |
| 2024-10-09 07:50:00 | AAPL | Stock | 225.6 | 225.69 | 225.6 | 225.62 | 1069.0 |
| 2024-10-09 07:55:00 | AAPL | Stock | 225.66 | 225.66 | 225.49 | 225.5 | 12442.0 |
| 2024-10-09 08:00:00 | AAPL | Stock | 225.3 | 225.73 | 224.7726 | 225.5 | 29226.0 |
| 2024-10-09 08:05:00 | AAPL | Stock | 225.5 | 225.52 | 225.4 | 225.4 | 927.0 |
| 2024-10-09 08:10:00 | AAPL | Stock | 225.3 | 225.5334 | 225.3 | 225.5334 | 377.0 |
| 2024-10-09 08:15:00 | AAPL | Stock | 225.48 | 225.48 | 225.31 | 225.31 | 700.0 |
| 2024-10-09 08:20:00 | AAPL | Stock | 225.31 | 225.35 | 225.22 | 225.3055 | 3327.0 |
| 2024-10-09 08:25:00 | AAPL | Stock | 225.2703 | 225.31 | 225.2703 | 225.3 | 910.0 |
| 2024-10-09 08:30:00 | AAPL | Stock | 225.2754 | 225.5973 | 225.25 | 225.31 | 7305.0 |
| 2024-10-09 08:35:00 | AAPL | Stock | 225.33 | 225.5665 | 225.3107 | 225.36 | 2621.0 |
| 2024-10-09 08:40:00 | AAPL | Stock | 225.36 | 225.46 | 225.36 | 225.37 | 450.0 |
| 2024-10-09 08:45:00 | AAPL | Stock | 225.43 | 225.5 | 225.42 | 225.5 | 3191.0 |
| 2024-10-09 08:50:00 | AAPL | Stock | 225.55 | 225.72 | 225.4835 | 225.72 | 4580.0 |
| 2024-10-09 08:55:00 | AAPL | Stock | 225.71 | 225.71 | 225.443 | 225.65 | 4385.0 |
| 2024-10-09 09:00:00 | AAPL | Stock | 225.59 | 225.7422 | 225.58 | 225.7 | 1450.0 |
| 2024-10-09 09:05:00 | AAPL | Stock | 225.7008 | 225.8893 | 225.7 | 225.8893 | 2308.0 |
| 2024-10-09 09:10:00 | AAPL | Stock | 225.8771 | 225.8999 | 225.61 | 225.826 | 2980.0 |
> showing 50 of 390,656 rows — these rows as CSV