PREVIEW / stock_5min / 2008-04-21
file: by_date/stock_5min/2008/2008-04-21.parquet size: 4.3 MB rows: 306,852 symbols: 3,286
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-21 04:15:00 | AAPL | Stock | 5.7693 | 5.7693 | 5.7693 | 5.7693 | 2800.0 |
| 2008-04-21 04:20:00 | AAPL | Stock | 5.7618 | 5.7618 | 5.7618 | 5.7618 | 2800.0 |
| 2008-04-21 05:45:00 | AAPL | Stock | 5.7889 | 5.7921 | 5.7889 | 5.7921 | 11172.0 |
| 2008-04-21 06:20:00 | AAPL | Stock | 5.7793 | 5.7793 | 5.7779 | 5.7779 | 21000.0 |
| 2008-04-21 06:45:00 | AAPL | Stock | 5.7711 | 5.7711 | 5.7711 | 5.7711 | 2800.0 |
| 2008-04-21 06:50:00 | AAPL | Stock | 5.7736 | 5.7736 | 5.7736 | 5.7736 | 2800.0 |
| 2008-04-21 06:55:00 | AAPL | Stock | 5.775 | 5.775 | 5.775 | 5.775 | 28000.0 |
| 2008-04-21 07:00:00 | AAPL | Stock | 5.775 | 5.775 | 5.7679 | 5.77 | 61600.0 |
| 2008-04-21 07:05:00 | AAPL | Stock | 5.7679 | 5.7679 | 5.7589 | 5.7589 | 36400.0 |
| 2008-04-21 07:10:00 | AAPL | Stock | 5.7629 | 5.7629 | 5.7629 | 5.7629 | 8400.0 |
| 2008-04-21 07:15:00 | AAPL | Stock | 5.7571 | 5.7589 | 5.7571 | 5.7589 | 5600.0 |
| 2008-04-21 07:25:00 | AAPL | Stock | 5.7607 | 5.7768 | 5.7571 | 5.7768 | 130788.0 |
| 2008-04-21 07:30:00 | AAPL | Stock | 5.7721 | 5.7729 | 5.7682 | 5.7729 | 79464.0 |
| 2008-04-21 07:35:00 | AAPL | Stock | 5.7725 | 5.7743 | 5.7682 | 5.7743 | 62664.0 |
| 2008-04-21 07:40:00 | AAPL | Stock | 5.775 | 5.79 | 5.7711 | 5.79 | 51800.0 |
| 2008-04-21 07:45:00 | AAPL | Stock | 5.7925 | 5.8036 | 5.7925 | 5.8036 | 76916.0 |
| 2008-04-21 07:50:00 | AAPL | Stock | 5.7996 | 5.7996 | 5.7964 | 5.7964 | 5600.0 |
| 2008-04-21 07:55:00 | AAPL | Stock | 5.7879 | 5.7939 | 5.7857 | 5.7857 | 87220.0 |
| 2008-04-21 08:00:00 | AAPL | Stock | 5.7929 | 5.8214 | 5.7871 | 5.8143 | 765660.0 |
| 2008-04-21 08:05:00 | AAPL | Stock | 5.8143 | 5.8214 | 5.8075 | 5.8179 | 742616.0 |
| 2008-04-21 08:10:00 | AAPL | Stock | 5.8175 | 5.8214 | 5.8107 | 5.8107 | 771120.0 |
| 2008-04-21 08:15:00 | AAPL | Stock | 5.8111 | 5.8111 | 5.7821 | 5.7821 | 1613584.0 |
| 2008-04-21 08:20:00 | AAPL | Stock | 5.7832 | 5.7893 | 5.7832 | 5.7868 | 862540.0 |
| 2008-04-21 08:25:00 | AAPL | Stock | 5.7889 | 5.7946 | 5.7821 | 5.7893 | 643664.0 |
| 2008-04-21 08:30:00 | AAPL | Stock | 5.7904 | 5.7964 | 5.7875 | 5.7946 | 307048.0 |
| 2008-04-21 08:35:00 | AAPL | Stock | 5.7946 | 5.8 | 5.7946 | 5.8 | 491988.0 |
| 2008-04-21 08:40:00 | AAPL | Stock | 5.8 | 5.8071 | 5.7957 | 5.7957 | 626220.0 |
| 2008-04-21 08:45:00 | AAPL | Stock | 5.7957 | 5.7964 | 5.7861 | 5.7893 | 572796.0 |
| 2008-04-21 08:50:00 | AAPL | Stock | 5.7882 | 5.8 | 5.7882 | 5.7921 | 225736.0 |
| 2008-04-21 08:55:00 | AAPL | Stock | 5.7911 | 5.7943 | 5.7861 | 5.79 | 582820.0 |
| 2008-04-21 09:00:00 | AAPL | Stock | 5.7875 | 5.7893 | 5.7857 | 5.7889 | 210728.0 |
| 2008-04-21 09:05:00 | AAPL | Stock | 5.7893 | 5.7961 | 5.7893 | 5.7936 | 412916.0 |
| 2008-04-21 09:10:00 | AAPL | Stock | 5.7954 | 5.7982 | 5.7929 | 5.7929 | 354116.0 |
| 2008-04-21 09:15:00 | AAPL | Stock | 5.7911 | 5.8036 | 5.7857 | 5.7857 | 400792.0 |
| 2008-04-21 09:20:00 | AAPL | Stock | 5.7857 | 5.7893 | 5.7821 | 5.7882 | 520324.0 |
| 2008-04-21 09:25:00 | AAPL | Stock | 5.7879 | 5.8029 | 5.7832 | 5.7943 | 1527204.0 |
| 2008-04-21 09:30:00 | AAPL | Stock | 5.7943 | 5.8525 | 5.7771 | 5.8418 | 39949588.0 |
| 2008-04-21 09:35:00 | AAPL | Stock | 5.8421 | 5.8711 | 5.8414 | 5.8546 | 31604412.0 |
| 2008-04-21 09:40:00 | AAPL | Stock | 5.855 | 5.8561 | 5.8307 | 5.8429 | 22678600.0 |
| 2008-04-21 09:45:00 | AAPL | Stock | 5.8428 | 5.8511 | 5.8396 | 5.8439 | 14617652.0 |
| 2008-04-21 09:50:00 | AAPL | Stock | 5.8436 | 5.8621 | 5.8421 | 5.8596 | 17586520.0 |
| 2008-04-21 09:55:00 | AAPL | Stock | 5.8575 | 5.8732 | 5.8525 | 5.8604 | 20884108.0 |
| 2008-04-21 10:00:00 | AAPL | Stock | 5.8607 | 5.8636 | 5.8343 | 5.8496 | 19323444.0 |
| 2008-04-21 10:05:00 | AAPL | Stock | 5.8496 | 5.855 | 5.8421 | 5.8539 | 14510244.0 |
| 2008-04-21 10:10:00 | AAPL | Stock | 5.8532 | 5.8589 | 5.8482 | 5.8529 | 12086368.0 |
| 2008-04-21 10:15:00 | AAPL | Stock | 5.8529 | 5.8529 | 5.8393 | 5.8425 | 12433176.0 |
| 2008-04-21 10:20:00 | AAPL | Stock | 5.8425 | 5.8532 | 5.8371 | 5.8507 | 12257280.0 |
| 2008-04-21 10:25:00 | AAPL | Stock | 5.85 | 5.8518 | 5.8307 | 5.8393 | 11543728.0 |
| 2008-04-21 10:30:00 | AAPL | Stock | 5.8396 | 5.8425 | 5.8229 | 5.8239 | 16234708.0 |
| 2008-04-21 10:35:00 | AAPL | Stock | 5.8243 | 5.8279 | 5.8071 | 5.8211 | 17210788.0 |
> showing 50 of 306,852 rows — these rows as CSV