PREVIEW / stock_30min / 2007-12-10
file: by_date/stock_30min/2007/2007-12-10.parquet size: 1.2 MB rows: 70,272 symbols: 3,241
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-10 05:00:00 | AAPL | Stock | 6.9346 | 6.9375 | 6.9346 | 6.9375 | 52444.0 |
| 2007-12-10 05:30:00 | AAPL | Stock | 6.9407 | 6.9407 | 6.9104 | 6.9104 | 8400.0 |
| 2007-12-10 06:30:00 | AAPL | Stock | 6.9471 | 6.9604 | 6.9471 | 6.9554 | 39200.0 |
| 2007-12-10 07:00:00 | AAPL | Stock | 6.9482 | 6.9482 | 6.9189 | 6.9286 | 208320.0 |
| 2007-12-10 07:30:00 | AAPL | Stock | 6.9286 | 6.95 | 6.9282 | 6.95 | 370496.0 |
| 2007-12-10 08:00:00 | AAPL | Stock | 6.95 | 6.9539 | 6.9086 | 6.9286 | 3019828.0 |
| 2007-12-10 08:30:00 | AAPL | Stock | 6.9286 | 6.9314 | 6.8929 | 6.8971 | 4380824.0 |
| 2007-12-10 09:00:00 | AAPL | Stock | 6.9011 | 6.9186 | 6.8836 | 6.9136 | 4263196.0 |
| 2007-12-10 09:30:00 | AAPL | Stock | 6.9139 | 6.9636 | 6.8818 | 6.91 | 133552272.0 |
| 2007-12-10 10:00:00 | AAPL | Stock | 6.9111 | 6.9304 | 6.8893 | 6.9036 | 82840912.0 |
| 2007-12-10 10:30:00 | AAPL | Stock | 6.9036 | 6.9414 | 6.9025 | 6.9382 | 53592812.0 |
| 2007-12-10 11:00:00 | AAPL | Stock | 6.9386 | 6.9407 | 6.9179 | 6.93 | 38139220.0 |
| 2007-12-10 11:30:00 | AAPL | Stock | 6.93 | 6.9879 | 6.9286 | 6.9786 | 67004868.0 |
| 2007-12-10 12:00:00 | AAPL | Stock | 6.9789 | 6.9857 | 6.9607 | 6.9707 | 36033816.0 |
| 2007-12-10 12:30:00 | AAPL | Stock | 6.9707 | 6.9746 | 6.9407 | 6.95 | 31143896.0 |
| 2007-12-10 13:00:00 | AAPL | Stock | 6.9496 | 6.975 | 6.9486 | 6.9579 | 29667372.0 |
| 2007-12-10 13:30:00 | AAPL | Stock | 6.9586 | 6.9704 | 6.9293 | 6.9325 | 36496012.0 |
| 2007-12-10 14:00:00 | AAPL | Stock | 6.9321 | 6.9518 | 6.9132 | 6.9446 | 44380784.0 |
| 2007-12-10 14:30:00 | AAPL | Stock | 6.9454 | 6.955 | 6.9161 | 6.9289 | 36837528.0 |
| 2007-12-10 15:00:00 | AAPL | Stock | 6.9279 | 6.9629 | 6.9236 | 6.9489 | 41357400.0 |
| 2007-12-10 15:30:00 | AAPL | Stock | 6.9493 | 6.9539 | 6.9268 | 6.9346 | 58994936.0 |
| 2007-12-10 16:00:00 | AAPL | Stock | 6.9357 | 6.9721 | 6.9289 | 6.9361 | 18217668.0 |
| 2007-12-10 16:30:00 | AAPL | Stock | 6.9339 | 6.9479 | 6.9304 | 6.9446 | 728896.0 |
| 2007-12-10 17:00:00 | AAPL | Stock | 6.9414 | 6.9718 | 6.9411 | 6.95 | 232932.0 |
| 2007-12-10 17:30:00 | AAPL | Stock | 6.9653 | 6.9653 | 6.9464 | 6.95 | 402948.0 |
| 2007-12-10 18:00:00 | AAPL | Stock | 6.9529 | 6.9529 | 6.9439 | 6.95 | 102816.0 |
| 2007-12-10 18:30:00 | AAPL | Stock | 6.9464 | 6.95 | 6.945 | 6.9464 | 97020.0 |
| 2007-12-10 19:00:00 | AAPL | Stock | 6.9482 | 6.9493 | 6.9482 | 6.9493 | 56952.0 |
| 2007-12-10 19:30:00 | AAPL | Stock | 6.9482 | 6.9554 | 6.9468 | 6.95 | 376320.0 |
| 2007-12-10 08:00:00 | MSFT | Stock | 34.5 | 34.6 | 34.5 | 34.6 | 2790.0 |
| 2007-12-10 08:30:00 | MSFT | Stock | 34.5 | 34.58 | 34.47 | 34.47 | 431.0 |
| 2007-12-10 09:00:00 | MSFT | Stock | 34.46 | 34.64 | 34.45 | 34.62 | 22203.0 |
| 2007-12-10 09:30:00 | MSFT | Stock | 34.59 | 34.83 | 34.47 | 34.579 | 5167743.0 |
| 2007-12-10 10:00:00 | MSFT | Stock | 34.57 | 34.85 | 34.57 | 34.74 | 4460482.0 |
| 2007-12-10 10:30:00 | MSFT | Stock | 34.74 | 34.95 | 34.74 | 34.9 | 2537504.0 |
| 2007-12-10 11:00:00 | MSFT | Stock | 34.9 | 34.94 | 34.79 | 34.8 | 1675751.0 |
| 2007-12-10 11:30:00 | MSFT | Stock | 34.8 | 34.92 | 34.79 | 34.89 | 1721704.0 |
| 2007-12-10 12:00:00 | MSFT | Stock | 34.89 | 34.92 | 34.85 | 34.862 | 1375918.0 |
| 2007-12-10 12:30:00 | MSFT | Stock | 34.866 | 34.91 | 34.86 | 34.87 | 1484838.0 |
| 2007-12-10 13:00:00 | MSFT | Stock | 34.87 | 34.93 | 34.86 | 34.88 | 1565641.0 |
| 2007-12-10 13:30:00 | MSFT | Stock | 34.88 | 34.91 | 34.83 | 34.85 | 2472743.0 |
| 2007-12-10 14:00:00 | MSFT | Stock | 34.85 | 34.92 | 34.835 | 34.9 | 2379779.0 |
| 2007-12-10 14:30:00 | MSFT | Stock | 34.9 | 34.95 | 34.83 | 34.835 | 2170642.0 |
| 2007-12-10 15:00:00 | MSFT | Stock | 34.84 | 34.9 | 34.82 | 34.83 | 2541214.0 |
| 2007-12-10 15:30:00 | MSFT | Stock | 34.83 | 34.86 | 34.76 | 34.77 | 4736889.0 |
| 2007-12-10 16:00:00 | MSFT | Stock | 34.77 | 34.88 | 34.73 | 34.76 | 1699753.0 |
| 2007-12-10 16:30:00 | MSFT | Stock | 34.85 | 34.858 | 34.75 | 34.84 | 42760.0 |
| 2007-12-10 17:00:00 | MSFT | Stock | 34.84 | 34.86 | 34.81 | 34.849 | 14061.0 |
| 2007-12-10 17:30:00 | MSFT | Stock | 34.909 | 34.909 | 34.86 | 34.86 | 6540.0 |
| 2007-12-10 18:00:00 | MSFT | Stock | 34.86 | 34.86 | 34.85 | 34.85 | 6787.0 |
> showing 50 of 70,272 rows — these rows as CSV