PREVIEW / stock_30min / 2009-06-30
file: by_date/stock_30min/2009/2009-06-30.parquet size: 1.3 MB rows: 73,561 symbols: 3,335
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-30 08:00:00 | AAPL | Stock | 5.0893 | 5.0893 | 5.0679 | 5.0775 | 293832.0 |
| 2009-06-30 08:30:00 | AAPL | Stock | 5.0768 | 5.0786 | 5.0714 | 5.0771 | 585284.0 |
| 2009-06-30 09:00:00 | AAPL | Stock | 5.075 | 5.1014 | 5.0743 | 5.0946 | 1080240.0 |
| 2009-06-30 09:30:00 | AAPL | Stock | 5.0921 | 5.1357 | 5.0743 | 5.1118 | 75575528.0 |
| 2009-06-30 10:00:00 | AAPL | Stock | 5.1118 | 5.1121 | 5.0804 | 5.0861 | 47505780.0 |
| 2009-06-30 10:30:00 | AAPL | Stock | 5.0857 | 5.0939 | 5.0643 | 5.0836 | 42582540.0 |
| 2009-06-30 11:00:00 | AAPL | Stock | 5.0832 | 5.0957 | 5.0732 | 5.0743 | 20345528.0 |
| 2009-06-30 11:30:00 | AAPL | Stock | 5.0743 | 5.0821 | 5.0671 | 5.0768 | 22496544.0 |
| 2009-06-30 12:00:00 | AAPL | Stock | 5.0768 | 5.0796 | 5.0646 | 5.0743 | 14060984.0 |
| 2009-06-30 12:30:00 | AAPL | Stock | 5.0743 | 5.0846 | 5.0721 | 5.0757 | 11620700.0 |
| 2009-06-30 13:00:00 | AAPL | Stock | 5.0754 | 5.0875 | 5.0711 | 5.0807 | 17151372.0 |
| 2009-06-30 13:30:00 | AAPL | Stock | 5.0807 | 5.0957 | 5.0803 | 5.0836 | 14762188.0 |
| 2009-06-30 14:00:00 | AAPL | Stock | 5.0832 | 5.0854 | 5.0729 | 5.0829 | 18490808.0 |
| 2009-06-30 14:30:00 | AAPL | Stock | 5.0829 | 5.0886 | 5.0743 | 5.0764 | 17212440.0 |
| 2009-06-30 15:00:00 | AAPL | Stock | 5.0763 | 5.0954 | 5.0711 | 5.0852 | 29739080.0 |
| 2009-06-30 15:30:00 | AAPL | Stock | 5.0857 | 5.1032 | 5.0714 | 5.09 | 54076960.0 |
| 2009-06-30 16:00:00 | AAPL | Stock | 5.0714 | 5.1032 | 5.0642 | 5.0868 | 26787740.0 |
| 2009-06-30 16:30:00 | AAPL | Stock | 5.0925 | 5.0964 | 5.0776 | 5.0868 | 12416572.0 |
| 2009-06-30 17:00:00 | AAPL | Stock | 5.0868 | 5.095 | 5.0868 | 5.0893 | 1149204.0 |
| 2009-06-30 17:30:00 | AAPL | Stock | 5.0893 | 5.0893 | 5.0821 | 5.0875 | 83300.0 |
| 2009-06-30 18:00:00 | AAPL | Stock | 5.0936 | 5.0936 | 5.0936 | 5.0936 | 223748.0 |
| 2009-06-30 18:30:00 | AAPL | Stock | 5.0821 | 5.0821 | 5.0821 | 5.0821 | 5600.0 |
| 2009-06-30 19:00:00 | AAPL | Stock | 5.0886 | 5.0893 | 5.0886 | 5.0893 | 11200.0 |
| 2009-06-30 19:30:00 | AAPL | Stock | 5.0857 | 5.0857 | 5.0857 | 5.0857 | 11200.0 |
| 2009-06-30 05:00:00 | MSFT | Stock | 23.85 | 23.85 | 23.81 | 23.81 | 838.0 |
| 2009-06-30 05:30:00 | MSFT | Stock | 23.8 | 23.8 | 23.8 | 23.8 | 638.0 |
| 2009-06-30 06:30:00 | MSFT | Stock | 23.84 | 23.84 | 23.84 | 23.84 | 1700.0 |
| 2009-06-30 08:00:00 | MSFT | Stock | 23.91 | 23.91 | 23.85 | 23.9 | 7556.0 |
| 2009-06-30 08:30:00 | MSFT | Stock | 23.9 | 23.98 | 23.9 | 23.9 | 10152.0 |
| 2009-06-30 09:00:00 | MSFT | Stock | 23.93 | 23.99 | 23.93 | 23.99 | 12681.0 |
| 2009-06-30 09:30:00 | MSFT | Stock | 23.97 | 24.24 | 23.95 | 24.22 | 6821824.0 |
| 2009-06-30 10:00:00 | MSFT | Stock | 24.22 | 24.24 | 23.81 | 23.85 | 8799891.0 |
| 2009-06-30 10:30:00 | MSFT | Stock | 23.85 | 23.96 | 23.77 | 23.919 | 5219033.0 |
| 2009-06-30 11:00:00 | MSFT | Stock | 23.92 | 23.92 | 23.81 | 23.875 | 2940281.0 |
| 2009-06-30 11:30:00 | MSFT | Stock | 23.87 | 23.87 | 23.75 | 23.76 | 3034393.0 |
| 2009-06-30 12:00:00 | MSFT | Stock | 23.76 | 23.81 | 23.73 | 23.8 | 1722386.0 |
| 2009-06-30 12:30:00 | MSFT | Stock | 23.8 | 23.85 | 23.79 | 23.81 | 1585178.0 |
| 2009-06-30 13:00:00 | MSFT | Stock | 23.81 | 23.83 | 23.75 | 23.75 | 2059562.0 |
| 2009-06-30 13:30:00 | MSFT | Stock | 23.75 | 23.77 | 23.63 | 23.67 | 1668886.0 |
| 2009-06-30 14:00:00 | MSFT | Stock | 23.68 | 23.78 | 23.66 | 23.71 | 2636640.0 |
| 2009-06-30 14:30:00 | MSFT | Stock | 23.712 | 23.78 | 23.67 | 23.715 | 3117142.0 |
| 2009-06-30 15:00:00 | MSFT | Stock | 23.71 | 23.78 | 23.65 | 23.78 | 3784130.0 |
| 2009-06-30 15:30:00 | MSFT | Stock | 23.78 | 23.88 | 23.7 | 23.77 | 12291826.0 |
| 2009-06-30 16:00:00 | MSFT | Stock | 23.78 | 24.032 | 23.72 | 23.8 | 8315878.0 |
| 2009-06-30 16:30:00 | MSFT | Stock | 23.77 | 23.77 | 23.727 | 23.77 | 1086873.0 |
| 2009-06-30 17:00:00 | MSFT | Stock | 23.77 | 23.8 | 23.77 | 23.78 | 277010.0 |
| 2009-06-30 17:30:00 | MSFT | Stock | 23.84 | 23.89 | 23.84 | 23.89 | 5800.0 |
| 2009-06-30 18:00:00 | MSFT | Stock | 23.88 | 23.88 | 23.81 | 23.81 | 6900.0 |
| 2009-06-30 18:30:00 | MSFT | Stock | 23.84 | 23.84 | 23.77 | 23.77 | 630.0 |
| 2009-06-30 19:00:00 | MSFT | Stock | 23.85 | 23.85 | 23.81 | 23.85 | 3625.0 |
> showing 50 of 73,561 rows — these rows as CSV