PREVIEW / stock_1min / 2008-07-21
file: by_date/stock_1min/2008/2008-07-21.parquet size: 12.0 MB rows: 965,525 symbols: 2,712
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-07-21 05:25:00 | AAPL | Stock | 5.9161 | 5.9161 | 5.9161 | 5.9161 | 28000.0 |
| 2008-07-21 05:54:00 | AAPL | Stock | 5.9171 | 5.9171 | 5.9171 | 5.9171 | 8400.0 |
| 2008-07-21 06:49:00 | AAPL | Stock | 5.9271 | 5.9393 | 5.9271 | 5.9393 | 5600.0 |
| 2008-07-21 06:56:00 | AAPL | Stock | 5.95 | 5.95 | 5.95 | 5.95 | 3360.0 |
| 2008-07-21 07:04:00 | AAPL | Stock | 5.9464 | 5.9464 | 5.9464 | 5.9464 | 2800.0 |
| 2008-07-21 07:09:00 | AAPL | Stock | 5.95 | 5.9511 | 5.9464 | 5.9511 | 42280.0 |
| 2008-07-21 07:13:00 | AAPL | Stock | 5.9511 | 5.9511 | 5.9511 | 5.9511 | 2800.0 |
| 2008-07-21 07:18:00 | AAPL | Stock | 5.9525 | 5.9536 | 5.9525 | 5.9536 | 70000.0 |
| 2008-07-21 07:22:00 | AAPL | Stock | 5.9729 | 5.9729 | 5.9729 | 5.9729 | 28000.0 |
| 2008-07-21 07:24:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9643 | 5.9643 | 26348.0 |
| 2008-07-21 07:25:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9643 | 5.9643 | 5460.0 |
| 2008-07-21 07:27:00 | AAPL | Stock | 5.9571 | 5.9571 | 5.9571 | 5.9571 | 27860.0 |
| 2008-07-21 07:28:00 | AAPL | Stock | 5.9554 | 5.9554 | 5.9539 | 5.9539 | 5600.0 |
| 2008-07-21 07:29:00 | AAPL | Stock | 5.9539 | 5.9539 | 5.9539 | 5.9539 | 14000.0 |
| 2008-07-21 07:30:00 | AAPL | Stock | 5.9554 | 5.9643 | 5.9554 | 5.9561 | 14000.0 |
| 2008-07-21 07:31:00 | AAPL | Stock | 5.9557 | 5.9561 | 5.9557 | 5.9561 | 16800.0 |
| 2008-07-21 07:32:00 | AAPL | Stock | 5.9636 | 5.9636 | 5.9636 | 5.9636 | 5600.0 |
| 2008-07-21 07:33:00 | AAPL | Stock | 5.9575 | 5.9575 | 5.9561 | 5.9561 | 14000.0 |
| 2008-07-21 07:36:00 | AAPL | Stock | 5.9564 | 5.9564 | 5.9564 | 5.9564 | 2800.0 |
| 2008-07-21 07:38:00 | AAPL | Stock | 5.96 | 5.9625 | 5.96 | 5.9625 | 16240.0 |
| 2008-07-21 07:42:00 | AAPL | Stock | 5.9571 | 5.9621 | 5.9561 | 5.9621 | 30800.0 |
| 2008-07-21 07:44:00 | AAPL | Stock | 5.9561 | 5.9561 | 5.9536 | 5.9536 | 103460.0 |
| 2008-07-21 07:47:00 | AAPL | Stock | 5.9421 | 5.9421 | 5.9411 | 5.9411 | 5600.0 |
| 2008-07-21 07:48:00 | AAPL | Stock | 5.9393 | 5.9393 | 5.9393 | 5.9393 | 5600.0 |
| 2008-07-21 07:55:00 | AAPL | Stock | 5.9464 | 5.9464 | 5.9464 | 5.9464 | 11060.0 |
| 2008-07-21 07:57:00 | AAPL | Stock | 5.95 | 5.9514 | 5.9464 | 5.9464 | 22400.0 |
| 2008-07-21 07:59:00 | AAPL | Stock | 5.9471 | 5.95 | 5.9464 | 5.95 | 22400.0 |
| 2008-07-21 08:00:00 | AAPL | Stock | 5.9482 | 5.9518 | 5.9464 | 5.95 | 226800.0 |
| 2008-07-21 08:01:00 | AAPL | Stock | 5.9514 | 5.9518 | 5.9464 | 5.9518 | 323512.0 |
| 2008-07-21 08:02:00 | AAPL | Stock | 5.9518 | 5.9536 | 5.9471 | 5.9518 | 176932.0 |
| 2008-07-21 08:03:00 | AAPL | Stock | 5.9518 | 5.9529 | 5.9518 | 5.9529 | 77000.0 |
| 2008-07-21 08:04:00 | AAPL | Stock | 5.9496 | 5.9529 | 5.9486 | 5.9514 | 88200.0 |
| 2008-07-21 08:05:00 | AAPL | Stock | 5.9525 | 5.9557 | 5.9521 | 5.9554 | 259980.0 |
| 2008-07-21 08:06:00 | AAPL | Stock | 5.9554 | 5.9557 | 5.9486 | 5.9486 | 88620.0 |
| 2008-07-21 08:07:00 | AAPL | Stock | 5.9536 | 5.9536 | 5.9518 | 5.9518 | 5600.0 |
| 2008-07-21 08:08:00 | AAPL | Stock | 5.9536 | 5.9536 | 5.9493 | 5.9493 | 34300.0 |
| 2008-07-21 08:09:00 | AAPL | Stock | 5.9493 | 5.9532 | 5.9493 | 5.9496 | 61600.0 |
| 2008-07-21 08:10:00 | AAPL | Stock | 5.9518 | 5.9536 | 5.95 | 5.9536 | 111328.0 |
| 2008-07-21 08:11:00 | AAPL | Stock | 5.9554 | 5.9554 | 5.9536 | 5.9536 | 91560.0 |
| 2008-07-21 08:12:00 | AAPL | Stock | 5.955 | 5.9554 | 5.9514 | 5.9514 | 58800.0 |
| 2008-07-21 08:13:00 | AAPL | Stock | 5.9518 | 5.9554 | 5.9518 | 5.9518 | 72800.0 |
| 2008-07-21 08:14:00 | AAPL | Stock | 5.9539 | 5.955 | 5.9507 | 5.9507 | 33600.0 |
| 2008-07-21 08:15:00 | AAPL | Stock | 5.9536 | 5.9536 | 5.9525 | 5.9525 | 25480.0 |
| 2008-07-21 08:16:00 | AAPL | Stock | 5.9536 | 5.9571 | 5.9529 | 5.9571 | 125216.0 |
| 2008-07-21 08:17:00 | AAPL | Stock | 5.9554 | 5.9557 | 5.9554 | 5.9554 | 105952.0 |
| 2008-07-21 08:18:00 | AAPL | Stock | 5.9554 | 5.9554 | 5.95 | 5.9504 | 218960.0 |
| 2008-07-21 08:19:00 | AAPL | Stock | 5.9486 | 5.95 | 5.9486 | 5.95 | 16800.0 |
| 2008-07-21 08:20:00 | AAPL | Stock | 5.95 | 5.95 | 5.9471 | 5.9479 | 75376.0 |
| 2008-07-21 08:21:00 | AAPL | Stock | 5.95 | 5.95 | 5.9464 | 5.9471 | 66920.0 |
| 2008-07-21 08:22:00 | AAPL | Stock | 5.9475 | 5.9475 | 5.9464 | 5.9464 | 64456.0 |
> showing 50 of 965,525 rows — these rows as CSV