PREVIEW / stock_5min / 2010-03-29
file: by_date/stock_5min/2010/2010-03-29.parquet size: 4.7 MB rows: 325,944 symbols: 3,471
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-29 04:15:00 | AAPL | Stock | 8.3179 | 8.3204 | 8.2964 | 8.3204 | 34104.0 |
| 2010-03-29 04:20:00 | AAPL | Stock | 8.3211 | 8.3211 | 8.3211 | 8.3211 | 2800.0 |
| 2010-03-29 04:30:00 | AAPL | Stock | 8.3214 | 8.3268 | 8.3214 | 8.3268 | 5600.0 |
| 2010-03-29 04:35:00 | AAPL | Stock | 8.3304 | 8.3304 | 8.3304 | 8.3304 | 5600.0 |
| 2010-03-29 05:15:00 | AAPL | Stock | 8.3343 | 8.3571 | 8.3343 | 8.3571 | 9912.0 |
| 2010-03-29 05:25:00 | AAPL | Stock | 8.3679 | 8.3679 | 8.3679 | 8.3679 | 2800.0 |
| 2010-03-29 05:45:00 | AAPL | Stock | 8.3743 | 8.375 | 8.3743 | 8.375 | 11844.0 |
| 2010-03-29 05:50:00 | AAPL | Stock | 8.375 | 8.375 | 8.3571 | 8.3571 | 284956.0 |
| 2010-03-29 05:55:00 | AAPL | Stock | 8.3571 | 8.3571 | 8.3536 | 8.3536 | 36400.0 |
| 2010-03-29 06:15:00 | AAPL | Stock | 8.3571 | 8.3571 | 8.3571 | 8.3571 | 3500.0 |
| 2010-03-29 06:35:00 | AAPL | Stock | 8.3571 | 8.3571 | 8.3571 | 8.3571 | 8400.0 |
| 2010-03-29 06:40:00 | AAPL | Stock | 8.3568 | 8.3568 | 8.3568 | 8.3568 | 2800.0 |
| 2010-03-29 06:50:00 | AAPL | Stock | 8.3525 | 8.3525 | 8.3525 | 8.3525 | 2800.0 |
| 2010-03-29 06:55:00 | AAPL | Stock | 8.3571 | 8.3571 | 8.3571 | 8.3571 | 14000.0 |
| 2010-03-29 07:00:00 | AAPL | Stock | 8.3571 | 8.3625 | 8.3568 | 8.3604 | 106400.0 |
| 2010-03-29 07:05:00 | AAPL | Stock | 8.3575 | 8.3661 | 8.3575 | 8.3661 | 147000.0 |
| 2010-03-29 07:10:00 | AAPL | Stock | 8.3657 | 8.375 | 8.3571 | 8.3604 | 212156.0 |
| 2010-03-29 07:15:00 | AAPL | Stock | 8.3521 | 8.3571 | 8.3432 | 8.3571 | 50400.0 |
| 2010-03-29 07:20:00 | AAPL | Stock | 8.3579 | 8.3579 | 8.3579 | 8.3579 | 28000.0 |
| 2010-03-29 07:25:00 | AAPL | Stock | 8.3536 | 8.3536 | 8.3436 | 8.3518 | 39536.0 |
| 2010-03-29 07:30:00 | AAPL | Stock | 8.3518 | 8.3593 | 8.3482 | 8.35 | 106204.0 |
| 2010-03-29 07:35:00 | AAPL | Stock | 8.3518 | 8.3518 | 8.3514 | 8.3518 | 51100.0 |
| 2010-03-29 07:40:00 | AAPL | Stock | 8.3564 | 8.3564 | 8.3446 | 8.3464 | 56280.0 |
| 2010-03-29 07:45:00 | AAPL | Stock | 8.3464 | 8.3464 | 8.3407 | 8.3407 | 28000.0 |
| 2010-03-29 07:50:00 | AAPL | Stock | 8.3411 | 8.3457 | 8.3411 | 8.3457 | 28000.0 |
| 2010-03-29 07:55:00 | AAPL | Stock | 8.3443 | 8.3443 | 8.3325 | 8.3386 | 112420.0 |
| 2010-03-29 08:00:00 | AAPL | Stock | 8.3589 | 8.3696 | 8.3214 | 8.3321 | 658784.0 |
| 2010-03-29 08:05:00 | AAPL | Stock | 8.3321 | 8.3393 | 8.3321 | 8.3375 | 239820.0 |
| 2010-03-29 08:10:00 | AAPL | Stock | 8.3375 | 8.3429 | 8.3375 | 8.3393 | 241752.0 |
| 2010-03-29 08:15:00 | AAPL | Stock | 8.3421 | 8.3425 | 8.3321 | 8.3368 | 188832.0 |
| 2010-03-29 08:20:00 | AAPL | Stock | 8.3364 | 8.3393 | 8.3354 | 8.3375 | 87640.0 |
| 2010-03-29 08:25:00 | AAPL | Stock | 8.3375 | 8.3393 | 8.3339 | 8.3357 | 148064.0 |
| 2010-03-29 08:30:00 | AAPL | Stock | 8.3357 | 8.3411 | 8.3318 | 8.3318 | 644588.0 |
| 2010-03-29 08:35:00 | AAPL | Stock | 8.3282 | 8.3393 | 8.3282 | 8.3343 | 223580.0 |
| 2010-03-29 08:40:00 | AAPL | Stock | 8.3336 | 8.3371 | 8.3332 | 8.335 | 59808.0 |
| 2010-03-29 08:45:00 | AAPL | Stock | 8.3354 | 8.3361 | 8.3346 | 8.3346 | 30800.0 |
| 2010-03-29 08:50:00 | AAPL | Stock | 8.335 | 8.3386 | 8.3343 | 8.3386 | 162400.0 |
| 2010-03-29 08:55:00 | AAPL | Stock | 8.3386 | 8.3386 | 8.3357 | 8.3357 | 170212.0 |
| 2010-03-29 09:00:00 | AAPL | Stock | 8.3361 | 8.3361 | 8.3271 | 8.3282 | 238364.0 |
| 2010-03-29 09:05:00 | AAPL | Stock | 8.3282 | 8.3357 | 8.3268 | 8.3296 | 427196.0 |
| 2010-03-29 09:10:00 | AAPL | Stock | 8.3304 | 8.3361 | 8.3254 | 8.3257 | 294616.0 |
| 2010-03-29 09:15:00 | AAPL | Stock | 8.3286 | 8.3346 | 8.3132 | 8.3214 | 318304.0 |
| 2010-03-29 09:20:00 | AAPL | Stock | 8.33 | 8.3321 | 8.325 | 8.3271 | 116368.0 |
| 2010-03-29 09:25:00 | AAPL | Stock | 8.3268 | 8.33 | 8.3193 | 8.3214 | 225680.0 |
| 2010-03-29 09:30:00 | AAPL | Stock | 8.3179 | 8.3525 | 8.3129 | 8.3454 | 26050108.0 |
| 2010-03-29 09:35:00 | AAPL | Stock | 8.3454 | 8.3521 | 8.3393 | 8.3477 | 15076964.0 |
| 2010-03-29 09:40:00 | AAPL | Stock | 8.3475 | 8.3489 | 8.3296 | 8.3325 | 11861612.0 |
| 2010-03-29 09:45:00 | AAPL | Stock | 8.3325 | 8.3446 | 8.3286 | 8.3331 | 5735156.0 |
| 2010-03-29 09:50:00 | AAPL | Stock | 8.3332 | 8.3446 | 8.3304 | 8.3371 | 5913348.0 |
| 2010-03-29 09:55:00 | AAPL | Stock | 8.3371 | 8.3429 | 8.3321 | 8.3343 | 8877316.0 |
> showing 50 of 325,944 rows — these rows as CSV