PREVIEW / stock_1min / 2009-06-09
file: by_date/stock_1min/2009/2009-06-09.parquet size: 12.4 MB rows: 951,397 symbols: 2,723
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-06-09 04:36:00 | AAPL | Stock | 5.1679 | 5.1679 | 5.1679 | 5.1679 | 2800.0 |
| 2009-06-09 06:06:00 | AAPL | Stock | 5.13 | 5.13 | 5.13 | 5.13 | 2800.0 |
| 2009-06-09 06:25:00 | AAPL | Stock | 5.1564 | 5.1564 | 5.1564 | 5.1564 | 14000.0 |
| 2009-06-09 07:04:00 | AAPL | Stock | 5.1461 | 5.15 | 5.1461 | 5.15 | 14000.0 |
| 2009-06-09 07:09:00 | AAPL | Stock | 5.1464 | 5.1464 | 5.1464 | 5.1464 | 2800.0 |
| 2009-06-09 07:10:00 | AAPL | Stock | 5.1464 | 5.1464 | 5.1464 | 5.1464 | 2800.0 |
| 2009-06-09 07:15:00 | AAPL | Stock | 5.1493 | 5.1493 | 5.1493 | 5.1493 | 8400.0 |
| 2009-06-09 07:17:00 | AAPL | Stock | 5.1493 | 5.1493 | 5.1493 | 5.1493 | 5600.0 |
| 2009-06-09 07:19:00 | AAPL | Stock | 5.1489 | 5.15 | 5.1489 | 5.15 | 56000.0 |
| 2009-06-09 07:22:00 | AAPL | Stock | 5.1521 | 5.1521 | 5.1521 | 5.1521 | 2800.0 |
| 2009-06-09 07:24:00 | AAPL | Stock | 5.1571 | 5.1571 | 5.1571 | 5.1571 | 2800.0 |
| 2009-06-09 07:27:00 | AAPL | Stock | 5.1554 | 5.1554 | 5.1554 | 5.1554 | 11200.0 |
| 2009-06-09 07:34:00 | AAPL | Stock | 5.1604 | 5.1604 | 5.1604 | 5.1604 | 11900.0 |
| 2009-06-09 07:35:00 | AAPL | Stock | 5.1511 | 5.1511 | 5.1511 | 5.1511 | 2800.0 |
| 2009-06-09 07:39:00 | AAPL | Stock | 5.1564 | 5.1564 | 5.1564 | 5.1564 | 5600.0 |
| 2009-06-09 07:44:00 | AAPL | Stock | 5.1561 | 5.1561 | 5.1561 | 5.1561 | 5600.0 |
| 2009-06-09 07:47:00 | AAPL | Stock | 5.1554 | 5.1564 | 5.1554 | 5.1564 | 14000.0 |
| 2009-06-09 07:48:00 | AAPL | Stock | 5.1564 | 5.1564 | 5.1564 | 5.1564 | 42000.0 |
| 2009-06-09 07:51:00 | AAPL | Stock | 5.1604 | 5.1604 | 5.1604 | 5.1604 | 14000.0 |
| 2009-06-09 07:52:00 | AAPL | Stock | 5.1607 | 5.1607 | 5.1604 | 5.1607 | 169036.0 |
| 2009-06-09 07:53:00 | AAPL | Stock | 5.1643 | 5.1643 | 5.1607 | 5.1607 | 11200.0 |
| 2009-06-09 07:54:00 | AAPL | Stock | 5.1604 | 5.1607 | 5.1604 | 5.1607 | 5600.0 |
| 2009-06-09 07:55:00 | AAPL | Stock | 5.1643 | 5.1643 | 5.1643 | 5.1643 | 62328.0 |
| 2009-06-09 07:56:00 | AAPL | Stock | 5.1654 | 5.1654 | 5.1654 | 5.1654 | 50400.0 |
| 2009-06-09 08:00:00 | AAPL | Stock | 5.1654 | 5.1696 | 5.1607 | 5.1607 | 79604.0 |
| 2009-06-09 08:01:00 | AAPL | Stock | 5.1561 | 5.165 | 5.1561 | 5.165 | 41860.0 |
| 2009-06-09 08:02:00 | AAPL | Stock | 5.1639 | 5.1639 | 5.1529 | 5.1529 | 12600.0 |
| 2009-06-09 08:03:00 | AAPL | Stock | 5.1564 | 5.1571 | 5.1561 | 5.1571 | 9772.0 |
| 2009-06-09 08:04:00 | AAPL | Stock | 5.1604 | 5.1604 | 5.1571 | 5.1571 | 10920.0 |
| 2009-06-09 08:05:00 | AAPL | Stock | 5.1532 | 5.1532 | 5.1532 | 5.1532 | 5600.0 |
| 2009-06-09 08:06:00 | AAPL | Stock | 5.16 | 5.16 | 5.1543 | 5.1543 | 11200.0 |
| 2009-06-09 08:07:00 | AAPL | Stock | 5.1543 | 5.1571 | 5.1521 | 5.1521 | 42476.0 |
| 2009-06-09 08:09:00 | AAPL | Stock | 5.1521 | 5.1521 | 5.15 | 5.1511 | 12292.0 |
| 2009-06-09 08:10:00 | AAPL | Stock | 5.15 | 5.15 | 5.1393 | 5.1429 | 126476.0 |
| 2009-06-09 08:11:00 | AAPL | Stock | 5.1429 | 5.1496 | 5.1429 | 5.1496 | 17752.0 |
| 2009-06-09 08:13:00 | AAPL | Stock | 5.1432 | 5.1436 | 5.1429 | 5.1432 | 21056.0 |
| 2009-06-09 08:14:00 | AAPL | Stock | 5.1429 | 5.1429 | 5.1357 | 5.1357 | 85876.0 |
| 2009-06-09 08:15:00 | AAPL | Stock | 5.1361 | 5.1361 | 5.1361 | 5.1361 | 14000.0 |
| 2009-06-09 08:17:00 | AAPL | Stock | 5.1389 | 5.1407 | 5.1389 | 5.1393 | 43540.0 |
| 2009-06-09 08:18:00 | AAPL | Stock | 5.1389 | 5.1389 | 5.1339 | 5.1375 | 36540.0 |
| 2009-06-09 08:19:00 | AAPL | Stock | 5.1375 | 5.1375 | 5.1375 | 5.1375 | 8260.0 |
| 2009-06-09 08:20:00 | AAPL | Stock | 5.1375 | 5.1425 | 5.1375 | 5.1425 | 119700.0 |
| 2009-06-09 08:21:00 | AAPL | Stock | 5.1421 | 5.1425 | 5.1393 | 5.1393 | 30800.0 |
| 2009-06-09 08:22:00 | AAPL | Stock | 5.1425 | 5.1425 | 5.1425 | 5.1425 | 5600.0 |
| 2009-06-09 08:23:00 | AAPL | Stock | 5.1425 | 5.1425 | 5.1421 | 5.1425 | 53200.0 |
| 2009-06-09 08:25:00 | AAPL | Stock | 5.1425 | 5.1425 | 5.14 | 5.14 | 14000.0 |
| 2009-06-09 08:26:00 | AAPL | Stock | 5.1418 | 5.1418 | 5.1418 | 5.1418 | 2800.0 |
| 2009-06-09 08:27:00 | AAPL | Stock | 5.1393 | 5.14 | 5.1393 | 5.14 | 11200.0 |
| 2009-06-09 08:29:00 | AAPL | Stock | 5.1393 | 5.1393 | 5.1379 | 5.1379 | 5880.0 |
| 2009-06-09 08:30:00 | AAPL | Stock | 5.14 | 5.14 | 5.1379 | 5.1379 | 23520.0 |
> showing 50 of 951,397 rows — these rows as CSV