PREVIEW / stock_1min / 2001-01-02
file: by_date/stock_1min/2001/2001-01-02.parquet size: 2.8 MB rows: 245,613 symbols: 1,036
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-01-02 08:47:00 | AAPL | Stock | 0.2656 | 0.2656 | 0.2656 | 0.2656 | 28000.0 |
| 2001-01-02 08:48:00 | AAPL | Stock | 0.2656 | 0.2656 | 0.2656 | 0.2656 | 11200.0 |
| 2001-01-02 09:03:00 | AAPL | Stock | 0.2656 | 0.2656 | 0.2656 | 0.2656 | 33600.0 |
| 2001-01-02 09:05:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 168000.0 |
| 2001-01-02 09:08:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 56000.0 |
| 2001-01-02 09:10:00 | AAPL | Stock | 0.2645 | 0.2645 | 0.2645 | 0.2645 | 112000.0 |
| 2001-01-02 09:11:00 | AAPL | Stock | 0.2645 | 0.2645 | 0.2645 | 0.2645 | 112000.0 |
| 2001-01-02 09:14:00 | AAPL | Stock | 0.2645 | 0.2645 | 0.2645 | 0.2645 | 56000.0 |
| 2001-01-02 09:16:00 | AAPL | Stock | 0.2656 | 0.2656 | 0.2656 | 0.2656 | 56000.0 |
| 2001-01-02 09:19:00 | AAPL | Stock | 0.2656 | 0.2656 | 0.2645 | 0.2645 | 151200.0 |
| 2001-01-02 09:25:00 | AAPL | Stock | 0.2656 | 0.2656 | 0.2656 | 0.2656 | 5600.0 |
| 2001-01-02 09:26:00 | AAPL | Stock | 0.2656 | 0.2656 | 0.2656 | 0.2656 | 140000.0 |
| 2001-01-02 09:27:00 | AAPL | Stock | 0.2667 | 0.2667 | 0.2656 | 0.2667 | 448000.0 |
| 2001-01-02 09:28:00 | AAPL | Stock | 0.2667 | 0.2667 | 0.2667 | 0.2667 | 218400.0 |
| 2001-01-02 09:29:00 | AAPL | Stock | 0.2667 | 0.2667 | 0.2667 | 0.2667 | 184800.0 |
| 2001-01-02 09:30:00 | AAPL | Stock | 0.2656 | 0.2667 | 0.2656 | 0.2667 | 3892000.0 |
| 2001-01-02 09:31:00 | AAPL | Stock | 0.2667 | 0.2679 | 0.2656 | 0.2667 | 621600.0 |
| 2001-01-02 09:32:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2656 | 0.2679 | 2256800.0 |
| 2001-01-02 09:33:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2656 | 0.2679 | 1428000.0 |
| 2001-01-02 09:34:00 | AAPL | Stock | 0.2667 | 0.2679 | 0.2656 | 0.2656 | 2811200.0 |
| 2001-01-02 09:35:00 | AAPL | Stock | 0.2667 | 0.2667 | 0.2634 | 0.2656 | 996800.0 |
| 2001-01-02 09:36:00 | AAPL | Stock | 0.2656 | 0.2667 | 0.2645 | 0.2667 | 722400.0 |
| 2001-01-02 09:37:00 | AAPL | Stock | 0.2667 | 0.2679 | 0.2667 | 0.2673 | 756000.0 |
| 2001-01-02 09:38:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2667 | 0.2679 | 1652000.0 |
| 2001-01-02 09:39:00 | AAPL | Stock | 0.2679 | 0.269 | 0.2667 | 0.2667 | 1254400.0 |
| 2001-01-02 09:40:00 | AAPL | Stock | 0.2679 | 0.269 | 0.2667 | 0.2679 | 3052000.0 |
| 2001-01-02 09:41:00 | AAPL | Stock | 0.2679 | 0.269 | 0.2679 | 0.2679 | 3724000.0 |
| 2001-01-02 09:42:00 | AAPL | Stock | 0.2679 | 0.269 | 0.2679 | 0.2679 | 1528800.0 |
| 2001-01-02 09:43:00 | AAPL | Stock | 0.2684 | 0.269 | 0.2679 | 0.2679 | 2072000.0 |
| 2001-01-02 09:44:00 | AAPL | Stock | 0.2684 | 0.269 | 0.2679 | 0.269 | 767200.0 |
| 2001-01-02 09:45:00 | AAPL | Stock | 0.269 | 0.2712 | 0.269 | 0.2712 | 1887200.0 |
| 2001-01-02 09:46:00 | AAPL | Stock | 0.2712 | 0.2723 | 0.269 | 0.2712 | 3449600.0 |
| 2001-01-02 09:47:00 | AAPL | Stock | 0.2701 | 0.2723 | 0.2679 | 0.2679 | 3606400.0 |
| 2001-01-02 09:48:00 | AAPL | Stock | 0.2679 | 0.269 | 0.2679 | 0.269 | 817600.0 |
| 2001-01-02 09:49:00 | AAPL | Stock | 0.2684 | 0.269 | 0.2679 | 0.269 | 868000.0 |
| 2001-01-02 09:50:00 | AAPL | Stock | 0.269 | 0.269 | 0.2679 | 0.2679 | 1265600.0 |
| 2001-01-02 09:51:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2656 | 0.2656 | 2755200.0 |
| 2001-01-02 09:52:00 | AAPL | Stock | 0.2656 | 0.2679 | 0.2656 | 0.2679 | 3264800.0 |
| 2001-01-02 09:53:00 | AAPL | Stock | 0.2667 | 0.2667 | 0.2656 | 0.2656 | 1237600.0 |
| 2001-01-02 09:54:00 | AAPL | Stock | 0.2656 | 0.2667 | 0.2645 | 0.2667 | 1377600.0 |
| 2001-01-02 09:55:00 | AAPL | Stock | 0.2667 | 0.2667 | 0.2645 | 0.2645 | 817600.0 |
| 2001-01-02 09:56:00 | AAPL | Stock | 0.2656 | 0.2656 | 0.2645 | 0.2645 | 582400.0 |
| 2001-01-02 09:57:00 | AAPL | Stock | 0.2656 | 0.2656 | 0.2645 | 0.2645 | 168000.0 |
| 2001-01-02 09:58:00 | AAPL | Stock | 0.2645 | 0.2656 | 0.2645 | 0.2645 | 352800.0 |
| 2001-01-02 09:59:00 | AAPL | Stock | 0.2645 | 0.2656 | 0.2634 | 0.2645 | 868000.0 |
| 2001-01-02 10:00:00 | AAPL | Stock | 0.2645 | 0.2656 | 0.2634 | 0.2656 | 1652000.0 |
| 2001-01-02 10:01:00 | AAPL | Stock | 0.2656 | 0.2656 | 0.2645 | 0.2645 | 1108800.0 |
| 2001-01-02 10:02:00 | AAPL | Stock | 0.2645 | 0.2656 | 0.2645 | 0.2645 | 375200.0 |
| 2001-01-02 10:03:00 | AAPL | Stock | 0.2645 | 0.2656 | 0.2634 | 0.2634 | 1562400.0 |
| 2001-01-02 10:04:00 | AAPL | Stock | 0.2634 | 0.2645 | 0.2634 | 0.2645 | 1349600.0 |
> showing 50 of 245,613 rows — these rows as CSV