PREVIEW / stock_30min / 2006-10-18
file: by_date/stock_30min/2006/2006-10-18.parquet size: 936 KB rows: 50,764 symbols: 2,406
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-18 07:30:00 | AAPL | Stock | 2.6539 | 2.6539 | 2.6361 | 2.6457 | 89320.0 |
| 2006-10-18 08:00:00 | AAPL | Stock | 2.6475 | 2.6654 | 2.6443 | 2.66 | 1342404.0 |
| 2006-10-18 08:30:00 | AAPL | Stock | 2.6607 | 2.675 | 2.6607 | 2.6714 | 2972760.0 |
| 2006-10-18 09:00:00 | AAPL | Stock | 2.6714 | 2.6761 | 2.6661 | 2.6711 | 2296952.0 |
| 2006-10-18 09:30:00 | AAPL | Stock | 2.6696 | 2.6875 | 2.655 | 2.6736 | 117250140.0 |
| 2006-10-18 10:00:00 | AAPL | Stock | 2.6736 | 2.6761 | 2.6568 | 2.6654 | 53977560.0 |
| 2006-10-18 10:30:00 | AAPL | Stock | 2.6657 | 2.6732 | 2.6504 | 2.6568 | 53705064.0 |
| 2006-10-18 11:00:00 | AAPL | Stock | 2.6568 | 2.6614 | 2.6396 | 2.6443 | 63901908.0 |
| 2006-10-18 11:30:00 | AAPL | Stock | 2.6439 | 2.6589 | 2.64 | 2.6561 | 40829208.0 |
| 2006-10-18 12:00:00 | AAPL | Stock | 2.6564 | 2.6732 | 2.65 | 2.6532 | 43806728.0 |
| 2006-10-18 12:30:00 | AAPL | Stock | 2.6536 | 2.6789 | 2.6532 | 2.6736 | 54019784.0 |
| 2006-10-18 13:00:00 | AAPL | Stock | 2.6739 | 2.6918 | 2.6704 | 2.6754 | 62433280.0 |
| 2006-10-18 13:30:00 | AAPL | Stock | 2.6754 | 2.6804 | 2.6668 | 2.68 | 38084956.0 |
| 2006-10-18 14:00:00 | AAPL | Stock | 2.6804 | 2.6893 | 2.6725 | 2.6847 | 42707028.0 |
| 2006-10-18 14:30:00 | AAPL | Stock | 2.6846 | 2.6893 | 2.6768 | 2.6771 | 62541276.0 |
| 2006-10-18 15:00:00 | AAPL | Stock | 2.6786 | 2.6825 | 2.6632 | 2.6664 | 73985268.0 |
| 2006-10-18 15:30:00 | AAPL | Stock | 2.6668 | 2.6714 | 2.6607 | 2.6636 | 73338580.0 |
| 2006-10-18 16:00:00 | AAPL | Stock | 2.6632 | 2.7 | 2.6536 | 2.6996 | 6168372.0 |
| 2006-10-18 16:30:00 | AAPL | Stock | 2.7 | 2.8536 | 2.7 | 2.8246 | 246958880.0 |
| 2006-10-18 17:00:00 | AAPL | Stock | 2.825 | 2.8286 | 2.7679 | 2.7707 | 57808604.0 |
| 2006-10-18 17:30:00 | AAPL | Stock | 2.7707 | 2.7889 | 2.7536 | 2.7643 | 24924956.0 |
| 2006-10-18 18:00:00 | AAPL | Stock | 2.7643 | 2.7875 | 2.7639 | 2.7714 | 10116372.0 |
| 2006-10-18 18:30:00 | AAPL | Stock | 2.7714 | 2.7807 | 2.7689 | 2.7807 | 1327704.0 |
| 2006-10-18 19:00:00 | AAPL | Stock | 2.7811 | 2.7821 | 2.7768 | 2.7789 | 509404.0 |
| 2006-10-18 19:30:00 | AAPL | Stock | 2.7804 | 2.7854 | 2.7789 | 2.7814 | 696584.0 |
| 2006-10-18 08:00:00 | MSFT | Stock | 28.5 | 28.5 | 28.45 | 28.45 | 2400.0 |
| 2006-10-18 08:30:00 | MSFT | Stock | 28.5 | 28.59 | 28.5 | 28.56 | 26781.0 |
| 2006-10-18 09:00:00 | MSFT | Stock | 28.6 | 28.63 | 28.49 | 28.49 | 99998.0 |
| 2006-10-18 09:30:00 | MSFT | Stock | 28.5 | 28.7 | 28.48 | 28.6 | 6830293.0 |
| 2006-10-18 10:00:00 | MSFT | Stock | 28.6 | 28.65 | 28.5 | 28.563 | 3306000.0 |
| 2006-10-18 10:30:00 | MSFT | Stock | 28.56 | 28.58 | 28.4 | 28.43 | 3535735.0 |
| 2006-10-18 11:00:00 | MSFT | Stock | 28.44 | 28.49 | 28.35 | 28.4 | 3908073.0 |
| 2006-10-18 11:30:00 | MSFT | Stock | 28.4 | 28.6 | 28.39 | 28.478 | 1740580.0 |
| 2006-10-18 12:00:00 | MSFT | Stock | 28.48 | 28.5 | 28.46 | 28.47 | 795551.0 |
| 2006-10-18 12:30:00 | MSFT | Stock | 28.47 | 28.47 | 28.36 | 28.37 | 2003328.0 |
| 2006-10-18 13:00:00 | MSFT | Stock | 28.37 | 28.39 | 28.26 | 28.28 | 1869730.0 |
| 2006-10-18 13:30:00 | MSFT | Stock | 28.28 | 28.38 | 28.26 | 28.36 | 2501225.0 |
| 2006-10-18 14:00:00 | MSFT | Stock | 28.36 | 28.49 | 28.35 | 28.46 | 2835698.0 |
| 2006-10-18 14:30:00 | MSFT | Stock | 28.46 | 28.493 | 28.43 | 28.47 | 1953765.0 |
| 2006-10-18 15:00:00 | MSFT | Stock | 28.47 | 28.48 | 28.37 | 28.41 | 2807530.0 |
| 2006-10-18 15:30:00 | MSFT | Stock | 28.41 | 28.52 | 28.39 | 28.52 | 3996860.0 |
| 2006-10-18 16:00:00 | MSFT | Stock | 28.5 | 28.54 | 28.48 | 28.51 | 145842.0 |
| 2006-10-18 16:30:00 | MSFT | Stock | 28.51 | 28.54 | 28.51 | 28.54 | 23367.0 |
| 2006-10-18 17:00:00 | MSFT | Stock | 28.51 | 28.54 | 28.51 | 28.54 | 1900.0 |
| 2006-10-18 17:30:00 | MSFT | Stock | 28.51 | 28.52 | 28.5 | 28.51 | 11521.0 |
| 2006-10-18 18:00:00 | MSFT | Stock | 28.51 | 28.52 | 28.5 | 28.52 | 33472.0 |
| 2006-10-18 18:30:00 | MSFT | Stock | 28.49 | 28.49 | 28.49 | 28.49 | 234.0 |
| 2006-10-18 19:00:00 | MSFT | Stock | 28.49 | 28.49 | 28.48 | 28.48 | 866.0 |
| 2006-10-18 08:00:00 | NVDA | Stock | 0.5448 | 0.5448 | 0.5448 | 0.5448 | 30000.0 |
| 2006-10-18 08:30:00 | NVDA | Stock | 0.5448 | 0.5458 | 0.5448 | 0.5458 | 133500.0 |
> showing 50 of 50,764 rows — these rows as CSV