PREVIEW / stock_1min / 2008-04-21
file: by_date/stock_1min/2008/2008-04-21.parquet size: 11.5 MB rows: 932,714 symbols: 2,684
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:17:00 | AAPL | Stock | 5.7693 | 5.7693 | 5.7693 | 5.7693 | 2800.0 |
| 2008-04-21 04:21:00 | AAPL | Stock | 5.7618 | 5.7618 | 5.7618 | 5.7618 | 2800.0 |
| 2008-04-21 05:47:00 | AAPL | Stock | 5.7889 | 5.7921 | 5.7889 | 5.7921 | 11172.0 |
| 2008-04-21 06:23:00 | AAPL | Stock | 5.7793 | 5.7793 | 5.7779 | 5.7779 | 21000.0 |
| 2008-04-21 06:49:00 | AAPL | Stock | 5.7711 | 5.7711 | 5.7711 | 5.7711 | 2800.0 |
| 2008-04-21 06:54:00 | AAPL | Stock | 5.7736 | 5.7736 | 5.7736 | 5.7736 | 2800.0 |
| 2008-04-21 06:56:00 | AAPL | Stock | 5.775 | 5.775 | 5.775 | 5.775 | 25200.0 |
| 2008-04-21 06:57:00 | AAPL | Stock | 5.775 | 5.775 | 5.775 | 5.775 | 2800.0 |
| 2008-04-21 07:01:00 | AAPL | Stock | 5.775 | 5.775 | 5.775 | 5.775 | 28000.0 |
| 2008-04-21 07:03:00 | AAPL | Stock | 5.7686 | 5.7686 | 5.7679 | 5.7679 | 16800.0 |
| 2008-04-21 07:04:00 | AAPL | Stock | 5.77 | 5.77 | 5.77 | 5.77 | 16800.0 |
| 2008-04-21 07:06:00 | AAPL | Stock | 5.7679 | 5.7679 | 5.7629 | 5.7629 | 30800.0 |
| 2008-04-21 07:08:00 | AAPL | Stock | 5.7589 | 5.7589 | 5.7589 | 5.7589 | 5600.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.7571 | 5.7571 | 5.7571 | 2800.0 |
| 2008-04-21 07:18:00 | AAPL | Stock | 5.7589 | 5.7589 | 5.7589 | 5.7589 | 2800.0 |
| 2008-04-21 07:25:00 | AAPL | Stock | 5.7607 | 5.7643 | 5.7607 | 5.7643 | 37800.0 |
| 2008-04-21 07:26:00 | AAPL | Stock | 5.7589 | 5.7589 | 5.7571 | 5.7571 | 9268.0 |
| 2008-04-21 07:27:00 | AAPL | Stock | 5.7664 | 5.7671 | 5.7664 | 5.7671 | 19600.0 |
| 2008-04-21 07:28:00 | AAPL | Stock | 5.7679 | 5.7679 | 5.7671 | 5.7679 | 55720.0 |
| 2008-04-21 07:29:00 | AAPL | Stock | 5.7768 | 5.7768 | 5.7768 | 5.7768 | 8400.0 |
| 2008-04-21 07:30:00 | AAPL | Stock | 5.7721 | 5.7721 | 5.7721 | 5.7721 | 22400.0 |
| 2008-04-21 07:31:00 | AAPL | Stock | 5.7682 | 5.7682 | 5.7682 | 5.7682 | 13132.0 |
| 2008-04-21 07:32:00 | AAPL | Stock | 5.7686 | 5.7686 | 5.7686 | 5.7686 | 2800.0 |
| 2008-04-21 07:33:00 | AAPL | Stock | 5.7686 | 5.7721 | 5.7686 | 5.7721 | 13132.0 |
| 2008-04-21 07:34:00 | AAPL | Stock | 5.7729 | 5.7729 | 5.7729 | 5.7729 | 28000.0 |
| 2008-04-21 07:37:00 | AAPL | Stock | 5.7725 | 5.7725 | 5.7682 | 5.7725 | 32732.0 |
| 2008-04-21 07:38:00 | AAPL | Stock | 5.7725 | 5.7729 | 5.7721 | 5.7729 | 18732.0 |
| 2008-04-21 07:39:00 | AAPL | Stock | 5.7732 | 5.7743 | 5.7732 | 5.7743 | 11200.0 |
| 2008-04-21 07:41:00 | AAPL | Stock | 5.775 | 5.775 | 5.775 | 5.775 | 8400.0 |
| 2008-04-21 07:44:00 | AAPL | Stock | 5.7711 | 5.79 | 5.7711 | 5.79 | 43400.0 |
| 2008-04-21 07:46:00 | AAPL | Stock | 5.7925 | 5.7929 | 5.7925 | 5.7929 | 22400.0 |
| 2008-04-21 07:47:00 | AAPL | Stock | 5.8018 | 5.8018 | 5.8018 | 5.8018 | 26516.0 |
| 2008-04-21 07:48:00 | AAPL | Stock | 5.8011 | 5.8036 | 5.8011 | 5.8036 | 28000.0 |
| 2008-04-21 07:52:00 | AAPL | Stock | 5.7996 | 5.7996 | 5.7996 | 5.7996 | 2800.0 |
| 2008-04-21 07:54:00 | AAPL | Stock | 5.7964 | 5.7964 | 5.7964 | 5.7964 | 2800.0 |
| 2008-04-21 07:56:00 | AAPL | Stock | 5.7879 | 5.7925 | 5.7879 | 5.7879 | 33600.0 |
| 2008-04-21 07:57:00 | AAPL | Stock | 5.7929 | 5.7929 | 5.7929 | 5.7929 | 2800.0 |
| 2008-04-21 07:58:00 | AAPL | Stock | 5.7896 | 5.7939 | 5.7871 | 5.7939 | 37268.0 |
| 2008-04-21 07:59:00 | AAPL | Stock | 5.7875 | 5.7875 | 5.7857 | 5.7857 | 13552.0 |
| 2008-04-21 08:00:00 | AAPL | Stock | 5.7929 | 5.7939 | 5.7871 | 5.7936 | 247604.0 |
| 2008-04-21 08:01:00 | AAPL | Stock | 5.7925 | 5.7964 | 5.7925 | 5.7964 | 135100.0 |
| 2008-04-21 08:02:00 | AAPL | Stock | 5.7993 | 5.8118 | 5.7993 | 5.8061 | 72800.0 |
| 2008-04-21 08:03:00 | AAPL | Stock | 5.8086 | 5.8214 | 5.8086 | 5.8136 | 140840.0 |
| 2008-04-21 08:04:00 | AAPL | Stock | 5.8207 | 5.8214 | 5.8132 | 5.8143 | 169316.0 |
| 2008-04-21 08:05:00 | AAPL | Stock | 5.8143 | 5.8164 | 5.8075 | 5.8107 | 133560.0 |
| 2008-04-21 08:06:00 | AAPL | Stock | 5.8118 | 5.8143 | 5.8089 | 5.8136 | 61600.0 |
| 2008-04-21 08:07:00 | AAPL | Stock | 5.8121 | 5.8157 | 5.8121 | 5.8157 | 80640.0 |
| 2008-04-21 08:08:00 | AAPL | Stock | 5.8157 | 5.8171 | 5.8114 | 5.8171 | 365540.0 |
| 2008-04-21 08:09:00 | AAPL | Stock | 5.8179 | 5.8214 | 5.8171 | 5.8179 | 101276.0 |
> showing 50 of 932,714 rows — these rows as CSV