PREVIEW / stock_1min / 2007-02-22
file: by_date/stock_1min/2007/2007-02-22.parquet size: 9.5 MB rows: 771,694 symbols: 2,057
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-22 04:15:00 | AAPL | Stock | 3.1964 | 3.2 | 3.1964 | 3.2 | 24640.0 |
| 2007-02-22 04:20:00 | AAPL | Stock | 3.2 | 3.2 | 3.2 | 3.2 | 2800.0 |
| 2007-02-22 04:40:00 | AAPL | Stock | 3.2 | 3.2 | 3.2 | 3.2 | 39200.0 |
| 2007-02-22 05:20:00 | AAPL | Stock | 3.2007 | 3.2007 | 3.2 | 3.2 | 14000.0 |
| 2007-02-22 06:36:00 | AAPL | Stock | 3.2036 | 3.2036 | 3.2036 | 3.2036 | 67200.0 |
| 2007-02-22 06:48:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2071 | 3.2071 | 2800.0 |
| 2007-02-22 06:52:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2071 | 3.2071 | 2800.0 |
| 2007-02-22 06:58:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2071 | 3.2071 | 25200.0 |
| 2007-02-22 07:03:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2071 | 3.2071 | 33600.0 |
| 2007-02-22 07:04:00 | AAPL | Stock | 3.2018 | 3.2018 | 3.2018 | 3.2018 | 5180.0 |
| 2007-02-22 07:05:00 | AAPL | Stock | 3.2071 | 3.2089 | 3.2071 | 3.2089 | 53200.0 |
| 2007-02-22 07:06:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2071 | 3.2071 | 13300.0 |
| 2007-02-22 07:08:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2089 | 3.2089 | 28000.0 |
| 2007-02-22 07:09:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2089 | 3.2089 | 11200.0 |
| 2007-02-22 07:10:00 | AAPL | Stock | 3.2121 | 3.2121 | 3.2121 | 3.2121 | 16800.0 |
| 2007-02-22 07:11:00 | AAPL | Stock | 3.2125 | 3.2139 | 3.2125 | 3.2139 | 22400.0 |
| 2007-02-22 07:12:00 | AAPL | Stock | 3.2139 | 3.2139 | 3.2139 | 3.2139 | 2800.0 |
| 2007-02-22 07:13:00 | AAPL | Stock | 3.2139 | 3.2139 | 3.2139 | 3.2139 | 2800.0 |
| 2007-02-22 07:16:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2089 | 3.2089 | 28000.0 |
| 2007-02-22 07:17:00 | AAPL | Stock | 3.2079 | 3.2079 | 3.2079 | 3.2079 | 5600.0 |
| 2007-02-22 07:18:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2071 | 3.2071 | 14000.0 |
| 2007-02-22 07:34:00 | AAPL | Stock | 3.2007 | 3.2007 | 3.2 | 3.2 | 16800.0 |
| 2007-02-22 07:35:00 | AAPL | Stock | 3.2014 | 3.2014 | 3.2014 | 3.2014 | 5600.0 |
| 2007-02-22 07:38:00 | AAPL | Stock | 3.2011 | 3.2014 | 3.2011 | 3.2014 | 14000.0 |
| 2007-02-22 07:39:00 | AAPL | Stock | 3.205 | 3.2064 | 3.205 | 3.2054 | 162400.0 |
| 2007-02-22 07:40:00 | AAPL | Stock | 3.2054 | 3.2064 | 3.2043 | 3.2043 | 61600.0 |
| 2007-02-22 07:41:00 | AAPL | Stock | 3.2054 | 3.2089 | 3.2054 | 3.2089 | 148400.0 |
| 2007-02-22 07:42:00 | AAPL | Stock | 3.2089 | 3.2107 | 3.2089 | 3.2107 | 30800.0 |
| 2007-02-22 07:43:00 | AAPL | Stock | 3.2125 | 3.2179 | 3.2125 | 3.2179 | 259000.0 |
| 2007-02-22 07:44:00 | AAPL | Stock | 3.2179 | 3.2211 | 3.2179 | 3.2179 | 35140.0 |
| 2007-02-22 07:45:00 | AAPL | Stock | 3.2179 | 3.2179 | 3.2125 | 3.2143 | 32200.0 |
| 2007-02-22 07:46:00 | AAPL | Stock | 3.2125 | 3.2129 | 3.21 | 3.2125 | 140000.0 |
| 2007-02-22 07:47:00 | AAPL | Stock | 3.2107 | 3.2107 | 3.2107 | 3.2107 | 2800.0 |
| 2007-02-22 07:49:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2071 | 3.2071 | 75600.0 |
| 2007-02-22 07:50:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2089 | 3.2089 | 14000.0 |
| 2007-02-22 07:51:00 | AAPL | Stock | 3.21 | 3.21 | 3.21 | 3.21 | 5600.0 |
| 2007-02-22 07:52:00 | AAPL | Stock | 3.21 | 3.2107 | 3.2071 | 3.21 | 92400.0 |
| 2007-02-22 07:53:00 | AAPL | Stock | 3.21 | 3.21 | 3.2089 | 3.2089 | 92400.0 |
| 2007-02-22 07:54:00 | AAPL | Stock | 3.2096 | 3.2096 | 3.2096 | 3.2096 | 28000.0 |
| 2007-02-22 07:55:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2089 | 3.2089 | 5600.0 |
| 2007-02-22 07:57:00 | AAPL | Stock | 3.2089 | 3.2089 | 3.2071 | 3.2071 | 16800.0 |
| 2007-02-22 07:58:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2064 | 3.2064 | 42000.0 |
| 2007-02-22 07:59:00 | AAPL | Stock | 3.2043 | 3.2071 | 3.2043 | 3.2071 | 58800.0 |
| 2007-02-22 08:00:00 | AAPL | Stock | 3.2082 | 3.2146 | 3.2036 | 3.2143 | 1042692.0 |
| 2007-02-22 08:01:00 | AAPL | Stock | 3.2143 | 3.2179 | 3.2129 | 3.2179 | 397712.0 |
| 2007-02-22 08:02:00 | AAPL | Stock | 3.2179 | 3.22 | 3.2143 | 3.2196 | 305648.0 |
| 2007-02-22 08:03:00 | AAPL | Stock | 3.2196 | 3.2243 | 3.2193 | 3.2221 | 632100.0 |
| 2007-02-22 08:04:00 | AAPL | Stock | 3.2211 | 3.2286 | 3.2211 | 3.2286 | 551572.0 |
| 2007-02-22 08:05:00 | AAPL | Stock | 3.2286 | 3.2304 | 3.2268 | 3.23 | 492296.0 |
| 2007-02-22 08:06:00 | AAPL | Stock | 3.23 | 3.2357 | 3.23 | 3.235 | 683620.0 |
> showing 50 of 771,694 rows — these rows as CSV