PREVIEW / stock_5min / 2004-10-29
file: by_date/stock_5min/2004/2004-10-29.parquet size: 2.5 MB rows: 181,599 symbols: 1,858
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-29 08:00:00 | AAPL | Stock | 0.9286 | 0.9311 | 0.9254 | 0.9304 | 79744.0 |
| 2004-10-29 08:05:00 | AAPL | Stock | 0.9286 | 0.9286 | 0.9286 | 0.9286 | 5600.0 |
| 2004-10-29 08:10:00 | AAPL | Stock | 0.9286 | 0.9286 | 0.9286 | 0.9286 | 50400.0 |
| 2004-10-29 08:15:00 | AAPL | Stock | 0.9275 | 0.9275 | 0.9275 | 0.9275 | 11200.0 |
| 2004-10-29 08:25:00 | AAPL | Stock | 0.9284 | 0.9286 | 0.9275 | 0.9286 | 208488.0 |
| 2004-10-29 08:30:00 | AAPL | Stock | 0.9286 | 0.9286 | 0.9268 | 0.927 | 202272.0 |
| 2004-10-29 08:35:00 | AAPL | Stock | 0.927 | 0.927 | 0.927 | 0.927 | 5600.0 |
| 2004-10-29 08:40:00 | AAPL | Stock | 0.9286 | 0.9286 | 0.927 | 0.927 | 38080.0 |
| 2004-10-29 08:45:00 | AAPL | Stock | 0.9286 | 0.9286 | 0.9286 | 0.9286 | 28000.0 |
| 2004-10-29 08:50:00 | AAPL | Stock | 0.9288 | 0.9288 | 0.9277 | 0.9277 | 28000.0 |
| 2004-10-29 08:55:00 | AAPL | Stock | 0.9286 | 0.9293 | 0.9284 | 0.9284 | 39200.0 |
| 2004-10-29 09:00:00 | AAPL | Stock | 0.9282 | 0.9293 | 0.9277 | 0.9293 | 28000.0 |
| 2004-10-29 09:05:00 | AAPL | Stock | 0.9288 | 0.9296 | 0.9277 | 0.9284 | 156800.0 |
| 2004-10-29 09:10:00 | AAPL | Stock | 0.9284 | 0.9284 | 0.9277 | 0.9277 | 106400.0 |
| 2004-10-29 09:25:00 | AAPL | Stock | 0.9295 | 0.9295 | 0.9268 | 0.9284 | 1169056.0 |
| 2004-10-29 09:30:00 | AAPL | Stock | 0.9279 | 0.932 | 0.925 | 0.9316 | 27204856.0 |
| 2004-10-29 09:35:00 | AAPL | Stock | 0.9313 | 0.9375 | 0.9302 | 0.9363 | 21901040.0 |
| 2004-10-29 09:40:00 | AAPL | Stock | 0.9364 | 0.9446 | 0.9352 | 0.9434 | 29310120.0 |
| 2004-10-29 09:45:00 | AAPL | Stock | 0.9432 | 0.9482 | 0.9413 | 0.9455 | 30314816.0 |
| 2004-10-29 09:50:00 | AAPL | Stock | 0.9455 | 0.9461 | 0.9416 | 0.9454 | 17880128.0 |
| 2004-10-29 09:55:00 | AAPL | Stock | 0.9454 | 0.9491 | 0.9445 | 0.9491 | 24558744.0 |
| 2004-10-29 10:00:00 | AAPL | Stock | 0.9488 | 0.95 | 0.943 | 0.9439 | 28094808.0 |
| 2004-10-29 10:05:00 | AAPL | Stock | 0.9439 | 0.9446 | 0.9413 | 0.9436 | 21859208.0 |
| 2004-10-29 10:10:00 | AAPL | Stock | 0.9434 | 0.9439 | 0.9388 | 0.9402 | 10405304.0 |
| 2004-10-29 10:15:00 | AAPL | Stock | 0.9398 | 0.9402 | 0.9371 | 0.9384 | 14225400.0 |
| 2004-10-29 10:20:00 | AAPL | Stock | 0.9384 | 0.9413 | 0.935 | 0.9407 | 25096848.0 |
| 2004-10-29 10:25:00 | AAPL | Stock | 0.9407 | 0.9441 | 0.9396 | 0.9441 | 18659144.0 |
| 2004-10-29 10:30:00 | AAPL | Stock | 0.9443 | 0.9464 | 0.9438 | 0.945 | 24447640.0 |
| 2004-10-29 10:35:00 | AAPL | Stock | 0.945 | 0.9464 | 0.945 | 0.9459 | 12146568.0 |
| 2004-10-29 10:40:00 | AAPL | Stock | 0.9459 | 0.9464 | 0.943 | 0.9448 | 17716832.0 |
| 2004-10-29 10:45:00 | AAPL | Stock | 0.9446 | 0.9464 | 0.9421 | 0.9429 | 12745824.0 |
| 2004-10-29 10:50:00 | AAPL | Stock | 0.9427 | 0.945 | 0.942 | 0.9443 | 11665080.0 |
| 2004-10-29 10:55:00 | AAPL | Stock | 0.9438 | 0.9491 | 0.9434 | 0.9461 | 20707008.0 |
| 2004-10-29 11:00:00 | AAPL | Stock | 0.9459 | 0.9459 | 0.9423 | 0.9443 | 14110432.0 |
| 2004-10-29 11:05:00 | AAPL | Stock | 0.9443 | 0.9464 | 0.9441 | 0.9457 | 7696248.0 |
| 2004-10-29 11:10:00 | AAPL | Stock | 0.9457 | 0.9459 | 0.9448 | 0.9455 | 6297312.0 |
| 2004-10-29 11:15:00 | AAPL | Stock | 0.9457 | 0.9457 | 0.9429 | 0.9439 | 9396576.0 |
| 2004-10-29 11:20:00 | AAPL | Stock | 0.9439 | 0.9457 | 0.9418 | 0.9435 | 10049088.0 |
| 2004-10-29 11:25:00 | AAPL | Stock | 0.9436 | 0.9443 | 0.9416 | 0.9436 | 7208544.0 |
| 2004-10-29 11:30:00 | AAPL | Stock | 0.9434 | 0.9438 | 0.9371 | 0.9382 | 11249560.0 |
| 2004-10-29 11:35:00 | AAPL | Stock | 0.9382 | 0.9421 | 0.9382 | 0.9411 | 9557128.0 |
| 2004-10-29 11:40:00 | AAPL | Stock | 0.9409 | 0.9438 | 0.9407 | 0.9427 | 11418568.0 |
| 2004-10-29 11:45:00 | AAPL | Stock | 0.9429 | 0.9434 | 0.9425 | 0.943 | 3135944.0 |
| 2004-10-29 11:50:00 | AAPL | Stock | 0.943 | 0.945 | 0.9423 | 0.9445 | 4876032.0 |
| 2004-10-29 11:55:00 | AAPL | Stock | 0.9445 | 0.9464 | 0.9441 | 0.9441 | 5245688.0 |
| 2004-10-29 12:00:00 | AAPL | Stock | 0.9443 | 0.9448 | 0.9434 | 0.9438 | 3488520.0 |
| 2004-10-29 12:05:00 | AAPL | Stock | 0.9436 | 0.9439 | 0.942 | 0.9429 | 5604088.0 |
| 2004-10-29 12:10:00 | AAPL | Stock | 0.9429 | 0.9434 | 0.9427 | 0.943 | 3163160.0 |
| 2004-10-29 12:15:00 | AAPL | Stock | 0.943 | 0.9436 | 0.9421 | 0.9421 | 2770656.0 |
| 2004-10-29 12:20:00 | AAPL | Stock | 0.9421 | 0.9425 | 0.9416 | 0.9425 | 2862048.0 |
> showing 50 of 181,599 rows — these rows as CSV