PREVIEW / stock_5min / 2003-06-19
file: by_date/stock_5min/2003/2003-06-19.parquet size: 2.2 MB rows: 156,281 symbols: 1,581
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-19 08:30:00 | AAPL | Stock | 0.3473 | 0.3482 | 0.3473 | 0.348 | 134400.0 |
| 2003-06-19 08:45:00 | AAPL | Stock | 0.3429 | 0.3433 | 0.3429 | 0.343 | 128576.0 |
| 2003-06-19 09:00:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3438 | 0.3438 | 61600.0 |
| 2003-06-19 09:10:00 | AAPL | Stock | 0.3434 | 0.3434 | 0.343 | 0.343 | 72800.0 |
| 2003-06-19 09:15:00 | AAPL | Stock | 0.343 | 0.343 | 0.343 | 0.343 | 11200.0 |
| 2003-06-19 09:20:00 | AAPL | Stock | 0.343 | 0.343 | 0.343 | 0.343 | 28000.0 |
| 2003-06-19 09:25:00 | AAPL | Stock | 0.343 | 0.3457 | 0.342 | 0.3457 | 492800.0 |
| 2003-06-19 09:30:00 | AAPL | Stock | 0.3457 | 0.3457 | 0.3393 | 0.3398 | 11443600.0 |
| 2003-06-19 09:35:00 | AAPL | Stock | 0.3395 | 0.342 | 0.3375 | 0.3418 | 7815528.0 |
| 2003-06-19 09:40:00 | AAPL | Stock | 0.342 | 0.342 | 0.3386 | 0.3395 | 6373976.0 |
| 2003-06-19 09:45:00 | AAPL | Stock | 0.3396 | 0.3399 | 0.3382 | 0.3393 | 3486224.0 |
| 2003-06-19 09:50:00 | AAPL | Stock | 0.3395 | 0.3414 | 0.3393 | 0.3413 | 3170048.0 |
| 2003-06-19 09:55:00 | AAPL | Stock | 0.3413 | 0.3418 | 0.3402 | 0.3405 | 6714848.0 |
| 2003-06-19 10:00:00 | AAPL | Stock | 0.3404 | 0.3409 | 0.3386 | 0.3391 | 7534464.0 |
| 2003-06-19 10:05:00 | AAPL | Stock | 0.3393 | 0.3434 | 0.3391 | 0.3433 | 5955096.0 |
| 2003-06-19 10:10:00 | AAPL | Stock | 0.3436 | 0.3441 | 0.3398 | 0.3402 | 6930952.0 |
| 2003-06-19 10:15:00 | AAPL | Stock | 0.3398 | 0.3407 | 0.3393 | 0.3395 | 6520472.0 |
| 2003-06-19 10:20:00 | AAPL | Stock | 0.3395 | 0.3411 | 0.3395 | 0.3396 | 5188400.0 |
| 2003-06-19 10:25:00 | AAPL | Stock | 0.3395 | 0.3407 | 0.3393 | 0.3407 | 4608800.0 |
| 2003-06-19 10:30:00 | AAPL | Stock | 0.3407 | 0.3407 | 0.3398 | 0.3405 | 2749600.0 |
| 2003-06-19 10:35:00 | AAPL | Stock | 0.3405 | 0.3411 | 0.3395 | 0.3398 | 4323760.0 |
| 2003-06-19 10:40:00 | AAPL | Stock | 0.3398 | 0.34 | 0.3375 | 0.3388 | 7068488.0 |
| 2003-06-19 10:45:00 | AAPL | Stock | 0.3387 | 0.3399 | 0.3384 | 0.3389 | 3005800.0 |
| 2003-06-19 10:50:00 | AAPL | Stock | 0.3389 | 0.3391 | 0.338 | 0.3382 | 2136288.0 |
| 2003-06-19 10:55:00 | AAPL | Stock | 0.3382 | 0.3402 | 0.338 | 0.34 | 2296000.0 |
| 2003-06-19 11:00:00 | AAPL | Stock | 0.34 | 0.34 | 0.3352 | 0.3361 | 6401416.0 |
| 2003-06-19 11:05:00 | AAPL | Stock | 0.3361 | 0.3368 | 0.3357 | 0.3363 | 1646400.0 |
| 2003-06-19 11:10:00 | AAPL | Stock | 0.3363 | 0.3373 | 0.3357 | 0.3371 | 1226792.0 |
| 2003-06-19 11:15:00 | AAPL | Stock | 0.3373 | 0.3373 | 0.3363 | 0.3368 | 806512.0 |
| 2003-06-19 11:20:00 | AAPL | Stock | 0.337 | 0.3373 | 0.3366 | 0.3373 | 2271864.0 |
| 2003-06-19 11:25:00 | AAPL | Stock | 0.3375 | 0.3384 | 0.3373 | 0.338 | 2016000.0 |
| 2003-06-19 11:30:00 | AAPL | Stock | 0.338 | 0.3389 | 0.3379 | 0.338 | 1618400.0 |
| 2003-06-19 11:35:00 | AAPL | Stock | 0.338 | 0.3389 | 0.338 | 0.3384 | 1699096.0 |
| 2003-06-19 11:40:00 | AAPL | Stock | 0.3387 | 0.3398 | 0.3386 | 0.3395 | 1411200.0 |
| 2003-06-19 11:45:00 | AAPL | Stock | 0.3395 | 0.34 | 0.3395 | 0.34 | 1036000.0 |
| 2003-06-19 11:50:00 | AAPL | Stock | 0.3398 | 0.3411 | 0.3398 | 0.34 | 2172800.0 |
| 2003-06-19 11:55:00 | AAPL | Stock | 0.3402 | 0.3404 | 0.3393 | 0.3395 | 1405600.0 |
| 2003-06-19 12:00:00 | AAPL | Stock | 0.3393 | 0.3395 | 0.3373 | 0.3384 | 4486216.0 |
| 2003-06-19 12:05:00 | AAPL | Stock | 0.3384 | 0.3404 | 0.3384 | 0.34 | 6395032.0 |
| 2003-06-19 12:10:00 | AAPL | Stock | 0.34 | 0.3405 | 0.3395 | 0.3405 | 2223200.0 |
| 2003-06-19 12:15:00 | AAPL | Stock | 0.3407 | 0.3411 | 0.34 | 0.3405 | 8496432.0 |
| 2003-06-19 12:20:00 | AAPL | Stock | 0.3407 | 0.342 | 0.3407 | 0.3411 | 4143104.0 |
| 2003-06-19 12:25:00 | AAPL | Stock | 0.3411 | 0.3429 | 0.3411 | 0.3411 | 2645776.0 |
| 2003-06-19 12:30:00 | AAPL | Stock | 0.3411 | 0.342 | 0.3411 | 0.3411 | 5079200.0 |
| 2003-06-19 12:35:00 | AAPL | Stock | 0.3411 | 0.342 | 0.3411 | 0.342 | 2282000.0 |
| 2003-06-19 12:40:00 | AAPL | Stock | 0.342 | 0.342 | 0.3411 | 0.3416 | 1075200.0 |
| 2003-06-19 12:45:00 | AAPL | Stock | 0.3418 | 0.3429 | 0.3414 | 0.3427 | 1012088.0 |
| 2003-06-19 12:50:00 | AAPL | Stock | 0.3429 | 0.3455 | 0.3427 | 0.3454 | 4029200.0 |
| 2003-06-19 12:55:00 | AAPL | Stock | 0.3455 | 0.3455 | 0.3443 | 0.3445 | 3897600.0 |
| 2003-06-19 13:00:00 | AAPL | Stock | 0.3445 | 0.3461 | 0.3443 | 0.3455 | 3970288.0 |
> showing 50 of 156,281 rows — these rows as CSV