PREVIEW / stock_30min / 2008-12-22
file: by_date/stock_30min/2008/2008-12-22.parquet size: 1.3 MB rows: 69,934 symbols: 3,376
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-12-22 06:30:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 7000.0 |
| 2008-12-22 07:00:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2175 | 3.2175 | 32480.0 |
| 2008-12-22 07:30:00 | AAPL | Stock | 3.2321 | 3.2393 | 3.2321 | 3.2393 | 16800.0 |
| 2008-12-22 08:00:00 | AAPL | Stock | 3.2232 | 3.2314 | 3.2179 | 3.2286 | 617064.0 |
| 2008-12-22 08:30:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2182 | 3.2214 | 950656.0 |
| 2008-12-22 09:00:00 | AAPL | Stock | 3.2229 | 3.2229 | 3.2125 | 3.2132 | 1333976.0 |
| 2008-12-22 09:30:00 | AAPL | Stock | 3.215 | 3.2154 | 3.1161 | 3.1204 | 108570056.0 |
| 2008-12-22 10:00:00 | AAPL | Stock | 3.1206 | 3.1214 | 3.0804 | 3.0961 | 99474648.0 |
| 2008-12-22 10:30:00 | AAPL | Stock | 3.0961 | 3.125 | 3.09 | 3.1196 | 56536564.0 |
| 2008-12-22 11:00:00 | AAPL | Stock | 3.1196 | 3.1232 | 3.0893 | 3.095 | 44969540.0 |
| 2008-12-22 11:30:00 | AAPL | Stock | 3.095 | 3.0961 | 3.0493 | 3.0736 | 67205404.0 |
| 2008-12-22 12:00:00 | AAPL | Stock | 3.0732 | 3.0984 | 3.0536 | 3.0589 | 32339160.0 |
| 2008-12-22 12:30:00 | AAPL | Stock | 3.0589 | 3.0721 | 3.0546 | 3.0683 | 30815596.0 |
| 2008-12-22 13:00:00 | AAPL | Stock | 3.0683 | 3.075 | 3.0604 | 3.0654 | 34070456.0 |
| 2008-12-22 13:30:00 | AAPL | Stock | 3.0654 | 3.0686 | 3.0439 | 3.0502 | 38320352.0 |
| 2008-12-22 14:00:00 | AAPL | Stock | 3.05 | 3.0636 | 3.0389 | 3.0421 | 42181468.0 |
| 2008-12-22 14:30:00 | AAPL | Stock | 3.0425 | 3.0464 | 3.0357 | 3.0368 | 56039732.0 |
| 2008-12-22 15:00:00 | AAPL | Stock | 3.0368 | 3.0575 | 3.0246 | 3.0314 | 80789940.0 |
| 2008-12-22 15:30:00 | AAPL | Stock | 3.0318 | 3.1179 | 3.0307 | 3.0632 | 112872396.0 |
| 2008-12-22 16:00:00 | AAPL | Stock | 3.0632 | 3.0801 | 3.0571 | 3.0654 | 29059828.0 |
| 2008-12-22 16:30:00 | AAPL | Stock | 3.0654 | 3.0785 | 3.0516 | 3.0679 | 535388.0 |
| 2008-12-22 17:00:00 | AAPL | Stock | 3.0671 | 3.075 | 3.0607 | 3.0714 | 315588.0 |
| 2008-12-22 17:30:00 | AAPL | Stock | 3.0721 | 3.0721 | 3.0625 | 3.0625 | 131600.0 |
| 2008-12-22 18:00:00 | AAPL | Stock | 3.0661 | 3.0693 | 3.0646 | 3.0646 | 56000.0 |
| 2008-12-22 18:30:00 | AAPL | Stock | 3.0646 | 3.0714 | 3.0646 | 3.07 | 149268.0 |
| 2008-12-22 19:00:00 | AAPL | Stock | 3.0714 | 3.0736 | 3.07 | 3.0736 | 87696.0 |
| 2008-12-22 19:30:00 | AAPL | Stock | 3.0736 | 3.0739 | 3.07 | 3.0739 | 83048.0 |
| 2008-12-22 04:30:00 | MSFT | Stock | 19.24 | 19.24 | 19.24 | 19.24 | 150.0 |
| 2008-12-22 05:00:00 | MSFT | Stock | 19.25 | 19.25 | 19.25 | 19.25 | 150.0 |
| 2008-12-22 07:30:00 | MSFT | Stock | 19.25 | 19.25 | 19.25 | 19.25 | 100.0 |
| 2008-12-22 08:00:00 | MSFT | Stock | 19.2 | 19.25 | 19.2 | 19.22 | 19413.0 |
| 2008-12-22 08:30:00 | MSFT | Stock | 19.22 | 19.26 | 19.2 | 19.22 | 10094.0 |
| 2008-12-22 09:00:00 | MSFT | Stock | 19.2 | 19.27 | 19.12 | 19.25 | 65259.0 |
| 2008-12-22 09:30:00 | MSFT | Stock | 19.25 | 19.29 | 18.91 | 19.08 | 6064492.0 |
| 2008-12-22 10:00:00 | MSFT | Stock | 19.07 | 19.16 | 19.01 | 19.15 | 3494320.0 |
| 2008-12-22 10:30:00 | MSFT | Stock | 19.15 | 19.27 | 19.13 | 19.23 | 3969854.0 |
| 2008-12-22 11:00:00 | MSFT | Stock | 19.23 | 19.24 | 19.16 | 19.23 | 2675395.0 |
| 2008-12-22 11:30:00 | MSFT | Stock | 19.22 | 19.25 | 19.09 | 19.25 | 3901074.0 |
| 2008-12-22 12:00:00 | MSFT | Stock | 19.24 | 19.25 | 19.1 | 19.1 | 2702371.0 |
| 2008-12-22 12:30:00 | MSFT | Stock | 19.1 | 19.16 | 19.07 | 19.099 | 2174765.0 |
| 2008-12-22 13:00:00 | MSFT | Stock | 19.099 | 19.18 | 19.08 | 19.162 | 3384596.0 |
| 2008-12-22 13:30:00 | MSFT | Stock | 19.165 | 19.17 | 19.01 | 19.045 | 4057522.0 |
| 2008-12-22 14:00:00 | MSFT | Stock | 19.04 | 19.1 | 18.91 | 18.95 | 3281069.0 |
| 2008-12-22 14:30:00 | MSFT | Stock | 18.95 | 19.04 | 18.9 | 18.97 | 3986645.0 |
| 2008-12-22 15:00:00 | MSFT | Stock | 18.97 | 19.01 | 18.89 | 18.91 | 4874678.0 |
| 2008-12-22 15:30:00 | MSFT | Stock | 18.91 | 19.24 | 18.89 | 19.2 | 8413547.0 |
| 2008-12-22 16:00:00 | MSFT | Stock | 19.2 | 19.24 | 18.91 | 19.17 | 4303374.0 |
| 2008-12-22 16:30:00 | MSFT | Stock | 19.2 | 19.23 | 19.017 | 19.17 | 91248.0 |
| 2008-12-22 17:00:00 | MSFT | Stock | 19.17 | 19.17 | 19.17 | 19.17 | 4800.0 |
| 2008-12-22 17:30:00 | MSFT | Stock | 19.17 | 19.2 | 19.17 | 19.2 | 10800.0 |
> showing 50 of 69,934 rows — these rows as CSV