PREVIEW / stock_5min / 2024-10-01
file: by_date/stock_5min/2024/2024-10-01.parquet size: 6.9 MB rows: 409,562 symbols: 774
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-10-01 04:00:00 | AAPL | Stock | 233.33 | 233.37 | 233.26 | 233.26 | 1669.0 |
| 2024-10-01 04:05:00 | AAPL | Stock | 233.15 | 233.17 | 233.12 | 233.12 | 530.0 |
| 2024-10-01 04:15:00 | AAPL | Stock | 233.08 | 233.12 | 233.08 | 233.12 | 394.0 |
| 2024-10-01 04:20:00 | AAPL | Stock | 233.08 | 233.13 | 233.08 | 233.12 | 794.0 |
| 2024-10-01 04:25:00 | AAPL | Stock | 233.13 | 233.19 | 233.12 | 233.19 | 540.0 |
| 2024-10-01 04:35:00 | AAPL | Stock | 233.25 | 233.28 | 233.25 | 233.28 | 315.0 |
| 2024-10-01 04:40:00 | AAPL | Stock | 233.28 | 233.28 | 233.2 | 233.27 | 1962.0 |
| 2024-10-01 04:50:00 | AAPL | Stock | 233.2 | 233.2 | 233.09 | 233.09 | 1503.0 |
| 2024-10-01 05:10:00 | AAPL | Stock | 233.23 | 233.23 | 233.23 | 233.23 | 220.0 |
| 2024-10-01 05:15:00 | AAPL | Stock | 233.23 | 233.34 | 233.23 | 233.28 | 499.0 |
| 2024-10-01 05:20:00 | AAPL | Stock | 233.29 | 233.29 | 233.29 | 233.29 | 300.0 |
| 2024-10-01 05:25:00 | AAPL | Stock | 233.35 | 233.35 | 233.35 | 233.35 | 691.0 |
| 2024-10-01 05:30:00 | AAPL | Stock | 233.35 | 233.35 | 233.32 | 233.32 | 816.0 |
| 2024-10-01 05:45:00 | AAPL | Stock | 233.3 | 233.3 | 233.27 | 233.29 | 918.0 |
| 2024-10-01 05:50:00 | AAPL | Stock | 233.35 | 233.35 | 233.35 | 233.35 | 117.0 |
| 2024-10-01 05:55:00 | AAPL | Stock | 233.32 | 233.42 | 233.32 | 233.42 | 333.0 |
| 2024-10-01 06:00:00 | AAPL | Stock | 233.39 | 233.39 | 233.39 | 233.39 | 127.0 |
| 2024-10-01 06:05:00 | AAPL | Stock | 233.4 | 233.4 | 233.4 | 233.4 | 150.0 |
| 2024-10-01 06:10:00 | AAPL | Stock | 233.4 | 233.4 | 233.4 | 233.4 | 420.0 |
| 2024-10-01 06:15:00 | AAPL | Stock | 233.43 | 233.43 | 233.42 | 233.42 | 300.0 |
| 2024-10-01 06:20:00 | AAPL | Stock | 233.45 | 233.45 | 233.42 | 233.42 | 499.0 |
| 2024-10-01 06:25:00 | AAPL | Stock | 233.44 | 233.44 | 233.41 | 233.41 | 1260.0 |
| 2024-10-01 06:30:00 | AAPL | Stock | 233.38 | 233.38 | 233.36 | 233.36 | 552.0 |
| 2024-10-01 06:35:00 | AAPL | Stock | 233.37 | 233.37 | 233.3 | 233.3 | 2522.0 |
| 2024-10-01 06:40:00 | AAPL | Stock | 233.3 | 233.3 | 233.3 | 233.3 | 940.0 |
| 2024-10-01 06:45:00 | AAPL | Stock | 233.3 | 233.35 | 233.3 | 233.35 | 397.0 |
| 2024-10-01 06:50:00 | AAPL | Stock | 233.35 | 233.38 | 233.35 | 233.38 | 205.0 |
| 2024-10-01 06:55:00 | AAPL | Stock | 233.45 | 233.56 | 233.0 | 233.0 | 19178.0 |
| 2024-10-01 07:00:00 | AAPL | Stock | 233.0 | 233.1 | 231.49 | 231.86 | 107068.0 |
| 2024-10-01 07:05:00 | AAPL | Stock | 231.76 | 231.87 | 230.52 | 231.0 | 59290.0 |
| 2024-10-01 07:10:00 | AAPL | Stock | 231.0 | 231.1 | 230.5 | 230.76 | 25159.0 |
| 2024-10-01 07:15:00 | AAPL | Stock | 230.87 | 230.87 | 230.19 | 230.49 | 53923.0 |
| 2024-10-01 07:20:00 | AAPL | Stock | 230.5 | 230.5 | 229.7 | 230.0 | 78944.0 |
| 2024-10-01 07:25:00 | AAPL | Stock | 230.02 | 230.45 | 230.02 | 230.33 | 34100.0 |
| 2024-10-01 07:30:00 | AAPL | Stock | 230.38 | 230.48 | 229.44 | 229.98 | 62861.0 |
| 2024-10-01 07:35:00 | AAPL | Stock | 229.91 | 230.1 | 229.85 | 229.97 | 17689.0 |
| 2024-10-01 07:40:00 | AAPL | Stock | 230.02 | 230.35 | 230.02 | 230.35 | 11878.0 |
| 2024-10-01 07:45:00 | AAPL | Stock | 230.4 | 230.44 | 230.0 | 230.01 | 12295.0 |
| 2024-10-01 07:50:00 | AAPL | Stock | 230.01 | 230.48 | 229.94 | 230.29 | 37779.0 |
| 2024-10-01 07:55:00 | AAPL | Stock | 230.29 | 230.32 | 230.16 | 230.32 | 5522.0 |
| 2024-10-01 08:00:00 | AAPL | Stock | 230.3 | 233.47 | 229.45 | 230.065 | 133734.0 |
| 2024-10-01 08:05:00 | AAPL | Stock | 230.1 | 233.0 | 229.82 | 229.82 | 41527.0 |
| 2024-10-01 08:10:00 | AAPL | Stock | 229.9872 | 230.1335 | 229.74 | 230.0101 | 18486.0 |
| 2024-10-01 08:15:00 | AAPL | Stock | 230.03 | 230.03 | 229.51 | 229.86 | 26657.0 |
| 2024-10-01 08:20:00 | AAPL | Stock | 229.85 | 230.0 | 229.76 | 229.99 | 22108.0 |
| 2024-10-01 08:25:00 | AAPL | Stock | 230.0 | 230.25 | 229.78 | 229.98 | 27122.0 |
| 2024-10-01 08:30:00 | AAPL | Stock | 229.99 | 230.01 | 229.88 | 230.0 | 14283.0 |
| 2024-10-01 08:35:00 | AAPL | Stock | 230.0 | 230.4 | 230.0 | 230.35 | 23878.0 |
| 2024-10-01 08:40:00 | AAPL | Stock | 230.31 | 230.43 | 230.2515 | 230.308 | 28863.0 |
| 2024-10-01 08:45:00 | AAPL | Stock | 230.4 | 230.4399 | 230.16 | 230.25 | 21659.0 |
> showing 50 of 409,562 rows — these rows as CSV