PREVIEW / stock_1min / 2010-01-26
file: by_date/stock_1min/2010/2010-01-26.parquet size: 12.8 MB rows: 958,406 symbols: 2,802
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-26 04:15:00 | AAPL | Stock | 7.3554 | 7.36 | 7.3375 | 7.36 | 27104.0 |
| 2010-01-26 04:16:00 | AAPL | Stock | 7.36 | 7.36 | 7.36 | 7.36 | 8400.0 |
| 2010-01-26 04:17:00 | AAPL | Stock | 7.3571 | 7.3571 | 7.3571 | 7.3571 | 2800.0 |
| 2010-01-26 04:23:00 | AAPL | Stock | 7.3636 | 7.3636 | 7.3636 | 7.3636 | 5600.0 |
| 2010-01-26 04:33:00 | AAPL | Stock | 7.3636 | 7.3636 | 7.3636 | 7.3636 | 8400.0 |
| 2010-01-26 04:47:00 | AAPL | Stock | 7.39 | 7.39 | 7.39 | 7.39 | 2800.0 |
| 2010-01-26 04:52:00 | AAPL | Stock | 7.3754 | 7.3754 | 7.3754 | 7.3754 | 19600.0 |
| 2010-01-26 04:53:00 | AAPL | Stock | 7.3754 | 7.3754 | 7.375 | 7.375 | 8400.0 |
| 2010-01-26 04:59:00 | AAPL | Stock | 7.3932 | 7.3932 | 7.3932 | 7.3932 | 9240.0 |
| 2010-01-26 05:11:00 | AAPL | Stock | 7.3914 | 7.3946 | 7.3914 | 7.3946 | 5600.0 |
| 2010-01-26 05:23:00 | AAPL | Stock | 7.3929 | 7.3929 | 7.3929 | 7.3929 | 2800.0 |
| 2010-01-26 05:24:00 | AAPL | Stock | 7.3929 | 7.3929 | 7.3929 | 7.3929 | 2800.0 |
| 2010-01-26 05:25:00 | AAPL | Stock | 7.3889 | 7.3929 | 7.3889 | 7.3929 | 8400.0 |
| 2010-01-26 05:27:00 | AAPL | Stock | 7.3868 | 7.3868 | 7.3868 | 7.3868 | 2800.0 |
| 2010-01-26 05:28:00 | AAPL | Stock | 7.3811 | 7.3811 | 7.375 | 7.375 | 8400.0 |
| 2010-01-26 05:41:00 | AAPL | Stock | 7.3714 | 7.3714 | 7.37 | 7.37 | 19600.0 |
| 2010-01-26 05:47:00 | AAPL | Stock | 7.3682 | 7.3682 | 7.3682 | 7.3682 | 2800.0 |
| 2010-01-26 05:48:00 | AAPL | Stock | 7.3718 | 7.3718 | 7.3718 | 7.3718 | 5600.0 |
| 2010-01-26 05:49:00 | AAPL | Stock | 7.3718 | 7.3718 | 7.3718 | 7.3718 | 5600.0 |
| 2010-01-26 06:00:00 | AAPL | Stock | 7.3714 | 7.3714 | 7.3714 | 7.3714 | 3500.0 |
| 2010-01-26 06:07:00 | AAPL | Stock | 7.37 | 7.37 | 7.37 | 7.37 | 5600.0 |
| 2010-01-26 06:08:00 | AAPL | Stock | 7.37 | 7.37 | 7.37 | 7.37 | 8400.0 |
| 2010-01-26 06:09:00 | AAPL | Stock | 7.3618 | 7.3664 | 7.3614 | 7.3664 | 19040.0 |
| 2010-01-26 06:14:00 | AAPL | Stock | 7.3629 | 7.3629 | 7.3629 | 7.3629 | 14000.0 |
| 2010-01-26 06:15:00 | AAPL | Stock | 7.3604 | 7.3604 | 7.3543 | 7.3543 | 33936.0 |
| 2010-01-26 06:18:00 | AAPL | Stock | 7.3589 | 7.3589 | 7.3589 | 7.3589 | 2800.0 |
| 2010-01-26 06:19:00 | AAPL | Stock | 7.3589 | 7.3589 | 7.3589 | 7.3589 | 2800.0 |
| 2010-01-26 06:20:00 | AAPL | Stock | 7.3543 | 7.3543 | 7.3543 | 7.3543 | 7784.0 |
| 2010-01-26 06:27:00 | AAPL | Stock | 7.3604 | 7.3604 | 7.3604 | 7.3604 | 25676.0 |
| 2010-01-26 06:32:00 | AAPL | Stock | 7.3625 | 7.3625 | 7.3625 | 7.3625 | 4228.0 |
| 2010-01-26 06:33:00 | AAPL | Stock | 7.3575 | 7.3575 | 7.3543 | 7.3543 | 16800.0 |
| 2010-01-26 06:36:00 | AAPL | Stock | 7.3625 | 7.3629 | 7.3625 | 7.3625 | 40012.0 |
| 2010-01-26 06:37:00 | AAPL | Stock | 7.3561 | 7.3561 | 7.3561 | 7.3561 | 2800.0 |
| 2010-01-26 06:39:00 | AAPL | Stock | 7.3607 | 7.3607 | 7.3607 | 7.3607 | 2800.0 |
| 2010-01-26 06:41:00 | AAPL | Stock | 7.3661 | 7.3661 | 7.3661 | 7.3661 | 8400.0 |
| 2010-01-26 06:47:00 | AAPL | Stock | 7.3632 | 7.3632 | 7.3632 | 7.3632 | 4396.0 |
| 2010-01-26 06:48:00 | AAPL | Stock | 7.3679 | 7.3679 | 7.3679 | 7.3679 | 2800.0 |
| 2010-01-26 06:49:00 | AAPL | Stock | 7.3686 | 7.3736 | 7.3686 | 7.3736 | 5600.0 |
| 2010-01-26 06:51:00 | AAPL | Stock | 7.3736 | 7.3736 | 7.3736 | 7.3736 | 2800.0 |
| 2010-01-26 06:55:00 | AAPL | Stock | 7.3611 | 7.3611 | 7.3579 | 7.3579 | 11200.0 |
| 2010-01-26 06:56:00 | AAPL | Stock | 7.3589 | 7.3589 | 7.3579 | 7.3579 | 8400.0 |
| 2010-01-26 06:57:00 | AAPL | Stock | 7.3568 | 7.3568 | 7.3543 | 7.3543 | 8400.0 |
| 2010-01-26 06:58:00 | AAPL | Stock | 7.3543 | 7.3543 | 7.3521 | 7.3521 | 22512.0 |
| 2010-01-26 07:00:00 | AAPL | Stock | 7.3618 | 7.3679 | 7.3618 | 7.3625 | 80920.0 |
| 2010-01-26 07:01:00 | AAPL | Stock | 7.3643 | 7.3643 | 7.3521 | 7.3521 | 28560.0 |
| 2010-01-26 07:02:00 | AAPL | Stock | 7.3571 | 7.3643 | 7.3571 | 7.3643 | 21000.0 |
| 2010-01-26 07:03:00 | AAPL | Stock | 7.3525 | 7.3621 | 7.3525 | 7.3614 | 21000.0 |
| 2010-01-26 07:04:00 | AAPL | Stock | 7.3571 | 7.3607 | 7.3571 | 7.3607 | 14140.0 |
| 2010-01-26 07:05:00 | AAPL | Stock | 7.3625 | 7.3625 | 7.3579 | 7.3579 | 5600.0 |
| 2010-01-26 07:07:00 | AAPL | Stock | 7.3589 | 7.3643 | 7.3589 | 7.3643 | 16800.0 |
> showing 50 of 958,406 rows — these rows as CSV