PREVIEW / stock_1min / 2001-01-31
file: by_date/stock_1min/2001/2001-01-31.parquet size: 3.2 MB rows: 257,411 symbols: 1,048
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-31 08:01:00 | AAPL | Stock | 0.3873 | 0.3873 | 0.3873 | 0.3873 | 5600.0 |
| 2001-01-31 08:11:00 | AAPL | Stock | 0.3817 | 0.3817 | 0.3817 | 0.3817 | 5600.0 |
| 2001-01-31 08:21:00 | AAPL | Stock | 0.3873 | 0.3873 | 0.3873 | 0.3873 | 5600.0 |
| 2001-01-31 08:48:00 | AAPL | Stock | 0.385 | 0.385 | 0.385 | 0.385 | 11200.0 |
| 2001-01-31 09:00:00 | AAPL | Stock | 0.3873 | 0.3873 | 0.3873 | 0.3873 | 11200.0 |
| 2001-01-31 09:03:00 | AAPL | Stock | 0.3862 | 0.3862 | 0.3862 | 0.3862 | 56000.0 |
| 2001-01-31 09:04:00 | AAPL | Stock | 0.385 | 0.385 | 0.385 | 0.385 | 5600.0 |
| 2001-01-31 09:08:00 | AAPL | Stock | 0.385 | 0.385 | 0.385 | 0.385 | 5600.0 |
| 2001-01-31 09:15:00 | AAPL | Stock | 0.385 | 0.385 | 0.385 | 0.385 | 5600.0 |
| 2001-01-31 09:17:00 | AAPL | Stock | 0.385 | 0.385 | 0.385 | 0.385 | 28000.0 |
| 2001-01-31 09:20:00 | AAPL | Stock | 0.385 | 0.385 | 0.385 | 0.385 | 56000.0 |
| 2001-01-31 09:27:00 | AAPL | Stock | 0.3845 | 0.3845 | 0.3839 | 0.3839 | 201600.0 |
| 2001-01-31 09:28:00 | AAPL | Stock | 0.3839 | 0.3839 | 0.3828 | 0.3828 | 420000.0 |
| 2001-01-31 09:29:00 | AAPL | Stock | 0.3839 | 0.3839 | 0.3839 | 0.3839 | 28000.0 |
| 2001-01-31 09:30:00 | AAPL | Stock | 0.3839 | 0.3862 | 0.3828 | 0.3839 | 3141600.0 |
| 2001-01-31 09:31:00 | AAPL | Stock | 0.385 | 0.3884 | 0.3828 | 0.3884 | 2044000.0 |
| 2001-01-31 09:32:00 | AAPL | Stock | 0.3884 | 0.3895 | 0.3828 | 0.3884 | 7280000.0 |
| 2001-01-31 09:33:00 | AAPL | Stock | 0.3884 | 0.3884 | 0.3862 | 0.3873 | 2676800.0 |
| 2001-01-31 09:34:00 | AAPL | Stock | 0.3873 | 0.3873 | 0.3862 | 0.3862 | 1237600.0 |
| 2001-01-31 09:35:00 | AAPL | Stock | 0.3862 | 0.3862 | 0.385 | 0.385 | 1271200.0 |
| 2001-01-31 09:36:00 | AAPL | Stock | 0.385 | 0.3884 | 0.3839 | 0.3873 | 2626400.0 |
| 2001-01-31 09:37:00 | AAPL | Stock | 0.3873 | 0.3895 | 0.385 | 0.3895 | 2951200.0 |
| 2001-01-31 09:38:00 | AAPL | Stock | 0.3884 | 0.3906 | 0.3884 | 0.3884 | 515200.0 |
| 2001-01-31 09:39:00 | AAPL | Stock | 0.3884 | 0.3895 | 0.3862 | 0.3884 | 588000.0 |
| 2001-01-31 09:40:00 | AAPL | Stock | 0.3862 | 0.3873 | 0.3862 | 0.3873 | 168000.0 |
| 2001-01-31 09:41:00 | AAPL | Stock | 0.3873 | 0.3884 | 0.3873 | 0.3884 | 1310400.0 |
| 2001-01-31 09:42:00 | AAPL | Stock | 0.3884 | 0.3895 | 0.385 | 0.389 | 1316000.0 |
| 2001-01-31 09:43:00 | AAPL | Stock | 0.3884 | 0.3884 | 0.3873 | 0.3873 | 481600.0 |
| 2001-01-31 09:44:00 | AAPL | Stock | 0.3862 | 0.3873 | 0.3862 | 0.3862 | 235200.0 |
| 2001-01-31 09:45:00 | AAPL | Stock | 0.3873 | 0.3873 | 0.3862 | 0.3873 | 1534400.0 |
| 2001-01-31 09:46:00 | AAPL | Stock | 0.3884 | 0.3884 | 0.3873 | 0.3873 | 442400.0 |
| 2001-01-31 09:47:00 | AAPL | Stock | 0.3873 | 0.3884 | 0.3862 | 0.3873 | 722400.0 |
| 2001-01-31 09:48:00 | AAPL | Stock | 0.3862 | 0.3884 | 0.3862 | 0.3884 | 1108800.0 |
| 2001-01-31 09:49:00 | AAPL | Stock | 0.3884 | 0.3895 | 0.3873 | 0.3884 | 1461600.0 |
| 2001-01-31 09:50:00 | AAPL | Stock | 0.3873 | 0.3884 | 0.3873 | 0.3884 | 722400.0 |
| 2001-01-31 09:51:00 | AAPL | Stock | 0.3884 | 0.3929 | 0.3873 | 0.3929 | 2895200.0 |
| 2001-01-31 09:52:00 | AAPL | Stock | 0.3917 | 0.3951 | 0.3906 | 0.394 | 16212000.0 |
| 2001-01-31 09:53:00 | AAPL | Stock | 0.394 | 0.3962 | 0.3929 | 0.3962 | 3757600.0 |
| 2001-01-31 09:54:00 | AAPL | Stock | 0.3962 | 0.3984 | 0.3951 | 0.3973 | 4681600.0 |
| 2001-01-31 09:55:00 | AAPL | Stock | 0.3973 | 0.3984 | 0.3917 | 0.3951 | 7369600.0 |
| 2001-01-31 09:56:00 | AAPL | Stock | 0.3951 | 0.3962 | 0.394 | 0.394 | 1512000.0 |
| 2001-01-31 09:57:00 | AAPL | Stock | 0.3951 | 0.3951 | 0.3929 | 0.3951 | 5129600.0 |
| 2001-01-31 09:58:00 | AAPL | Stock | 0.3951 | 0.3962 | 0.394 | 0.3962 | 4412800.0 |
| 2001-01-31 09:59:00 | AAPL | Stock | 0.3962 | 0.3962 | 0.3951 | 0.3951 | 761600.0 |
| 2001-01-31 10:00:00 | AAPL | Stock | 0.3951 | 0.3962 | 0.394 | 0.3962 | 3673600.0 |
| 2001-01-31 10:01:00 | AAPL | Stock | 0.3951 | 0.3968 | 0.3951 | 0.3962 | 2721600.0 |
| 2001-01-31 10:02:00 | AAPL | Stock | 0.3962 | 0.3973 | 0.3951 | 0.3973 | 6708800.0 |
| 2001-01-31 10:03:00 | AAPL | Stock | 0.3979 | 0.3996 | 0.3962 | 0.3996 | 6669600.0 |
| 2001-01-31 10:04:00 | AAPL | Stock | 0.3996 | 0.4007 | 0.3984 | 0.3984 | 1691200.0 |
| 2001-01-31 10:05:00 | AAPL | Stock | 0.3984 | 0.3996 | 0.3973 | 0.3996 | 2049600.0 |
> showing 50 of 257,411 rows — these rows as CSV