PREVIEW / stock_30min / 2007-02-08
file: by_date/stock_30min/2007/2007-02-08.parquet size: 955 KB rows: 51,625 symbols: 2,496
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-08 04:00:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0786 | 3.0786 | 11844.0 |
| 2007-02-08 04:30:00 | AAPL | Stock | 3.0764 | 3.0764 | 3.0764 | 3.0764 | 11200.0 |
| 2007-02-08 06:00:00 | AAPL | Stock | 3.0889 | 3.0889 | 3.0689 | 3.0689 | 111104.0 |
| 2007-02-08 06:30:00 | AAPL | Stock | 3.0604 | 3.0679 | 3.0604 | 3.0661 | 33600.0 |
| 2007-02-08 07:00:00 | AAPL | Stock | 3.0661 | 3.0679 | 3.0589 | 3.0589 | 224000.0 |
| 2007-02-08 07:30:00 | AAPL | Stock | 3.0546 | 3.0629 | 3.0536 | 3.0554 | 320600.0 |
| 2007-02-08 08:00:00 | AAPL | Stock | 3.0571 | 3.0689 | 3.0539 | 3.0571 | 3565632.0 |
| 2007-02-08 08:30:00 | AAPL | Stock | 3.0589 | 3.0679 | 3.0564 | 3.0564 | 1933232.0 |
| 2007-02-08 09:00:00 | AAPL | Stock | 3.0586 | 3.0625 | 3.0489 | 3.0525 | 5470948.0 |
| 2007-02-08 09:30:00 | AAPL | Stock | 3.0511 | 3.0896 | 3.0504 | 3.0618 | 149640372.0 |
| 2007-02-08 10:00:00 | AAPL | Stock | 3.0618 | 3.0818 | 3.0586 | 3.0618 | 72993816.0 |
| 2007-02-08 10:30:00 | AAPL | Stock | 3.0621 | 3.0682 | 3.0536 | 3.0603 | 55228376.0 |
| 2007-02-08 11:00:00 | AAPL | Stock | 3.06 | 3.0707 | 3.0539 | 3.0696 | 38219104.0 |
| 2007-02-08 11:30:00 | AAPL | Stock | 3.07 | 3.0757 | 3.0643 | 3.0718 | 42840168.0 |
| 2007-02-08 12:00:00 | AAPL | Stock | 3.0718 | 3.0718 | 3.0614 | 3.07 | 30943668.0 |
| 2007-02-08 12:30:00 | AAPL | Stock | 3.07 | 3.085 | 3.0679 | 3.0771 | 44972872.0 |
| 2007-02-08 13:00:00 | AAPL | Stock | 3.0771 | 3.0886 | 3.0754 | 3.0799 | 37450112.0 |
| 2007-02-08 13:30:00 | AAPL | Stock | 3.0793 | 3.0843 | 3.0714 | 3.0761 | 23851772.0 |
| 2007-02-08 14:00:00 | AAPL | Stock | 3.0757 | 3.0804 | 3.0679 | 3.0767 | 27293252.0 |
| 2007-02-08 14:30:00 | AAPL | Stock | 3.0768 | 3.0825 | 3.0679 | 3.0811 | 33861268.0 |
| 2007-02-08 15:00:00 | AAPL | Stock | 3.0811 | 3.0893 | 3.0754 | 3.0818 | 46226124.0 |
| 2007-02-08 15:30:00 | AAPL | Stock | 3.0811 | 3.0843 | 3.075 | 3.0768 | 43869812.0 |
| 2007-02-08 16:00:00 | AAPL | Stock | 3.0771 | 3.0793 | 3.0754 | 3.0793 | 981792.0 |
| 2007-02-08 16:30:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0779 | 3.0786 | 239120.0 |
| 2007-02-08 17:00:00 | AAPL | Stock | 3.0793 | 3.0804 | 3.0786 | 3.0804 | 233324.0 |
| 2007-02-08 17:30:00 | AAPL | Stock | 3.0811 | 3.0814 | 3.0811 | 3.0811 | 98000.0 |
| 2007-02-08 18:00:00 | AAPL | Stock | 3.0789 | 3.0811 | 3.0786 | 3.0786 | 124040.0 |
| 2007-02-08 18:30:00 | AAPL | Stock | 3.0782 | 3.0807 | 3.0779 | 3.0793 | 84168.0 |
| 2007-02-08 19:00:00 | AAPL | Stock | 3.0786 | 3.0793 | 3.0786 | 3.0793 | 53900.0 |
| 2007-02-08 19:30:00 | AAPL | Stock | 3.0779 | 3.0789 | 3.0779 | 3.0779 | 118356.0 |
| 2007-02-08 08:00:00 | MSFT | Stock | 29.35 | 29.35 | 29.29 | 29.31 | 10050.0 |
| 2007-02-08 08:30:00 | MSFT | Stock | 29.33 | 29.38 | 29.29 | 29.29 | 387807.0 |
| 2007-02-08 09:00:00 | MSFT | Stock | 29.29 | 29.29 | 29.2 | 29.23 | 97332.0 |
| 2007-02-08 09:30:00 | MSFT | Stock | 29.24 | 29.8 | 29.21 | 29.31 | 7880747.0 |
| 2007-02-08 10:00:00 | MSFT | Stock | 29.31 | 29.8 | 29.28 | 29.32 | 3884612.0 |
| 2007-02-08 10:30:00 | MSFT | Stock | 29.32 | 29.35 | 29.27 | 29.293 | 2386019.0 |
| 2007-02-08 11:00:00 | MSFT | Stock | 29.29 | 29.34 | 29.27 | 29.3 | 2752835.0 |
| 2007-02-08 11:30:00 | MSFT | Stock | 29.3 | 29.36 | 29.2 | 29.26 | 2222905.0 |
| 2007-02-08 12:00:00 | MSFT | Stock | 29.26 | 29.37 | 29.2 | 29.3 | 2482437.0 |
| 2007-02-08 12:30:00 | MSFT | Stock | 29.3 | 29.34 | 29.26 | 29.31 | 1927006.0 |
| 2007-02-08 13:00:00 | MSFT | Stock | 29.32 | 29.36 | 29.2 | 29.3 | 1496814.0 |
| 2007-02-08 13:30:00 | MSFT | Stock | 29.29 | 29.3 | 29.26 | 29.27 | 3714825.0 |
| 2007-02-08 14:00:00 | MSFT | Stock | 29.26 | 29.29 | 29.24 | 29.24 | 3215444.0 |
| 2007-02-08 14:30:00 | MSFT | Stock | 29.24 | 29.3 | 29.23 | 29.29 | 5367131.0 |
| 2007-02-08 15:00:00 | MSFT | Stock | 29.29 | 29.3 | 29.25 | 29.26 | 2609454.0 |
| 2007-02-08 15:30:00 | MSFT | Stock | 29.26 | 29.33 | 29.24 | 29.26 | 6372353.0 |
| 2007-02-08 16:00:00 | MSFT | Stock | 29.26 | 29.286 | 29.24 | 29.25 | 202271.0 |
| 2007-02-08 16:30:00 | MSFT | Stock | 29.25 | 29.26 | 29.25 | 29.25 | 20500.0 |
| 2007-02-08 17:00:00 | MSFT | Stock | 29.26 | 29.28 | 29.25 | 29.28 | 3340.0 |
| 2007-02-08 17:30:00 | MSFT | Stock | 29.26 | 29.28 | 29.26 | 29.26 | 2750.0 |
> showing 50 of 51,625 rows — these rows as CSV