PREVIEW / stock_5min / 2011-03-21
file: by_date/stock_5min/2011/2011-03-21.parquet size: 4.9 MB rows: 335,133 symbols: 3,531
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 |
|---|---|---|---|---|---|---|---|
| 2011-03-21 04:00:00 | AAPL | Stock | 11.8929 | 11.9446 | 11.8929 | 11.9432 | 23800.0 |
| 2011-03-21 04:05:00 | AAPL | Stock | 11.9718 | 11.9732 | 11.9718 | 11.9732 | 28000.0 |
| 2011-03-21 04:10:00 | AAPL | Stock | 11.9714 | 11.9886 | 11.9696 | 11.9886 | 16800.0 |
| 2011-03-21 04:15:00 | AAPL | Stock | 11.9911 | 11.9911 | 11.9911 | 11.9911 | 5600.0 |
| 2011-03-21 04:20:00 | AAPL | Stock | 11.9879 | 11.9911 | 11.9879 | 11.9911 | 8400.0 |
| 2011-03-21 04:25:00 | AAPL | Stock | 11.9821 | 11.9821 | 11.9821 | 11.9821 | 5600.0 |
| 2011-03-21 04:35:00 | AAPL | Stock | 11.99 | 11.99 | 11.99 | 11.99 | 5600.0 |
| 2011-03-21 04:40:00 | AAPL | Stock | 11.9911 | 11.9911 | 11.9911 | 11.9911 | 2800.0 |
| 2011-03-21 04:45:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 5600.0 |
| 2011-03-21 04:50:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 14000.0 |
| 2011-03-21 04:55:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 5600.0 |
| 2011-03-21 05:00:00 | AAPL | Stock | 11.9821 | 11.9879 | 11.97 | 11.97 | 14000.0 |
| 2011-03-21 05:05:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 8400.0 |
| 2011-03-21 05:15:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 11200.0 |
| 2011-03-21 05:25:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 14000.0 |
| 2011-03-21 05:30:00 | AAPL | Stock | 11.9929 | 11.9929 | 11.9929 | 11.9929 | 2800.0 |
| 2011-03-21 05:35:00 | AAPL | Stock | 11.9821 | 11.9821 | 11.9821 | 11.9821 | 5600.0 |
| 2011-03-21 06:05:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 8400.0 |
| 2011-03-21 06:10:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 5600.0 |
| 2011-03-21 06:15:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 8400.0 |
| 2011-03-21 06:20:00 | AAPL | Stock | 11.9857 | 12.0 | 11.9857 | 11.9882 | 14000.0 |
| 2011-03-21 06:25:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 5600.0 |
| 2011-03-21 06:35:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 2800.0 |
| 2011-03-21 06:45:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 14000.0 |
| 2011-03-21 06:55:00 | AAPL | Stock | 12.0 | 12.0 | 11.9929 | 11.9929 | 19600.0 |
| 2011-03-21 07:00:00 | AAPL | Stock | 11.9929 | 12.0 | 11.9929 | 11.9996 | 82880.0 |
| 2011-03-21 07:05:00 | AAPL | Stock | 11.9825 | 11.9843 | 11.9789 | 11.9843 | 16800.0 |
| 2011-03-21 07:10:00 | AAPL | Stock | 11.975 | 11.9821 | 11.9732 | 11.98 | 86800.0 |
| 2011-03-21 07:15:00 | AAPL | Stock | 11.9786 | 12.0 | 11.9786 | 12.0 | 248248.0 |
| 2011-03-21 07:20:00 | AAPL | Stock | 12.0 | 12.0143 | 12.0 | 12.0139 | 125244.0 |
| 2011-03-21 07:25:00 | AAPL | Stock | 12.0107 | 12.0304 | 12.0039 | 12.0179 | 125020.0 |
| 2011-03-21 07:30:00 | AAPL | Stock | 12.0182 | 12.0321 | 12.0179 | 12.0179 | 51520.0 |
| 2011-03-21 07:35:00 | AAPL | Stock | 12.0143 | 12.0143 | 12.0143 | 12.0143 | 5600.0 |
| 2011-03-21 07:40:00 | AAPL | Stock | 12.0143 | 12.0179 | 12.0107 | 12.0179 | 29400.0 |
| 2011-03-21 07:45:00 | AAPL | Stock | 12.0143 | 12.0179 | 12.0011 | 12.0107 | 53200.0 |
| 2011-03-21 07:50:00 | AAPL | Stock | 12.0107 | 12.0114 | 12.0018 | 12.0089 | 103600.0 |
| 2011-03-21 07:55:00 | AAPL | Stock | 12.01 | 12.01 | 12.0029 | 12.0096 | 28840.0 |
| 2011-03-21 08:00:00 | AAPL | Stock | 12.0036 | 12.0179 | 11.9893 | 11.9929 | 591388.0 |
| 2011-03-21 08:05:00 | AAPL | Stock | 11.9986 | 12.0071 | 11.9986 | 12.0068 | 165844.0 |
| 2011-03-21 08:10:00 | AAPL | Stock | 12.005 | 12.0075 | 12.0 | 12.0 | 264264.0 |
| 2011-03-21 08:15:00 | AAPL | Stock | 12.0 | 12.005 | 11.9839 | 11.9868 | 176512.0 |
| 2011-03-21 08:20:00 | AAPL | Stock | 11.9854 | 11.9886 | 11.9718 | 11.985 | 297220.0 |
| 2011-03-21 08:25:00 | AAPL | Stock | 11.985 | 11.9893 | 11.975 | 11.9804 | 194208.0 |
| 2011-03-21 08:30:00 | AAPL | Stock | 11.98 | 11.9821 | 11.9643 | 11.9686 | 301448.0 |
| 2011-03-21 08:35:00 | AAPL | Stock | 11.97 | 11.9886 | 11.97 | 11.9786 | 605668.0 |
| 2011-03-21 08:40:00 | AAPL | Stock | 11.9757 | 11.9843 | 11.975 | 11.9843 | 93324.0 |
| 2011-03-21 08:45:00 | AAPL | Stock | 11.9843 | 11.9918 | 11.9793 | 11.9857 | 257824.0 |
| 2011-03-21 08:50:00 | AAPL | Stock | 11.9832 | 11.9857 | 11.975 | 11.9818 | 313600.0 |
| 2011-03-21 08:55:00 | AAPL | Stock | 11.9786 | 11.9875 | 11.9786 | 11.9821 | 173460.0 |
| 2011-03-21 09:00:00 | AAPL | Stock | 11.9836 | 11.9839 | 11.9732 | 11.9732 | 90496.0 |
> showing 50 of 335,133 rows — these rows as CSV