PREVIEW / stock_30min / 2006-09-15
file: by_date/stock_30min/2006/2006-09-15.parquet size: 954 KB rows: 51,378 symbols: 2,342
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-15 08:00:00 | AAPL | Stock | 2.6489 | 2.6554 | 2.6489 | 2.6511 | 251580.0 |
| 2006-09-15 08:30:00 | AAPL | Stock | 2.6514 | 2.6654 | 2.6514 | 2.6639 | 3229996.0 |
| 2006-09-15 09:00:00 | AAPL | Stock | 2.6639 | 2.6786 | 2.6607 | 2.665 | 8247540.0 |
| 2006-09-15 09:30:00 | AAPL | Stock | 2.6643 | 2.6779 | 2.6496 | 2.6657 | 271085528.0 |
| 2006-09-15 10:00:00 | AAPL | Stock | 2.6657 | 2.6725 | 2.6536 | 2.6582 | 75231016.0 |
| 2006-09-15 10:30:00 | AAPL | Stock | 2.6579 | 2.67 | 2.6293 | 2.6368 | 87899616.0 |
| 2006-09-15 11:00:00 | AAPL | Stock | 2.6368 | 2.6443 | 2.6175 | 2.635 | 90125000.0 |
| 2006-09-15 11:30:00 | AAPL | Stock | 2.6346 | 2.6496 | 2.6311 | 2.645 | 45895360.0 |
| 2006-09-15 12:00:00 | AAPL | Stock | 2.645 | 2.6571 | 2.6375 | 2.6543 | 51539236.0 |
| 2006-09-15 12:30:00 | AAPL | Stock | 2.6543 | 2.6546 | 2.6411 | 2.6429 | 53791696.0 |
| 2006-09-15 13:00:00 | AAPL | Stock | 2.6429 | 2.6575 | 2.6425 | 2.6511 | 39714332.0 |
| 2006-09-15 13:30:00 | AAPL | Stock | 2.6511 | 2.6625 | 2.6468 | 2.6579 | 48166300.0 |
| 2006-09-15 14:00:00 | AAPL | Stock | 2.6579 | 2.6621 | 2.6521 | 2.6557 | 26819968.0 |
| 2006-09-15 14:30:00 | AAPL | Stock | 2.6557 | 2.6625 | 2.65 | 2.6511 | 28821380.0 |
| 2006-09-15 15:00:00 | AAPL | Stock | 2.6511 | 2.6579 | 2.6482 | 2.655 | 35948388.0 |
| 2006-09-15 15:30:00 | AAPL | Stock | 2.655 | 2.6554 | 2.6421 | 2.6439 | 75003656.0 |
| 2006-09-15 16:00:00 | AAPL | Stock | 2.6436 | 2.6471 | 2.6429 | 2.6446 | 7327628.0 |
| 2006-09-15 16:30:00 | AAPL | Stock | 2.6443 | 2.6464 | 2.6429 | 2.6461 | 7305004.0 |
| 2006-09-15 17:00:00 | AAPL | Stock | 2.6461 | 2.6467 | 2.645 | 2.6463 | 1049860.0 |
| 2006-09-15 17:30:00 | AAPL | Stock | 2.6446 | 2.645 | 2.6432 | 2.645 | 16800.0 |
| 2006-09-15 18:00:00 | AAPL | Stock | 2.6436 | 2.6464 | 2.6436 | 2.6436 | 221900.0 |
| 2006-09-15 06:30:00 | MSFT | Stock | 26.3 | 26.35 | 26.3 | 26.35 | 1600.0 |
| 2006-09-15 07:00:00 | MSFT | Stock | 26.38 | 26.48 | 26.36 | 26.42 | 10000.0 |
| 2006-09-15 07:30:00 | MSFT | Stock | 26.47 | 26.48 | 26.47 | 26.48 | 11075.0 |
| 2006-09-15 08:00:00 | MSFT | Stock | 26.44 | 26.48 | 26.43 | 26.47 | 540279.0 |
| 2006-09-15 08:30:00 | MSFT | Stock | 26.47 | 26.64 | 26.47 | 26.62 | 424818.0 |
| 2006-09-15 09:00:00 | MSFT | Stock | 26.62 | 26.8 | 26.49 | 26.54 | 2373712.0 |
| 2006-09-15 09:30:00 | MSFT | Stock | 26.58 | 26.76 | 26.49 | 26.73 | 36541187.0 |
| 2006-09-15 10:00:00 | MSFT | Stock | 26.74 | 26.94 | 26.55 | 26.91 | 9785004.0 |
| 2006-09-15 10:30:00 | MSFT | Stock | 26.92 | 26.93 | 26.83 | 26.83 | 6313865.0 |
| 2006-09-15 11:00:00 | MSFT | Stock | 26.84 | 26.88 | 26.83 | 26.86 | 4033267.0 |
| 2006-09-15 11:30:00 | MSFT | Stock | 26.85 | 26.89 | 26.84 | 26.86 | 2032971.0 |
| 2006-09-15 12:00:00 | MSFT | Stock | 26.86 | 26.89 | 26.84 | 26.89 | 2745543.0 |
| 2006-09-15 12:30:00 | MSFT | Stock | 26.88 | 26.9 | 26.78 | 26.79 | 3656056.0 |
| 2006-09-15 13:00:00 | MSFT | Stock | 26.78 | 26.91 | 26.78 | 26.89 | 4466951.0 |
| 2006-09-15 13:30:00 | MSFT | Stock | 26.89 | 26.92 | 26.87 | 26.9 | 5722691.0 |
| 2006-09-15 14:00:00 | MSFT | Stock | 26.9 | 26.91 | 26.86 | 26.89 | 1914318.0 |
| 2006-09-15 14:30:00 | MSFT | Stock | 26.9 | 26.94 | 26.83 | 26.91 | 6092393.0 |
| 2006-09-15 15:00:00 | MSFT | Stock | 26.91 | 26.92 | 26.73 | 26.83 | 9159655.0 |
| 2006-09-15 15:30:00 | MSFT | Stock | 26.83 | 26.86 | 26.72 | 26.82 | 13632441.0 |
| 2006-09-15 16:00:00 | MSFT | Stock | 26.8 | 26.86 | 26.74 | 26.75 | 1992722.0 |
| 2006-09-15 16:30:00 | MSFT | Stock | 26.75 | 26.845 | 25.94 | 26.77 | 1273840.0 |
| 2006-09-15 17:00:00 | MSFT | Stock | 26.831 | 26.849 | 26.74 | 26.844 | 688877.0 |
| 2006-09-15 17:30:00 | MSFT | Stock | 26.78 | 26.78 | 26.74 | 26.74 | 1300.0 |
| 2006-09-15 18:00:00 | MSFT | Stock | 26.74 | 26.78 | 26.74 | 26.78 | 4000.0 |
| 2006-09-15 08:30:00 | NVDA | Stock | 0.483 | 0.4922 | 0.483 | 0.4918 | 433020.0 |
| 2006-09-15 09:00:00 | NVDA | Stock | 0.4925 | 0.4943 | 0.4843 | 0.485 | 4077060.0 |
| 2006-09-15 09:30:00 | NVDA | Stock | 0.4848 | 0.4917 | 0.4825 | 0.4877 | 169271820.0 |
| 2006-09-15 10:00:00 | NVDA | Stock | 0.4877 | 0.495 | 0.4855 | 0.4938 | 80567100.0 |
| 2006-09-15 10:30:00 | NVDA | Stock | 0.4937 | 0.4947 | 0.4893 | 0.4903 | 48351540.0 |
> showing 50 of 51,378 rows — these rows as CSV