PREVIEW / stock_5min / 2024-01-16
file: by_date/stock_5min/2024/2024-01-16.parquet size: 6.7 MB rows: 406,442 symbols: 1,200
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-01-16 04:00:00 | AAPL | Stock | 183.53 | 184.38 | 183.5 | 183.5 | 7944.0 |
| 2024-01-16 04:05:00 | AAPL | Stock | 183.4 | 183.47 | 183.33 | 183.33 | 2768.0 |
| 2024-01-16 04:10:00 | AAPL | Stock | 183.22 | 183.25 | 183.19 | 183.2 | 2356.0 |
| 2024-01-16 04:15:00 | AAPL | Stock | 183.22 | 183.22 | 183.0 | 183.0 | 1000.0 |
| 2024-01-16 04:20:00 | AAPL | Stock | 183.1 | 183.15 | 183.1 | 183.15 | 4025.0 |
| 2024-01-16 04:25:00 | AAPL | Stock | 182.9 | 182.9 | 182.83 | 182.87 | 640.0 |
| 2024-01-16 04:30:00 | AAPL | Stock | 182.87 | 183.06 | 182.87 | 183.06 | 2066.0 |
| 2024-01-16 04:35:00 | AAPL | Stock | 183.0 | 183.0 | 182.9 | 182.95 | 2492.0 |
| 2024-01-16 04:40:00 | AAPL | Stock | 182.98 | 183.11 | 182.9 | 182.9 | 10957.0 |
| 2024-01-16 04:45:00 | AAPL | Stock | 182.88 | 182.94 | 182.83 | 182.83 | 1642.0 |
| 2024-01-16 04:50:00 | AAPL | Stock | 182.82 | 182.84 | 182.76 | 182.84 | 3283.0 |
| 2024-01-16 04:55:00 | AAPL | Stock | 182.85 | 183.0 | 182.85 | 183.0 | 1890.0 |
| 2024-01-16 05:00:00 | AAPL | Stock | 183.06 | 183.12 | 182.84 | 182.84 | 1528.0 |
| 2024-01-16 05:05:00 | AAPL | Stock | 182.95 | 183.0 | 182.95 | 183.0 | 855.0 |
| 2024-01-16 05:10:00 | AAPL | Stock | 183.0 | 183.0 | 182.86 | 182.92 | 531.0 |
| 2024-01-16 05:15:00 | AAPL | Stock | 182.9 | 182.9 | 182.9 | 182.9 | 125.0 |
| 2024-01-16 05:20:00 | AAPL | Stock | 182.85 | 182.9 | 182.85 | 182.9 | 540.0 |
| 2024-01-16 05:25:00 | AAPL | Stock | 182.74 | 182.75 | 182.74 | 182.75 | 1120.0 |
| 2024-01-16 05:30:00 | AAPL | Stock | 182.74 | 182.74 | 182.58 | 182.66 | 2773.0 |
| 2024-01-16 05:35:00 | AAPL | Stock | 182.62 | 182.71 | 182.58 | 182.71 | 2207.0 |
| 2024-01-16 05:40:00 | AAPL | Stock | 182.67 | 182.67 | 182.67 | 182.67 | 248.0 |
| 2024-01-16 05:50:00 | AAPL | Stock | 182.63 | 182.63 | 182.63 | 182.63 | 920.0 |
| 2024-01-16 05:55:00 | AAPL | Stock | 182.63 | 182.68 | 182.56 | 182.56 | 1194.0 |
| 2024-01-16 06:00:00 | AAPL | Stock | 182.6 | 182.69 | 182.6 | 182.69 | 1965.0 |
| 2024-01-16 06:10:00 | AAPL | Stock | 182.65 | 182.65 | 182.65 | 182.65 | 100.0 |
| 2024-01-16 06:15:00 | AAPL | Stock | 182.64 | 182.69 | 182.64 | 182.69 | 1631.0 |
| 2024-01-16 06:20:00 | AAPL | Stock | 182.69 | 182.69 | 182.69 | 182.69 | 123.0 |
| 2024-01-16 06:25:00 | AAPL | Stock | 182.6 | 182.72 | 182.6 | 182.64 | 7231.0 |
| 2024-01-16 06:30:00 | AAPL | Stock | 182.69 | 182.74 | 182.69 | 182.7 | 567.0 |
| 2024-01-16 06:35:00 | AAPL | Stock | 182.69 | 182.7 | 182.64 | 182.7 | 840.0 |
| 2024-01-16 06:40:00 | AAPL | Stock | 182.7 | 182.7 | 182.7 | 182.7 | 755.0 |
| 2024-01-16 06:45:00 | AAPL | Stock | 182.75 | 182.82 | 182.72 | 182.82 | 3989.0 |
| 2024-01-16 06:50:00 | AAPL | Stock | 182.88 | 182.94 | 182.84 | 182.94 | 1451.0 |
| 2024-01-16 06:55:00 | AAPL | Stock | 182.94 | 182.94 | 182.82 | 182.85 | 2541.0 |
| 2024-01-16 07:00:00 | AAPL | Stock | 182.89 | 183.0 | 182.8 | 182.88 | 16240.0 |
| 2024-01-16 07:05:00 | AAPL | Stock | 182.89 | 183.2 | 182.88 | 183.2 | 11231.0 |
| 2024-01-16 07:10:00 | AAPL | Stock | 183.19 | 183.2 | 183.02 | 183.03 | 2925.0 |
| 2024-01-16 07:15:00 | AAPL | Stock | 183.03 | 183.05 | 183.0 | 183.0 | 7081.0 |
| 2024-01-16 07:20:00 | AAPL | Stock | 183.05 | 183.09 | 183.0 | 183.09 | 1870.0 |
| 2024-01-16 07:25:00 | AAPL | Stock | 183.15 | 183.3 | 183.08 | 183.3 | 8227.0 |
| 2024-01-16 07:30:00 | AAPL | Stock | 183.45 | 183.45 | 183.39 | 183.39 | 6727.0 |
| 2024-01-16 07:35:00 | AAPL | Stock | 183.26 | 183.26 | 182.98 | 183.19 | 18868.0 |
| 2024-01-16 07:40:00 | AAPL | Stock | 183.17 | 183.27 | 183.13 | 183.2 | 4043.0 |
| 2024-01-16 07:45:00 | AAPL | Stock | 183.2 | 183.24 | 183.16 | 183.23 | 2316.0 |
| 2024-01-16 07:50:00 | AAPL | Stock | 183.23 | 183.23 | 183.0 | 183.1 | 7652.0 |
| 2024-01-16 07:55:00 | AAPL | Stock | 183.07 | 183.07 | 183.0 | 183.05 | 7977.0 |
| 2024-01-16 08:00:00 | AAPL | Stock | 182.9 | 185.0 | 182.85 | 183.7 | 56447.0 |
| 2024-01-16 08:05:00 | AAPL | Stock | 184.38 | 184.39 | 183.0 | 183.18 | 13624.0 |
| 2024-01-16 08:10:00 | AAPL | Stock | 183.15 | 183.15 | 182.7 | 182.84 | 20962.0 |
| 2024-01-16 08:15:00 | AAPL | Stock | 182.85 | 182.89 | 182.7 | 182.75 | 14946.0 |
> showing 50 of 406,442 rows — these rows as CSV