PREVIEW / stock_1min / 2000-01-07
file: by_date/stock_1min/2000/2000-01-07.parquet size: 2.3 MB rows: 199,692 symbols: 918
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 |
|---|---|---|---|---|---|---|---|
| 2000-01-07 09:30:00 | AAPL | Stock | 0.8616 | 0.8622 | 0.8616 | 0.8616 | 2273600.0 |
| 2000-01-07 09:31:00 | AAPL | Stock | 0.8619 | 0.8661 | 0.8616 | 0.8627 | 2273600.0 |
| 2000-01-07 09:32:00 | AAPL | Stock | 0.865 | 0.8672 | 0.8616 | 0.8661 | 3080000.0 |
| 2000-01-07 09:33:00 | AAPL | Stock | 0.8661 | 0.8683 | 0.8616 | 0.865 | 2408000.0 |
| 2000-01-07 09:34:00 | AAPL | Stock | 0.8683 | 0.8722 | 0.8627 | 0.8717 | 1646400.0 |
| 2000-01-07 09:35:00 | AAPL | Stock | 0.8722 | 0.875 | 0.8683 | 0.8744 | 2430400.0 |
| 2000-01-07 09:36:00 | AAPL | Stock | 0.875 | 0.8778 | 0.8694 | 0.8778 | 1209600.0 |
| 2000-01-07 09:37:00 | AAPL | Stock | 0.8778 | 0.8839 | 0.875 | 0.8839 | 2620800.0 |
| 2000-01-07 09:38:00 | AAPL | Stock | 0.8839 | 0.8839 | 0.8772 | 0.8839 | 3225600.0 |
| 2000-01-07 09:39:00 | AAPL | Stock | 0.8834 | 0.8839 | 0.8817 | 0.8823 | 3718400.0 |
| 2000-01-07 09:40:00 | AAPL | Stock | 0.8817 | 0.8839 | 0.8817 | 0.8823 | 4132800.0 |
| 2000-01-07 09:41:00 | AAPL | Stock | 0.8823 | 0.8839 | 0.8817 | 0.8834 | 1960000.0 |
| 2000-01-07 09:42:00 | AAPL | Stock | 0.8823 | 0.8839 | 0.8823 | 0.8834 | 2934400.0 |
| 2000-01-07 09:43:00 | AAPL | Stock | 0.8839 | 0.8839 | 0.8817 | 0.8839 | 4244800.0 |
| 2000-01-07 09:44:00 | AAPL | Stock | 0.8828 | 0.8839 | 0.8811 | 0.8823 | 3315200.0 |
| 2000-01-07 09:45:00 | AAPL | Stock | 0.8823 | 0.8834 | 0.8778 | 0.8806 | 2184000.0 |
| 2000-01-07 09:46:00 | AAPL | Stock | 0.8806 | 0.8806 | 0.8795 | 0.8795 | 1702400.0 |
| 2000-01-07 09:47:00 | AAPL | Stock | 0.8795 | 0.8806 | 0.875 | 0.8789 | 2172800.0 |
| 2000-01-07 09:48:00 | AAPL | Stock | 0.88 | 0.88 | 0.875 | 0.875 | 2004800.0 |
| 2000-01-07 09:49:00 | AAPL | Stock | 0.875 | 0.8772 | 0.8733 | 0.8733 | 2049600.0 |
| 2000-01-07 09:50:00 | AAPL | Stock | 0.8739 | 0.8783 | 0.8733 | 0.8756 | 2732800.0 |
| 2000-01-07 09:51:00 | AAPL | Stock | 0.875 | 0.8778 | 0.8739 | 0.8778 | 2105600.0 |
| 2000-01-07 09:52:00 | AAPL | Stock | 0.8783 | 0.8783 | 0.875 | 0.8778 | 3371200.0 |
| 2000-01-07 09:53:00 | AAPL | Stock | 0.8778 | 0.8795 | 0.875 | 0.8789 | 2553600.0 |
| 2000-01-07 09:54:00 | AAPL | Stock | 0.8789 | 0.8806 | 0.875 | 0.8767 | 1108800.0 |
| 2000-01-07 09:55:00 | AAPL | Stock | 0.8772 | 0.8811 | 0.8761 | 0.8811 | 2016000.0 |
| 2000-01-07 09:56:00 | AAPL | Stock | 0.8817 | 0.8839 | 0.8811 | 0.8839 | 3057600.0 |
| 2000-01-07 09:57:00 | AAPL | Stock | 0.8839 | 0.885 | 0.8834 | 0.8845 | 2576000.0 |
| 2000-01-07 09:58:00 | AAPL | Stock | 0.885 | 0.8873 | 0.8834 | 0.8867 | 1657600.0 |
| 2000-01-07 09:59:00 | AAPL | Stock | 0.8867 | 0.8873 | 0.8828 | 0.8856 | 1814400.0 |
| 2000-01-07 10:00:00 | AAPL | Stock | 0.8845 | 0.8873 | 0.8845 | 0.8862 | 1198400.0 |
| 2000-01-07 10:01:00 | AAPL | Stock | 0.8862 | 0.8867 | 0.8834 | 0.8839 | 1881600.0 |
| 2000-01-07 10:02:00 | AAPL | Stock | 0.8839 | 0.8873 | 0.8837 | 0.8873 | 2318400.0 |
| 2000-01-07 10:03:00 | AAPL | Stock | 0.887 | 0.8929 | 0.885 | 0.8903 | 1601600.0 |
| 2000-01-07 10:04:00 | AAPL | Stock | 0.8906 | 0.9018 | 0.8873 | 0.9007 | 2385600.0 |
| 2000-01-07 10:05:00 | AAPL | Stock | 0.8996 | 0.9018 | 0.8945 | 0.9007 | 3976000.0 |
| 2000-01-07 10:06:00 | AAPL | Stock | 0.9018 | 0.9018 | 0.894 | 0.8951 | 1288000.0 |
| 2000-01-07 10:07:00 | AAPL | Stock | 0.8984 | 0.8984 | 0.8951 | 0.8984 | 2609600.0 |
| 2000-01-07 10:08:00 | AAPL | Stock | 0.8973 | 0.8996 | 0.8968 | 0.8996 | 1198400.0 |
| 2000-01-07 10:09:00 | AAPL | Stock | 0.8984 | 0.8996 | 0.8968 | 0.899 | 806400.0 |
| 2000-01-07 10:10:00 | AAPL | Stock | 0.8984 | 0.9001 | 0.8962 | 0.8976 | 1982400.0 |
| 2000-01-07 10:11:00 | AAPL | Stock | 0.8973 | 0.8979 | 0.8951 | 0.897 | 3819200.0 |
| 2000-01-07 10:12:00 | AAPL | Stock | 0.8973 | 0.8979 | 0.8951 | 0.8956 | 672000.0 |
| 2000-01-07 10:13:00 | AAPL | Stock | 0.8951 | 0.8968 | 0.8929 | 0.8956 | 1120000.0 |
| 2000-01-07 10:14:00 | AAPL | Stock | 0.8956 | 0.8979 | 0.8956 | 0.8956 | 1209600.0 |
| 2000-01-07 10:15:00 | AAPL | Stock | 0.8956 | 0.8962 | 0.8917 | 0.8917 | 784000.0 |
| 2000-01-07 10:16:00 | AAPL | Stock | 0.8923 | 0.8929 | 0.8873 | 0.8901 | 1276800.0 |
| 2000-01-07 10:17:00 | AAPL | Stock | 0.8884 | 0.8906 | 0.8862 | 0.8867 | 1220800.0 |
| 2000-01-07 10:18:00 | AAPL | Stock | 0.8862 | 0.8895 | 0.8862 | 0.8884 | 1568000.0 |
| 2000-01-07 10:19:00 | AAPL | Stock | 0.8884 | 0.8906 | 0.8884 | 0.8901 | 1142400.0 |
> showing 50 of 199,692 rows — these rows as CSV