PREVIEW / stock_5min / 2004-10-25
file: by_date/stock_5min/2004/2004-10-25.parquet size: 2.5 MB rows: 181,571 symbols: 1,846
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-25 08:30:00 | AAPL | Stock | 0.8395 | 0.8395 | 0.8393 | 0.8393 | 61600.0 |
| 2004-10-25 09:05:00 | AAPL | Stock | 0.8402 | 0.8402 | 0.8402 | 0.8402 | 33600.0 |
| 2004-10-25 09:10:00 | AAPL | Stock | 0.8402 | 0.8402 | 0.8402 | 0.8402 | 22400.0 |
| 2004-10-25 09:15:00 | AAPL | Stock | 0.8427 | 0.8438 | 0.8423 | 0.8429 | 106960.0 |
| 2004-10-25 09:20:00 | AAPL | Stock | 0.8429 | 0.8429 | 0.8429 | 0.8429 | 11200.0 |
| 2004-10-25 09:25:00 | AAPL | Stock | 0.8439 | 0.8445 | 0.8418 | 0.8429 | 163464.0 |
| 2004-10-25 09:30:00 | AAPL | Stock | 0.8429 | 0.8468 | 0.8405 | 0.8459 | 13697488.0 |
| 2004-10-25 09:35:00 | AAPL | Stock | 0.8459 | 0.8498 | 0.8459 | 0.8482 | 16985136.0 |
| 2004-10-25 09:40:00 | AAPL | Stock | 0.8482 | 0.8543 | 0.848 | 0.8498 | 16764608.0 |
| 2004-10-25 09:45:00 | AAPL | Stock | 0.8498 | 0.8502 | 0.8461 | 0.8461 | 12297600.0 |
| 2004-10-25 09:50:00 | AAPL | Stock | 0.8463 | 0.8473 | 0.8441 | 0.8448 | 9538592.0 |
| 2004-10-25 09:55:00 | AAPL | Stock | 0.8446 | 0.8466 | 0.8427 | 0.8448 | 11918592.0 |
| 2004-10-25 10:00:00 | AAPL | Stock | 0.8448 | 0.8484 | 0.8446 | 0.8479 | 7589232.0 |
| 2004-10-25 10:05:00 | AAPL | Stock | 0.8471 | 0.8482 | 0.8459 | 0.8471 | 3468024.0 |
| 2004-10-25 10:10:00 | AAPL | Stock | 0.847 | 0.8516 | 0.8468 | 0.85 | 13548640.0 |
| 2004-10-25 10:15:00 | AAPL | Stock | 0.85 | 0.8518 | 0.8488 | 0.8518 | 10817128.0 |
| 2004-10-25 10:20:00 | AAPL | Stock | 0.8518 | 0.8518 | 0.8502 | 0.8511 | 8923768.0 |
| 2004-10-25 10:25:00 | AAPL | Stock | 0.8509 | 0.8516 | 0.8484 | 0.8509 | 8416968.0 |
| 2004-10-25 10:30:00 | AAPL | Stock | 0.8509 | 0.8514 | 0.8486 | 0.8488 | 3681048.0 |
| 2004-10-25 10:35:00 | AAPL | Stock | 0.8504 | 0.8504 | 0.8479 | 0.8482 | 5339488.0 |
| 2004-10-25 10:40:00 | AAPL | Stock | 0.8482 | 0.8488 | 0.8479 | 0.848 | 7613928.0 |
| 2004-10-25 10:45:00 | AAPL | Stock | 0.8484 | 0.8484 | 0.8477 | 0.848 | 2596440.0 |
| 2004-10-25 10:50:00 | AAPL | Stock | 0.848 | 0.8484 | 0.847 | 0.8482 | 3653944.0 |
| 2004-10-25 10:55:00 | AAPL | Stock | 0.8482 | 0.8486 | 0.848 | 0.8482 | 3212048.0 |
| 2004-10-25 11:00:00 | AAPL | Stock | 0.848 | 0.8482 | 0.8466 | 0.8466 | 5955208.0 |
| 2004-10-25 11:05:00 | AAPL | Stock | 0.8466 | 0.8482 | 0.8466 | 0.8475 | 3233384.0 |
| 2004-10-25 11:10:00 | AAPL | Stock | 0.8473 | 0.8477 | 0.8448 | 0.8454 | 3637424.0 |
| 2004-10-25 11:15:00 | AAPL | Stock | 0.8454 | 0.8468 | 0.8446 | 0.8466 | 2811592.0 |
| 2004-10-25 11:20:00 | AAPL | Stock | 0.8464 | 0.848 | 0.8461 | 0.8463 | 2999416.0 |
| 2004-10-25 11:25:00 | AAPL | Stock | 0.8463 | 0.8477 | 0.8463 | 0.8473 | 3596488.0 |
| 2004-10-25 11:30:00 | AAPL | Stock | 0.8473 | 0.8477 | 0.8464 | 0.847 | 1483776.0 |
| 2004-10-25 11:35:00 | AAPL | Stock | 0.8473 | 0.8479 | 0.8471 | 0.8477 | 4604824.0 |
| 2004-10-25 11:40:00 | AAPL | Stock | 0.8473 | 0.8482 | 0.847 | 0.8477 | 3378704.0 |
| 2004-10-25 11:45:00 | AAPL | Stock | 0.8477 | 0.8477 | 0.8443 | 0.8448 | 7044240.0 |
| 2004-10-25 11:50:00 | AAPL | Stock | 0.8448 | 0.845 | 0.8421 | 0.8444 | 4564728.0 |
| 2004-10-25 11:55:00 | AAPL | Stock | 0.8443 | 0.8457 | 0.8438 | 0.8443 | 3671752.0 |
| 2004-10-25 12:00:00 | AAPL | Stock | 0.8443 | 0.8448 | 0.8436 | 0.8443 | 4346720.0 |
| 2004-10-25 12:05:00 | AAPL | Stock | 0.8441 | 0.8464 | 0.8441 | 0.8455 | 3548440.0 |
| 2004-10-25 12:10:00 | AAPL | Stock | 0.8459 | 0.8459 | 0.8441 | 0.8457 | 2140712.0 |
| 2004-10-25 12:15:00 | AAPL | Stock | 0.8452 | 0.8455 | 0.8441 | 0.8445 | 2104928.0 |
| 2004-10-25 12:20:00 | AAPL | Stock | 0.8443 | 0.8443 | 0.842 | 0.842 | 6913872.0 |
| 2004-10-25 12:25:00 | AAPL | Stock | 0.842 | 0.8455 | 0.842 | 0.8441 | 4724104.0 |
| 2004-10-25 12:30:00 | AAPL | Stock | 0.8441 | 0.8457 | 0.8436 | 0.8448 | 5642784.0 |
| 2004-10-25 12:35:00 | AAPL | Stock | 0.8451 | 0.8464 | 0.8446 | 0.8461 | 1479688.0 |
| 2004-10-25 12:40:00 | AAPL | Stock | 0.8461 | 0.8464 | 0.8446 | 0.8446 | 2417968.0 |
| 2004-10-25 12:45:00 | AAPL | Stock | 0.8445 | 0.8445 | 0.843 | 0.8445 | 2532544.0 |
| 2004-10-25 12:50:00 | AAPL | Stock | 0.8443 | 0.8446 | 0.8439 | 0.8443 | 854504.0 |
| 2004-10-25 12:55:00 | AAPL | Stock | 0.8445 | 0.8457 | 0.8438 | 0.8455 | 1988504.0 |
| 2004-10-25 13:00:00 | AAPL | Stock | 0.8452 | 0.8479 | 0.8452 | 0.8475 | 6533184.0 |
| 2004-10-25 13:05:00 | AAPL | Stock | 0.8473 | 0.8479 | 0.8466 | 0.8473 | 3020808.0 |
> showing 50 of 181,571 rows — these rows as CSV