PREVIEW / stock_30min / 2008-08-05
file: by_date/stock_30min/2008/2008-08-05.parquet size: 1.3 MB rows: 69,064 symbols: 3,316
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-05 07:00:00 | AAPL | Stock | 5.5586 | 5.5589 | 5.5357 | 5.5589 | 156660.0 |
| 2008-08-05 07:30:00 | AAPL | Stock | 5.5625 | 5.5796 | 5.5446 | 5.5511 | 307720.0 |
| 2008-08-05 08:00:00 | AAPL | Stock | 5.5504 | 5.5625 | 5.5314 | 5.5364 | 1575168.0 |
| 2008-08-05 08:30:00 | AAPL | Stock | 5.5364 | 5.5536 | 5.5304 | 5.5536 | 1272348.0 |
| 2008-08-05 09:00:00 | AAPL | Stock | 5.5529 | 5.5689 | 5.5429 | 5.5518 | 2840516.0 |
| 2008-08-05 09:30:00 | AAPL | Stock | 5.5511 | 5.5861 | 5.5293 | 5.5704 | 96791324.0 |
| 2008-08-05 10:00:00 | AAPL | Stock | 5.5714 | 5.5964 | 5.5686 | 5.585 | 57859956.0 |
| 2008-08-05 10:30:00 | AAPL | Stock | 5.585 | 5.6036 | 5.5729 | 5.6029 | 39939732.0 |
| 2008-08-05 11:00:00 | AAPL | Stock | 5.6029 | 5.6346 | 5.5964 | 5.6275 | 44241540.0 |
| 2008-08-05 11:30:00 | AAPL | Stock | 5.6275 | 5.6386 | 5.6196 | 5.6336 | 33717544.0 |
| 2008-08-05 12:00:00 | AAPL | Stock | 5.6336 | 5.6343 | 5.6121 | 5.6186 | 27572496.0 |
| 2008-08-05 12:30:00 | AAPL | Stock | 5.6182 | 5.6304 | 5.615 | 5.6243 | 22116836.0 |
| 2008-08-05 13:00:00 | AAPL | Stock | 5.6243 | 5.6325 | 5.6207 | 5.6304 | 18965324.0 |
| 2008-08-05 13:30:00 | AAPL | Stock | 5.6296 | 5.6418 | 5.6275 | 5.636 | 28499744.0 |
| 2008-08-05 14:00:00 | AAPL | Stock | 5.6371 | 5.6786 | 5.625 | 5.6686 | 71979488.0 |
| 2008-08-05 14:30:00 | AAPL | Stock | 5.6679 | 5.7089 | 5.6646 | 5.6989 | 68883528.0 |
| 2008-08-05 15:00:00 | AAPL | Stock | 5.6989 | 5.7114 | 5.6679 | 5.6904 | 55522684.0 |
| 2008-08-05 15:30:00 | AAPL | Stock | 5.6907 | 5.7429 | 5.6786 | 5.7339 | 89696208.0 |
| 2008-08-05 16:00:00 | AAPL | Stock | 5.7339 | 5.7429 | 5.6371 | 5.7354 | 15188376.0 |
| 2008-08-05 16:30:00 | AAPL | Stock | 5.7357 | 5.7571 | 5.6392 | 5.75 | 8259132.0 |
| 2008-08-05 17:00:00 | AAPL | Stock | 5.75 | 5.7671 | 5.7421 | 5.7589 | 413336.0 |
| 2008-08-05 17:30:00 | AAPL | Stock | 5.7579 | 5.7632 | 5.7464 | 5.7582 | 383656.0 |
| 2008-08-05 18:00:00 | AAPL | Stock | 5.7536 | 5.7536 | 5.75 | 5.75 | 218456.0 |
| 2008-08-05 18:30:00 | AAPL | Stock | 5.75 | 5.7514 | 5.7471 | 5.7482 | 91812.0 |
| 2008-08-05 19:00:00 | AAPL | Stock | 5.7479 | 5.7511 | 5.7471 | 5.7489 | 50064.0 |
| 2008-08-05 19:30:00 | AAPL | Stock | 5.75 | 5.75 | 5.7471 | 5.7471 | 135968.0 |
| 2008-08-05 07:00:00 | MSFT | Stock | 25.59 | 25.59 | 25.59 | 25.59 | 100.0 |
| 2008-08-05 07:30:00 | MSFT | Stock | 25.39 | 25.53 | 25.39 | 25.52 | 700.0 |
| 2008-08-05 08:00:00 | MSFT | Stock | 25.28 | 25.5 | 25.28 | 25.48 | 47454.0 |
| 2008-08-05 08:30:00 | MSFT | Stock | 25.49 | 25.5 | 25.49 | 25.5 | 24467.0 |
| 2008-08-05 09:00:00 | MSFT | Stock | 25.5 | 25.69 | 25.42 | 25.66 | 84940.0 |
| 2008-08-05 09:30:00 | MSFT | Stock | 25.65 | 25.69 | 25.5 | 25.63 | 5181069.0 |
| 2008-08-05 10:00:00 | MSFT | Stock | 25.63 | 25.74 | 25.6 | 25.72 | 5200851.0 |
| 2008-08-05 10:30:00 | MSFT | Stock | 25.72 | 25.75 | 25.6 | 25.72 | 6283948.0 |
| 2008-08-05 11:00:00 | MSFT | Stock | 25.72 | 25.9 | 25.71 | 25.87 | 6232367.0 |
| 2008-08-05 11:30:00 | MSFT | Stock | 25.872 | 25.99 | 25.85 | 25.94 | 5873692.0 |
| 2008-08-05 12:00:00 | MSFT | Stock | 25.94 | 26.05 | 25.84 | 25.99 | 5169090.0 |
| 2008-08-05 12:30:00 | MSFT | Stock | 25.99 | 26.11 | 25.92 | 26.1 | 4905966.0 |
| 2008-08-05 13:00:00 | MSFT | Stock | 26.09 | 26.12 | 25.92 | 25.99 | 3608955.0 |
| 2008-08-05 13:30:00 | MSFT | Stock | 26.0 | 26.05 | 25.9 | 25.9 | 4287737.0 |
| 2008-08-05 14:00:00 | MSFT | Stock | 25.91 | 26.18 | 25.86 | 26.06 | 6870402.0 |
| 2008-08-05 14:30:00 | MSFT | Stock | 26.06 | 26.24 | 26.05 | 26.12 | 4915785.0 |
| 2008-08-05 15:00:00 | MSFT | Stock | 26.12 | 26.23 | 26.09 | 26.13 | 4546256.0 |
| 2008-08-05 15:30:00 | MSFT | Stock | 26.12 | 26.28 | 26.07 | 26.19 | 10606283.0 |
| 2008-08-05 16:00:00 | MSFT | Stock | 26.21 | 26.22 | 25.932 | 26.18 | 6154122.0 |
| 2008-08-05 16:30:00 | MSFT | Stock | 26.14 | 26.21 | 26.14 | 26.21 | 47836.0 |
| 2008-08-05 17:00:00 | MSFT | Stock | 26.2 | 26.3 | 26.2 | 26.25 | 65219.0 |
| 2008-08-05 17:30:00 | MSFT | Stock | 26.25 | 26.32 | 26.25 | 26.31 | 6650.0 |
| 2008-08-05 18:00:00 | MSFT | Stock | 26.28 | 26.28 | 26.27 | 26.27 | 4700.0 |
| 2008-08-05 18:30:00 | MSFT | Stock | 26.27 | 26.28 | 26.27 | 26.28 | 700.0 |
> showing 50 of 69,064 rows — these rows as CSV