PREVIEW / stock_30min / 2023-09-21
file: by_date/stock_30min/2023/2023-09-21.parquet size: 2.0 MB rows: 98,859 symbols: 1,396
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-09-21 04:00:00 | AAPL | Stock | 175.01 | 175.03 | 174.72 | 174.83 | 12512.0 |
| 2023-09-21 04:30:00 | AAPL | Stock | 174.76 | 174.78 | 174.55 | 174.61 | 12114.0 |
| 2023-09-21 05:00:00 | AAPL | Stock | 174.6 | 174.72 | 174.6 | 174.63 | 7937.0 |
| 2023-09-21 05:30:00 | AAPL | Stock | 174.64 | 174.68 | 174.5 | 174.53 | 8550.0 |
| 2023-09-21 06:00:00 | AAPL | Stock | 174.54 | 174.62 | 174.45 | 174.55 | 15481.0 |
| 2023-09-21 06:30:00 | AAPL | Stock | 174.59 | 174.6 | 174.34 | 174.48 | 16855.0 |
| 2023-09-21 07:00:00 | AAPL | Stock | 174.58 | 174.64 | 174.2 | 174.31 | 54323.0 |
| 2023-09-21 07:30:00 | AAPL | Stock | 174.31 | 174.66 | 174.2 | 174.5 | 49001.0 |
| 2023-09-21 08:00:00 | AAPL | Stock | 174.7 | 175.05 | 174.2001 | 174.55 | 115378.0 |
| 2023-09-21 08:30:00 | AAPL | Stock | 174.52 | 174.55 | 173.88 | 173.89 | 313681.0 |
| 2023-09-21 09:00:00 | AAPL | Stock | 173.9 | 174.55 | 173.7 | 174.51 | 220381.0 |
| 2023-09-21 09:30:00 | AAPL | Stock | 174.55 | 176.05 | 174.44 | 174.68 | 7715053.0 |
| 2023-09-21 10:00:00 | AAPL | Stock | 174.66 | 176.06 | 174.63 | 175.3952 | 5229880.0 |
| 2023-09-21 10:30:00 | AAPL | Stock | 175.3947 | 176.3 | 175.33 | 175.41 | 3657909.0 |
| 2023-09-21 11:00:00 | AAPL | Stock | 175.4 | 175.62 | 174.82 | 174.92 | 2377067.0 |
| 2023-09-21 11:30:00 | AAPL | Stock | 174.92 | 175.7 | 174.83 | 175.377 | 2615834.0 |
| 2023-09-21 12:00:00 | AAPL | Stock | 175.37 | 175.4212 | 175.0 | 175.115 | 1800810.0 |
| 2023-09-21 12:30:00 | AAPL | Stock | 175.11 | 175.37 | 174.86 | 174.885 | 2312333.0 |
| 2023-09-21 13:00:00 | AAPL | Stock | 174.88 | 175.495 | 174.87 | 175.31 | 2115167.0 |
| 2023-09-21 13:30:00 | AAPL | Stock | 175.3101 | 175.54 | 175.28 | 175.35 | 1828592.0 |
| 2023-09-21 14:00:00 | AAPL | Stock | 175.35 | 175.39 | 174.63 | 174.66 | 2223589.0 |
| 2023-09-21 14:30:00 | AAPL | Stock | 174.66 | 175.0 | 174.52 | 174.651 | 2292098.0 |
| 2023-09-21 15:00:00 | AAPL | Stock | 174.655 | 174.8099 | 174.22 | 174.27 | 2768507.0 |
| 2023-09-21 15:30:00 | AAPL | Stock | 174.265 | 174.545 | 173.86 | 173.93 | 5997087.0 |
| 2023-09-21 16:00:00 | AAPL | Stock | 173.92 | 174.07 | 173.79 | 173.94 | 7384658.0 |
| 2023-09-21 16:30:00 | AAPL | Stock | 173.94 | 173.95 | 173.86 | 173.88 | 143401.0 |
| 2023-09-21 17:00:00 | AAPL | Stock | 173.88 | 173.96 | 173.74 | 173.9 | 28227.0 |
| 2023-09-21 17:30:00 | AAPL | Stock | 173.9 | 173.94 | 173.81 | 173.89 | 16008.0 |
| 2023-09-21 18:00:00 | AAPL | Stock | 173.87 | 174.19 | 173.87 | 174.0531 | 32696.0 |
| 2023-09-21 18:30:00 | AAPL | Stock | 174.15 | 174.29 | 174.02 | 174.11 | 19549.0 |
| 2023-09-21 19:00:00 | AAPL | Stock | 174.12 | 174.2 | 174.03 | 174.17 | 11508.0 |
| 2023-09-21 19:30:00 | AAPL | Stock | 174.16 | 174.22 | 174.04 | 174.14 | 24274.0 |
| 2023-09-21 04:00:00 | MSFT | Stock | 319.9 | 320.3 | 319.55 | 319.55 | 1312.0 |
| 2023-09-21 04:30:00 | MSFT | Stock | 319.85 | 319.85 | 319.38 | 319.4 | 1519.0 |
| 2023-09-21 05:00:00 | MSFT | Stock | 319.6 | 319.6 | 319.42 | 319.55 | 1008.0 |
| 2023-09-21 05:30:00 | MSFT | Stock | 319.43 | 319.43 | 319.3 | 319.3 | 1004.0 |
| 2023-09-21 06:00:00 | MSFT | Stock | 319.49 | 319.5 | 319.1 | 319.19 | 1731.0 |
| 2023-09-21 06:30:00 | MSFT | Stock | 319.48 | 319.48 | 319.2 | 319.25 | 1021.0 |
| 2023-09-21 07:00:00 | MSFT | Stock | 319.41 | 319.6 | 318.5 | 318.93 | 14339.0 |
| 2023-09-21 07:30:00 | MSFT | Stock | 318.8 | 319.75 | 318.0 | 318.77 | 26120.0 |
| 2023-09-21 08:00:00 | MSFT | Stock | 319.66 | 319.68 | 318.5 | 318.88 | 25993.0 |
| 2023-09-21 08:30:00 | MSFT | Stock | 318.74 | 318.9 | 318.08 | 318.5495 | 39318.0 |
| 2023-09-21 09:00:00 | MSFT | Stock | 318.59 | 319.8 | 318.4 | 319.26 | 30944.0 |
| 2023-09-21 09:30:00 | MSFT | Stock | 319.23 | 320.31 | 317.27 | 317.43 | 2559240.0 |
| 2023-09-21 10:00:00 | MSFT | Stock | 317.43 | 324.15 | 315.0 | 320.7 | 4396156.0 |
| 2023-09-21 10:30:00 | MSFT | Stock | 320.6644 | 325.3499 | 320.28 | 323.24 | 3411247.0 |
| 2023-09-21 11:00:00 | MSFT | Stock | 323.25 | 324.15 | 321.705 | 322.02 | 1159979.0 |
| 2023-09-21 11:30:00 | MSFT | Stock | 322.04 | 322.8829 | 321.51 | 321.71 | 1006237.0 |
| 2023-09-21 12:00:00 | MSFT | Stock | 321.7 | 321.81 | 320.24 | 320.69 | 788704.0 |
| 2023-09-21 12:30:00 | MSFT | Stock | 320.69 | 321.67 | 320.39 | 321.275 | 615591.0 |
> showing 50 of 98,859 rows — these rows as CSV