PREVIEW / stock_1min / 2005-06-22
file: by_date/stock_1min/2005/2005-06-22.parquet size: 6.7 MB rows: 564,891 symbols: 1,637
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-22 08:00:00 | AAPL | Stock | 1.3661 | 1.3661 | 1.3661 | 1.3661 | 5600.0 |
| 2005-06-22 08:01:00 | AAPL | Stock | 1.3646 | 1.3675 | 1.3643 | 1.3661 | 174300.0 |
| 2005-06-22 08:02:00 | AAPL | Stock | 1.3661 | 1.3661 | 1.3661 | 1.3661 | 121800.0 |
| 2005-06-22 08:04:00 | AAPL | Stock | 1.3643 | 1.3643 | 1.3643 | 1.3643 | 12236.0 |
| 2005-06-22 08:06:00 | AAPL | Stock | 1.3632 | 1.3632 | 1.3632 | 1.3632 | 2800.0 |
| 2005-06-22 08:07:00 | AAPL | Stock | 1.3643 | 1.3643 | 1.3643 | 1.3643 | 44800.0 |
| 2005-06-22 08:08:00 | AAPL | Stock | 1.3643 | 1.3643 | 1.3643 | 1.3643 | 4200.0 |
| 2005-06-22 08:12:00 | AAPL | Stock | 1.3639 | 1.3639 | 1.3639 | 1.3639 | 5600.0 |
| 2005-06-22 08:13:00 | AAPL | Stock | 1.3625 | 1.3625 | 1.3625 | 1.3625 | 2800.0 |
| 2005-06-22 08:14:00 | AAPL | Stock | 1.3625 | 1.3625 | 1.3625 | 1.3625 | 21000.0 |
| 2005-06-22 08:15:00 | AAPL | Stock | 1.3625 | 1.3625 | 1.3625 | 1.3625 | 60200.0 |
| 2005-06-22 08:20:00 | AAPL | Stock | 1.3632 | 1.3632 | 1.3632 | 1.3632 | 5600.0 |
| 2005-06-22 08:22:00 | AAPL | Stock | 1.3625 | 1.3625 | 1.3625 | 1.3625 | 5600.0 |
| 2005-06-22 08:24:00 | AAPL | Stock | 1.3636 | 1.3636 | 1.3636 | 1.3636 | 18200.0 |
| 2005-06-22 08:29:00 | AAPL | Stock | 1.3629 | 1.3629 | 1.3629 | 1.3629 | 2800.0 |
| 2005-06-22 08:30:00 | AAPL | Stock | 1.3636 | 1.3636 | 1.3636 | 1.3636 | 25200.0 |
| 2005-06-22 08:31:00 | AAPL | Stock | 1.3643 | 1.3654 | 1.3643 | 1.3654 | 133420.0 |
| 2005-06-22 08:32:00 | AAPL | Stock | 1.3664 | 1.3664 | 1.3664 | 1.3664 | 36400.0 |
| 2005-06-22 08:34:00 | AAPL | Stock | 1.3661 | 1.3661 | 1.3661 | 1.3661 | 14000.0 |
| 2005-06-22 08:35:00 | AAPL | Stock | 1.3679 | 1.3679 | 1.3675 | 1.3675 | 65268.0 |
| 2005-06-22 08:36:00 | AAPL | Stock | 1.37 | 1.37 | 1.3696 | 1.37 | 46816.0 |
| 2005-06-22 08:37:00 | AAPL | Stock | 1.37 | 1.3714 | 1.37 | 1.3714 | 134400.0 |
| 2005-06-22 08:38:00 | AAPL | Stock | 1.3714 | 1.3714 | 1.3714 | 1.3714 | 70000.0 |
| 2005-06-22 08:39:00 | AAPL | Stock | 1.3743 | 1.3743 | 1.3732 | 1.3732 | 202384.0 |
| 2005-06-22 08:40:00 | AAPL | Stock | 1.3732 | 1.3732 | 1.3718 | 1.3732 | 128800.0 |
| 2005-06-22 08:41:00 | AAPL | Stock | 1.3732 | 1.3732 | 1.3732 | 1.3732 | 170800.0 |
| 2005-06-22 08:43:00 | AAPL | Stock | 1.3714 | 1.3714 | 1.3714 | 1.3714 | 14000.0 |
| 2005-06-22 08:44:00 | AAPL | Stock | 1.3714 | 1.3714 | 1.3714 | 1.3714 | 5600.0 |
| 2005-06-22 08:45:00 | AAPL | Stock | 1.3714 | 1.3714 | 1.3714 | 1.3714 | 35000.0 |
| 2005-06-22 08:46:00 | AAPL | Stock | 1.3714 | 1.3714 | 1.3714 | 1.3714 | 154000.0 |
| 2005-06-22 08:47:00 | AAPL | Stock | 1.3696 | 1.3696 | 1.3696 | 1.3696 | 30800.0 |
| 2005-06-22 08:48:00 | AAPL | Stock | 1.3696 | 1.3696 | 1.3696 | 1.3696 | 11200.0 |
| 2005-06-22 08:49:00 | AAPL | Stock | 1.3714 | 1.3714 | 1.3714 | 1.3714 | 8400.0 |
| 2005-06-22 08:50:00 | AAPL | Stock | 1.3714 | 1.3714 | 1.3714 | 1.3714 | 11200.0 |
| 2005-06-22 08:51:00 | AAPL | Stock | 1.3718 | 1.3718 | 1.3718 | 1.3718 | 2800.0 |
| 2005-06-22 08:52:00 | AAPL | Stock | 1.3721 | 1.3732 | 1.3721 | 1.3732 | 140000.0 |
| 2005-06-22 08:53:00 | AAPL | Stock | 1.3714 | 1.3714 | 1.3714 | 1.3714 | 84000.0 |
| 2005-06-22 08:54:00 | AAPL | Stock | 1.3732 | 1.3732 | 1.3729 | 1.3729 | 47600.0 |
| 2005-06-22 08:56:00 | AAPL | Stock | 1.3732 | 1.3732 | 1.3729 | 1.3732 | 84000.0 |
| 2005-06-22 08:57:00 | AAPL | Stock | 1.3732 | 1.375 | 1.3732 | 1.375 | 102816.0 |
| 2005-06-22 08:58:00 | AAPL | Stock | 1.375 | 1.375 | 1.375 | 1.375 | 53200.0 |
| 2005-06-22 08:59:00 | AAPL | Stock | 1.375 | 1.375 | 1.3743 | 1.3743 | 49616.0 |
| 2005-06-22 09:00:00 | AAPL | Stock | 1.375 | 1.375 | 1.375 | 1.375 | 2800.0 |
| 2005-06-22 09:01:00 | AAPL | Stock | 1.375 | 1.375 | 1.3743 | 1.3743 | 28896.0 |
| 2005-06-22 09:03:00 | AAPL | Stock | 1.3746 | 1.3746 | 1.3746 | 1.3746 | 67200.0 |
| 2005-06-22 09:04:00 | AAPL | Stock | 1.3757 | 1.3757 | 1.3743 | 1.3746 | 120400.0 |
| 2005-06-22 09:05:00 | AAPL | Stock | 1.3746 | 1.3746 | 1.3743 | 1.3746 | 28000.0 |
| 2005-06-22 09:06:00 | AAPL | Stock | 1.3746 | 1.3764 | 1.3746 | 1.3764 | 163800.0 |
| 2005-06-22 09:07:00 | AAPL | Stock | 1.3761 | 1.3764 | 1.375 | 1.3764 | 86800.0 |
| 2005-06-22 09:08:00 | AAPL | Stock | 1.3746 | 1.375 | 1.3746 | 1.375 | 8400.0 |
> showing 50 of 564,891 rows — these rows as CSV