PREVIEW / stock_5min / 2023-11-24
file: by_date/stock_5min/2023/2023-11-24.parquet size: 3.9 MB rows: 224,750 symbols: 1,211
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-11-24 04:00:00 | AAPL | Stock | 191.26 | 191.26 | 191.26 | 191.26 | 102.0 |
| 2023-11-24 04:20:00 | AAPL | Stock | 191.18 | 191.22 | 191.18 | 191.2 | 1048.0 |
| 2023-11-24 04:25:00 | AAPL | Stock | 191.18 | 191.2 | 191.16 | 191.16 | 451.0 |
| 2023-11-24 04:30:00 | AAPL | Stock | 191.15 | 191.15 | 191.15 | 191.15 | 150.0 |
| 2023-11-24 04:40:00 | AAPL | Stock | 191.14 | 191.15 | 191.14 | 191.15 | 233.0 |
| 2023-11-24 04:45:00 | AAPL | Stock | 191.1 | 191.1 | 191.1 | 191.1 | 250.0 |
| 2023-11-24 05:05:00 | AAPL | Stock | 191.08 | 191.08 | 191.08 | 191.08 | 276.0 |
| 2023-11-24 05:25:00 | AAPL | Stock | 191.08 | 191.08 | 191.08 | 191.08 | 100.0 |
| 2023-11-24 05:30:00 | AAPL | Stock | 191.0 | 191.0 | 191.0 | 191.0 | 1181.0 |
| 2023-11-24 05:35:00 | AAPL | Stock | 191.0 | 191.0 | 191.0 | 191.0 | 412.0 |
| 2023-11-24 05:40:00 | AAPL | Stock | 190.97 | 190.97 | 190.97 | 190.97 | 440.0 |
| 2023-11-24 05:45:00 | AAPL | Stock | 191.0 | 191.05 | 191.0 | 191.05 | 475.0 |
| 2023-11-24 05:55:00 | AAPL | Stock | 191.1 | 191.1 | 191.1 | 191.1 | 2949.0 |
| 2023-11-24 06:00:00 | AAPL | Stock | 191.1 | 191.1 | 191.1 | 191.1 | 400.0 |
| 2023-11-24 06:05:00 | AAPL | Stock | 191.01 | 191.01 | 191.01 | 191.01 | 374.0 |
| 2023-11-24 06:10:00 | AAPL | Stock | 190.94 | 190.94 | 190.9 | 190.9 | 1127.0 |
| 2023-11-24 06:15:00 | AAPL | Stock | 190.91 | 190.91 | 190.9 | 190.9 | 749.0 |
| 2023-11-24 06:25:00 | AAPL | Stock | 190.92 | 190.92 | 190.91 | 190.91 | 798.0 |
| 2023-11-24 06:30:00 | AAPL | Stock | 190.91 | 190.91 | 190.85 | 190.85 | 634.0 |
| 2023-11-24 06:35:00 | AAPL | Stock | 190.85 | 190.85 | 190.72 | 190.72 | 812.0 |
| 2023-11-24 06:40:00 | AAPL | Stock | 190.85 | 190.85 | 190.85 | 190.85 | 416.0 |
| 2023-11-24 06:45:00 | AAPL | Stock | 190.81 | 190.81 | 190.8 | 190.8 | 464.0 |
| 2023-11-24 06:50:00 | AAPL | Stock | 190.8 | 190.8 | 190.8 | 190.8 | 800.0 |
| 2023-11-24 06:55:00 | AAPL | Stock | 190.77 | 190.77 | 190.76 | 190.76 | 341.0 |
| 2023-11-24 07:00:00 | AAPL | Stock | 190.8 | 190.84 | 190.75 | 190.84 | 4002.0 |
| 2023-11-24 07:05:00 | AAPL | Stock | 190.85 | 190.85 | 190.84 | 190.84 | 2188.0 |
| 2023-11-24 07:10:00 | AAPL | Stock | 190.84 | 190.84 | 190.79 | 190.79 | 897.0 |
| 2023-11-24 07:15:00 | AAPL | Stock | 190.75 | 190.75 | 190.75 | 190.75 | 100.0 |
| 2023-11-24 07:25:00 | AAPL | Stock | 190.88 | 190.9 | 190.88 | 190.9 | 339.0 |
| 2023-11-24 07:30:00 | AAPL | Stock | 190.85 | 190.85 | 190.82 | 190.82 | 1968.0 |
| 2023-11-24 07:35:00 | AAPL | Stock | 190.79 | 190.79 | 190.77 | 190.77 | 786.0 |
| 2023-11-24 07:40:00 | AAPL | Stock | 190.8 | 190.8 | 190.8 | 190.8 | 392.0 |
| 2023-11-24 07:45:00 | AAPL | Stock | 190.75 | 190.75 | 190.67 | 190.67 | 4025.0 |
| 2023-11-24 07:50:00 | AAPL | Stock | 190.67 | 190.69 | 190.67 | 190.67 | 869.0 |
| 2023-11-24 07:55:00 | AAPL | Stock | 190.69 | 190.77 | 190.69 | 190.77 | 1916.0 |
| 2023-11-24 08:00:00 | AAPL | Stock | 190.7989 | 191.35 | 190.61 | 190.69 | 28203.0 |
| 2023-11-24 08:05:00 | AAPL | Stock | 190.72 | 190.85 | 190.72 | 190.85 | 2755.0 |
| 2023-11-24 08:10:00 | AAPL | Stock | 190.78 | 190.86 | 190.75 | 190.8 | 3012.0 |
| 2023-11-24 08:15:00 | AAPL | Stock | 190.75 | 190.75 | 190.7 | 190.7 | 2033.0 |
| 2023-11-24 08:20:00 | AAPL | Stock | 190.7486 | 190.79 | 190.7 | 190.75 | 5185.0 |
| 2023-11-24 08:25:00 | AAPL | Stock | 190.7 | 190.75 | 190.7 | 190.7001 | 2300.0 |
| 2023-11-24 08:30:00 | AAPL | Stock | 190.7 | 190.72 | 190.59 | 190.65 | 4350.0 |
| 2023-11-24 08:35:00 | AAPL | Stock | 190.63 | 190.65 | 190.6 | 190.62 | 707.0 |
| 2023-11-24 08:40:00 | AAPL | Stock | 190.62 | 190.71 | 190.62 | 190.71 | 3733.0 |
| 2023-11-24 08:45:00 | AAPL | Stock | 190.71 | 190.84 | 190.71 | 190.73 | 8465.0 |
| 2023-11-24 08:50:00 | AAPL | Stock | 190.78 | 190.87 | 190.78 | 190.8 | 1903.0 |
| 2023-11-24 08:55:00 | AAPL | Stock | 190.88 | 190.88 | 190.85 | 190.85 | 5404.0 |
| 2023-11-24 09:00:00 | AAPL | Stock | 190.88 | 190.89 | 190.65 | 190.65 | 4839.0 |
| 2023-11-24 09:05:00 | AAPL | Stock | 190.69 | 190.69 | 190.6316 | 190.6316 | 3506.0 |
| 2023-11-24 09:10:00 | AAPL | Stock | 190.71 | 190.75 | 190.71 | 190.73 | 2998.0 |
> showing 50 of 224,750 rows — these rows as CSV