PREVIEW / stock_30min / 2022-10-06
file: by_date/stock_30min/2022/2022-10-06.parquet size: 2.0 MB rows: 100,892 symbols: 2,164
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-10-06 04:00:00 | AAPL | Stock | 147.31 | 147.31 | 145.76 | 145.87 | 19922.0 |
| 2022-10-06 04:30:00 | AAPL | Stock | 145.98 | 146.05 | 145.62 | 145.88 | 9759.0 |
| 2022-10-06 05:00:00 | AAPL | Stock | 145.72 | 145.88 | 145.57 | 145.8 | 3565.0 |
| 2022-10-06 05:30:00 | AAPL | Stock | 145.74 | 145.74 | 145.11 | 145.15 | 11830.0 |
| 2022-10-06 06:00:00 | AAPL | Stock | 145.24 | 145.39 | 145.11 | 145.19 | 13451.0 |
| 2022-10-06 06:30:00 | AAPL | Stock | 145.31 | 145.4 | 145.25 | 145.3 | 7355.0 |
| 2022-10-06 07:00:00 | AAPL | Stock | 145.49 | 145.76 | 145.44 | 145.64 | 41161.0 |
| 2022-10-06 07:30:00 | AAPL | Stock | 145.69 | 145.98 | 145.69 | 145.9 | 14853.0 |
| 2022-10-06 08:00:00 | AAPL | Stock | 145.5995 | 147.0 | 145.43 | 145.95 | 116153.0 |
| 2022-10-06 08:30:00 | AAPL | Stock | 146.08 | 146.9471 | 146.08 | 146.36 | 124290.0 |
| 2022-10-06 09:00:00 | AAPL | Stock | 146.34 | 146.34 | 145.45 | 145.93 | 121642.0 |
| 2022-10-06 09:30:00 | AAPL | Stock | 145.89 | 147.54 | 145.81 | 146.73 | 8171585.0 |
| 2022-10-06 10:00:00 | AAPL | Stock | 146.74 | 146.75 | 145.61 | 145.7289 | 6073935.0 |
| 2022-10-06 10:30:00 | AAPL | Stock | 145.73 | 146.65 | 145.6 | 146.6299 | 4229206.0 |
| 2022-10-06 11:00:00 | AAPL | Stock | 146.62 | 146.69 | 145.72 | 146.53 | 4035806.0 |
| 2022-10-06 11:30:00 | AAPL | Stock | 146.53 | 146.94 | 145.8323 | 145.89 | 3899566.0 |
| 2022-10-06 12:00:00 | AAPL | Stock | 145.88 | 146.13 | 145.565 | 146.07 | 3026122.0 |
| 2022-10-06 12:30:00 | AAPL | Stock | 146.06 | 146.475 | 145.82 | 146.26 | 2442493.0 |
| 2022-10-06 13:00:00 | AAPL | Stock | 146.265 | 146.53 | 145.94 | 146.4801 | 2649352.0 |
| 2022-10-06 13:30:00 | AAPL | Stock | 146.49 | 146.54 | 145.99 | 146.425 | 2103216.0 |
| 2022-10-06 14:00:00 | AAPL | Stock | 146.4393 | 146.4393 | 145.72 | 145.884 | 2429947.0 |
| 2022-10-06 14:30:00 | AAPL | Stock | 145.88 | 146.16 | 145.27 | 145.69 | 2859133.0 |
| 2022-10-06 15:00:00 | AAPL | Stock | 145.68 | 145.995 | 145.25 | 145.99 | 3650957.0 |
| 2022-10-06 15:30:00 | AAPL | Stock | 145.985 | 146.045 | 145.22 | 145.49 | 6285215.0 |
| 2022-10-06 16:00:00 | AAPL | Stock | 145.495 | 145.495 | 144.7 | 144.9 | 4519313.0 |
| 2022-10-06 16:30:00 | AAPL | Stock | 144.88 | 145.43 | 144.67 | 144.79 | 86668.0 |
| 2022-10-06 17:00:00 | AAPL | Stock | 144.77 | 144.9 | 144.4 | 144.48 | 51449.0 |
| 2022-10-06 17:30:00 | AAPL | Stock | 144.42 | 144.78 | 144.4 | 144.67 | 35041.0 |
| 2022-10-06 18:00:00 | AAPL | Stock | 144.65 | 144.95 | 144.32 | 144.74 | 28573.0 |
| 2022-10-06 18:30:00 | AAPL | Stock | 144.75 | 144.76 | 144.69 | 144.69 | 11620.0 |
| 2022-10-06 19:00:00 | AAPL | Stock | 144.68 | 145.19 | 144.61 | 145.14 | 27217.0 |
| 2022-10-06 19:30:00 | AAPL | Stock | 145.15 | 145.15 | 144.75 | 144.78 | 39634.0 |
| 2022-10-06 04:00:00 | MSFT | Stock | 248.9 | 249.22 | 247.62 | 247.71 | 4837.0 |
| 2022-10-06 04:30:00 | MSFT | Stock | 247.75 | 247.93 | 247.15 | 247.33 | 2812.0 |
| 2022-10-06 05:00:00 | MSFT | Stock | 247.63 | 247.63 | 247.63 | 247.63 | 100.0 |
| 2022-10-06 05:30:00 | MSFT | Stock | 247.46 | 247.46 | 246.82 | 246.82 | 2762.0 |
| 2022-10-06 06:00:00 | MSFT | Stock | 246.85 | 246.98 | 246.64 | 246.7 | 3997.0 |
| 2022-10-06 06:30:00 | MSFT | Stock | 246.85 | 247.0 | 246.78 | 247.0 | 8569.0 |
| 2022-10-06 07:00:00 | MSFT | Stock | 247.2 | 247.62 | 247.19 | 247.35 | 2359.0 |
| 2022-10-06 07:30:00 | MSFT | Stock | 247.59 | 247.96 | 247.41 | 247.96 | 5037.0 |
| 2022-10-06 08:00:00 | MSFT | Stock | 247.3898 | 249.67 | 247.3 | 247.93 | 14363.0 |
| 2022-10-06 08:30:00 | MSFT | Stock | 247.93 | 249.57 | 247.88 | 249.2 | 37643.0 |
| 2022-10-06 09:00:00 | MSFT | Stock | 248.76 | 248.85 | 247.44 | 247.81 | 24162.0 |
| 2022-10-06 09:30:00 | MSFT | Stock | 247.97 | 250.34 | 247.93 | 248.4 | 1943728.0 |
| 2022-10-06 10:00:00 | MSFT | Stock | 248.39 | 248.43 | 246.08 | 246.8301 | 1446671.0 |
| 2022-10-06 10:30:00 | MSFT | Stock | 246.83 | 249.34 | 246.8 | 249.26 | 1254495.0 |
| 2022-10-06 11:00:00 | MSFT | Stock | 249.28 | 249.78 | 248.0 | 249.48 | 1057251.0 |
| 2022-10-06 11:30:00 | MSFT | Stock | 249.47 | 250.0 | 248.29 | 248.44 | 842214.0 |
| 2022-10-06 12:00:00 | MSFT | Stock | 248.44 | 248.5697 | 247.83 | 248.35 | 664254.0 |
| 2022-10-06 12:30:00 | MSFT | Stock | 248.34 | 248.94 | 247.9 | 248.34 | 546133.0 |
> showing 50 of 100,892 rows — these rows as CSV