PREVIEW / stock_5min / 2010-02-24
file: by_date/stock_5min/2010/2010-02-24.parquet size: 4.6 MB rows: 318,178 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-02-24 04:15:00 | AAPL | Stock | 7.0432 | 7.0432 | 7.0368 | 7.0368 | 9408.0 |
| 2010-02-24 04:20:00 | AAPL | Stock | 7.0314 | 7.0314 | 7.0289 | 7.0289 | 5600.0 |
| 2010-02-24 04:30:00 | AAPL | Stock | 7.0261 | 7.0261 | 7.0261 | 7.0261 | 5600.0 |
| 2010-02-24 04:45:00 | AAPL | Stock | 7.0207 | 7.0207 | 7.0154 | 7.0154 | 8400.0 |
| 2010-02-24 05:15:00 | AAPL | Stock | 7.0261 | 7.0261 | 7.0261 | 7.0261 | 5600.0 |
| 2010-02-24 05:20:00 | AAPL | Stock | 7.0314 | 7.0314 | 7.0314 | 7.0314 | 2800.0 |
| 2010-02-24 06:25:00 | AAPL | Stock | 7.0357 | 7.0368 | 7.0357 | 7.0368 | 8400.0 |
| 2010-02-24 06:30:00 | AAPL | Stock | 7.0357 | 7.0357 | 7.0357 | 7.0357 | 2800.0 |
| 2010-02-24 06:50:00 | AAPL | Stock | 7.0432 | 7.0432 | 7.0432 | 7.0432 | 2800.0 |
| 2010-02-24 06:55:00 | AAPL | Stock | 7.0318 | 7.0529 | 7.0318 | 7.0529 | 11200.0 |
| 2010-02-24 07:00:00 | AAPL | Stock | 7.0571 | 7.0571 | 7.0571 | 7.0571 | 25844.0 |
| 2010-02-24 07:05:00 | AAPL | Stock | 7.0575 | 7.0582 | 7.0575 | 7.0582 | 8400.0 |
| 2010-02-24 07:10:00 | AAPL | Stock | 7.0636 | 7.0636 | 7.0636 | 7.0636 | 2800.0 |
| 2010-02-24 07:25:00 | AAPL | Stock | 7.0679 | 7.0793 | 7.0679 | 7.0793 | 109228.0 |
| 2010-02-24 07:30:00 | AAPL | Stock | 7.0714 | 7.0804 | 7.0714 | 7.0804 | 35000.0 |
| 2010-02-24 07:35:00 | AAPL | Stock | 7.08 | 7.08 | 7.08 | 7.08 | 22400.0 |
| 2010-02-24 07:40:00 | AAPL | Stock | 7.0736 | 7.075 | 7.0657 | 7.075 | 186760.0 |
| 2010-02-24 07:45:00 | AAPL | Stock | 7.075 | 7.075 | 7.0746 | 7.0746 | 55160.0 |
| 2010-02-24 07:50:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0689 | 7.0714 | 221200.0 |
| 2010-02-24 07:55:00 | AAPL | Stock | 7.0711 | 7.0711 | 7.0679 | 7.0679 | 23520.0 |
| 2010-02-24 08:00:00 | AAPL | Stock | 7.0636 | 7.0693 | 7.0607 | 7.0671 | 85120.0 |
| 2010-02-24 08:05:00 | AAPL | Stock | 7.0675 | 7.0704 | 7.0654 | 7.07 | 197400.0 |
| 2010-02-24 08:10:00 | AAPL | Stock | 7.0704 | 7.0754 | 7.0704 | 7.0714 | 370664.0 |
| 2010-02-24 08:15:00 | AAPL | Stock | 7.0714 | 7.075 | 7.0704 | 7.0732 | 203280.0 |
| 2010-02-24 08:20:00 | AAPL | Stock | 7.0732 | 7.0743 | 7.0707 | 7.0714 | 142492.0 |
| 2010-02-24 08:25:00 | AAPL | Stock | 7.0714 | 7.0761 | 7.0714 | 7.0718 | 196000.0 |
| 2010-02-24 08:30:00 | AAPL | Stock | 7.0721 | 7.0736 | 7.0714 | 7.0736 | 44240.0 |
| 2010-02-24 08:35:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0714 | 7.0714 | 78820.0 |
| 2010-02-24 08:40:00 | AAPL | Stock | 7.0707 | 7.0707 | 7.0661 | 7.0675 | 190764.0 |
| 2010-02-24 08:45:00 | AAPL | Stock | 7.0671 | 7.0739 | 7.0671 | 7.0679 | 80304.0 |
| 2010-02-24 08:50:00 | AAPL | Stock | 7.0693 | 7.075 | 7.0693 | 7.0729 | 79268.0 |
| 2010-02-24 08:55:00 | AAPL | Stock | 7.0729 | 7.075 | 7.0729 | 7.075 | 134540.0 |
| 2010-02-24 09:00:00 | AAPL | Stock | 7.0721 | 7.0725 | 7.0721 | 7.0721 | 15400.0 |
| 2010-02-24 09:05:00 | AAPL | Stock | 7.0721 | 7.0729 | 7.0689 | 7.0689 | 159544.0 |
| 2010-02-24 09:10:00 | AAPL | Stock | 7.0696 | 7.0696 | 7.0643 | 7.0643 | 121800.0 |
| 2010-02-24 09:15:00 | AAPL | Stock | 7.0679 | 7.0679 | 7.0661 | 7.0679 | 28000.0 |
| 2010-02-24 09:20:00 | AAPL | Stock | 7.0682 | 7.0682 | 7.0679 | 7.0679 | 19544.0 |
| 2010-02-24 09:25:00 | AAPL | Stock | 7.0686 | 7.0804 | 7.0686 | 7.08 | 550200.0 |
| 2010-02-24 09:30:00 | AAPL | Stock | 7.0796 | 7.1071 | 7.0657 | 7.0961 | 19333580.0 |
| 2010-02-24 09:35:00 | AAPL | Stock | 7.0957 | 7.1121 | 7.0914 | 7.0986 | 13012972.0 |
| 2010-02-24 09:40:00 | AAPL | Stock | 7.0989 | 7.1121 | 7.0929 | 7.1039 | 10380776.0 |
| 2010-02-24 09:45:00 | AAPL | Stock | 7.1024 | 7.1239 | 7.1024 | 7.1225 | 13244644.0 |
| 2010-02-24 09:50:00 | AAPL | Stock | 7.1225 | 7.1375 | 7.1018 | 7.131 | 12352760.0 |
| 2010-02-24 09:55:00 | AAPL | Stock | 7.1314 | 7.1354 | 7.1211 | 7.1289 | 6547744.0 |
| 2010-02-24 10:00:00 | AAPL | Stock | 7.1282 | 7.1429 | 7.1161 | 7.135 | 17662232.0 |
| 2010-02-24 10:05:00 | AAPL | Stock | 7.1342 | 7.1342 | 7.1039 | 7.1071 | 15346128.0 |
| 2010-02-24 10:10:00 | AAPL | Stock | 7.1075 | 7.1246 | 7.1046 | 7.12 | 8847384.0 |
| 2010-02-24 10:15:00 | AAPL | Stock | 7.1207 | 7.1229 | 7.1075 | 7.1086 | 7106120.0 |
| 2010-02-24 10:20:00 | AAPL | Stock | 7.1079 | 7.1196 | 7.1021 | 7.1142 | 5525100.0 |
| 2010-02-24 10:25:00 | AAPL | Stock | 7.1143 | 7.1293 | 7.1121 | 7.1214 | 5739048.0 |
> showing 50 of 318,178 rows — these rows as CSV