PREVIEW / stock_5min / 2010-01-25
file: by_date/stock_5min/2010/2010-01-25.parquet size: 4.8 MB rows: 326,944 symbols: 3,451
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-25 04:15:00 | AAPL | Stock | 7.175 | 7.175 | 7.175 | 7.175 | 5600.0 |
| 2010-01-25 04:20:00 | AAPL | Stock | 7.1946 | 7.1946 | 7.1946 | 7.1946 | 2800.0 |
| 2010-01-25 04:25:00 | AAPL | Stock | 7.1829 | 7.1829 | 7.1829 | 7.1829 | 2800.0 |
| 2010-01-25 04:30:00 | AAPL | Stock | 7.1821 | 7.1821 | 7.1821 | 7.1821 | 2800.0 |
| 2010-01-25 04:45:00 | AAPL | Stock | 7.1936 | 7.225 | 7.1936 | 7.225 | 8400.0 |
| 2010-01-25 05:05:00 | AAPL | Stock | 7.2354 | 7.2354 | 7.2321 | 7.2321 | 13412.0 |
| 2010-01-25 05:10:00 | AAPL | Stock | 7.2321 | 7.25 | 7.2321 | 7.25 | 8400.0 |
| 2010-01-25 05:15:00 | AAPL | Stock | 7.2568 | 7.2568 | 7.2568 | 7.2568 | 2800.0 |
| 2010-01-25 05:30:00 | AAPL | Stock | 7.2532 | 7.2532 | 7.2532 | 7.2532 | 6440.0 |
| 2010-01-25 05:45:00 | AAPL | Stock | 7.2471 | 7.2471 | 7.2354 | 7.2393 | 23240.0 |
| 2010-01-25 05:50:00 | AAPL | Stock | 7.2393 | 7.2446 | 7.2321 | 7.2446 | 86800.0 |
| 2010-01-25 06:05:00 | AAPL | Stock | 7.25 | 7.25 | 7.2393 | 7.2393 | 14000.0 |
| 2010-01-25 06:10:00 | AAPL | Stock | 7.25 | 7.25 | 7.25 | 7.25 | 7000.0 |
| 2010-01-25 06:15:00 | AAPL | Stock | 7.2496 | 7.25 | 7.2496 | 7.25 | 33600.0 |
| 2010-01-25 06:20:00 | AAPL | Stock | 7.25 | 7.25 | 7.25 | 7.25 | 6104.0 |
| 2010-01-25 06:25:00 | AAPL | Stock | 7.2339 | 7.2339 | 7.2304 | 7.2339 | 16800.0 |
| 2010-01-25 06:30:00 | AAPL | Stock | 7.2454 | 7.2454 | 7.2454 | 7.2454 | 2800.0 |
| 2010-01-25 06:35:00 | AAPL | Stock | 7.2293 | 7.2293 | 7.2282 | 7.2282 | 36400.0 |
| 2010-01-25 06:45:00 | AAPL | Stock | 7.2286 | 7.2382 | 7.2282 | 7.2382 | 11200.0 |
| 2010-01-25 06:50:00 | AAPL | Stock | 7.2318 | 7.2318 | 7.2286 | 7.2286 | 19824.0 |
| 2010-01-25 06:55:00 | AAPL | Stock | 7.2239 | 7.2282 | 7.2168 | 7.2196 | 50288.0 |
| 2010-01-25 07:00:00 | AAPL | Stock | 7.2164 | 7.2282 | 7.2139 | 7.2229 | 84616.0 |
| 2010-01-25 07:05:00 | AAPL | Stock | 7.2229 | 7.2232 | 7.1964 | 7.1964 | 98644.0 |
| 2010-01-25 07:10:00 | AAPL | Stock | 7.2136 | 7.2136 | 7.2093 | 7.2093 | 8400.0 |
| 2010-01-25 07:15:00 | AAPL | Stock | 7.2089 | 7.2232 | 7.2086 | 7.2107 | 311472.0 |
| 2010-01-25 07:20:00 | AAPL | Stock | 7.2107 | 7.2214 | 7.2107 | 7.2214 | 119812.0 |
| 2010-01-25 07:25:00 | AAPL | Stock | 7.2164 | 7.2164 | 7.2036 | 7.2039 | 160160.0 |
| 2010-01-25 07:30:00 | AAPL | Stock | 7.2036 | 7.2071 | 7.1857 | 7.1982 | 111720.0 |
| 2010-01-25 07:35:00 | AAPL | Stock | 7.1929 | 7.1986 | 7.1929 | 7.1986 | 30520.0 |
| 2010-01-25 07:40:00 | AAPL | Stock | 7.1857 | 7.2143 | 7.1825 | 7.1857 | 141036.0 |
| 2010-01-25 07:45:00 | AAPL | Stock | 7.1857 | 7.1911 | 7.1825 | 7.1846 | 167300.0 |
| 2010-01-25 07:50:00 | AAPL | Stock | 7.1893 | 7.2025 | 7.1893 | 7.1986 | 57540.0 |
| 2010-01-25 07:55:00 | AAPL | Stock | 7.1993 | 7.1993 | 7.1896 | 7.1946 | 141680.0 |
| 2010-01-25 08:00:00 | AAPL | Stock | 7.1904 | 7.2182 | 7.1896 | 7.2164 | 1448272.0 |
| 2010-01-25 08:05:00 | AAPL | Stock | 7.2146 | 7.2321 | 7.2125 | 7.225 | 1527596.0 |
| 2010-01-25 08:10:00 | AAPL | Stock | 7.2239 | 7.2279 | 7.2143 | 7.2279 | 1148084.0 |
| 2010-01-25 08:15:00 | AAPL | Stock | 7.2264 | 7.2293 | 7.2196 | 7.2246 | 397544.0 |
| 2010-01-25 08:20:00 | AAPL | Stock | 7.2271 | 7.2339 | 7.2236 | 7.2304 | 670516.0 |
| 2010-01-25 08:25:00 | AAPL | Stock | 7.2304 | 7.2321 | 7.2279 | 7.2304 | 243824.0 |
| 2010-01-25 08:30:00 | AAPL | Stock | 7.2314 | 7.2314 | 7.2179 | 7.2211 | 644532.0 |
| 2010-01-25 08:35:00 | AAPL | Stock | 7.2232 | 7.2232 | 7.2146 | 7.2159 | 490672.0 |
| 2010-01-25 08:40:00 | AAPL | Stock | 7.2161 | 7.2214 | 7.2146 | 7.2179 | 253960.0 |
| 2010-01-25 08:45:00 | AAPL | Stock | 7.2189 | 7.2214 | 7.2157 | 7.2171 | 358400.0 |
| 2010-01-25 08:50:00 | AAPL | Stock | 7.2179 | 7.2182 | 7.2089 | 7.2143 | 501984.0 |
| 2010-01-25 08:55:00 | AAPL | Stock | 7.2121 | 7.2214 | 7.2096 | 7.2214 | 638456.0 |
| 2010-01-25 09:00:00 | AAPL | Stock | 7.2196 | 7.2211 | 7.2054 | 7.2107 | 575680.0 |
| 2010-01-25 09:05:00 | AAPL | Stock | 7.2107 | 7.2229 | 7.2089 | 7.2229 | 566272.0 |
| 2010-01-25 09:10:00 | AAPL | Stock | 7.2229 | 7.2357 | 7.2229 | 7.2339 | 917840.0 |
| 2010-01-25 09:15:00 | AAPL | Stock | 7.2321 | 7.2375 | 7.225 | 7.2321 | 698096.0 |
| 2010-01-25 09:20:00 | AAPL | Stock | 7.2329 | 7.2361 | 7.2321 | 7.2321 | 452760.0 |
> showing 50 of 326,944 rows — these rows as CSV