PREVIEW / stock_30min / 2009-12-11
file: by_date/stock_30min/2009/2009-12-11.parquet size: 1.3 MB rows: 71,551 symbols: 3,442
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-11 06:30:00 | AAPL | Stock | 7.0614 | 7.0614 | 7.0571 | 7.0571 | 5600.0 |
| 2009-12-11 07:00:00 | AAPL | Stock | 7.0536 | 7.0536 | 7.0536 | 7.0536 | 2800.0 |
| 2009-12-11 07:30:00 | AAPL | Stock | 7.06 | 7.0896 | 7.06 | 7.0754 | 343392.0 |
| 2009-12-11 08:00:00 | AAPL | Stock | 7.0761 | 7.0786 | 7.0154 | 7.05 | 2069648.0 |
| 2009-12-11 08:30:00 | AAPL | Stock | 7.0564 | 7.0714 | 7.05 | 7.0607 | 1279852.0 |
| 2009-12-11 09:00:00 | AAPL | Stock | 7.0604 | 7.0643 | 7.0475 | 7.0607 | 1236732.0 |
| 2009-12-11 09:30:00 | AAPL | Stock | 7.0636 | 7.0714 | 7.01 | 7.0467 | 62720336.0 |
| 2009-12-11 10:00:00 | AAPL | Stock | 7.0475 | 7.0482 | 6.9771 | 7.0029 | 45881276.0 |
| 2009-12-11 10:30:00 | AAPL | Stock | 7.0039 | 7.0161 | 6.9875 | 6.9943 | 27487936.0 |
| 2009-12-11 11:00:00 | AAPL | Stock | 6.9946 | 6.9957 | 6.9375 | 6.9491 | 44425640.0 |
| 2009-12-11 11:30:00 | AAPL | Stock | 6.9486 | 6.9554 | 6.9107 | 6.9293 | 42101164.0 |
| 2009-12-11 12:00:00 | AAPL | Stock | 6.9289 | 6.9429 | 6.9196 | 6.9411 | 22762264.0 |
| 2009-12-11 12:30:00 | AAPL | Stock | 6.9407 | 6.9607 | 6.9311 | 6.9607 | 19315604.0 |
| 2009-12-11 13:00:00 | AAPL | Stock | 6.9607 | 6.9632 | 6.9361 | 6.9389 | 15017492.0 |
| 2009-12-11 13:30:00 | AAPL | Stock | 6.9404 | 6.9504 | 6.9304 | 6.9357 | 15810228.0 |
| 2009-12-11 14:00:00 | AAPL | Stock | 6.9357 | 6.9564 | 6.9339 | 6.9461 | 15693440.0 |
| 2009-12-11 14:30:00 | AAPL | Stock | 6.9466 | 6.9511 | 6.9321 | 6.9443 | 17769360.0 |
| 2009-12-11 15:00:00 | AAPL | Stock | 6.9441 | 6.9643 | 6.9421 | 6.9643 | 22244432.0 |
| 2009-12-11 15:30:00 | AAPL | Stock | 6.9643 | 6.9743 | 6.9082 | 6.9536 | 47613132.0 |
| 2009-12-11 16:00:00 | AAPL | Stock | 6.9461 | 7.0154 | 6.9237 | 6.9539 | 11556552.0 |
| 2009-12-11 16:30:00 | AAPL | Stock | 6.9539 | 6.9626 | 6.9493 | 6.9525 | 305564.0 |
| 2009-12-11 17:00:00 | AAPL | Stock | 6.9571 | 6.9586 | 6.9532 | 6.9536 | 69636.0 |
| 2009-12-11 17:30:00 | AAPL | Stock | 6.9536 | 6.9589 | 6.9532 | 6.9571 | 50400.0 |
| 2009-12-11 18:00:00 | AAPL | Stock | 6.9525 | 7.0364 | 6.9525 | 6.9571 | 326648.0 |
| 2009-12-11 18:30:00 | AAPL | Stock | 6.9536 | 6.9536 | 6.9529 | 6.9536 | 66360.0 |
| 2009-12-11 19:00:00 | AAPL | Stock | 6.9536 | 6.9554 | 6.9536 | 6.9554 | 72660.0 |
| 2009-12-11 19:30:00 | AAPL | Stock | 6.9568 | 6.9643 | 6.9539 | 6.9607 | 291760.0 |
| 2009-12-11 08:00:00 | MSFT | Stock | 29.87 | 29.97 | 29.87 | 29.97 | 1544.0 |
| 2009-12-11 08:30:00 | MSFT | Stock | 29.97 | 29.97 | 29.92 | 29.92 | 5205.0 |
| 2009-12-11 09:00:00 | MSFT | Stock | 29.92 | 29.98 | 29.87 | 29.97 | 37901.0 |
| 2009-12-11 09:30:00 | MSFT | Stock | 29.96 | 30.0 | 29.93 | 29.965 | 5477660.0 |
| 2009-12-11 10:00:00 | MSFT | Stock | 29.968 | 30.0 | 29.87 | 29.92 | 5255937.0 |
| 2009-12-11 10:30:00 | MSFT | Stock | 29.91 | 29.97 | 29.91 | 29.94 | 2154196.0 |
| 2009-12-11 11:00:00 | MSFT | Stock | 29.94 | 29.95 | 29.81 | 29.83 | 3243257.0 |
| 2009-12-11 11:30:00 | MSFT | Stock | 29.82 | 29.956 | 29.79 | 29.872 | 2904879.0 |
| 2009-12-11 12:00:00 | MSFT | Stock | 29.88 | 29.89 | 29.8 | 29.82 | 2100919.0 |
| 2009-12-11 12:30:00 | MSFT | Stock | 29.82 | 29.88 | 29.82 | 29.86 | 2145309.0 |
| 2009-12-11 13:00:00 | MSFT | Stock | 29.87 | 29.9 | 29.85 | 29.87 | 1577681.0 |
| 2009-12-11 13:30:00 | MSFT | Stock | 29.865 | 29.87 | 29.84 | 29.851 | 1085129.0 |
| 2009-12-11 14:00:00 | MSFT | Stock | 29.85 | 29.88 | 29.83 | 29.86 | 1801270.0 |
| 2009-12-11 14:30:00 | MSFT | Stock | 29.85 | 29.9 | 29.82 | 29.84 | 4297912.0 |
| 2009-12-11 15:00:00 | MSFT | Stock | 29.84 | 29.9 | 29.82 | 29.9 | 2400232.0 |
| 2009-12-11 15:30:00 | MSFT | Stock | 29.9 | 29.9 | 29.81 | 29.85 | 5668599.0 |
| 2009-12-11 16:00:00 | MSFT | Stock | 29.86 | 29.9 | 29.849 | 29.86 | 2376517.0 |
| 2009-12-11 16:30:00 | MSFT | Stock | 29.85 | 29.88 | 29.85 | 29.85 | 18685.0 |
| 2009-12-11 17:00:00 | MSFT | Stock | 29.87 | 29.87 | 29.87 | 29.87 | 100.0 |
| 2009-12-11 17:30:00 | MSFT | Stock | 29.85 | 29.85 | 29.85 | 29.85 | 1000.0 |
| 2009-12-11 19:00:00 | MSFT | Stock | 29.87 | 29.88 | 29.87 | 29.88 | 968.0 |
| 2009-12-11 19:30:00 | MSFT | Stock | 29.88 | 29.88 | 29.88 | 29.88 | 450.0 |
| 2009-12-11 08:00:00 | NVDA | Stock | 0.388 | 0.388 | 0.388 | 0.388 | 24000.0 |
> showing 50 of 71,551 rows — these rows as CSV