PREVIEW / stock_1min / 2008-11-21
file: by_date/stock_1min/2008/2008-11-21.parquet size: 14.1 MB rows: 1,113,291 symbols: 2,753
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-21 04:57:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 2800.0 |
| 2008-11-21 04:58:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 2800.0 |
| 2008-11-21 05:50:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 2800.0 |
| 2008-11-21 06:11:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 2800.0 |
| 2008-11-21 06:47:00 | AAPL | Stock | 2.9693 | 2.9693 | 2.9629 | 2.9629 | 5600.0 |
| 2008-11-21 06:57:00 | AAPL | Stock | 2.9821 | 2.9821 | 2.9821 | 2.9821 | 2800.0 |
| 2008-11-21 07:11:00 | AAPL | Stock | 2.9643 | 2.9643 | 2.9643 | 2.9643 | 16800.0 |
| 2008-11-21 07:13:00 | AAPL | Stock | 2.9643 | 2.9643 | 2.9643 | 2.9643 | 2800.0 |
| 2008-11-21 07:17:00 | AAPL | Stock | 2.975 | 2.975 | 2.975 | 2.975 | 2800.0 |
| 2008-11-21 07:18:00 | AAPL | Stock | 2.9768 | 2.9768 | 2.9768 | 2.9768 | 24724.0 |
| 2008-11-21 07:20:00 | AAPL | Stock | 2.9646 | 2.9646 | 2.9646 | 2.9646 | 5880.0 |
| 2008-11-21 07:25:00 | AAPL | Stock | 2.9661 | 2.9661 | 2.9661 | 2.9661 | 84476.0 |
| 2008-11-21 07:30:00 | AAPL | Stock | 2.9664 | 2.9664 | 2.9607 | 2.9607 | 105644.0 |
| 2008-11-21 07:31:00 | AAPL | Stock | 2.9529 | 2.9529 | 2.9529 | 2.9529 | 14000.0 |
| 2008-11-21 07:32:00 | AAPL | Stock | 2.95 | 2.95 | 2.95 | 2.95 | 2800.0 |
| 2008-11-21 07:38:00 | AAPL | Stock | 2.9464 | 2.9464 | 2.9464 | 2.9464 | 2800.0 |
| 2008-11-21 07:41:00 | AAPL | Stock | 2.95 | 2.9529 | 2.95 | 2.9529 | 30800.0 |
| 2008-11-21 07:42:00 | AAPL | Stock | 2.9525 | 2.9525 | 2.9464 | 2.9464 | 42000.0 |
| 2008-11-21 07:44:00 | AAPL | Stock | 2.9429 | 2.9429 | 2.9429 | 2.9429 | 5600.0 |
| 2008-11-21 07:46:00 | AAPL | Stock | 2.9393 | 2.9393 | 2.9393 | 2.9393 | 4200.0 |
| 2008-11-21 07:47:00 | AAPL | Stock | 2.9339 | 2.9393 | 2.9339 | 2.9393 | 43400.0 |
| 2008-11-21 07:48:00 | AAPL | Stock | 2.9339 | 2.9339 | 2.9054 | 2.9054 | 63420.0 |
| 2008-11-21 07:49:00 | AAPL | Stock | 2.9071 | 2.9254 | 2.8968 | 2.9254 | 190400.0 |
| 2008-11-21 07:50:00 | AAPL | Stock | 2.9125 | 2.9232 | 2.9125 | 2.9232 | 86800.0 |
| 2008-11-21 07:52:00 | AAPL | Stock | 2.9164 | 2.9268 | 2.9143 | 2.9268 | 47600.0 |
| 2008-11-21 07:53:00 | AAPL | Stock | 2.9268 | 2.9304 | 2.9268 | 2.9304 | 19600.0 |
| 2008-11-21 07:54:00 | AAPL | Stock | 2.9304 | 2.9304 | 2.9304 | 2.9304 | 5600.0 |
| 2008-11-21 07:55:00 | AAPL | Stock | 2.9286 | 2.9286 | 2.9286 | 2.9286 | 5600.0 |
| 2008-11-21 07:56:00 | AAPL | Stock | 2.9286 | 2.9286 | 2.9286 | 2.9286 | 8400.0 |
| 2008-11-21 07:58:00 | AAPL | Stock | 2.9268 | 2.9268 | 2.9107 | 2.9107 | 75600.0 |
| 2008-11-21 07:59:00 | AAPL | Stock | 2.9107 | 2.9107 | 2.9107 | 2.9107 | 109200.0 |
| 2008-11-21 08:00:00 | AAPL | Stock | 2.9196 | 2.9214 | 2.9018 | 2.9036 | 393792.0 |
| 2008-11-21 08:01:00 | AAPL | Stock | 2.9021 | 2.9021 | 2.8929 | 2.8929 | 304724.0 |
| 2008-11-21 08:02:00 | AAPL | Stock | 2.8964 | 2.915 | 2.8964 | 2.9104 | 53396.0 |
| 2008-11-21 08:03:00 | AAPL | Stock | 2.91 | 2.91 | 2.9054 | 2.9054 | 14840.0 |
| 2008-11-21 08:04:00 | AAPL | Stock | 2.91 | 2.91 | 2.9046 | 2.9046 | 57680.0 |
| 2008-11-21 08:05:00 | AAPL | Stock | 2.8982 | 2.9011 | 2.875 | 2.8782 | 626108.0 |
| 2008-11-21 08:06:00 | AAPL | Stock | 2.9 | 2.9 | 2.8839 | 2.8839 | 36680.0 |
| 2008-11-21 08:07:00 | AAPL | Stock | 2.8868 | 2.8893 | 2.8839 | 2.8893 | 63000.0 |
| 2008-11-21 08:08:00 | AAPL | Stock | 2.8929 | 2.8929 | 2.8929 | 2.8929 | 20440.0 |
| 2008-11-21 08:09:00 | AAPL | Stock | 2.8929 | 2.9 | 2.8929 | 2.9 | 62720.0 |
| 2008-11-21 08:10:00 | AAPL | Stock | 2.8996 | 2.9007 | 2.8996 | 2.9007 | 39200.0 |
| 2008-11-21 08:11:00 | AAPL | Stock | 2.9029 | 2.9054 | 2.8982 | 2.8982 | 117600.0 |
| 2008-11-21 08:12:00 | AAPL | Stock | 2.8968 | 2.9036 | 2.8964 | 2.8986 | 76832.0 |
| 2008-11-21 08:13:00 | AAPL | Stock | 2.9018 | 2.9068 | 2.9018 | 2.9068 | 18480.0 |
| 2008-11-21 08:14:00 | AAPL | Stock | 2.9071 | 2.9107 | 2.9071 | 2.9104 | 75544.0 |
| 2008-11-21 08:15:00 | AAPL | Stock | 2.9107 | 2.9154 | 2.9107 | 2.9107 | 120064.0 |
| 2008-11-21 08:16:00 | AAPL | Stock | 2.9118 | 2.9161 | 2.9107 | 2.9161 | 144844.0 |
| 2008-11-21 08:17:00 | AAPL | Stock | 2.9143 | 2.9214 | 2.9143 | 2.9214 | 158256.0 |
| 2008-11-21 08:18:00 | AAPL | Stock | 2.9214 | 2.9286 | 2.9211 | 2.9286 | 183736.0 |
> showing 50 of 1,113,291 rows — these rows as CSV