PREVIEW / stock_1min / 2007-04-05
file: by_date/stock_1min/2007/2007-04-05.parquet size: 9.0 MB rows: 736,559 symbols: 2,099
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-05 06:13:00 | AAPL | Stock | 3.3614 | 3.3764 | 3.3614 | 3.3764 | 8400.0 |
| 2007-04-05 08:00:00 | AAPL | Stock | 3.3696 | 3.37 | 3.3696 | 3.37 | 14000.0 |
| 2007-04-05 08:01:00 | AAPL | Stock | 3.37 | 3.37 | 3.3696 | 3.3696 | 37548.0 |
| 2007-04-05 08:03:00 | AAPL | Stock | 3.3689 | 3.3689 | 3.3689 | 3.3689 | 7000.0 |
| 2007-04-05 08:06:00 | AAPL | Stock | 3.3679 | 3.3679 | 3.3679 | 3.3679 | 14000.0 |
| 2007-04-05 08:07:00 | AAPL | Stock | 3.3671 | 3.3671 | 3.3671 | 3.3671 | 16800.0 |
| 2007-04-05 08:10:00 | AAPL | Stock | 3.3679 | 3.3689 | 3.3679 | 3.3689 | 8400.0 |
| 2007-04-05 08:11:00 | AAPL | Stock | 3.3682 | 3.3682 | 3.3682 | 3.3682 | 14000.0 |
| 2007-04-05 08:12:00 | AAPL | Stock | 3.3689 | 3.3689 | 3.3689 | 3.3689 | 2800.0 |
| 2007-04-05 08:23:00 | AAPL | Stock | 3.3689 | 3.3689 | 3.3689 | 3.3689 | 4200.0 |
| 2007-04-05 08:26:00 | AAPL | Stock | 3.3696 | 3.3704 | 3.3696 | 3.3704 | 30800.0 |
| 2007-04-05 08:30:00 | AAPL | Stock | 3.3686 | 3.3686 | 3.3671 | 3.3671 | 55776.0 |
| 2007-04-05 08:31:00 | AAPL | Stock | 3.3643 | 3.3643 | 3.3643 | 3.3643 | 28140.0 |
| 2007-04-05 08:34:00 | AAPL | Stock | 3.3643 | 3.3643 | 3.3643 | 3.3643 | 9800.0 |
| 2007-04-05 08:40:00 | AAPL | Stock | 3.3643 | 3.3643 | 3.3643 | 3.3643 | 8400.0 |
| 2007-04-05 08:48:00 | AAPL | Stock | 3.3643 | 3.3643 | 3.3643 | 3.3643 | 11200.0 |
| 2007-04-05 08:51:00 | AAPL | Stock | 3.3625 | 3.3625 | 3.3625 | 3.3625 | 2800.0 |
| 2007-04-05 08:52:00 | AAPL | Stock | 3.3625 | 3.3625 | 3.3625 | 3.3625 | 7364.0 |
| 2007-04-05 08:53:00 | AAPL | Stock | 3.3625 | 3.3625 | 3.3625 | 3.3625 | 5600.0 |
| 2007-04-05 08:54:00 | AAPL | Stock | 3.3625 | 3.3639 | 3.3625 | 3.3639 | 14364.0 |
| 2007-04-05 08:55:00 | AAPL | Stock | 3.3621 | 3.3621 | 3.3621 | 3.3621 | 3444.0 |
| 2007-04-05 08:57:00 | AAPL | Stock | 3.3621 | 3.3621 | 3.3621 | 3.3621 | 20356.0 |
| 2007-04-05 08:58:00 | AAPL | Stock | 3.3621 | 3.3621 | 3.3621 | 3.3621 | 31444.0 |
| 2007-04-05 08:59:00 | AAPL | Stock | 3.3621 | 3.3621 | 3.3621 | 3.3621 | 5600.0 |
| 2007-04-05 09:00:00 | AAPL | Stock | 3.3625 | 3.3625 | 3.3621 | 3.3625 | 24500.0 |
| 2007-04-05 09:01:00 | AAPL | Stock | 3.3625 | 3.3625 | 3.3625 | 3.3625 | 23016.0 |
| 2007-04-05 09:05:00 | AAPL | Stock | 3.3614 | 3.3614 | 3.3614 | 3.3614 | 92400.0 |
| 2007-04-05 09:08:00 | AAPL | Stock | 3.3625 | 3.3625 | 3.3625 | 3.3625 | 2800.0 |
| 2007-04-05 09:09:00 | AAPL | Stock | 3.3625 | 3.3625 | 3.3614 | 3.3614 | 7504.0 |
| 2007-04-05 09:10:00 | AAPL | Stock | 3.3614 | 3.3625 | 3.3614 | 3.3625 | 84000.0 |
| 2007-04-05 09:11:00 | AAPL | Stock | 3.3625 | 3.3625 | 3.3625 | 3.3625 | 89040.0 |
| 2007-04-05 09:12:00 | AAPL | Stock | 3.3625 | 3.3625 | 3.3607 | 3.3607 | 28000.0 |
| 2007-04-05 09:14:00 | AAPL | Stock | 3.3614 | 3.3614 | 3.3614 | 3.3614 | 2800.0 |
| 2007-04-05 09:15:00 | AAPL | Stock | 3.3614 | 3.3614 | 3.3614 | 3.3614 | 16800.0 |
| 2007-04-05 09:19:00 | AAPL | Stock | 3.3614 | 3.3614 | 3.3614 | 3.3614 | 20020.0 |
| 2007-04-05 09:22:00 | AAPL | Stock | 3.3632 | 3.3632 | 3.3632 | 3.3632 | 16800.0 |
| 2007-04-05 09:24:00 | AAPL | Stock | 3.3636 | 3.3636 | 3.3636 | 3.3636 | 2800.0 |
| 2007-04-05 09:26:00 | AAPL | Stock | 3.3636 | 3.3636 | 3.3636 | 3.3636 | 13160.0 |
| 2007-04-05 09:29:00 | AAPL | Stock | 3.3646 | 3.365 | 3.3629 | 3.3629 | 179200.0 |
| 2007-04-05 09:30:00 | AAPL | Stock | 3.3614 | 3.3661 | 3.3589 | 3.3629 | 3123960.0 |
| 2007-04-05 09:31:00 | AAPL | Stock | 3.3629 | 3.3629 | 3.3575 | 3.3586 | 2073568.0 |
| 2007-04-05 09:32:00 | AAPL | Stock | 3.3586 | 3.3593 | 3.3575 | 3.3586 | 1675604.0 |
| 2007-04-05 09:33:00 | AAPL | Stock | 3.3586 | 3.3618 | 3.3579 | 3.3604 | 1715420.0 |
| 2007-04-05 09:34:00 | AAPL | Stock | 3.3604 | 3.3614 | 3.3593 | 3.3607 | 1364776.0 |
| 2007-04-05 09:35:00 | AAPL | Stock | 3.3604 | 3.3607 | 3.3589 | 3.3604 | 1218728.0 |
| 2007-04-05 09:36:00 | AAPL | Stock | 3.3604 | 3.3607 | 3.3496 | 3.3518 | 3732036.0 |
| 2007-04-05 09:37:00 | AAPL | Stock | 3.3518 | 3.3521 | 3.345 | 3.3457 | 3308704.0 |
| 2007-04-05 09:38:00 | AAPL | Stock | 3.3454 | 3.3461 | 3.34 | 3.3443 | 3940048.0 |
| 2007-04-05 09:39:00 | AAPL | Stock | 3.3436 | 3.3443 | 3.3418 | 3.3436 | 1921584.0 |
| 2007-04-05 09:40:00 | AAPL | Stock | 3.3432 | 3.3482 | 3.3432 | 3.3482 | 3254440.0 |
> showing 50 of 736,559 rows — these rows as CSV