PREVIEW / stock_5min / 2010-05-14
file: by_date/stock_5min/2010/2010-05-14.parquet size: 4.9 MB rows: 336,620 symbols: 3,488
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-05-14 04:20:00 | AAPL | Stock | 9.1857 | 9.1857 | 9.1857 | 9.1857 | 2800.0 |
| 2010-05-14 04:25:00 | AAPL | Stock | 9.1829 | 9.1829 | 9.1829 | 9.1829 | 2800.0 |
| 2010-05-14 04:30:00 | AAPL | Stock | 9.1786 | 9.1786 | 9.1786 | 9.1786 | 2800.0 |
| 2010-05-14 05:00:00 | AAPL | Stock | 9.1532 | 9.1532 | 9.1532 | 9.1532 | 2800.0 |
| 2010-05-14 05:15:00 | AAPL | Stock | 9.1429 | 9.1429 | 9.1429 | 9.1429 | 3304.0 |
| 2010-05-14 05:50:00 | AAPL | Stock | 9.1179 | 9.1179 | 9.1179 | 9.1179 | 5600.0 |
| 2010-05-14 05:55:00 | AAPL | Stock | 9.1164 | 9.1164 | 9.0957 | 9.0961 | 46060.0 |
| 2010-05-14 06:00:00 | AAPL | Stock | 9.0964 | 9.0964 | 9.0964 | 9.0964 | 6580.0 |
| 2010-05-14 06:10:00 | AAPL | Stock | 9.1071 | 9.1071 | 9.1071 | 9.1071 | 19600.0 |
| 2010-05-14 06:15:00 | AAPL | Stock | 9.0893 | 9.0907 | 9.0893 | 9.0907 | 5600.0 |
| 2010-05-14 06:20:00 | AAPL | Stock | 9.1071 | 9.1071 | 9.1071 | 9.1071 | 11620.0 |
| 2010-05-14 06:35:00 | AAPL | Stock | 9.1075 | 9.1075 | 9.1075 | 9.1075 | 2800.0 |
| 2010-05-14 06:40:00 | AAPL | Stock | 9.1246 | 9.1246 | 9.1246 | 9.1246 | 11200.0 |
| 2010-05-14 06:50:00 | AAPL | Stock | 9.1079 | 9.1079 | 9.1071 | 9.1071 | 16660.0 |
| 2010-05-14 06:55:00 | AAPL | Stock | 9.1157 | 9.1161 | 9.1157 | 9.1161 | 9800.0 |
| 2010-05-14 07:00:00 | AAPL | Stock | 9.125 | 9.1411 | 9.125 | 9.1357 | 21000.0 |
| 2010-05-14 07:05:00 | AAPL | Stock | 9.1357 | 9.1604 | 9.1357 | 9.1604 | 43400.0 |
| 2010-05-14 07:10:00 | AAPL | Stock | 9.1643 | 9.1643 | 9.1643 | 9.1643 | 11200.0 |
| 2010-05-14 07:15:00 | AAPL | Stock | 9.1646 | 9.1646 | 9.1607 | 9.1643 | 28000.0 |
| 2010-05-14 07:20:00 | AAPL | Stock | 9.1671 | 9.1679 | 9.1436 | 9.1436 | 82292.0 |
| 2010-05-14 07:25:00 | AAPL | Stock | 9.1486 | 9.1536 | 9.1421 | 9.1421 | 146552.0 |
| 2010-05-14 07:30:00 | AAPL | Stock | 9.1425 | 9.1425 | 9.1179 | 9.1339 | 116200.0 |
| 2010-05-14 07:35:00 | AAPL | Stock | 9.1182 | 9.1254 | 9.1161 | 9.1243 | 332500.0 |
| 2010-05-14 07:40:00 | AAPL | Stock | 9.1404 | 9.1421 | 9.1329 | 9.1421 | 61600.0 |
| 2010-05-14 07:45:00 | AAPL | Stock | 9.1425 | 9.1496 | 9.1425 | 9.1496 | 19600.0 |
| 2010-05-14 07:50:00 | AAPL | Stock | 9.1536 | 9.1579 | 9.1393 | 9.1579 | 125580.0 |
| 2010-05-14 07:55:00 | AAPL | Stock | 9.1675 | 9.1786 | 9.1468 | 9.1721 | 180600.0 |
| 2010-05-14 08:00:00 | AAPL | Stock | 9.1718 | 9.1786 | 9.1471 | 9.1529 | 773444.0 |
| 2010-05-14 08:05:00 | AAPL | Stock | 9.1539 | 9.16 | 9.1364 | 9.1396 | 395500.0 |
| 2010-05-14 08:10:00 | AAPL | Stock | 9.1393 | 9.1493 | 9.1321 | 9.1493 | 430612.0 |
| 2010-05-14 08:15:00 | AAPL | Stock | 9.1464 | 9.1464 | 9.1357 | 9.1379 | 185080.0 |
| 2010-05-14 08:20:00 | AAPL | Stock | 9.1379 | 9.1414 | 9.1321 | 9.1414 | 366100.0 |
| 2010-05-14 08:25:00 | AAPL | Stock | 9.1411 | 9.15 | 9.1393 | 9.15 | 199640.0 |
| 2010-05-14 08:30:00 | AAPL | Stock | 9.1489 | 9.1607 | 9.1293 | 9.1293 | 585928.0 |
| 2010-05-14 08:35:00 | AAPL | Stock | 9.1321 | 9.1411 | 9.1268 | 9.1393 | 307272.0 |
| 2010-05-14 08:40:00 | AAPL | Stock | 9.1396 | 9.1518 | 9.1343 | 9.1496 | 226100.0 |
| 2010-05-14 08:45:00 | AAPL | Stock | 9.1457 | 9.15 | 9.1429 | 9.1482 | 199192.0 |
| 2010-05-14 08:50:00 | AAPL | Stock | 9.1514 | 9.1543 | 9.1468 | 9.1511 | 190708.0 |
| 2010-05-14 08:55:00 | AAPL | Stock | 9.1511 | 9.1571 | 9.1464 | 9.1491 | 340368.0 |
| 2010-05-14 09:00:00 | AAPL | Stock | 9.1479 | 9.15 | 9.1429 | 9.1429 | 313348.0 |
| 2010-05-14 09:05:00 | AAPL | Stock | 9.1429 | 9.1482 | 9.1296 | 9.1304 | 609896.0 |
| 2010-05-14 09:10:00 | AAPL | Stock | 9.1314 | 9.1314 | 9.1189 | 9.1239 | 651476.0 |
| 2010-05-14 09:15:00 | AAPL | Stock | 9.1232 | 9.1232 | 9.115 | 9.1179 | 315924.0 |
| 2010-05-14 09:20:00 | AAPL | Stock | 9.12 | 9.1243 | 9.1118 | 9.1175 | 549024.0 |
| 2010-05-14 09:25:00 | AAPL | Stock | 9.1161 | 9.1229 | 9.1143 | 9.1143 | 500080.0 |
| 2010-05-14 09:30:00 | AAPL | Stock | 9.1143 | 9.16 | 9.1071 | 9.1284 | 21969388.0 |
| 2010-05-14 09:35:00 | AAPL | Stock | 9.1279 | 9.1318 | 9.0821 | 9.0986 | 20386604.0 |
| 2010-05-14 09:40:00 | AAPL | Stock | 9.1004 | 9.1018 | 9.0271 | 9.0751 | 28377580.0 |
| 2010-05-14 09:45:00 | AAPL | Stock | 9.0747 | 9.0828 | 9.0293 | 9.0429 | 18300800.0 |
| 2010-05-14 09:50:00 | AAPL | Stock | 9.0414 | 9.055 | 9.0196 | 9.0321 | 17109792.0 |
> showing 50 of 336,620 rows — these rows as CSV