PREVIEW / stock_1min / 2001-01-23
file: by_date/stock_1min/2001/2001-01-23.parquet size: 2.8 MB rows: 241,844 symbols: 1,034
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-23 08:02:00 | AAPL | Stock | 0.3432 | 0.3432 | 0.3432 | 0.3432 | 750400.0 |
| 2001-01-23 08:12:00 | AAPL | Stock | 0.3438 | 0.3493 | 0.3438 | 0.3482 | 112000.0 |
| 2001-01-23 08:16:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 5600.0 |
| 2001-01-23 08:27:00 | AAPL | Stock | 0.3398 | 0.3398 | 0.3398 | 0.3398 | 5600.0 |
| 2001-01-23 08:56:00 | AAPL | Stock | 0.3449 | 0.3482 | 0.3449 | 0.3471 | 106400.0 |
| 2001-01-23 08:58:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 44800.0 |
| 2001-01-23 09:02:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 84000.0 |
| 2001-01-23 09:05:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 44800.0 |
| 2001-01-23 09:06:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 56000.0 |
| 2001-01-23 09:07:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 50400.0 |
| 2001-01-23 09:08:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 44800.0 |
| 2001-01-23 09:11:00 | AAPL | Stock | 0.3426 | 0.3426 | 0.3426 | 0.3426 | 168000.0 |
| 2001-01-23 09:12:00 | AAPL | Stock | 0.3426 | 0.3426 | 0.3426 | 0.3426 | 112000.0 |
| 2001-01-23 09:15:00 | AAPL | Stock | 0.3415 | 0.3415 | 0.3415 | 0.3415 | 56000.0 |
| 2001-01-23 09:17:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 11200.0 |
| 2001-01-23 09:18:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 616000.0 |
| 2001-01-23 09:27:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 140000.0 |
| 2001-01-23 09:28:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 862400.0 |
| 2001-01-23 09:29:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 509600.0 |
| 2001-01-23 09:30:00 | AAPL | Stock | 0.3449 | 0.3449 | 0.3438 | 0.3449 | 7431200.0 |
| 2001-01-23 09:31:00 | AAPL | Stock | 0.3443 | 0.346 | 0.3438 | 0.346 | 2167200.0 |
| 2001-01-23 09:32:00 | AAPL | Stock | 0.346 | 0.3471 | 0.3438 | 0.346 | 403200.0 |
| 2001-01-23 09:33:00 | AAPL | Stock | 0.3471 | 0.3471 | 0.3449 | 0.346 | 991200.0 |
| 2001-01-23 09:34:00 | AAPL | Stock | 0.346 | 0.346 | 0.3449 | 0.346 | 952000.0 |
| 2001-01-23 09:35:00 | AAPL | Stock | 0.346 | 0.3471 | 0.3449 | 0.3449 | 470400.0 |
| 2001-01-23 09:36:00 | AAPL | Stock | 0.346 | 0.3471 | 0.346 | 0.346 | 442400.0 |
| 2001-01-23 09:37:00 | AAPL | Stock | 0.3471 | 0.3471 | 0.3449 | 0.346 | 201600.0 |
| 2001-01-23 09:38:00 | AAPL | Stock | 0.3449 | 0.346 | 0.3449 | 0.346 | 1954400.0 |
| 2001-01-23 09:39:00 | AAPL | Stock | 0.346 | 0.346 | 0.3449 | 0.346 | 1769600.0 |
| 2001-01-23 09:40:00 | AAPL | Stock | 0.346 | 0.3471 | 0.3449 | 0.3449 | 2469600.0 |
| 2001-01-23 09:41:00 | AAPL | Stock | 0.346 | 0.3471 | 0.346 | 0.346 | 1338400.0 |
| 2001-01-23 09:42:00 | AAPL | Stock | 0.3471 | 0.3471 | 0.3449 | 0.3449 | 1596000.0 |
| 2001-01-23 09:43:00 | AAPL | Stock | 0.3449 | 0.346 | 0.3438 | 0.3438 | 2139200.0 |
| 2001-01-23 09:44:00 | AAPL | Stock | 0.3438 | 0.3449 | 0.3438 | 0.3438 | 2021600.0 |
| 2001-01-23 09:45:00 | AAPL | Stock | 0.3449 | 0.3449 | 0.3426 | 0.3426 | 1422400.0 |
| 2001-01-23 09:46:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3426 | 0.3426 | 1646400.0 |
| 2001-01-23 09:47:00 | AAPL | Stock | 0.3426 | 0.3438 | 0.3426 | 0.3438 | 1366400.0 |
| 2001-01-23 09:48:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3415 | 0.3426 | 1204000.0 |
| 2001-01-23 09:49:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3421 | 0.3438 | 1237600.0 |
| 2001-01-23 09:50:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3426 | 0.3426 | 352800.0 |
| 2001-01-23 09:51:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3426 | 0.3426 | 1192800.0 |
| 2001-01-23 09:52:00 | AAPL | Stock | 0.3415 | 0.3421 | 0.3415 | 0.3415 | 1383200.0 |
| 2001-01-23 09:53:00 | AAPL | Stock | 0.3415 | 0.3426 | 0.3404 | 0.3404 | 1461600.0 |
| 2001-01-23 09:54:00 | AAPL | Stock | 0.3404 | 0.3415 | 0.3404 | 0.3415 | 1254400.0 |
| 2001-01-23 09:55:00 | AAPL | Stock | 0.3404 | 0.3415 | 0.3404 | 0.3404 | 263200.0 |
| 2001-01-23 09:56:00 | AAPL | Stock | 0.3404 | 0.3415 | 0.3404 | 0.3404 | 128800.0 |
| 2001-01-23 09:57:00 | AAPL | Stock | 0.3415 | 0.3426 | 0.3415 | 0.3415 | 560000.0 |
| 2001-01-23 09:58:00 | AAPL | Stock | 0.3415 | 0.3426 | 0.3404 | 0.3404 | 700000.0 |
| 2001-01-23 09:59:00 | AAPL | Stock | 0.3404 | 0.3415 | 0.3404 | 0.3415 | 196000.0 |
| 2001-01-23 10:00:00 | AAPL | Stock | 0.3404 | 0.3415 | 0.3404 | 0.3415 | 106400.0 |
> showing 50 of 241,844 rows — these rows as CSV