PREVIEW / stock_5min / 2008-03-07
file: by_date/stock_5min/2008/2008-03-07.parquet size: 4.4 MB rows: 316,949 symbols: 3,264
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-03-07 07:00:00 | AAPL | Stock | 4.3607 | 4.3607 | 4.3529 | 4.3529 | 68600.0 |
| 2008-03-07 07:05:00 | AAPL | Stock | 4.3607 | 4.3607 | 4.3607 | 4.3607 | 23800.0 |
| 2008-03-07 07:10:00 | AAPL | Stock | 4.3589 | 4.3589 | 4.3571 | 4.3571 | 18200.0 |
| 2008-03-07 07:30:00 | AAPL | Stock | 4.3571 | 4.3571 | 4.3571 | 4.3571 | 16660.0 |
| 2008-03-07 07:35:00 | AAPL | Stock | 4.3536 | 4.3575 | 4.3536 | 4.3575 | 97860.0 |
| 2008-03-07 07:40:00 | AAPL | Stock | 4.3575 | 4.3575 | 4.3518 | 4.3518 | 56000.0 |
| 2008-03-07 07:45:00 | AAPL | Stock | 4.3446 | 4.3446 | 4.3446 | 4.3446 | 53312.0 |
| 2008-03-07 07:55:00 | AAPL | Stock | 4.3561 | 4.3589 | 4.3468 | 4.3589 | 56000.0 |
| 2008-03-07 08:00:00 | AAPL | Stock | 4.3575 | 4.3643 | 4.3493 | 4.35 | 491792.0 |
| 2008-03-07 08:05:00 | AAPL | Stock | 4.3568 | 4.3571 | 4.35 | 4.35 | 114100.0 |
| 2008-03-07 08:10:00 | AAPL | Stock | 4.355 | 4.355 | 4.3414 | 4.3421 | 239092.0 |
| 2008-03-07 08:15:00 | AAPL | Stock | 4.3421 | 4.3786 | 4.3404 | 4.3557 | 1111572.0 |
| 2008-03-07 08:20:00 | AAPL | Stock | 4.3504 | 4.3525 | 4.3382 | 4.3429 | 810628.0 |
| 2008-03-07 08:25:00 | AAPL | Stock | 4.3461 | 4.3571 | 4.3254 | 4.3564 | 1236508.0 |
| 2008-03-07 08:30:00 | AAPL | Stock | 4.3432 | 4.3564 | 4.3032 | 4.3332 | 1496404.0 |
| 2008-03-07 08:35:00 | AAPL | Stock | 4.3307 | 4.3407 | 4.3139 | 4.3211 | 1331540.0 |
| 2008-03-07 08:40:00 | AAPL | Stock | 4.3207 | 4.3304 | 4.3118 | 4.3179 | 596204.0 |
| 2008-03-07 08:45:00 | AAPL | Stock | 4.3211 | 4.3321 | 4.3196 | 4.3257 | 382536.0 |
| 2008-03-07 08:50:00 | AAPL | Stock | 4.3239 | 4.3332 | 4.3218 | 4.3268 | 477960.0 |
| 2008-03-07 08:55:00 | AAPL | Stock | 4.3268 | 4.3282 | 4.3132 | 4.3157 | 359408.0 |
| 2008-03-07 09:00:00 | AAPL | Stock | 4.3161 | 4.3214 | 4.3057 | 4.31 | 274512.0 |
| 2008-03-07 09:05:00 | AAPL | Stock | 4.3071 | 4.3079 | 4.2789 | 4.2868 | 1704472.0 |
| 2008-03-07 09:10:00 | AAPL | Stock | 4.2857 | 4.2939 | 4.2739 | 4.2836 | 972076.0 |
| 2008-03-07 09:15:00 | AAPL | Stock | 4.28 | 4.2929 | 4.28 | 4.2896 | 1048628.0 |
| 2008-03-07 09:20:00 | AAPL | Stock | 4.2861 | 4.2868 | 4.2786 | 4.2789 | 335636.0 |
| 2008-03-07 09:25:00 | AAPL | Stock | 4.2821 | 4.3071 | 4.2807 | 4.3004 | 1202908.0 |
| 2008-03-07 09:30:00 | AAPL | Stock | 4.3011 | 4.3343 | 4.2804 | 4.2861 | 36101184.0 |
| 2008-03-07 09:35:00 | AAPL | Stock | 4.2864 | 4.3254 | 4.2846 | 4.3213 | 31714032.0 |
| 2008-03-07 09:40:00 | AAPL | Stock | 4.3246 | 4.3382 | 4.3071 | 4.3375 | 30355612.0 |
| 2008-03-07 09:45:00 | AAPL | Stock | 4.3375 | 4.3493 | 4.3314 | 4.3354 | 30521764.0 |
| 2008-03-07 09:50:00 | AAPL | Stock | 4.335 | 4.3425 | 4.3182 | 4.3275 | 23981944.0 |
| 2008-03-07 09:55:00 | AAPL | Stock | 4.3275 | 4.3589 | 4.3264 | 4.3464 | 30960076.0 |
| 2008-03-07 10:00:00 | AAPL | Stock | 4.345 | 4.3711 | 4.3443 | 4.3657 | 24264688.0 |
| 2008-03-07 10:05:00 | AAPL | Stock | 4.3657 | 4.37 | 4.3411 | 4.3518 | 25253228.0 |
| 2008-03-07 10:10:00 | AAPL | Stock | 4.3511 | 4.3521 | 4.3321 | 4.3406 | 19762540.0 |
| 2008-03-07 10:15:00 | AAPL | Stock | 4.3404 | 4.3525 | 4.3325 | 4.3443 | 16094176.0 |
| 2008-03-07 10:20:00 | AAPL | Stock | 4.3443 | 4.3604 | 4.3443 | 4.345 | 24425828.0 |
| 2008-03-07 10:25:00 | AAPL | Stock | 4.345 | 4.3507 | 4.3368 | 4.3479 | 14117600.0 |
| 2008-03-07 10:30:00 | AAPL | Stock | 4.3486 | 4.3643 | 4.3421 | 4.3625 | 18501084.0 |
| 2008-03-07 10:35:00 | AAPL | Stock | 4.3621 | 4.3811 | 4.3518 | 4.3771 | 17608192.0 |
| 2008-03-07 10:40:00 | AAPL | Stock | 4.3764 | 4.3921 | 4.3714 | 4.3804 | 23880668.0 |
| 2008-03-07 10:45:00 | AAPL | Stock | 4.3804 | 4.3896 | 4.3786 | 4.3789 | 13902784.0 |
| 2008-03-07 10:50:00 | AAPL | Stock | 4.38 | 4.38 | 4.3636 | 4.3661 | 14515368.0 |
| 2008-03-07 10:55:00 | AAPL | Stock | 4.3664 | 4.3689 | 4.3575 | 4.3664 | 11574668.0 |
| 2008-03-07 11:00:00 | AAPL | Stock | 4.3664 | 4.3757 | 4.3607 | 4.3661 | 10019660.0 |
| 2008-03-07 11:05:00 | AAPL | Stock | 4.3662 | 4.3696 | 4.3436 | 4.3439 | 12049660.0 |
| 2008-03-07 11:10:00 | AAPL | Stock | 4.3443 | 4.3532 | 4.3386 | 4.3386 | 11631284.0 |
| 2008-03-07 11:15:00 | AAPL | Stock | 4.3386 | 4.3471 | 4.3343 | 4.3429 | 9612708.0 |
| 2008-03-07 11:20:00 | AAPL | Stock | 4.3427 | 4.3507 | 4.3375 | 4.3493 | 8668352.0 |
| 2008-03-07 11:25:00 | AAPL | Stock | 4.3493 | 4.3532 | 4.3393 | 4.3404 | 12442136.0 |
> showing 50 of 316,949 rows — these rows as CSV