PREVIEW / stock_30min / 2010-12-16
file: by_date/stock_30min/2010/2010-12-16.parquet size: 1.4 MB rows: 76,450 symbols: 3,537
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-16 04:30:00 | AAPL | Stock | 11.4579 | 11.4579 | 11.4579 | 11.4579 | 13384.0 |
| 2010-12-16 05:00:00 | AAPL | Stock | 11.4325 | 11.4614 | 11.4325 | 11.4614 | 16800.0 |
| 2010-12-16 05:30:00 | AAPL | Stock | 11.4643 | 11.4643 | 11.4643 | 11.4643 | 14000.0 |
| 2010-12-16 06:00:00 | AAPL | Stock | 11.4682 | 11.4839 | 11.4643 | 11.4839 | 8400.0 |
| 2010-12-16 06:30:00 | AAPL | Stock | 11.5171 | 11.5171 | 11.5171 | 11.5171 | 4200.0 |
| 2010-12-16 07:00:00 | AAPL | Stock | 11.4989 | 11.5125 | 11.4957 | 11.5018 | 128688.0 |
| 2010-12-16 07:30:00 | AAPL | Stock | 11.5036 | 11.5161 | 11.4864 | 11.5054 | 536900.0 |
| 2010-12-16 08:00:00 | AAPL | Stock | 11.5018 | 11.5036 | 11.4564 | 11.4793 | 1284360.0 |
| 2010-12-16 08:30:00 | AAPL | Stock | 11.4768 | 11.5018 | 11.475 | 11.4918 | 1551312.0 |
| 2010-12-16 09:00:00 | AAPL | Stock | 11.4918 | 11.4946 | 11.4643 | 11.4661 | 954072.0 |
| 2010-12-16 09:30:00 | AAPL | Stock | 11.4654 | 11.4821 | 11.4321 | 11.4325 | 44242408.0 |
| 2010-12-16 10:00:00 | AAPL | Stock | 11.4325 | 11.4704 | 11.4325 | 11.4494 | 27815256.0 |
| 2010-12-16 10:30:00 | AAPL | Stock | 11.4507 | 11.4654 | 11.4473 | 11.4521 | 19275760.0 |
| 2010-12-16 11:00:00 | AAPL | Stock | 11.4529 | 11.4846 | 11.4414 | 11.4746 | 32174576.0 |
| 2010-12-16 11:30:00 | AAPL | Stock | 11.4745 | 11.4946 | 11.4721 | 11.4934 | 18057452.0 |
| 2010-12-16 12:00:00 | AAPL | Stock | 11.4932 | 11.4946 | 11.4871 | 11.4879 | 11030292.0 |
| 2010-12-16 12:30:00 | AAPL | Stock | 11.4879 | 11.5218 | 11.4857 | 11.5132 | 22363712.0 |
| 2010-12-16 13:00:00 | AAPL | Stock | 11.5132 | 11.5171 | 11.4904 | 11.4921 | 16991660.0 |
| 2010-12-16 13:30:00 | AAPL | Stock | 11.4921 | 11.5059 | 11.4793 | 11.4836 | 18569236.0 |
| 2010-12-16 14:00:00 | AAPL | Stock | 11.4854 | 11.4929 | 11.4804 | 11.4864 | 10682336.0 |
| 2010-12-16 14:30:00 | AAPL | Stock | 11.4864 | 11.4879 | 11.4739 | 11.4789 | 11761512.0 |
| 2010-12-16 15:00:00 | AAPL | Stock | 11.48 | 11.4946 | 11.4621 | 11.4746 | 19777828.0 |
| 2010-12-16 15:30:00 | AAPL | Stock | 11.475 | 11.4775 | 11.4622 | 11.4643 | 31215296.0 |
| 2010-12-16 16:00:00 | AAPL | Stock | 11.4646 | 11.49 | 11.4583 | 11.4679 | 14654080.0 |
| 2010-12-16 16:30:00 | AAPL | Stock | 11.4729 | 11.485 | 11.4684 | 11.485 | 776216.0 |
| 2010-12-16 17:00:00 | AAPL | Stock | 11.4759 | 11.4854 | 11.4646 | 11.4843 | 2638328.0 |
| 2010-12-16 17:30:00 | AAPL | Stock | 11.4843 | 11.4861 | 11.4768 | 11.4768 | 428148.0 |
| 2010-12-16 18:00:00 | AAPL | Stock | 11.4768 | 11.4814 | 11.4714 | 11.4714 | 155876.0 |
| 2010-12-16 18:30:00 | AAPL | Stock | 11.4714 | 11.4804 | 11.4714 | 11.4804 | 96320.0 |
| 2010-12-16 19:00:00 | AAPL | Stock | 11.4804 | 11.4807 | 11.4804 | 11.4807 | 30072.0 |
| 2010-12-16 19:30:00 | AAPL | Stock | 11.4814 | 11.4961 | 11.4814 | 11.4961 | 309512.0 |
| 2010-12-16 04:00:00 | MSFT | Stock | 27.7 | 27.7 | 27.7 | 27.7 | 1000.0 |
| 2010-12-16 07:00:00 | MSFT | Stock | 27.85 | 27.85 | 27.85 | 27.85 | 200.0 |
| 2010-12-16 07:30:00 | MSFT | Stock | 27.85 | 27.85 | 27.84 | 27.84 | 1200.0 |
| 2010-12-16 08:00:00 | MSFT | Stock | 27.85 | 27.93 | 27.85 | 27.9 | 10322.0 |
| 2010-12-16 08:30:00 | MSFT | Stock | 27.93 | 27.96 | 27.91 | 27.93 | 7137.0 |
| 2010-12-16 09:00:00 | MSFT | Stock | 27.92 | 27.93 | 27.77 | 27.77 | 80438.0 |
| 2010-12-16 09:30:00 | MSFT | Stock | 27.81 | 27.94 | 27.69 | 27.71 | 8841939.0 |
| 2010-12-16 10:00:00 | MSFT | Stock | 27.71 | 27.82 | 27.66 | 27.77 | 5413985.0 |
| 2010-12-16 10:30:00 | MSFT | Stock | 27.78 | 27.805 | 27.73 | 27.74 | 3119223.0 |
| 2010-12-16 11:00:00 | MSFT | Stock | 27.74 | 27.78 | 27.68 | 27.76 | 5411214.0 |
| 2010-12-16 11:30:00 | MSFT | Stock | 27.75 | 27.8 | 27.75 | 27.795 | 2287998.0 |
| 2010-12-16 12:00:00 | MSFT | Stock | 27.8 | 27.9 | 27.77 | 27.885 | 2721271.0 |
| 2010-12-16 12:30:00 | MSFT | Stock | 27.89 | 27.97 | 27.88 | 27.97 | 2611296.0 |
| 2010-12-16 13:00:00 | MSFT | Stock | 27.97 | 27.975 | 27.89 | 27.92 | 2697919.0 |
| 2010-12-16 13:30:00 | MSFT | Stock | 27.91 | 27.93 | 27.86 | 27.861 | 1643560.0 |
| 2010-12-16 14:00:00 | MSFT | Stock | 27.87 | 27.87 | 27.83 | 27.86 | 2043224.0 |
| 2010-12-16 14:30:00 | MSFT | Stock | 27.86 | 27.88 | 27.81 | 27.875 | 2739580.0 |
| 2010-12-16 15:00:00 | MSFT | Stock | 27.88 | 27.975 | 27.875 | 27.968 | 4273001.0 |
| 2010-12-16 15:30:00 | MSFT | Stock | 27.96 | 27.99 | 27.94 | 27.97 | 6295200.0 |
> showing 50 of 76,450 rows — these rows as CSV