PREVIEW / stock_1min / 2008-01-03
file: by_date/stock_1min/2008/2008-01-03.parquet size: 12.5 MB rows: 1,024,362 symbols: 2,642
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-03 06:08:00 | AAPL | Stock | 6.9796 | 6.9807 | 6.9796 | 6.9807 | 11200.0 |
| 2008-01-03 06:47:00 | AAPL | Stock | 6.9557 | 6.9557 | 6.9557 | 6.9557 | 5600.0 |
| 2008-01-03 06:50:00 | AAPL | Stock | 6.9357 | 6.9357 | 6.9357 | 6.9357 | 5600.0 |
| 2008-01-03 06:53:00 | AAPL | Stock | 6.9389 | 6.9389 | 6.9389 | 6.9389 | 2800.0 |
| 2008-01-03 07:04:00 | AAPL | Stock | 6.9389 | 6.9389 | 6.9389 | 6.9389 | 2800.0 |
| 2008-01-03 07:16:00 | AAPL | Stock | 6.9536 | 6.9536 | 6.9536 | 6.9536 | 2800.0 |
| 2008-01-03 07:17:00 | AAPL | Stock | 6.9536 | 6.955 | 6.9536 | 6.955 | 16800.0 |
| 2008-01-03 07:19:00 | AAPL | Stock | 6.9554 | 6.9554 | 6.9554 | 6.9554 | 2800.0 |
| 2008-01-03 07:25:00 | AAPL | Stock | 6.9821 | 6.9821 | 6.9821 | 6.9821 | 5600.0 |
| 2008-01-03 07:35:00 | AAPL | Stock | 6.9643 | 6.9643 | 6.9643 | 6.9643 | 24780.0 |
| 2008-01-03 07:37:00 | AAPL | Stock | 6.9643 | 6.9646 | 6.9643 | 6.9646 | 42000.0 |
| 2008-01-03 07:39:00 | AAPL | Stock | 6.9696 | 6.9696 | 6.9696 | 6.9696 | 5600.0 |
| 2008-01-03 07:40:00 | AAPL | Stock | 6.9696 | 6.9696 | 6.9696 | 6.9696 | 5600.0 |
| 2008-01-03 07:44:00 | AAPL | Stock | 6.9629 | 6.9629 | 6.9629 | 6.9629 | 11200.0 |
| 2008-01-03 07:49:00 | AAPL | Stock | 6.9554 | 6.9554 | 6.9554 | 6.9554 | 8400.0 |
| 2008-01-03 07:53:00 | AAPL | Stock | 6.9571 | 6.9571 | 6.9554 | 6.9554 | 16800.0 |
| 2008-01-03 07:55:00 | AAPL | Stock | 6.9554 | 6.9554 | 6.9554 | 6.9554 | 14000.0 |
| 2008-01-03 07:57:00 | AAPL | Stock | 6.9482 | 6.9482 | 6.9482 | 6.9482 | 11200.0 |
| 2008-01-03 07:58:00 | AAPL | Stock | 6.9414 | 6.9414 | 6.9414 | 6.9414 | 2800.0 |
| 2008-01-03 07:59:00 | AAPL | Stock | 6.9479 | 6.9479 | 6.9429 | 6.9429 | 30800.0 |
| 2008-01-03 08:00:00 | AAPL | Stock | 6.9482 | 6.9643 | 6.9289 | 6.9443 | 248808.0 |
| 2008-01-03 08:01:00 | AAPL | Stock | 6.9464 | 6.9464 | 6.945 | 6.945 | 36400.0 |
| 2008-01-03 08:02:00 | AAPL | Stock | 6.9493 | 6.9611 | 6.9493 | 6.9564 | 96880.0 |
| 2008-01-03 08:03:00 | AAPL | Stock | 6.9546 | 6.9546 | 6.9454 | 6.9454 | 100800.0 |
| 2008-01-03 08:04:00 | AAPL | Stock | 6.9543 | 6.9571 | 6.9543 | 6.9571 | 114800.0 |
| 2008-01-03 08:05:00 | AAPL | Stock | 6.9536 | 6.9536 | 6.9429 | 6.9464 | 89152.0 |
| 2008-01-03 08:06:00 | AAPL | Stock | 6.9464 | 6.9532 | 6.9464 | 6.9518 | 54600.0 |
| 2008-01-03 08:07:00 | AAPL | Stock | 6.95 | 6.9518 | 6.9482 | 6.9518 | 23800.0 |
| 2008-01-03 08:08:00 | AAPL | Stock | 6.9471 | 6.9471 | 6.9411 | 6.9411 | 46200.0 |
| 2008-01-03 08:09:00 | AAPL | Stock | 6.9411 | 6.9411 | 6.94 | 6.94 | 8400.0 |
| 2008-01-03 08:10:00 | AAPL | Stock | 6.9393 | 6.9393 | 6.9364 | 6.9364 | 81200.0 |
| 2008-01-03 08:11:00 | AAPL | Stock | 6.9368 | 6.9368 | 6.9286 | 6.9286 | 50092.0 |
| 2008-01-03 08:12:00 | AAPL | Stock | 6.9286 | 6.9286 | 6.9286 | 6.9286 | 3052.0 |
| 2008-01-03 08:13:00 | AAPL | Stock | 6.9232 | 6.9232 | 6.9107 | 6.9111 | 128828.0 |
| 2008-01-03 08:14:00 | AAPL | Stock | 6.9111 | 6.9214 | 6.9068 | 6.9111 | 58268.0 |
| 2008-01-03 08:15:00 | AAPL | Stock | 6.9229 | 6.9286 | 6.9125 | 6.9286 | 74900.0 |
| 2008-01-03 08:16:00 | AAPL | Stock | 6.9286 | 6.9286 | 6.9186 | 6.9286 | 76720.0 |
| 2008-01-03 08:17:00 | AAPL | Stock | 6.9286 | 6.9421 | 6.9286 | 6.9389 | 111440.0 |
| 2008-01-03 08:18:00 | AAPL | Stock | 6.9421 | 6.9514 | 6.9379 | 6.9507 | 172732.0 |
| 2008-01-03 08:19:00 | AAPL | Stock | 6.9525 | 6.9536 | 6.9411 | 6.9464 | 25928.0 |
| 2008-01-03 08:20:00 | AAPL | Stock | 6.9454 | 6.9464 | 6.9411 | 6.9411 | 29400.0 |
| 2008-01-03 08:21:00 | AAPL | Stock | 6.9461 | 6.9464 | 6.9457 | 6.9464 | 19600.0 |
| 2008-01-03 08:22:00 | AAPL | Stock | 6.9493 | 6.9532 | 6.9464 | 6.9532 | 227780.0 |
| 2008-01-03 08:23:00 | AAPL | Stock | 6.9518 | 6.9639 | 6.9518 | 6.9607 | 108472.0 |
| 2008-01-03 08:24:00 | AAPL | Stock | 6.9589 | 6.9604 | 6.9571 | 6.9589 | 77000.0 |
| 2008-01-03 08:25:00 | AAPL | Stock | 6.9607 | 6.9643 | 6.9593 | 6.9593 | 138936.0 |
| 2008-01-03 08:26:00 | AAPL | Stock | 6.9589 | 6.9668 | 6.9536 | 6.9604 | 191408.0 |
| 2008-01-03 08:27:00 | AAPL | Stock | 6.9554 | 6.9571 | 6.9546 | 6.9571 | 8400.0 |
| 2008-01-03 08:28:00 | AAPL | Stock | 6.9571 | 6.9571 | 6.9536 | 6.9536 | 22400.0 |
| 2008-01-03 08:29:00 | AAPL | Stock | 6.95 | 6.9571 | 6.95 | 6.95 | 213136.0 |
> showing 50 of 1,024,362 rows — these rows as CSV