PREVIEW / stock_30min / 2022-09-06
file: by_date/stock_30min/2022/2022-09-06.parquet size: 2.1 MB rows: 104,175 symbols: 2,190
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 |
|---|---|---|---|---|---|---|---|
| 2022-09-06 04:00:00 | AAPL | Stock | 156.22 | 157.33 | 156.22 | 156.78 | 20892.0 |
| 2022-09-06 04:30:00 | AAPL | Stock | 156.86 | 157.29 | 156.8 | 157.23 | 14573.0 |
| 2022-09-06 05:00:00 | AAPL | Stock | 157.19 | 157.19 | 156.83 | 157.12 | 16599.0 |
| 2022-09-06 05:30:00 | AAPL | Stock | 157.08 | 157.09 | 156.96 | 157.07 | 2829.0 |
| 2022-09-06 06:00:00 | AAPL | Stock | 157.06 | 157.39 | 156.97 | 157.28 | 13362.0 |
| 2022-09-06 06:30:00 | AAPL | Stock | 157.24 | 157.28 | 157.02 | 157.17 | 19811.0 |
| 2022-09-06 07:00:00 | AAPL | Stock | 157.05 | 157.18 | 156.6 | 156.65 | 56090.0 |
| 2022-09-06 07:30:00 | AAPL | Stock | 156.62 | 156.88 | 156.34 | 156.85 | 36562.0 |
| 2022-09-06 08:00:00 | AAPL | Stock | 157.16 | 157.88 | 155.421 | 156.74 | 183576.0 |
| 2022-09-06 08:30:00 | AAPL | Stock | 156.7 | 157.0 | 156.64 | 156.89 | 76292.0 |
| 2022-09-06 09:00:00 | AAPL | Stock | 156.9 | 157.1277 | 156.28 | 156.44 | 164730.0 |
| 2022-09-06 09:30:00 | AAPL | Stock | 156.46 | 157.09 | 155.06 | 155.26 | 7898467.0 |
| 2022-09-06 10:00:00 | AAPL | Stock | 155.26 | 155.3 | 153.69 | 154.7208 | 6861767.0 |
| 2022-09-06 10:30:00 | AAPL | Stock | 154.71 | 156.44 | 154.48 | 156.12 | 5306503.0 |
| 2022-09-06 11:00:00 | AAPL | Stock | 156.1129 | 156.53 | 155.481 | 155.58 | 4109557.0 |
| 2022-09-06 11:30:00 | AAPL | Stock | 155.585 | 156.4583 | 155.48 | 156.0738 | 3432353.0 |
| 2022-09-06 12:00:00 | AAPL | Stock | 156.08 | 156.27 | 154.64 | 154.9 | 3548754.0 |
| 2022-09-06 12:30:00 | AAPL | Stock | 154.91 | 155.415 | 154.67 | 155.215 | 2868063.0 |
| 2022-09-06 13:00:00 | AAPL | Stock | 155.2054 | 155.27 | 154.09 | 154.201 | 3066883.0 |
| 2022-09-06 13:30:00 | AAPL | Stock | 154.22 | 154.68 | 153.904 | 154.5 | 2648392.0 |
| 2022-09-06 14:00:00 | AAPL | Stock | 154.5 | 155.12 | 154.38 | 154.81 | 2873375.0 |
| 2022-09-06 14:30:00 | AAPL | Stock | 154.81 | 154.91 | 154.2 | 154.33 | 2397993.0 |
| 2022-09-06 15:00:00 | AAPL | Stock | 154.33 | 155.1 | 154.0816 | 154.55 | 3703160.0 |
| 2022-09-06 15:30:00 | AAPL | Stock | 154.56 | 154.67 | 153.99 | 154.54 | 7920227.0 |
| 2022-09-06 16:00:00 | AAPL | Stock | 154.54 | 154.85 | 154.32 | 154.4 | 5385565.0 |
| 2022-09-06 16:30:00 | AAPL | Stock | 154.4 | 154.77 | 154.38 | 154.71 | 81231.0 |
| 2022-09-06 17:00:00 | AAPL | Stock | 154.74 | 154.75 | 154.57 | 154.65 | 19146.0 |
| 2022-09-06 17:30:00 | AAPL | Stock | 154.62 | 154.73 | 154.62 | 154.63 | 9628.0 |
| 2022-09-06 18:00:00 | AAPL | Stock | 154.7 | 154.87 | 154.63 | 154.76 | 26500.0 |
| 2022-09-06 18:30:00 | AAPL | Stock | 154.76 | 154.76 | 154.65 | 154.65 | 8935.0 |
| 2022-09-06 19:00:00 | AAPL | Stock | 154.68 | 154.73 | 154.5 | 154.67 | 21040.0 |
| 2022-09-06 19:30:00 | AAPL | Stock | 154.65 | 154.75 | 154.48 | 154.49 | 33210.0 |
| 2022-09-06 04:00:00 | MSFT | Stock | 257.91 | 257.91 | 257.11 | 257.74 | 4415.0 |
| 2022-09-06 04:30:00 | MSFT | Stock | 257.6 | 258.0 | 257.6 | 258.0 | 2363.0 |
| 2022-09-06 05:00:00 | MSFT | Stock | 257.82 | 257.82 | 257.67 | 257.67 | 300.0 |
| 2022-09-06 05:30:00 | MSFT | Stock | 257.72 | 257.88 | 257.72 | 257.88 | 336.0 |
| 2022-09-06 06:00:00 | MSFT | Stock | 257.85 | 258.49 | 257.85 | 258.49 | 1696.0 |
| 2022-09-06 06:30:00 | MSFT | Stock | 258.3 | 258.3 | 257.82 | 257.82 | 535.0 |
| 2022-09-06 07:00:00 | MSFT | Stock | 257.65 | 257.77 | 257.2 | 257.2 | 7592.0 |
| 2022-09-06 07:30:00 | MSFT | Stock | 257.16 | 257.16 | 256.42 | 257.09 | 4351.0 |
| 2022-09-06 08:00:00 | MSFT | Stock | 257.56 | 258.82 | 255.42 | 256.75 | 11768.0 |
| 2022-09-06 08:30:00 | MSFT | Stock | 256.7836 | 257.35 | 256.7367 | 257.35 | 6319.0 |
| 2022-09-06 09:00:00 | MSFT | Stock | 257.14 | 257.25 | 256.1 | 256.32 | 17189.0 |
| 2022-09-06 09:30:00 | MSFT | Stock | 256.16 | 257.83 | 254.7001 | 255.525 | 1791426.0 |
| 2022-09-06 10:00:00 | MSFT | Stock | 255.49 | 255.49 | 252.66 | 254.34 | 1329091.0 |
| 2022-09-06 10:30:00 | MSFT | Stock | 254.35 | 256.97 | 253.84 | 256.5 | 1058508.0 |
| 2022-09-06 11:00:00 | MSFT | Stock | 256.505 | 257.13 | 255.21 | 255.43 | 919830.0 |
| 2022-09-06 11:30:00 | MSFT | Stock | 255.43 | 256.94 | 255.24 | 256.115 | 704468.0 |
| 2022-09-06 12:00:00 | MSFT | Stock | 256.11 | 256.2 | 253.5 | 253.93 | 668291.0 |
| 2022-09-06 12:30:00 | MSFT | Stock | 253.92 | 254.56 | 253.48 | 254.32 | 547392.0 |
> showing 50 of 104,175 rows — these rows as CSV