PREVIEW / stock_1min / 2000-07-31
file: by_date/stock_1min/2000/2000-07-31.parquet size: 2.4 MB rows: 207,381 symbols: 977
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-07-31 08:01:00 | AAPL | Stock | 0.8705 | 0.8705 | 0.8705 | 0.8705 | 5600.0 |
| 2000-07-31 09:05:00 | AAPL | Stock | 0.875 | 0.875 | 0.875 | 0.875 | 16800.0 |
| 2000-07-31 09:16:00 | AAPL | Stock | 0.8839 | 0.8839 | 0.8772 | 0.8772 | 56000.0 |
| 2000-07-31 09:20:00 | AAPL | Stock | 0.875 | 0.875 | 0.875 | 0.875 | 16800.0 |
| 2000-07-31 09:22:00 | AAPL | Stock | 0.8705 | 0.8705 | 0.8705 | 0.8705 | 11200.0 |
| 2000-07-31 09:25:00 | AAPL | Stock | 0.8772 | 0.8772 | 0.8772 | 0.8772 | 5600.0 |
| 2000-07-31 09:29:00 | AAPL | Stock | 0.8795 | 0.8795 | 0.875 | 0.8795 | 761600.0 |
| 2000-07-31 09:30:00 | AAPL | Stock | 0.8778 | 0.8778 | 0.875 | 0.8772 | 330400.0 |
| 2000-07-31 09:31:00 | AAPL | Stock | 0.8761 | 0.8761 | 0.8761 | 0.8761 | 39200.0 |
| 2000-07-31 09:32:00 | AAPL | Stock | 0.8761 | 0.8761 | 0.875 | 0.875 | 638400.0 |
| 2000-07-31 09:33:00 | AAPL | Stock | 0.8761 | 0.8772 | 0.875 | 0.8772 | 1489600.0 |
| 2000-07-31 09:34:00 | AAPL | Stock | 0.8756 | 0.8795 | 0.875 | 0.8795 | 1304800.0 |
| 2000-07-31 09:35:00 | AAPL | Stock | 0.8795 | 0.8817 | 0.875 | 0.8772 | 453600.0 |
| 2000-07-31 09:36:00 | AAPL | Stock | 0.8772 | 0.8772 | 0.8705 | 0.8717 | 1422400.0 |
| 2000-07-31 09:37:00 | AAPL | Stock | 0.8717 | 0.8795 | 0.8705 | 0.875 | 487200.0 |
| 2000-07-31 09:38:00 | AAPL | Stock | 0.8772 | 0.8783 | 0.875 | 0.875 | 565600.0 |
| 2000-07-31 09:39:00 | AAPL | Stock | 0.875 | 0.8761 | 0.875 | 0.875 | 1478400.0 |
| 2000-07-31 09:40:00 | AAPL | Stock | 0.8761 | 0.8862 | 0.8761 | 0.885 | 1652000.0 |
| 2000-07-31 09:41:00 | AAPL | Stock | 0.8862 | 0.8895 | 0.885 | 0.8895 | 1232000.0 |
| 2000-07-31 09:42:00 | AAPL | Stock | 0.8895 | 0.8917 | 0.8884 | 0.8895 | 744800.0 |
| 2000-07-31 09:43:00 | AAPL | Stock | 0.8906 | 0.8917 | 0.8884 | 0.8912 | 1500800.0 |
| 2000-07-31 09:44:00 | AAPL | Stock | 0.8912 | 0.8917 | 0.8884 | 0.8884 | 324800.0 |
| 2000-07-31 09:45:00 | AAPL | Stock | 0.8884 | 0.8906 | 0.8862 | 0.8862 | 588000.0 |
| 2000-07-31 09:46:00 | AAPL | Stock | 0.8862 | 0.8906 | 0.8817 | 0.8817 | 1058400.0 |
| 2000-07-31 09:47:00 | AAPL | Stock | 0.8817 | 0.8895 | 0.8806 | 0.8895 | 364000.0 |
| 2000-07-31 09:48:00 | AAPL | Stock | 0.8862 | 0.8862 | 0.8828 | 0.8828 | 364000.0 |
| 2000-07-31 09:49:00 | AAPL | Stock | 0.8839 | 0.8895 | 0.8828 | 0.8884 | 235200.0 |
| 2000-07-31 09:50:00 | AAPL | Stock | 0.8828 | 0.8895 | 0.8828 | 0.8839 | 162400.0 |
| 2000-07-31 09:51:00 | AAPL | Stock | 0.8862 | 0.8873 | 0.8839 | 0.8839 | 985600.0 |
| 2000-07-31 09:52:00 | AAPL | Stock | 0.8839 | 0.8878 | 0.8839 | 0.8873 | 257600.0 |
| 2000-07-31 09:53:00 | AAPL | Stock | 0.8873 | 0.8878 | 0.8873 | 0.8878 | 246400.0 |
| 2000-07-31 09:54:00 | AAPL | Stock | 0.8873 | 0.8884 | 0.8839 | 0.8873 | 840000.0 |
| 2000-07-31 09:55:00 | AAPL | Stock | 0.8878 | 0.8878 | 0.8828 | 0.8839 | 330400.0 |
| 2000-07-31 09:56:00 | AAPL | Stock | 0.8839 | 0.8884 | 0.8828 | 0.8878 | 823200.0 |
| 2000-07-31 09:57:00 | AAPL | Stock | 0.8884 | 0.8906 | 0.8873 | 0.8906 | 694400.0 |
| 2000-07-31 09:58:00 | AAPL | Stock | 0.8906 | 0.8906 | 0.8862 | 0.8884 | 644000.0 |
| 2000-07-31 09:59:00 | AAPL | Stock | 0.8862 | 0.8884 | 0.8862 | 0.8884 | 498400.0 |
| 2000-07-31 10:00:00 | AAPL | Stock | 0.8895 | 0.8929 | 0.8862 | 0.8929 | 1254400.0 |
| 2000-07-31 10:01:00 | AAPL | Stock | 0.8917 | 0.8951 | 0.8917 | 0.894 | 2172800.0 |
| 2000-07-31 10:02:00 | AAPL | Stock | 0.8929 | 0.8945 | 0.8906 | 0.8917 | 733600.0 |
| 2000-07-31 10:03:00 | AAPL | Stock | 0.8923 | 0.8929 | 0.8906 | 0.8929 | 616000.0 |
| 2000-07-31 10:04:00 | AAPL | Stock | 0.8929 | 0.8973 | 0.8929 | 0.8968 | 772800.0 |
| 2000-07-31 10:05:00 | AAPL | Stock | 0.8968 | 0.8996 | 0.8929 | 0.8996 | 767200.0 |
| 2000-07-31 10:06:00 | AAPL | Stock | 0.8929 | 0.8973 | 0.8929 | 0.8973 | 655200.0 |
| 2000-07-31 10:07:00 | AAPL | Stock | 0.8951 | 0.8962 | 0.8929 | 0.8929 | 1159200.0 |
| 2000-07-31 10:08:00 | AAPL | Stock | 0.8929 | 0.8929 | 0.8873 | 0.8873 | 565600.0 |
| 2000-07-31 10:09:00 | AAPL | Stock | 0.8895 | 0.8906 | 0.8862 | 0.8862 | 100800.0 |
| 2000-07-31 10:10:00 | AAPL | Stock | 0.8873 | 0.8873 | 0.8839 | 0.885 | 593600.0 |
| 2000-07-31 10:11:00 | AAPL | Stock | 0.885 | 0.885 | 0.8817 | 0.8828 | 655200.0 |
| 2000-07-31 10:12:00 | AAPL | Stock | 0.8817 | 0.8817 | 0.8772 | 0.8772 | 560000.0 |
> showing 50 of 207,381 rows — these rows as CSV