PREVIEW / stock_5min / 2004-10-20
file: by_date/stock_5min/2004/2004-10-20.parquet size: 2.5 MB rows: 178,662 symbols: 1,839
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-20 08:00:00 | AAPL | Stock | 0.842 | 0.8465 | 0.842 | 0.842 | 1657600.0 |
| 2004-10-20 08:10:00 | AAPL | Stock | 0.842 | 0.842 | 0.842 | 0.842 | 39200.0 |
| 2004-10-20 08:15:00 | AAPL | Stock | 0.842 | 0.842 | 0.842 | 0.842 | 11368.0 |
| 2004-10-20 08:25:00 | AAPL | Stock | 0.842 | 0.842 | 0.842 | 0.842 | 11200.0 |
| 2004-10-20 08:30:00 | AAPL | Stock | 0.842 | 0.842 | 0.842 | 0.842 | 5600.0 |
| 2004-10-20 08:50:00 | AAPL | Stock | 0.842 | 0.842 | 0.842 | 0.842 | 56000.0 |
| 2004-10-20 09:05:00 | AAPL | Stock | 0.8439 | 0.8439 | 0.8439 | 0.8439 | 33600.0 |
| 2004-10-20 09:10:00 | AAPL | Stock | 0.842 | 0.842 | 0.84 | 0.8418 | 223832.0 |
| 2004-10-20 09:15:00 | AAPL | Stock | 0.8411 | 0.8442 | 0.8411 | 0.8442 | 128800.0 |
| 2004-10-20 09:20:00 | AAPL | Stock | 0.8413 | 0.8429 | 0.8411 | 0.8429 | 22400.0 |
| 2004-10-20 09:25:00 | AAPL | Stock | 0.8429 | 0.8446 | 0.8411 | 0.8411 | 751352.0 |
| 2004-10-20 09:30:00 | AAPL | Stock | 0.8411 | 0.8477 | 0.8402 | 0.8445 | 20266960.0 |
| 2004-10-20 09:35:00 | AAPL | Stock | 0.8446 | 0.845 | 0.8439 | 0.8445 | 11243008.0 |
| 2004-10-20 09:40:00 | AAPL | Stock | 0.8445 | 0.8455 | 0.8438 | 0.8446 | 8181152.0 |
| 2004-10-20 09:45:00 | AAPL | Stock | 0.8446 | 0.8488 | 0.8446 | 0.848 | 11347952.0 |
| 2004-10-20 09:50:00 | AAPL | Stock | 0.848 | 0.8491 | 0.8477 | 0.8482 | 5956496.0 |
| 2004-10-20 09:55:00 | AAPL | Stock | 0.8484 | 0.8486 | 0.8457 | 0.8486 | 4363296.0 |
| 2004-10-20 10:00:00 | AAPL | Stock | 0.8486 | 0.85 | 0.8464 | 0.8479 | 4302592.0 |
| 2004-10-20 10:05:00 | AAPL | Stock | 0.8479 | 0.848 | 0.8455 | 0.8461 | 6727000.0 |
| 2004-10-20 10:10:00 | AAPL | Stock | 0.8455 | 0.8477 | 0.8455 | 0.8473 | 3292016.0 |
| 2004-10-20 10:15:00 | AAPL | Stock | 0.8473 | 0.8473 | 0.8457 | 0.8468 | 2585352.0 |
| 2004-10-20 10:20:00 | AAPL | Stock | 0.8471 | 0.8475 | 0.8454 | 0.8455 | 6965224.0 |
| 2004-10-20 10:25:00 | AAPL | Stock | 0.8455 | 0.8475 | 0.842 | 0.8466 | 9728208.0 |
| 2004-10-20 10:30:00 | AAPL | Stock | 0.8466 | 0.8468 | 0.8413 | 0.8421 | 7893816.0 |
| 2004-10-20 10:35:00 | AAPL | Stock | 0.8421 | 0.8436 | 0.8382 | 0.8391 | 11925648.0 |
| 2004-10-20 10:40:00 | AAPL | Stock | 0.8393 | 0.8396 | 0.838 | 0.8386 | 7123368.0 |
| 2004-10-20 10:45:00 | AAPL | Stock | 0.8386 | 0.8388 | 0.833 | 0.8343 | 21130144.0 |
| 2004-10-20 10:50:00 | AAPL | Stock | 0.8345 | 0.8377 | 0.8339 | 0.8371 | 13388200.0 |
| 2004-10-20 10:55:00 | AAPL | Stock | 0.8371 | 0.8404 | 0.8357 | 0.84 | 11245528.0 |
| 2004-10-20 11:00:00 | AAPL | Stock | 0.8404 | 0.8436 | 0.8398 | 0.8429 | 11026568.0 |
| 2004-10-20 11:05:00 | AAPL | Stock | 0.843 | 0.8434 | 0.8411 | 0.8418 | 10402448.0 |
| 2004-10-20 11:10:00 | AAPL | Stock | 0.842 | 0.8477 | 0.8416 | 0.8464 | 10983392.0 |
| 2004-10-20 11:15:00 | AAPL | Stock | 0.8464 | 0.8466 | 0.8446 | 0.8446 | 4322416.0 |
| 2004-10-20 11:20:00 | AAPL | Stock | 0.8446 | 0.8446 | 0.842 | 0.8432 | 5350016.0 |
| 2004-10-20 11:25:00 | AAPL | Stock | 0.8434 | 0.8464 | 0.8434 | 0.8446 | 5729360.0 |
| 2004-10-20 11:30:00 | AAPL | Stock | 0.8445 | 0.8464 | 0.8429 | 0.8432 | 11811296.0 |
| 2004-10-20 11:35:00 | AAPL | Stock | 0.8434 | 0.8452 | 0.8416 | 0.842 | 6277656.0 |
| 2004-10-20 11:40:00 | AAPL | Stock | 0.8425 | 0.8434 | 0.8414 | 0.843 | 3944528.0 |
| 2004-10-20 11:45:00 | AAPL | Stock | 0.843 | 0.8436 | 0.8411 | 0.8421 | 4571840.0 |
| 2004-10-20 11:50:00 | AAPL | Stock | 0.842 | 0.8429 | 0.8409 | 0.842 | 5291944.0 |
| 2004-10-20 11:55:00 | AAPL | Stock | 0.8416 | 0.8429 | 0.8413 | 0.8427 | 10531360.0 |
| 2004-10-20 12:00:00 | AAPL | Stock | 0.8427 | 0.843 | 0.842 | 0.8423 | 3290840.0 |
| 2004-10-20 12:05:00 | AAPL | Stock | 0.842 | 0.8423 | 0.8382 | 0.8382 | 18964064.0 |
| 2004-10-20 12:10:00 | AAPL | Stock | 0.8382 | 0.8388 | 0.8366 | 0.8382 | 7371280.0 |
| 2004-10-20 12:15:00 | AAPL | Stock | 0.838 | 0.8413 | 0.838 | 0.8404 | 6804560.0 |
| 2004-10-20 12:20:00 | AAPL | Stock | 0.8404 | 0.8413 | 0.8398 | 0.8411 | 2612904.0 |
| 2004-10-20 12:25:00 | AAPL | Stock | 0.8411 | 0.8434 | 0.8409 | 0.8423 | 3135216.0 |
| 2004-10-20 12:30:00 | AAPL | Stock | 0.8427 | 0.8446 | 0.8421 | 0.8421 | 3895920.0 |
| 2004-10-20 12:35:00 | AAPL | Stock | 0.8421 | 0.8423 | 0.84 | 0.8402 | 2916760.0 |
| 2004-10-20 12:40:00 | AAPL | Stock | 0.8402 | 0.8431 | 0.84 | 0.8431 | 5464312.0 |
> showing 50 of 178,662 rows — these rows as CSV