PREVIEW / stock_5min / 2003-07-01
file: by_date/stock_5min/2003/2003-07-01.parquet size: 2.2 MB rows: 156,231 symbols: 1,582
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-07-01 08:00:00 | AAPL | Stock | 0.3409 | 0.3409 | 0.3409 | 0.3409 | 106400.0 |
| 2003-07-01 08:55:00 | AAPL | Stock | 0.3405 | 0.3405 | 0.3405 | 0.3405 | 1859200.0 |
| 2003-07-01 09:00:00 | AAPL | Stock | 0.3395 | 0.3395 | 0.3395 | 0.3395 | 28000.0 |
| 2003-07-01 09:15:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3393 | 0.3393 | 5600.0 |
| 2003-07-01 09:20:00 | AAPL | Stock | 0.3398 | 0.34 | 0.3398 | 0.34 | 341600.0 |
| 2003-07-01 09:25:00 | AAPL | Stock | 0.3375 | 0.3384 | 0.3375 | 0.3379 | 212016.0 |
| 2003-07-01 09:30:00 | AAPL | Stock | 0.337 | 0.338 | 0.3353 | 0.3379 | 5367600.0 |
| 2003-07-01 09:35:00 | AAPL | Stock | 0.3374 | 0.3398 | 0.3361 | 0.3395 | 4060000.0 |
| 2003-07-01 09:40:00 | AAPL | Stock | 0.3396 | 0.3402 | 0.337 | 0.3371 | 5358080.0 |
| 2003-07-01 09:45:00 | AAPL | Stock | 0.3371 | 0.3388 | 0.3371 | 0.3375 | 1842400.0 |
| 2003-07-01 09:50:00 | AAPL | Stock | 0.3377 | 0.3384 | 0.337 | 0.3373 | 700000.0 |
| 2003-07-01 09:55:00 | AAPL | Stock | 0.3373 | 0.3373 | 0.337 | 0.337 | 608384.0 |
| 2003-07-01 10:00:00 | AAPL | Stock | 0.3373 | 0.3375 | 0.3323 | 0.3329 | 5509896.0 |
| 2003-07-01 10:05:00 | AAPL | Stock | 0.3329 | 0.3336 | 0.3309 | 0.333 | 5605880.0 |
| 2003-07-01 10:10:00 | AAPL | Stock | 0.333 | 0.3345 | 0.3325 | 0.3339 | 3269672.0 |
| 2003-07-01 10:15:00 | AAPL | Stock | 0.3339 | 0.3343 | 0.3329 | 0.333 | 2314144.0 |
| 2003-07-01 10:20:00 | AAPL | Stock | 0.3332 | 0.3346 | 0.3321 | 0.3329 | 3539200.0 |
| 2003-07-01 10:25:00 | AAPL | Stock | 0.333 | 0.3332 | 0.3321 | 0.3329 | 3532816.0 |
| 2003-07-01 10:30:00 | AAPL | Stock | 0.3327 | 0.3332 | 0.3321 | 0.3327 | 4026400.0 |
| 2003-07-01 10:35:00 | AAPL | Stock | 0.3329 | 0.3329 | 0.332 | 0.3322 | 2352000.0 |
| 2003-07-01 10:40:00 | AAPL | Stock | 0.332 | 0.3327 | 0.3311 | 0.3311 | 2581600.0 |
| 2003-07-01 10:45:00 | AAPL | Stock | 0.3311 | 0.3313 | 0.3305 | 0.3313 | 3073504.0 |
| 2003-07-01 10:50:00 | AAPL | Stock | 0.3313 | 0.3318 | 0.3311 | 0.3316 | 1041600.0 |
| 2003-07-01 10:55:00 | AAPL | Stock | 0.3316 | 0.332 | 0.3309 | 0.3318 | 1265488.0 |
| 2003-07-01 11:00:00 | AAPL | Stock | 0.3316 | 0.333 | 0.3316 | 0.3329 | 1019200.0 |
| 2003-07-01 11:05:00 | AAPL | Stock | 0.3327 | 0.3338 | 0.3327 | 0.3337 | 1453144.0 |
| 2003-07-01 11:10:00 | AAPL | Stock | 0.3338 | 0.3339 | 0.3334 | 0.3336 | 1008000.0 |
| 2003-07-01 11:15:00 | AAPL | Stock | 0.3336 | 0.3338 | 0.333 | 0.3332 | 771176.0 |
| 2003-07-01 11:20:00 | AAPL | Stock | 0.3332 | 0.3332 | 0.3321 | 0.333 | 892024.0 |
| 2003-07-01 11:25:00 | AAPL | Stock | 0.3327 | 0.3338 | 0.3327 | 0.3334 | 779128.0 |
| 2003-07-01 11:30:00 | AAPL | Stock | 0.3338 | 0.3339 | 0.3332 | 0.3334 | 716800.0 |
| 2003-07-01 11:35:00 | AAPL | Stock | 0.3334 | 0.3338 | 0.3332 | 0.3338 | 404824.0 |
| 2003-07-01 11:40:00 | AAPL | Stock | 0.3338 | 0.3338 | 0.3334 | 0.3334 | 750400.0 |
| 2003-07-01 11:45:00 | AAPL | Stock | 0.3334 | 0.3337 | 0.3332 | 0.3334 | 823200.0 |
| 2003-07-01 11:50:00 | AAPL | Stock | 0.3334 | 0.3338 | 0.3332 | 0.3336 | 873600.0 |
| 2003-07-01 11:55:00 | AAPL | Stock | 0.3338 | 0.3341 | 0.3336 | 0.3341 | 397600.0 |
| 2003-07-01 12:00:00 | AAPL | Stock | 0.3341 | 0.3352 | 0.3341 | 0.3346 | 1534400.0 |
| 2003-07-01 12:05:00 | AAPL | Stock | 0.3346 | 0.3346 | 0.3338 | 0.3344 | 952000.0 |
| 2003-07-01 12:10:00 | AAPL | Stock | 0.3341 | 0.3345 | 0.3339 | 0.3341 | 403200.0 |
| 2003-07-01 12:15:00 | AAPL | Stock | 0.3341 | 0.3352 | 0.3339 | 0.3343 | 1159200.0 |
| 2003-07-01 12:20:00 | AAPL | Stock | 0.3343 | 0.335 | 0.3343 | 0.3346 | 1288000.0 |
| 2003-07-01 12:25:00 | AAPL | Stock | 0.3348 | 0.3348 | 0.3341 | 0.3341 | 736400.0 |
| 2003-07-01 12:30:00 | AAPL | Stock | 0.3341 | 0.3345 | 0.3334 | 0.3334 | 1123248.0 |
| 2003-07-01 12:35:00 | AAPL | Stock | 0.3334 | 0.3334 | 0.3321 | 0.3327 | 1044400.0 |
| 2003-07-01 12:40:00 | AAPL | Stock | 0.3327 | 0.3329 | 0.3323 | 0.3327 | 969416.0 |
| 2003-07-01 12:45:00 | AAPL | Stock | 0.3329 | 0.3336 | 0.3328 | 0.3334 | 785960.0 |
| 2003-07-01 12:50:00 | AAPL | Stock | 0.3336 | 0.3338 | 0.3336 | 0.3336 | 134400.0 |
| 2003-07-01 12:55:00 | AAPL | Stock | 0.3336 | 0.3348 | 0.3336 | 0.3348 | 224000.0 |
| 2003-07-01 13:00:00 | AAPL | Stock | 0.3346 | 0.3366 | 0.3346 | 0.3361 | 2154712.0 |
| 2003-07-01 13:05:00 | AAPL | Stock | 0.3361 | 0.3366 | 0.3355 | 0.3357 | 907200.0 |
> showing 50 of 156,231 rows — these rows as CSV