PREVIEW / stock_5min / 2009-05-28
file: by_date/stock_5min/2009/2009-05-28.parquet size: 4.7 MB rows: 321,517 symbols: 3,361
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-05-28 04:25:00 | AAPL | Stock | 4.7157 | 4.7157 | 4.7157 | 4.7157 | 2800.0 |
| 2009-05-28 05:50:00 | AAPL | Stock | 4.7218 | 4.7321 | 4.7218 | 4.7321 | 5600.0 |
| 2009-05-28 07:10:00 | AAPL | Stock | 4.7589 | 4.7589 | 4.7589 | 4.7589 | 2800.0 |
| 2009-05-28 07:20:00 | AAPL | Stock | 4.7671 | 4.7671 | 4.7671 | 4.7671 | 8400.0 |
| 2009-05-28 07:50:00 | AAPL | Stock | 4.7582 | 4.7582 | 4.7582 | 4.7582 | 2800.0 |
| 2009-05-28 07:55:00 | AAPL | Stock | 4.7532 | 4.7532 | 4.7304 | 4.7304 | 28280.0 |
| 2009-05-28 08:00:00 | AAPL | Stock | 4.7464 | 4.7582 | 4.7464 | 4.7496 | 79548.0 |
| 2009-05-28 08:05:00 | AAPL | Stock | 4.7446 | 4.7446 | 4.7446 | 4.7446 | 19600.0 |
| 2009-05-28 08:10:00 | AAPL | Stock | 4.7446 | 4.7446 | 4.7446 | 4.7446 | 23800.0 |
| 2009-05-28 08:15:00 | AAPL | Stock | 4.7446 | 4.7493 | 4.7446 | 4.7493 | 81592.0 |
| 2009-05-28 08:20:00 | AAPL | Stock | 4.7493 | 4.7571 | 4.7493 | 4.7536 | 82572.0 |
| 2009-05-28 08:25:00 | AAPL | Stock | 4.7539 | 4.7539 | 4.7521 | 4.7536 | 20076.0 |
| 2009-05-28 08:30:00 | AAPL | Stock | 4.7582 | 4.7679 | 4.7571 | 4.7664 | 330064.0 |
| 2009-05-28 08:35:00 | AAPL | Stock | 4.7625 | 4.7704 | 4.7607 | 4.7704 | 240660.0 |
| 2009-05-28 08:40:00 | AAPL | Stock | 4.775 | 4.7768 | 4.7732 | 4.7768 | 100240.0 |
| 2009-05-28 08:45:00 | AAPL | Stock | 4.7768 | 4.7821 | 4.775 | 4.7782 | 161140.0 |
| 2009-05-28 08:50:00 | AAPL | Stock | 4.7782 | 4.7857 | 4.7782 | 4.7818 | 401660.0 |
| 2009-05-28 08:55:00 | AAPL | Stock | 4.7839 | 4.7839 | 4.7786 | 4.7786 | 197260.0 |
| 2009-05-28 09:00:00 | AAPL | Stock | 4.7768 | 4.7771 | 4.7732 | 4.7768 | 115780.0 |
| 2009-05-28 09:05:00 | AAPL | Stock | 4.7732 | 4.7732 | 4.7732 | 4.7732 | 17472.0 |
| 2009-05-28 09:10:00 | AAPL | Stock | 4.7757 | 4.7757 | 4.7679 | 4.7732 | 73500.0 |
| 2009-05-28 09:15:00 | AAPL | Stock | 4.775 | 4.7839 | 4.775 | 4.7839 | 46060.0 |
| 2009-05-28 09:20:00 | AAPL | Stock | 4.7839 | 4.7839 | 4.7714 | 4.7714 | 64400.0 |
| 2009-05-28 09:25:00 | AAPL | Stock | 4.7736 | 4.7736 | 4.7643 | 4.7661 | 232428.0 |
| 2009-05-28 09:30:00 | AAPL | Stock | 4.7661 | 4.7999 | 4.7611 | 4.7746 | 17508792.0 |
| 2009-05-28 09:35:00 | AAPL | Stock | 4.775 | 4.8036 | 4.7721 | 4.8014 | 11447240.0 |
| 2009-05-28 09:40:00 | AAPL | Stock | 4.8013 | 4.8121 | 4.7864 | 4.7876 | 12573652.0 |
| 2009-05-28 09:45:00 | AAPL | Stock | 4.7879 | 4.7936 | 4.7782 | 4.7889 | 7329168.0 |
| 2009-05-28 09:50:00 | AAPL | Stock | 4.7893 | 4.8004 | 4.7786 | 4.7839 | 6823236.0 |
| 2009-05-28 09:55:00 | AAPL | Stock | 4.783 | 4.7911 | 4.7689 | 4.7804 | 8051036.0 |
| 2009-05-28 10:00:00 | AAPL | Stock | 4.7811 | 4.7814 | 4.7389 | 4.7518 | 18677036.0 |
| 2009-05-28 10:05:00 | AAPL | Stock | 4.7518 | 4.7529 | 4.7214 | 4.7314 | 14206192.0 |
| 2009-05-28 10:10:00 | AAPL | Stock | 4.7318 | 4.7391 | 4.7154 | 4.7371 | 10205636.0 |
| 2009-05-28 10:15:00 | AAPL | Stock | 4.7364 | 4.755 | 4.7339 | 4.7486 | 7154868.0 |
| 2009-05-28 10:20:00 | AAPL | Stock | 4.7489 | 4.7525 | 4.7364 | 4.7429 | 6713560.0 |
| 2009-05-28 10:25:00 | AAPL | Stock | 4.7429 | 4.7614 | 4.7371 | 4.7571 | 6599544.0 |
| 2009-05-28 10:30:00 | AAPL | Stock | 4.7557 | 4.7571 | 4.7471 | 4.7475 | 5741008.0 |
| 2009-05-28 10:35:00 | AAPL | Stock | 4.7475 | 4.7571 | 4.7446 | 4.7475 | 5533332.0 |
| 2009-05-28 10:40:00 | AAPL | Stock | 4.7464 | 4.75 | 4.7375 | 4.7429 | 5258400.0 |
| 2009-05-28 10:45:00 | AAPL | Stock | 4.7429 | 4.7432 | 4.7321 | 4.7354 | 5247928.0 |
| 2009-05-28 10:50:00 | AAPL | Stock | 4.7364 | 4.75 | 4.7357 | 4.7454 | 5409544.0 |
| 2009-05-28 10:55:00 | AAPL | Stock | 4.7443 | 4.7589 | 4.7432 | 4.7578 | 5438104.0 |
| 2009-05-28 11:00:00 | AAPL | Stock | 4.7579 | 4.7729 | 4.7561 | 4.7729 | 6768580.0 |
| 2009-05-28 11:05:00 | AAPL | Stock | 4.7729 | 4.7789 | 4.7625 | 4.7746 | 6657420.0 |
| 2009-05-28 11:10:00 | AAPL | Stock | 4.7743 | 4.7764 | 4.7636 | 4.7671 | 5148416.0 |
| 2009-05-28 11:15:00 | AAPL | Stock | 4.7675 | 4.7704 | 4.7593 | 4.7593 | 3513076.0 |
| 2009-05-28 11:20:00 | AAPL | Stock | 4.7596 | 4.76 | 4.7521 | 4.7589 | 4616052.0 |
| 2009-05-28 11:25:00 | AAPL | Stock | 4.7589 | 4.7704 | 4.7557 | 4.7674 | 4643968.0 |
| 2009-05-28 11:30:00 | AAPL | Stock | 4.7675 | 4.7739 | 4.7646 | 4.7696 | 3632412.0 |
| 2009-05-28 11:35:00 | AAPL | Stock | 4.7696 | 4.7721 | 4.7596 | 4.7596 | 2749992.0 |
> showing 50 of 321,517 rows — these rows as CSV