PREVIEW / stock_5min / 2023-12-11
file: by_date/stock_5min/2023/2023-12-11.parquet size: 6.8 MB rows: 410,210 symbols: 1,295
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-12-11 04:00:00 | AAPL | Stock | 195.01 | 195.05 | 194.92 | 195.0 | 2259.0 |
| 2023-12-11 04:05:00 | AAPL | Stock | 195.01 | 195.01 | 195.0 | 195.0 | 2824.0 |
| 2023-12-11 04:10:00 | AAPL | Stock | 194.94 | 195.02 | 194.94 | 195.02 | 767.0 |
| 2023-12-11 04:15:00 | AAPL | Stock | 195.0 | 195.0 | 194.96 | 194.96 | 476.0 |
| 2023-12-11 04:20:00 | AAPL | Stock | 194.94 | 195.0 | 194.94 | 195.0 | 6455.0 |
| 2023-12-11 04:25:00 | AAPL | Stock | 195.0 | 195.0 | 194.99 | 194.99 | 2397.0 |
| 2023-12-11 04:30:00 | AAPL | Stock | 194.98 | 194.98 | 194.98 | 194.98 | 100.0 |
| 2023-12-11 04:35:00 | AAPL | Stock | 194.93 | 195.0 | 194.9 | 194.93 | 8479.0 |
| 2023-12-11 04:40:00 | AAPL | Stock | 194.99 | 195.0 | 194.99 | 195.0 | 2634.0 |
| 2023-12-11 04:45:00 | AAPL | Stock | 194.93 | 194.93 | 194.93 | 194.93 | 1799.0 |
| 2023-12-11 04:50:00 | AAPL | Stock | 194.85 | 194.85 | 194.85 | 194.85 | 100.0 |
| 2023-12-11 04:55:00 | AAPL | Stock | 194.81 | 194.81 | 194.8 | 194.8 | 400.0 |
| 2023-12-11 05:00:00 | AAPL | Stock | 194.83 | 194.83 | 194.76 | 194.78 | 3390.0 |
| 2023-12-11 05:10:00 | AAPL | Stock | 194.85 | 194.85 | 194.83 | 194.83 | 4698.0 |
| 2023-12-11 05:15:00 | AAPL | Stock | 194.83 | 194.83 | 194.83 | 194.83 | 1597.0 |
| 2023-12-11 05:20:00 | AAPL | Stock | 194.81 | 194.81 | 194.81 | 194.81 | 149.0 |
| 2023-12-11 05:25:00 | AAPL | Stock | 194.83 | 194.83 | 194.77 | 194.82 | 6035.0 |
| 2023-12-11 05:30:00 | AAPL | Stock | 194.81 | 194.81 | 194.81 | 194.81 | 1025.0 |
| 2023-12-11 05:35:00 | AAPL | Stock | 194.81 | 194.81 | 194.81 | 194.81 | 912.0 |
| 2023-12-11 05:40:00 | AAPL | Stock | 194.8 | 194.8 | 194.79 | 194.79 | 1132.0 |
| 2023-12-11 05:45:00 | AAPL | Stock | 194.8 | 194.8 | 194.73 | 194.73 | 2434.0 |
| 2023-12-11 05:50:00 | AAPL | Stock | 194.71 | 194.71 | 194.68 | 194.68 | 3054.0 |
| 2023-12-11 05:55:00 | AAPL | Stock | 194.61 | 194.64 | 194.61 | 194.64 | 247.0 |
| 2023-12-11 06:00:00 | AAPL | Stock | 194.66 | 194.66 | 194.65 | 194.65 | 200.0 |
| 2023-12-11 06:05:00 | AAPL | Stock | 194.63 | 194.63 | 194.63 | 194.63 | 200.0 |
| 2023-12-11 06:10:00 | AAPL | Stock | 194.65 | 194.68 | 194.65 | 194.68 | 2241.0 |
| 2023-12-11 06:15:00 | AAPL | Stock | 194.61 | 194.61 | 194.52 | 194.52 | 908.0 |
| 2023-12-11 06:20:00 | AAPL | Stock | 194.54 | 194.54 | 194.46 | 194.46 | 2651.0 |
| 2023-12-11 06:25:00 | AAPL | Stock | 194.49 | 194.49 | 194.49 | 194.49 | 125.0 |
| 2023-12-11 06:30:00 | AAPL | Stock | 194.5 | 194.54 | 194.5 | 194.54 | 1884.0 |
| 2023-12-11 06:35:00 | AAPL | Stock | 194.6 | 194.62 | 194.6 | 194.61 | 1005.0 |
| 2023-12-11 06:40:00 | AAPL | Stock | 194.63 | 194.63 | 194.6 | 194.6 | 285.0 |
| 2023-12-11 06:50:00 | AAPL | Stock | 194.59 | 194.6 | 194.59 | 194.6 | 300.0 |
| 2023-12-11 06:55:00 | AAPL | Stock | 194.59 | 194.7 | 194.59 | 194.7 | 1921.0 |
| 2023-12-11 07:00:00 | AAPL | Stock | 194.75 | 195.04 | 194.74 | 195.0 | 10431.0 |
| 2023-12-11 07:05:00 | AAPL | Stock | 195.0 | 195.15 | 195.0 | 195.15 | 6235.0 |
| 2023-12-11 07:10:00 | AAPL | Stock | 195.15 | 195.32 | 195.15 | 195.3 | 9491.0 |
| 2023-12-11 07:15:00 | AAPL | Stock | 195.25 | 195.38 | 195.25 | 195.38 | 6799.0 |
| 2023-12-11 07:20:00 | AAPL | Stock | 195.42 | 195.5 | 195.3 | 195.3 | 4999.0 |
| 2023-12-11 07:25:00 | AAPL | Stock | 195.25 | 195.35 | 195.22 | 195.25 | 6514.0 |
| 2023-12-11 07:30:00 | AAPL | Stock | 195.25 | 195.25 | 195.13 | 195.15 | 2044.0 |
| 2023-12-11 07:35:00 | AAPL | Stock | 195.13 | 195.15 | 195.05 | 195.1 | 4054.0 |
| 2023-12-11 07:40:00 | AAPL | Stock | 195.04 | 195.05 | 195.0 | 195.0 | 1428.0 |
| 2023-12-11 07:45:00 | AAPL | Stock | 195.05 | 195.05 | 195.0 | 195.0 | 3116.0 |
| 2023-12-11 07:50:00 | AAPL | Stock | 195.0 | 195.01 | 194.97 | 195.01 | 4775.0 |
| 2023-12-11 07:55:00 | AAPL | Stock | 195.01 | 195.04 | 194.95 | 194.95 | 13787.0 |
| 2023-12-11 08:00:00 | AAPL | Stock | 194.98 | 195.4763 | 194.48 | 194.88 | 60084.0 |
| 2023-12-11 08:05:00 | AAPL | Stock | 194.81 | 194.82 | 194.75 | 194.81 | 23783.0 |
| 2023-12-11 08:10:00 | AAPL | Stock | 194.8892 | 194.9 | 194.81 | 194.9 | 9914.0 |
| 2023-12-11 08:15:00 | AAPL | Stock | 194.9 | 194.9963 | 194.84 | 194.86 | 19159.0 |
> showing 50 of 410,210 rows — these rows as CSV