PREVIEW / stock_30min / 2022-01-04
file: by_date/stock_30min/2022/2022-01-04.parquet size: 2.2 MB rows: 109,702 symbols: 2,566
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-01-04 04:00:00 | AAPL | Stock | 182.22 | 182.67 | 182.1 | 182.57 | 21177.0 |
| 2022-01-04 04:30:00 | AAPL | Stock | 182.59 | 182.95 | 182.51 | 182.87 | 11991.0 |
| 2022-01-04 05:00:00 | AAPL | Stock | 182.89 | 183.37 | 182.82 | 183.3 | 31685.0 |
| 2022-01-04 05:30:00 | AAPL | Stock | 183.25 | 183.38 | 183.18 | 183.28 | 13997.0 |
| 2022-01-04 06:00:00 | AAPL | Stock | 183.24 | 183.37 | 183.02 | 183.02 | 19606.0 |
| 2022-01-04 06:30:00 | AAPL | Stock | 183.16 | 183.22 | 183.07 | 183.08 | 9339.0 |
| 2022-01-04 07:00:00 | AAPL | Stock | 183.05 | 183.14 | 182.32 | 182.44 | 95571.0 |
| 2022-01-04 07:30:00 | AAPL | Stock | 182.45 | 182.75 | 182.44 | 182.75 | 68387.0 |
| 2022-01-04 08:00:00 | AAPL | Stock | 183.0499 | 183.13 | 182.3304 | 182.81 | 344769.0 |
| 2022-01-04 08:30:00 | AAPL | Stock | 182.85 | 182.89 | 182.5 | 182.77 | 126564.0 |
| 2022-01-04 09:00:00 | AAPL | Stock | 182.74 | 182.84 | 182.55 | 182.63 | 129765.0 |
| 2022-01-04 09:30:00 | AAPL | Stock | 182.63 | 182.94 | 181.49 | 182.27 | 11553905.0 |
| 2022-01-04 10:00:00 | AAPL | Stock | 182.27 | 182.42 | 181.5 | 182.4 | 7752895.0 |
| 2022-01-04 10:30:00 | AAPL | Stock | 182.385 | 182.6799 | 180.97 | 181.01 | 7044306.0 |
| 2022-01-04 11:00:00 | AAPL | Stock | 181.02 | 181.05 | 179.47 | 179.94 | 8913769.0 |
| 2022-01-04 11:30:00 | AAPL | Stock | 179.94 | 180.21 | 179.62 | 179.815 | 4607354.0 |
| 2022-01-04 12:00:00 | AAPL | Stock | 179.815 | 180.37 | 179.2 | 180.03 | 4801407.0 |
| 2022-01-04 12:30:00 | AAPL | Stock | 180.02 | 180.05 | 179.25 | 179.325 | 2906772.0 |
| 2022-01-04 13:00:00 | AAPL | Stock | 179.3276 | 179.98 | 179.22 | 179.5 | 2617066.0 |
| 2022-01-04 13:30:00 | AAPL | Stock | 179.5 | 179.7393 | 179.12 | 179.4516 | 2762759.0 |
| 2022-01-04 14:00:00 | AAPL | Stock | 179.4588 | 179.75 | 179.31 | 179.497 | 2767469.0 |
| 2022-01-04 14:30:00 | AAPL | Stock | 179.49 | 180.18 | 179.48 | 180.0 | 3261467.0 |
| 2022-01-04 15:00:00 | AAPL | Stock | 180.0 | 180.5 | 179.975 | 180.11 | 3979732.0 |
| 2022-01-04 15:30:00 | AAPL | Stock | 180.11 | 180.48 | 179.62 | 179.69 | 6115563.0 |
| 2022-01-04 16:00:00 | AAPL | Stock | 179.7 | 179.75 | 179.4 | 179.48 | 7152122.0 |
| 2022-01-04 16:30:00 | AAPL | Stock | 179.48 | 179.7 | 179.4 | 179.47 | 39226.0 |
| 2022-01-04 17:00:00 | AAPL | Stock | 179.48 | 179.54 | 179.45 | 179.5 | 19190.0 |
| 2022-01-04 17:30:00 | AAPL | Stock | 179.51 | 179.51 | 179.47 | 179.47 | 11616.0 |
| 2022-01-04 18:00:00 | AAPL | Stock | 179.5 | 179.55 | 179.38 | 179.39 | 22083.0 |
| 2022-01-04 18:30:00 | AAPL | Stock | 179.43 | 179.43 | 179.34 | 179.35 | 7649.0 |
| 2022-01-04 19:00:00 | AAPL | Stock | 179.35 | 179.39 | 179.3 | 179.33 | 25552.0 |
| 2022-01-04 19:30:00 | AAPL | Stock | 179.33 | 179.38 | 179.25 | 179.33 | 25739.0 |
| 2022-01-04 04:00:00 | MSFT | Stock | 334.85 | 335.4 | 334.85 | 334.95 | 2526.0 |
| 2022-01-04 04:30:00 | MSFT | Stock | 334.98 | 335.31 | 334.98 | 335.25 | 1295.0 |
| 2022-01-04 05:00:00 | MSFT | Stock | 335.25 | 335.55 | 335.25 | 335.55 | 2772.0 |
| 2022-01-04 05:30:00 | MSFT | Stock | 335.8 | 335.9 | 335.7 | 335.75 | 1511.0 |
| 2022-01-04 06:00:00 | MSFT | Stock | 335.9 | 336.4 | 335.75 | 335.75 | 3694.0 |
| 2022-01-04 06:30:00 | MSFT | Stock | 335.92 | 335.92 | 335.41 | 335.41 | 3501.0 |
| 2022-01-04 07:00:00 | MSFT | Stock | 335.68 | 335.7 | 334.5 | 334.5 | 11075.0 |
| 2022-01-04 07:30:00 | MSFT | Stock | 334.53 | 335.1 | 334.5 | 335.0 | 3837.0 |
| 2022-01-04 08:00:00 | MSFT | Stock | 335.27 | 335.69 | 334.41 | 335.51 | 20727.0 |
| 2022-01-04 08:30:00 | MSFT | Stock | 335.5 | 335.53 | 334.82 | 335.49 | 15621.0 |
| 2022-01-04 09:00:00 | MSFT | Stock | 335.27 | 335.32 | 334.2 | 334.42 | 16955.0 |
| 2022-01-04 09:30:00 | MSFT | Stock | 334.83 | 335.2 | 332.44 | 334.0 | 2365188.0 |
| 2022-01-04 10:00:00 | MSFT | Stock | 333.99 | 334.155 | 332.74 | 333.98 | 1361142.0 |
| 2022-01-04 10:30:00 | MSFT | Stock | 333.97 | 334.37 | 329.35 | 329.98 | 1820946.0 |
| 2022-01-04 11:00:00 | MSFT | Stock | 330.03 | 330.08 | 327.56 | 328.39 | 2106584.0 |
| 2022-01-04 11:30:00 | MSFT | Stock | 328.4 | 329.42 | 327.86 | 328.0 | 1549023.0 |
| 2022-01-04 12:00:00 | MSFT | Stock | 327.98 | 328.31 | 326.57 | 327.78 | 1177372.0 |
| 2022-01-04 12:30:00 | MSFT | Stock | 327.79 | 328.019 | 327.1264 | 327.33 | 835206.0 |
> showing 50 of 109,702 rows — these rows as CSV