PREVIEW / stock_30min / 2008-09-11
file: by_date/stock_30min/2008/2008-09-11.parquet size: 1.3 MB rows: 70,329 symbols: 3,332
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-11 05:30:00 | AAPL | Stock | 5.3679 | 5.3679 | 5.3679 | 5.3679 | 2800.0 |
| 2008-09-11 07:30:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3321 | 5.3321 | 19600.0 |
| 2008-09-11 08:00:00 | AAPL | Stock | 5.3261 | 5.3464 | 5.295 | 5.3 | 1273132.0 |
| 2008-09-11 08:30:00 | AAPL | Stock | 5.2982 | 5.3071 | 5.2804 | 5.2929 | 2159584.0 |
| 2008-09-11 09:00:00 | AAPL | Stock | 5.2886 | 5.3011 | 5.2593 | 5.2932 | 5144748.0 |
| 2008-09-11 09:30:00 | AAPL | Stock | 5.2921 | 5.3107 | 5.2143 | 5.2361 | 150306772.0 |
| 2008-09-11 10:00:00 | AAPL | Stock | 5.2395 | 5.3214 | 5.2182 | 5.2825 | 119121800.0 |
| 2008-09-11 10:30:00 | AAPL | Stock | 5.2821 | 5.3279 | 5.2679 | 5.3182 | 68179804.0 |
| 2008-09-11 11:00:00 | AAPL | Stock | 5.3182 | 5.3368 | 5.2846 | 5.2982 | 52677940.0 |
| 2008-09-11 11:30:00 | AAPL | Stock | 5.2993 | 5.3911 | 5.2857 | 5.3907 | 69238456.0 |
| 2008-09-11 12:00:00 | AAPL | Stock | 5.3896 | 5.4179 | 5.3501 | 5.3639 | 61145560.0 |
| 2008-09-11 12:30:00 | AAPL | Stock | 5.3629 | 5.3639 | 5.3225 | 5.3532 | 54492592.0 |
| 2008-09-11 13:00:00 | AAPL | Stock | 5.3532 | 5.3543 | 5.2954 | 5.3096 | 41547996.0 |
| 2008-09-11 13:30:00 | AAPL | Stock | 5.3104 | 5.3471 | 5.2971 | 5.33 | 50664488.0 |
| 2008-09-11 14:00:00 | AAPL | Stock | 5.3293 | 5.3689 | 5.3227 | 5.355 | 55128948.0 |
| 2008-09-11 14:30:00 | AAPL | Stock | 5.355 | 5.3679 | 5.3254 | 5.3279 | 47453868.0 |
| 2008-09-11 15:00:00 | AAPL | Stock | 5.3279 | 5.3893 | 5.3275 | 5.3329 | 76085100.0 |
| 2008-09-11 15:30:00 | AAPL | Stock | 5.3332 | 5.4639 | 5.3211 | 5.4521 | 95187092.0 |
| 2008-09-11 16:00:00 | AAPL | Stock | 5.4543 | 5.4718 | 5.3228 | 5.4679 | 10964044.0 |
| 2008-09-11 16:30:00 | AAPL | Stock | 5.4671 | 5.4761 | 5.4521 | 5.4721 | 738836.0 |
| 2008-09-11 17:00:00 | AAPL | Stock | 5.4721 | 5.4793 | 5.4464 | 5.4564 | 1775396.0 |
| 2008-09-11 17:30:00 | AAPL | Stock | 5.4536 | 5.4571 | 5.4464 | 5.4464 | 116200.0 |
| 2008-09-11 18:00:00 | AAPL | Stock | 5.4464 | 5.4607 | 5.4464 | 5.4589 | 159264.0 |
| 2008-09-11 18:30:00 | AAPL | Stock | 5.4621 | 5.4625 | 5.4557 | 5.4557 | 33460.0 |
| 2008-09-11 19:00:00 | AAPL | Stock | 5.4607 | 5.4625 | 5.4607 | 5.4625 | 107968.0 |
| 2008-09-11 19:30:00 | AAPL | Stock | 5.4625 | 5.4786 | 5.4625 | 5.4775 | 321832.0 |
| 2008-09-11 08:00:00 | MSFT | Stock | 26.25 | 26.4 | 26.08 | 26.08 | 7300.0 |
| 2008-09-11 08:30:00 | MSFT | Stock | 26.02 | 26.02 | 26.0 | 26.01 | 1569.0 |
| 2008-09-11 09:00:00 | MSFT | Stock | 26.05 | 26.1 | 26.0 | 26.08 | 19884.0 |
| 2008-09-11 09:30:00 | MSFT | Stock | 26.09 | 26.6 | 26.03 | 26.57 | 6259063.0 |
| 2008-09-11 10:00:00 | MSFT | Stock | 26.57 | 26.86 | 26.57 | 26.74 | 6537007.0 |
| 2008-09-11 10:30:00 | MSFT | Stock | 26.742 | 26.86 | 26.62 | 26.8 | 5426251.0 |
| 2008-09-11 11:00:00 | MSFT | Stock | 26.8 | 26.85 | 26.67 | 26.73 | 3216503.0 |
| 2008-09-11 11:30:00 | MSFT | Stock | 26.73 | 26.82 | 26.72 | 26.8 | 2717741.0 |
| 2008-09-11 12:00:00 | MSFT | Stock | 26.8 | 26.92 | 26.8 | 26.88 | 5075595.0 |
| 2008-09-11 12:30:00 | MSFT | Stock | 26.88 | 26.99 | 26.81 | 26.93 | 3587810.0 |
| 2008-09-11 13:00:00 | MSFT | Stock | 26.93 | 26.96 | 26.85 | 26.91 | 4297934.0 |
| 2008-09-11 13:30:00 | MSFT | Stock | 26.92 | 27.03 | 26.905 | 27.002 | 3887089.0 |
| 2008-09-11 14:00:00 | MSFT | Stock | 27.01 | 27.13 | 27.0 | 27.05 | 4032847.0 |
| 2008-09-11 14:30:00 | MSFT | Stock | 27.04 | 27.17 | 27.02 | 27.06 | 4624853.0 |
| 2008-09-11 15:00:00 | MSFT | Stock | 27.05 | 27.24 | 27.05 | 27.12 | 6250931.0 |
| 2008-09-11 15:30:00 | MSFT | Stock | 27.12 | 27.46 | 27.07 | 27.33 | 12168709.0 |
| 2008-09-11 16:00:00 | MSFT | Stock | 27.38 | 27.42 | 26.914 | 27.228 | 2461899.0 |
| 2008-09-11 16:30:00 | MSFT | Stock | 27.32 | 27.32 | 26.863 | 27.28 | 796903.0 |
| 2008-09-11 17:00:00 | MSFT | Stock | 27.32 | 27.32 | 27.24 | 27.28 | 223400.0 |
| 2008-09-11 17:30:00 | MSFT | Stock | 27.28 | 27.32 | 27.28 | 27.32 | 12200.0 |
| 2008-09-11 18:00:00 | MSFT | Stock | 27.26 | 27.26 | 27.26 | 27.26 | 500.0 |
| 2008-09-11 19:30:00 | MSFT | Stock | 27.3 | 27.3 | 27.3 | 27.3 | 1400.0 |
| 2008-09-11 05:30:00 | NVDA | Stock | 0.27 | 0.27 | 0.27 | 0.27 | 4000.0 |
| 2008-09-11 06:30:00 | NVDA | Stock | 0.265 | 0.265 | 0.265 | 0.265 | 4000.0 |
> showing 50 of 70,329 rows — these rows as CSV