PREVIEW / stock_5min / 2024-11-29
file: by_date/stock_5min/2024/2024-11-29.parquet size: 4.5 MB rows: 257,205 symbols: 682
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-11-29 04:00:00 | AAPL | Stock | 235.37 | 235.37 | 235.06 | 235.12 | 2298.0 |
| 2024-11-29 04:05:00 | AAPL | Stock | 235.13 | 235.13 | 234.99 | 235.0 | 415.0 |
| 2024-11-29 04:10:00 | AAPL | Stock | 235.01 | 235.01 | 234.96 | 234.96 | 1050.0 |
| 2024-11-29 04:15:00 | AAPL | Stock | 235.03 | 235.03 | 235.03 | 235.03 | 165.0 |
| 2024-11-29 04:20:00 | AAPL | Stock | 235.14 | 235.2 | 235.14 | 235.2 | 200.0 |
| 2024-11-29 04:35:00 | AAPL | Stock | 235.08 | 235.08 | 235.04 | 235.07 | 507.0 |
| 2024-11-29 05:00:00 | AAPL | Stock | 234.94 | 234.94 | 234.94 | 234.94 | 100.0 |
| 2024-11-29 05:05:00 | AAPL | Stock | 234.98 | 235.0 | 234.91 | 234.91 | 313.0 |
| 2024-11-29 05:10:00 | AAPL | Stock | 234.85 | 234.9 | 234.84 | 234.9 | 490.0 |
| 2024-11-29 05:40:00 | AAPL | Stock | 234.8 | 234.8 | 234.78 | 234.78 | 1127.0 |
| 2024-11-29 05:50:00 | AAPL | Stock | 234.8 | 234.8 | 234.8 | 234.8 | 622.0 |
| 2024-11-29 06:15:00 | AAPL | Stock | 234.63 | 234.63 | 234.63 | 234.63 | 118.0 |
| 2024-11-29 06:20:00 | AAPL | Stock | 234.63 | 234.63 | 234.63 | 234.63 | 185.0 |
| 2024-11-29 06:30:00 | AAPL | Stock | 234.59 | 234.59 | 234.59 | 234.59 | 100.0 |
| 2024-11-29 06:35:00 | AAPL | Stock | 234.6 | 234.6 | 234.6 | 234.6 | 700.0 |
| 2024-11-29 06:40:00 | AAPL | Stock | 234.6 | 234.6 | 234.58 | 234.58 | 713.0 |
| 2024-11-29 06:45:00 | AAPL | Stock | 234.56 | 234.57 | 234.4 | 234.4 | 2349.0 |
| 2024-11-29 06:55:00 | AAPL | Stock | 234.42 | 234.42 | 234.42 | 234.42 | 100.0 |
| 2024-11-29 07:00:00 | AAPL | Stock | 234.41 | 234.52 | 234.4 | 234.52 | 2230.0 |
| 2024-11-29 07:05:00 | AAPL | Stock | 234.55 | 234.55 | 234.51 | 234.53 | 333.0 |
| 2024-11-29 07:10:00 | AAPL | Stock | 234.52 | 234.52 | 234.52 | 234.52 | 3140.0 |
| 2024-11-29 07:15:00 | AAPL | Stock | 234.51 | 234.55 | 234.51 | 234.55 | 400.0 |
| 2024-11-29 07:25:00 | AAPL | Stock | 234.59 | 234.66 | 234.59 | 234.66 | 2844.0 |
| 2024-11-29 07:30:00 | AAPL | Stock | 234.75 | 234.8 | 234.75 | 234.78 | 3725.0 |
| 2024-11-29 07:35:00 | AAPL | Stock | 234.66 | 234.74 | 234.65 | 234.65 | 600.0 |
| 2024-11-29 07:40:00 | AAPL | Stock | 234.72 | 234.72 | 234.65 | 234.65 | 529.0 |
| 2024-11-29 07:55:00 | AAPL | Stock | 234.55 | 234.61 | 234.52 | 234.58 | 3580.0 |
| 2024-11-29 08:00:00 | AAPL | Stock | 234.56 | 235.49 | 234.4001 | 234.55 | 33681.0 |
| 2024-11-29 08:05:00 | AAPL | Stock | 234.55 | 234.55 | 234.55 | 234.55 | 2000.0 |
| 2024-11-29 08:10:00 | AAPL | Stock | 234.59 | 234.65 | 234.59 | 234.65 | 1552.0 |
| 2024-11-29 08:15:00 | AAPL | Stock | 234.57 | 234.57 | 234.52 | 234.5209 | 1256.0 |
| 2024-11-29 08:20:00 | AAPL | Stock | 234.6 | 234.6 | 234.56 | 234.6 | 1480.0 |
| 2024-11-29 08:25:00 | AAPL | Stock | 234.56 | 234.57 | 234.5 | 234.56 | 1638.0 |
| 2024-11-29 08:30:00 | AAPL | Stock | 234.58 | 234.59 | 234.47 | 234.53 | 4516.0 |
| 2024-11-29 08:35:00 | AAPL | Stock | 234.52 | 234.52 | 234.45 | 234.5 | 1804.0 |
| 2024-11-29 08:40:00 | AAPL | Stock | 234.53 | 234.55 | 234.4 | 234.4 | 2342.0 |
| 2024-11-29 08:45:00 | AAPL | Stock | 234.3514 | 234.45 | 234.3514 | 234.42 | 5323.0 |
| 2024-11-29 08:50:00 | AAPL | Stock | 234.37 | 234.4 | 234.36 | 234.36 | 2434.0 |
| 2024-11-29 08:55:00 | AAPL | Stock | 234.31 | 234.4 | 234.3 | 234.31 | 5025.0 |
| 2024-11-29 09:00:00 | AAPL | Stock | 234.39 | 234.7399 | 234.39 | 234.62 | 9105.0 |
| 2024-11-29 09:05:00 | AAPL | Stock | 234.71 | 234.73 | 234.54 | 234.54 | 3972.0 |
| 2024-11-29 09:10:00 | AAPL | Stock | 234.71 | 234.75 | 234.64 | 234.68 | 2853.0 |
| 2024-11-29 09:15:00 | AAPL | Stock | 234.67 | 234.71 | 234.62 | 234.7 | 1385.0 |
| 2024-11-29 09:20:00 | AAPL | Stock | 234.6313 | 234.73 | 234.5 | 234.5 | 6129.0 |
| 2024-11-29 09:25:00 | AAPL | Stock | 234.5 | 234.91 | 234.13 | 234.85 | 46682.0 |
| 2024-11-29 09:30:00 | AAPL | Stock | 234.84 | 235.0 | 233.97 | 234.67 | 1135065.0 |
| 2024-11-29 09:35:00 | AAPL | Stock | 234.65 | 235.38 | 234.575 | 235.38 | 469829.0 |
| 2024-11-29 09:40:00 | AAPL | Stock | 235.365 | 235.645 | 235.29 | 235.38 | 384887.0 |
| 2024-11-29 09:45:00 | AAPL | Stock | 235.38 | 235.61 | 235.05 | 235.14 | 271628.0 |
| 2024-11-29 09:50:00 | AAPL | Stock | 235.14 | 235.52 | 235.08 | 235.5066 | 203554.0 |
> showing 50 of 257,205 rows — these rows as CSV