PREVIEW / stock_5min / 2009-04-07
file: by_date/stock_5min/2009/2009-04-07.parquet size: 4.3 MB rows: 304,199 symbols: 3,301
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 |
|---|---|---|---|---|---|---|---|
| 2009-04-07 05:25:00 | AAPL | Stock | 4.1607 | 4.1607 | 4.1607 | 4.1607 | 3584.0 |
| 2009-04-07 05:35:00 | AAPL | Stock | 4.1429 | 4.1429 | 4.1429 | 4.1429 | 10864.0 |
| 2009-04-07 06:40:00 | AAPL | Stock | 4.1804 | 4.1804 | 4.1793 | 4.1793 | 5600.0 |
| 2009-04-07 07:10:00 | AAPL | Stock | 4.1607 | 4.1607 | 4.1607 | 4.1607 | 2800.0 |
| 2009-04-07 07:15:00 | AAPL | Stock | 4.1607 | 4.1607 | 4.1543 | 4.1543 | 19600.0 |
| 2009-04-07 07:20:00 | AAPL | Stock | 4.1543 | 4.1557 | 4.1543 | 4.1546 | 19600.0 |
| 2009-04-07 07:25:00 | AAPL | Stock | 4.1475 | 4.1475 | 4.1475 | 4.1475 | 2800.0 |
| 2009-04-07 07:45:00 | AAPL | Stock | 4.1586 | 4.1711 | 4.1586 | 4.1643 | 15400.0 |
| 2009-04-07 07:50:00 | AAPL | Stock | 4.1743 | 4.1743 | 4.1743 | 4.1743 | 2800.0 |
| 2009-04-07 07:55:00 | AAPL | Stock | 4.1696 | 4.1696 | 4.1625 | 4.1625 | 27860.0 |
| 2009-04-07 08:00:00 | AAPL | Stock | 4.1589 | 4.1625 | 4.1536 | 4.1539 | 161784.0 |
| 2009-04-07 08:05:00 | AAPL | Stock | 4.1543 | 4.1607 | 4.1539 | 4.1607 | 26600.0 |
| 2009-04-07 08:10:00 | AAPL | Stock | 4.1614 | 4.1721 | 4.1614 | 4.1721 | 38220.0 |
| 2009-04-07 08:15:00 | AAPL | Stock | 4.1704 | 4.1704 | 4.1654 | 4.1679 | 101500.0 |
| 2009-04-07 08:20:00 | AAPL | Stock | 4.1679 | 4.1679 | 4.1629 | 4.1629 | 105728.0 |
| 2009-04-07 08:25:00 | AAPL | Stock | 4.1643 | 4.165 | 4.1629 | 4.1643 | 142408.0 |
| 2009-04-07 08:30:00 | AAPL | Stock | 4.1614 | 4.1614 | 4.1546 | 4.1571 | 148148.0 |
| 2009-04-07 08:35:00 | AAPL | Stock | 4.1571 | 4.1593 | 4.1546 | 4.1593 | 48440.0 |
| 2009-04-07 08:40:00 | AAPL | Stock | 4.1636 | 4.1636 | 4.1557 | 4.1571 | 40152.0 |
| 2009-04-07 08:45:00 | AAPL | Stock | 4.1607 | 4.1636 | 4.1607 | 4.1636 | 28140.0 |
| 2009-04-07 08:50:00 | AAPL | Stock | 4.1632 | 4.1643 | 4.1632 | 4.1643 | 23800.0 |
| 2009-04-07 08:55:00 | AAPL | Stock | 4.1614 | 4.1657 | 4.1614 | 4.1646 | 48440.0 |
| 2009-04-07 09:00:00 | AAPL | Stock | 4.1671 | 4.1689 | 4.1625 | 4.1643 | 338380.0 |
| 2009-04-07 09:05:00 | AAPL | Stock | 4.1629 | 4.1643 | 4.1607 | 4.1643 | 41440.0 |
| 2009-04-07 09:10:00 | AAPL | Stock | 4.1643 | 4.1661 | 4.1643 | 4.1661 | 11200.0 |
| 2009-04-07 09:15:00 | AAPL | Stock | 4.1675 | 4.1679 | 4.1654 | 4.1679 | 155904.0 |
| 2009-04-07 09:20:00 | AAPL | Stock | 4.1679 | 4.1714 | 4.1671 | 4.1679 | 233800.0 |
| 2009-04-07 09:25:00 | AAPL | Stock | 4.1604 | 4.1671 | 4.1536 | 4.1593 | 713860.0 |
| 2009-04-07 09:30:00 | AAPL | Stock | 4.1607 | 4.1668 | 4.135 | 4.1543 | 16521512.0 |
| 2009-04-07 09:35:00 | AAPL | Stock | 4.1532 | 4.1596 | 4.1321 | 4.1407 | 15294188.0 |
| 2009-04-07 09:40:00 | AAPL | Stock | 4.1407 | 4.1568 | 4.1386 | 4.1436 | 10242596.0 |
| 2009-04-07 09:45:00 | AAPL | Stock | 4.1436 | 4.1461 | 4.1286 | 4.1389 | 10064852.0 |
| 2009-04-07 09:50:00 | AAPL | Stock | 4.1379 | 4.1386 | 4.125 | 4.1256 | 8388520.0 |
| 2009-04-07 09:55:00 | AAPL | Stock | 4.1257 | 4.1407 | 4.1236 | 4.1296 | 11901372.0 |
| 2009-04-07 10:00:00 | AAPL | Stock | 4.1293 | 4.1364 | 4.1179 | 4.1182 | 10629836.0 |
| 2009-04-07 10:05:00 | AAPL | Stock | 4.1182 | 4.1204 | 4.0996 | 4.1064 | 16283456.0 |
| 2009-04-07 10:10:00 | AAPL | Stock | 4.1068 | 4.1132 | 4.1018 | 4.1114 | 7822444.0 |
| 2009-04-07 10:15:00 | AAPL | Stock | 4.1118 | 4.1132 | 4.0936 | 4.0982 | 9146788.0 |
| 2009-04-07 10:20:00 | AAPL | Stock | 4.0971 | 4.1089 | 4.0943 | 4.1039 | 7360836.0 |
| 2009-04-07 10:25:00 | AAPL | Stock | 4.1036 | 4.1325 | 4.1029 | 4.1325 | 12024320.0 |
| 2009-04-07 10:30:00 | AAPL | Stock | 4.1325 | 4.1418 | 4.1179 | 4.1275 | 11915988.0 |
| 2009-04-07 10:35:00 | AAPL | Stock | 4.1271 | 4.1321 | 4.1232 | 4.13 | 7778736.0 |
| 2009-04-07 10:40:00 | AAPL | Stock | 4.1314 | 4.1389 | 4.1304 | 4.1375 | 7797300.0 |
| 2009-04-07 10:45:00 | AAPL | Stock | 4.1375 | 4.1496 | 4.1354 | 4.1441 | 10095960.0 |
| 2009-04-07 10:50:00 | AAPL | Stock | 4.1443 | 4.1443 | 4.1329 | 4.1357 | 5229504.0 |
| 2009-04-07 10:55:00 | AAPL | Stock | 4.1368 | 4.1396 | 4.1271 | 4.1307 | 4652172.0 |
| 2009-04-07 11:00:00 | AAPL | Stock | 4.1311 | 4.1371 | 4.1268 | 4.1332 | 4663820.0 |
| 2009-04-07 11:05:00 | AAPL | Stock | 4.1329 | 4.1361 | 4.1239 | 4.1264 | 4912040.0 |
| 2009-04-07 11:10:00 | AAPL | Stock | 4.1271 | 4.1339 | 4.1254 | 4.1268 | 3591840.0 |
| 2009-04-07 11:15:00 | AAPL | Stock | 4.1268 | 4.1282 | 4.1225 | 4.1236 | 2804704.0 |
> showing 50 of 304,199 rows — these rows as CSV