PREVIEW / stock_5min / 2003-01-23
file: by_date/stock_5min/2003/2003-01-23.parquet size: 1.9 MB rows: 136,255 symbols: 1,519
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-01-23 08:00:00 | AAPL | Stock | 0.2488 | 0.2488 | 0.2488 | 0.2488 | 67200.0 |
| 2003-01-23 08:05:00 | AAPL | Stock | 0.2498 | 0.2498 | 0.2498 | 0.2498 | 145600.0 |
| 2003-01-23 08:15:00 | AAPL | Stock | 0.2498 | 0.2504 | 0.2498 | 0.2504 | 128800.0 |
| 2003-01-23 08:30:00 | AAPL | Stock | 0.2491 | 0.2493 | 0.2482 | 0.2482 | 296800.0 |
| 2003-01-23 08:35:00 | AAPL | Stock | 0.25 | 0.2504 | 0.25 | 0.2504 | 134400.0 |
| 2003-01-23 08:50:00 | AAPL | Stock | 0.2493 | 0.2493 | 0.2491 | 0.2491 | 33600.0 |
| 2003-01-23 08:55:00 | AAPL | Stock | 0.25 | 0.2502 | 0.25 | 0.2502 | 89600.0 |
| 2003-01-23 09:00:00 | AAPL | Stock | 0.2504 | 0.2507 | 0.2504 | 0.2507 | 67200.0 |
| 2003-01-23 09:05:00 | AAPL | Stock | 0.2495 | 0.25 | 0.2495 | 0.25 | 89600.0 |
| 2003-01-23 09:15:00 | AAPL | Stock | 0.2525 | 0.2525 | 0.2489 | 0.2489 | 56000.0 |
| 2003-01-23 09:20:00 | AAPL | Stock | 0.2504 | 0.2504 | 0.2504 | 0.2504 | 123200.0 |
| 2003-01-23 09:25:00 | AAPL | Stock | 0.2505 | 0.2509 | 0.2504 | 0.2509 | 263200.0 |
| 2003-01-23 09:30:00 | AAPL | Stock | 0.2509 | 0.2525 | 0.2495 | 0.2504 | 6529264.0 |
| 2003-01-23 09:35:00 | AAPL | Stock | 0.2507 | 0.2518 | 0.2507 | 0.2514 | 3645600.0 |
| 2003-01-23 09:40:00 | AAPL | Stock | 0.2514 | 0.2516 | 0.2509 | 0.2513 | 1893248.0 |
| 2003-01-23 09:45:00 | AAPL | Stock | 0.2513 | 0.2513 | 0.25 | 0.2513 | 2490096.0 |
| 2003-01-23 09:50:00 | AAPL | Stock | 0.2513 | 0.2514 | 0.2502 | 0.2509 | 5020456.0 |
| 2003-01-23 09:55:00 | AAPL | Stock | 0.2509 | 0.2514 | 0.25 | 0.2504 | 2944872.0 |
| 2003-01-23 10:00:00 | AAPL | Stock | 0.2504 | 0.2514 | 0.2498 | 0.2504 | 6984320.0 |
| 2003-01-23 10:05:00 | AAPL | Stock | 0.2507 | 0.2509 | 0.2505 | 0.2505 | 4457600.0 |
| 2003-01-23 10:10:00 | AAPL | Stock | 0.2507 | 0.2507 | 0.25 | 0.2502 | 3905104.0 |
| 2003-01-23 10:15:00 | AAPL | Stock | 0.25 | 0.2502 | 0.2497 | 0.2498 | 2363760.0 |
| 2003-01-23 10:20:00 | AAPL | Stock | 0.2498 | 0.25 | 0.2491 | 0.25 | 2461536.0 |
| 2003-01-23 10:25:00 | AAPL | Stock | 0.2498 | 0.2502 | 0.2498 | 0.25 | 4637864.0 |
| 2003-01-23 10:30:00 | AAPL | Stock | 0.25 | 0.2502 | 0.2495 | 0.25 | 5267080.0 |
| 2003-01-23 10:35:00 | AAPL | Stock | 0.25 | 0.2505 | 0.25 | 0.2505 | 4118912.0 |
| 2003-01-23 10:40:00 | AAPL | Stock | 0.2502 | 0.2507 | 0.25 | 0.2505 | 2728544.0 |
| 2003-01-23 10:45:00 | AAPL | Stock | 0.25 | 0.2505 | 0.25 | 0.2505 | 3253600.0 |
| 2003-01-23 10:50:00 | AAPL | Stock | 0.2505 | 0.2509 | 0.25 | 0.2507 | 4785200.0 |
| 2003-01-23 10:55:00 | AAPL | Stock | 0.2507 | 0.2516 | 0.2505 | 0.2516 | 2721600.0 |
| 2003-01-23 11:00:00 | AAPL | Stock | 0.2516 | 0.2518 | 0.2509 | 0.2518 | 2828000.0 |
| 2003-01-23 11:05:00 | AAPL | Stock | 0.2514 | 0.2516 | 0.2509 | 0.2511 | 2300200.0 |
| 2003-01-23 11:10:00 | AAPL | Stock | 0.2509 | 0.2527 | 0.2509 | 0.2518 | 2366896.0 |
| 2003-01-23 11:15:00 | AAPL | Stock | 0.2516 | 0.2527 | 0.2516 | 0.2516 | 1555512.0 |
| 2003-01-23 11:20:00 | AAPL | Stock | 0.2516 | 0.252 | 0.2514 | 0.2514 | 1920800.0 |
| 2003-01-23 11:25:00 | AAPL | Stock | 0.2516 | 0.2518 | 0.2509 | 0.2518 | 1749272.0 |
| 2003-01-23 11:30:00 | AAPL | Stock | 0.2518 | 0.2518 | 0.2509 | 0.2514 | 3298400.0 |
| 2003-01-23 11:35:00 | AAPL | Stock | 0.2516 | 0.2517 | 0.2511 | 0.2513 | 1411200.0 |
| 2003-01-23 11:40:00 | AAPL | Stock | 0.2514 | 0.252 | 0.2507 | 0.2518 | 883400.0 |
| 2003-01-23 11:45:00 | AAPL | Stock | 0.252 | 0.2534 | 0.2518 | 0.2532 | 4627952.0 |
| 2003-01-23 11:50:00 | AAPL | Stock | 0.2534 | 0.2534 | 0.2525 | 0.2529 | 1464680.0 |
| 2003-01-23 11:55:00 | AAPL | Stock | 0.2529 | 0.2536 | 0.2529 | 0.2532 | 2847880.0 |
| 2003-01-23 12:00:00 | AAPL | Stock | 0.2532 | 0.2541 | 0.2527 | 0.2529 | 2812152.0 |
| 2003-01-23 12:05:00 | AAPL | Stock | 0.253 | 0.253 | 0.2527 | 0.2527 | 1310624.0 |
| 2003-01-23 12:10:00 | AAPL | Stock | 0.2527 | 0.2527 | 0.2523 | 0.2523 | 638400.0 |
| 2003-01-23 12:15:00 | AAPL | Stock | 0.2523 | 0.2525 | 0.252 | 0.2522 | 1897000.0 |
| 2003-01-23 12:20:00 | AAPL | Stock | 0.2521 | 0.2527 | 0.2518 | 0.2525 | 2317000.0 |
| 2003-01-23 12:25:00 | AAPL | Stock | 0.2527 | 0.2529 | 0.2518 | 0.2525 | 3808000.0 |
| 2003-01-23 12:30:00 | AAPL | Stock | 0.2527 | 0.2529 | 0.2521 | 0.2523 | 1103200.0 |
| 2003-01-23 12:35:00 | AAPL | Stock | 0.2521 | 0.2527 | 0.252 | 0.2527 | 840000.0 |
> showing 50 of 136,255 rows — these rows as CSV