PREVIEW / stock_1min / 2003-04-14
file: by_date/stock_1min/2003/2003-04-14.parquet size: 4.2 MB rows: 352,112 symbols: 1,285
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 |
|---|---|---|---|---|---|---|---|
| 2003-04-14 08:00:00 | AAPL | Stock | 0.2446 | 0.2446 | 0.2429 | 0.2439 | 431200.0 |
| 2003-04-14 08:01:00 | AAPL | Stock | 0.2439 | 0.2443 | 0.2411 | 0.2429 | 484400.0 |
| 2003-04-14 08:02:00 | AAPL | Stock | 0.2425 | 0.2429 | 0.2425 | 0.2425 | 79072.0 |
| 2003-04-14 08:03:00 | AAPL | Stock | 0.2425 | 0.2425 | 0.2425 | 0.2425 | 67200.0 |
| 2003-04-14 08:04:00 | AAPL | Stock | 0.242 | 0.242 | 0.242 | 0.242 | 28000.0 |
| 2003-04-14 08:07:00 | AAPL | Stock | 0.242 | 0.2422 | 0.242 | 0.2422 | 224000.0 |
| 2003-04-14 08:08:00 | AAPL | Stock | 0.2429 | 0.2429 | 0.2429 | 0.2429 | 56000.0 |
| 2003-04-14 08:10:00 | AAPL | Stock | 0.2425 | 0.2439 | 0.2425 | 0.2429 | 246400.0 |
| 2003-04-14 08:12:00 | AAPL | Stock | 0.2439 | 0.2439 | 0.2432 | 0.2432 | 61600.0 |
| 2003-04-14 08:13:00 | AAPL | Stock | 0.2432 | 0.2432 | 0.2432 | 0.2432 | 22400.0 |
| 2003-04-14 08:15:00 | AAPL | Stock | 0.2432 | 0.2432 | 0.2432 | 0.2432 | 28000.0 |
| 2003-04-14 08:16:00 | AAPL | Stock | 0.2436 | 0.2436 | 0.2436 | 0.2436 | 67200.0 |
| 2003-04-14 08:17:00 | AAPL | Stock | 0.2436 | 0.2436 | 0.2436 | 0.2436 | 56000.0 |
| 2003-04-14 08:19:00 | AAPL | Stock | 0.2436 | 0.2439 | 0.2436 | 0.2439 | 11200.0 |
| 2003-04-14 08:20:00 | AAPL | Stock | 0.2443 | 0.2446 | 0.2441 | 0.2443 | 39200.0 |
| 2003-04-14 08:21:00 | AAPL | Stock | 0.2443 | 0.2443 | 0.2443 | 0.2443 | 50400.0 |
| 2003-04-14 08:23:00 | AAPL | Stock | 0.2439 | 0.2439 | 0.2439 | 0.2439 | 316400.0 |
| 2003-04-14 08:24:00 | AAPL | Stock | 0.2439 | 0.2439 | 0.2439 | 0.2439 | 16800.0 |
| 2003-04-14 08:25:00 | AAPL | Stock | 0.2443 | 0.2443 | 0.2443 | 0.2443 | 112000.0 |
| 2003-04-14 08:26:00 | AAPL | Stock | 0.2441 | 0.2441 | 0.2441 | 0.2441 | 50400.0 |
| 2003-04-14 08:27:00 | AAPL | Stock | 0.2441 | 0.2441 | 0.2441 | 0.2441 | 61600.0 |
| 2003-04-14 08:28:00 | AAPL | Stock | 0.2439 | 0.2439 | 0.2439 | 0.2439 | 5600.0 |
| 2003-04-14 08:29:00 | AAPL | Stock | 0.2439 | 0.2439 | 0.2439 | 0.2439 | 5600.0 |
| 2003-04-14 08:30:00 | AAPL | Stock | 0.2439 | 0.2439 | 0.2439 | 0.2439 | 44800.0 |
| 2003-04-14 08:32:00 | AAPL | Stock | 0.2429 | 0.2429 | 0.2429 | 0.2429 | 5600.0 |
| 2003-04-14 08:33:00 | AAPL | Stock | 0.2429 | 0.2429 | 0.2429 | 0.2429 | 336000.0 |
| 2003-04-14 08:35:00 | AAPL | Stock | 0.242 | 0.242 | 0.242 | 0.242 | 95200.0 |
| 2003-04-14 08:36:00 | AAPL | Stock | 0.242 | 0.2436 | 0.242 | 0.2436 | 134400.0 |
| 2003-04-14 08:37:00 | AAPL | Stock | 0.242 | 0.2432 | 0.242 | 0.2432 | 44800.0 |
| 2003-04-14 08:39:00 | AAPL | Stock | 0.242 | 0.242 | 0.242 | 0.242 | 39200.0 |
| 2003-04-14 08:40:00 | AAPL | Stock | 0.2416 | 0.2416 | 0.2411 | 0.2411 | 845600.0 |
| 2003-04-14 08:41:00 | AAPL | Stock | 0.2411 | 0.2411 | 0.2411 | 0.2411 | 806400.0 |
| 2003-04-14 08:42:00 | AAPL | Stock | 0.2418 | 0.2418 | 0.2411 | 0.2411 | 375200.0 |
| 2003-04-14 08:43:00 | AAPL | Stock | 0.2411 | 0.2411 | 0.2411 | 0.2411 | 122920.0 |
| 2003-04-14 08:44:00 | AAPL | Stock | 0.2411 | 0.2413 | 0.2411 | 0.2413 | 212800.0 |
| 2003-04-14 08:45:00 | AAPL | Stock | 0.2411 | 0.2411 | 0.2411 | 0.2411 | 22400.0 |
| 2003-04-14 08:46:00 | AAPL | Stock | 0.2411 | 0.2411 | 0.2402 | 0.2402 | 582400.0 |
| 2003-04-14 08:48:00 | AAPL | Stock | 0.2411 | 0.2411 | 0.2411 | 0.2411 | 28000.0 |
| 2003-04-14 08:49:00 | AAPL | Stock | 0.2411 | 0.2411 | 0.2411 | 0.2411 | 22400.0 |
| 2003-04-14 08:53:00 | AAPL | Stock | 0.2411 | 0.2429 | 0.2411 | 0.2427 | 235200.0 |
| 2003-04-14 08:54:00 | AAPL | Stock | 0.2411 | 0.2411 | 0.2411 | 0.2411 | 16800.0 |
| 2003-04-14 08:55:00 | AAPL | Stock | 0.2411 | 0.2411 | 0.2411 | 0.2411 | 44800.0 |
| 2003-04-14 08:56:00 | AAPL | Stock | 0.2411 | 0.2411 | 0.2411 | 0.2411 | 56000.0 |
| 2003-04-14 08:58:00 | AAPL | Stock | 0.242 | 0.2445 | 0.2414 | 0.2445 | 212800.0 |
| 2003-04-14 09:00:00 | AAPL | Stock | 0.2434 | 0.2434 | 0.2434 | 0.2434 | 11200.0 |
| 2003-04-14 09:01:00 | AAPL | Stock | 0.2429 | 0.2429 | 0.2429 | 0.2429 | 308000.0 |
| 2003-04-14 09:02:00 | AAPL | Stock | 0.2429 | 0.2429 | 0.2429 | 0.2429 | 78400.0 |
| 2003-04-14 09:03:00 | AAPL | Stock | 0.2429 | 0.2429 | 0.2429 | 0.2429 | 50400.0 |
| 2003-04-14 09:04:00 | AAPL | Stock | 0.2429 | 0.2429 | 0.2429 | 0.2429 | 50400.0 |
| 2003-04-14 09:06:00 | AAPL | Stock | 0.2432 | 0.2432 | 0.2432 | 0.2432 | 56000.0 |
> showing 50 of 352,112 rows — these rows as CSV