PREVIEW / stock_5min / 2004-11-01
file: by_date/stock_5min/2004/2004-11-01.parquet size: 2.5 MB rows: 181,706 symbols: 1,865
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-11-01 08:00:00 | AAPL | Stock | 0.9358 | 0.9464 | 0.9358 | 0.9464 | 8285088.0 |
| 2004-11-01 08:05:00 | AAPL | Stock | 0.9464 | 0.9482 | 0.9457 | 0.9482 | 552216.0 |
| 2004-11-01 08:10:00 | AAPL | Stock | 0.9488 | 0.9509 | 0.9482 | 0.9509 | 694288.0 |
| 2004-11-01 08:15:00 | AAPL | Stock | 0.9514 | 0.9552 | 0.95 | 0.9536 | 669312.0 |
| 2004-11-01 08:20:00 | AAPL | Stock | 0.9543 | 0.9543 | 0.9357 | 0.9536 | 751800.0 |
| 2004-11-01 08:25:00 | AAPL | Stock | 0.9518 | 0.9527 | 0.9518 | 0.9518 | 128800.0 |
| 2004-11-01 08:30:00 | AAPL | Stock | 0.9518 | 0.9518 | 0.9516 | 0.9516 | 11200.0 |
| 2004-11-01 08:35:00 | AAPL | Stock | 0.9511 | 0.9514 | 0.9509 | 0.9514 | 78512.0 |
| 2004-11-01 08:40:00 | AAPL | Stock | 0.9509 | 0.9509 | 0.95 | 0.95 | 112000.0 |
| 2004-11-01 08:45:00 | AAPL | Stock | 0.9504 | 0.9504 | 0.95 | 0.95 | 117600.0 |
| 2004-11-01 08:50:00 | AAPL | Stock | 0.95 | 0.95 | 0.95 | 0.95 | 61600.0 |
| 2004-11-01 08:55:00 | AAPL | Stock | 0.9486 | 0.95 | 0.9486 | 0.95 | 128800.0 |
| 2004-11-01 09:00:00 | AAPL | Stock | 0.9489 | 0.9489 | 0.9466 | 0.9482 | 347200.0 |
| 2004-11-01 09:05:00 | AAPL | Stock | 0.9482 | 0.9486 | 0.9479 | 0.9479 | 162400.0 |
| 2004-11-01 09:10:00 | AAPL | Stock | 0.9473 | 0.9473 | 0.947 | 0.947 | 78400.0 |
| 2004-11-01 09:15:00 | AAPL | Stock | 0.9468 | 0.9475 | 0.9466 | 0.947 | 280000.0 |
| 2004-11-01 09:20:00 | AAPL | Stock | 0.947 | 0.948 | 0.9446 | 0.9468 | 419888.0 |
| 2004-11-01 09:25:00 | AAPL | Stock | 0.9468 | 0.948 | 0.937 | 0.9373 | 4983944.0 |
| 2004-11-01 09:30:00 | AAPL | Stock | 0.9375 | 0.9429 | 0.9341 | 0.9363 | 25056752.0 |
| 2004-11-01 09:35:00 | AAPL | Stock | 0.9363 | 0.9452 | 0.9341 | 0.943 | 16230816.0 |
| 2004-11-01 09:40:00 | AAPL | Stock | 0.9432 | 0.9496 | 0.9429 | 0.9488 | 14680736.0 |
| 2004-11-01 09:45:00 | AAPL | Stock | 0.9489 | 0.9511 | 0.947 | 0.9486 | 16664312.0 |
| 2004-11-01 09:50:00 | AAPL | Stock | 0.9484 | 0.9489 | 0.9446 | 0.9471 | 9433312.0 |
| 2004-11-01 09:55:00 | AAPL | Stock | 0.9471 | 0.9486 | 0.9386 | 0.9386 | 11100712.0 |
| 2004-11-01 10:00:00 | AAPL | Stock | 0.9388 | 0.9429 | 0.9379 | 0.94 | 18853296.0 |
| 2004-11-01 10:05:00 | AAPL | Stock | 0.94 | 0.9416 | 0.9395 | 0.9404 | 8307432.0 |
| 2004-11-01 10:10:00 | AAPL | Stock | 0.9402 | 0.9402 | 0.9332 | 0.9332 | 12145448.0 |
| 2004-11-01 10:15:00 | AAPL | Stock | 0.9334 | 0.9357 | 0.9323 | 0.9348 | 9785496.0 |
| 2004-11-01 10:20:00 | AAPL | Stock | 0.9346 | 0.9368 | 0.9346 | 0.9359 | 5662048.0 |
| 2004-11-01 10:25:00 | AAPL | Stock | 0.9359 | 0.9393 | 0.9359 | 0.9388 | 5004272.0 |
| 2004-11-01 10:30:00 | AAPL | Stock | 0.9386 | 0.9388 | 0.9352 | 0.9373 | 4366992.0 |
| 2004-11-01 10:35:00 | AAPL | Stock | 0.9373 | 0.9382 | 0.9363 | 0.937 | 3870048.0 |
| 2004-11-01 10:40:00 | AAPL | Stock | 0.9375 | 0.9391 | 0.937 | 0.9375 | 9703008.0 |
| 2004-11-01 10:45:00 | AAPL | Stock | 0.9375 | 0.9389 | 0.9371 | 0.9383 | 5750080.0 |
| 2004-11-01 10:50:00 | AAPL | Stock | 0.9382 | 0.9416 | 0.9377 | 0.94 | 7183344.0 |
| 2004-11-01 10:55:00 | AAPL | Stock | 0.9404 | 0.9438 | 0.9404 | 0.9438 | 9413768.0 |
| 2004-11-01 11:00:00 | AAPL | Stock | 0.9432 | 0.9445 | 0.9429 | 0.9436 | 7597912.0 |
| 2004-11-01 11:05:00 | AAPL | Stock | 0.9436 | 0.9439 | 0.9409 | 0.9429 | 8494472.0 |
| 2004-11-01 11:10:00 | AAPL | Stock | 0.9432 | 0.9434 | 0.9416 | 0.9434 | 3806936.0 |
| 2004-11-01 11:15:00 | AAPL | Stock | 0.9432 | 0.9448 | 0.943 | 0.9441 | 7995960.0 |
| 2004-11-01 11:20:00 | AAPL | Stock | 0.9443 | 0.945 | 0.9434 | 0.9436 | 6974968.0 |
| 2004-11-01 11:25:00 | AAPL | Stock | 0.9436 | 0.9439 | 0.9421 | 0.9432 | 4660992.0 |
| 2004-11-01 11:30:00 | AAPL | Stock | 0.9432 | 0.9434 | 0.9418 | 0.9432 | 3441536.0 |
| 2004-11-01 11:35:00 | AAPL | Stock | 0.9432 | 0.9432 | 0.942 | 0.9421 | 4319672.0 |
| 2004-11-01 11:40:00 | AAPL | Stock | 0.9423 | 0.9429 | 0.9402 | 0.9402 | 4618152.0 |
| 2004-11-01 11:45:00 | AAPL | Stock | 0.9404 | 0.9413 | 0.9384 | 0.9411 | 3906560.0 |
| 2004-11-01 11:50:00 | AAPL | Stock | 0.9409 | 0.9416 | 0.9402 | 0.9413 | 9728544.0 |
| 2004-11-01 11:55:00 | AAPL | Stock | 0.9414 | 0.9429 | 0.9413 | 0.942 | 3562664.0 |
| 2004-11-01 12:00:00 | AAPL | Stock | 0.942 | 0.9425 | 0.942 | 0.9425 | 2119376.0 |
| 2004-11-01 12:05:00 | AAPL | Stock | 0.9425 | 0.9429 | 0.9409 | 0.9421 | 4409888.0 |
> showing 50 of 181,706 rows — these rows as CSV