PREVIEW / stock_5min / 2003-06-27
file: by_date/stock_5min/2003/2003-06-27.parquet size: 2.1 MB rows: 153,642 symbols: 1,580
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-06-27 08:00:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3446 | 0.3446 | 5600.0 |
| 2003-06-27 08:45:00 | AAPL | Stock | 0.3446 | 0.3447 | 0.3446 | 0.3446 | 1103200.0 |
| 2003-06-27 09:00:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3446 | 0.3446 | 33600.0 |
| 2003-06-27 09:05:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3446 | 0.3446 | 22400.0 |
| 2003-06-27 09:15:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3446 | 0.3446 | 5600.0 |
| 2003-06-27 09:20:00 | AAPL | Stock | 0.3446 | 0.3446 | 0.3446 | 0.3446 | 117600.0 |
| 2003-06-27 09:25:00 | AAPL | Stock | 0.3455 | 0.3455 | 0.3455 | 0.3455 | 5600.0 |
| 2003-06-27 09:30:00 | AAPL | Stock | 0.3446 | 0.3448 | 0.3411 | 0.3421 | 6599600.0 |
| 2003-06-27 09:35:00 | AAPL | Stock | 0.3419 | 0.3427 | 0.3414 | 0.3423 | 3181696.0 |
| 2003-06-27 09:40:00 | AAPL | Stock | 0.3423 | 0.343 | 0.3411 | 0.3413 | 5099528.0 |
| 2003-06-27 09:45:00 | AAPL | Stock | 0.3411 | 0.3423 | 0.3407 | 0.3418 | 6788712.0 |
| 2003-06-27 09:50:00 | AAPL | Stock | 0.3416 | 0.342 | 0.3396 | 0.3396 | 7203448.0 |
| 2003-06-27 09:55:00 | AAPL | Stock | 0.3396 | 0.3414 | 0.3395 | 0.3409 | 3072552.0 |
| 2003-06-27 10:00:00 | AAPL | Stock | 0.3405 | 0.3414 | 0.3402 | 0.3409 | 9027200.0 |
| 2003-06-27 10:05:00 | AAPL | Stock | 0.3409 | 0.3416 | 0.3409 | 0.3409 | 1997520.0 |
| 2003-06-27 10:10:00 | AAPL | Stock | 0.3414 | 0.342 | 0.3409 | 0.342 | 11774504.0 |
| 2003-06-27 10:15:00 | AAPL | Stock | 0.342 | 0.342 | 0.3411 | 0.3413 | 2860984.0 |
| 2003-06-27 10:20:00 | AAPL | Stock | 0.3414 | 0.3423 | 0.3413 | 0.3418 | 5667200.0 |
| 2003-06-27 10:25:00 | AAPL | Stock | 0.342 | 0.3429 | 0.3418 | 0.3429 | 5679464.0 |
| 2003-06-27 10:30:00 | AAPL | Stock | 0.3429 | 0.3434 | 0.3426 | 0.3429 | 9464448.0 |
| 2003-06-27 10:35:00 | AAPL | Stock | 0.3429 | 0.3432 | 0.3427 | 0.3429 | 3339336.0 |
| 2003-06-27 10:40:00 | AAPL | Stock | 0.3429 | 0.3429 | 0.3423 | 0.3427 | 1306032.0 |
| 2003-06-27 10:45:00 | AAPL | Stock | 0.3427 | 0.3427 | 0.3411 | 0.3421 | 2090648.0 |
| 2003-06-27 10:50:00 | AAPL | Stock | 0.3416 | 0.3418 | 0.3413 | 0.3418 | 1422400.0 |
| 2003-06-27 10:55:00 | AAPL | Stock | 0.3418 | 0.3419 | 0.3413 | 0.3418 | 2704800.0 |
| 2003-06-27 11:00:00 | AAPL | Stock | 0.3416 | 0.342 | 0.3416 | 0.342 | 1611400.0 |
| 2003-06-27 11:05:00 | AAPL | Stock | 0.3418 | 0.3425 | 0.3418 | 0.3418 | 2783200.0 |
| 2003-06-27 11:10:00 | AAPL | Stock | 0.3416 | 0.3418 | 0.34 | 0.3404 | 2645328.0 |
| 2003-06-27 11:15:00 | AAPL | Stock | 0.3404 | 0.3411 | 0.3402 | 0.3411 | 3749704.0 |
| 2003-06-27 11:20:00 | AAPL | Stock | 0.3411 | 0.3411 | 0.3407 | 0.3409 | 1236424.0 |
| 2003-06-27 11:25:00 | AAPL | Stock | 0.3409 | 0.3411 | 0.34 | 0.3404 | 3124800.0 |
| 2003-06-27 11:30:00 | AAPL | Stock | 0.34 | 0.3409 | 0.34 | 0.3409 | 700000.0 |
| 2003-06-27 11:35:00 | AAPL | Stock | 0.3409 | 0.3413 | 0.3402 | 0.3402 | 930608.0 |
| 2003-06-27 11:40:00 | AAPL | Stock | 0.3404 | 0.3404 | 0.3386 | 0.3386 | 3365600.0 |
| 2003-06-27 11:45:00 | AAPL | Stock | 0.3389 | 0.3391 | 0.3373 | 0.338 | 3868984.0 |
| 2003-06-27 11:50:00 | AAPL | Stock | 0.3379 | 0.3386 | 0.3379 | 0.3386 | 263200.0 |
| 2003-06-27 11:55:00 | AAPL | Stock | 0.3382 | 0.3384 | 0.3371 | 0.3379 | 1829016.0 |
| 2003-06-27 12:00:00 | AAPL | Stock | 0.3377 | 0.3382 | 0.3373 | 0.3382 | 946400.0 |
| 2003-06-27 12:05:00 | AAPL | Stock | 0.3381 | 0.3391 | 0.338 | 0.3389 | 1500800.0 |
| 2003-06-27 12:10:00 | AAPL | Stock | 0.3391 | 0.3393 | 0.3373 | 0.3373 | 4355064.0 |
| 2003-06-27 12:15:00 | AAPL | Stock | 0.3373 | 0.3382 | 0.3373 | 0.3377 | 1108800.0 |
| 2003-06-27 12:20:00 | AAPL | Stock | 0.338 | 0.3389 | 0.3375 | 0.3375 | 12505080.0 |
| 2003-06-27 12:25:00 | AAPL | Stock | 0.3377 | 0.3382 | 0.3377 | 0.338 | 828800.0 |
| 2003-06-27 12:30:00 | AAPL | Stock | 0.338 | 0.3386 | 0.338 | 0.3384 | 1136800.0 |
| 2003-06-27 12:35:00 | AAPL | Stock | 0.3384 | 0.3389 | 0.3384 | 0.3384 | 1711696.0 |
| 2003-06-27 12:40:00 | AAPL | Stock | 0.3384 | 0.3391 | 0.3384 | 0.3384 | 1245888.0 |
| 2003-06-27 12:45:00 | AAPL | Stock | 0.3384 | 0.3386 | 0.3379 | 0.3382 | 520800.0 |
| 2003-06-27 12:50:00 | AAPL | Stock | 0.3377 | 0.3381 | 0.3372 | 0.3377 | 1050392.0 |
| 2003-06-27 12:55:00 | AAPL | Stock | 0.3377 | 0.3377 | 0.337 | 0.337 | 1300936.0 |
| 2003-06-27 13:00:00 | AAPL | Stock | 0.3371 | 0.3371 | 0.337 | 0.337 | 1388800.0 |
> showing 50 of 153,642 rows — these rows as CSV