PREVIEW / stock_30min / 2006-10-17
file: by_date/stock_30min/2006/2006-10-17.parquet size: 937 KB rows: 50,624 symbols: 2,392
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-10-17 06:30:00 | AAPL | Stock | 2.6864 | 2.6864 | 2.6864 | 2.6864 | 2800.0 |
| 2006-10-17 08:00:00 | AAPL | Stock | 2.6839 | 2.6861 | 2.6796 | 2.6821 | 306600.0 |
| 2006-10-17 08:30:00 | AAPL | Stock | 2.6825 | 2.6825 | 2.6757 | 2.6786 | 931476.0 |
| 2006-10-17 09:00:00 | AAPL | Stock | 2.68 | 2.6839 | 2.6768 | 2.6786 | 567084.0 |
| 2006-10-17 09:30:00 | AAPL | Stock | 2.68 | 2.6882 | 2.6671 | 2.6739 | 54811904.0 |
| 2006-10-17 10:00:00 | AAPL | Stock | 2.6739 | 2.6764 | 2.6675 | 2.6696 | 36270108.0 |
| 2006-10-17 10:30:00 | AAPL | Stock | 2.6696 | 2.6704 | 2.6571 | 2.6618 | 45647364.0 |
| 2006-10-17 11:00:00 | AAPL | Stock | 2.6618 | 2.6618 | 2.6443 | 2.6504 | 47235076.0 |
| 2006-10-17 11:30:00 | AAPL | Stock | 2.6504 | 2.6679 | 2.6493 | 2.6532 | 44603496.0 |
| 2006-10-17 12:00:00 | AAPL | Stock | 2.6532 | 2.6621 | 2.6504 | 2.6571 | 20732208.0 |
| 2006-10-17 12:30:00 | AAPL | Stock | 2.6571 | 2.6643 | 2.65 | 2.6621 | 21324464.0 |
| 2006-10-17 13:00:00 | AAPL | Stock | 2.6625 | 2.6675 | 2.6539 | 2.6579 | 23837688.0 |
| 2006-10-17 13:30:00 | AAPL | Stock | 2.6579 | 2.6661 | 2.6518 | 2.6636 | 34025824.0 |
| 2006-10-17 14:00:00 | AAPL | Stock | 2.6639 | 2.6646 | 2.6536 | 2.6543 | 31602676.0 |
| 2006-10-17 14:30:00 | AAPL | Stock | 2.6546 | 2.6625 | 2.6546 | 2.6561 | 35747796.0 |
| 2006-10-17 15:00:00 | AAPL | Stock | 2.6564 | 2.6639 | 2.6557 | 2.6596 | 26574660.0 |
| 2006-10-17 15:30:00 | AAPL | Stock | 2.6593 | 2.6621 | 2.6518 | 2.6529 | 50840916.0 |
| 2006-10-17 16:00:00 | AAPL | Stock | 2.6529 | 2.6554 | 2.6479 | 2.6521 | 1045268.0 |
| 2006-10-17 16:30:00 | AAPL | Stock | 2.6543 | 2.6546 | 2.6482 | 2.6482 | 363104.0 |
| 2006-10-17 17:00:00 | AAPL | Stock | 2.6468 | 2.6571 | 2.6464 | 2.6518 | 1140720.0 |
| 2006-10-17 17:30:00 | AAPL | Stock | 2.6536 | 2.6561 | 2.6521 | 2.6557 | 148400.0 |
| 2006-10-17 18:00:00 | AAPL | Stock | 2.6557 | 2.6571 | 2.6543 | 2.6571 | 172564.0 |
| 2006-10-17 18:30:00 | AAPL | Stock | 2.6561 | 2.6561 | 2.6561 | 2.6561 | 14000.0 |
| 2006-10-17 04:30:00 | MSFT | Stock | 28.35 | 28.35 | 28.35 | 28.35 | 300.0 |
| 2006-10-17 07:00:00 | MSFT | Stock | 28.37 | 28.37 | 28.37 | 28.37 | 500.0 |
| 2006-10-17 07:30:00 | MSFT | Stock | 28.37 | 28.7 | 28.37 | 28.42 | 6186.0 |
| 2006-10-17 08:00:00 | MSFT | Stock | 28.38 | 28.41 | 28.37 | 28.38 | 24844.0 |
| 2006-10-17 08:30:00 | MSFT | Stock | 28.37 | 28.37 | 28.27 | 28.27 | 281992.0 |
| 2006-10-17 09:00:00 | MSFT | Stock | 28.3 | 28.33 | 28.23 | 28.24 | 146575.0 |
| 2006-10-17 09:30:00 | MSFT | Stock | 28.24 | 28.36 | 28.17 | 28.3 | 5603817.0 |
| 2006-10-17 10:00:00 | MSFT | Stock | 28.31 | 28.35 | 28.25 | 28.27 | 3276980.0 |
| 2006-10-17 10:30:00 | MSFT | Stock | 28.27 | 28.32 | 28.25 | 28.28 | 2172366.0 |
| 2006-10-17 11:00:00 | MSFT | Stock | 28.28 | 28.28 | 28.21 | 28.21 | 2353237.0 |
| 2006-10-17 11:30:00 | MSFT | Stock | 28.22 | 28.28 | 28.21 | 28.25 | 2633345.0 |
| 2006-10-17 12:00:00 | MSFT | Stock | 28.26 | 28.32 | 28.25 | 28.307 | 1543857.0 |
| 2006-10-17 12:30:00 | MSFT | Stock | 28.3 | 28.39 | 28.3 | 28.35 | 1586322.0 |
| 2006-10-17 13:00:00 | MSFT | Stock | 28.357 | 28.39 | 28.3 | 28.321 | 2293509.0 |
| 2006-10-17 13:30:00 | MSFT | Stock | 28.32 | 28.36 | 28.27 | 28.36 | 1996234.0 |
| 2006-10-17 14:00:00 | MSFT | Stock | 28.35 | 28.36 | 28.32 | 28.34 | 1227784.0 |
| 2006-10-17 14:30:00 | MSFT | Stock | 28.34 | 28.49 | 28.34 | 28.43 | 3314324.0 |
| 2006-10-17 15:00:00 | MSFT | Stock | 28.43 | 28.5 | 28.39 | 28.49 | 3962830.0 |
| 2006-10-17 15:30:00 | MSFT | Stock | 28.48 | 28.51 | 28.4 | 28.49 | 6020175.0 |
| 2006-10-17 16:00:00 | MSFT | Stock | 28.49 | 28.57 | 28.43 | 28.53 | 299022.0 |
| 2006-10-17 16:30:00 | MSFT | Stock | 28.53 | 28.55 | 28.49 | 28.51 | 418661.0 |
| 2006-10-17 17:00:00 | MSFT | Stock | 28.51 | 28.57 | 28.51 | 28.51 | 21530.0 |
| 2006-10-17 17:30:00 | MSFT | Stock | 28.54 | 28.58 | 28.54 | 28.58 | 4600.0 |
| 2006-10-17 18:00:00 | MSFT | Stock | 28.55 | 28.55 | 28.51 | 28.51 | 4300.0 |
| 2006-10-17 18:30:00 | MSFT | Stock | 28.47 | 28.47 | 28.47 | 28.47 | 100.0 |
| 2006-10-17 19:30:00 | MSFT | Stock | 28.49 | 28.49 | 28.49 | 28.49 | 100.0 |
| 2006-10-17 08:00:00 | NVDA | Stock | 0.5572 | 0.5572 | 0.5567 | 0.5567 | 456900.0 |
> showing 50 of 50,624 rows — these rows as CSV