PREVIEW / stock_30min / 2022-12-16
file: by_date/stock_30min/2022/2022-12-16.parquet size: 2.1 MB rows: 104,835 symbols: 1,986
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-12-16 04:00:00 | AAPL | Stock | 136.42 | 136.42 | 134.9 | 135.14 | 65413.0 |
| 2022-12-16 04:30:00 | AAPL | Stock | 135.15 | 135.5 | 135.04 | 135.5 | 17178.0 |
| 2022-12-16 05:00:00 | AAPL | Stock | 135.52 | 135.68 | 135.27 | 135.34 | 13369.0 |
| 2022-12-16 05:30:00 | AAPL | Stock | 135.34 | 135.56 | 135.2 | 135.38 | 10625.0 |
| 2022-12-16 06:00:00 | AAPL | Stock | 135.37 | 136.0 | 135.31 | 135.98 | 19456.0 |
| 2022-12-16 06:30:00 | AAPL | Stock | 135.97 | 136.12 | 135.8 | 135.81 | 22255.0 |
| 2022-12-16 07:00:00 | AAPL | Stock | 135.9 | 136.48 | 135.89 | 136.21 | 67743.0 |
| 2022-12-16 07:30:00 | AAPL | Stock | 136.19 | 136.7 | 136.11 | 136.7 | 63653.0 |
| 2022-12-16 08:00:00 | AAPL | Stock | 136.0716 | 136.91 | 134.9215 | 136.48 | 197629.0 |
| 2022-12-16 08:30:00 | AAPL | Stock | 136.46 | 136.49 | 136.15 | 136.47 | 155643.0 |
| 2022-12-16 09:00:00 | AAPL | Stock | 136.42 | 136.96 | 135.51 | 136.58 | 1032267.0 |
| 2022-12-16 09:30:00 | AAPL | Stock | 136.685 | 137.65 | 135.675 | 136.635 | 20346174.0 |
| 2022-12-16 10:00:00 | AAPL | Stock | 136.6318 | 136.6631 | 134.8431 | 135.06 | 7152719.0 |
| 2022-12-16 10:30:00 | AAPL | Stock | 135.07 | 135.374 | 134.682 | 135.14 | 4569674.0 |
| 2022-12-16 11:00:00 | AAPL | Stock | 135.145 | 135.23 | 134.42 | 134.64 | 4305166.0 |
| 2022-12-16 11:30:00 | AAPL | Stock | 134.64 | 135.18 | 134.36 | 134.535 | 3497615.0 |
| 2022-12-16 12:00:00 | AAPL | Stock | 134.53 | 134.91 | 134.479 | 134.87 | 3069387.0 |
| 2022-12-16 12:30:00 | AAPL | Stock | 134.88 | 135.3399 | 134.26 | 134.311 | 3140153.0 |
| 2022-12-16 13:00:00 | AAPL | Stock | 134.31 | 134.42 | 133.94 | 134.0128 | 3723889.0 |
| 2022-12-16 13:30:00 | AAPL | Stock | 134.015 | 134.365 | 133.945 | 134.305 | 3246083.0 |
| 2022-12-16 14:00:00 | AAPL | Stock | 134.308 | 134.48 | 133.97 | 134.005 | 3760840.0 |
| 2022-12-16 14:30:00 | AAPL | Stock | 134.005 | 134.54 | 133.73 | 134.37 | 3738500.0 |
| 2022-12-16 15:00:00 | AAPL | Stock | 134.36 | 134.99 | 134.13 | 134.8781 | 4533852.0 |
| 2022-12-16 15:30:00 | AAPL | Stock | 134.88 | 135.45 | 134.45 | 134.52 | 11733825.0 |
| 2022-12-16 16:00:00 | AAPL | Stock | 134.52 | 135.09 | 134.3 | 134.34 | 52450267.0 |
| 2022-12-16 16:30:00 | AAPL | Stock | 134.33 | 134.51 | 134.25 | 134.39 | 74658.0 |
| 2022-12-16 17:00:00 | AAPL | Stock | 134.39 | 134.51 | 134.31 | 134.34 | 141874.0 |
| 2022-12-16 17:30:00 | AAPL | Stock | 134.34 | 134.52 | 134.29 | 134.4463 | 46223.0 |
| 2022-12-16 18:00:00 | AAPL | Stock | 134.46 | 134.52 | 134.44 | 134.46 | 19197.0 |
| 2022-12-16 18:30:00 | AAPL | Stock | 134.49 | 134.5 | 134.43 | 134.43 | 22317.0 |
| 2022-12-16 19:00:00 | AAPL | Stock | 134.43 | 134.49 | 134.43 | 134.47 | 5285.0 |
| 2022-12-16 19:30:00 | AAPL | Stock | 134.48 | 134.51 | 134.41 | 134.42 | 18936.0 |
| 2022-12-16 04:00:00 | MSFT | Stock | 246.88 | 247.0 | 245.42 | 245.56 | 11962.0 |
| 2022-12-16 04:30:00 | MSFT | Stock | 245.71 | 246.38 | 245.51 | 246.38 | 3498.0 |
| 2022-12-16 05:00:00 | MSFT | Stock | 246.32 | 247.0 | 245.79 | 245.93 | 5355.0 |
| 2022-12-16 05:30:00 | MSFT | Stock | 246.36 | 246.77 | 246.1 | 246.77 | 1844.0 |
| 2022-12-16 06:00:00 | MSFT | Stock | 246.7 | 247.28 | 246.53 | 247.28 | 2041.0 |
| 2022-12-16 06:30:00 | MSFT | Stock | 247.56 | 247.74 | 247.2 | 247.2 | 800.0 |
| 2022-12-16 07:00:00 | MSFT | Stock | 247.26 | 247.6 | 246.66 | 246.66 | 6801.0 |
| 2022-12-16 07:30:00 | MSFT | Stock | 246.82 | 247.95 | 246.82 | 247.94 | 6856.0 |
| 2022-12-16 08:00:00 | MSFT | Stock | 247.0008 | 247.85 | 246.3297 | 247.16 | 26565.0 |
| 2022-12-16 08:30:00 | MSFT | Stock | 247.06 | 247.198 | 246.76 | 247.198 | 9919.0 |
| 2022-12-16 09:00:00 | MSFT | Stock | 247.34 | 249.47 | 245.99 | 248.61 | 351191.0 |
| 2022-12-16 09:30:00 | MSFT | Stock | 248.55 | 249.84 | 247.9 | 248.59 | 8245364.0 |
| 2022-12-16 10:00:00 | MSFT | Stock | 248.5907 | 248.5907 | 245.8607 | 245.95 | 1293511.0 |
| 2022-12-16 10:30:00 | MSFT | Stock | 245.91 | 246.3499 | 244.81 | 245.49 | 1300957.0 |
| 2022-12-16 11:00:00 | MSFT | Stock | 245.48 | 245.6 | 244.01 | 244.14 | 1221243.0 |
| 2022-12-16 11:30:00 | MSFT | Stock | 244.2 | 244.92 | 243.59 | 243.78 | 1350761.0 |
| 2022-12-16 12:00:00 | MSFT | Stock | 243.79 | 244.465 | 243.55 | 244.46 | 998890.0 |
| 2022-12-16 12:30:00 | MSFT | Stock | 244.46 | 245.1 | 243.69 | 243.88 | 969749.0 |
> showing 50 of 104,835 rows — these rows as CSV