PREVIEW / stock_30min / 2023-03-03
file: by_date/stock_30min/2023/2023-03-03.parquet size: 2.1 MB rows: 101,107 symbols: 1,801
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 |
|---|---|---|---|---|---|---|---|
| 2023-03-03 04:00:00 | AAPL | Stock | 145.92 | 147.1 | 145.92 | 146.79 | 32313.0 |
| 2023-03-03 04:30:00 | AAPL | Stock | 146.79 | 146.89 | 146.71 | 146.79 | 4493.0 |
| 2023-03-03 05:00:00 | AAPL | Stock | 146.92 | 147.2 | 146.92 | 147.01 | 10376.0 |
| 2023-03-03 05:30:00 | AAPL | Stock | 147.01 | 147.09 | 146.93 | 147.06 | 9356.0 |
| 2023-03-03 06:00:00 | AAPL | Stock | 147.1 | 147.55 | 147.02 | 147.55 | 23716.0 |
| 2023-03-03 06:30:00 | AAPL | Stock | 147.56 | 147.87 | 147.43 | 147.76 | 32447.0 |
| 2023-03-03 07:00:00 | AAPL | Stock | 147.73 | 147.85 | 147.33 | 147.52 | 61324.0 |
| 2023-03-03 07:30:00 | AAPL | Stock | 147.5 | 147.63 | 147.16 | 147.32 | 35251.0 |
| 2023-03-03 08:00:00 | AAPL | Stock | 147.66 | 147.8412 | 145.23 | 147.54 | 151345.0 |
| 2023-03-03 08:30:00 | AAPL | Stock | 147.51 | 148.12 | 147.39 | 148.0941 | 173932.0 |
| 2023-03-03 09:00:00 | AAPL | Stock | 148.12 | 148.39 | 147.58 | 148.09 | 284467.0 |
| 2023-03-03 09:30:00 | AAPL | Stock | 148.045 | 149.48 | 147.33 | 149.47 | 8763106.0 |
| 2023-03-03 10:00:00 | AAPL | Stock | 149.47 | 150.16 | 149.03 | 150.15 | 6170234.0 |
| 2023-03-03 10:30:00 | AAPL | Stock | 150.14 | 150.17 | 149.4439 | 149.6384 | 3800239.0 |
| 2023-03-03 11:00:00 | AAPL | Stock | 149.64 | 149.94 | 149.375 | 149.57 | 2622353.0 |
| 2023-03-03 11:30:00 | AAPL | Stock | 149.575 | 149.98 | 149.26 | 149.8367 | 2804982.0 |
| 2023-03-03 12:00:00 | AAPL | Stock | 149.84 | 150.03 | 149.71 | 149.9142 | 2189741.0 |
| 2023-03-03 12:30:00 | AAPL | Stock | 149.915 | 150.24 | 149.6001 | 150.2117 | 2343794.0 |
| 2023-03-03 13:00:00 | AAPL | Stock | 150.23 | 150.32 | 149.8846 | 150.1014 | 2373736.0 |
| 2023-03-03 13:30:00 | AAPL | Stock | 150.105 | 150.25 | 149.91 | 150.2287 | 2063510.0 |
| 2023-03-03 14:00:00 | AAPL | Stock | 150.22 | 150.81 | 150.1 | 150.76 | 2899012.0 |
| 2023-03-03 14:30:00 | AAPL | Stock | 150.76 | 150.89 | 150.6202 | 150.83 | 2232955.0 |
| 2023-03-03 15:00:00 | AAPL | Stock | 150.835 | 150.97 | 150.65 | 150.92 | 3111027.0 |
| 2023-03-03 15:30:00 | AAPL | Stock | 150.91 | 151.11 | 150.53 | 151.1 | 6573593.0 |
| 2023-03-03 16:00:00 | AAPL | Stock | 151.1 | 151.14 | 150.93 | 151.11 | 11887772.0 |
| 2023-03-03 16:30:00 | AAPL | Stock | 151.1 | 151.25 | 151.03 | 151.22 | 114633.0 |
| 2023-03-03 17:00:00 | AAPL | Stock | 151.2 | 151.23 | 151.0604 | 151.1 | 26200.0 |
| 2023-03-03 17:30:00 | AAPL | Stock | 151.1 | 151.13 | 151.07 | 151.1 | 12922.0 |
| 2023-03-03 18:00:00 | AAPL | Stock | 151.1 | 151.14 | 151.06 | 151.11 | 5955.0 |
| 2023-03-03 18:30:00 | AAPL | Stock | 151.14 | 151.15 | 151.08 | 151.1 | 13574.0 |
| 2023-03-03 19:00:00 | AAPL | Stock | 151.1 | 151.19 | 151.08 | 151.15 | 11152.0 |
| 2023-03-03 19:30:00 | AAPL | Stock | 151.18 | 151.42 | 151.16 | 151.42 | 23842.0 |
| 2023-03-03 04:00:00 | MSFT | Stock | 251.87 | 251.95 | 251.12 | 251.12 | 2274.0 |
| 2023-03-03 04:30:00 | MSFT | Stock | 251.33 | 251.7 | 251.22 | 251.44 | 2208.0 |
| 2023-03-03 05:00:00 | MSFT | Stock | 251.5 | 251.93 | 251.5 | 251.93 | 811.0 |
| 2023-03-03 05:30:00 | MSFT | Stock | 251.76 | 251.9 | 251.57 | 251.9 | 3850.0 |
| 2023-03-03 06:00:00 | MSFT | Stock | 252.01 | 252.32 | 252.01 | 252.2 | 1503.0 |
| 2023-03-03 06:30:00 | MSFT | Stock | 252.24 | 252.26 | 251.2 | 251.82 | 6162.0 |
| 2023-03-03 07:00:00 | MSFT | Stock | 251.95 | 252.0 | 251.33 | 251.42 | 10152.0 |
| 2023-03-03 07:30:00 | MSFT | Stock | 251.5 | 251.51 | 250.9 | 250.98 | 4582.0 |
| 2023-03-03 08:00:00 | MSFT | Stock | 251.94 | 252.1 | 250.483 | 251.1 | 21734.0 |
| 2023-03-03 08:30:00 | MSFT | Stock | 251.0 | 251.98 | 250.92 | 251.94 | 19824.0 |
| 2023-03-03 09:00:00 | MSFT | Stock | 251.94 | 252.49 | 251.81 | 252.16 | 60401.0 |
| 2023-03-03 09:30:00 | MSFT | Stock | 252.19 | 254.47 | 251.39 | 254.37 | 1923718.0 |
| 2023-03-03 10:00:00 | MSFT | Stock | 254.38 | 255.25 | 253.23 | 255.1 | 1562094.0 |
| 2023-03-03 10:30:00 | MSFT | Stock | 255.1 | 255.13 | 253.97 | 254.1 | 998902.0 |
| 2023-03-03 11:00:00 | MSFT | Stock | 254.1246 | 254.17 | 253.33 | 253.745 | 821039.0 |
| 2023-03-03 11:30:00 | MSFT | Stock | 253.76 | 254.03 | 253.25 | 253.87 | 986594.0 |
| 2023-03-03 12:00:00 | MSFT | Stock | 253.88 | 254.0 | 253.6 | 253.94 | 656322.0 |
| 2023-03-03 12:30:00 | MSFT | Stock | 253.94 | 254.97 | 253.69 | 254.94 | 624461.0 |
> showing 50 of 101,107 rows — these rows as CSV