PREVIEW / stock_5min / 2009-11-02
file: by_date/stock_5min/2009/2009-11-02.parquet size: 4.9 MB rows: 331,883 symbols: 3,411
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-11-02 04:15:00 | AAPL | Stock | 6.7707 | 6.7707 | 6.7707 | 6.7707 | 4200.0 |
| 2009-11-02 04:20:00 | AAPL | Stock | 6.7707 | 6.7707 | 6.7707 | 6.7707 | 8400.0 |
| 2009-11-02 04:25:00 | AAPL | Stock | 6.7679 | 6.7679 | 6.7679 | 6.7679 | 17808.0 |
| 2009-11-02 05:30:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 2800.0 |
| 2009-11-02 05:50:00 | AAPL | Stock | 6.7643 | 6.7643 | 6.7643 | 6.7643 | 2800.0 |
| 2009-11-02 06:40:00 | AAPL | Stock | 6.7821 | 6.7821 | 6.7821 | 6.7821 | 24360.0 |
| 2009-11-02 07:00:00 | AAPL | Stock | 6.7625 | 6.7696 | 6.7625 | 6.7696 | 30576.0 |
| 2009-11-02 07:05:00 | AAPL | Stock | 6.7696 | 6.7854 | 6.7696 | 6.7768 | 24080.0 |
| 2009-11-02 07:10:00 | AAPL | Stock | 6.7854 | 6.7854 | 6.7786 | 6.7786 | 22736.0 |
| 2009-11-02 07:15:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7786 | 6.7793 | 76580.0 |
| 2009-11-02 07:20:00 | AAPL | Stock | 6.77 | 6.7764 | 6.77 | 6.7764 | 16800.0 |
| 2009-11-02 07:25:00 | AAPL | Stock | 6.77 | 6.77 | 6.7679 | 6.7679 | 22736.0 |
| 2009-11-02 07:30:00 | AAPL | Stock | 6.7629 | 6.7629 | 6.7629 | 6.7629 | 5600.0 |
| 2009-11-02 07:35:00 | AAPL | Stock | 6.7629 | 6.7786 | 6.7625 | 6.7786 | 108612.0 |
| 2009-11-02 07:40:00 | AAPL | Stock | 6.7818 | 6.7818 | 6.7818 | 6.7818 | 11200.0 |
| 2009-11-02 07:45:00 | AAPL | Stock | 6.7607 | 6.7607 | 6.7607 | 6.7607 | 22400.0 |
| 2009-11-02 08:00:00 | AAPL | Stock | 6.7714 | 6.7786 | 6.7321 | 6.7721 | 358092.0 |
| 2009-11-02 08:05:00 | AAPL | Stock | 6.7714 | 6.7729 | 6.7679 | 6.7679 | 52584.0 |
| 2009-11-02 08:10:00 | AAPL | Stock | 6.7643 | 6.7679 | 6.7643 | 6.7661 | 58044.0 |
| 2009-11-02 08:15:00 | AAPL | Stock | 6.7661 | 6.7711 | 6.7629 | 6.7704 | 165900.0 |
| 2009-11-02 08:20:00 | AAPL | Stock | 6.7704 | 6.7821 | 6.7704 | 6.7821 | 112140.0 |
| 2009-11-02 08:25:00 | AAPL | Stock | 6.7834 | 6.7834 | 6.7768 | 6.7771 | 99680.0 |
| 2009-11-02 08:30:00 | AAPL | Stock | 6.7807 | 6.7836 | 6.7807 | 6.7836 | 70280.0 |
| 2009-11-02 08:35:00 | AAPL | Stock | 6.7836 | 6.7932 | 6.7836 | 6.7879 | 193032.0 |
| 2009-11-02 08:40:00 | AAPL | Stock | 6.7911 | 6.7911 | 6.7875 | 6.7911 | 77672.0 |
| 2009-11-02 08:45:00 | AAPL | Stock | 6.7911 | 6.7968 | 6.7893 | 6.7925 | 493556.0 |
| 2009-11-02 08:50:00 | AAPL | Stock | 6.7939 | 6.7957 | 6.7929 | 6.7929 | 106120.0 |
| 2009-11-02 08:55:00 | AAPL | Stock | 6.7929 | 6.7939 | 6.7839 | 6.7857 | 590996.0 |
| 2009-11-02 09:00:00 | AAPL | Stock | 6.7845 | 6.79 | 6.7804 | 6.7832 | 233660.0 |
| 2009-11-02 09:05:00 | AAPL | Stock | 6.7832 | 6.7839 | 6.7804 | 6.7829 | 275240.0 |
| 2009-11-02 09:10:00 | AAPL | Stock | 6.7821 | 6.7836 | 6.7807 | 6.7807 | 68600.0 |
| 2009-11-02 09:15:00 | AAPL | Stock | 6.7807 | 6.7811 | 6.7779 | 6.7779 | 58520.0 |
| 2009-11-02 09:20:00 | AAPL | Stock | 6.7807 | 6.7832 | 6.775 | 6.7818 | 82096.0 |
| 2009-11-02 09:25:00 | AAPL | Stock | 6.7804 | 6.7811 | 6.7682 | 6.7775 | 192808.0 |
| 2009-11-02 09:30:00 | AAPL | Stock | 6.7782 | 6.8079 | 6.7457 | 6.7771 | 20288100.0 |
| 2009-11-02 09:35:00 | AAPL | Stock | 6.7786 | 6.7814 | 6.7321 | 6.735 | 14438284.0 |
| 2009-11-02 09:40:00 | AAPL | Stock | 6.7357 | 6.7579 | 6.7207 | 6.7229 | 16800112.0 |
| 2009-11-02 09:45:00 | AAPL | Stock | 6.7257 | 6.7381 | 6.6275 | 6.6429 | 44824472.0 |
| 2009-11-02 09:50:00 | AAPL | Stock | 6.6414 | 6.6882 | 6.6389 | 6.68 | 23699984.0 |
| 2009-11-02 09:55:00 | AAPL | Stock | 6.68 | 6.7479 | 6.68 | 6.7404 | 20230924.0 |
| 2009-11-02 10:00:00 | AAPL | Stock | 6.7404 | 6.7932 | 6.7368 | 6.7925 | 28204372.0 |
| 2009-11-02 10:05:00 | AAPL | Stock | 6.7921 | 6.8014 | 6.7604 | 6.7614 | 18608184.0 |
| 2009-11-02 10:10:00 | AAPL | Stock | 6.7634 | 6.7825 | 6.7361 | 6.7425 | 13188112.0 |
| 2009-11-02 10:15:00 | AAPL | Stock | 6.7432 | 6.8071 | 6.7375 | 6.8021 | 15689100.0 |
| 2009-11-02 10:20:00 | AAPL | Stock | 6.8025 | 6.8214 | 6.7875 | 6.8054 | 15913940.0 |
| 2009-11-02 10:25:00 | AAPL | Stock | 6.8054 | 6.8886 | 6.8011 | 6.8471 | 23565584.0 |
| 2009-11-02 10:30:00 | AAPL | Stock | 6.8471 | 6.8714 | 6.8439 | 6.8514 | 12908532.0 |
| 2009-11-02 10:35:00 | AAPL | Stock | 6.8539 | 6.8793 | 6.8339 | 6.8718 | 9574656.0 |
| 2009-11-02 10:40:00 | AAPL | Stock | 6.8718 | 6.8761 | 6.8054 | 6.8439 | 8961680.0 |
| 2009-11-02 10:45:00 | AAPL | Stock | 6.8439 | 6.8521 | 6.8325 | 6.8471 | 8737876.0 |
> showing 50 of 331,883 rows — these rows as CSV