PREVIEW / stock_30min / 2021-12-08
file: by_date/stock_30min/2021/2021-12-08.parquet size: 2.2 MB rows: 111,050 symbols: 2,670
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-08 04:00:00 | AAPL | Stock | 172.86 | 173.48 | 172.48 | 172.9 | 67856.0 |
| 2021-12-08 04:30:00 | AAPL | Stock | 172.87 | 172.95 | 172.38 | 172.78 | 29062.0 |
| 2021-12-08 05:00:00 | AAPL | Stock | 172.81 | 172.87 | 172.66 | 172.8 | 6537.0 |
| 2021-12-08 05:30:00 | AAPL | Stock | 172.74 | 172.74 | 171.9 | 172.24 | 38978.0 |
| 2021-12-08 06:00:00 | AAPL | Stock | 172.18 | 172.6 | 172.15 | 172.5 | 34095.0 |
| 2021-12-08 06:30:00 | AAPL | Stock | 172.48 | 173.1 | 172.23 | 172.4 | 68543.0 |
| 2021-12-08 07:00:00 | AAPL | Stock | 172.48 | 172.6 | 172.0 | 172.35 | 152688.0 |
| 2021-12-08 07:30:00 | AAPL | Stock | 172.37 | 172.74 | 172.13 | 172.29 | 116856.0 |
| 2021-12-08 08:00:00 | AAPL | Stock | 172.5499 | 172.7398 | 171.67 | 171.96 | 310872.0 |
| 2021-12-08 08:30:00 | AAPL | Stock | 171.9501 | 172.17 | 171.55 | 172.091 | 199451.0 |
| 2021-12-08 09:00:00 | AAPL | Stock | 172.09 | 172.27 | 171.2471 | 172.09 | 254982.0 |
| 2021-12-08 09:30:00 | AAPL | Stock | 172.08 | 173.46 | 170.7 | 172.7201 | 16146853.0 |
| 2021-12-08 10:00:00 | AAPL | Stock | 172.68 | 174.44 | 172.57 | 173.81 | 12341085.0 |
| 2021-12-08 10:30:00 | AAPL | Stock | 173.82 | 174.4465 | 173.755 | 173.92 | 7483209.0 |
| 2021-12-08 11:00:00 | AAPL | Stock | 173.92 | 174.74 | 173.27 | 174.37 | 7623323.0 |
| 2021-12-08 11:30:00 | AAPL | Stock | 174.37 | 174.87 | 174.14 | 174.8301 | 6132193.0 |
| 2021-12-08 12:00:00 | AAPL | Stock | 174.83 | 174.83 | 173.75 | 173.94 | 4442339.0 |
| 2021-12-08 12:30:00 | AAPL | Stock | 173.94 | 174.61 | 173.9333 | 174.27 | 3795797.0 |
| 2021-12-08 13:00:00 | AAPL | Stock | 174.28 | 174.4 | 174.035 | 174.27 | 2236716.0 |
| 2021-12-08 13:30:00 | AAPL | Stock | 174.265 | 174.82 | 174.235 | 174.54 | 3605304.0 |
| 2021-12-08 14:00:00 | AAPL | Stock | 174.54 | 175.96 | 174.0726 | 175.71 | 7278099.0 |
| 2021-12-08 14:30:00 | AAPL | Stock | 175.7008 | 175.92 | 174.43 | 174.7754 | 5882957.0 |
| 2021-12-08 15:00:00 | AAPL | Stock | 174.7729 | 174.875 | 174.05 | 174.35 | 4675584.0 |
| 2021-12-08 15:30:00 | AAPL | Stock | 174.35 | 175.28 | 174.05 | 175.01 | 9119395.0 |
| 2021-12-08 16:00:00 | AAPL | Stock | 175.13 | 175.35 | 174.96 | 175.26 | 8827085.0 |
| 2021-12-08 16:30:00 | AAPL | Stock | 175.29 | 175.35 | 175.08 | 175.2 | 69205.0 |
| 2021-12-08 17:00:00 | AAPL | Stock | 175.15 | 175.25 | 175.02 | 175.02 | 24224.0 |
| 2021-12-08 17:30:00 | AAPL | Stock | 175.05 | 175.15 | 174.62 | 174.87 | 42435.0 |
| 2021-12-08 18:00:00 | AAPL | Stock | 174.87 | 174.92 | 174.48 | 174.9 | 90066.0 |
| 2021-12-08 18:30:00 | AAPL | Stock | 174.86 | 174.88 | 174.7 | 174.72 | 13454.0 |
| 2021-12-08 19:00:00 | AAPL | Stock | 174.71 | 174.79 | 174.66 | 174.73 | 22849.0 |
| 2021-12-08 19:30:00 | AAPL | Stock | 174.71 | 174.79 | 174.6 | 174.75 | 51529.0 |
| 2021-12-08 04:00:00 | MSFT | Stock | 336.5 | 336.74 | 335.61 | 336.74 | 5910.0 |
| 2021-12-08 04:30:00 | MSFT | Stock | 336.24 | 336.59 | 336.07 | 336.5 | 6808.0 |
| 2021-12-08 05:00:00 | MSFT | Stock | 336.5 | 336.67 | 336.5 | 336.5 | 1558.0 |
| 2021-12-08 05:30:00 | MSFT | Stock | 336.49 | 336.69 | 336.2 | 336.3 | 2780.0 |
| 2021-12-08 06:00:00 | MSFT | Stock | 336.29 | 337.2 | 336.29 | 337.07 | 4582.0 |
| 2021-12-08 06:30:00 | MSFT | Stock | 337.11 | 338.5 | 336.52 | 336.96 | 8660.0 |
| 2021-12-08 07:00:00 | MSFT | Stock | 336.98 | 337.49 | 335.23 | 336.25 | 28499.0 |
| 2021-12-08 07:30:00 | MSFT | Stock | 336.2 | 336.25 | 335.75 | 335.9 | 9413.0 |
| 2021-12-08 08:00:00 | MSFT | Stock | 336.5899 | 337.3001 | 334.99 | 335.0 | 20545.0 |
| 2021-12-08 08:30:00 | MSFT | Stock | 335.05 | 335.05 | 334.11 | 334.48 | 15199.0 |
| 2021-12-08 09:00:00 | MSFT | Stock | 334.25 | 335.43 | 334.25 | 335.42 | 25540.0 |
| 2021-12-08 09:30:00 | MSFT | Stock | 335.42 | 335.5 | 332.272 | 332.8237 | 2011021.0 |
| 2021-12-08 10:00:00 | MSFT | Stock | 332.76 | 333.53 | 331.71 | 332.4 | 1180655.0 |
| 2021-12-08 10:30:00 | MSFT | Stock | 332.41 | 332.85 | 331.46 | 331.69 | 889040.0 |
| 2021-12-08 11:00:00 | MSFT | Stock | 331.71 | 332.24 | 330.8 | 332.12 | 946660.0 |
| 2021-12-08 11:30:00 | MSFT | Stock | 332.12 | 332.29 | 331.251 | 331.6599 | 647087.0 |
| 2021-12-08 12:00:00 | MSFT | Stock | 331.62 | 331.73 | 330.98 | 331.13 | 599837.0 |
| 2021-12-08 12:30:00 | MSFT | Stock | 331.12 | 331.88 | 330.99 | 331.5642 | 583615.0 |
> showing 50 of 111,050 rows — these rows as CSV