PREVIEW / stock_1min / 2007-12-11
file: by_date/stock_1min/2007/2007-12-11.parquet size: 12.6 MB rows: 1,007,302 symbols: 2,639
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-11 06:44:00 | AAPL | Stock | 6.9071 | 6.9071 | 6.9043 | 6.9043 | 5600.0 |
| 2007-12-11 07:02:00 | AAPL | Stock | 6.9286 | 6.9286 | 6.9286 | 6.9286 | 6300.0 |
| 2007-12-11 07:04:00 | AAPL | Stock | 6.9286 | 6.9286 | 6.9286 | 6.9286 | 2800.0 |
| 2007-12-11 07:35:00 | AAPL | Stock | 6.9318 | 6.9318 | 6.9318 | 6.9318 | 8400.0 |
| 2007-12-11 07:41:00 | AAPL | Stock | 6.9354 | 6.9357 | 6.9354 | 6.9354 | 11900.0 |
| 2007-12-11 07:45:00 | AAPL | Stock | 6.9389 | 6.9389 | 6.9389 | 6.9389 | 5600.0 |
| 2007-12-11 07:48:00 | AAPL | Stock | 6.9389 | 6.9554 | 6.9389 | 6.9464 | 45164.0 |
| 2007-12-11 07:49:00 | AAPL | Stock | 6.9568 | 6.9568 | 6.9568 | 6.9568 | 11536.0 |
| 2007-12-11 07:52:00 | AAPL | Stock | 6.9571 | 6.9625 | 6.9571 | 6.9571 | 18284.0 |
| 2007-12-11 07:53:00 | AAPL | Stock | 6.9571 | 6.9571 | 6.9571 | 6.9571 | 8400.0 |
| 2007-12-11 07:55:00 | AAPL | Stock | 6.9571 | 6.9571 | 6.9571 | 6.9571 | 8400.0 |
| 2007-12-11 07:56:00 | AAPL | Stock | 6.9589 | 6.9589 | 6.9589 | 6.9589 | 14000.0 |
| 2007-12-11 07:57:00 | AAPL | Stock | 6.9589 | 6.9589 | 6.9571 | 6.9571 | 133280.0 |
| 2007-12-11 07:59:00 | AAPL | Stock | 6.9571 | 6.9571 | 6.9571 | 6.9571 | 11200.0 |
| 2007-12-11 08:00:00 | AAPL | Stock | 6.9589 | 6.9589 | 6.9536 | 6.9536 | 60592.0 |
| 2007-12-11 08:01:00 | AAPL | Stock | 6.9529 | 6.9532 | 6.9507 | 6.9507 | 69664.0 |
| 2007-12-11 08:02:00 | AAPL | Stock | 6.95 | 6.95 | 6.9471 | 6.9471 | 33600.0 |
| 2007-12-11 08:03:00 | AAPL | Stock | 6.9471 | 6.95 | 6.9464 | 6.95 | 50568.0 |
| 2007-12-11 08:05:00 | AAPL | Stock | 6.9489 | 6.9496 | 6.9489 | 6.9496 | 25424.0 |
| 2007-12-11 08:06:00 | AAPL | Stock | 6.9529 | 6.9589 | 6.9511 | 6.9511 | 44800.0 |
| 2007-12-11 08:08:00 | AAPL | Stock | 6.9479 | 6.9479 | 6.9479 | 6.9479 | 11200.0 |
| 2007-12-11 08:09:00 | AAPL | Stock | 6.9536 | 6.9557 | 6.9536 | 6.9557 | 53200.0 |
| 2007-12-11 08:10:00 | AAPL | Stock | 6.9571 | 6.9571 | 6.9546 | 6.9554 | 74424.0 |
| 2007-12-11 08:14:00 | AAPL | Stock | 6.9546 | 6.9554 | 6.9511 | 6.9529 | 31976.0 |
| 2007-12-11 08:15:00 | AAPL | Stock | 6.9532 | 6.9532 | 6.9511 | 6.9514 | 11200.0 |
| 2007-12-11 08:16:00 | AAPL | Stock | 6.9536 | 6.9536 | 6.9536 | 6.9536 | 19600.0 |
| 2007-12-11 08:17:00 | AAPL | Stock | 6.9536 | 6.9536 | 6.95 | 6.95 | 30800.0 |
| 2007-12-11 08:18:00 | AAPL | Stock | 6.9493 | 6.9532 | 6.9464 | 6.9464 | 80108.0 |
| 2007-12-11 08:19:00 | AAPL | Stock | 6.9468 | 6.95 | 6.9464 | 6.9464 | 14000.0 |
| 2007-12-11 08:20:00 | AAPL | Stock | 6.9507 | 6.9507 | 6.9507 | 6.9507 | 26600.0 |
| 2007-12-11 08:21:00 | AAPL | Stock | 6.9514 | 6.9521 | 6.9514 | 6.9521 | 22400.0 |
| 2007-12-11 08:22:00 | AAPL | Stock | 6.9521 | 6.9529 | 6.9464 | 6.9464 | 55132.0 |
| 2007-12-11 08:24:00 | AAPL | Stock | 6.9471 | 6.9475 | 6.9471 | 6.9475 | 16548.0 |
| 2007-12-11 08:25:00 | AAPL | Stock | 6.9518 | 6.9554 | 6.9518 | 6.9554 | 121912.0 |
| 2007-12-11 08:26:00 | AAPL | Stock | 6.9554 | 6.9564 | 6.9543 | 6.9564 | 32620.0 |
| 2007-12-11 08:27:00 | AAPL | Stock | 6.9554 | 6.9554 | 6.9532 | 6.9532 | 42000.0 |
| 2007-12-11 08:28:00 | AAPL | Stock | 6.9557 | 6.9557 | 6.9529 | 6.9529 | 9800.0 |
| 2007-12-11 08:29:00 | AAPL | Stock | 6.9507 | 6.9511 | 6.9486 | 6.9504 | 61600.0 |
| 2007-12-11 08:31:00 | AAPL | Stock | 6.95 | 6.95 | 6.9489 | 6.9489 | 5600.0 |
| 2007-12-11 08:32:00 | AAPL | Stock | 6.9518 | 6.9518 | 6.9518 | 6.9518 | 42000.0 |
| 2007-12-11 08:33:00 | AAPL | Stock | 6.9486 | 6.9486 | 6.9486 | 6.9486 | 9800.0 |
| 2007-12-11 08:34:00 | AAPL | Stock | 6.9482 | 6.9482 | 6.9468 | 6.9468 | 29400.0 |
| 2007-12-11 08:35:00 | AAPL | Stock | 6.9471 | 6.9471 | 6.9464 | 6.9468 | 34944.0 |
| 2007-12-11 08:38:00 | AAPL | Stock | 6.9482 | 6.9514 | 6.9482 | 6.9514 | 39200.0 |
| 2007-12-11 08:40:00 | AAPL | Stock | 6.9507 | 6.9507 | 6.9507 | 6.9507 | 2800.0 |
| 2007-12-11 08:44:00 | AAPL | Stock | 6.9464 | 6.9479 | 6.9457 | 6.9457 | 54096.0 |
| 2007-12-11 08:45:00 | AAPL | Stock | 6.9461 | 6.9464 | 6.9461 | 6.9464 | 14000.0 |
| 2007-12-11 08:46:00 | AAPL | Stock | 6.9464 | 6.9464 | 6.9464 | 6.9464 | 3724.0 |
| 2007-12-11 08:47:00 | AAPL | Stock | 6.9468 | 6.9468 | 6.9468 | 6.9468 | 8708.0 |
| 2007-12-11 08:48:00 | AAPL | Stock | 6.9468 | 6.9482 | 6.9464 | 6.9464 | 14532.0 |
> showing 50 of 1,007,302 rows — these rows as CSV