PREVIEW / stock_30min / 2009-06-25
file: by_date/stock_30min/2009/2009-06-25.parquet size: 1.3 MB rows: 71,802 symbols: 3,354
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-06-25 05:30:00 | AAPL | Stock | 4.8868 | 4.8868 | 4.8868 | 4.8868 | 14000.0 |
| 2009-06-25 06:00:00 | AAPL | Stock | 4.8943 | 4.9025 | 4.8943 | 4.9025 | 28000.0 |
| 2009-06-25 07:00:00 | AAPL | Stock | 4.8857 | 4.8857 | 4.8857 | 4.8857 | 2800.0 |
| 2009-06-25 07:30:00 | AAPL | Stock | 4.8911 | 4.9054 | 4.8893 | 4.8993 | 120400.0 |
| 2009-06-25 08:00:00 | AAPL | Stock | 4.8936 | 4.8979 | 4.875 | 4.8768 | 683564.0 |
| 2009-06-25 08:30:00 | AAPL | Stock | 4.8786 | 4.8786 | 4.8339 | 4.8432 | 1038996.0 |
| 2009-06-25 09:00:00 | AAPL | Stock | 4.8404 | 4.8536 | 4.8389 | 4.8504 | 772856.0 |
| 2009-06-25 09:30:00 | AAPL | Stock | 4.8489 | 4.9425 | 4.8289 | 4.9336 | 92001588.0 |
| 2009-06-25 10:00:00 | AAPL | Stock | 4.9336 | 4.9768 | 4.9286 | 4.9532 | 77523432.0 |
| 2009-06-25 10:30:00 | AAPL | Stock | 4.9532 | 4.9621 | 4.9407 | 4.9618 | 34842416.0 |
| 2009-06-25 11:00:00 | AAPL | Stock | 4.9621 | 4.9782 | 4.9568 | 4.9768 | 26713064.0 |
| 2009-06-25 11:30:00 | AAPL | Stock | 4.9768 | 4.9896 | 4.9732 | 4.9811 | 41184780.0 |
| 2009-06-25 12:00:00 | AAPL | Stock | 4.9814 | 4.9893 | 4.9721 | 4.9793 | 25261544.0 |
| 2009-06-25 12:30:00 | AAPL | Stock | 4.9793 | 4.9854 | 4.9696 | 4.9793 | 20701352.0 |
| 2009-06-25 13:00:00 | AAPL | Stock | 4.9789 | 5.0 | 4.9754 | 4.9921 | 28572544.0 |
| 2009-06-25 13:30:00 | AAPL | Stock | 4.9918 | 4.9957 | 4.9811 | 4.9879 | 18306988.0 |
| 2009-06-25 14:00:00 | AAPL | Stock | 4.9879 | 4.9901 | 4.9771 | 4.9894 | 25675356.0 |
| 2009-06-25 14:30:00 | AAPL | Stock | 4.9896 | 4.9907 | 4.9714 | 4.975 | 39725784.0 |
| 2009-06-25 15:00:00 | AAPL | Stock | 4.975 | 4.9789 | 4.9568 | 4.9739 | 47419652.0 |
| 2009-06-25 15:30:00 | AAPL | Stock | 4.9736 | 5.0071 | 4.9607 | 4.9979 | 76770344.0 |
| 2009-06-25 16:00:00 | AAPL | Stock | 5.0025 | 5.0046 | 4.9594 | 4.9964 | 18424980.0 |
| 2009-06-25 16:30:00 | AAPL | Stock | 4.9993 | 5.0036 | 4.9596 | 4.9936 | 1297100.0 |
| 2009-06-25 17:00:00 | AAPL | Stock | 4.9996 | 5.0071 | 4.9996 | 5.0007 | 168588.0 |
| 2009-06-25 17:30:00 | AAPL | Stock | 5.0071 | 5.0071 | 4.9982 | 4.9982 | 85148.0 |
| 2009-06-25 18:00:00 | AAPL | Stock | 4.9982 | 5.0 | 4.995 | 4.9982 | 1219064.0 |
| 2009-06-25 18:30:00 | AAPL | Stock | 4.9982 | 4.9993 | 4.9982 | 4.9993 | 117600.0 |
| 2009-06-25 19:00:00 | AAPL | Stock | 4.9986 | 4.9993 | 4.9954 | 4.9993 | 39760.0 |
| 2009-06-25 19:30:00 | AAPL | Stock | 4.9971 | 4.9993 | 4.995 | 4.9964 | 58492.0 |
| 2009-06-25 08:00:00 | MSFT | Stock | 23.55 | 23.69 | 23.47 | 23.62 | 5479.0 |
| 2009-06-25 08:30:00 | MSFT | Stock | 23.5 | 23.5 | 23.38 | 23.38 | 15017.0 |
| 2009-06-25 09:00:00 | MSFT | Stock | 23.42 | 23.43 | 23.37 | 23.43 | 5556.0 |
| 2009-06-25 09:30:00 | MSFT | Stock | 23.43 | 23.55 | 23.2 | 23.49 | 7252502.0 |
| 2009-06-25 10:00:00 | MSFT | Stock | 23.49 | 23.73 | 23.49 | 23.65 | 5293601.0 |
| 2009-06-25 10:30:00 | MSFT | Stock | 23.65 | 23.68 | 23.55 | 23.595 | 2887897.0 |
| 2009-06-25 11:00:00 | MSFT | Stock | 23.6 | 23.75 | 23.58 | 23.74 | 2103224.0 |
| 2009-06-25 11:30:00 | MSFT | Stock | 23.75 | 23.87 | 23.73 | 23.81 | 4950675.0 |
| 2009-06-25 12:00:00 | MSFT | Stock | 23.8 | 23.84 | 23.71 | 23.75 | 2911924.0 |
| 2009-06-25 12:30:00 | MSFT | Stock | 23.75 | 23.77 | 23.675 | 23.69 | 2060882.0 |
| 2009-06-25 13:00:00 | MSFT | Stock | 23.69 | 23.86 | 23.67 | 23.83 | 3207243.0 |
| 2009-06-25 13:30:00 | MSFT | Stock | 23.84 | 23.88 | 23.82 | 23.849 | 2680257.0 |
| 2009-06-25 14:00:00 | MSFT | Stock | 23.84 | 23.86 | 23.77 | 23.85 | 2517435.0 |
| 2009-06-25 14:30:00 | MSFT | Stock | 23.845 | 23.86 | 23.65 | 23.69 | 5057298.0 |
| 2009-06-25 15:00:00 | MSFT | Stock | 23.69 | 23.81 | 23.623 | 23.75 | 4061729.0 |
| 2009-06-25 15:30:00 | MSFT | Stock | 23.75 | 23.92 | 23.62 | 23.8 | 8523381.0 |
| 2009-06-25 16:00:00 | MSFT | Stock | 23.8 | 23.86 | 23.686 | 23.79 | 2596044.0 |
| 2009-06-25 16:30:00 | MSFT | Stock | 23.8 | 23.82 | 23.689 | 23.77 | 363161.0 |
| 2009-06-25 17:00:00 | MSFT | Stock | 23.76 | 23.76 | 23.76 | 23.76 | 400.0 |
| 2009-06-25 17:30:00 | MSFT | Stock | 23.78 | 23.78 | 23.78 | 23.78 | 200.0 |
| 2009-06-25 18:00:00 | MSFT | Stock | 23.82 | 23.83 | 23.82 | 23.83 | 2300.0 |
| 2009-06-25 18:30:00 | MSFT | Stock | 23.79 | 23.79 | 23.75 | 23.76 | 2575.0 |
> showing 50 of 71,802 rows — these rows as CSV