PREVIEW / stock_30min / 2010-10-26
file: by_date/stock_30min/2010/2010-10-26.parquet size: 1.4 MB rows: 75,891 symbols: 3,478
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-10-26 04:00:00 | AAPL | Stock | 10.9829 | 10.9829 | 10.9829 | 10.9829 | 2800.0 |
| 2010-10-26 04:30:00 | AAPL | Stock | 10.9786 | 10.9786 | 10.9782 | 10.9782 | 5600.0 |
| 2010-10-26 05:00:00 | AAPL | Stock | 10.9586 | 10.9704 | 10.9586 | 10.9704 | 8400.0 |
| 2010-10-26 06:00:00 | AAPL | Stock | 10.9821 | 10.9821 | 10.9714 | 10.9714 | 11200.0 |
| 2010-10-26 06:30:00 | AAPL | Stock | 10.9714 | 10.9729 | 10.9714 | 10.9729 | 8400.0 |
| 2010-10-26 07:00:00 | AAPL | Stock | 10.9736 | 10.9918 | 10.9736 | 10.9911 | 93240.0 |
| 2010-10-26 07:30:00 | AAPL | Stock | 10.9893 | 11.0 | 10.9729 | 10.9729 | 134400.0 |
| 2010-10-26 08:00:00 | AAPL | Stock | 10.9821 | 10.9957 | 10.9611 | 10.9739 | 1011192.0 |
| 2010-10-26 08:30:00 | AAPL | Stock | 10.9757 | 10.9832 | 10.9732 | 10.9764 | 426580.0 |
| 2010-10-26 09:00:00 | AAPL | Stock | 10.9764 | 10.9786 | 10.945 | 10.9639 | 1941072.0 |
| 2010-10-26 09:30:00 | AAPL | Stock | 10.9639 | 10.9714 | 10.9161 | 10.9432 | 74488484.0 |
| 2010-10-26 10:00:00 | AAPL | Stock | 10.9411 | 11.0425 | 10.9411 | 11.0206 | 58649640.0 |
| 2010-10-26 10:30:00 | AAPL | Stock | 11.0205 | 11.0464 | 11.015 | 11.0364 | 33065396.0 |
| 2010-10-26 11:00:00 | AAPL | Stock | 11.0368 | 11.0621 | 11.0096 | 11.0493 | 29767864.0 |
| 2010-10-26 11:30:00 | AAPL | Stock | 11.0475 | 11.0586 | 11.0357 | 11.0504 | 18663428.0 |
| 2010-10-26 12:00:00 | AAPL | Stock | 11.0504 | 11.0568 | 11.0364 | 11.0421 | 16000908.0 |
| 2010-10-26 12:30:00 | AAPL | Stock | 11.0444 | 11.0486 | 11.025 | 11.0368 | 10277540.0 |
| 2010-10-26 13:00:00 | AAPL | Stock | 11.0371 | 11.0471 | 11.0 | 11.0004 | 23251928.0 |
| 2010-10-26 13:30:00 | AAPL | Stock | 11.0 | 11.0193 | 10.9814 | 10.9914 | 17612616.0 |
| 2010-10-26 14:00:00 | AAPL | Stock | 10.9889 | 11.0075 | 10.98 | 11.0064 | 15695176.0 |
| 2010-10-26 14:30:00 | AAPL | Stock | 11.0064 | 11.0175 | 10.995 | 11.0004 | 13599348.0 |
| 2010-10-26 15:00:00 | AAPL | Stock | 11.0007 | 11.0157 | 10.9832 | 10.995 | 22545796.0 |
| 2010-10-26 15:30:00 | AAPL | Stock | 10.9954 | 11.0086 | 10.9857 | 11.0021 | 27452740.0 |
| 2010-10-26 16:00:00 | AAPL | Stock | 11.0018 | 11.0415 | 10.9551 | 10.9979 | 17340148.0 |
| 2010-10-26 16:30:00 | AAPL | Stock | 10.9986 | 10.9993 | 10.9714 | 10.9786 | 1346688.0 |
| 2010-10-26 17:00:00 | AAPL | Stock | 10.9696 | 10.9761 | 10.9596 | 10.9682 | 1727096.0 |
| 2010-10-26 17:30:00 | AAPL | Stock | 10.9696 | 10.9739 | 10.9661 | 10.9707 | 720496.0 |
| 2010-10-26 18:00:00 | AAPL | Stock | 10.9711 | 11.0018 | 10.9621 | 10.9807 | 1323896.0 |
| 2010-10-26 18:30:00 | AAPL | Stock | 10.9907 | 10.9911 | 10.9875 | 10.9879 | 64008.0 |
| 2010-10-26 19:00:00 | AAPL | Stock | 10.985 | 10.985 | 10.9654 | 10.9686 | 985908.0 |
| 2010-10-26 19:30:00 | AAPL | Stock | 10.9679 | 10.9768 | 10.9654 | 10.9721 | 1075396.0 |
| 2010-10-26 04:30:00 | MSFT | Stock | 25.15 | 25.15 | 25.15 | 25.15 | 500.0 |
| 2010-10-26 07:00:00 | MSFT | Stock | 25.25 | 25.25 | 25.25 | 25.25 | 1500.0 |
| 2010-10-26 07:30:00 | MSFT | Stock | 25.19 | 25.31 | 25.18 | 25.31 | 20600.0 |
| 2010-10-26 08:00:00 | MSFT | Stock | 25.25 | 25.25 | 25.16 | 25.18 | 39382.0 |
| 2010-10-26 08:30:00 | MSFT | Stock | 25.17 | 25.24 | 25.15 | 25.16 | 45915.0 |
| 2010-10-26 09:00:00 | MSFT | Stock | 25.17 | 25.21 | 25.1 | 25.11 | 65989.0 |
| 2010-10-26 09:30:00 | MSFT | Stock | 25.12 | 25.18 | 25.06 | 25.16 | 3570216.0 |
| 2010-10-26 10:00:00 | MSFT | Stock | 25.16 | 25.38 | 25.15 | 25.355 | 4870527.0 |
| 2010-10-26 10:30:00 | MSFT | Stock | 25.36 | 25.39 | 25.3 | 25.365 | 2075261.0 |
| 2010-10-26 11:00:00 | MSFT | Stock | 25.37 | 25.42 | 25.29 | 25.4 | 5042404.0 |
| 2010-10-26 11:30:00 | MSFT | Stock | 25.4 | 25.49 | 25.37 | 25.49 | 2048676.0 |
| 2010-10-26 12:00:00 | MSFT | Stock | 25.49 | 25.64 | 25.47 | 25.55 | 4823421.0 |
| 2010-10-26 12:30:00 | MSFT | Stock | 25.55 | 25.57 | 25.51 | 25.54 | 1999352.0 |
| 2010-10-26 13:00:00 | MSFT | Stock | 25.54 | 25.62 | 25.54 | 25.6 | 2499444.0 |
| 2010-10-26 13:30:00 | MSFT | Stock | 25.6 | 25.695 | 25.58 | 25.645 | 4099511.0 |
| 2010-10-26 14:00:00 | MSFT | Stock | 25.64 | 25.75 | 25.57 | 25.73 | 4448768.0 |
| 2010-10-26 14:30:00 | MSFT | Stock | 25.73 | 25.79 | 25.65 | 25.79 | 4552445.0 |
| 2010-10-26 15:00:00 | MSFT | Stock | 25.79 | 25.9 | 25.59 | 25.895 | 7978649.0 |
| 2010-10-26 15:30:00 | MSFT | Stock | 25.9 | 25.97 | 25.88 | 25.91 | 15964702.0 |
> showing 50 of 75,891 rows — these rows as CSV