PREVIEW / stock_5min / 2006-11-13
file: by_date/stock_5min/2006/2006-11-13.parquet size: 3.2 MB rows: 236,782 symbols: 2,448
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-13 08:00:00 | AAPL | Stock | 2.9704 | 2.9732 | 2.9696 | 2.9707 | 66668.0 |
| 2006-11-13 08:05:00 | AAPL | Stock | 2.9732 | 2.9764 | 2.9732 | 2.9764 | 109200.0 |
| 2006-11-13 08:10:00 | AAPL | Stock | 2.9761 | 2.9761 | 2.9711 | 2.9711 | 47600.0 |
| 2006-11-13 08:15:00 | AAPL | Stock | 2.9714 | 2.9714 | 2.9696 | 2.9696 | 91000.0 |
| 2006-11-13 08:20:00 | AAPL | Stock | 2.9714 | 2.9714 | 2.9714 | 2.9714 | 89600.0 |
| 2006-11-13 08:25:00 | AAPL | Stock | 2.9696 | 2.9696 | 2.9689 | 2.9689 | 51800.0 |
| 2006-11-13 08:30:00 | AAPL | Stock | 2.9689 | 2.9689 | 2.9689 | 2.9689 | 2800.0 |
| 2006-11-13 08:35:00 | AAPL | Stock | 2.9689 | 2.9693 | 2.9689 | 2.9693 | 42896.0 |
| 2006-11-13 08:40:00 | AAPL | Stock | 2.9704 | 2.9714 | 2.9704 | 2.9714 | 11200.0 |
| 2006-11-13 08:45:00 | AAPL | Stock | 2.9732 | 2.9732 | 2.9732 | 2.9732 | 81200.0 |
| 2006-11-13 08:50:00 | AAPL | Stock | 2.9707 | 2.9707 | 2.9686 | 2.9686 | 20104.0 |
| 2006-11-13 08:55:00 | AAPL | Stock | 2.9696 | 2.9696 | 2.9696 | 2.9696 | 8904.0 |
| 2006-11-13 09:00:00 | AAPL | Stock | 2.9696 | 2.9696 | 2.9696 | 2.9696 | 28000.0 |
| 2006-11-13 09:10:00 | AAPL | Stock | 2.9696 | 2.9696 | 2.9696 | 2.9696 | 142800.0 |
| 2006-11-13 09:15:00 | AAPL | Stock | 2.9696 | 2.9696 | 2.9693 | 2.9693 | 19600.0 |
| 2006-11-13 09:20:00 | AAPL | Stock | 2.9689 | 2.9693 | 2.9689 | 2.9693 | 33600.0 |
| 2006-11-13 09:25:00 | AAPL | Stock | 2.9664 | 2.9721 | 2.9646 | 2.9721 | 136304.0 |
| 2006-11-13 09:30:00 | AAPL | Stock | 2.9732 | 2.9754 | 2.9514 | 2.9546 | 12260892.0 |
| 2006-11-13 09:35:00 | AAPL | Stock | 2.9546 | 2.9657 | 2.9525 | 2.9639 | 8500800.0 |
| 2006-11-13 09:40:00 | AAPL | Stock | 2.9639 | 2.9821 | 2.9625 | 2.9743 | 12039664.0 |
| 2006-11-13 09:45:00 | AAPL | Stock | 2.975 | 2.9779 | 2.9707 | 2.9743 | 8353436.0 |
| 2006-11-13 09:50:00 | AAPL | Stock | 2.9743 | 2.9793 | 2.9732 | 2.9789 | 4980556.0 |
| 2006-11-13 09:55:00 | AAPL | Stock | 2.9786 | 2.9911 | 2.9768 | 2.9893 | 11507832.0 |
| 2006-11-13 10:00:00 | AAPL | Stock | 2.9886 | 2.9996 | 2.9864 | 2.999 | 11216156.0 |
| 2006-11-13 10:05:00 | AAPL | Stock | 2.9993 | 2.9996 | 2.9915 | 2.9957 | 8351672.0 |
| 2006-11-13 10:10:00 | AAPL | Stock | 2.9957 | 3.0096 | 2.995 | 3.0032 | 13408612.0 |
| 2006-11-13 10:15:00 | AAPL | Stock | 3.0036 | 3.0107 | 3.0007 | 3.0011 | 9294544.0 |
| 2006-11-13 10:20:00 | AAPL | Stock | 3.0014 | 3.0029 | 2.9975 | 2.9979 | 7702184.0 |
| 2006-11-13 10:25:00 | AAPL | Stock | 2.9979 | 3.0 | 2.9968 | 2.9989 | 5468764.0 |
| 2006-11-13 10:30:00 | AAPL | Stock | 2.9989 | 3.0 | 2.9975 | 2.9982 | 4310768.0 |
| 2006-11-13 10:35:00 | AAPL | Stock | 2.9982 | 3.0032 | 2.9975 | 3.0025 | 5143264.0 |
| 2006-11-13 10:40:00 | AAPL | Stock | 3.0025 | 3.0029 | 2.9979 | 3.0 | 3601948.0 |
| 2006-11-13 10:45:00 | AAPL | Stock | 2.9993 | 3.0018 | 2.9979 | 3.0014 | 3762640.0 |
| 2006-11-13 10:50:00 | AAPL | Stock | 3.0018 | 3.0029 | 2.9979 | 3.0018 | 3713696.0 |
| 2006-11-13 10:55:00 | AAPL | Stock | 3.0018 | 3.0025 | 2.995 | 2.9964 | 5293484.0 |
| 2006-11-13 11:00:00 | AAPL | Stock | 2.9964 | 3.0054 | 2.9964 | 3.0004 | 4588500.0 |
| 2006-11-13 11:05:00 | AAPL | Stock | 3.0011 | 3.0018 | 2.9964 | 2.9982 | 3530828.0 |
| 2006-11-13 11:10:00 | AAPL | Stock | 2.9986 | 3.0014 | 2.9975 | 3.0012 | 2115036.0 |
| 2006-11-13 11:15:00 | AAPL | Stock | 3.0011 | 3.0032 | 2.9982 | 3.0014 | 3234644.0 |
| 2006-11-13 11:20:00 | AAPL | Stock | 3.0014 | 3.0046 | 2.9986 | 3.0043 | 4296572.0 |
| 2006-11-13 11:25:00 | AAPL | Stock | 3.0039 | 3.0054 | 3.0 | 3.0043 | 5756212.0 |
| 2006-11-13 11:30:00 | AAPL | Stock | 3.0043 | 3.0104 | 3.0039 | 3.0089 | 7875868.0 |
| 2006-11-13 11:35:00 | AAPL | Stock | 3.0093 | 3.0161 | 3.0057 | 3.0139 | 9817276.0 |
| 2006-11-13 11:40:00 | AAPL | Stock | 3.0139 | 3.0143 | 3.0081 | 3.0111 | 9200856.0 |
| 2006-11-13 11:45:00 | AAPL | Stock | 3.0111 | 3.0111 | 3.0039 | 3.0089 | 7710948.0 |
| 2006-11-13 11:50:00 | AAPL | Stock | 3.0086 | 3.0125 | 3.0036 | 3.0089 | 5525912.0 |
| 2006-11-13 11:55:00 | AAPL | Stock | 3.0093 | 3.0107 | 3.007 | 3.007 | 3668336.0 |
| 2006-11-13 12:00:00 | AAPL | Stock | 3.0071 | 3.0086 | 2.9996 | 2.9996 | 6598844.0 |
| 2006-11-13 12:05:00 | AAPL | Stock | 3.0 | 3.0018 | 2.9975 | 3.0018 | 4393536.0 |
| 2006-11-13 12:10:00 | AAPL | Stock | 3.0015 | 3.0057 | 2.9993 | 3.0024 | 3535840.0 |
> showing 50 of 236,782 rows — these rows as CSV