PREVIEW / stock_1min / 2007-04-03
file: by_date/stock_1min/2007/2007-04-03.parquet size: 10.0 MB rows: 813,221 symbols: 2,095
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-04-03 07:20:00 | AAPL | Stock | 3.3461 | 3.3461 | 3.3461 | 3.3461 | 2800.0 |
| 2007-04-03 07:25:00 | AAPL | Stock | 3.3468 | 3.3468 | 3.3461 | 3.3461 | 24948.0 |
| 2007-04-03 07:32:00 | AAPL | Stock | 3.3482 | 3.3482 | 3.3482 | 3.3482 | 5600.0 |
| 2007-04-03 07:34:00 | AAPL | Stock | 3.3482 | 3.3482 | 3.3482 | 3.3482 | 14000.0 |
| 2007-04-03 07:35:00 | AAPL | Stock | 3.3471 | 3.3471 | 3.3471 | 3.3471 | 5600.0 |
| 2007-04-03 07:41:00 | AAPL | Stock | 3.3554 | 3.3571 | 3.3554 | 3.3571 | 51660.0 |
| 2007-04-03 07:42:00 | AAPL | Stock | 3.3604 | 3.3604 | 3.3604 | 3.3604 | 3080.0 |
| 2007-04-03 07:43:00 | AAPL | Stock | 3.3607 | 3.3607 | 3.3607 | 3.3607 | 30800.0 |
| 2007-04-03 07:47:00 | AAPL | Stock | 3.3571 | 3.3571 | 3.3571 | 3.3571 | 84000.0 |
| 2007-04-03 07:49:00 | AAPL | Stock | 3.3571 | 3.3571 | 3.3571 | 3.3571 | 22400.0 |
| 2007-04-03 07:52:00 | AAPL | Stock | 3.3532 | 3.3532 | 3.3521 | 3.3521 | 44800.0 |
| 2007-04-03 07:53:00 | AAPL | Stock | 3.3525 | 3.3525 | 3.3521 | 3.3521 | 15400.0 |
| 2007-04-03 07:59:00 | AAPL | Stock | 3.3554 | 3.3554 | 3.3554 | 3.3554 | 2800.0 |
| 2007-04-03 08:00:00 | AAPL | Stock | 3.3554 | 3.3571 | 3.3507 | 3.3536 | 199192.0 |
| 2007-04-03 08:01:00 | AAPL | Stock | 3.3536 | 3.3536 | 3.3536 | 3.3536 | 60900.0 |
| 2007-04-03 08:02:00 | AAPL | Stock | 3.35 | 3.3557 | 3.35 | 3.3557 | 115640.0 |
| 2007-04-03 08:03:00 | AAPL | Stock | 3.3511 | 3.3536 | 3.3504 | 3.3536 | 112560.0 |
| 2007-04-03 08:04:00 | AAPL | Stock | 3.3543 | 3.3543 | 3.3536 | 3.3536 | 92400.0 |
| 2007-04-03 08:05:00 | AAPL | Stock | 3.3518 | 3.3518 | 3.3518 | 3.3518 | 5600.0 |
| 2007-04-03 08:06:00 | AAPL | Stock | 3.3532 | 3.3532 | 3.3518 | 3.3518 | 31836.0 |
| 2007-04-03 08:08:00 | AAPL | Stock | 3.3536 | 3.3536 | 3.3536 | 3.3536 | 8400.0 |
| 2007-04-03 08:09:00 | AAPL | Stock | 3.3504 | 3.3504 | 3.3504 | 3.3504 | 26348.0 |
| 2007-04-03 08:10:00 | AAPL | Stock | 3.3504 | 3.3554 | 3.3504 | 3.3554 | 102760.0 |
| 2007-04-03 08:11:00 | AAPL | Stock | 3.355 | 3.3571 | 3.355 | 3.3564 | 289660.0 |
| 2007-04-03 08:12:00 | AAPL | Stock | 3.355 | 3.355 | 3.355 | 3.355 | 14000.0 |
| 2007-04-03 08:13:00 | AAPL | Stock | 3.355 | 3.355 | 3.3536 | 3.3536 | 49028.0 |
| 2007-04-03 08:15:00 | AAPL | Stock | 3.3546 | 3.3546 | 3.3539 | 3.3539 | 5600.0 |
| 2007-04-03 08:16:00 | AAPL | Stock | 3.3539 | 3.3554 | 3.3536 | 3.3536 | 109200.0 |
| 2007-04-03 08:17:00 | AAPL | Stock | 3.3536 | 3.3536 | 3.3536 | 3.3536 | 49700.0 |
| 2007-04-03 08:18:00 | AAPL | Stock | 3.3536 | 3.3536 | 3.3536 | 3.3536 | 2800.0 |
| 2007-04-03 08:22:00 | AAPL | Stock | 3.3525 | 3.3536 | 3.3507 | 3.3536 | 67200.0 |
| 2007-04-03 08:24:00 | AAPL | Stock | 3.3511 | 3.3511 | 3.3511 | 3.3511 | 8400.0 |
| 2007-04-03 08:25:00 | AAPL | Stock | 3.3532 | 3.3532 | 3.3532 | 3.3532 | 56000.0 |
| 2007-04-03 08:27:00 | AAPL | Stock | 3.3529 | 3.3532 | 3.3518 | 3.3532 | 22400.0 |
| 2007-04-03 08:29:00 | AAPL | Stock | 3.3532 | 3.3532 | 3.3532 | 3.3532 | 2800.0 |
| 2007-04-03 08:30:00 | AAPL | Stock | 3.3518 | 3.3518 | 3.3518 | 3.3518 | 2800.0 |
| 2007-04-03 08:31:00 | AAPL | Stock | 3.3536 | 3.3536 | 3.3536 | 3.3536 | 28000.0 |
| 2007-04-03 08:32:00 | AAPL | Stock | 3.3514 | 3.3514 | 3.3514 | 3.3514 | 4200.0 |
| 2007-04-03 08:33:00 | AAPL | Stock | 3.3518 | 3.3518 | 3.3518 | 3.3518 | 25200.0 |
| 2007-04-03 08:34:00 | AAPL | Stock | 3.3532 | 3.3539 | 3.3532 | 3.3539 | 70980.0 |
| 2007-04-03 08:35:00 | AAPL | Stock | 3.3536 | 3.3536 | 3.3536 | 3.3536 | 86520.0 |
| 2007-04-03 08:37:00 | AAPL | Stock | 3.3536 | 3.3536 | 3.3536 | 3.3536 | 2800.0 |
| 2007-04-03 08:38:00 | AAPL | Stock | 3.3536 | 3.3536 | 3.3536 | 3.3536 | 56000.0 |
| 2007-04-03 08:39:00 | AAPL | Stock | 3.3561 | 3.3561 | 3.3561 | 3.3561 | 2800.0 |
| 2007-04-03 08:45:00 | AAPL | Stock | 3.3554 | 3.3564 | 3.355 | 3.3564 | 26600.0 |
| 2007-04-03 08:47:00 | AAPL | Stock | 3.3554 | 3.3554 | 3.3554 | 3.3554 | 2800.0 |
| 2007-04-03 08:49:00 | AAPL | Stock | 3.3546 | 3.355 | 3.3546 | 3.355 | 16800.0 |
| 2007-04-03 08:50:00 | AAPL | Stock | 3.355 | 3.3564 | 3.355 | 3.3557 | 42476.0 |
| 2007-04-03 08:51:00 | AAPL | Stock | 3.3557 | 3.3557 | 3.3557 | 3.3557 | 15540.0 |
| 2007-04-03 08:52:00 | AAPL | Stock | 3.3557 | 3.3564 | 3.3554 | 3.3554 | 56000.0 |
> showing 50 of 813,221 rows — these rows as CSV