PREVIEW / stock_30min / 2008-05-08
file: by_date/stock_30min/2008/2008-05-08.parquet size: 1.3 MB rows: 68,847 symbols: 3,275
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-05-08 07:00:00 | AAPL | Stock | 6.5125 | 6.6071 | 6.5125 | 6.5643 | 207956.0 |
| 2008-05-08 07:30:00 | AAPL | Stock | 6.5643 | 6.5964 | 6.5639 | 6.5718 | 932680.0 |
| 2008-05-08 08:00:00 | AAPL | Stock | 6.57 | 6.5804 | 6.5643 | 6.5775 | 2194192.0 |
| 2008-05-08 08:30:00 | AAPL | Stock | 6.5786 | 6.5846 | 6.5393 | 6.5432 | 5133604.0 |
| 2008-05-08 09:00:00 | AAPL | Stock | 6.5436 | 6.5686 | 6.5432 | 6.5629 | 3068576.0 |
| 2008-05-08 09:30:00 | AAPL | Stock | 6.5632 | 6.6089 | 6.5382 | 6.59 | 127832432.0 |
| 2008-05-08 10:00:00 | AAPL | Stock | 6.5896 | 6.6036 | 6.5489 | 6.6036 | 111087340.0 |
| 2008-05-08 10:30:00 | AAPL | Stock | 6.6036 | 6.6061 | 6.5518 | 6.5761 | 73662148.0 |
| 2008-05-08 11:00:00 | AAPL | Stock | 6.5759 | 6.6271 | 6.5754 | 6.6214 | 83251280.0 |
| 2008-05-08 11:30:00 | AAPL | Stock | 6.6204 | 6.6279 | 6.6011 | 6.61 | 54714632.0 |
| 2008-05-08 12:00:00 | AAPL | Stock | 6.61 | 6.6254 | 6.605 | 6.6064 | 35659792.0 |
| 2008-05-08 12:30:00 | AAPL | Stock | 6.6061 | 6.6118 | 6.5771 | 6.5996 | 37396548.0 |
| 2008-05-08 13:00:00 | AAPL | Stock | 6.5996 | 6.6418 | 6.5961 | 6.63 | 44355164.0 |
| 2008-05-08 13:30:00 | AAPL | Stock | 6.6304 | 6.6607 | 6.6296 | 6.6529 | 59772664.0 |
| 2008-05-08 14:00:00 | AAPL | Stock | 6.6529 | 6.6571 | 6.6071 | 6.6114 | 49786240.0 |
| 2008-05-08 14:30:00 | AAPL | Stock | 6.6114 | 6.625 | 6.5832 | 6.6039 | 55353088.0 |
| 2008-05-08 15:00:00 | AAPL | Stock | 6.6036 | 6.6225 | 6.5714 | 6.585 | 53385584.0 |
| 2008-05-08 15:30:00 | AAPL | Stock | 6.5846 | 6.6214 | 6.5821 | 6.6064 | 66721340.0 |
| 2008-05-08 16:00:00 | AAPL | Stock | 6.6068 | 6.6096 | 6.5896 | 6.5986 | 21917140.0 |
| 2008-05-08 16:30:00 | AAPL | Stock | 6.5979 | 6.6018 | 6.5946 | 6.5954 | 351596.0 |
| 2008-05-08 17:00:00 | AAPL | Stock | 6.595 | 6.5964 | 6.5896 | 6.5939 | 266868.0 |
| 2008-05-08 17:30:00 | AAPL | Stock | 6.5943 | 6.6271 | 6.5939 | 6.5982 | 109676.0 |
| 2008-05-08 18:00:00 | AAPL | Stock | 6.5982 | 6.5982 | 6.5929 | 6.5929 | 165312.0 |
| 2008-05-08 18:30:00 | AAPL | Stock | 6.5914 | 6.5943 | 6.5904 | 6.5929 | 119280.0 |
| 2008-05-08 19:00:00 | AAPL | Stock | 6.5943 | 6.5982 | 6.5921 | 6.5979 | 198436.0 |
| 2008-05-08 19:30:00 | AAPL | Stock | 6.5979 | 6.5993 | 6.5929 | 6.5954 | 151788.0 |
| 2008-05-08 07:30:00 | MSFT | Stock | 29.24 | 29.39 | 29.23 | 29.39 | 3518.0 |
| 2008-05-08 08:00:00 | MSFT | Stock | 29.35 | 29.39 | 29.3 | 29.39 | 18229.0 |
| 2008-05-08 08:30:00 | MSFT | Stock | 29.39 | 29.39 | 29.35 | 29.35 | 18573.0 |
| 2008-05-08 09:00:00 | MSFT | Stock | 29.36 | 29.37 | 29.16 | 29.26 | 544295.0 |
| 2008-05-08 09:30:00 | MSFT | Stock | 29.27 | 29.39 | 29.11 | 29.3 | 8490594.0 |
| 2008-05-08 10:00:00 | MSFT | Stock | 29.3 | 29.33 | 29.22 | 29.33 | 4767427.0 |
| 2008-05-08 10:30:00 | MSFT | Stock | 29.33 | 29.35 | 29.2 | 29.25 | 4902593.0 |
| 2008-05-08 11:00:00 | MSFT | Stock | 29.252 | 29.27 | 29.18 | 29.2 | 5844636.0 |
| 2008-05-08 11:30:00 | MSFT | Stock | 29.19 | 29.21 | 29.0 | 29.05 | 5071327.0 |
| 2008-05-08 12:00:00 | MSFT | Stock | 29.06 | 29.15 | 29.01 | 29.04 | 2331876.0 |
| 2008-05-08 12:30:00 | MSFT | Stock | 29.03 | 29.18 | 29.03 | 29.16 | 2533399.0 |
| 2008-05-08 13:00:00 | MSFT | Stock | 29.16 | 29.3 | 29.13 | 29.238 | 3088785.0 |
| 2008-05-08 13:30:00 | MSFT | Stock | 29.24 | 29.34 | 29.21 | 29.338 | 3739124.0 |
| 2008-05-08 14:00:00 | MSFT | Stock | 29.33 | 29.35 | 29.045 | 29.25 | 4949562.0 |
| 2008-05-08 14:30:00 | MSFT | Stock | 29.25 | 29.32 | 29.19 | 29.23 | 5208489.0 |
| 2008-05-08 15:00:00 | MSFT | Stock | 29.22 | 29.305 | 29.19 | 29.25 | 7818518.0 |
| 2008-05-08 15:30:00 | MSFT | Stock | 29.24 | 29.32 | 29.21 | 29.24 | 6561394.0 |
| 2008-05-08 16:00:00 | MSFT | Stock | 29.24 | 29.33 | 29.2 | 29.2 | 2390833.0 |
| 2008-05-08 16:30:00 | MSFT | Stock | 29.2 | 29.27 | 29.2 | 29.212 | 32284.0 |
| 2008-05-08 17:00:00 | MSFT | Stock | 29.22 | 29.24 | 29.17 | 29.24 | 3600.0 |
| 2008-05-08 17:30:00 | MSFT | Stock | 29.2 | 29.2 | 29.19 | 29.198 | 4193.0 |
| 2008-05-08 18:00:00 | MSFT | Stock | 29.19 | 29.19 | 29.19 | 29.19 | 201.0 |
| 2008-05-08 18:30:00 | MSFT | Stock | 29.25 | 29.25 | 29.25 | 29.25 | 1000.0 |
| 2008-05-08 19:00:00 | MSFT | Stock | 29.22 | 29.22 | 29.2 | 29.2 | 698.0 |
> showing 50 of 68,847 rows — these rows as CSV