PREVIEW / stock_30min / 2023-10-06
file: by_date/stock_30min/2023/2023-10-06.parquet size: 2.0 MB rows: 95,624 symbols: 1,381
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-10-06 04:00:00 | AAPL | Stock | 175.08 | 175.22 | 174.9 | 174.9 | 9443.0 |
| 2023-10-06 04:30:00 | AAPL | Stock | 174.92 | 174.98 | 174.87 | 174.88 | 1855.0 |
| 2023-10-06 05:00:00 | AAPL | Stock | 174.82 | 175.06 | 174.82 | 175.06 | 1282.0 |
| 2023-10-06 05:30:00 | AAPL | Stock | 175.08 | 175.1 | 175.02 | 175.08 | 5380.0 |
| 2023-10-06 06:00:00 | AAPL | Stock | 175.08 | 175.5 | 175.08 | 175.47 | 9080.0 |
| 2023-10-06 06:30:00 | AAPL | Stock | 175.4 | 175.49 | 175.35 | 175.35 | 2682.0 |
| 2023-10-06 07:00:00 | AAPL | Stock | 175.36 | 175.56 | 175.31 | 175.4 | 16468.0 |
| 2023-10-06 07:30:00 | AAPL | Stock | 175.25 | 175.3 | 175.1 | 175.15 | 16002.0 |
| 2023-10-06 08:00:00 | AAPL | Stock | 175.4105 | 175.59 | 174.52 | 175.35 | 57629.0 |
| 2023-10-06 08:30:00 | AAPL | Stock | 175.27 | 175.54 | 172.75 | 173.29 | 413090.0 |
| 2023-10-06 09:00:00 | AAPL | Stock | 173.29 | 174.11 | 173.04 | 173.89 | 133080.0 |
| 2023-10-06 09:30:00 | AAPL | Stock | 173.9 | 175.06 | 173.18 | 174.03 | 5104546.0 |
| 2023-10-06 10:00:00 | AAPL | Stock | 174.04 | 174.89 | 173.35 | 174.81 | 3489006.0 |
| 2023-10-06 10:30:00 | AAPL | Stock | 174.8 | 175.28 | 174.73 | 175.13 | 3536849.0 |
| 2023-10-06 11:00:00 | AAPL | Stock | 175.1324 | 175.725 | 175.09 | 175.45 | 3378006.0 |
| 2023-10-06 11:30:00 | AAPL | Stock | 175.45 | 176.84 | 175.43 | 176.7987 | 3227535.0 |
| 2023-10-06 12:00:00 | AAPL | Stock | 176.795 | 177.05 | 176.31 | 176.6701 | 3025758.0 |
| 2023-10-06 12:30:00 | AAPL | Stock | 176.68 | 176.99 | 176.45 | 176.82 | 1847046.0 |
| 2023-10-06 13:00:00 | AAPL | Stock | 176.83 | 177.36 | 176.69 | 177.16 | 2638734.0 |
| 2023-10-06 13:30:00 | AAPL | Stock | 177.17 | 177.39 | 177.1 | 177.2799 | 1678258.0 |
| 2023-10-06 14:00:00 | AAPL | Stock | 177.275 | 177.54 | 177.13 | 177.5291 | 1824109.0 |
| 2023-10-06 14:30:00 | AAPL | Stock | 177.53 | 177.7059 | 177.42 | 177.54 | 1790940.0 |
| 2023-10-06 15:00:00 | AAPL | Stock | 177.535 | 177.955 | 177.45 | 177.94 | 2354056.0 |
| 2023-10-06 15:30:00 | AAPL | Stock | 177.935 | 177.99 | 177.4 | 177.49 | 6370872.0 |
| 2023-10-06 16:00:00 | AAPL | Stock | 177.47 | 177.7 | 177.45 | 177.6 | 8283343.0 |
| 2023-10-06 16:30:00 | AAPL | Stock | 177.57 | 177.57 | 177.49 | 177.57 | 93470.0 |
| 2023-10-06 17:00:00 | AAPL | Stock | 177.53 | 177.56 | 177.5 | 177.53 | 13061.0 |
| 2023-10-06 17:30:00 | AAPL | Stock | 177.54 | 177.5588 | 177.53 | 177.53 | 4249.0 |
| 2023-10-06 18:00:00 | AAPL | Stock | 177.54 | 177.59 | 177.54 | 177.56 | 10266.0 |
| 2023-10-06 18:30:00 | AAPL | Stock | 177.56 | 177.56 | 177.51 | 177.53 | 4073.0 |
| 2023-10-06 19:00:00 | AAPL | Stock | 177.52 | 177.55 | 177.51 | 177.55 | 3296.0 |
| 2023-10-06 19:30:00 | AAPL | Stock | 177.58 | 177.77 | 177.58 | 177.72 | 18315.0 |
| 2023-10-06 04:00:00 | MSFT | Stock | 320.15 | 320.27 | 319.99 | 319.99 | 858.0 |
| 2023-10-06 05:30:00 | MSFT | Stock | 319.95 | 319.95 | 319.74 | 319.74 | 300.0 |
| 2023-10-06 06:00:00 | MSFT | Stock | 319.97 | 320.96 | 319.97 | 320.96 | 1682.0 |
| 2023-10-06 06:30:00 | MSFT | Stock | 321.39 | 321.52 | 321.39 | 321.39 | 301.0 |
| 2023-10-06 07:00:00 | MSFT | Stock | 321.25 | 321.31 | 320.53 | 320.53 | 5392.0 |
| 2023-10-06 07:30:00 | MSFT | Stock | 320.37 | 320.5 | 319.99 | 320.2 | 2338.0 |
| 2023-10-06 08:00:00 | MSFT | Stock | 321.2464 | 321.45 | 318.85 | 320.5 | 15055.0 |
| 2023-10-06 08:30:00 | MSFT | Stock | 320.0 | 320.5 | 314.14 | 315.35 | 98448.0 |
| 2023-10-06 09:00:00 | MSFT | Stock | 315.2 | 317.3834 | 315.0 | 316.46 | 57070.0 |
| 2023-10-06 09:30:00 | MSFT | Stock | 316.55 | 320.17 | 316.3 | 319.17 | 1697739.0 |
| 2023-10-06 10:00:00 | MSFT | Stock | 319.12 | 321.33 | 317.8 | 321.1 | 1109418.0 |
| 2023-10-06 10:30:00 | MSFT | Stock | 321.13 | 322.5 | 321.1 | 322.05 | 1224133.0 |
| 2023-10-06 11:00:00 | MSFT | Stock | 322.1 | 324.115 | 321.965 | 323.27 | 1580092.0 |
| 2023-10-06 11:30:00 | MSFT | Stock | 323.33 | 325.5 | 323.305 | 325.31 | 1023445.0 |
| 2023-10-06 12:00:00 | MSFT | Stock | 325.3 | 325.76 | 324.17 | 324.97 | 784119.0 |
| 2023-10-06 12:30:00 | MSFT | Stock | 324.97 | 325.61 | 324.5901 | 325.32 | 474329.0 |
| 2023-10-06 13:00:00 | MSFT | Stock | 325.37 | 326.66 | 325.22 | 326.47 | 689771.0 |
| 2023-10-06 13:30:00 | MSFT | Stock | 326.47 | 327.09 | 326.3285 | 326.94 | 578108.0 |
> showing 50 of 95,624 rows — these rows as CSV