PREVIEW / stock_30min / 2022-12-27
file: by_date/stock_30min/2022/2022-12-27.parquet size: 2.1 MB rows: 103,549 symbols: 1,950
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-27 04:00:00 | AAPL | Stock | 132.52 | 133.24 | 132.33 | 132.41 | 14123.0 |
| 2022-12-27 04:30:00 | AAPL | Stock | 132.44 | 132.64 | 132.44 | 132.61 | 4582.0 |
| 2022-12-27 05:00:00 | AAPL | Stock | 132.68 | 132.82 | 132.67 | 132.72 | 8612.0 |
| 2022-12-27 05:30:00 | AAPL | Stock | 132.71 | 132.75 | 132.54 | 132.55 | 5758.0 |
| 2022-12-27 06:00:00 | AAPL | Stock | 132.54 | 132.56 | 132.43 | 132.43 | 12098.0 |
| 2022-12-27 06:30:00 | AAPL | Stock | 132.41 | 132.46 | 132.2 | 132.38 | 16613.0 |
| 2022-12-27 07:00:00 | AAPL | Stock | 132.34 | 132.4 | 131.8 | 131.8 | 41816.0 |
| 2022-12-27 07:30:00 | AAPL | Stock | 131.82 | 131.92 | 131.62 | 131.62 | 48469.0 |
| 2022-12-27 08:00:00 | AAPL | Stock | 132.37 | 132.6985 | 131.5 | 131.7 | 154869.0 |
| 2022-12-27 08:30:00 | AAPL | Stock | 131.7192 | 131.7192 | 131.11 | 131.24 | 141228.0 |
| 2022-12-27 09:00:00 | AAPL | Stock | 131.21 | 131.66 | 131.03 | 131.36 | 145211.0 |
| 2022-12-27 09:30:00 | AAPL | Stock | 131.42 | 131.42 | 129.18 | 129.3399 | 8651523.0 |
| 2022-12-27 10:00:00 | AAPL | Stock | 129.33 | 130.28 | 128.72 | 130.1652 | 7713918.0 |
| 2022-12-27 10:30:00 | AAPL | Stock | 130.16 | 130.42 | 129.71 | 129.8428 | 4930143.0 |
| 2022-12-27 11:00:00 | AAPL | Stock | 129.85 | 129.95 | 129.18 | 129.7257 | 4334652.0 |
| 2022-12-27 11:30:00 | AAPL | Stock | 129.72 | 130.14 | 129.51 | 129.95 | 3349523.0 |
| 2022-12-27 12:00:00 | AAPL | Stock | 129.9457 | 130.5299 | 129.88 | 129.93 | 3012690.0 |
| 2022-12-27 12:30:00 | AAPL | Stock | 129.925 | 130.1799 | 129.68 | 130.13 | 2451894.0 |
| 2022-12-27 13:00:00 | AAPL | Stock | 130.135 | 130.37 | 129.93 | 130.005 | 2410366.0 |
| 2022-12-27 13:30:00 | AAPL | Stock | 129.995 | 130.16 | 129.62 | 129.675 | 2777440.0 |
| 2022-12-27 14:00:00 | AAPL | Stock | 129.68 | 130.08 | 129.65 | 129.9299 | 2427311.0 |
| 2022-12-27 14:30:00 | AAPL | Stock | 129.9203 | 130.31 | 129.88 | 130.1884 | 2336367.0 |
| 2022-12-27 15:00:00 | AAPL | Stock | 130.185 | 130.41 | 130.0 | 130.26 | 3131720.0 |
| 2022-12-27 15:30:00 | AAPL | Stock | 130.27 | 130.59 | 129.94 | 130.05 | 5156794.0 |
| 2022-12-27 16:00:00 | AAPL | Stock | 130.05 | 130.15 | 129.99 | 130.09 | 5981883.0 |
| 2022-12-27 16:30:00 | AAPL | Stock | 130.12 | 130.13 | 129.98 | 130.02 | 51138.0 |
| 2022-12-27 17:00:00 | AAPL | Stock | 129.96 | 130.08 | 129.89 | 129.98 | 56284.0 |
| 2022-12-27 17:30:00 | AAPL | Stock | 129.94 | 130.03 | 129.92 | 129.96 | 15796.0 |
| 2022-12-27 18:00:00 | AAPL | Stock | 130.0 | 130.14 | 129.96 | 130.03 | 15851.0 |
| 2022-12-27 18:30:00 | AAPL | Stock | 130.05 | 130.09 | 129.9 | 129.97 | 16333.0 |
| 2022-12-27 19:00:00 | AAPL | Stock | 130.0 | 130.1 | 129.93 | 130.0 | 8794.0 |
| 2022-12-27 19:30:00 | AAPL | Stock | 130.0 | 130.0 | 129.5 | 129.5 | 23899.0 |
| 2022-12-27 04:00:00 | MSFT | Stock | 240.8 | 240.8 | 239.65 | 239.7 | 1401.0 |
| 2022-12-27 04:30:00 | MSFT | Stock | 239.62 | 240.29 | 239.62 | 240.29 | 5939.0 |
| 2022-12-27 05:00:00 | MSFT | Stock | 240.0 | 240.17 | 240.0 | 240.17 | 1411.0 |
| 2022-12-27 05:30:00 | MSFT | Stock | 240.15 | 240.15 | 239.8 | 239.8 | 1620.0 |
| 2022-12-27 06:00:00 | MSFT | Stock | 239.76 | 239.89 | 239.7 | 239.89 | 3775.0 |
| 2022-12-27 06:30:00 | MSFT | Stock | 239.85 | 240.16 | 239.73 | 240.16 | 7423.0 |
| 2022-12-27 07:00:00 | MSFT | Stock | 239.97 | 239.99 | 239.67 | 239.7 | 10855.0 |
| 2022-12-27 07:30:00 | MSFT | Stock | 239.69 | 239.96 | 239.43 | 239.43 | 30831.0 |
| 2022-12-27 08:00:00 | MSFT | Stock | 240.0199 | 240.02 | 238.134 | 239.8 | 16497.0 |
| 2022-12-27 08:30:00 | MSFT | Stock | 239.6 | 239.69 | 238.51 | 238.79 | 18996.0 |
| 2022-12-27 09:00:00 | MSFT | Stock | 238.85 | 239.79 | 238.34 | 238.65 | 20811.0 |
| 2022-12-27 09:30:00 | MSFT | Stock | 238.7 | 238.93 | 235.83 | 236.83 | 1532303.0 |
| 2022-12-27 10:00:00 | MSFT | Stock | 236.8 | 238.53 | 235.86 | 237.8 | 1044523.0 |
| 2022-12-27 10:30:00 | MSFT | Stock | 237.8 | 238.44 | 237.2 | 237.51 | 838967.0 |
| 2022-12-27 11:00:00 | MSFT | Stock | 237.52 | 238.0582 | 237.2 | 237.86 | 762646.0 |
| 2022-12-27 11:30:00 | MSFT | Stock | 237.8379 | 238.17 | 237.35 | 237.54 | 702690.0 |
| 2022-12-27 12:00:00 | MSFT | Stock | 237.54 | 238.4287 | 237.53 | 237.68 | 531533.0 |
| 2022-12-27 12:30:00 | MSFT | Stock | 237.6502 | 237.9299 | 236.86 | 237.28 | 505019.0 |
> showing 50 of 103,549 rows — these rows as CSV