PREVIEW / stock_1min / 2014-04-01
file: by_date/stock_1min/2014/2014-04-01.parquet size: 15.3 MB rows: 1,109,801 symbols: 2,895
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-04-01 04:53:00 | AAPL | Stock | 19.1854 | 19.1889 | 19.1854 | 19.1889 | 5600.0 |
| 2014-04-01 05:01:00 | AAPL | Stock | 19.1786 | 19.1786 | 19.1786 | 19.1786 | 2800.0 |
| 2014-04-01 06:33:00 | AAPL | Stock | 19.1786 | 19.1786 | 19.1786 | 19.1786 | 2800.0 |
| 2014-04-01 06:36:00 | AAPL | Stock | 19.1871 | 19.1893 | 19.1871 | 19.1893 | 8960.0 |
| 2014-04-01 07:04:00 | AAPL | Stock | 19.1968 | 19.1968 | 19.1968 | 19.1968 | 2800.0 |
| 2014-04-01 07:09:00 | AAPL | Stock | 19.2014 | 19.2054 | 19.2014 | 19.2054 | 8400.0 |
| 2014-04-01 07:11:00 | AAPL | Stock | 19.2143 | 19.2143 | 19.2143 | 19.2143 | 2800.0 |
| 2014-04-01 07:13:00 | AAPL | Stock | 19.1982 | 19.1982 | 19.1964 | 19.1964 | 18004.0 |
| 2014-04-01 07:19:00 | AAPL | Stock | 19.1971 | 19.1971 | 19.1964 | 19.1964 | 28000.0 |
| 2014-04-01 07:22:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 5600.0 |
| 2014-04-01 07:25:00 | AAPL | Stock | 19.1971 | 19.1971 | 19.1964 | 19.1964 | 30800.0 |
| 2014-04-01 07:27:00 | AAPL | Stock | 19.1968 | 19.1968 | 19.1968 | 19.1968 | 2800.0 |
| 2014-04-01 07:28:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 14000.0 |
| 2014-04-01 07:30:00 | AAPL | Stock | 19.2014 | 19.2086 | 19.2014 | 19.2086 | 12600.0 |
| 2014-04-01 07:34:00 | AAPL | Stock | 19.2014 | 19.2014 | 19.1964 | 19.1964 | 13300.0 |
| 2014-04-01 07:40:00 | AAPL | Stock | 19.1964 | 19.1964 | 19.1964 | 19.1964 | 2800.0 |
| 2014-04-01 07:52:00 | AAPL | Stock | 19.2043 | 19.2071 | 19.2043 | 19.2071 | 16800.0 |
| 2014-04-01 07:53:00 | AAPL | Stock | 19.2054 | 19.2054 | 19.2054 | 19.2054 | 2800.0 |
| 2014-04-01 08:00:00 | AAPL | Stock | 19.2057 | 19.2057 | 19.1964 | 19.2054 | 23800.0 |
| 2014-04-01 08:07:00 | AAPL | Stock | 19.2089 | 19.2089 | 19.2089 | 19.2089 | 2800.0 |
| 2014-04-01 08:11:00 | AAPL | Stock | 19.21 | 19.21 | 19.21 | 19.21 | 2800.0 |
| 2014-04-01 08:12:00 | AAPL | Stock | 19.2054 | 19.2054 | 19.2054 | 19.2054 | 11200.0 |
| 2014-04-01 08:13:00 | AAPL | Stock | 19.2054 | 19.2054 | 19.2054 | 19.2054 | 28000.0 |
| 2014-04-01 08:14:00 | AAPL | Stock | 19.2054 | 19.2057 | 19.2054 | 19.2057 | 11200.0 |
| 2014-04-01 08:16:00 | AAPL | Stock | 19.2054 | 19.2054 | 19.2054 | 19.2054 | 2800.0 |
| 2014-04-01 08:20:00 | AAPL | Stock | 19.2054 | 19.2054 | 19.1968 | 19.1968 | 90440.0 |
| 2014-04-01 08:22:00 | AAPL | Stock | 19.1968 | 19.1968 | 19.1968 | 19.1968 | 2800.0 |
| 2014-04-01 08:23:00 | AAPL | Stock | 19.2029 | 19.2029 | 19.2029 | 19.2029 | 6300.0 |
| 2014-04-01 08:25:00 | AAPL | Stock | 19.2029 | 19.2029 | 19.2029 | 19.2029 | 2800.0 |
| 2014-04-01 08:30:00 | AAPL | Stock | 19.2018 | 19.2018 | 19.2018 | 19.2018 | 2800.0 |
| 2014-04-01 08:31:00 | AAPL | Stock | 19.2 | 19.2 | 19.2 | 19.2 | 5600.0 |
| 2014-04-01 08:35:00 | AAPL | Stock | 19.1989 | 19.1989 | 19.1989 | 19.1989 | 2800.0 |
| 2014-04-01 08:39:00 | AAPL | Stock | 19.2029 | 19.2032 | 19.2029 | 19.2032 | 14000.0 |
| 2014-04-01 08:40:00 | AAPL | Stock | 19.2032 | 19.205 | 19.2029 | 19.2029 | 19600.0 |
| 2014-04-01 08:44:00 | AAPL | Stock | 19.2029 | 19.2029 | 19.2029 | 19.2029 | 2800.0 |
| 2014-04-01 08:45:00 | AAPL | Stock | 19.2071 | 19.2071 | 19.2021 | 19.2021 | 30800.0 |
| 2014-04-01 08:47:00 | AAPL | Stock | 19.1693 | 19.1693 | 19.1693 | 19.1693 | 17444.0 |
| 2014-04-01 08:51:00 | AAPL | Stock | 19.2071 | 19.2071 | 19.2064 | 19.2071 | 49952.0 |
| 2014-04-01 08:52:00 | AAPL | Stock | 19.2082 | 19.2114 | 19.2082 | 19.2114 | 39200.0 |
| 2014-04-01 08:53:00 | AAPL | Stock | 19.2114 | 19.2321 | 19.2114 | 19.2321 | 72520.0 |
| 2014-04-01 08:54:00 | AAPL | Stock | 19.2321 | 19.2321 | 19.2321 | 19.2321 | 2800.0 |
| 2014-04-01 09:00:00 | AAPL | Stock | 19.2257 | 19.2257 | 19.2257 | 19.2257 | 2800.0 |
| 2014-04-01 09:01:00 | AAPL | Stock | 19.2232 | 19.2232 | 19.2232 | 19.2232 | 2800.0 |
| 2014-04-01 09:02:00 | AAPL | Stock | 19.2218 | 19.2218 | 19.2218 | 19.2218 | 2800.0 |
| 2014-04-01 09:03:00 | AAPL | Stock | 19.2236 | 19.2236 | 19.2236 | 19.2236 | 2800.0 |
| 2014-04-01 09:04:00 | AAPL | Stock | 19.2236 | 19.2236 | 19.2236 | 19.2236 | 5600.0 |
| 2014-04-01 09:05:00 | AAPL | Stock | 19.2232 | 19.2232 | 19.2196 | 19.2196 | 23492.0 |
| 2014-04-01 09:06:00 | AAPL | Stock | 19.2211 | 19.2211 | 19.2196 | 19.2196 | 14000.0 |
| 2014-04-01 09:11:00 | AAPL | Stock | 19.2161 | 19.2161 | 19.2161 | 19.2161 | 2800.0 |
| 2014-04-01 09:14:00 | AAPL | Stock | 19.2193 | 19.2218 | 19.2193 | 19.2218 | 8400.0 |
> showing 50 of 1,109,801 rows — these rows as CSV