PREVIEW / stock_30min / 2011-02-16
file: by_date/stock_30min/2011/2011-02-16.parquet size: 1.4 MB rows: 77,597 symbols: 3,560
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-16 05:00:00 | AAPL | Stock | 12.8736 | 12.8768 | 12.8621 | 12.8621 | 19600.0 |
| 2011-02-16 05:30:00 | AAPL | Stock | 12.8643 | 12.8764 | 12.8643 | 12.8704 | 11200.0 |
| 2011-02-16 06:00:00 | AAPL | Stock | 12.8471 | 12.8471 | 12.8471 | 12.8471 | 5600.0 |
| 2011-02-16 06:30:00 | AAPL | Stock | 12.8554 | 12.8554 | 12.855 | 12.855 | 5600.0 |
| 2011-02-16 07:00:00 | AAPL | Stock | 12.8571 | 12.9018 | 12.8554 | 12.8907 | 364448.0 |
| 2011-02-16 07:30:00 | AAPL | Stock | 12.8911 | 12.8986 | 12.8893 | 12.8986 | 117880.0 |
| 2011-02-16 08:00:00 | AAPL | Stock | 12.8986 | 12.9136 | 12.8825 | 12.9089 | 1793092.0 |
| 2011-02-16 08:30:00 | AAPL | Stock | 12.9064 | 12.9064 | 12.8946 | 12.8982 | 1188264.0 |
| 2011-02-16 09:00:00 | AAPL | Stock | 12.8993 | 12.9014 | 12.8786 | 12.8811 | 1233512.0 |
| 2011-02-16 09:30:00 | AAPL | Stock | 12.8857 | 12.9282 | 12.875 | 12.9146 | 58135028.0 |
| 2011-02-16 10:00:00 | AAPL | Stock | 12.9146 | 12.9643 | 12.9 | 12.9521 | 59482108.0 |
| 2011-02-16 10:30:00 | AAPL | Stock | 12.9536 | 13.0079 | 12.9527 | 13.0071 | 49913892.0 |
| 2011-02-16 11:00:00 | AAPL | Stock | 13.0064 | 13.0321 | 12.985 | 12.9879 | 53242728.0 |
| 2011-02-16 11:30:00 | AAPL | Stock | 12.9875 | 13.005 | 12.9768 | 12.9896 | 28431648.0 |
| 2011-02-16 12:00:00 | AAPL | Stock | 12.9909 | 12.9918 | 12.9079 | 12.9482 | 62637092.0 |
| 2011-02-16 12:30:00 | AAPL | Stock | 12.9479 | 12.9896 | 12.9354 | 12.975 | 30684080.0 |
| 2011-02-16 13:00:00 | AAPL | Stock | 12.975 | 12.9821 | 12.9591 | 12.9591 | 13649888.0 |
| 2011-02-16 13:30:00 | AAPL | Stock | 12.9614 | 12.9868 | 12.9604 | 12.9868 | 12918892.0 |
| 2011-02-16 14:00:00 | AAPL | Stock | 12.9861 | 12.9882 | 12.9525 | 12.9679 | 17350704.0 |
| 2011-02-16 14:30:00 | AAPL | Stock | 12.9679 | 12.9897 | 12.9646 | 12.9668 | 14283780.0 |
| 2011-02-16 15:00:00 | AAPL | Stock | 12.967 | 12.9814 | 12.9618 | 12.97 | 16064356.0 |
| 2011-02-16 15:30:00 | AAPL | Stock | 12.9696 | 12.9821 | 12.9604 | 12.9664 | 36781640.0 |
| 2011-02-16 16:00:00 | AAPL | Stock | 12.9689 | 12.9707 | 12.9575 | 12.9625 | 6451088.0 |
| 2011-02-16 16:30:00 | AAPL | Stock | 12.9625 | 12.9785 | 12.96 | 12.96 | 859824.0 |
| 2011-02-16 17:00:00 | AAPL | Stock | 12.9604 | 12.9657 | 12.96 | 12.9657 | 112756.0 |
| 2011-02-16 17:30:00 | AAPL | Stock | 12.9611 | 12.9625 | 12.8375 | 12.875 | 1713684.0 |
| 2011-02-16 18:00:00 | AAPL | Stock | 12.8804 | 12.9689 | 12.8757 | 12.88 | 1060864.0 |
| 2011-02-16 18:30:00 | AAPL | Stock | 12.8786 | 12.8836 | 12.8571 | 12.8607 | 1293656.0 |
| 2011-02-16 19:00:00 | AAPL | Stock | 12.8582 | 12.8643 | 12.8521 | 12.8536 | 1023988.0 |
| 2011-02-16 19:30:00 | AAPL | Stock | 12.8518 | 12.875 | 12.8489 | 12.8607 | 977312.0 |
| 2011-02-16 07:00:00 | MSFT | Stock | 27.0 | 27.0 | 27.0 | 27.0 | 300.0 |
| 2011-02-16 07:30:00 | MSFT | Stock | 27.03 | 27.03 | 27.03 | 27.03 | 2000.0 |
| 2011-02-16 08:00:00 | MSFT | Stock | 27.07 | 27.12 | 27.07 | 27.11 | 12470.0 |
| 2011-02-16 08:30:00 | MSFT | Stock | 27.11 | 27.12 | 27.05 | 27.06 | 20965.0 |
| 2011-02-16 09:00:00 | MSFT | Stock | 27.05 | 27.06 | 26.99 | 27.05 | 46549.0 |
| 2011-02-16 09:30:00 | MSFT | Stock | 27.06 | 27.07 | 26.86 | 26.98 | 4838431.0 |
| 2011-02-16 10:00:00 | MSFT | Stock | 26.98 | 27.05 | 26.92 | 26.92 | 5396536.0 |
| 2011-02-16 10:30:00 | MSFT | Stock | 26.92 | 26.95 | 26.85 | 26.91 | 4782670.0 |
| 2011-02-16 11:00:00 | MSFT | Stock | 26.91 | 26.91 | 26.73 | 26.74 | 7107934.0 |
| 2011-02-16 11:30:00 | MSFT | Stock | 26.74 | 26.84 | 26.71 | 26.742 | 6416777.0 |
| 2011-02-16 12:00:00 | MSFT | Stock | 26.75 | 26.75 | 26.6 | 26.635 | 6045238.0 |
| 2011-02-16 12:30:00 | MSFT | Stock | 26.64 | 26.7 | 26.61 | 26.695 | 4146725.0 |
| 2011-02-16 13:00:00 | MSFT | Stock | 26.695 | 26.73 | 26.62 | 26.71 | 4918427.0 |
| 2011-02-16 13:30:00 | MSFT | Stock | 26.7 | 26.94 | 26.69 | 26.895 | 7064382.0 |
| 2011-02-16 14:00:00 | MSFT | Stock | 26.9 | 26.96 | 26.83 | 26.87 | 4668895.0 |
| 2011-02-16 14:30:00 | MSFT | Stock | 26.88 | 27.0 | 26.85 | 26.958 | 3580053.0 |
| 2011-02-16 15:00:00 | MSFT | Stock | 26.955 | 27.025 | 26.95 | 26.96 | 3622642.0 |
| 2011-02-16 15:30:00 | MSFT | Stock | 26.955 | 27.02 | 26.93 | 27.01 | 5631958.0 |
| 2011-02-16 16:00:00 | MSFT | Stock | 27.01 | 27.023 | 26.847 | 26.99 | 1386349.0 |
| 2011-02-16 16:30:00 | MSFT | Stock | 26.97 | 27.02 | 26.92 | 26.95 | 112879.0 |
> showing 50 of 77,597 rows — these rows as CSV