PREVIEW / stock_1min / 2001-06-19
file: by_date/stock_1min/2001/2001-06-19.parquet size: 3.2 MB rows: 257,348 symbols: 1,080
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-19 08:02:00 | AAPL | Stock | 0.363 | 0.363 | 0.363 | 0.363 | 425600.0 |
| 2001-06-19 08:21:00 | AAPL | Stock | 0.3741 | 0.3741 | 0.3741 | 0.3741 | 5600.0 |
| 2001-06-19 08:22:00 | AAPL | Stock | 0.3748 | 0.375 | 0.3748 | 0.375 | 28000.0 |
| 2001-06-19 08:34:00 | AAPL | Stock | 0.3755 | 0.3755 | 0.3755 | 0.3755 | 5600.0 |
| 2001-06-19 08:35:00 | AAPL | Stock | 0.375 | 0.375 | 0.375 | 0.375 | 22400.0 |
| 2001-06-19 08:37:00 | AAPL | Stock | 0.3757 | 0.3757 | 0.3757 | 0.3757 | 11200.0 |
| 2001-06-19 08:49:00 | AAPL | Stock | 0.3786 | 0.3786 | 0.3786 | 0.3786 | 22400.0 |
| 2001-06-19 08:50:00 | AAPL | Stock | 0.3795 | 0.3795 | 0.3795 | 0.3795 | 5600.0 |
| 2001-06-19 08:56:00 | AAPL | Stock | 0.377 | 0.377 | 0.3768 | 0.3768 | 50400.0 |
| 2001-06-19 09:00:00 | AAPL | Stock | 0.3768 | 0.3768 | 0.3768 | 0.3768 | 168000.0 |
| 2001-06-19 09:02:00 | AAPL | Stock | 0.3786 | 0.3786 | 0.3786 | 0.3786 | 28000.0 |
| 2001-06-19 09:09:00 | AAPL | Stock | 0.3763 | 0.3763 | 0.3763 | 0.3763 | 22400.0 |
| 2001-06-19 09:10:00 | AAPL | Stock | 0.3782 | 0.3782 | 0.3782 | 0.3782 | 11200.0 |
| 2001-06-19 09:11:00 | AAPL | Stock | 0.3777 | 0.3782 | 0.3777 | 0.3782 | 22400.0 |
| 2001-06-19 09:15:00 | AAPL | Stock | 0.3782 | 0.3782 | 0.3782 | 0.3782 | 5600.0 |
| 2001-06-19 09:18:00 | AAPL | Stock | 0.3777 | 0.3777 | 0.3777 | 0.3777 | 16800.0 |
| 2001-06-19 09:20:00 | AAPL | Stock | 0.3748 | 0.3748 | 0.3748 | 0.3748 | 16800.0 |
| 2001-06-19 09:24:00 | AAPL | Stock | 0.3759 | 0.3759 | 0.3759 | 0.3759 | 22400.0 |
| 2001-06-19 09:25:00 | AAPL | Stock | 0.3757 | 0.3759 | 0.3757 | 0.3759 | 100800.0 |
| 2001-06-19 09:27:00 | AAPL | Stock | 0.3757 | 0.3757 | 0.3757 | 0.3757 | 22400.0 |
| 2001-06-19 09:28:00 | AAPL | Stock | 0.3754 | 0.3757 | 0.3754 | 0.3757 | 33600.0 |
| 2001-06-19 09:29:00 | AAPL | Stock | 0.375 | 0.3752 | 0.3716 | 0.3716 | 106400.0 |
| 2001-06-19 09:30:00 | AAPL | Stock | 0.3723 | 0.3725 | 0.3714 | 0.3723 | 1668800.0 |
| 2001-06-19 09:31:00 | AAPL | Stock | 0.3716 | 0.3725 | 0.3707 | 0.3714 | 907200.0 |
| 2001-06-19 09:32:00 | AAPL | Stock | 0.3716 | 0.3732 | 0.3716 | 0.3732 | 1528800.0 |
| 2001-06-19 09:33:00 | AAPL | Stock | 0.3732 | 0.3732 | 0.3714 | 0.3714 | 420000.0 |
| 2001-06-19 09:34:00 | AAPL | Stock | 0.3723 | 0.3727 | 0.3714 | 0.3714 | 1064000.0 |
| 2001-06-19 09:35:00 | AAPL | Stock | 0.3714 | 0.3721 | 0.3714 | 0.3721 | 1876000.0 |
| 2001-06-19 09:36:00 | AAPL | Stock | 0.3721 | 0.3725 | 0.3718 | 0.372 | 1321600.0 |
| 2001-06-19 09:37:00 | AAPL | Stock | 0.372 | 0.3727 | 0.3716 | 0.3727 | 1780800.0 |
| 2001-06-19 09:38:00 | AAPL | Stock | 0.3718 | 0.3727 | 0.3711 | 0.3725 | 6596800.0 |
| 2001-06-19 09:39:00 | AAPL | Stock | 0.3725 | 0.3729 | 0.3718 | 0.3723 | 1450400.0 |
| 2001-06-19 09:40:00 | AAPL | Stock | 0.3723 | 0.375 | 0.3723 | 0.375 | 1461600.0 |
| 2001-06-19 09:41:00 | AAPL | Stock | 0.3745 | 0.3752 | 0.3745 | 0.3748 | 1568000.0 |
| 2001-06-19 09:42:00 | AAPL | Stock | 0.375 | 0.3759 | 0.3748 | 0.3759 | 1786400.0 |
| 2001-06-19 09:43:00 | AAPL | Stock | 0.3759 | 0.3759 | 0.3755 | 0.3755 | 996800.0 |
| 2001-06-19 09:44:00 | AAPL | Stock | 0.3755 | 0.3759 | 0.3755 | 0.3759 | 4088000.0 |
| 2001-06-19 09:45:00 | AAPL | Stock | 0.3761 | 0.3777 | 0.3755 | 0.3777 | 1965600.0 |
| 2001-06-19 09:46:00 | AAPL | Stock | 0.3768 | 0.3775 | 0.3759 | 0.3766 | 6468000.0 |
| 2001-06-19 09:47:00 | AAPL | Stock | 0.3768 | 0.3768 | 0.375 | 0.3763 | 1596000.0 |
| 2001-06-19 09:48:00 | AAPL | Stock | 0.375 | 0.3757 | 0.3745 | 0.3748 | 397600.0 |
| 2001-06-19 09:49:00 | AAPL | Stock | 0.3746 | 0.3755 | 0.3741 | 0.3752 | 1260000.0 |
| 2001-06-19 09:50:00 | AAPL | Stock | 0.3752 | 0.3759 | 0.3739 | 0.3759 | 6462400.0 |
| 2001-06-19 09:51:00 | AAPL | Stock | 0.3759 | 0.3763 | 0.3759 | 0.3759 | 481600.0 |
| 2001-06-19 09:52:00 | AAPL | Stock | 0.3761 | 0.377 | 0.3759 | 0.3768 | 1125600.0 |
| 2001-06-19 09:53:00 | AAPL | Stock | 0.377 | 0.3771 | 0.3761 | 0.3768 | 1904000.0 |
| 2001-06-19 09:54:00 | AAPL | Stock | 0.3766 | 0.377 | 0.3748 | 0.3759 | 1517600.0 |
| 2001-06-19 09:55:00 | AAPL | Stock | 0.3768 | 0.377 | 0.3757 | 0.3764 | 1887200.0 |
| 2001-06-19 09:56:00 | AAPL | Stock | 0.3757 | 0.3766 | 0.3755 | 0.3764 | 896000.0 |
| 2001-06-19 09:57:00 | AAPL | Stock | 0.3766 | 0.3766 | 0.3761 | 0.3763 | 1187200.0 |
> showing 50 of 257,348 rows — these rows as CSV