PREVIEW / stock_5min / 2009-04-02
file: by_date/stock_5min/2009/2009-04-02.parquet size: 4.7 MB rows: 325,543 symbols: 3,334
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 |
|---|---|---|---|---|---|---|---|
| 2009-04-02 04:30:00 | AAPL | Stock | 3.9321 | 3.9321 | 3.9321 | 3.9321 | 2800.0 |
| 2009-04-02 05:05:00 | AAPL | Stock | 3.9321 | 3.9321 | 3.9321 | 3.9321 | 17248.0 |
| 2009-04-02 05:20:00 | AAPL | Stock | 3.9696 | 3.9696 | 3.9696 | 3.9696 | 2800.0 |
| 2009-04-02 05:35:00 | AAPL | Stock | 3.9779 | 3.9786 | 3.9779 | 3.9786 | 6300.0 |
| 2009-04-02 05:55:00 | AAPL | Stock | 3.9796 | 3.9796 | 3.9796 | 3.9796 | 9800.0 |
| 2009-04-02 06:00:00 | AAPL | Stock | 3.9582 | 3.9589 | 3.9582 | 3.9589 | 12600.0 |
| 2009-04-02 06:30:00 | AAPL | Stock | 3.965 | 3.965 | 3.965 | 3.965 | 2800.0 |
| 2009-04-02 06:40:00 | AAPL | Stock | 3.9821 | 3.9821 | 3.9821 | 3.9821 | 2800.0 |
| 2009-04-02 06:50:00 | AAPL | Stock | 3.965 | 3.965 | 3.965 | 3.965 | 2800.0 |
| 2009-04-02 06:55:00 | AAPL | Stock | 3.9646 | 3.9646 | 3.9646 | 3.9646 | 2800.0 |
| 2009-04-02 07:05:00 | AAPL | Stock | 3.9646 | 3.9646 | 3.9643 | 3.9643 | 8400.0 |
| 2009-04-02 07:30:00 | AAPL | Stock | 3.9546 | 3.9546 | 3.9546 | 3.9546 | 5600.0 |
| 2009-04-02 07:35:00 | AAPL | Stock | 3.9454 | 3.9454 | 3.9375 | 3.9382 | 50400.0 |
| 2009-04-02 07:40:00 | AAPL | Stock | 3.9375 | 3.9375 | 3.9375 | 3.9375 | 5320.0 |
| 2009-04-02 07:45:00 | AAPL | Stock | 3.9514 | 3.9514 | 3.9514 | 3.9514 | 2800.0 |
| 2009-04-02 07:50:00 | AAPL | Stock | 3.9514 | 3.9514 | 3.9514 | 3.9514 | 12600.0 |
| 2009-04-02 07:55:00 | AAPL | Stock | 3.9371 | 3.9371 | 3.9371 | 3.9371 | 2800.0 |
| 2009-04-02 08:00:00 | AAPL | Stock | 3.9411 | 3.9518 | 3.8818 | 3.9393 | 2185904.0 |
| 2009-04-02 08:05:00 | AAPL | Stock | 3.9429 | 3.9429 | 3.9382 | 3.9382 | 154000.0 |
| 2009-04-02 08:10:00 | AAPL | Stock | 3.9379 | 3.9393 | 3.9364 | 3.9393 | 99484.0 |
| 2009-04-02 08:15:00 | AAPL | Stock | 3.9393 | 3.9464 | 3.9393 | 3.9461 | 111188.0 |
| 2009-04-02 08:20:00 | AAPL | Stock | 3.9429 | 3.9429 | 3.9425 | 3.9425 | 15148.0 |
| 2009-04-02 08:25:00 | AAPL | Stock | 3.9425 | 3.9464 | 3.9425 | 3.9446 | 273000.0 |
| 2009-04-02 08:30:00 | AAPL | Stock | 3.9439 | 3.9464 | 3.9375 | 3.9375 | 288764.0 |
| 2009-04-02 08:35:00 | AAPL | Stock | 3.9354 | 3.9393 | 3.9346 | 3.9393 | 223748.0 |
| 2009-04-02 08:40:00 | AAPL | Stock | 3.9393 | 3.9393 | 3.93 | 3.9375 | 367136.0 |
| 2009-04-02 08:45:00 | AAPL | Stock | 3.9393 | 3.9425 | 3.9393 | 3.9425 | 40040.0 |
| 2009-04-02 08:50:00 | AAPL | Stock | 3.9393 | 3.9429 | 3.9325 | 3.9325 | 143360.0 |
| 2009-04-02 08:55:00 | AAPL | Stock | 3.9325 | 3.9393 | 3.9321 | 3.9375 | 54348.0 |
| 2009-04-02 09:00:00 | AAPL | Stock | 3.9364 | 3.9393 | 3.9329 | 3.9379 | 71400.0 |
| 2009-04-02 09:05:00 | AAPL | Stock | 3.9371 | 3.9446 | 3.9371 | 3.9446 | 243600.0 |
| 2009-04-02 09:10:00 | AAPL | Stock | 3.9457 | 3.9482 | 3.94 | 3.9482 | 305648.0 |
| 2009-04-02 09:15:00 | AAPL | Stock | 3.9479 | 3.95 | 3.9457 | 3.9482 | 193340.0 |
| 2009-04-02 09:20:00 | AAPL | Stock | 3.9482 | 3.9482 | 3.9407 | 3.9414 | 59612.0 |
| 2009-04-02 09:25:00 | AAPL | Stock | 3.9414 | 3.945 | 3.9289 | 3.9289 | 437892.0 |
| 2009-04-02 09:30:00 | AAPL | Stock | 3.9336 | 3.95 | 3.9286 | 3.9411 | 19980660.0 |
| 2009-04-02 09:35:00 | AAPL | Stock | 3.9421 | 3.9457 | 3.9221 | 3.9436 | 15141560.0 |
| 2009-04-02 09:40:00 | AAPL | Stock | 3.9446 | 3.9514 | 3.9207 | 3.9475 | 17017672.0 |
| 2009-04-02 09:45:00 | AAPL | Stock | 3.9471 | 3.9593 | 3.9357 | 3.9539 | 11180792.0 |
| 2009-04-02 09:50:00 | AAPL | Stock | 3.9539 | 3.9643 | 3.9371 | 3.9604 | 10973172.0 |
| 2009-04-02 09:55:00 | AAPL | Stock | 3.9614 | 3.9732 | 3.9525 | 3.9732 | 14751828.0 |
| 2009-04-02 10:00:00 | AAPL | Stock | 3.9732 | 3.9821 | 3.9694 | 3.9757 | 9954140.0 |
| 2009-04-02 10:05:00 | AAPL | Stock | 3.9764 | 3.9839 | 3.9704 | 3.9793 | 12225164.0 |
| 2009-04-02 10:10:00 | AAPL | Stock | 3.9789 | 3.9989 | 3.9714 | 3.998 | 14720944.0 |
| 2009-04-02 10:15:00 | AAPL | Stock | 3.9975 | 4.0014 | 3.9925 | 3.9982 | 15624728.0 |
| 2009-04-02 10:20:00 | AAPL | Stock | 3.9979 | 3.9993 | 3.99 | 3.9968 | 6718628.0 |
| 2009-04-02 10:25:00 | AAPL | Stock | 3.9964 | 3.9986 | 3.9789 | 3.9851 | 9853312.0 |
| 2009-04-02 10:30:00 | AAPL | Stock | 3.9846 | 3.9957 | 3.9821 | 3.9929 | 6284880.0 |
| 2009-04-02 10:35:00 | AAPL | Stock | 3.9932 | 4.0004 | 3.9893 | 3.9979 | 14525616.0 |
| 2009-04-02 10:40:00 | AAPL | Stock | 3.9965 | 4.0 | 3.9925 | 3.9989 | 12406240.0 |
> showing 50 of 325,543 rows — these rows as CSV