PREVIEW / stock_30min / 2024-09-20
file: by_date/stock_30min/2024/2024-09-20.parquet size: 2.1 MB rows: 99,319 symbols: 791
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-20 04:00:00 | AAPL | Stock | 228.15 | 228.42 | 227.74 | 228.06 | 20389.0 |
| 2024-09-20 04:30:00 | AAPL | Stock | 227.99 | 228.06 | 227.75 | 227.84 | 11050.0 |
| 2024-09-20 05:00:00 | AAPL | Stock | 227.9 | 227.92 | 227.5 | 227.68 | 16924.0 |
| 2024-09-20 05:30:00 | AAPL | Stock | 227.45 | 227.63 | 227.4 | 227.63 | 6736.0 |
| 2024-09-20 06:00:00 | AAPL | Stock | 227.5 | 227.6 | 227.35 | 227.6 | 5616.0 |
| 2024-09-20 06:30:00 | AAPL | Stock | 227.52 | 227.52 | 227.11 | 227.2 | 11090.0 |
| 2024-09-20 07:00:00 | AAPL | Stock | 227.47 | 227.98 | 227.42 | 227.8 | 31903.0 |
| 2024-09-20 07:30:00 | AAPL | Stock | 227.66 | 227.91 | 227.37 | 227.9 | 27464.0 |
| 2024-09-20 08:00:00 | AAPL | Stock | 227.4573 | 228.75 | 227.4201 | 228.4 | 134769.0 |
| 2024-09-20 08:30:00 | AAPL | Stock | 228.5 | 229.99 | 228.5 | 229.442 | 245382.0 |
| 2024-09-20 09:00:00 | AAPL | Stock | 229.48 | 230.23 | 228.74 | 229.98 | 360569.0 |
| 2024-09-20 09:30:00 | AAPL | Stock | 229.97 | 231.16 | 229.22 | 230.0 | 17274353.0 |
| 2024-09-20 10:00:00 | AAPL | Stock | 230.0 | 230.3573 | 229.37 | 230.0345 | 3719503.0 |
| 2024-09-20 10:30:00 | AAPL | Stock | 230.03 | 230.58 | 229.58 | 230.305 | 3452967.0 |
| 2024-09-20 11:00:00 | AAPL | Stock | 230.305 | 230.485 | 229.2 | 229.77 | 3341189.0 |
| 2024-09-20 11:30:00 | AAPL | Stock | 229.76 | 230.9499 | 229.74 | 230.8 | 3018708.0 |
| 2024-09-20 12:00:00 | AAPL | Stock | 230.8 | 231.74 | 230.75 | 231.73 | 2712601.0 |
| 2024-09-20 12:30:00 | AAPL | Stock | 231.73 | 231.93 | 231.3301 | 231.845 | 2331669.0 |
| 2024-09-20 13:00:00 | AAPL | Stock | 231.845 | 231.9 | 230.61 | 230.75 | 2775616.0 |
| 2024-09-20 13:30:00 | AAPL | Stock | 230.75 | 231.26 | 230.61 | 230.665 | 2383195.0 |
| 2024-09-20 14:00:00 | AAPL | Stock | 230.665 | 230.78 | 229.59 | 229.7772 | 3690010.0 |
| 2024-09-20 14:30:00 | AAPL | Stock | 229.77 | 231.61 | 229.5 | 231.48 | 3986078.0 |
| 2024-09-20 15:00:00 | AAPL | Stock | 231.478 | 232.0 | 231.2 | 231.975 | 4241315.0 |
| 2024-09-20 15:30:00 | AAPL | Stock | 231.975 | 233.09 | 227.62 | 228.53 | 21957847.0 |
| 2024-09-20 16:00:00 | AAPL | Stock | 228.53 | 228.7 | 227.75 | 228.07 | 118005950.0 |
| 2024-09-20 16:30:00 | AAPL | Stock | 228.14 | 228.45 | 228.05 | 228.05 | 421537.0 |
| 2024-09-20 17:00:00 | AAPL | Stock | 228.05 | 228.23 | 227.8 | 227.85 | 115723.0 |
| 2024-09-20 17:30:00 | AAPL | Stock | 227.9 | 227.915 | 227.8 | 227.8704 | 20802.0 |
| 2024-09-20 18:00:00 | AAPL | Stock | 227.8732 | 228.0 | 227.78 | 227.9 | 23647.0 |
| 2024-09-20 18:30:00 | AAPL | Stock | 227.93 | 227.94 | 227.77 | 227.85 | 25959.0 |
| 2024-09-20 19:00:00 | AAPL | Stock | 227.86 | 227.88 | 227.8 | 227.86 | 13150.0 |
| 2024-09-20 19:30:00 | AAPL | Stock | 227.87 | 227.94 | 227.72 | 227.76 | 22411.0 |
| 2024-09-20 04:00:00 | MSFT | Stock | 438.14 | 438.79 | 438.0 | 438.0 | 1605.0 |
| 2024-09-20 04:30:00 | MSFT | Stock | 438.21 | 438.21 | 438.0 | 438.19 | 589.0 |
| 2024-09-20 05:00:00 | MSFT | Stock | 438.11 | 438.19 | 438.11 | 438.19 | 236.0 |
| 2024-09-20 05:30:00 | MSFT | Stock | 438.0 | 438.0 | 437.85 | 437.91 | 667.0 |
| 2024-09-20 06:00:00 | MSFT | Stock | 437.75 | 437.75 | 437.48 | 437.49 | 833.0 |
| 2024-09-20 06:30:00 | MSFT | Stock | 437.32 | 437.32 | 436.69 | 436.89 | 2296.0 |
| 2024-09-20 07:00:00 | MSFT | Stock | 437.0 | 437.55 | 437.0 | 437.55 | 2114.0 |
| 2024-09-20 07:30:00 | MSFT | Stock | 437.38 | 438.0 | 437.38 | 438.0 | 1125.0 |
| 2024-09-20 08:00:00 | MSFT | Stock | 437.55 | 438.99 | 437.0 | 438.91 | 8366.0 |
| 2024-09-20 08:30:00 | MSFT | Stock | 438.9 | 439.39 | 438.67 | 439.39 | 6835.0 |
| 2024-09-20 09:00:00 | MSFT | Stock | 439.4999 | 439.4999 | 436.49 | 437.05 | 86715.0 |
| 2024-09-20 09:30:00 | MSFT | Stock | 437.05 | 439.24 | 436.49 | 436.785 | 6181853.0 |
| 2024-09-20 10:00:00 | MSFT | Stock | 436.785 | 437.4 | 435.69 | 435.835 | 542031.0 |
| 2024-09-20 10:30:00 | MSFT | Stock | 435.82 | 436.45 | 434.9 | 434.99 | 487569.0 |
| 2024-09-20 11:00:00 | MSFT | Stock | 435.02 | 435.63 | 434.22 | 434.7707 | 362052.0 |
| 2024-09-20 11:30:00 | MSFT | Stock | 434.73 | 436.43 | 434.66 | 435.86 | 362655.0 |
| 2024-09-20 12:00:00 | MSFT | Stock | 435.88 | 437.51 | 435.72 | 437.295 | 365753.0 |
| 2024-09-20 12:30:00 | MSFT | Stock | 437.24 | 437.96 | 436.76 | 437.255 | 316168.0 |
> showing 50 of 99,319 rows — these rows as CSV