PREVIEW / stock_30min / 2008-02-13
file: by_date/stock_30min/2008/2008-02-13.parquet size: 1.2 MB rows: 69,746 symbols: 3,263
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-02-13 05:30:00 | AAPL | Stock | 4.4996 | 4.5004 | 4.4996 | 4.5004 | 5600.0 |
| 2008-02-13 07:00:00 | AAPL | Stock | 4.4986 | 4.4986 | 4.4964 | 4.4975 | 16800.0 |
| 2008-02-13 07:30:00 | AAPL | Stock | 4.4893 | 4.5043 | 4.4893 | 4.5 | 96740.0 |
| 2008-02-13 08:00:00 | AAPL | Stock | 4.4929 | 4.4946 | 4.4821 | 4.4846 | 1319388.0 |
| 2008-02-13 08:30:00 | AAPL | Stock | 4.4896 | 4.5179 | 4.4839 | 4.4968 | 4716628.0 |
| 2008-02-13 09:00:00 | AAPL | Stock | 4.4996 | 4.5282 | 4.4982 | 4.5254 | 3800300.0 |
| 2008-02-13 09:30:00 | AAPL | Stock | 4.5257 | 4.5586 | 4.4868 | 4.5364 | 172410392.0 |
| 2008-02-13 10:00:00 | AAPL | Stock | 4.5361 | 4.5661 | 4.5118 | 4.5446 | 109917472.0 |
| 2008-02-13 10:30:00 | AAPL | Stock | 4.5455 | 4.5457 | 4.5125 | 4.5213 | 60599812.0 |
| 2008-02-13 11:00:00 | AAPL | Stock | 4.52 | 4.5361 | 4.5129 | 4.5346 | 45062864.0 |
| 2008-02-13 11:30:00 | AAPL | Stock | 4.535 | 4.5525 | 4.5275 | 4.5318 | 45581872.0 |
| 2008-02-13 12:00:00 | AAPL | Stock | 4.5307 | 4.5536 | 4.5279 | 4.5393 | 33702396.0 |
| 2008-02-13 12:30:00 | AAPL | Stock | 4.5396 | 4.5589 | 4.5393 | 4.5575 | 33953976.0 |
| 2008-02-13 13:00:00 | AAPL | Stock | 4.5571 | 4.5964 | 4.5471 | 4.5793 | 67352992.0 |
| 2008-02-13 13:30:00 | AAPL | Stock | 4.58 | 4.625 | 4.5761 | 4.6054 | 78322916.0 |
| 2008-02-13 14:00:00 | AAPL | Stock | 4.6056 | 4.6161 | 4.5939 | 4.6021 | 59075856.0 |
| 2008-02-13 14:30:00 | AAPL | Stock | 4.6021 | 4.625 | 4.5946 | 4.6214 | 58816968.0 |
| 2008-02-13 15:00:00 | AAPL | Stock | 4.6214 | 4.635 | 4.6121 | 4.6272 | 72908192.0 |
| 2008-02-13 15:30:00 | AAPL | Stock | 4.6271 | 4.6336 | 4.6107 | 4.6161 | 95382812.0 |
| 2008-02-13 16:00:00 | AAPL | Stock | 4.6175 | 4.6243 | 4.5668 | 4.6214 | 19701444.0 |
| 2008-02-13 16:30:00 | AAPL | Stock | 4.6211 | 4.6568 | 4.5846 | 4.655 | 2921380.0 |
| 2008-02-13 17:00:00 | AAPL | Stock | 4.6489 | 4.6489 | 4.635 | 4.6393 | 866572.0 |
| 2008-02-13 17:30:00 | AAPL | Stock | 4.6411 | 4.6429 | 4.5434 | 4.6379 | 640612.0 |
| 2008-02-13 18:00:00 | AAPL | Stock | 4.6411 | 4.6411 | 4.6321 | 4.6357 | 275324.0 |
| 2008-02-13 18:30:00 | AAPL | Stock | 4.6329 | 4.6404 | 4.6325 | 4.6364 | 244384.0 |
| 2008-02-13 19:00:00 | AAPL | Stock | 4.64 | 4.6429 | 4.6371 | 4.6418 | 337400.0 |
| 2008-02-13 19:30:00 | AAPL | Stock | 4.6418 | 4.655 | 4.6418 | 4.6525 | 504840.0 |
| 2008-02-13 07:00:00 | MSFT | Stock | 28.4 | 28.58 | 28.4 | 28.58 | 1900.0 |
| 2008-02-13 07:30:00 | MSFT | Stock | 28.5 | 28.5 | 28.5 | 28.5 | 1000.0 |
| 2008-02-13 08:00:00 | MSFT | Stock | 28.41 | 28.59 | 28.41 | 28.51 | 53625.0 |
| 2008-02-13 08:30:00 | MSFT | Stock | 28.51 | 28.62 | 28.51 | 28.56 | 55219.0 |
| 2008-02-13 09:00:00 | MSFT | Stock | 28.56 | 28.68 | 28.5 | 28.63 | 382477.0 |
| 2008-02-13 09:30:00 | MSFT | Stock | 28.63 | 28.75 | 28.53 | 28.7 | 9969709.0 |
| 2008-02-13 10:00:00 | MSFT | Stock | 28.705 | 28.85 | 28.64 | 28.67 | 9758190.0 |
| 2008-02-13 10:30:00 | MSFT | Stock | 28.665 | 28.92 | 28.63 | 28.85 | 7859694.0 |
| 2008-02-13 11:00:00 | MSFT | Stock | 28.85 | 28.88 | 28.73 | 28.82 | 5240135.0 |
| 2008-02-13 11:30:00 | MSFT | Stock | 28.81 | 28.83 | 28.65 | 28.69 | 3934218.0 |
| 2008-02-13 12:00:00 | MSFT | Stock | 28.68 | 28.75 | 28.62 | 28.65 | 3185597.0 |
| 2008-02-13 12:30:00 | MSFT | Stock | 28.65 | 28.7 | 28.6 | 28.66 | 3101853.0 |
| 2008-02-13 13:00:00 | MSFT | Stock | 28.66 | 28.77 | 28.62 | 28.74 | 3515720.0 |
| 2008-02-13 13:30:00 | MSFT | Stock | 28.74 | 28.87 | 28.73 | 28.82 | 4198144.0 |
| 2008-02-13 14:00:00 | MSFT | Stock | 28.83 | 28.95 | 28.82 | 28.91 | 7201421.0 |
| 2008-02-13 14:30:00 | MSFT | Stock | 28.91 | 29.05 | 28.89 | 29.01 | 8245970.0 |
| 2008-02-13 15:00:00 | MSFT | Stock | 29.01 | 29.04 | 28.86 | 28.935 | 8060625.0 |
| 2008-02-13 15:30:00 | MSFT | Stock | 28.935 | 29.03 | 28.87 | 28.97 | 10172107.0 |
| 2008-02-13 16:00:00 | MSFT | Stock | 28.99 | 29.02 | 28.818 | 28.99 | 3518213.0 |
| 2008-02-13 16:30:00 | MSFT | Stock | 29.049 | 29.049 | 28.96 | 28.98 | 654687.0 |
| 2008-02-13 17:00:00 | MSFT | Stock | 29.02 | 29.05 | 28.325 | 29.02 | 61009.0 |
| 2008-02-13 17:30:00 | MSFT | Stock | 29.02 | 29.05 | 28.67 | 29.05 | 3976.0 |
| 2008-02-13 18:00:00 | MSFT | Stock | 29.02 | 29.02 | 28.99 | 28.99 | 4758.0 |
> showing 50 of 69,746 rows — these rows as CSV