PREVIEW / stock_5min / 2014-01-03
file: by_date/stock_5min/2014/2014-01-03.parquet size: 5.3 MB rows: 354,020 symbols: 3,512
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 |
|---|---|---|---|---|---|---|---|
| 2014-01-03 04:50:00 | AAPL | Stock | 19.7607 | 19.7607 | 19.7607 | 19.7607 | 2800.0 |
| 2014-01-03 05:00:00 | AAPL | Stock | 19.7607 | 19.7607 | 19.7607 | 19.7607 | 8400.0 |
| 2014-01-03 05:10:00 | AAPL | Stock | 19.7607 | 19.7607 | 19.7607 | 19.7607 | 5600.0 |
| 2014-01-03 06:00:00 | AAPL | Stock | 19.7732 | 19.7732 | 19.7732 | 19.7732 | 3920.0 |
| 2014-01-03 06:40:00 | AAPL | Stock | 19.7979 | 19.7979 | 19.7979 | 19.7979 | 7112.0 |
| 2014-01-03 06:55:00 | AAPL | Stock | 19.7993 | 19.8 | 19.7993 | 19.8 | 8400.0 |
| 2014-01-03 07:00:00 | AAPL | Stock | 19.8 | 19.8 | 19.7864 | 19.7864 | 19600.0 |
| 2014-01-03 07:05:00 | AAPL | Stock | 19.8071 | 19.8279 | 19.8071 | 19.8279 | 29120.0 |
| 2014-01-03 07:10:00 | AAPL | Stock | 19.8214 | 19.8214 | 19.8107 | 19.8107 | 31304.0 |
| 2014-01-03 07:15:00 | AAPL | Stock | 19.7896 | 19.7896 | 19.7875 | 19.7875 | 7840.0 |
| 2014-01-03 07:25:00 | AAPL | Stock | 19.8014 | 19.8014 | 19.8014 | 19.8014 | 2800.0 |
| 2014-01-03 07:30:00 | AAPL | Stock | 19.8036 | 19.8179 | 19.7968 | 19.8036 | 43260.0 |
| 2014-01-03 07:40:00 | AAPL | Stock | 19.8143 | 19.8143 | 19.8143 | 19.8143 | 2800.0 |
| 2014-01-03 07:45:00 | AAPL | Stock | 19.8046 | 19.8175 | 19.8036 | 19.8175 | 33180.0 |
| 2014-01-03 07:55:00 | AAPL | Stock | 19.8143 | 19.8146 | 19.8139 | 19.8139 | 16688.0 |
| 2014-01-03 08:00:00 | AAPL | Stock | 19.8111 | 19.8211 | 19.7946 | 19.8121 | 144340.0 |
| 2014-01-03 08:05:00 | AAPL | Stock | 19.8114 | 19.8182 | 19.8071 | 19.8182 | 197624.0 |
| 2014-01-03 08:10:00 | AAPL | Stock | 19.8207 | 19.8214 | 19.8171 | 19.8204 | 111860.0 |
| 2014-01-03 08:15:00 | AAPL | Stock | 19.8164 | 19.8164 | 19.8036 | 19.8089 | 61208.0 |
| 2014-01-03 08:20:00 | AAPL | Stock | 19.8039 | 19.8054 | 19.7993 | 19.8036 | 75180.0 |
| 2014-01-03 08:25:00 | AAPL | Stock | 19.8125 | 19.8125 | 19.7946 | 19.7946 | 127960.0 |
| 2014-01-03 08:30:00 | AAPL | Stock | 19.7911 | 19.8036 | 19.7911 | 19.7914 | 95200.0 |
| 2014-01-03 08:35:00 | AAPL | Stock | 19.7914 | 19.7946 | 19.7911 | 19.7914 | 76860.0 |
| 2014-01-03 08:40:00 | AAPL | Stock | 19.7914 | 19.7957 | 19.7879 | 19.7957 | 108192.0 |
| 2014-01-03 08:45:00 | AAPL | Stock | 19.7954 | 19.8 | 19.7882 | 19.7907 | 44240.0 |
| 2014-01-03 08:50:00 | AAPL | Stock | 19.7889 | 19.7968 | 19.7843 | 19.7843 | 63560.0 |
| 2014-01-03 08:55:00 | AAPL | Stock | 19.7964 | 19.7964 | 19.7786 | 19.7786 | 16800.0 |
| 2014-01-03 09:00:00 | AAPL | Stock | 19.7786 | 19.7786 | 19.7614 | 19.7661 | 215544.0 |
| 2014-01-03 09:05:00 | AAPL | Stock | 19.7757 | 19.7771 | 19.7682 | 19.7682 | 11200.0 |
| 2014-01-03 09:10:00 | AAPL | Stock | 19.7729 | 19.7786 | 19.7714 | 19.7786 | 125580.0 |
| 2014-01-03 09:15:00 | AAPL | Stock | 19.7789 | 19.7814 | 19.775 | 19.7768 | 41720.0 |
| 2014-01-03 09:20:00 | AAPL | Stock | 19.7768 | 19.7768 | 19.7671 | 19.7732 | 119000.0 |
| 2014-01-03 09:25:00 | AAPL | Stock | 19.7714 | 19.7743 | 19.75 | 19.75 | 122192.0 |
| 2014-01-03 09:30:00 | AAPL | Stock | 19.7454 | 19.775 | 19.6293 | 19.6429 | 17312456.0 |
| 2014-01-03 09:35:00 | AAPL | Stock | 19.6396 | 19.6786 | 19.6296 | 19.6354 | 9003400.0 |
| 2014-01-03 09:40:00 | AAPL | Stock | 19.6423 | 19.6457 | 19.595 | 19.6259 | 9985500.0 |
| 2014-01-03 09:45:00 | AAPL | Stock | 19.6204 | 19.6395 | 19.6014 | 19.6043 | 5218500.0 |
| 2014-01-03 09:50:00 | AAPL | Stock | 19.6061 | 19.6071 | 19.5464 | 19.5571 | 9945936.0 |
| 2014-01-03 09:55:00 | AAPL | Stock | 19.5596 | 19.5882 | 19.5571 | 19.5825 | 5227376.0 |
| 2014-01-03 10:00:00 | AAPL | Stock | 19.5839 | 19.5889 | 19.5589 | 19.5804 | 5334224.0 |
| 2014-01-03 10:05:00 | AAPL | Stock | 19.5845 | 19.5975 | 19.5714 | 19.5871 | 3985716.0 |
| 2014-01-03 10:10:00 | AAPL | Stock | 19.5886 | 19.5971 | 19.5521 | 19.5629 | 5426652.0 |
| 2014-01-03 10:15:00 | AAPL | Stock | 19.5618 | 19.5693 | 19.5511 | 19.5607 | 3669260.0 |
| 2014-01-03 10:20:00 | AAPL | Stock | 19.5604 | 19.5618 | 19.54 | 19.5429 | 3432352.0 |
| 2014-01-03 10:25:00 | AAPL | Stock | 19.5429 | 19.5461 | 19.5043 | 19.5096 | 7236964.0 |
| 2014-01-03 10:30:00 | AAPL | Stock | 19.5096 | 19.5304 | 19.4954 | 19.5161 | 5145616.0 |
| 2014-01-03 10:35:00 | AAPL | Stock | 19.5171 | 19.5175 | 19.4868 | 19.4907 | 4986520.0 |
| 2014-01-03 10:40:00 | AAPL | Stock | 19.4925 | 19.5314 | 19.49 | 19.5157 | 4541292.0 |
| 2014-01-03 10:45:00 | AAPL | Stock | 19.5171 | 19.5207 | 19.4893 | 19.4921 | 3393516.0 |
| 2014-01-03 10:50:00 | AAPL | Stock | 19.4918 | 19.5121 | 19.4893 | 19.5079 | 4537848.0 |
> showing 50 of 354,020 rows — these rows as CSV