PREVIEW / stock_30min / 2010-09-02
file: by_date/stock_30min/2010/2010-09-02.parquet size: 1.3 MB rows: 73,901 symbols: 3,455
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-09-02 04:00:00 | AAPL | Stock | 8.9729 | 8.9729 | 8.9729 | 8.9729 | 5600.0 |
| 2010-09-02 07:00:00 | AAPL | Stock | 8.9643 | 8.9875 | 8.9418 | 8.9786 | 111300.0 |
| 2010-09-02 07:30:00 | AAPL | Stock | 8.9868 | 8.9871 | 8.9464 | 8.9554 | 126000.0 |
| 2010-09-02 08:00:00 | AAPL | Stock | 8.9504 | 8.9696 | 8.9468 | 8.9568 | 932708.0 |
| 2010-09-02 08:30:00 | AAPL | Stock | 8.9554 | 9.0246 | 8.9554 | 9.0071 | 4466644.0 |
| 2010-09-02 09:00:00 | AAPL | Stock | 9.0054 | 9.0054 | 8.9761 | 8.9761 | 2013620.0 |
| 2010-09-02 09:30:00 | AAPL | Stock | 8.9754 | 8.9786 | 8.9054 | 8.9279 | 73493616.0 |
| 2010-09-02 10:00:00 | AAPL | Stock | 8.9286 | 8.9546 | 8.8775 | 8.9175 | 64346548.0 |
| 2010-09-02 10:30:00 | AAPL | Stock | 8.9182 | 8.9543 | 8.9054 | 8.9393 | 30952544.0 |
| 2010-09-02 11:00:00 | AAPL | Stock | 8.9386 | 8.9471 | 8.9179 | 8.9214 | 20877136.0 |
| 2010-09-02 11:30:00 | AAPL | Stock | 8.9211 | 8.9411 | 8.9129 | 8.935 | 14726096.0 |
| 2010-09-02 12:00:00 | AAPL | Stock | 8.9336 | 8.9529 | 8.9332 | 8.95 | 20982612.0 |
| 2010-09-02 12:30:00 | AAPL | Stock | 8.9504 | 8.9518 | 8.9225 | 8.9325 | 16376136.0 |
| 2010-09-02 13:00:00 | AAPL | Stock | 8.9325 | 8.9375 | 8.925 | 8.9296 | 10576664.0 |
| 2010-09-02 13:30:00 | AAPL | Stock | 8.9293 | 8.9454 | 8.9275 | 8.9446 | 11214336.0 |
| 2010-09-02 14:00:00 | AAPL | Stock | 8.9446 | 8.9704 | 8.9418 | 8.955 | 33035044.0 |
| 2010-09-02 14:30:00 | AAPL | Stock | 8.9559 | 8.9718 | 8.9543 | 8.965 | 17995096.0 |
| 2010-09-02 15:00:00 | AAPL | Stock | 8.9646 | 8.9861 | 8.9582 | 8.9786 | 27739516.0 |
| 2010-09-02 15:30:00 | AAPL | Stock | 8.9796 | 9.0061 | 8.9732 | 9.0061 | 52667972.0 |
| 2010-09-02 16:00:00 | AAPL | Stock | 9.0014 | 9.0071 | 8.9433 | 9.0054 | 7521668.0 |
| 2010-09-02 16:30:00 | AAPL | Stock | 9.0057 | 9.0075 | 8.9621 | 9.0054 | 394660.0 |
| 2010-09-02 17:00:00 | AAPL | Stock | 9.0054 | 9.0079 | 9.0036 | 9.0036 | 1361920.0 |
| 2010-09-02 17:30:00 | AAPL | Stock | 9.0039 | 9.0071 | 9.0039 | 9.0071 | 77448.0 |
| 2010-09-02 18:00:00 | AAPL | Stock | 9.0064 | 9.0125 | 9.0061 | 9.0125 | 272384.0 |
| 2010-09-02 18:30:00 | AAPL | Stock | 9.0125 | 9.0168 | 9.0111 | 9.0168 | 153552.0 |
| 2010-09-02 19:00:00 | AAPL | Stock | 9.0143 | 9.0168 | 9.0111 | 9.0111 | 83720.0 |
| 2010-09-02 19:30:00 | AAPL | Stock | 9.0107 | 9.0107 | 9.0 | 9.0057 | 307860.0 |
| 2010-09-02 07:00:00 | MSFT | Stock | 23.88 | 23.88 | 23.88 | 23.88 | 1000.0 |
| 2010-09-02 07:30:00 | MSFT | Stock | 23.9 | 23.9 | 23.9 | 23.9 | 100.0 |
| 2010-09-02 08:00:00 | MSFT | Stock | 23.91 | 23.93 | 23.91 | 23.93 | 1000.0 |
| 2010-09-02 08:30:00 | MSFT | Stock | 23.97 | 23.99 | 23.97 | 23.99 | 8951.0 |
| 2010-09-02 09:00:00 | MSFT | Stock | 23.99 | 23.99 | 23.84 | 23.85 | 51585.0 |
| 2010-09-02 09:30:00 | MSFT | Stock | 23.89 | 23.9 | 23.71 | 23.88 | 5401796.0 |
| 2010-09-02 10:00:00 | MSFT | Stock | 23.88 | 23.95 | 23.805 | 23.855 | 3757064.0 |
| 2010-09-02 10:30:00 | MSFT | Stock | 23.855 | 23.91 | 23.84 | 23.901 | 2521022.0 |
| 2010-09-02 11:00:00 | MSFT | Stock | 23.91 | 23.94 | 23.86 | 23.87 | 3069760.0 |
| 2010-09-02 11:30:00 | MSFT | Stock | 23.87 | 23.91 | 23.86 | 23.89 | 2292003.0 |
| 2010-09-02 12:00:00 | MSFT | Stock | 23.895 | 23.9 | 23.85 | 23.88 | 2571755.0 |
| 2010-09-02 12:30:00 | MSFT | Stock | 23.88 | 23.9 | 23.84 | 23.864 | 2751101.0 |
| 2010-09-02 13:00:00 | MSFT | Stock | 23.86 | 23.92 | 23.86 | 23.895 | 1737678.0 |
| 2010-09-02 13:30:00 | MSFT | Stock | 23.895 | 23.91 | 23.84 | 23.895 | 2867519.0 |
| 2010-09-02 14:00:00 | MSFT | Stock | 23.895 | 23.94 | 23.88 | 23.94 | 3802107.0 |
| 2010-09-02 14:30:00 | MSFT | Stock | 23.94 | 23.94 | 23.88 | 23.905 | 1949516.0 |
| 2010-09-02 15:00:00 | MSFT | Stock | 23.91 | 23.92 | 23.89 | 23.895 | 4569398.0 |
| 2010-09-02 15:30:00 | MSFT | Stock | 23.9 | 23.93 | 23.89 | 23.92 | 8607167.0 |
| 2010-09-02 16:00:00 | MSFT | Stock | 23.94 | 23.95 | 23.87 | 23.94 | 2043085.0 |
| 2010-09-02 16:30:00 | MSFT | Stock | 23.94 | 23.95 | 23.91 | 23.91 | 33300.0 |
| 2010-09-02 17:00:00 | MSFT | Stock | 23.94 | 23.94 | 23.93 | 23.93 | 111538.0 |
| 2010-09-02 17:30:00 | MSFT | Stock | 23.94 | 23.95 | 23.94 | 23.94 | 5245.0 |
| 2010-09-02 18:00:00 | MSFT | Stock | 23.97 | 23.97 | 23.94 | 23.96 | 40352.0 |
> showing 50 of 73,901 rows — these rows as CSV