PREVIEW / stock_1min / 2003-04-24
file: by_date/stock_1min/2003/2003-04-24.parquet size: 4.4 MB rows: 365,691 symbols: 1,281
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-24 08:30:00 | AAPL | Stock | 0.2423 | 0.2423 | 0.2423 | 0.2423 | 28000.0 |
| 2003-04-24 08:47:00 | AAPL | Stock | 0.2411 | 0.2411 | 0.2411 | 0.2411 | 5600.0 |
| 2003-04-24 09:05:00 | AAPL | Stock | 0.2427 | 0.2427 | 0.2427 | 0.2427 | 1338400.0 |
| 2003-04-24 09:06:00 | AAPL | Stock | 0.2411 | 0.2411 | 0.2411 | 0.2411 | 168000.0 |
| 2003-04-24 09:08:00 | AAPL | Stock | 0.2411 | 0.2411 | 0.2411 | 0.2411 | 50400.0 |
| 2003-04-24 09:25:00 | AAPL | Stock | 0.242 | 0.242 | 0.242 | 0.242 | 14000.0 |
| 2003-04-24 09:29:00 | AAPL | Stock | 0.242 | 0.2425 | 0.2414 | 0.2423 | 764400.0 |
| 2003-04-24 09:30:00 | AAPL | Stock | 0.2414 | 0.2423 | 0.2411 | 0.2416 | 1737400.0 |
| 2003-04-24 09:31:00 | AAPL | Stock | 0.2413 | 0.2418 | 0.2411 | 0.2413 | 1031240.0 |
| 2003-04-24 09:32:00 | AAPL | Stock | 0.2411 | 0.2427 | 0.2404 | 0.2414 | 2602600.0 |
| 2003-04-24 09:33:00 | AAPL | Stock | 0.2407 | 0.2416 | 0.2407 | 0.2416 | 369600.0 |
| 2003-04-24 09:34:00 | AAPL | Stock | 0.2416 | 0.2416 | 0.2414 | 0.2414 | 470400.0 |
| 2003-04-24 09:35:00 | AAPL | Stock | 0.2414 | 0.2418 | 0.2414 | 0.2418 | 358400.0 |
| 2003-04-24 09:36:00 | AAPL | Stock | 0.2414 | 0.2416 | 0.2412 | 0.2414 | 1114400.0 |
| 2003-04-24 09:37:00 | AAPL | Stock | 0.2414 | 0.2418 | 0.2414 | 0.2418 | 1652000.0 |
| 2003-04-24 09:38:00 | AAPL | Stock | 0.242 | 0.242 | 0.2416 | 0.2416 | 1292424.0 |
| 2003-04-24 09:39:00 | AAPL | Stock | 0.2416 | 0.242 | 0.2416 | 0.2416 | 1068592.0 |
| 2003-04-24 09:40:00 | AAPL | Stock | 0.2418 | 0.2421 | 0.2416 | 0.242 | 641312.0 |
| 2003-04-24 09:41:00 | AAPL | Stock | 0.2421 | 0.2429 | 0.2418 | 0.2429 | 1551200.0 |
| 2003-04-24 09:42:00 | AAPL | Stock | 0.2427 | 0.243 | 0.2423 | 0.2423 | 403200.0 |
| 2003-04-24 09:43:00 | AAPL | Stock | 0.2421 | 0.2421 | 0.2416 | 0.2421 | 1504216.0 |
| 2003-04-24 09:44:00 | AAPL | Stock | 0.2418 | 0.2418 | 0.2414 | 0.2416 | 1470000.0 |
| 2003-04-24 09:45:00 | AAPL | Stock | 0.2416 | 0.242 | 0.2416 | 0.2416 | 744800.0 |
| 2003-04-24 09:46:00 | AAPL | Stock | 0.2418 | 0.2427 | 0.2416 | 0.2418 | 1224048.0 |
| 2003-04-24 09:47:00 | AAPL | Stock | 0.2418 | 0.242 | 0.2415 | 0.2416 | 427448.0 |
| 2003-04-24 09:48:00 | AAPL | Stock | 0.2414 | 0.2418 | 0.2405 | 0.2405 | 3029600.0 |
| 2003-04-24 09:49:00 | AAPL | Stock | 0.2407 | 0.2411 | 0.2407 | 0.2411 | 515200.0 |
| 2003-04-24 09:50:00 | AAPL | Stock | 0.2411 | 0.2413 | 0.2411 | 0.2411 | 296800.0 |
| 2003-04-24 09:51:00 | AAPL | Stock | 0.2411 | 0.2421 | 0.2411 | 0.2421 | 2041200.0 |
| 2003-04-24 09:52:00 | AAPL | Stock | 0.2422 | 0.2422 | 0.2413 | 0.242 | 319200.0 |
| 2003-04-24 09:53:00 | AAPL | Stock | 0.2418 | 0.242 | 0.2409 | 0.2416 | 274400.0 |
| 2003-04-24 09:54:00 | AAPL | Stock | 0.2416 | 0.2418 | 0.2413 | 0.2413 | 257600.0 |
| 2003-04-24 09:55:00 | AAPL | Stock | 0.2414 | 0.2414 | 0.2405 | 0.2411 | 538888.0 |
| 2003-04-24 09:56:00 | AAPL | Stock | 0.2409 | 0.2409 | 0.2407 | 0.2409 | 369992.0 |
| 2003-04-24 09:57:00 | AAPL | Stock | 0.2409 | 0.2409 | 0.2404 | 0.2405 | 680288.0 |
| 2003-04-24 09:58:00 | AAPL | Stock | 0.2404 | 0.2405 | 0.2402 | 0.2404 | 436800.0 |
| 2003-04-24 09:59:00 | AAPL | Stock | 0.2404 | 0.2409 | 0.2402 | 0.2404 | 1022112.0 |
| 2003-04-24 10:00:00 | AAPL | Stock | 0.2405 | 0.2408 | 0.2404 | 0.2407 | 787976.0 |
| 2003-04-24 10:01:00 | AAPL | Stock | 0.2407 | 0.2408 | 0.2404 | 0.2404 | 829976.0 |
| 2003-04-24 10:02:00 | AAPL | Stock | 0.2404 | 0.2409 | 0.2402 | 0.2407 | 369600.0 |
| 2003-04-24 10:03:00 | AAPL | Stock | 0.2405 | 0.2405 | 0.2402 | 0.2404 | 873712.0 |
| 2003-04-24 10:04:00 | AAPL | Stock | 0.2404 | 0.2405 | 0.2402 | 0.2404 | 672000.0 |
| 2003-04-24 10:05:00 | AAPL | Stock | 0.2404 | 0.2405 | 0.2404 | 0.2405 | 924000.0 |
| 2003-04-24 10:06:00 | AAPL | Stock | 0.2405 | 0.2405 | 0.2404 | 0.2404 | 706216.0 |
| 2003-04-24 10:07:00 | AAPL | Stock | 0.2404 | 0.2405 | 0.2402 | 0.2404 | 1105328.0 |
| 2003-04-24 10:08:00 | AAPL | Stock | 0.2405 | 0.2405 | 0.2404 | 0.2404 | 235200.0 |
| 2003-04-24 10:09:00 | AAPL | Stock | 0.2404 | 0.2405 | 0.2404 | 0.2405 | 759808.0 |
| 2003-04-24 10:10:00 | AAPL | Stock | 0.2405 | 0.2409 | 0.2404 | 0.2404 | 879200.0 |
| 2003-04-24 10:11:00 | AAPL | Stock | 0.2404 | 0.2405 | 0.2404 | 0.2405 | 168000.0 |
| 2003-04-24 10:12:00 | AAPL | Stock | 0.2405 | 0.2405 | 0.24 | 0.2405 | 1951768.0 |
> showing 50 of 365,691 rows — these rows as CSV