PREVIEW / stock_30min / 2006-12-28
file: by_date/stock_30min/2006/2006-12-28.parquet size: 977 KB rows: 53,551 symbols: 2,484
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-12-28 04:30:00 | AAPL | Stock | 2.8282 | 2.8282 | 2.8282 | 2.8282 | 5600.0 |
| 2006-12-28 06:00:00 | AAPL | Stock | 2.8143 | 2.8257 | 2.8143 | 2.825 | 207200.0 |
| 2006-12-28 06:30:00 | AAPL | Stock | 2.8257 | 2.8268 | 2.8143 | 2.8143 | 380436.0 |
| 2006-12-28 07:00:00 | AAPL | Stock | 2.8161 | 2.8168 | 2.7579 | 2.7779 | 4128208.0 |
| 2006-12-28 07:30:00 | AAPL | Stock | 2.775 | 2.8321 | 2.775 | 2.825 | 7236544.0 |
| 2006-12-28 08:00:00 | AAPL | Stock | 2.8236 | 2.8429 | 2.8125 | 2.8339 | 16873248.0 |
| 2006-12-28 08:30:00 | AAPL | Stock | 2.8343 | 2.8618 | 2.8321 | 2.8557 | 18838932.0 |
| 2006-12-28 09:00:00 | AAPL | Stock | 2.8554 | 2.8721 | 2.8518 | 2.8643 | 18182052.0 |
| 2006-12-28 09:30:00 | AAPL | Stock | 2.865 | 2.8864 | 2.8446 | 2.8614 | 207096232.0 |
| 2006-12-28 10:00:00 | AAPL | Stock | 2.8611 | 2.8721 | 2.8579 | 2.8693 | 111535564.0 |
| 2006-12-28 10:30:00 | AAPL | Stock | 2.8693 | 2.8786 | 2.865 | 2.8668 | 88067868.0 |
| 2006-12-28 11:00:00 | AAPL | Stock | 2.8668 | 2.8668 | 2.8521 | 2.8579 | 87010364.0 |
| 2006-12-28 11:30:00 | AAPL | Stock | 2.8579 | 2.8589 | 2.8468 | 2.8536 | 77963032.0 |
| 2006-12-28 12:00:00 | AAPL | Stock | 2.8536 | 2.865 | 2.8507 | 2.8643 | 57197896.0 |
| 2006-12-28 12:30:00 | AAPL | Stock | 2.8643 | 2.8693 | 2.8614 | 2.8635 | 39855564.0 |
| 2006-12-28 13:00:00 | AAPL | Stock | 2.8636 | 2.8636 | 2.8561 | 2.8629 | 31598672.0 |
| 2006-12-28 13:30:00 | AAPL | Stock | 2.8632 | 2.8661 | 2.8607 | 2.8621 | 30894024.0 |
| 2006-12-28 14:00:00 | AAPL | Stock | 2.8618 | 2.8857 | 2.8614 | 2.8775 | 68199236.0 |
| 2006-12-28 14:30:00 | AAPL | Stock | 2.8771 | 2.8843 | 2.8686 | 2.8818 | 59606764.0 |
| 2006-12-28 15:00:00 | AAPL | Stock | 2.8818 | 2.9018 | 2.8814 | 2.895 | 105547456.0 |
| 2006-12-28 15:30:00 | AAPL | Stock | 2.8946 | 2.9 | 2.8857 | 2.8884 | 82136488.0 |
| 2006-12-28 16:00:00 | AAPL | Stock | 2.8868 | 2.8921 | 2.8861 | 2.89 | 2252824.0 |
| 2006-12-28 16:30:00 | AAPL | Stock | 2.8896 | 2.8896 | 2.8871 | 2.8871 | 296352.0 |
| 2006-12-28 17:00:00 | AAPL | Stock | 2.8882 | 2.89 | 2.8857 | 2.8857 | 215600.0 |
| 2006-12-28 17:30:00 | AAPL | Stock | 2.8854 | 2.8857 | 2.8846 | 2.8857 | 93800.0 |
| 2006-12-28 18:00:00 | AAPL | Stock | 2.8879 | 2.8879 | 2.8846 | 2.885 | 111076.0 |
| 2006-12-28 18:30:00 | AAPL | Stock | 2.8843 | 2.8875 | 2.8839 | 2.8857 | 449960.0 |
| 2006-12-28 19:00:00 | AAPL | Stock | 2.8843 | 2.8893 | 2.8839 | 2.8893 | 273140.0 |
| 2006-12-28 19:30:00 | AAPL | Stock | 2.89 | 2.8921 | 2.8896 | 2.8921 | 233044.0 |
| 2006-12-28 07:30:00 | MSFT | Stock | 29.84 | 29.84 | 29.84 | 29.84 | 300.0 |
| 2006-12-28 08:30:00 | MSFT | Stock | 29.9 | 29.93 | 29.9 | 29.93 | 3200.0 |
| 2006-12-28 09:00:00 | MSFT | Stock | 29.9 | 29.9 | 29.82 | 29.85 | 15643.0 |
| 2006-12-28 09:30:00 | MSFT | Stock | 29.86 | 29.96 | 29.81 | 29.925 | 3061574.0 |
| 2006-12-28 10:00:00 | MSFT | Stock | 29.93 | 29.99 | 29.9 | 29.9 | 2132129.0 |
| 2006-12-28 10:30:00 | MSFT | Stock | 29.9 | 29.93 | 29.9 | 29.91 | 1324650.0 |
| 2006-12-28 11:00:00 | MSFT | Stock | 29.91 | 30.01 | 29.9 | 29.91 | 1028061.0 |
| 2006-12-28 11:30:00 | MSFT | Stock | 29.9 | 29.91 | 29.9 | 29.909 | 1106235.0 |
| 2006-12-28 12:00:00 | MSFT | Stock | 29.9 | 29.94 | 29.86 | 29.92 | 2395772.0 |
| 2006-12-28 12:30:00 | MSFT | Stock | 29.92 | 29.96 | 29.91 | 29.91 | 615881.0 |
| 2006-12-28 13:00:00 | MSFT | Stock | 29.91 | 29.92 | 29.91 | 29.92 | 560933.0 |
| 2006-12-28 13:30:00 | MSFT | Stock | 29.91 | 29.94 | 29.91 | 29.91 | 779465.0 |
| 2006-12-28 14:00:00 | MSFT | Stock | 29.912 | 30.02 | 29.9 | 29.969 | 1968195.0 |
| 2006-12-28 14:30:00 | MSFT | Stock | 29.96 | 30.01 | 29.94 | 30.0 | 1551903.0 |
| 2006-12-28 15:00:00 | MSFT | Stock | 30.0 | 30.03 | 29.93 | 29.93 | 2418860.0 |
| 2006-12-28 15:30:00 | MSFT | Stock | 29.93 | 29.99 | 29.89 | 29.98 | 3246385.0 |
| 2006-12-28 16:00:00 | MSFT | Stock | 29.96 | 29.98 | 29.91 | 29.97 | 136116.0 |
| 2006-12-28 16:30:00 | MSFT | Stock | 29.98 | 29.98 | 29.98 | 29.98 | 61850.0 |
| 2006-12-28 17:00:00 | MSFT | Stock | 29.98 | 29.98 | 29.97 | 29.98 | 8100.0 |
| 2006-12-28 18:00:00 | MSFT | Stock | 29.977 | 29.977 | 29.97 | 29.97 | 1961.0 |
| 2006-12-28 19:00:00 | MSFT | Stock | 29.96 | 29.96 | 29.96 | 29.96 | 400.0 |
> showing 50 of 53,551 rows — these rows as CSV