PREVIEW / stock_30min / 2009-09-03
file: by_date/stock_30min/2009/2009-09-03.parquet size: 1.3 MB rows: 70,704 symbols: 3,358
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-03 07:00:00 | AAPL | Stock | 5.9464 | 5.9796 | 5.9464 | 5.9793 | 51828.0 |
| 2009-09-03 07:30:00 | AAPL | Stock | 5.975 | 5.9825 | 5.9682 | 5.9711 | 240996.0 |
| 2009-09-03 08:00:00 | AAPL | Stock | 5.9664 | 5.9818 | 5.965 | 5.97 | 658448.0 |
| 2009-09-03 08:30:00 | AAPL | Stock | 5.9675 | 5.9686 | 5.9504 | 5.9614 | 627480.0 |
| 2009-09-03 09:00:00 | AAPL | Stock | 5.9571 | 5.9732 | 5.9418 | 5.9504 | 1279572.0 |
| 2009-09-03 09:30:00 | AAPL | Stock | 5.9443 | 5.9564 | 5.9121 | 5.9175 | 55841632.0 |
| 2009-09-03 10:00:00 | AAPL | Stock | 5.9161 | 5.9271 | 5.8929 | 5.9161 | 38712996.0 |
| 2009-09-03 10:30:00 | AAPL | Stock | 5.9157 | 5.9321 | 5.9066 | 5.9302 | 20712580.0 |
| 2009-09-03 11:00:00 | AAPL | Stock | 5.9293 | 5.955 | 5.9293 | 5.9429 | 19787572.0 |
| 2009-09-03 11:30:00 | AAPL | Stock | 5.9429 | 5.9603 | 5.9418 | 5.9564 | 18191712.0 |
| 2009-09-03 12:00:00 | AAPL | Stock | 5.9564 | 5.9679 | 5.9543 | 5.9571 | 13215412.0 |
| 2009-09-03 12:30:00 | AAPL | Stock | 5.9575 | 5.9582 | 5.9414 | 5.9457 | 11319700.0 |
| 2009-09-03 13:00:00 | AAPL | Stock | 5.9461 | 5.9596 | 5.9446 | 5.9586 | 13288268.0 |
| 2009-09-03 13:30:00 | AAPL | Stock | 5.9584 | 5.9632 | 5.94 | 5.9439 | 12188316.0 |
| 2009-09-03 14:00:00 | AAPL | Stock | 5.9443 | 5.9482 | 5.9293 | 5.9371 | 12501972.0 |
| 2009-09-03 14:30:00 | AAPL | Stock | 5.9375 | 5.9414 | 5.9229 | 5.9357 | 11681236.0 |
| 2009-09-03 15:00:00 | AAPL | Stock | 5.9364 | 5.9404 | 5.9268 | 5.9367 | 14020216.0 |
| 2009-09-03 15:30:00 | AAPL | Stock | 5.9368 | 5.9589 | 5.935 | 5.9482 | 31598140.0 |
| 2009-09-03 16:00:00 | AAPL | Stock | 5.9479 | 5.954 | 5.9359 | 5.9525 | 12028856.0 |
| 2009-09-03 16:30:00 | AAPL | Stock | 5.9504 | 5.9543 | 5.9475 | 5.9518 | 95424.0 |
| 2009-09-03 17:00:00 | AAPL | Stock | 5.9543 | 5.9643 | 5.9475 | 5.9607 | 141820.0 |
| 2009-09-03 17:30:00 | AAPL | Stock | 5.9604 | 5.9607 | 5.9546 | 5.9604 | 32620.0 |
| 2009-09-03 18:00:00 | AAPL | Stock | 5.9571 | 5.9607 | 5.9482 | 5.9571 | 137172.0 |
| 2009-09-03 18:30:00 | AAPL | Stock | 5.9579 | 5.9621 | 5.9554 | 5.9611 | 67480.0 |
| 2009-09-03 19:00:00 | AAPL | Stock | 5.9607 | 5.9607 | 5.9571 | 5.9571 | 12180.0 |
| 2009-09-03 19:30:00 | AAPL | Stock | 5.9571 | 5.9571 | 5.9554 | 5.9571 | 63224.0 |
| 2009-09-03 06:00:00 | MSFT | Stock | 23.9 | 23.9 | 23.9 | 23.9 | 300.0 |
| 2009-09-03 07:00:00 | MSFT | Stock | 23.89 | 23.9 | 23.89 | 23.9 | 300.0 |
| 2009-09-03 08:00:00 | MSFT | Stock | 24.0 | 24.0 | 23.86 | 24.0 | 96348.0 |
| 2009-09-03 08:30:00 | MSFT | Stock | 24.0 | 24.0 | 23.95 | 23.99 | 7142.0 |
| 2009-09-03 09:00:00 | MSFT | Stock | 23.98 | 23.99 | 23.92 | 23.92 | 17119.0 |
| 2009-09-03 09:30:00 | MSFT | Stock | 23.92 | 23.987 | 23.81 | 23.88 | 3123396.0 |
| 2009-09-03 10:00:00 | MSFT | Stock | 23.87 | 23.93 | 23.76 | 23.82 | 3713494.0 |
| 2009-09-03 10:30:00 | MSFT | Stock | 23.82 | 23.932 | 23.8 | 23.9 | 2099664.0 |
| 2009-09-03 11:00:00 | MSFT | Stock | 23.91 | 23.96 | 23.82 | 23.9 | 1878018.0 |
| 2009-09-03 11:30:00 | MSFT | Stock | 23.89 | 23.97 | 23.89 | 23.93 | 1371331.0 |
| 2009-09-03 12:00:00 | MSFT | Stock | 23.93 | 24.04 | 23.9 | 24.01 | 1992654.0 |
| 2009-09-03 12:30:00 | MSFT | Stock | 24.0 | 24.02 | 23.935 | 23.952 | 1565554.0 |
| 2009-09-03 13:00:00 | MSFT | Stock | 23.96 | 24.04 | 23.95 | 24.03 | 1501878.0 |
| 2009-09-03 13:30:00 | MSFT | Stock | 24.03 | 24.06 | 24.02 | 24.035 | 1849706.0 |
| 2009-09-03 14:00:00 | MSFT | Stock | 24.03 | 24.06 | 24.0 | 24.01 | 2451230.0 |
| 2009-09-03 14:30:00 | MSFT | Stock | 24.0 | 24.05 | 23.98 | 24.05 | 2836599.0 |
| 2009-09-03 15:00:00 | MSFT | Stock | 24.05 | 24.09 | 24.0 | 24.04 | 2606014.0 |
| 2009-09-03 15:30:00 | MSFT | Stock | 24.04 | 24.14 | 24.03 | 24.11 | 3836020.0 |
| 2009-09-03 16:00:00 | MSFT | Stock | 24.11 | 24.12 | 23.958 | 24.08 | 2434142.0 |
| 2009-09-03 16:30:00 | MSFT | Stock | 23.985 | 24.11 | 23.985 | 24.09 | 70749.0 |
| 2009-09-03 17:00:00 | MSFT | Stock | 23.917 | 24.11 | 23.917 | 24.11 | 1700.0 |
| 2009-09-03 18:00:00 | MSFT | Stock | 24.15 | 24.16 | 24.11 | 24.16 | 9161.0 |
| 2009-09-03 18:30:00 | MSFT | Stock | 24.07 | 24.07 | 24.07 | 24.07 | 114.0 |
| 2009-09-03 19:30:00 | MSFT | Stock | 24.07 | 24.07 | 24.07 | 24.07 | 287.0 |
> showing 50 of 70,704 rows — these rows as CSV