PREVIEW / stock_30min / 2023-05-30
file: by_date/stock_30min/2023/2023-05-30.parquet size: 2.1 MB rows: 103,557 symbols: 1,661
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-05-30 04:00:00 | AAPL | Stock | 176.1 | 176.23 | 175.88 | 176.0 | 35722.0 |
| 2023-05-30 04:30:00 | AAPL | Stock | 175.99 | 176.09 | 175.9 | 175.96 | 10755.0 |
| 2023-05-30 05:00:00 | AAPL | Stock | 175.96 | 176.6 | 175.96 | 176.07 | 14380.0 |
| 2023-05-30 05:30:00 | AAPL | Stock | 176.2 | 176.58 | 176.17 | 176.46 | 13336.0 |
| 2023-05-30 06:00:00 | AAPL | Stock | 176.46 | 177.0 | 176.31 | 176.55 | 22850.0 |
| 2023-05-30 06:30:00 | AAPL | Stock | 176.52 | 176.78 | 176.48 | 176.73 | 29168.0 |
| 2023-05-30 07:00:00 | AAPL | Stock | 176.73 | 176.95 | 176.73 | 176.74 | 75620.0 |
| 2023-05-30 07:30:00 | AAPL | Stock | 176.77 | 177.5 | 176.77 | 177.39 | 74801.0 |
| 2023-05-30 08:00:00 | AAPL | Stock | 176.7311 | 178.18 | 175.81 | 177.74 | 442115.0 |
| 2023-05-30 08:30:00 | AAPL | Stock | 177.75 | 177.83 | 177.37 | 177.651 | 162072.0 |
| 2023-05-30 09:00:00 | AAPL | Stock | 177.66 | 177.9265 | 176.82 | 177.0 | 320973.0 |
| 2023-05-30 09:30:00 | AAPL | Stock | 176.99 | 178.99 | 176.57 | 177.7399 | 9609594.0 |
| 2023-05-30 10:00:00 | AAPL | Stock | 177.72 | 178.0982 | 177.3 | 177.6111 | 3568119.0 |
| 2023-05-30 10:30:00 | AAPL | Stock | 177.63 | 177.8199 | 176.975 | 177.44 | 2716673.0 |
| 2023-05-30 11:00:00 | AAPL | Stock | 177.435 | 177.79 | 176.7504 | 177.24 | 2424632.0 |
| 2023-05-30 11:30:00 | AAPL | Stock | 177.235 | 177.78 | 177.18 | 177.3215 | 1876536.0 |
| 2023-05-30 12:00:00 | AAPL | Stock | 177.33 | 177.55 | 177.09 | 177.2222 | 1610779.0 |
| 2023-05-30 12:30:00 | AAPL | Stock | 177.23 | 177.975 | 177.1401 | 177.83 | 1799750.0 |
| 2023-05-30 13:00:00 | AAPL | Stock | 177.85 | 177.86 | 177.14 | 177.15 | 1777855.0 |
| 2023-05-30 13:30:00 | AAPL | Stock | 177.15 | 177.4 | 176.82 | 176.97 | 1699915.0 |
| 2023-05-30 14:00:00 | AAPL | Stock | 176.965 | 177.66 | 176.59 | 177.5974 | 2051266.0 |
| 2023-05-30 14:30:00 | AAPL | Stock | 177.59 | 177.85 | 177.42 | 177.47 | 1799722.0 |
| 2023-05-30 15:00:00 | AAPL | Stock | 177.47 | 177.61 | 177.25 | 177.52 | 1806304.0 |
| 2023-05-30 15:30:00 | AAPL | Stock | 177.53 | 177.685 | 176.81 | 177.33 | 4883422.0 |
| 2023-05-30 16:00:00 | AAPL | Stock | 177.34 | 177.4 | 177.1 | 177.26 | 7335085.0 |
| 2023-05-30 16:30:00 | AAPL | Stock | 177.23 | 177.37 | 177.17 | 177.3 | 60151.0 |
| 2023-05-30 17:00:00 | AAPL | Stock | 177.29 | 177.32 | 177.24 | 177.25 | 11045.0 |
| 2023-05-30 17:30:00 | AAPL | Stock | 177.22 | 177.3 | 177.13 | 177.13 | 20107.0 |
| 2023-05-30 18:00:00 | AAPL | Stock | 177.17 | 177.29 | 177.17 | 177.29 | 2450.0 |
| 2023-05-30 18:30:00 | AAPL | Stock | 177.21 | 177.39 | 177.2 | 177.35 | 9854.0 |
| 2023-05-30 19:00:00 | AAPL | Stock | 177.37 | 177.66 | 177.36 | 177.66 | 29026.0 |
| 2023-05-30 19:30:00 | AAPL | Stock | 177.65 | 177.7 | 177.6 | 177.66 | 22996.0 |
| 2023-05-30 04:00:00 | MSFT | Stock | 335.65 | 336.94 | 334.95 | 336.55 | 21041.0 |
| 2023-05-30 04:30:00 | MSFT | Stock | 336.25 | 337.19 | 336.25 | 336.76 | 8827.0 |
| 2023-05-30 05:00:00 | MSFT | Stock | 336.16 | 336.66 | 336.0 | 336.02 | 6060.0 |
| 2023-05-30 05:30:00 | MSFT | Stock | 336.02 | 336.55 | 336.02 | 336.4 | 17711.0 |
| 2023-05-30 06:00:00 | MSFT | Stock | 336.5 | 336.5 | 336.02 | 336.5 | 4993.0 |
| 2023-05-30 06:30:00 | MSFT | Stock | 336.1 | 336.8 | 336.0 | 336.53 | 13984.0 |
| 2023-05-30 07:00:00 | MSFT | Stock | 336.54 | 337.27 | 336.53 | 336.82 | 42800.0 |
| 2023-05-30 07:30:00 | MSFT | Stock | 337.0 | 337.62 | 336.92 | 337.37 | 30240.0 |
| 2023-05-30 08:00:00 | MSFT | Stock | 336.62 | 338.11 | 334.68 | 336.85 | 93578.0 |
| 2023-05-30 08:30:00 | MSFT | Stock | 336.8 | 336.8 | 335.98 | 336.7 | 54996.0 |
| 2023-05-30 09:00:00 | MSFT | Stock | 336.7 | 336.8 | 334.8 | 335.21 | 71598.0 |
| 2023-05-30 09:30:00 | MSFT | Stock | 335.23 | 335.74 | 330.58 | 331.85 | 4711565.0 |
| 2023-05-30 10:00:00 | MSFT | Stock | 331.8 | 332.1313 | 330.59 | 331.8409 | 1766168.0 |
| 2023-05-30 10:30:00 | MSFT | Stock | 331.85 | 334.21 | 331.6083 | 333.03 | 1304431.0 |
| 2023-05-30 11:00:00 | MSFT | Stock | 333.04 | 333.43 | 331.65 | 332.92 | 991621.0 |
| 2023-05-30 11:30:00 | MSFT | Stock | 332.915 | 333.49 | 332.4 | 332.455 | 679956.0 |
| 2023-05-30 12:00:00 | MSFT | Stock | 332.5063 | 332.5063 | 331.3101 | 331.8 | 1203109.0 |
| 2023-05-30 12:30:00 | MSFT | Stock | 331.795 | 332.45 | 331.47 | 332.1859 | 873642.0 |
> showing 50 of 103,557 rows — these rows as CSV