PREVIEW / stock_5min / 2024-01-18
file: by_date/stock_5min/2024/2024-01-18.parquet size: 6.6 MB rows: 397,352 symbols: 1,168
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-18 04:00:00 | AAPL | Stock | 182.55 | 182.83 | 182.55 | 182.76 | 1848.0 |
| 2024-01-18 04:05:00 | AAPL | Stock | 182.71 | 182.71 | 182.54 | 182.6 | 4125.0 |
| 2024-01-18 04:10:00 | AAPL | Stock | 182.6 | 182.71 | 182.55 | 182.65 | 1373.0 |
| 2024-01-18 04:15:00 | AAPL | Stock | 182.5 | 182.5 | 182.5 | 182.5 | 163.0 |
| 2024-01-18 04:20:00 | AAPL | Stock | 182.59 | 182.59 | 182.5 | 182.5 | 636.0 |
| 2024-01-18 04:25:00 | AAPL | Stock | 182.5 | 182.6 | 182.49 | 182.49 | 862.0 |
| 2024-01-18 04:30:00 | AAPL | Stock | 182.37 | 182.45 | 182.37 | 182.45 | 329.0 |
| 2024-01-18 04:35:00 | AAPL | Stock | 182.45 | 182.45 | 182.41 | 182.41 | 638.0 |
| 2024-01-18 04:40:00 | AAPL | Stock | 182.44 | 182.56 | 182.37 | 182.37 | 1705.0 |
| 2024-01-18 04:45:00 | AAPL | Stock | 182.46 | 182.49 | 182.46 | 182.46 | 340.0 |
| 2024-01-18 04:50:00 | AAPL | Stock | 182.42 | 182.42 | 182.37 | 182.37 | 1322.0 |
| 2024-01-18 04:55:00 | AAPL | Stock | 182.31 | 182.31 | 182.2 | 182.2 | 300.0 |
| 2024-01-18 05:00:00 | AAPL | Stock | 182.3 | 182.3 | 182.3 | 182.3 | 180.0 |
| 2024-01-18 05:05:00 | AAPL | Stock | 182.23 | 182.23 | 182.2 | 182.2 | 400.0 |
| 2024-01-18 05:10:00 | AAPL | Stock | 182.2 | 182.2 | 182.11 | 182.18 | 635.0 |
| 2024-01-18 05:15:00 | AAPL | Stock | 182.2 | 182.2 | 182.2 | 182.2 | 220.0 |
| 2024-01-18 05:20:00 | AAPL | Stock | 182.37 | 182.37 | 182.32 | 182.32 | 217.0 |
| 2024-01-18 05:35:00 | AAPL | Stock | 182.32 | 182.33 | 182.32 | 182.33 | 2605.0 |
| 2024-01-18 05:40:00 | AAPL | Stock | 182.3 | 182.39 | 182.3 | 182.39 | 396.0 |
| 2024-01-18 05:45:00 | AAPL | Stock | 182.39 | 182.43 | 182.39 | 182.43 | 1120.0 |
| 2024-01-18 05:50:00 | AAPL | Stock | 182.48 | 182.48 | 182.48 | 182.48 | 100.0 |
| 2024-01-18 05:55:00 | AAPL | Stock | 182.55 | 182.55 | 182.55 | 182.55 | 200.0 |
| 2024-01-18 06:00:00 | AAPL | Stock | 182.55 | 185.57 | 182.55 | 185.5 | 87115.0 |
| 2024-01-18 06:05:00 | AAPL | Stock | 185.31 | 185.89 | 185.29 | 185.89 | 23932.0 |
| 2024-01-18 06:10:00 | AAPL | Stock | 185.78 | 185.92 | 185.5 | 185.63 | 12202.0 |
| 2024-01-18 06:15:00 | AAPL | Stock | 185.63 | 185.88 | 185.58 | 185.82 | 11157.0 |
| 2024-01-18 06:20:00 | AAPL | Stock | 185.88 | 186.0 | 185.71 | 186.0 | 23560.0 |
| 2024-01-18 06:25:00 | AAPL | Stock | 186.0 | 186.0 | 185.8 | 185.8 | 8659.0 |
| 2024-01-18 06:30:00 | AAPL | Stock | 185.8 | 185.8 | 185.6 | 185.7 | 9690.0 |
| 2024-01-18 06:35:00 | AAPL | Stock | 185.75 | 186.0 | 185.75 | 185.92 | 4632.0 |
| 2024-01-18 06:40:00 | AAPL | Stock | 185.95 | 186.15 | 185.95 | 186.05 | 9837.0 |
| 2024-01-18 06:45:00 | AAPL | Stock | 186.08 | 186.1 | 185.9 | 185.9 | 4731.0 |
| 2024-01-18 06:50:00 | AAPL | Stock | 185.9 | 185.99 | 185.85 | 185.85 | 6734.0 |
| 2024-01-18 06:55:00 | AAPL | Stock | 185.85 | 185.97 | 185.72 | 185.92 | 12234.0 |
| 2024-01-18 07:00:00 | AAPL | Stock | 185.81 | 185.91 | 185.52 | 185.69 | 28335.0 |
| 2024-01-18 07:05:00 | AAPL | Stock | 185.75 | 186.0 | 185.75 | 185.95 | 14105.0 |
| 2024-01-18 07:10:00 | AAPL | Stock | 185.99 | 186.1 | 185.99 | 186.05 | 22962.0 |
| 2024-01-18 07:15:00 | AAPL | Stock | 186.0 | 186.04 | 185.9 | 185.92 | 13195.0 |
| 2024-01-18 07:20:00 | AAPL | Stock | 185.9 | 186.0 | 185.75 | 185.75 | 18002.0 |
| 2024-01-18 07:25:00 | AAPL | Stock | 185.75 | 186.0 | 185.66 | 185.79 | 18839.0 |
| 2024-01-18 07:30:00 | AAPL | Stock | 185.83 | 186.2 | 185.8 | 186.11 | 13226.0 |
| 2024-01-18 07:35:00 | AAPL | Stock | 186.1 | 186.27 | 186.0 | 186.25 | 14223.0 |
| 2024-01-18 07:40:00 | AAPL | Stock | 186.25 | 186.95 | 186.25 | 186.83 | 51287.0 |
| 2024-01-18 07:45:00 | AAPL | Stock | 186.83 | 187.05 | 186.8 | 187.0 | 38230.0 |
| 2024-01-18 07:50:00 | AAPL | Stock | 187.0 | 187.25 | 187.0 | 187.2 | 47593.0 |
| 2024-01-18 07:55:00 | AAPL | Stock | 187.14 | 187.14 | 186.9 | 186.9 | 11030.0 |
| 2024-01-18 08:00:00 | AAPL | Stock | 185.79 | 187.25 | 182.04 | 186.79 | 142605.0 |
| 2024-01-18 08:05:00 | AAPL | Stock | 186.77 | 186.91 | 186.76 | 186.8 | 14070.0 |
| 2024-01-18 08:10:00 | AAPL | Stock | 186.77 | 186.87 | 186.62 | 186.65 | 20689.0 |
| 2024-01-18 08:15:00 | AAPL | Stock | 186.62 | 186.67 | 186.575 | 186.64 | 13716.0 |
> showing 50 of 397,352 rows — these rows as CSV