PREVIEW / stock_30min / 2006-12-20
file: by_date/stock_30min/2006/2006-12-20.parquet size: 975 KB rows: 53,174 symbols: 2,477
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-20 07:00:00 | AAPL | Stock | 3.0954 | 3.1032 | 3.0954 | 3.1032 | 27720.0 |
| 2006-12-20 07:30:00 | AAPL | Stock | 3.1032 | 3.1071 | 3.0964 | 3.0964 | 79800.0 |
| 2006-12-20 08:00:00 | AAPL | Stock | 3.0971 | 3.0979 | 3.0925 | 3.0925 | 1057084.0 |
| 2006-12-20 08:30:00 | AAPL | Stock | 3.0918 | 3.0971 | 3.0864 | 3.0918 | 1069740.0 |
| 2006-12-20 09:00:00 | AAPL | Stock | 3.0918 | 3.0943 | 3.0857 | 3.0893 | 781816.0 |
| 2006-12-20 09:30:00 | AAPL | Stock | 3.0879 | 3.0954 | 3.0629 | 3.0843 | 83053628.0 |
| 2006-12-20 10:00:00 | AAPL | Stock | 3.0843 | 3.0939 | 3.0679 | 3.0721 | 61327392.0 |
| 2006-12-20 10:30:00 | AAPL | Stock | 3.0721 | 3.0804 | 3.0621 | 3.0679 | 45558996.0 |
| 2006-12-20 11:00:00 | AAPL | Stock | 3.0679 | 3.0714 | 3.0529 | 3.0571 | 41791680.0 |
| 2006-12-20 11:30:00 | AAPL | Stock | 3.0571 | 3.0746 | 3.0546 | 3.07 | 33167540.0 |
| 2006-12-20 12:00:00 | AAPL | Stock | 3.07 | 3.0743 | 3.0657 | 3.0693 | 16858660.0 |
| 2006-12-20 12:30:00 | AAPL | Stock | 3.0689 | 3.0729 | 3.06 | 3.0704 | 17817940.0 |
| 2006-12-20 13:00:00 | AAPL | Stock | 3.0707 | 3.0732 | 3.0518 | 3.0543 | 36418592.0 |
| 2006-12-20 13:30:00 | AAPL | Stock | 3.0539 | 3.0542 | 3.0343 | 3.0493 | 53737432.0 |
| 2006-12-20 14:00:00 | AAPL | Stock | 3.0489 | 3.0611 | 3.0457 | 3.0536 | 27717620.0 |
| 2006-12-20 14:30:00 | AAPL | Stock | 3.0536 | 3.0596 | 3.0432 | 3.0446 | 32720940.0 |
| 2006-12-20 15:00:00 | AAPL | Stock | 3.045 | 3.0539 | 3.0404 | 3.0504 | 36390396.0 |
| 2006-12-20 15:30:00 | AAPL | Stock | 3.0507 | 3.0507 | 3.0264 | 3.0279 | 63233464.0 |
| 2006-12-20 16:00:00 | AAPL | Stock | 3.0275 | 3.0354 | 3.0269 | 3.0286 | 1318268.0 |
| 2006-12-20 16:30:00 | AAPL | Stock | 3.0286 | 3.03 | 3.0271 | 3.0279 | 392000.0 |
| 2006-12-20 17:00:00 | AAPL | Stock | 3.0271 | 3.0286 | 3.0268 | 3.0282 | 174300.0 |
| 2006-12-20 17:30:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0268 | 3.0286 | 152656.0 |
| 2006-12-20 18:00:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0271 | 3.0271 | 100240.0 |
| 2006-12-20 18:30:00 | AAPL | Stock | 3.0275 | 3.0279 | 3.0271 | 3.0271 | 28392.0 |
| 2006-12-20 19:00:00 | AAPL | Stock | 3.0279 | 3.0286 | 3.0271 | 3.0286 | 113960.0 |
| 2006-12-20 19:30:00 | AAPL | Stock | 3.0275 | 3.0286 | 3.0271 | 3.0286 | 129528.0 |
| 2006-12-20 08:00:00 | MSFT | Stock | 29.96 | 29.99 | 29.96 | 29.99 | 3900.0 |
| 2006-12-20 08:30:00 | MSFT | Stock | 29.99 | 29.99 | 29.98 | 29.98 | 1100.0 |
| 2006-12-20 09:00:00 | MSFT | Stock | 29.98 | 30.01 | 29.97 | 30.01 | 45025.0 |
| 2006-12-20 09:30:00 | MSFT | Stock | 29.99 | 30.24 | 29.97 | 30.18 | 4910263.0 |
| 2006-12-20 10:00:00 | MSFT | Stock | 30.19 | 30.21 | 29.99 | 30.11 | 3460358.0 |
| 2006-12-20 10:30:00 | MSFT | Stock | 30.11 | 30.18 | 30.11 | 30.12 | 1334594.0 |
| 2006-12-20 11:00:00 | MSFT | Stock | 30.12 | 30.14 | 30.05 | 30.07 | 1711667.0 |
| 2006-12-20 11:30:00 | MSFT | Stock | 30.06 | 30.14 | 30.05 | 30.11 | 1510852.0 |
| 2006-12-20 12:00:00 | MSFT | Stock | 30.11 | 30.12 | 30.05 | 30.05 | 900934.0 |
| 2006-12-20 12:30:00 | MSFT | Stock | 30.05 | 30.1 | 30.0 | 30.1 | 1429458.0 |
| 2006-12-20 13:00:00 | MSFT | Stock | 30.1 | 30.1 | 30.0 | 30.05 | 1441474.0 |
| 2006-12-20 13:30:00 | MSFT | Stock | 30.05 | 30.06 | 29.97 | 30.023 | 1429298.0 |
| 2006-12-20 14:00:00 | MSFT | Stock | 30.02 | 30.14 | 30.02 | 30.09 | 1587197.0 |
| 2006-12-20 14:30:00 | MSFT | Stock | 30.09 | 30.13 | 30.05 | 30.06 | 2124077.0 |
| 2006-12-20 15:00:00 | MSFT | Stock | 30.05 | 30.14 | 30.05 | 30.08 | 2894772.0 |
| 2006-12-20 15:30:00 | MSFT | Stock | 30.08 | 30.14 | 30.05 | 30.1 | 4549323.0 |
| 2006-12-20 16:00:00 | MSFT | Stock | 30.1 | 30.22 | 30.05 | 30.08 | 159301.0 |
| 2006-12-20 16:30:00 | MSFT | Stock | 30.07 | 30.07 | 30.05 | 30.05 | 2697.0 |
| 2006-12-20 17:00:00 | MSFT | Stock | 30.07 | 30.08 | 30.04 | 30.04 | 8583.0 |
| 2006-12-20 19:30:00 | MSFT | Stock | 30.09 | 30.09 | 30.09 | 30.09 | 100.0 |
| 2006-12-20 08:00:00 | NVDA | Stock | 0.643 | 0.643 | 0.643 | 0.643 | 30000.0 |
| 2006-12-20 08:30:00 | NVDA | Stock | 0.6475 | 0.6475 | 0.6475 | 0.6475 | 24000.0 |
| 2006-12-20 09:00:00 | NVDA | Stock | 0.645 | 0.6458 | 0.6427 | 0.6427 | 296820.0 |
| 2006-12-20 09:30:00 | NVDA | Stock | 0.6417 | 0.6493 | 0.6413 | 0.6482 | 38926380.0 |
> showing 50 of 53,174 rows — these rows as CSV