PREVIEW / stock_30min / 2008-09-22
file: by_date/stock_30min/2008/2008-09-22.parquet size: 1.3 MB rows: 70,093 symbols: 3,363
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-09-22 07:00:00 | AAPL | Stock | 5.0 | 5.0 | 4.9679 | 4.9679 | 149716.0 |
| 2008-09-22 07:30:00 | AAPL | Stock | 4.9679 | 4.9732 | 4.9568 | 4.9571 | 379932.0 |
| 2008-09-22 08:00:00 | AAPL | Stock | 4.9679 | 4.9761 | 4.9511 | 4.9761 | 1595580.0 |
| 2008-09-22 08:30:00 | AAPL | Stock | 4.9729 | 5.0068 | 4.9729 | 4.9818 | 1709624.0 |
| 2008-09-22 09:00:00 | AAPL | Stock | 4.9818 | 5.0268 | 4.9779 | 4.9932 | 1951348.0 |
| 2008-09-22 09:30:00 | AAPL | Stock | 4.9979 | 5.0089 | 4.9154 | 4.9475 | 109137056.0 |
| 2008-09-22 10:00:00 | AAPL | Stock | 4.9464 | 4.9664 | 4.9046 | 4.9325 | 69301792.0 |
| 2008-09-22 10:30:00 | AAPL | Stock | 4.9329 | 4.9779 | 4.9243 | 4.9657 | 60238612.0 |
| 2008-09-22 11:00:00 | AAPL | Stock | 4.9657 | 4.975 | 4.9089 | 4.9194 | 51587760.0 |
| 2008-09-22 11:30:00 | AAPL | Stock | 4.9168 | 4.9204 | 4.8486 | 4.8771 | 66803352.0 |
| 2008-09-22 12:00:00 | AAPL | Stock | 4.8748 | 4.9086 | 4.8607 | 4.8975 | 37442636.0 |
| 2008-09-22 12:30:00 | AAPL | Stock | 4.8979 | 4.9096 | 4.875 | 4.8807 | 27255788.0 |
| 2008-09-22 13:00:00 | AAPL | Stock | 4.8821 | 4.8875 | 4.8254 | 4.8289 | 43378776.0 |
| 2008-09-22 13:30:00 | AAPL | Stock | 4.8293 | 4.8693 | 4.8014 | 4.8518 | 60687704.0 |
| 2008-09-22 14:00:00 | AAPL | Stock | 4.8511 | 4.8614 | 4.8036 | 4.8121 | 58648408.0 |
| 2008-09-22 14:30:00 | AAPL | Stock | 4.8125 | 4.8436 | 4.7693 | 4.7829 | 57890980.0 |
| 2008-09-22 15:00:00 | AAPL | Stock | 4.7818 | 4.7925 | 4.7161 | 4.7257 | 78147272.0 |
| 2008-09-22 15:30:00 | AAPL | Stock | 4.7264 | 4.7546 | 4.6664 | 4.6725 | 109959360.0 |
| 2008-09-22 16:00:00 | AAPL | Stock | 4.6714 | 4.8724 | 4.6714 | 4.6986 | 13884388.0 |
| 2008-09-22 16:30:00 | AAPL | Stock | 4.6986 | 4.7 | 4.6946 | 4.6954 | 133532.0 |
| 2008-09-22 17:00:00 | AAPL | Stock | 4.6921 | 4.7 | 4.6918 | 4.6971 | 231336.0 |
| 2008-09-22 17:30:00 | AAPL | Stock | 4.6996 | 4.6996 | 4.6804 | 4.6961 | 174160.0 |
| 2008-09-22 18:00:00 | AAPL | Stock | 4.6961 | 4.6971 | 4.6875 | 4.6904 | 293692.0 |
| 2008-09-22 18:30:00 | AAPL | Stock | 4.6889 | 4.6964 | 4.6829 | 4.6954 | 179788.0 |
| 2008-09-22 19:00:00 | AAPL | Stock | 4.6882 | 4.6907 | 4.6829 | 4.6893 | 148008.0 |
| 2008-09-22 19:30:00 | AAPL | Stock | 4.6921 | 4.6964 | 4.6882 | 4.6964 | 82768.0 |
| 2008-09-22 07:30:00 | MSFT | Stock | 24.95 | 24.95 | 24.95 | 24.95 | 100.0 |
| 2008-09-22 08:00:00 | MSFT | Stock | 25.1 | 25.1 | 24.88 | 25.0 | 11013.0 |
| 2008-09-22 08:30:00 | MSFT | Stock | 25.05 | 28.99 | 24.98 | 26.47 | 3505812.0 |
| 2008-09-22 09:00:00 | MSFT | Stock | 26.45 | 26.51 | 26.17 | 26.22 | 893606.0 |
| 2008-09-22 09:30:00 | MSFT | Stock | 26.22 | 26.32 | 25.65 | 26.04 | 12635646.0 |
| 2008-09-22 10:00:00 | MSFT | Stock | 26.05 | 26.25 | 25.94 | 26.16 | 11665527.0 |
| 2008-09-22 10:30:00 | MSFT | Stock | 26.16 | 26.3 | 26.09 | 26.23 | 8051014.0 |
| 2008-09-22 11:00:00 | MSFT | Stock | 26.24 | 26.245 | 25.9 | 25.91 | 5090059.0 |
| 2008-09-22 11:30:00 | MSFT | Stock | 25.9 | 25.98 | 25.7 | 25.93 | 7302752.0 |
| 2008-09-22 12:00:00 | MSFT | Stock | 25.93 | 26.04 | 25.929 | 26.04 | 3656645.0 |
| 2008-09-22 12:30:00 | MSFT | Stock | 26.04 | 26.09 | 25.95 | 26.01 | 3807499.0 |
| 2008-09-22 13:00:00 | MSFT | Stock | 26.002 | 26.01 | 25.86 | 25.9 | 5104590.0 |
| 2008-09-22 13:30:00 | MSFT | Stock | 25.91 | 25.91 | 25.71 | 25.88 | 6069447.0 |
| 2008-09-22 14:00:00 | MSFT | Stock | 25.88 | 25.99 | 25.84 | 25.89 | 5048240.0 |
| 2008-09-22 14:30:00 | MSFT | Stock | 25.895 | 26.05 | 25.87 | 25.89 | 4502965.0 |
| 2008-09-22 15:00:00 | MSFT | Stock | 25.89 | 25.93 | 25.6 | 25.6 | 7161052.0 |
| 2008-09-22 15:30:00 | MSFT | Stock | 25.61 | 25.64 | 25.32 | 25.36 | 14246924.0 |
| 2008-09-22 16:00:00 | MSFT | Stock | 25.38 | 25.9 | 25.36 | 25.5 | 3736239.0 |
| 2008-09-22 16:30:00 | MSFT | Stock | 25.53 | 25.762 | 25.413 | 25.59 | 163657.0 |
| 2008-09-22 17:00:00 | MSFT | Stock | 25.62 | 25.62 | 25.16 | 25.61 | 1122449.0 |
| 2008-09-22 17:30:00 | MSFT | Stock | 25.59 | 25.6 | 25.4 | 25.6 | 13750.0 |
| 2008-09-22 18:00:00 | MSFT | Stock | 25.61 | 25.62 | 25.4 | 25.61 | 19740.0 |
| 2008-09-22 18:30:00 | MSFT | Stock | 25.59 | 25.63 | 25.57 | 25.57 | 15633.0 |
| 2008-09-22 19:00:00 | MSFT | Stock | 25.57 | 25.63 | 25.56 | 25.63 | 5169.0 |
> showing 50 of 70,093 rows — these rows as CSV