PREVIEW / stock_30min / 2005-12-06
file: by_date/stock_30min/2005/2005-12-06.parquet size: 887 KB rows: 47,797 symbols: 2,114
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-06 05:00:00 | AAPL | Stock | 2.5829 | 2.5829 | 2.5829 | 2.5829 | 2800.0 |
| 2005-12-06 06:00:00 | AAPL | Stock | 2.5893 | 2.5893 | 2.5857 | 2.5857 | 39200.0 |
| 2005-12-06 07:00:00 | AAPL | Stock | 2.5861 | 2.6054 | 2.5861 | 2.6054 | 114800.0 |
| 2005-12-06 07:30:00 | AAPL | Stock | 2.6036 | 2.6036 | 2.6036 | 2.6036 | 28000.0 |
| 2005-12-06 08:00:00 | AAPL | Stock | 2.6071 | 2.6321 | 2.6071 | 2.6218 | 9481472.0 |
| 2005-12-06 08:30:00 | AAPL | Stock | 2.6225 | 2.6325 | 2.565 | 2.6321 | 6328756.0 |
| 2005-12-06 09:00:00 | AAPL | Stock | 2.6311 | 2.6446 | 2.6271 | 2.6404 | 10887744.0 |
| 2005-12-06 09:30:00 | AAPL | Stock | 2.6404 | 2.6479 | 2.6196 | 2.6293 | 146558748.0 |
| 2005-12-06 10:00:00 | AAPL | Stock | 2.6293 | 2.6536 | 2.6264 | 2.6532 | 103211584.0 |
| 2005-12-06 10:30:00 | AAPL | Stock | 2.6532 | 2.6579 | 2.6418 | 2.6493 | 75331984.0 |
| 2005-12-06 11:00:00 | AAPL | Stock | 2.6489 | 2.6507 | 2.6379 | 2.6457 | 47684504.0 |
| 2005-12-06 11:30:00 | AAPL | Stock | 2.6453 | 2.6618 | 2.6429 | 2.6561 | 52085460.0 |
| 2005-12-06 12:00:00 | AAPL | Stock | 2.6561 | 2.6704 | 2.6554 | 2.6668 | 56413448.0 |
| 2005-12-06 12:30:00 | AAPL | Stock | 2.6661 | 2.6661 | 2.655 | 2.6575 | 31961216.0 |
| 2005-12-06 13:00:00 | AAPL | Stock | 2.6572 | 2.6643 | 2.6529 | 2.6614 | 31827628.0 |
| 2005-12-06 13:30:00 | AAPL | Stock | 2.6614 | 2.6725 | 2.66 | 2.6671 | 32699380.0 |
| 2005-12-06 14:00:00 | AAPL | Stock | 2.6671 | 2.6675 | 2.6546 | 2.6654 | 35234276.0 |
| 2005-12-06 14:30:00 | AAPL | Stock | 2.665 | 2.6704 | 2.6611 | 2.6661 | 32491676.0 |
| 2005-12-06 15:00:00 | AAPL | Stock | 2.6657 | 2.6686 | 2.6414 | 2.645 | 83158964.0 |
| 2005-12-06 15:30:00 | AAPL | Stock | 2.6454 | 2.6511 | 2.6332 | 2.6443 | 87366104.0 |
| 2005-12-06 16:00:00 | AAPL | Stock | 2.6454 | 2.6502 | 2.6443 | 2.6493 | 2907604.0 |
| 2005-12-06 16:30:00 | AAPL | Stock | 2.6479 | 2.6489 | 2.6446 | 2.6468 | 1476916.0 |
| 2005-12-06 17:00:00 | AAPL | Stock | 2.6464 | 2.6486 | 2.6446 | 2.6479 | 194096.0 |
| 2005-12-06 17:30:00 | AAPL | Stock | 2.6482 | 2.6496 | 2.6468 | 2.6489 | 595532.0 |
| 2005-12-06 18:00:00 | AAPL | Stock | 2.6489 | 2.6493 | 2.6464 | 2.6486 | 114688.0 |
| 2005-12-06 07:00:00 | MSFT | Stock | 27.84 | 27.84 | 27.84 | 27.84 | 1000.0 |
| 2005-12-06 08:00:00 | MSFT | Stock | 27.85 | 27.92 | 27.84 | 27.92 | 12748.0 |
| 2005-12-06 08:30:00 | MSFT | Stock | 27.92 | 27.96 | 27.85 | 27.9 | 38231.0 |
| 2005-12-06 09:00:00 | MSFT | Stock | 27.85 | 27.92 | 27.85 | 27.9 | 31900.0 |
| 2005-12-06 09:30:00 | MSFT | Stock | 27.9 | 27.921 | 27.71 | 27.75 | 5147330.0 |
| 2005-12-06 10:00:00 | MSFT | Stock | 27.75 | 27.85 | 27.74 | 27.848 | 4402265.0 |
| 2005-12-06 10:30:00 | MSFT | Stock | 27.84 | 27.87 | 27.77 | 27.82 | 2296267.0 |
| 2005-12-06 11:00:00 | MSFT | Stock | 27.82 | 27.82 | 27.69 | 27.74 | 3898347.0 |
| 2005-12-06 11:30:00 | MSFT | Stock | 27.74 | 27.832 | 27.73 | 27.77 | 3253442.0 |
| 2005-12-06 12:00:00 | MSFT | Stock | 27.78 | 27.84 | 27.77 | 27.81 | 2511773.0 |
| 2005-12-06 12:30:00 | MSFT | Stock | 27.81 | 27.81 | 27.72 | 27.78 | 2331142.0 |
| 2005-12-06 13:00:00 | MSFT | Stock | 27.78 | 27.8 | 27.75 | 27.77 | 2097223.0 |
| 2005-12-06 13:30:00 | MSFT | Stock | 27.76 | 27.84 | 27.76 | 27.81 | 6889044.0 |
| 2005-12-06 14:00:00 | MSFT | Stock | 27.81 | 27.82 | 27.78 | 27.792 | 4137969.0 |
| 2005-12-06 14:30:00 | MSFT | Stock | 27.8 | 27.84 | 27.78 | 27.83 | 4439886.0 |
| 2005-12-06 15:00:00 | MSFT | Stock | 27.84 | 27.84 | 27.73 | 27.77 | 5506593.0 |
| 2005-12-06 15:30:00 | MSFT | Stock | 27.78 | 27.81 | 27.68 | 27.71 | 12731068.0 |
| 2005-12-06 16:00:00 | MSFT | Stock | 27.69 | 27.73 | 27.67 | 27.69 | 1304587.0 |
| 2005-12-06 16:30:00 | MSFT | Stock | 27.73 | 27.73 | 27.71 | 27.71 | 1950.0 |
| 2005-12-06 17:00:00 | MSFT | Stock | 27.72 | 27.72 | 27.69 | 27.69 | 2493.0 |
| 2005-12-06 17:30:00 | MSFT | Stock | 27.72 | 27.72 | 27.71 | 27.71 | 400.0 |
| 2005-12-06 18:00:00 | MSFT | Stock | 27.71 | 27.72 | 27.71 | 27.72 | 2100.0 |
| 2005-12-06 08:30:00 | NVDA | Stock | 0.2992 | 0.2992 | 0.2992 | 0.2992 | 48000.0 |
| 2005-12-06 09:00:00 | NVDA | Stock | 0.2998 | 0.2998 | 0.2997 | 0.2997 | 24000.0 |
| 2005-12-06 09:30:00 | NVDA | Stock | 0.2997 | 0.3022 | 0.2995 | 0.3002 | 36993000.0 |
> showing 50 of 47,797 rows — these rows as CSV