PREVIEW / stock_30min / 2008-12-03
file: by_date/stock_30min/2008/2008-12-03.parquet size: 1.2 MB rows: 68,541 symbols: 3,345
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-12-03 06:30:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2143 | 3.2143 | 36400.0 |
| 2008-12-03 07:00:00 | AAPL | Stock | 3.1839 | 3.2143 | 3.1743 | 3.2143 | 316904.0 |
| 2008-12-03 07:30:00 | AAPL | Stock | 3.2071 | 3.2161 | 3.1964 | 3.2146 | 192752.0 |
| 2008-12-03 08:00:00 | AAPL | Stock | 3.2229 | 3.2407 | 3.2054 | 3.2139 | 1492932.0 |
| 2008-12-03 08:30:00 | AAPL | Stock | 3.2143 | 3.2196 | 3.2071 | 3.2082 | 835240.0 |
| 2008-12-03 09:00:00 | AAPL | Stock | 3.2082 | 3.2143 | 3.1911 | 3.1929 | 2215248.0 |
| 2008-12-03 09:30:00 | AAPL | Stock | 3.1929 | 3.2311 | 3.1714 | 3.2129 | 127932448.0 |
| 2008-12-03 10:00:00 | AAPL | Stock | 3.2121 | 3.26 | 3.2029 | 3.2582 | 108482136.0 |
| 2008-12-03 10:30:00 | AAPL | Stock | 3.2571 | 3.3361 | 3.2511 | 3.3289 | 109424392.0 |
| 2008-12-03 11:00:00 | AAPL | Stock | 3.3296 | 3.3604 | 3.3275 | 3.3339 | 80845968.0 |
| 2008-12-03 11:30:00 | AAPL | Stock | 3.3339 | 3.3486 | 3.3107 | 3.3443 | 64028664.0 |
| 2008-12-03 12:00:00 | AAPL | Stock | 3.3446 | 3.35 | 3.3146 | 3.3379 | 55959736.0 |
| 2008-12-03 12:30:00 | AAPL | Stock | 3.3382 | 3.375 | 3.3379 | 3.3671 | 67198992.0 |
| 2008-12-03 13:00:00 | AAPL | Stock | 3.3679 | 3.3679 | 3.2918 | 3.2921 | 65988804.0 |
| 2008-12-03 13:30:00 | AAPL | Stock | 3.2921 | 3.2932 | 3.2632 | 3.2854 | 73872092.0 |
| 2008-12-03 14:00:00 | AAPL | Stock | 3.2843 | 3.3632 | 3.2725 | 3.3543 | 100861628.0 |
| 2008-12-03 14:30:00 | AAPL | Stock | 3.3532 | 3.3957 | 3.3504 | 3.3693 | 122982412.0 |
| 2008-12-03 15:00:00 | AAPL | Stock | 3.3679 | 3.4018 | 3.3429 | 3.3907 | 119688856.0 |
| 2008-12-03 15:30:00 | AAPL | Stock | 3.3904 | 3.4368 | 3.3764 | 3.4257 | 183566124.0 |
| 2008-12-03 16:00:00 | AAPL | Stock | 3.425 | 3.4275 | 3.3251 | 3.4221 | 32573520.0 |
| 2008-12-03 16:30:00 | AAPL | Stock | 3.4214 | 3.425 | 3.3342 | 3.425 | 345324.0 |
| 2008-12-03 17:00:00 | AAPL | Stock | 3.4221 | 3.425 | 3.3744 | 3.4179 | 107044.0 |
| 2008-12-03 17:30:00 | AAPL | Stock | 3.4179 | 3.4196 | 3.4164 | 3.4196 | 42644.0 |
| 2008-12-03 18:00:00 | AAPL | Stock | 3.4179 | 3.425 | 3.4157 | 3.4179 | 1076264.0 |
| 2008-12-03 18:30:00 | AAPL | Stock | 3.4179 | 3.4196 | 3.4179 | 3.4196 | 69468.0 |
| 2008-12-03 19:00:00 | AAPL | Stock | 3.4179 | 3.4179 | 3.4164 | 3.4164 | 55440.0 |
| 2008-12-03 19:30:00 | AAPL | Stock | 3.4171 | 3.4193 | 3.4154 | 3.4179 | 365680.0 |
| 2008-12-03 07:30:00 | MSFT | Stock | 18.93 | 18.93 | 18.92 | 18.92 | 500.0 |
| 2008-12-03 08:00:00 | MSFT | Stock | 18.87 | 18.91 | 18.75 | 18.75 | 21000.0 |
| 2008-12-03 08:30:00 | MSFT | Stock | 18.8 | 18.85 | 18.76 | 18.82 | 7031.0 |
| 2008-12-03 09:00:00 | MSFT | Stock | 18.82 | 18.85 | 18.61 | 18.61 | 123798.0 |
| 2008-12-03 09:30:00 | MSFT | Stock | 18.65 | 19.17 | 18.6 | 18.94 | 7131766.0 |
| 2008-12-03 10:00:00 | MSFT | Stock | 18.94 | 19.27 | 18.83 | 19.26 | 4682977.0 |
| 2008-12-03 10:30:00 | MSFT | Stock | 19.27 | 19.51 | 19.21 | 19.5 | 5291592.0 |
| 2008-12-03 11:00:00 | MSFT | Stock | 19.5 | 19.66 | 19.38 | 19.512 | 4514180.0 |
| 2008-12-03 11:30:00 | MSFT | Stock | 19.51 | 19.76 | 19.37 | 19.73 | 5216347.0 |
| 2008-12-03 12:00:00 | MSFT | Stock | 19.73 | 19.74 | 19.39 | 19.49 | 4038788.0 |
| 2008-12-03 12:30:00 | MSFT | Stock | 19.5 | 19.7 | 19.492 | 19.622 | 3115798.0 |
| 2008-12-03 13:00:00 | MSFT | Stock | 19.63 | 19.65 | 19.3 | 19.302 | 2623629.0 |
| 2008-12-03 13:30:00 | MSFT | Stock | 19.3 | 19.34 | 19.06 | 19.16 | 4337158.0 |
| 2008-12-03 14:00:00 | MSFT | Stock | 19.15 | 19.36 | 18.92 | 19.31 | 6192207.0 |
| 2008-12-03 14:30:00 | MSFT | Stock | 19.298 | 19.57 | 19.298 | 19.45 | 6472020.0 |
| 2008-12-03 15:00:00 | MSFT | Stock | 19.45 | 19.53 | 19.3 | 19.48 | 7327110.0 |
| 2008-12-03 15:30:00 | MSFT | Stock | 19.48 | 19.9 | 19.39 | 19.83 | 14198653.0 |
| 2008-12-03 16:00:00 | MSFT | Stock | 19.87 | 19.957 | 19.15 | 19.75 | 4482265.0 |
| 2008-12-03 16:30:00 | MSFT | Stock | 19.75 | 19.87 | 19.75 | 19.82 | 3277.0 |
| 2008-12-03 17:00:00 | MSFT | Stock | 19.473 | 19.87 | 19.473 | 19.75 | 12840.0 |
| 2008-12-03 17:30:00 | MSFT | Stock | 19.76 | 19.76 | 19.74 | 19.76 | 2000.0 |
| 2008-12-03 18:00:00 | MSFT | Stock | 19.76 | 19.76 | 19.67 | 19.74 | 12789.0 |
| 2008-12-03 18:30:00 | MSFT | Stock | 19.74 | 19.74 | 19.72 | 19.72 | 795.0 |
> showing 50 of 68,541 rows — these rows as CSV