PREVIEW / stock_1min / 2004-12-29
file: by_date/stock_1min/2004/2004-12-29.parquet size: 5.8 MB rows: 485,874 symbols: 1,574
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-29 08:00:00 | AAPL | Stock | 1.1434 | 1.1471 | 1.1434 | 1.1471 | 44800.0 |
| 2004-12-29 08:01:00 | AAPL | Stock | 1.1482 | 1.1482 | 1.1482 | 1.1482 | 60480.0 |
| 2004-12-29 08:04:00 | AAPL | Stock | 1.1473 | 1.1473 | 1.1473 | 1.1473 | 14000.0 |
| 2004-12-29 08:11:00 | AAPL | Stock | 1.1459 | 1.1459 | 1.1459 | 1.1459 | 11200.0 |
| 2004-12-29 08:15:00 | AAPL | Stock | 1.1457 | 1.1457 | 1.1457 | 1.1457 | 11200.0 |
| 2004-12-29 08:25:00 | AAPL | Stock | 1.1455 | 1.1473 | 1.1455 | 1.1473 | 25200.0 |
| 2004-12-29 08:33:00 | AAPL | Stock | 1.148 | 1.148 | 1.1468 | 1.1473 | 37800.0 |
| 2004-12-29 08:39:00 | AAPL | Stock | 1.1464 | 1.1464 | 1.1464 | 1.1464 | 16800.0 |
| 2004-12-29 08:41:00 | AAPL | Stock | 1.1464 | 1.1464 | 1.1464 | 1.1464 | 7280.0 |
| 2004-12-29 08:43:00 | AAPL | Stock | 1.1464 | 1.1464 | 1.1464 | 1.1464 | 16800.0 |
| 2004-12-29 08:46:00 | AAPL | Stock | 1.1457 | 1.1457 | 1.1455 | 1.1455 | 20440.0 |
| 2004-12-29 08:50:00 | AAPL | Stock | 1.1455 | 1.1455 | 1.1455 | 1.1455 | 28000.0 |
| 2004-12-29 08:53:00 | AAPL | Stock | 1.146 | 1.146 | 1.146 | 1.146 | 11200.0 |
| 2004-12-29 08:57:00 | AAPL | Stock | 1.1446 | 1.1446 | 1.1434 | 1.1446 | 66640.0 |
| 2004-12-29 08:58:00 | AAPL | Stock | 1.143 | 1.143 | 1.143 | 1.143 | 56000.0 |
| 2004-12-29 09:07:00 | AAPL | Stock | 1.1446 | 1.1446 | 1.1446 | 1.1446 | 5600.0 |
| 2004-12-29 09:10:00 | AAPL | Stock | 1.1446 | 1.1455 | 1.1446 | 1.1455 | 50960.0 |
| 2004-12-29 09:11:00 | AAPL | Stock | 1.143 | 1.143 | 1.1429 | 1.1429 | 72800.0 |
| 2004-12-29 09:12:00 | AAPL | Stock | 1.142 | 1.142 | 1.1416 | 1.1418 | 113008.0 |
| 2004-12-29 09:25:00 | AAPL | Stock | 1.1438 | 1.1438 | 1.1427 | 1.1438 | 16800.0 |
| 2004-12-29 09:27:00 | AAPL | Stock | 1.1418 | 1.1418 | 1.1418 | 1.1418 | 5600.0 |
| 2004-12-29 09:28:00 | AAPL | Stock | 1.1427 | 1.1427 | 1.1427 | 1.1427 | 67200.0 |
| 2004-12-29 09:29:00 | AAPL | Stock | 1.1411 | 1.1414 | 1.1402 | 1.1402 | 190400.0 |
| 2004-12-29 09:30:00 | AAPL | Stock | 1.1393 | 1.1425 | 1.1384 | 1.1425 | 6705888.0 |
| 2004-12-29 09:31:00 | AAPL | Stock | 1.1425 | 1.1468 | 1.142 | 1.1454 | 4990160.0 |
| 2004-12-29 09:32:00 | AAPL | Stock | 1.1454 | 1.147 | 1.1418 | 1.1466 | 2625560.0 |
| 2004-12-29 09:33:00 | AAPL | Stock | 1.147 | 1.147 | 1.1455 | 1.1461 | 1418928.0 |
| 2004-12-29 09:34:00 | AAPL | Stock | 1.1461 | 1.1463 | 1.1454 | 1.1459 | 1211336.0 |
| 2004-12-29 09:35:00 | AAPL | Stock | 1.1459 | 1.1482 | 1.1454 | 1.1482 | 3326568.0 |
| 2004-12-29 09:36:00 | AAPL | Stock | 1.1479 | 1.1482 | 1.1471 | 1.1482 | 1663592.0 |
| 2004-12-29 09:37:00 | AAPL | Stock | 1.1482 | 1.1496 | 1.1482 | 1.1486 | 2877728.0 |
| 2004-12-29 09:38:00 | AAPL | Stock | 1.1484 | 1.1514 | 1.1482 | 1.15 | 5261816.0 |
| 2004-12-29 09:39:00 | AAPL | Stock | 1.1498 | 1.1507 | 1.1486 | 1.1498 | 2575384.0 |
| 2004-12-29 09:40:00 | AAPL | Stock | 1.1502 | 1.1504 | 1.1489 | 1.1493 | 2155440.0 |
| 2004-12-29 09:41:00 | AAPL | Stock | 1.1491 | 1.1495 | 1.1484 | 1.1486 | 1520904.0 |
| 2004-12-29 09:42:00 | AAPL | Stock | 1.1488 | 1.1488 | 1.1464 | 1.1466 | 2122344.0 |
| 2004-12-29 09:43:00 | AAPL | Stock | 1.1466 | 1.1471 | 1.146 | 1.1471 | 2382520.0 |
| 2004-12-29 09:44:00 | AAPL | Stock | 1.147 | 1.1482 | 1.1468 | 1.1477 | 2356984.0 |
| 2004-12-29 09:45:00 | AAPL | Stock | 1.148 | 1.1491 | 1.1477 | 1.1489 | 1820672.0 |
| 2004-12-29 09:46:00 | AAPL | Stock | 1.1488 | 1.1491 | 1.148 | 1.148 | 2510200.0 |
| 2004-12-29 09:47:00 | AAPL | Stock | 1.1479 | 1.148 | 1.147 | 1.147 | 2285920.0 |
| 2004-12-29 09:48:00 | AAPL | Stock | 1.1468 | 1.1482 | 1.1464 | 1.1468 | 4886784.0 |
| 2004-12-29 09:49:00 | AAPL | Stock | 1.1467 | 1.148 | 1.1454 | 1.1464 | 4286408.0 |
| 2004-12-29 09:50:00 | AAPL | Stock | 1.1464 | 1.1477 | 1.1459 | 1.147 | 2922192.0 |
| 2004-12-29 09:51:00 | AAPL | Stock | 1.1471 | 1.1477 | 1.1461 | 1.1466 | 1948072.0 |
| 2004-12-29 09:52:00 | AAPL | Stock | 1.1471 | 1.148 | 1.1464 | 1.1471 | 1141560.0 |
| 2004-12-29 09:53:00 | AAPL | Stock | 1.1473 | 1.1484 | 1.1466 | 1.1484 | 1467872.0 |
| 2004-12-29 09:54:00 | AAPL | Stock | 1.1484 | 1.1484 | 1.1464 | 1.1468 | 744072.0 |
| 2004-12-29 09:55:00 | AAPL | Stock | 1.147 | 1.1471 | 1.1432 | 1.1432 | 1702848.0 |
| 2004-12-29 09:56:00 | AAPL | Stock | 1.1432 | 1.1448 | 1.1425 | 1.1448 | 2987600.0 |
> showing 50 of 485,874 rows — these rows as CSV