PREVIEW / stock_5min / 2024-09-16
file: by_date/stock_5min/2024/2024-09-16.parquet size: 6.5 MB rows: 398,561 symbols: 824
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-09-16 04:00:00 | AAPL | Stock | 222.2 | 222.2 | 220.0 | 220.6 | 15236.0 |
| 2024-09-16 04:05:00 | AAPL | Stock | 220.58 | 220.61 | 220.39 | 220.39 | 4512.0 |
| 2024-09-16 04:10:00 | AAPL | Stock | 220.39 | 220.39 | 220.2 | 220.29 | 3145.0 |
| 2024-09-16 04:15:00 | AAPL | Stock | 220.13 | 220.13 | 219.65 | 219.89 | 11332.0 |
| 2024-09-16 04:20:00 | AAPL | Stock | 219.86 | 219.86 | 219.35 | 219.35 | 7500.0 |
| 2024-09-16 04:25:00 | AAPL | Stock | 219.7 | 219.7 | 219.35 | 219.5 | 3559.0 |
| 2024-09-16 04:30:00 | AAPL | Stock | 219.4 | 219.49 | 219.2 | 219.2 | 7325.0 |
| 2024-09-16 04:35:00 | AAPL | Stock | 219.2 | 219.2 | 218.34 | 218.9 | 2616.0 |
| 2024-09-16 04:40:00 | AAPL | Stock | 219.0 | 219.0 | 218.87 | 218.87 | 200.0 |
| 2024-09-16 04:45:00 | AAPL | Stock | 219.0 | 219.2 | 219.0 | 219.2 | 942.0 |
| 2024-09-16 04:50:00 | AAPL | Stock | 219.28 | 219.5 | 219.21 | 219.21 | 2613.0 |
| 2024-09-16 04:55:00 | AAPL | Stock | 219.2 | 219.25 | 219.2 | 219.21 | 668.0 |
| 2024-09-16 05:00:00 | AAPL | Stock | 219.16 | 219.17 | 219.16 | 219.17 | 352.0 |
| 2024-09-16 05:05:00 | AAPL | Stock | 219.06 | 219.06 | 218.8 | 218.9 | 3845.0 |
| 2024-09-16 05:10:00 | AAPL | Stock | 219.0 | 219.0 | 218.9 | 218.9 | 4785.0 |
| 2024-09-16 05:15:00 | AAPL | Stock | 218.9 | 219.0 | 218.52 | 218.68 | 4926.0 |
| 2024-09-16 05:20:00 | AAPL | Stock | 218.73 | 218.73 | 218.61 | 218.7 | 3195.0 |
| 2024-09-16 05:25:00 | AAPL | Stock | 218.75 | 218.96 | 218.68 | 218.96 | 2690.0 |
| 2024-09-16 05:30:00 | AAPL | Stock | 218.88 | 218.88 | 218.71 | 218.79 | 2382.0 |
| 2024-09-16 05:35:00 | AAPL | Stock | 218.79 | 219.0 | 218.79 | 218.89 | 1890.0 |
| 2024-09-16 05:40:00 | AAPL | Stock | 218.89 | 218.9 | 218.5 | 218.5 | 6293.0 |
| 2024-09-16 05:45:00 | AAPL | Stock | 218.7 | 218.7 | 218.59 | 218.59 | 200.0 |
| 2024-09-16 05:50:00 | AAPL | Stock | 218.5 | 218.75 | 218.5 | 218.75 | 650.0 |
| 2024-09-16 05:55:00 | AAPL | Stock | 218.87 | 218.99 | 218.82 | 218.82 | 2007.0 |
| 2024-09-16 06:00:00 | AAPL | Stock | 218.75 | 218.75 | 218.75 | 218.75 | 300.0 |
| 2024-09-16 06:05:00 | AAPL | Stock | 218.81 | 218.9 | 218.81 | 218.86 | 573.0 |
| 2024-09-16 06:10:00 | AAPL | Stock | 218.75 | 218.75 | 218.68 | 218.74 | 1378.0 |
| 2024-09-16 06:15:00 | AAPL | Stock | 218.74 | 218.74 | 218.6 | 218.74 | 3396.0 |
| 2024-09-16 06:20:00 | AAPL | Stock | 218.55 | 218.55 | 217.99 | 217.99 | 17239.0 |
| 2024-09-16 06:25:00 | AAPL | Stock | 217.95 | 217.95 | 217.71 | 217.9 | 9876.0 |
| 2024-09-16 06:30:00 | AAPL | Stock | 217.81 | 217.9 | 217.58 | 217.6 | 14742.0 |
| 2024-09-16 06:35:00 | AAPL | Stock | 217.67 | 217.8 | 217.58 | 217.65 | 19414.0 |
| 2024-09-16 06:40:00 | AAPL | Stock | 217.65 | 217.93 | 217.65 | 217.87 | 7184.0 |
| 2024-09-16 06:45:00 | AAPL | Stock | 217.89 | 218.0 | 217.84 | 218.0 | 6875.0 |
| 2024-09-16 06:50:00 | AAPL | Stock | 217.81 | 218.25 | 217.81 | 218.19 | 10097.0 |
| 2024-09-16 06:55:00 | AAPL | Stock | 218.16 | 218.23 | 218.07 | 218.2 | 7123.0 |
| 2024-09-16 07:00:00 | AAPL | Stock | 218.25 | 218.6 | 218.0 | 218.1 | 34602.0 |
| 2024-09-16 07:05:00 | AAPL | Stock | 218.01 | 218.01 | 217.62 | 217.62 | 9386.0 |
| 2024-09-16 07:10:00 | AAPL | Stock | 217.61 | 217.75 | 217.59 | 217.75 | 33261.0 |
| 2024-09-16 07:15:00 | AAPL | Stock | 217.75 | 217.75 | 217.27 | 217.3 | 35609.0 |
| 2024-09-16 07:20:00 | AAPL | Stock | 217.3 | 217.3 | 217.0 | 217.2 | 29495.0 |
| 2024-09-16 07:25:00 | AAPL | Stock | 217.23 | 217.25 | 217.15 | 217.18 | 21991.0 |
| 2024-09-16 07:30:00 | AAPL | Stock | 217.25 | 217.53 | 217.2 | 217.5 | 12938.0 |
| 2024-09-16 07:35:00 | AAPL | Stock | 217.47 | 217.65 | 217.45 | 217.6 | 8627.0 |
| 2024-09-16 07:40:00 | AAPL | Stock | 217.6 | 217.65 | 217.0 | 217.0 | 44999.0 |
| 2024-09-16 07:45:00 | AAPL | Stock | 217.15 | 217.3 | 217.1 | 217.2 | 14767.0 |
| 2024-09-16 07:50:00 | AAPL | Stock | 217.2 | 217.2 | 216.93 | 217.1 | 26095.0 |
| 2024-09-16 07:55:00 | AAPL | Stock | 217.2 | 217.2 | 216.95 | 217.0 | 18252.0 |
| 2024-09-16 08:00:00 | AAPL | Stock | 217.0 | 221.96 | 216.9411 | 216.96 | 141460.0 |
| 2024-09-16 08:05:00 | AAPL | Stock | 216.96 | 217.0 | 216.79 | 216.86 | 32564.0 |
> showing 50 of 398,561 rows — these rows as CSV