PREVIEW / stock_30min / 2008-09-08
file: by_date/stock_30min/2008/2008-09-08.parquet size: 1.3 MB rows: 70,326 symbols: 3,320
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-08 04:00:00 | AAPL | Stock | 5.78 | 5.78 | 5.78 | 5.78 | 2800.0 |
| 2008-09-08 06:30:00 | AAPL | Stock | 5.8571 | 5.875 | 5.8571 | 5.875 | 64484.0 |
| 2008-09-08 07:00:00 | AAPL | Stock | 5.8754 | 5.8839 | 5.8429 | 5.8482 | 349356.0 |
| 2008-09-08 07:30:00 | AAPL | Stock | 5.8571 | 5.8643 | 5.8429 | 5.8571 | 364420.0 |
| 2008-09-08 08:00:00 | AAPL | Stock | 5.8571 | 5.875 | 5.8429 | 5.8696 | 3146528.0 |
| 2008-09-08 08:30:00 | AAPL | Stock | 5.8696 | 5.8696 | 5.8571 | 5.8643 | 1439564.0 |
| 2008-09-08 09:00:00 | AAPL | Stock | 5.8646 | 5.8946 | 5.8629 | 5.875 | 4063696.0 |
| 2008-09-08 09:30:00 | AAPL | Stock | 5.8771 | 5.8889 | 5.6786 | 5.6846 | 137946872.0 |
| 2008-09-08 10:00:00 | AAPL | Stock | 5.6836 | 5.7225 | 5.6114 | 5.67 | 109708424.0 |
| 2008-09-08 10:30:00 | AAPL | Stock | 5.6714 | 5.7375 | 5.6168 | 5.6168 | 78549380.0 |
| 2008-09-08 11:00:00 | AAPL | Stock | 5.6168 | 5.6875 | 5.5207 | 5.5261 | 97919108.0 |
| 2008-09-08 11:30:00 | AAPL | Stock | 5.5254 | 5.6004 | 5.4479 | 5.4771 | 88648084.0 |
| 2008-09-08 12:00:00 | AAPL | Stock | 5.4775 | 5.5125 | 5.4092 | 5.5 | 87254888.0 |
| 2008-09-08 12:30:00 | AAPL | Stock | 5.5 | 5.5982 | 5.5 | 5.5768 | 64410752.0 |
| 2008-09-08 13:00:00 | AAPL | Stock | 5.5768 | 5.5954 | 5.5189 | 5.5579 | 48727868.0 |
| 2008-09-08 13:30:00 | AAPL | Stock | 5.5557 | 5.5625 | 5.5082 | 5.515 | 43887872.0 |
| 2008-09-08 14:00:00 | AAPL | Stock | 5.5146 | 5.6064 | 5.4979 | 5.5936 | 65775892.0 |
| 2008-09-08 14:30:00 | AAPL | Stock | 5.5936 | 5.6182 | 5.5593 | 5.5821 | 45610796.0 |
| 2008-09-08 15:00:00 | AAPL | Stock | 5.5821 | 5.6175 | 5.5414 | 5.6109 | 48677720.0 |
| 2008-09-08 15:30:00 | AAPL | Stock | 5.6086 | 5.6657 | 5.605 | 5.6407 | 98145264.0 |
| 2008-09-08 16:00:00 | AAPL | Stock | 5.64 | 5.64 | 5.5854 | 5.625 | 8817536.0 |
| 2008-09-08 16:30:00 | AAPL | Stock | 5.64 | 5.64 | 5.6071 | 5.6204 | 1181040.0 |
| 2008-09-08 17:00:00 | AAPL | Stock | 5.6164 | 5.7207 | 5.6111 | 5.6204 | 2899820.0 |
| 2008-09-08 17:30:00 | AAPL | Stock | 5.615 | 5.6314 | 5.615 | 5.6311 | 122584.0 |
| 2008-09-08 18:00:00 | AAPL | Stock | 5.625 | 5.6279 | 5.6196 | 5.6279 | 38528.0 |
| 2008-09-08 18:30:00 | AAPL | Stock | 5.6282 | 5.64 | 5.6196 | 5.6314 | 144088.0 |
| 2008-09-08 19:00:00 | AAPL | Stock | 5.6207 | 5.6214 | 5.6204 | 5.6204 | 57400.0 |
| 2008-09-08 19:30:00 | AAPL | Stock | 5.6246 | 5.6275 | 5.6196 | 5.6246 | 66864.0 |
| 2008-09-08 07:00:00 | MSFT | Stock | 26.25 | 26.3 | 26.25 | 26.25 | 1100.0 |
| 2008-09-08 07:30:00 | MSFT | Stock | 26.28 | 26.28 | 26.28 | 26.28 | 450.0 |
| 2008-09-08 08:00:00 | MSFT | Stock | 26.16 | 26.2 | 26.01 | 26.1 | 20300.0 |
| 2008-09-08 08:30:00 | MSFT | Stock | 26.1 | 26.16 | 26.1 | 26.15 | 36729.0 |
| 2008-09-08 09:00:00 | MSFT | Stock | 26.19 | 26.29 | 26.18 | 26.21 | 108859.0 |
| 2008-09-08 09:30:00 | MSFT | Stock | 26.21 | 26.33 | 25.74 | 25.76 | 9043668.0 |
| 2008-09-08 10:00:00 | MSFT | Stock | 25.76 | 26.05 | 25.67 | 26.0 | 7284433.0 |
| 2008-09-08 10:30:00 | MSFT | Stock | 26.0 | 26.19 | 25.85 | 25.85 | 4544671.0 |
| 2008-09-08 11:00:00 | MSFT | Stock | 25.85 | 26.0 | 25.69 | 25.75 | 5615236.0 |
| 2008-09-08 11:30:00 | MSFT | Stock | 25.75 | 25.92 | 25.75 | 25.84 | 3608890.0 |
| 2008-09-08 12:00:00 | MSFT | Stock | 25.842 | 25.95 | 25.73 | 25.86 | 3975795.0 |
| 2008-09-08 12:30:00 | MSFT | Stock | 25.862 | 26.01 | 25.86 | 25.96 | 2123258.0 |
| 2008-09-08 13:00:00 | MSFT | Stock | 25.97 | 25.99 | 25.76 | 25.77 | 2571904.0 |
| 2008-09-08 13:30:00 | MSFT | Stock | 25.77 | 25.83 | 25.75 | 25.76 | 2204419.0 |
| 2008-09-08 14:00:00 | MSFT | Stock | 25.76 | 25.91 | 25.75 | 25.9 | 2375485.0 |
| 2008-09-08 14:30:00 | MSFT | Stock | 25.9 | 25.95 | 25.81 | 25.85 | 2480334.0 |
| 2008-09-08 15:00:00 | MSFT | Stock | 25.84 | 26.0 | 25.75 | 25.98 | 3592289.0 |
| 2008-09-08 15:30:00 | MSFT | Stock | 25.98 | 26.13 | 25.97 | 26.13 | 7124277.0 |
| 2008-09-08 16:00:00 | MSFT | Stock | 26.13 | 26.2 | 25.904 | 25.992 | 3187166.0 |
| 2008-09-08 16:30:00 | MSFT | Stock | 26.12 | 26.18 | 26.12 | 26.15 | 336353.0 |
| 2008-09-08 17:00:00 | MSFT | Stock | 26.06 | 26.12 | 25.65 | 26.07 | 252697.0 |
| 2008-09-08 17:30:00 | MSFT | Stock | 26.12 | 26.19 | 26.12 | 26.19 | 1100.0 |
> showing 50 of 70,326 rows — these rows as CSV