PREVIEW / stock_5min / 2004-11-02
file: by_date/stock_5min/2004/2004-11-02.parquet size: 2.5 MB rows: 183,921 symbols: 1,868
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-02 08:00:00 | AAPL | Stock | 0.9393 | 0.9402 | 0.9393 | 0.9402 | 72800.0 |
| 2004-11-02 08:05:00 | AAPL | Stock | 0.9393 | 0.9393 | 0.9393 | 0.9393 | 56000.0 |
| 2004-11-02 08:10:00 | AAPL | Stock | 0.9393 | 0.9393 | 0.9393 | 0.9393 | 5600.0 |
| 2004-11-02 08:15:00 | AAPL | Stock | 0.9393 | 0.9393 | 0.9393 | 0.9393 | 22400.0 |
| 2004-11-02 08:20:00 | AAPL | Stock | 0.9393 | 0.9402 | 0.9384 | 0.9402 | 45808.0 |
| 2004-11-02 08:25:00 | AAPL | Stock | 0.9393 | 0.9393 | 0.9393 | 0.9393 | 28000.0 |
| 2004-11-02 08:30:00 | AAPL | Stock | 0.9402 | 0.9402 | 0.9393 | 0.9393 | 17976.0 |
| 2004-11-02 08:45:00 | AAPL | Stock | 0.9393 | 0.9393 | 0.9384 | 0.9384 | 44800.0 |
| 2004-11-02 08:55:00 | AAPL | Stock | 0.9384 | 0.9384 | 0.9384 | 0.9384 | 11200.0 |
| 2004-11-02 09:05:00 | AAPL | Stock | 0.9393 | 0.9436 | 0.9393 | 0.9436 | 2194024.0 |
| 2004-11-02 09:10:00 | AAPL | Stock | 0.9384 | 0.9384 | 0.9379 | 0.9379 | 61600.0 |
| 2004-11-02 09:15:00 | AAPL | Stock | 0.9375 | 0.9375 | 0.9375 | 0.9375 | 86912.0 |
| 2004-11-02 09:20:00 | AAPL | Stock | 0.9375 | 0.9375 | 0.9368 | 0.9368 | 95200.0 |
| 2004-11-02 09:25:00 | AAPL | Stock | 0.937 | 0.9377 | 0.9348 | 0.9355 | 1558928.0 |
| 2004-11-02 09:30:00 | AAPL | Stock | 0.9363 | 0.9379 | 0.9357 | 0.9368 | 21918680.0 |
| 2004-11-02 09:35:00 | AAPL | Stock | 0.937 | 0.9396 | 0.9368 | 0.9389 | 12988080.0 |
| 2004-11-02 09:40:00 | AAPL | Stock | 0.9393 | 0.9407 | 0.9373 | 0.9389 | 8705704.0 |
| 2004-11-02 09:45:00 | AAPL | Stock | 0.9389 | 0.9405 | 0.9379 | 0.9388 | 13059312.0 |
| 2004-11-02 09:50:00 | AAPL | Stock | 0.9388 | 0.9427 | 0.9382 | 0.9413 | 16100112.0 |
| 2004-11-02 09:55:00 | AAPL | Stock | 0.9409 | 0.9425 | 0.9393 | 0.9393 | 12690272.0 |
| 2004-11-02 10:00:00 | AAPL | Stock | 0.9396 | 0.94 | 0.9384 | 0.9388 | 8798440.0 |
| 2004-11-02 10:05:00 | AAPL | Stock | 0.9386 | 0.9416 | 0.9382 | 0.9393 | 7608104.0 |
| 2004-11-02 10:10:00 | AAPL | Stock | 0.9396 | 0.9425 | 0.9396 | 0.9413 | 13803664.0 |
| 2004-11-02 10:15:00 | AAPL | Stock | 0.9411 | 0.942 | 0.9402 | 0.9407 | 9421496.0 |
| 2004-11-02 10:20:00 | AAPL | Stock | 0.9405 | 0.9439 | 0.9405 | 0.943 | 15263528.0 |
| 2004-11-02 10:25:00 | AAPL | Stock | 0.943 | 0.9439 | 0.942 | 0.9434 | 13634768.0 |
| 2004-11-02 10:30:00 | AAPL | Stock | 0.9436 | 0.9464 | 0.9434 | 0.9454 | 20730864.0 |
| 2004-11-02 10:35:00 | AAPL | Stock | 0.945 | 0.9463 | 0.9441 | 0.9448 | 13538728.0 |
| 2004-11-02 10:40:00 | AAPL | Stock | 0.9446 | 0.9457 | 0.9425 | 0.9448 | 8692600.0 |
| 2004-11-02 10:45:00 | AAPL | Stock | 0.9448 | 0.9454 | 0.9441 | 0.9446 | 4804016.0 |
| 2004-11-02 10:50:00 | AAPL | Stock | 0.9448 | 0.9452 | 0.9441 | 0.9445 | 3659264.0 |
| 2004-11-02 10:55:00 | AAPL | Stock | 0.9446 | 0.9463 | 0.9443 | 0.9461 | 5406352.0 |
| 2004-11-02 11:00:00 | AAPL | Stock | 0.9461 | 0.9473 | 0.9457 | 0.9464 | 10528560.0 |
| 2004-11-02 11:05:00 | AAPL | Stock | 0.9463 | 0.9477 | 0.9446 | 0.9457 | 8442840.0 |
| 2004-11-02 11:10:00 | AAPL | Stock | 0.9457 | 0.9464 | 0.9446 | 0.9463 | 5945352.0 |
| 2004-11-02 11:15:00 | AAPL | Stock | 0.9464 | 0.9464 | 0.9446 | 0.9454 | 5913040.0 |
| 2004-11-02 11:20:00 | AAPL | Stock | 0.9454 | 0.9466 | 0.945 | 0.9464 | 3206560.0 |
| 2004-11-02 11:25:00 | AAPL | Stock | 0.9464 | 0.9466 | 0.9455 | 0.9457 | 2246944.0 |
| 2004-11-02 11:30:00 | AAPL | Stock | 0.9463 | 0.9464 | 0.9454 | 0.9459 | 2356312.0 |
| 2004-11-02 11:35:00 | AAPL | Stock | 0.9459 | 0.9464 | 0.9455 | 0.9463 | 3235456.0 |
| 2004-11-02 11:40:00 | AAPL | Stock | 0.9463 | 0.9468 | 0.9461 | 0.9464 | 5146232.0 |
| 2004-11-02 11:45:00 | AAPL | Stock | 0.9463 | 0.9473 | 0.9454 | 0.9471 | 5832792.0 |
| 2004-11-02 11:50:00 | AAPL | Stock | 0.9471 | 0.9471 | 0.9457 | 0.9464 | 4406584.0 |
| 2004-11-02 11:55:00 | AAPL | Stock | 0.9464 | 0.9473 | 0.9461 | 0.9463 | 4148816.0 |
| 2004-11-02 12:00:00 | AAPL | Stock | 0.9464 | 0.9464 | 0.9455 | 0.9464 | 3127656.0 |
| 2004-11-02 12:05:00 | AAPL | Stock | 0.9463 | 0.947 | 0.9461 | 0.9464 | 3748640.0 |
| 2004-11-02 12:10:00 | AAPL | Stock | 0.9464 | 0.9466 | 0.9461 | 0.9464 | 3102344.0 |
| 2004-11-02 12:15:00 | AAPL | Stock | 0.9464 | 0.9466 | 0.9461 | 0.9464 | 6413456.0 |
| 2004-11-02 12:20:00 | AAPL | Stock | 0.9466 | 0.947 | 0.9463 | 0.9468 | 5244008.0 |
| 2004-11-02 12:25:00 | AAPL | Stock | 0.9464 | 0.9468 | 0.9461 | 0.9463 | 1960560.0 |
> showing 50 of 183,921 rows — these rows as CSV