PREVIEW / stock_5min / 2023-12-13
file: by_date/stock_5min/2023/2023-12-13.parquet size: 7.0 MB rows: 422,821 symbols: 1,306
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-12-13 04:00:00 | AAPL | Stock | 194.51 | 194.65 | 194.51 | 194.65 | 400.0 |
| 2023-12-13 04:15:00 | AAPL | Stock | 194.69 | 194.75 | 194.69 | 194.75 | 1603.0 |
| 2023-12-13 04:20:00 | AAPL | Stock | 194.7 | 194.7 | 194.7 | 194.7 | 1850.0 |
| 2023-12-13 04:30:00 | AAPL | Stock | 194.73 | 194.73 | 194.7 | 194.7 | 555.0 |
| 2023-12-13 04:40:00 | AAPL | Stock | 194.66 | 194.66 | 194.66 | 194.66 | 117.0 |
| 2023-12-13 04:50:00 | AAPL | Stock | 194.68 | 194.68 | 194.68 | 194.68 | 100.0 |
| 2023-12-13 04:55:00 | AAPL | Stock | 194.6 | 194.6 | 194.6 | 194.6 | 125.0 |
| 2023-12-13 05:05:00 | AAPL | Stock | 194.65 | 194.65 | 194.65 | 194.65 | 512.0 |
| 2023-12-13 05:15:00 | AAPL | Stock | 194.62 | 194.62 | 194.59 | 194.59 | 252.0 |
| 2023-12-13 05:20:00 | AAPL | Stock | 194.5 | 194.5 | 194.49 | 194.5 | 950.0 |
| 2023-12-13 05:25:00 | AAPL | Stock | 194.48 | 194.5 | 194.48 | 194.5 | 598.0 |
| 2023-12-13 05:30:00 | AAPL | Stock | 194.44 | 194.5 | 194.44 | 194.5 | 510.0 |
| 2023-12-13 05:35:00 | AAPL | Stock | 194.48 | 194.5 | 194.48 | 194.5 | 699.0 |
| 2023-12-13 05:40:00 | AAPL | Stock | 194.51 | 194.51 | 194.42 | 194.43 | 637.0 |
| 2023-12-13 05:45:00 | AAPL | Stock | 194.41 | 194.51 | 194.41 | 194.51 | 1472.0 |
| 2023-12-13 05:50:00 | AAPL | Stock | 194.51 | 194.51 | 194.51 | 194.51 | 409.0 |
| 2023-12-13 05:55:00 | AAPL | Stock | 194.51 | 194.51 | 194.44 | 194.51 | 579.0 |
| 2023-12-13 06:15:00 | AAPL | Stock | 194.51 | 194.52 | 194.51 | 194.52 | 5191.0 |
| 2023-12-13 06:20:00 | AAPL | Stock | 194.61 | 194.61 | 194.61 | 194.61 | 100.0 |
| 2023-12-13 06:25:00 | AAPL | Stock | 194.58 | 194.58 | 194.57 | 194.58 | 1000.0 |
| 2023-12-13 06:30:00 | AAPL | Stock | 194.61 | 195.3 | 194.61 | 195.24 | 19771.0 |
| 2023-12-13 06:35:00 | AAPL | Stock | 195.24 | 195.33 | 195.13 | 195.33 | 6505.0 |
| 2023-12-13 06:45:00 | AAPL | Stock | 195.06 | 195.25 | 195.01 | 195.25 | 5696.0 |
| 2023-12-13 06:50:00 | AAPL | Stock | 195.27 | 195.34 | 195.27 | 195.34 | 2046.0 |
| 2023-12-13 06:55:00 | AAPL | Stock | 195.36 | 195.36 | 195.21 | 195.36 | 4401.0 |
| 2023-12-13 07:00:00 | AAPL | Stock | 195.18 | 195.21 | 195.05 | 195.05 | 2576.0 |
| 2023-12-13 07:05:00 | AAPL | Stock | 195.08 | 195.08 | 195.08 | 195.08 | 250.0 |
| 2023-12-13 07:15:00 | AAPL | Stock | 195.09 | 195.15 | 195.09 | 195.15 | 1209.0 |
| 2023-12-13 07:20:00 | AAPL | Stock | 195.09 | 195.09 | 195.09 | 195.09 | 773.0 |
| 2023-12-13 07:25:00 | AAPL | Stock | 195.09 | 195.15 | 195.08 | 195.09 | 5893.0 |
| 2023-12-13 07:30:00 | AAPL | Stock | 195.05 | 195.05 | 195.0 | 195.05 | 2759.0 |
| 2023-12-13 07:35:00 | AAPL | Stock | 195.08 | 195.08 | 195.05 | 195.08 | 1682.0 |
| 2023-12-13 07:40:00 | AAPL | Stock | 195.08 | 195.12 | 195.08 | 195.12 | 500.0 |
| 2023-12-13 07:45:00 | AAPL | Stock | 195.14 | 195.15 | 195.14 | 195.15 | 2787.0 |
| 2023-12-13 07:50:00 | AAPL | Stock | 195.16 | 195.4 | 195.16 | 195.4 | 13861.0 |
| 2023-12-13 07:55:00 | AAPL | Stock | 195.4 | 195.46 | 195.4 | 195.4 | 4735.0 |
| 2023-12-13 08:00:00 | AAPL | Stock | 195.1 | 195.49 | 194.53 | 195.4234 | 31933.0 |
| 2023-12-13 08:05:00 | AAPL | Stock | 195.48 | 195.65 | 195.47 | 195.6003 | 15953.0 |
| 2023-12-13 08:10:00 | AAPL | Stock | 195.6002 | 195.7 | 195.6002 | 195.66 | 15654.0 |
| 2023-12-13 08:15:00 | AAPL | Stock | 195.63 | 195.75 | 195.63 | 195.71 | 12432.0 |
| 2023-12-13 08:20:00 | AAPL | Stock | 195.69 | 195.83 | 195.67 | 195.67 | 18817.0 |
| 2023-12-13 08:25:00 | AAPL | Stock | 195.67 | 195.79 | 195.65 | 195.78 | 17713.0 |
| 2023-12-13 08:30:00 | AAPL | Stock | 195.78 | 196.02 | 195.75 | 195.84 | 68218.0 |
| 2023-12-13 08:35:00 | AAPL | Stock | 195.8 | 196.1794 | 195.76 | 196.14 | 39011.0 |
| 2023-12-13 08:40:00 | AAPL | Stock | 196.1 | 196.19 | 195.91 | 195.9255 | 31014.0 |
| 2023-12-13 08:45:00 | AAPL | Stock | 195.98 | 196.0 | 195.78 | 195.7803 | 30472.0 |
| 2023-12-13 08:50:00 | AAPL | Stock | 195.8 | 195.8854 | 195.77 | 195.85 | 13214.0 |
| 2023-12-13 08:55:00 | AAPL | Stock | 195.89 | 195.9 | 195.86 | 195.89 | 5261.0 |
| 2023-12-13 09:00:00 | AAPL | Stock | 195.83 | 196.0 | 195.8 | 195.85 | 13218.0 |
| 2023-12-13 09:05:00 | AAPL | Stock | 195.88 | 195.9 | 195.8 | 195.88 | 8852.0 |
> showing 50 of 422,821 rows — these rows as CSV