PREVIEW / stock_30min / 2008-10-30
file: by_date/stock_30min/2008/2008-10-30.parquet size: 1.2 MB rows: 72,487 symbols: 3,338
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-10-30 04:30:00 | AAPL | Stock | 3.8214 | 3.8214 | 3.8214 | 3.8214 | 2800.0 |
| 2008-10-30 06:00:00 | AAPL | Stock | 3.8564 | 3.8571 | 3.8564 | 3.8571 | 16800.0 |
| 2008-10-30 06:30:00 | AAPL | Stock | 3.8571 | 3.8571 | 3.8571 | 3.8571 | 8400.0 |
| 2008-10-30 07:00:00 | AAPL | Stock | 3.8571 | 3.875 | 3.8286 | 3.8482 | 166208.0 |
| 2008-10-30 07:30:00 | AAPL | Stock | 3.8407 | 3.8571 | 3.8393 | 3.8571 | 321580.0 |
| 2008-10-30 08:00:00 | AAPL | Stock | 3.8571 | 3.8714 | 3.8321 | 3.8343 | 2585156.0 |
| 2008-10-30 08:30:00 | AAPL | Stock | 3.8339 | 3.8729 | 3.8318 | 3.8496 | 2872520.0 |
| 2008-10-30 09:00:00 | AAPL | Stock | 3.85 | 3.8796 | 3.8496 | 3.8632 | 4230828.0 |
| 2008-10-30 09:30:00 | AAPL | Stock | 3.8664 | 3.9357 | 3.8432 | 3.9093 | 205147824.0 |
| 2008-10-30 10:00:00 | AAPL | Stock | 3.91 | 3.9432 | 3.8857 | 3.8907 | 163754276.0 |
| 2008-10-30 10:30:00 | AAPL | Stock | 3.89 | 3.9207 | 3.8693 | 3.8986 | 145940004.0 |
| 2008-10-30 11:00:00 | AAPL | Stock | 3.8993 | 3.9464 | 3.8979 | 3.9193 | 110358472.0 |
| 2008-10-30 11:30:00 | AAPL | Stock | 3.9193 | 3.9286 | 3.8804 | 3.8954 | 106845844.0 |
| 2008-10-30 12:00:00 | AAPL | Stock | 3.8957 | 3.9454 | 3.8929 | 3.9346 | 97905304.0 |
| 2008-10-30 12:30:00 | AAPL | Stock | 3.9346 | 3.9571 | 3.9179 | 3.9186 | 93185848.0 |
| 2008-10-30 13:00:00 | AAPL | Stock | 3.9189 | 3.9729 | 3.9107 | 3.9504 | 81984112.0 |
| 2008-10-30 13:30:00 | AAPL | Stock | 3.9507 | 3.9893 | 3.9393 | 3.9786 | 87712408.0 |
| 2008-10-30 14:00:00 | AAPL | Stock | 3.9789 | 4.0068 | 3.9725 | 3.9868 | 108272136.0 |
| 2008-10-30 14:30:00 | AAPL | Stock | 3.9854 | 3.9996 | 3.9693 | 3.9871 | 102416944.0 |
| 2008-10-30 15:00:00 | AAPL | Stock | 3.9871 | 4.0043 | 3.9286 | 3.9611 | 144480112.0 |
| 2008-10-30 15:30:00 | AAPL | Stock | 3.9617 | 3.985 | 3.9114 | 3.9661 | 158061120.0 |
| 2008-10-30 16:00:00 | AAPL | Stock | 3.9707 | 3.9761 | 3.7543 | 3.9711 | 13361936.0 |
| 2008-10-30 16:30:00 | AAPL | Stock | 3.9704 | 3.9875 | 3.9356 | 3.9736 | 1384880.0 |
| 2008-10-30 17:00:00 | AAPL | Stock | 3.9746 | 3.9821 | 3.9657 | 3.975 | 785204.0 |
| 2008-10-30 17:30:00 | AAPL | Stock | 3.9793 | 3.9821 | 3.9771 | 3.9821 | 267204.0 |
| 2008-10-30 18:00:00 | AAPL | Stock | 3.9786 | 3.9857 | 3.9657 | 3.9832 | 472696.0 |
| 2008-10-30 18:30:00 | AAPL | Stock | 3.9818 | 3.9875 | 3.9786 | 3.9786 | 218232.0 |
| 2008-10-30 19:00:00 | AAPL | Stock | 3.9775 | 3.9786 | 3.9768 | 3.9768 | 97524.0 |
| 2008-10-30 19:30:00 | AAPL | Stock | 3.9761 | 3.9761 | 3.9639 | 3.9639 | 414932.0 |
| 2008-10-30 07:00:00 | MSFT | Stock | 23.6 | 23.6 | 23.6 | 23.6 | 280.0 |
| 2008-10-30 07:30:00 | MSFT | Stock | 23.51 | 23.51 | 23.5 | 23.5 | 820.0 |
| 2008-10-30 08:00:00 | MSFT | Stock | 23.57 | 23.69 | 23.47 | 23.47 | 25221.0 |
| 2008-10-30 08:30:00 | MSFT | Stock | 23.53 | 23.69 | 23.53 | 23.68 | 26095.0 |
| 2008-10-30 09:00:00 | MSFT | Stock | 23.68 | 23.74 | 23.56 | 23.69 | 96474.0 |
| 2008-10-30 09:30:00 | MSFT | Stock | 23.68 | 23.88 | 23.55 | 23.64 | 8586318.0 |
| 2008-10-30 10:00:00 | MSFT | Stock | 23.63 | 23.75 | 23.25 | 23.25 | 5972890.0 |
| 2008-10-30 10:30:00 | MSFT | Stock | 23.25 | 23.34 | 23.08 | 23.17 | 6367672.0 |
| 2008-10-30 11:00:00 | MSFT | Stock | 23.16 | 23.42 | 23.03 | 23.1 | 6110388.0 |
| 2008-10-30 11:30:00 | MSFT | Stock | 23.104 | 23.17 | 22.69 | 22.848 | 5988136.0 |
| 2008-10-30 12:00:00 | MSFT | Stock | 22.84 | 23.04 | 22.8 | 22.88 | 4032992.0 |
| 2008-10-30 12:30:00 | MSFT | Stock | 22.88 | 23.08 | 22.83 | 22.95 | 3262370.0 |
| 2008-10-30 13:00:00 | MSFT | Stock | 22.958 | 23.26 | 22.9 | 23.04 | 5015519.0 |
| 2008-10-30 13:30:00 | MSFT | Stock | 23.04 | 23.2 | 22.98 | 23.08 | 3422985.0 |
| 2008-10-30 14:00:00 | MSFT | Stock | 23.08 | 23.28 | 23.05 | 23.17 | 4722974.0 |
| 2008-10-30 14:30:00 | MSFT | Stock | 23.17 | 23.33 | 23.09 | 23.19 | 5683834.0 |
| 2008-10-30 15:00:00 | MSFT | Stock | 23.19 | 23.41 | 22.82 | 23.01 | 9847035.0 |
| 2008-10-30 15:30:00 | MSFT | Stock | 23.0 | 23.04 | 22.39 | 22.63 | 20207973.0 |
| 2008-10-30 16:00:00 | MSFT | Stock | 22.68 | 23.715 | 22.629 | 22.7 | 3638358.0 |
| 2008-10-30 16:30:00 | MSFT | Stock | 22.77 | 22.978 | 22.63 | 22.75 | 13444.0 |
| 2008-10-30 17:00:00 | MSFT | Stock | 22.63 | 22.79 | 22.63 | 22.77 | 112324.0 |
> showing 50 of 72,487 rows — these rows as CSV