PREVIEW / stock_5min / 2023-11-20
file: by_date/stock_5min/2023/2023-11-20.parquet size: 6.7 MB rows: 402,420 symbols: 1,281
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-20 04:00:00 | AAPL | Stock | 189.52 | 189.52 | 188.92 | 189.0 | 6509.0 |
| 2023-11-20 04:05:00 | AAPL | Stock | 189.1 | 189.23 | 189.01 | 189.22 | 2537.0 |
| 2023-11-20 04:10:00 | AAPL | Stock | 189.2 | 189.3 | 189.2 | 189.3 | 690.0 |
| 2023-11-20 04:15:00 | AAPL | Stock | 189.38 | 189.4 | 189.3 | 189.4 | 2078.0 |
| 2023-11-20 04:20:00 | AAPL | Stock | 189.5 | 189.5 | 189.36 | 189.5 | 1553.0 |
| 2023-11-20 04:25:00 | AAPL | Stock | 189.5 | 189.55 | 189.45 | 189.55 | 3081.0 |
| 2023-11-20 04:30:00 | AAPL | Stock | 189.55 | 189.6 | 189.5 | 189.57 | 1167.0 |
| 2023-11-20 04:35:00 | AAPL | Stock | 189.53 | 189.54 | 189.5 | 189.54 | 925.0 |
| 2023-11-20 04:40:00 | AAPL | Stock | 189.5 | 189.5 | 189.5 | 189.5 | 100.0 |
| 2023-11-20 04:45:00 | AAPL | Stock | 189.54 | 189.54 | 189.54 | 189.54 | 100.0 |
| 2023-11-20 04:50:00 | AAPL | Stock | 189.55 | 189.56 | 189.5 | 189.56 | 1658.0 |
| 2023-11-20 04:55:00 | AAPL | Stock | 189.52 | 189.6 | 189.52 | 189.57 | 639.0 |
| 2023-11-20 05:00:00 | AAPL | Stock | 189.55 | 189.55 | 189.55 | 189.55 | 450.0 |
| 2023-11-20 05:05:00 | AAPL | Stock | 189.64 | 189.64 | 189.6 | 189.6 | 210.0 |
| 2023-11-20 05:10:00 | AAPL | Stock | 189.65 | 189.68 | 189.65 | 189.68 | 1357.0 |
| 2023-11-20 05:15:00 | AAPL | Stock | 189.68 | 189.68 | 189.68 | 189.68 | 564.0 |
| 2023-11-20 05:20:00 | AAPL | Stock | 189.68 | 189.68 | 189.61 | 189.61 | 2014.0 |
| 2023-11-20 05:25:00 | AAPL | Stock | 189.5 | 189.51 | 189.5 | 189.51 | 1547.0 |
| 2023-11-20 05:30:00 | AAPL | Stock | 189.59 | 189.62 | 189.59 | 189.62 | 549.0 |
| 2023-11-20 05:35:00 | AAPL | Stock | 189.52 | 189.52 | 189.5 | 189.5 | 4418.0 |
| 2023-11-20 05:40:00 | AAPL | Stock | 189.55 | 189.55 | 189.55 | 189.55 | 100.0 |
| 2023-11-20 05:45:00 | AAPL | Stock | 189.57 | 189.57 | 189.55 | 189.55 | 890.0 |
| 2023-11-20 05:50:00 | AAPL | Stock | 189.56 | 189.57 | 189.56 | 189.57 | 990.0 |
| 2023-11-20 05:55:00 | AAPL | Stock | 189.57 | 189.67 | 189.57 | 189.67 | 834.0 |
| 2023-11-20 06:00:00 | AAPL | Stock | 189.67 | 189.8 | 189.66 | 189.8 | 1258.0 |
| 2023-11-20 06:10:00 | AAPL | Stock | 189.85 | 189.85 | 189.81 | 189.81 | 466.0 |
| 2023-11-20 06:25:00 | AAPL | Stock | 189.88 | 189.88 | 189.87 | 189.87 | 314.0 |
| 2023-11-20 06:35:00 | AAPL | Stock | 189.68 | 189.68 | 189.68 | 189.68 | 350.0 |
| 2023-11-20 06:40:00 | AAPL | Stock | 189.66 | 189.67 | 189.6 | 189.63 | 3506.0 |
| 2023-11-20 06:45:00 | AAPL | Stock | 189.61 | 189.64 | 189.61 | 189.64 | 350.0 |
| 2023-11-20 06:50:00 | AAPL | Stock | 189.66 | 189.66 | 189.61 | 189.61 | 364.0 |
| 2023-11-20 06:55:00 | AAPL | Stock | 189.67 | 189.67 | 189.58 | 189.59 | 1963.0 |
| 2023-11-20 07:00:00 | AAPL | Stock | 189.67 | 189.67 | 189.58 | 189.67 | 1795.0 |
| 2023-11-20 07:10:00 | AAPL | Stock | 189.68 | 189.68 | 189.6 | 189.6 | 1620.0 |
| 2023-11-20 07:15:00 | AAPL | Stock | 189.62 | 189.62 | 189.62 | 189.62 | 600.0 |
| 2023-11-20 07:20:00 | AAPL | Stock | 189.64 | 189.64 | 189.59 | 189.59 | 2767.0 |
| 2023-11-20 07:25:00 | AAPL | Stock | 189.57 | 189.57 | 189.5 | 189.5 | 4139.0 |
| 2023-11-20 07:30:00 | AAPL | Stock | 189.46 | 189.46 | 189.45 | 189.45 | 860.0 |
| 2023-11-20 07:35:00 | AAPL | Stock | 189.48 | 189.51 | 189.45 | 189.51 | 873.0 |
| 2023-11-20 07:40:00 | AAPL | Stock | 189.5 | 189.5 | 189.45 | 189.45 | 2394.0 |
| 2023-11-20 07:45:00 | AAPL | Stock | 189.44 | 189.44 | 189.44 | 189.44 | 284.0 |
| 2023-11-20 07:50:00 | AAPL | Stock | 189.47 | 189.47 | 189.47 | 189.47 | 100.0 |
| 2023-11-20 07:55:00 | AAPL | Stock | 189.4 | 189.5 | 189.4 | 189.5 | 1479.0 |
| 2023-11-20 08:00:00 | AAPL | Stock | 189.68 | 189.69 | 189.13 | 189.59 | 22403.0 |
| 2023-11-20 08:05:00 | AAPL | Stock | 189.65 | 189.79 | 189.5677 | 189.78 | 13532.0 |
| 2023-11-20 08:10:00 | AAPL | Stock | 189.82 | 189.97 | 189.79 | 189.92 | 15971.0 |
| 2023-11-20 08:15:00 | AAPL | Stock | 189.92 | 190.08 | 189.86 | 189.96 | 13429.0 |
| 2023-11-20 08:20:00 | AAPL | Stock | 189.96 | 190.02 | 189.95 | 190.02 | 5059.0 |
| 2023-11-20 08:25:00 | AAPL | Stock | 189.98 | 190.1 | 189.98 | 190.05 | 8480.0 |
| 2023-11-20 08:30:00 | AAPL | Stock | 189.99 | 190.1 | 189.99 | 190.1 | 27066.0 |
> showing 50 of 402,420 rows — these rows as CSV