PREVIEW / stock_30min / 2024-08-05
file: by_date/stock_30min/2024/2024-08-05.parquet size: 2.2 MB rows: 112,242 symbols: 897
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-08-05 04:00:00 | AAPL | Stock | 206.94 | 207.9 | 202.0 | 203.81 | 225187.0 |
| 2024-08-05 04:30:00 | AAPL | Stock | 203.93 | 204.29 | 202.13 | 202.3 | 101289.0 |
| 2024-08-05 05:00:00 | AAPL | Stock | 202.4 | 203.06 | 200.51 | 202.0 | 149804.0 |
| 2024-08-05 05:30:00 | AAPL | Stock | 202.24 | 202.62 | 200.48 | 202.4 | 84452.0 |
| 2024-08-05 06:00:00 | AAPL | Stock | 202.39 | 202.49 | 200.6 | 201.44 | 69624.0 |
| 2024-08-05 06:30:00 | AAPL | Stock | 201.44 | 203.5 | 200.05 | 203.25 | 147501.0 |
| 2024-08-05 07:00:00 | AAPL | Stock | 203.44 | 206.12 | 202.5 | 204.23 | 426474.0 |
| 2024-08-05 07:30:00 | AAPL | Stock | 204.31 | 205.68 | 202.5 | 203.07 | 280384.0 |
| 2024-08-05 08:00:00 | AAPL | Stock | 203.0 | 206.1294 | 197.08 | 200.17 | 970984.0 |
| 2024-08-05 08:30:00 | AAPL | Stock | 200.27 | 200.35 | 196.51 | 197.65 | 1224512.0 |
| 2024-08-05 09:00:00 | AAPL | Stock | 197.65 | 200.56 | 197.0 | 199.02 | 1221560.0 |
| 2024-08-05 09:30:00 | AAPL | Stock | 199.09 | 211.12 | 196.0 | 207.63 | 20599582.0 |
| 2024-08-05 10:00:00 | AAPL | Stock | 207.83 | 211.01 | 207.7 | 207.9787 | 6632792.0 |
| 2024-08-05 10:30:00 | AAPL | Stock | 207.9407 | 210.4 | 207.82 | 209.5599 | 4657647.0 |
| 2024-08-05 11:00:00 | AAPL | Stock | 209.57 | 213.5 | 208.74 | 211.17 | 5597294.0 |
| 2024-08-05 11:30:00 | AAPL | Stock | 211.2 | 211.888 | 209.505 | 210.335 | 3734185.0 |
| 2024-08-05 12:00:00 | AAPL | Stock | 210.335 | 213.0 | 210.02 | 212.615 | 2731326.0 |
| 2024-08-05 12:30:00 | AAPL | Stock | 212.62 | 212.65 | 209.72 | 210.38 | 2465908.0 |
| 2024-08-05 13:00:00 | AAPL | Stock | 210.36 | 211.79 | 209.91 | 210.8 | 2287692.0 |
| 2024-08-05 13:30:00 | AAPL | Stock | 210.782 | 211.89 | 210.51 | 210.76 | 1859823.0 |
| 2024-08-05 14:00:00 | AAPL | Stock | 210.77 | 210.91 | 209.36 | 210.57 | 1992144.0 |
| 2024-08-05 14:30:00 | AAPL | Stock | 210.57 | 210.95 | 203.91 | 204.7596 | 7692197.0 |
| 2024-08-05 15:00:00 | AAPL | Stock | 204.79 | 207.14 | 204.06 | 206.43 | 5260722.0 |
| 2024-08-05 15:30:00 | AAPL | Stock | 206.43 | 209.38 | 206.01 | 209.2 | 8504415.0 |
| 2024-08-05 16:00:00 | AAPL | Stock | 209.27 | 211.47 | 208.7 | 210.3 | 12373753.0 |
| 2024-08-05 16:30:00 | AAPL | Stock | 210.4 | 210.8 | 209.0 | 210.7996 | 235654.0 |
| 2024-08-05 17:00:00 | AAPL | Stock | 210.64 | 210.8 | 209.27 | 210.6001 | 81390.0 |
| 2024-08-05 17:30:00 | AAPL | Stock | 210.6001 | 210.69 | 210.26 | 210.34 | 20298.0 |
| 2024-08-05 18:00:00 | AAPL | Stock | 210.33 | 211.38 | 210.26 | 210.62 | 44783.0 |
| 2024-08-05 18:30:00 | AAPL | Stock | 210.78 | 210.79 | 210.29 | 210.45 | 23152.0 |
| 2024-08-05 19:00:00 | AAPL | Stock | 210.5 | 210.96 | 210.45 | 210.9 | 26940.0 |
| 2024-08-05 19:30:00 | AAPL | Stock | 210.959 | 212.0 | 210.959 | 211.85 | 57332.0 |
| 2024-08-05 04:00:00 | MSFT | Stock | 389.8 | 395.76 | 385.36 | 393.49 | 36309.0 |
| 2024-08-05 04:30:00 | MSFT | Stock | 394.0 | 394.0 | 388.5 | 388.96 | 17617.0 |
| 2024-08-05 05:00:00 | MSFT | Stock | 389.0 | 392.0 | 387.08 | 392.0 | 19495.0 |
| 2024-08-05 05:30:00 | MSFT | Stock | 392.39 | 393.0 | 390.0 | 391.22 | 35795.0 |
| 2024-08-05 06:00:00 | MSFT | Stock | 391.6 | 392.28 | 389.82 | 389.82 | 5560.0 |
| 2024-08-05 06:30:00 | MSFT | Stock | 390.9 | 391.79 | 386.0 | 391.79 | 19565.0 |
| 2024-08-05 07:00:00 | MSFT | Stock | 392.0 | 393.89 | 391.26 | 392.36 | 62438.0 |
| 2024-08-05 07:30:00 | MSFT | Stock | 392.36 | 392.36 | 388.87 | 391.2 | 72640.0 |
| 2024-08-05 08:00:00 | MSFT | Stock | 392.0 | 409.511 | 368.95 | 384.98 | 188135.0 |
| 2024-08-05 08:30:00 | MSFT | Stock | 385.11 | 389.0 | 383.01 | 387.86 | 96054.0 |
| 2024-08-05 09:00:00 | MSFT | Stock | 388.3336 | 392.18 | 385.3 | 388.74 | 170330.0 |
| 2024-08-05 09:30:00 | MSFT | Stock | 389.2 | 397.0 | 385.58 | 393.57 | 5775301.0 |
| 2024-08-05 10:00:00 | MSFT | Stock | 393.53 | 397.43 | 392.87 | 394.43 | 2286204.0 |
| 2024-08-05 10:30:00 | MSFT | Stock | 394.425 | 399.48 | 394.38 | 396.725 | 1405091.0 |
| 2024-08-05 11:00:00 | MSFT | Stock | 396.6 | 400.0 | 395.0 | 399.08 | 1158069.0 |
| 2024-08-05 11:30:00 | MSFT | Stock | 399.02 | 400.7 | 397.07 | 398.79 | 937601.0 |
| 2024-08-05 12:00:00 | MSFT | Stock | 398.76 | 401.04 | 398.07 | 400.76 | 651812.0 |
| 2024-08-05 12:30:00 | MSFT | Stock | 400.76 | 400.76 | 396.457 | 396.99 | 651358.0 |
> showing 50 of 112,242 rows — these rows as CSV