PREVIEW / stock_5min / 2008-05-01
file: by_date/stock_5min/2008/2008-05-01.parquet size: 4.5 MB rows: 313,101 symbols: 3,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 |
|---|---|---|---|---|---|---|---|
| 2008-05-01 07:00:00 | AAPL | Stock | 6.2479 | 6.2711 | 6.2479 | 6.2546 | 44520.0 |
| 2008-05-01 07:05:00 | AAPL | Stock | 6.2607 | 6.2607 | 6.25 | 6.25 | 42000.0 |
| 2008-05-01 07:10:00 | AAPL | Stock | 6.2496 | 6.25 | 6.2464 | 6.25 | 25200.0 |
| 2008-05-01 07:15:00 | AAPL | Stock | 6.2518 | 6.2568 | 6.2518 | 6.2568 | 16800.0 |
| 2008-05-01 07:20:00 | AAPL | Stock | 6.2536 | 6.2536 | 6.2518 | 6.2518 | 5600.0 |
| 2008-05-01 07:25:00 | AAPL | Stock | 6.25 | 6.2571 | 6.25 | 6.2571 | 36400.0 |
| 2008-05-01 07:30:00 | AAPL | Stock | 6.2554 | 6.2554 | 6.2536 | 6.2536 | 16800.0 |
| 2008-05-01 07:35:00 | AAPL | Stock | 6.2571 | 6.2571 | 6.2571 | 6.2571 | 28000.0 |
| 2008-05-01 07:45:00 | AAPL | Stock | 6.2507 | 6.2518 | 6.2507 | 6.2518 | 5600.0 |
| 2008-05-01 07:50:00 | AAPL | Stock | 6.2518 | 6.2639 | 6.25 | 6.2639 | 109704.0 |
| 2008-05-01 07:55:00 | AAPL | Stock | 6.2643 | 6.2643 | 6.2571 | 6.2611 | 28000.0 |
| 2008-05-01 08:00:00 | AAPL | Stock | 6.2643 | 6.285 | 6.2579 | 6.2768 | 1021636.0 |
| 2008-05-01 08:05:00 | AAPL | Stock | 6.2786 | 6.2857 | 6.2718 | 6.2821 | 942200.0 |
| 2008-05-01 08:10:00 | AAPL | Stock | 6.2825 | 6.2825 | 6.2682 | 6.2682 | 517048.0 |
| 2008-05-01 08:15:00 | AAPL | Stock | 6.2718 | 6.2779 | 6.2714 | 6.2746 | 559972.0 |
| 2008-05-01 08:20:00 | AAPL | Stock | 6.2696 | 6.2736 | 6.2125 | 6.2696 | 280000.0 |
| 2008-05-01 08:25:00 | AAPL | Stock | 6.2736 | 6.2775 | 6.2732 | 6.2768 | 139356.0 |
| 2008-05-01 08:30:00 | AAPL | Stock | 6.2779 | 6.2793 | 6.2607 | 6.2743 | 816928.0 |
| 2008-05-01 08:35:00 | AAPL | Stock | 6.2746 | 6.2761 | 6.2714 | 6.2725 | 170044.0 |
| 2008-05-01 08:40:00 | AAPL | Stock | 6.2725 | 6.2725 | 6.2589 | 6.2593 | 374668.0 |
| 2008-05-01 08:45:00 | AAPL | Stock | 6.2593 | 6.2664 | 6.2125 | 6.2607 | 199220.0 |
| 2008-05-01 08:50:00 | AAPL | Stock | 6.2604 | 6.2625 | 6.2571 | 6.2607 | 215180.0 |
| 2008-05-01 08:55:00 | AAPL | Stock | 6.2593 | 6.2611 | 6.2486 | 6.25 | 496048.0 |
| 2008-05-01 09:00:00 | AAPL | Stock | 6.2496 | 6.2546 | 6.2464 | 6.2493 | 570668.0 |
| 2008-05-01 09:05:00 | AAPL | Stock | 6.2525 | 6.2525 | 6.2411 | 6.2411 | 694932.0 |
| 2008-05-01 09:10:00 | AAPL | Stock | 6.2443 | 6.2464 | 6.2407 | 6.2407 | 284480.0 |
| 2008-05-01 09:15:00 | AAPL | Stock | 6.2436 | 6.2446 | 6.2125 | 6.2425 | 428008.0 |
| 2008-05-01 09:20:00 | AAPL | Stock | 6.2411 | 6.2471 | 6.24 | 6.2468 | 528220.0 |
| 2008-05-01 09:25:00 | AAPL | Stock | 6.2446 | 6.2507 | 6.2429 | 6.2486 | 566888.0 |
| 2008-05-01 09:30:00 | AAPL | Stock | 6.2479 | 6.2871 | 6.245 | 6.2679 | 25511780.0 |
| 2008-05-01 09:35:00 | AAPL | Stock | 6.2665 | 6.3036 | 6.2643 | 6.2982 | 18982572.0 |
| 2008-05-01 09:40:00 | AAPL | Stock | 6.2971 | 6.3143 | 6.2893 | 6.3111 | 15376900.0 |
| 2008-05-01 09:45:00 | AAPL | Stock | 6.3121 | 6.3279 | 6.305 | 6.3075 | 22358140.0 |
| 2008-05-01 09:50:00 | AAPL | Stock | 6.3064 | 6.3207 | 6.2957 | 6.3182 | 15649284.0 |
| 2008-05-01 09:55:00 | AAPL | Stock | 6.3179 | 6.325 | 6.3107 | 6.3132 | 18015032.0 |
| 2008-05-01 10:00:00 | AAPL | Stock | 6.315 | 6.3357 | 6.3045 | 6.3354 | 20183688.0 |
| 2008-05-01 10:05:00 | AAPL | Stock | 6.3354 | 6.3379 | 6.3221 | 6.3332 | 16874340.0 |
| 2008-05-01 10:10:00 | AAPL | Stock | 6.3332 | 6.3364 | 6.3082 | 6.3118 | 13772864.0 |
| 2008-05-01 10:15:00 | AAPL | Stock | 6.3129 | 6.3293 | 6.3086 | 6.3237 | 10666768.0 |
| 2008-05-01 10:20:00 | AAPL | Stock | 6.3236 | 6.3286 | 6.3075 | 6.3239 | 10730524.0 |
| 2008-05-01 10:25:00 | AAPL | Stock | 6.3246 | 6.3525 | 6.3243 | 6.3496 | 15732668.0 |
| 2008-05-01 10:30:00 | AAPL | Stock | 6.3496 | 6.3511 | 6.3357 | 6.3418 | 12077128.0 |
| 2008-05-01 10:35:00 | AAPL | Stock | 6.3412 | 6.3475 | 6.3332 | 6.3368 | 9368688.0 |
| 2008-05-01 10:40:00 | AAPL | Stock | 6.3371 | 6.3382 | 6.3196 | 6.3277 | 9553348.0 |
| 2008-05-01 10:45:00 | AAPL | Stock | 6.3282 | 6.3321 | 6.3121 | 6.3125 | 7950264.0 |
| 2008-05-01 10:50:00 | AAPL | Stock | 6.312 | 6.3375 | 6.3118 | 6.3371 | 7705768.0 |
| 2008-05-01 10:55:00 | AAPL | Stock | 6.3364 | 6.3429 | 6.3296 | 6.335 | 8514072.0 |
| 2008-05-01 11:00:00 | AAPL | Stock | 6.3343 | 6.355 | 6.3318 | 6.3546 | 12483464.0 |
| 2008-05-01 11:05:00 | AAPL | Stock | 6.3546 | 6.3625 | 6.3489 | 6.3611 | 13072892.0 |
| 2008-05-01 11:10:00 | AAPL | Stock | 6.3607 | 6.3661 | 6.3514 | 6.3518 | 11425820.0 |
> showing 50 of 313,101 rows — these rows as CSV