PREVIEW / stock_5min / 2012-03-07
file: by_date/stock_5min/2012/2012-03-07.parquet size: 4.8 MB rows: 322,953 symbols: 3,503
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 |
|---|---|---|---|---|---|---|---|
| 2012-03-07 04:00:00 | AAPL | Stock | 19.0129 | 19.0129 | 19.0129 | 19.0129 | 2800.0 |
| 2012-03-07 04:05:00 | AAPL | Stock | 19.0296 | 19.0429 | 19.0268 | 19.0268 | 40600.0 |
| 2012-03-07 04:10:00 | AAPL | Stock | 19.0164 | 19.0164 | 19.0164 | 19.0164 | 2800.0 |
| 2012-03-07 04:15:00 | AAPL | Stock | 19.0193 | 19.0193 | 19.0193 | 19.0193 | 2800.0 |
| 2012-03-07 04:20:00 | AAPL | Stock | 19.0357 | 19.0429 | 19.0357 | 19.0357 | 18200.0 |
| 2012-03-07 04:40:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 6860.0 |
| 2012-03-07 04:45:00 | AAPL | Stock | 19.025 | 19.025 | 19.025 | 19.025 | 8400.0 |
| 2012-03-07 05:05:00 | AAPL | Stock | 19.0286 | 19.0286 | 19.0286 | 19.0286 | 5600.0 |
| 2012-03-07 05:10:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.0357 | 19.0357 | 8400.0 |
| 2012-03-07 05:20:00 | AAPL | Stock | 19.0407 | 19.0429 | 19.0407 | 19.0429 | 11200.0 |
| 2012-03-07 05:40:00 | AAPL | Stock | 19.0679 | 19.0679 | 19.0679 | 19.0679 | 19600.0 |
| 2012-03-07 05:50:00 | AAPL | Stock | 19.0679 | 19.1393 | 19.0679 | 19.1393 | 36400.0 |
| 2012-03-07 05:55:00 | AAPL | Stock | 19.0571 | 19.0571 | 19.0571 | 19.0571 | 8400.0 |
| 2012-03-07 06:25:00 | AAPL | Stock | 19.0625 | 19.0625 | 19.0536 | 19.0536 | 34412.0 |
| 2012-03-07 06:30:00 | AAPL | Stock | 19.0568 | 19.0568 | 19.0568 | 19.0568 | 12684.0 |
| 2012-03-07 06:40:00 | AAPL | Stock | 19.0536 | 19.0536 | 19.0357 | 19.0536 | 88340.0 |
| 2012-03-07 06:45:00 | AAPL | Stock | 19.0536 | 19.0536 | 19.0536 | 19.0536 | 7700.0 |
| 2012-03-07 06:50:00 | AAPL | Stock | 19.0536 | 19.0536 | 19.0464 | 19.0536 | 21000.0 |
| 2012-03-07 06:55:00 | AAPL | Stock | 19.0536 | 19.0536 | 19.0536 | 19.0536 | 42000.0 |
| 2012-03-07 07:00:00 | AAPL | Stock | 19.0411 | 19.0639 | 19.0393 | 19.0639 | 78960.0 |
| 2012-03-07 07:05:00 | AAPL | Stock | 19.0643 | 19.0686 | 19.055 | 19.0675 | 75600.0 |
| 2012-03-07 07:10:00 | AAPL | Stock | 19.0643 | 19.0668 | 19.045 | 19.045 | 57820.0 |
| 2012-03-07 07:15:00 | AAPL | Stock | 19.0607 | 19.0607 | 19.0536 | 19.0536 | 29400.0 |
| 2012-03-07 07:20:00 | AAPL | Stock | 19.0536 | 19.0596 | 19.0536 | 19.0596 | 11200.0 |
| 2012-03-07 07:25:00 | AAPL | Stock | 19.0607 | 19.0607 | 19.0554 | 19.0554 | 69608.0 |
| 2012-03-07 07:30:00 | AAPL | Stock | 19.0568 | 19.0657 | 19.0529 | 19.0639 | 117852.0 |
| 2012-03-07 07:35:00 | AAPL | Stock | 19.0679 | 19.0714 | 19.0643 | 19.0696 | 183400.0 |
| 2012-03-07 07:40:00 | AAPL | Stock | 19.0696 | 19.0714 | 19.0571 | 19.0571 | 138964.0 |
| 2012-03-07 07:45:00 | AAPL | Stock | 19.05 | 19.0539 | 19.0464 | 19.05 | 85120.0 |
| 2012-03-07 07:50:00 | AAPL | Stock | 19.0536 | 19.0536 | 19.0357 | 19.0461 | 130256.0 |
| 2012-03-07 07:55:00 | AAPL | Stock | 19.0461 | 19.0482 | 19.0361 | 19.0464 | 121464.0 |
| 2012-03-07 08:00:00 | AAPL | Stock | 19.0482 | 19.0714 | 19.0357 | 19.0696 | 978264.0 |
| 2012-03-07 08:05:00 | AAPL | Stock | 19.0464 | 19.0875 | 18.975 | 19.0793 | 554484.0 |
| 2012-03-07 08:10:00 | AAPL | Stock | 19.0818 | 19.0996 | 19.0818 | 19.0971 | 498736.0 |
| 2012-03-07 08:15:00 | AAPL | Stock | 19.1004 | 19.1143 | 19.0964 | 19.1071 | 1363432.0 |
| 2012-03-07 08:20:00 | AAPL | Stock | 19.1057 | 19.1175 | 19.0911 | 19.1175 | 846720.0 |
| 2012-03-07 08:25:00 | AAPL | Stock | 19.1171 | 19.1196 | 19.1071 | 19.1079 | 836136.0 |
| 2012-03-07 08:30:00 | AAPL | Stock | 19.1107 | 19.1214 | 19.1071 | 19.1179 | 875588.0 |
| 2012-03-07 08:35:00 | AAPL | Stock | 19.1186 | 19.1307 | 19.1161 | 19.1282 | 660744.0 |
| 2012-03-07 08:40:00 | AAPL | Stock | 19.1268 | 19.1361 | 19.1221 | 19.1361 | 1188544.0 |
| 2012-03-07 08:45:00 | AAPL | Stock | 19.1361 | 19.1507 | 19.1357 | 19.1375 | 649880.0 |
| 2012-03-07 08:50:00 | AAPL | Stock | 19.14 | 19.15 | 19.1361 | 19.15 | 756224.0 |
| 2012-03-07 08:55:00 | AAPL | Stock | 19.15 | 19.15 | 19.1304 | 19.1436 | 603036.0 |
| 2012-03-07 09:00:00 | AAPL | Stock | 19.1432 | 19.175 | 19.1432 | 19.1696 | 768656.0 |
| 2012-03-07 09:05:00 | AAPL | Stock | 19.1664 | 19.1786 | 19.155 | 19.1604 | 851928.0 |
| 2012-03-07 09:10:00 | AAPL | Stock | 19.155 | 19.1582 | 19.1243 | 19.1332 | 1243844.0 |
| 2012-03-07 09:15:00 | AAPL | Stock | 19.1229 | 19.1314 | 19.1075 | 19.1143 | 843920.0 |
| 2012-03-07 09:20:00 | AAPL | Stock | 19.1179 | 19.1343 | 19.1071 | 19.1343 | 717444.0 |
| 2012-03-07 09:25:00 | AAPL | Stock | 19.1343 | 19.1786 | 19.1236 | 19.1611 | 2039492.0 |
| 2012-03-07 09:30:00 | AAPL | Stock | 19.1711 | 19.2064 | 19.0568 | 19.105 | 29285984.0 |
> showing 50 of 322,953 rows — these rows as CSV