PREVIEW / stock_5min / 2003-04-28
file: by_date/stock_5min/2003/2003-04-28.parquet size: 2.0 MB rows: 147,162 symbols: 1,579
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-28 08:00:00 | AAPL | Stock | 0.2393 | 0.2393 | 0.2393 | 0.2393 | 56000.0 |
| 2003-04-28 08:20:00 | AAPL | Stock | 0.2402 | 0.2402 | 0.2402 | 0.2402 | 56000.0 |
| 2003-04-28 08:40:00 | AAPL | Stock | 0.2402 | 0.2402 | 0.2402 | 0.2402 | 11200.0 |
| 2003-04-28 09:00:00 | AAPL | Stock | 0.241 | 0.241 | 0.241 | 0.241 | 56000.0 |
| 2003-04-28 09:05:00 | AAPL | Stock | 0.2409 | 0.2409 | 0.2409 | 0.2409 | 56000.0 |
| 2003-04-28 09:25:00 | AAPL | Stock | 0.2411 | 0.2411 | 0.2397 | 0.2405 | 593600.0 |
| 2003-04-28 09:30:00 | AAPL | Stock | 0.2407 | 0.2425 | 0.2398 | 0.2423 | 13951448.0 |
| 2003-04-28 09:35:00 | AAPL | Stock | 0.2423 | 0.2429 | 0.2416 | 0.2429 | 8673000.0 |
| 2003-04-28 09:40:00 | AAPL | Stock | 0.243 | 0.2448 | 0.2427 | 0.2446 | 9824864.0 |
| 2003-04-28 09:45:00 | AAPL | Stock | 0.2448 | 0.2491 | 0.2446 | 0.2479 | 14880880.0 |
| 2003-04-28 09:50:00 | AAPL | Stock | 0.248 | 0.248 | 0.2452 | 0.2471 | 10010000.0 |
| 2003-04-28 09:55:00 | AAPL | Stock | 0.2471 | 0.2486 | 0.2468 | 0.2486 | 6816656.0 |
| 2003-04-28 10:00:00 | AAPL | Stock | 0.2486 | 0.2486 | 0.247 | 0.2473 | 5672800.0 |
| 2003-04-28 10:05:00 | AAPL | Stock | 0.247 | 0.2482 | 0.2466 | 0.2466 | 4563776.0 |
| 2003-04-28 10:10:00 | AAPL | Stock | 0.2466 | 0.2491 | 0.2463 | 0.2491 | 11203584.0 |
| 2003-04-28 10:15:00 | AAPL | Stock | 0.2486 | 0.2493 | 0.2475 | 0.248 | 12546352.0 |
| 2003-04-28 10:20:00 | AAPL | Stock | 0.2482 | 0.2488 | 0.2479 | 0.2479 | 5354720.0 |
| 2003-04-28 10:25:00 | AAPL | Stock | 0.2479 | 0.2484 | 0.2475 | 0.248 | 8185520.0 |
| 2003-04-28 10:30:00 | AAPL | Stock | 0.248 | 0.2488 | 0.248 | 0.2482 | 8346016.0 |
| 2003-04-28 10:35:00 | AAPL | Stock | 0.248 | 0.2484 | 0.2473 | 0.2482 | 7820400.0 |
| 2003-04-28 10:40:00 | AAPL | Stock | 0.2482 | 0.2486 | 0.2473 | 0.2482 | 6039992.0 |
| 2003-04-28 10:45:00 | AAPL | Stock | 0.248 | 0.2482 | 0.247 | 0.2475 | 5471200.0 |
| 2003-04-28 10:50:00 | AAPL | Stock | 0.2473 | 0.2482 | 0.247 | 0.2477 | 5293344.0 |
| 2003-04-28 10:55:00 | AAPL | Stock | 0.2477 | 0.2482 | 0.2473 | 0.2479 | 3019968.0 |
| 2003-04-28 11:00:00 | AAPL | Stock | 0.2479 | 0.2484 | 0.2477 | 0.2479 | 3789240.0 |
| 2003-04-28 11:05:00 | AAPL | Stock | 0.2479 | 0.248 | 0.2473 | 0.2473 | 1654800.0 |
| 2003-04-28 11:10:00 | AAPL | Stock | 0.2473 | 0.2475 | 0.247 | 0.2471 | 4330592.0 |
| 2003-04-28 11:15:00 | AAPL | Stock | 0.2471 | 0.2473 | 0.2466 | 0.2466 | 3906000.0 |
| 2003-04-28 11:20:00 | AAPL | Stock | 0.2466 | 0.2468 | 0.2458 | 0.2458 | 7199192.0 |
| 2003-04-28 11:25:00 | AAPL | Stock | 0.2457 | 0.2463 | 0.2455 | 0.2457 | 5301296.0 |
| 2003-04-28 11:30:00 | AAPL | Stock | 0.2456 | 0.2459 | 0.2455 | 0.2457 | 1722000.0 |
| 2003-04-28 11:35:00 | AAPL | Stock | 0.2455 | 0.2458 | 0.2441 | 0.2448 | 8334648.0 |
| 2003-04-28 11:40:00 | AAPL | Stock | 0.2448 | 0.2458 | 0.2445 | 0.2452 | 3049592.0 |
| 2003-04-28 11:45:00 | AAPL | Stock | 0.2451 | 0.2455 | 0.2448 | 0.245 | 5588800.0 |
| 2003-04-28 11:50:00 | AAPL | Stock | 0.2448 | 0.245 | 0.2446 | 0.2446 | 3399200.0 |
| 2003-04-28 11:55:00 | AAPL | Stock | 0.2448 | 0.245 | 0.2439 | 0.2441 | 6152160.0 |
| 2003-04-28 12:00:00 | AAPL | Stock | 0.2441 | 0.2441 | 0.2429 | 0.243 | 5702256.0 |
| 2003-04-28 12:05:00 | AAPL | Stock | 0.2429 | 0.2434 | 0.242 | 0.242 | 5712224.0 |
| 2003-04-28 12:10:00 | AAPL | Stock | 0.242 | 0.2449 | 0.2411 | 0.2427 | 34448288.0 |
| 2003-04-28 12:15:00 | AAPL | Stock | 0.2429 | 0.2438 | 0.2427 | 0.2434 | 4972744.0 |
| 2003-04-28 12:20:00 | AAPL | Stock | 0.2434 | 0.2441 | 0.2434 | 0.2438 | 2318400.0 |
| 2003-04-28 12:25:00 | AAPL | Stock | 0.2439 | 0.2448 | 0.2438 | 0.2443 | 3868200.0 |
| 2003-04-28 12:30:00 | AAPL | Stock | 0.2443 | 0.2446 | 0.2441 | 0.2443 | 5887280.0 |
| 2003-04-28 12:35:00 | AAPL | Stock | 0.2443 | 0.2445 | 0.2443 | 0.2445 | 2268000.0 |
| 2003-04-28 12:40:00 | AAPL | Stock | 0.2445 | 0.2448 | 0.2443 | 0.2446 | 2783200.0 |
| 2003-04-28 12:45:00 | AAPL | Stock | 0.2446 | 0.2448 | 0.2443 | 0.2446 | 3082800.0 |
| 2003-04-28 12:50:00 | AAPL | Stock | 0.2446 | 0.2448 | 0.2441 | 0.2443 | 3656800.0 |
| 2003-04-28 12:55:00 | AAPL | Stock | 0.2445 | 0.2452 | 0.2444 | 0.245 | 9354688.0 |
| 2003-04-28 13:00:00 | AAPL | Stock | 0.245 | 0.245 | 0.2446 | 0.2448 | 3539200.0 |
| 2003-04-28 13:05:00 | AAPL | Stock | 0.2446 | 0.2448 | 0.2445 | 0.2445 | 3029600.0 |
> showing 50 of 147,162 rows — these rows as CSV