PREVIEW / stock_1min / 2003-09-26
file: by_date/stock_1min/2003/2003-09-26.parquet size: 5.2 MB rows: 422,147 symbols: 1,328
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 |
|---|---|---|---|---|---|---|---|
| 2003-09-26 08:37:00 | AAPL | Stock | 0.3627 | 0.3627 | 0.3627 | 0.3627 | 28000.0 |
| 2003-09-26 08:38:00 | AAPL | Stock | 0.3621 | 0.3621 | 0.3621 | 0.3621 | 78400.0 |
| 2003-09-26 08:42:00 | AAPL | Stock | 0.3621 | 0.3621 | 0.3621 | 0.3621 | 5600.0 |
| 2003-09-26 08:54:00 | AAPL | Stock | 0.3627 | 0.3627 | 0.3627 | 0.3627 | 11200.0 |
| 2003-09-26 08:56:00 | AAPL | Stock | 0.3627 | 0.3627 | 0.3627 | 0.3627 | 5600.0 |
| 2003-09-26 09:04:00 | AAPL | Stock | 0.3627 | 0.3627 | 0.3627 | 0.3627 | 5600.0 |
| 2003-09-26 09:08:00 | AAPL | Stock | 0.3629 | 0.3629 | 0.3629 | 0.3629 | 28000.0 |
| 2003-09-26 09:16:00 | AAPL | Stock | 0.3629 | 0.363 | 0.3629 | 0.363 | 128800.0 |
| 2003-09-26 09:19:00 | AAPL | Stock | 0.363 | 0.363 | 0.363 | 0.363 | 5600.0 |
| 2003-09-26 09:22:00 | AAPL | Stock | 0.363 | 0.363 | 0.363 | 0.363 | 39200.0 |
| 2003-09-26 09:23:00 | AAPL | Stock | 0.3632 | 0.3632 | 0.3632 | 0.3632 | 22400.0 |
| 2003-09-26 09:24:00 | AAPL | Stock | 0.3636 | 0.3636 | 0.3636 | 0.3636 | 16800.0 |
| 2003-09-26 09:26:00 | AAPL | Stock | 0.3636 | 0.3636 | 0.3636 | 0.3636 | 28000.0 |
| 2003-09-26 09:28:00 | AAPL | Stock | 0.3643 | 0.3643 | 0.3643 | 0.3643 | 84000.0 |
| 2003-09-26 09:29:00 | AAPL | Stock | 0.3643 | 0.3643 | 0.3625 | 0.3625 | 252000.0 |
| 2003-09-26 09:30:00 | AAPL | Stock | 0.3625 | 0.3633 | 0.3614 | 0.3625 | 3074344.0 |
| 2003-09-26 09:31:00 | AAPL | Stock | 0.3618 | 0.3629 | 0.3607 | 0.3618 | 1825600.0 |
| 2003-09-26 09:32:00 | AAPL | Stock | 0.362 | 0.363 | 0.3613 | 0.3617 | 1121344.0 |
| 2003-09-26 09:33:00 | AAPL | Stock | 0.3616 | 0.363 | 0.3614 | 0.3625 | 1579200.0 |
| 2003-09-26 09:34:00 | AAPL | Stock | 0.3625 | 0.3627 | 0.362 | 0.3625 | 2150400.0 |
| 2003-09-26 09:35:00 | AAPL | Stock | 0.3627 | 0.3627 | 0.3621 | 0.3625 | 1685600.0 |
| 2003-09-26 09:36:00 | AAPL | Stock | 0.3627 | 0.3632 | 0.3627 | 0.3632 | 476000.0 |
| 2003-09-26 09:37:00 | AAPL | Stock | 0.3632 | 0.3634 | 0.3629 | 0.363 | 1258768.0 |
| 2003-09-26 09:38:00 | AAPL | Stock | 0.363 | 0.3632 | 0.3614 | 0.362 | 996800.0 |
| 2003-09-26 09:39:00 | AAPL | Stock | 0.3616 | 0.3621 | 0.3616 | 0.3616 | 431200.0 |
| 2003-09-26 09:40:00 | AAPL | Stock | 0.3616 | 0.3625 | 0.3614 | 0.3623 | 476000.0 |
| 2003-09-26 09:41:00 | AAPL | Stock | 0.3623 | 0.3634 | 0.3621 | 0.3634 | 1236368.0 |
| 2003-09-26 09:42:00 | AAPL | Stock | 0.3634 | 0.3634 | 0.3629 | 0.3629 | 896504.0 |
| 2003-09-26 09:43:00 | AAPL | Stock | 0.3629 | 0.3632 | 0.3629 | 0.3629 | 516432.0 |
| 2003-09-26 09:44:00 | AAPL | Stock | 0.3629 | 0.3634 | 0.3629 | 0.3632 | 1208312.0 |
| 2003-09-26 09:45:00 | AAPL | Stock | 0.3632 | 0.3632 | 0.3626 | 0.3626 | 561400.0 |
| 2003-09-26 09:46:00 | AAPL | Stock | 0.3626 | 0.3632 | 0.3626 | 0.3627 | 313600.0 |
| 2003-09-26 09:47:00 | AAPL | Stock | 0.3629 | 0.3629 | 0.3618 | 0.362 | 646016.0 |
| 2003-09-26 09:48:00 | AAPL | Stock | 0.362 | 0.362 | 0.3602 | 0.3604 | 2562840.0 |
| 2003-09-26 09:49:00 | AAPL | Stock | 0.3606 | 0.3623 | 0.3605 | 0.362 | 1336048.0 |
| 2003-09-26 09:50:00 | AAPL | Stock | 0.3621 | 0.3623 | 0.3616 | 0.3616 | 349272.0 |
| 2003-09-26 09:51:00 | AAPL | Stock | 0.362 | 0.3621 | 0.3616 | 0.3618 | 890400.0 |
| 2003-09-26 09:52:00 | AAPL | Stock | 0.362 | 0.3621 | 0.3614 | 0.3616 | 2620800.0 |
| 2003-09-26 09:53:00 | AAPL | Stock | 0.3616 | 0.362 | 0.3607 | 0.3607 | 3589600.0 |
| 2003-09-26 09:54:00 | AAPL | Stock | 0.3614 | 0.3616 | 0.3607 | 0.3611 | 1450400.0 |
| 2003-09-26 09:55:00 | AAPL | Stock | 0.3611 | 0.3616 | 0.3609 | 0.3616 | 803264.0 |
| 2003-09-26 09:56:00 | AAPL | Stock | 0.3616 | 0.3623 | 0.3616 | 0.362 | 414400.0 |
| 2003-09-26 09:57:00 | AAPL | Stock | 0.362 | 0.362 | 0.3611 | 0.3611 | 786800.0 |
| 2003-09-26 09:58:00 | AAPL | Stock | 0.3609 | 0.3616 | 0.3609 | 0.3614 | 526400.0 |
| 2003-09-26 09:59:00 | AAPL | Stock | 0.3611 | 0.3616 | 0.3611 | 0.3616 | 448000.0 |
| 2003-09-26 10:00:00 | AAPL | Stock | 0.3616 | 0.362 | 0.3614 | 0.3614 | 207200.0 |
| 2003-09-26 10:01:00 | AAPL | Stock | 0.3614 | 0.3618 | 0.3613 | 0.3616 | 26021968.0 |
| 2003-09-26 10:02:00 | AAPL | Stock | 0.3618 | 0.362 | 0.3611 | 0.3613 | 509600.0 |
| 2003-09-26 10:03:00 | AAPL | Stock | 0.3613 | 0.3613 | 0.3604 | 0.3607 | 812000.0 |
| 2003-09-26 10:04:00 | AAPL | Stock | 0.3604 | 0.3616 | 0.3604 | 0.3616 | 503608.0 |
> showing 50 of 422,147 rows — these rows as CSV