PREVIEW / stock_5min / 2012-01-18
file: by_date/stock_5min/2012/2012-01-18.parquet size: 4.8 MB rows: 320,568 symbols: 3,521
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-18 04:05:00 | AAPL | Stock | 15.1921 | 15.1921 | 15.1921 | 15.1921 | 2800.0 |
| 2012-01-18 04:15:00 | AAPL | Stock | 15.2207 | 15.2207 | 15.2207 | 15.2207 | 2800.0 |
| 2012-01-18 04:20:00 | AAPL | Stock | 15.2168 | 15.2168 | 15.2154 | 15.2154 | 16800.0 |
| 2012-01-18 04:40:00 | AAPL | Stock | 15.2218 | 15.2218 | 15.2218 | 15.2218 | 2800.0 |
| 2012-01-18 05:10:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.2321 | 15.2321 | 28000.0 |
| 2012-01-18 05:15:00 | AAPL | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 14000.0 |
| 2012-01-18 06:00:00 | AAPL | Stock | 15.2321 | 15.2321 | 15.2286 | 15.2286 | 8400.0 |
| 2012-01-18 06:05:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 5600.0 |
| 2012-01-18 06:25:00 | AAPL | Stock | 15.2036 | 15.2036 | 15.2036 | 15.2036 | 11200.0 |
| 2012-01-18 07:00:00 | AAPL | Stock | 15.2143 | 15.2321 | 15.2143 | 15.2143 | 40432.0 |
| 2012-01-18 07:05:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2057 | 15.2057 | 34300.0 |
| 2012-01-18 07:10:00 | AAPL | Stock | 15.1986 | 15.1986 | 15.1982 | 15.1982 | 8400.0 |
| 2012-01-18 07:15:00 | AAPL | Stock | 15.205 | 15.205 | 15.205 | 15.205 | 2800.0 |
| 2012-01-18 07:20:00 | AAPL | Stock | 15.1982 | 15.1982 | 15.1982 | 15.1982 | 5600.0 |
| 2012-01-18 07:30:00 | AAPL | Stock | 15.2054 | 15.2054 | 15.2054 | 15.2054 | 2800.0 |
| 2012-01-18 07:35:00 | AAPL | Stock | 15.1964 | 15.2054 | 15.1964 | 15.2054 | 8400.0 |
| 2012-01-18 07:40:00 | AAPL | Stock | 15.2243 | 15.2243 | 15.2243 | 15.2243 | 2800.0 |
| 2012-01-18 07:45:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 8400.0 |
| 2012-01-18 07:50:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 28000.0 |
| 2012-01-18 07:55:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 11200.0 |
| 2012-01-18 08:00:00 | AAPL | Stock | 15.2093 | 15.2136 | 15.1964 | 15.1986 | 317576.0 |
| 2012-01-18 08:05:00 | AAPL | Stock | 15.2021 | 15.2054 | 15.1289 | 15.1289 | 122388.0 |
| 2012-01-18 08:10:00 | AAPL | Stock | 15.2054 | 15.2071 | 15.2014 | 15.2036 | 41160.0 |
| 2012-01-18 08:15:00 | AAPL | Stock | 15.2079 | 15.2179 | 15.2079 | 15.2179 | 101108.0 |
| 2012-01-18 08:20:00 | AAPL | Stock | 15.2179 | 15.2179 | 15.2143 | 15.2179 | 137340.0 |
| 2012-01-18 08:25:00 | AAPL | Stock | 15.2161 | 15.2321 | 15.2143 | 15.2321 | 437472.0 |
| 2012-01-18 08:30:00 | AAPL | Stock | 15.2311 | 15.2321 | 15.2232 | 15.2275 | 260484.0 |
| 2012-01-18 08:35:00 | AAPL | Stock | 15.2286 | 15.2393 | 15.2286 | 15.2393 | 102704.0 |
| 2012-01-18 08:40:00 | AAPL | Stock | 15.2429 | 15.2429 | 15.2321 | 15.2332 | 139916.0 |
| 2012-01-18 08:45:00 | AAPL | Stock | 15.2389 | 15.2464 | 15.2339 | 15.2411 | 144900.0 |
| 2012-01-18 08:50:00 | AAPL | Stock | 15.2393 | 15.2393 | 15.2232 | 15.2232 | 210308.0 |
| 2012-01-18 08:55:00 | AAPL | Stock | 15.2239 | 15.2321 | 15.2189 | 15.2193 | 248080.0 |
| 2012-01-18 09:00:00 | AAPL | Stock | 15.2182 | 15.2282 | 15.2146 | 15.2264 | 130648.0 |
| 2012-01-18 09:05:00 | AAPL | Stock | 15.2286 | 15.2311 | 15.2214 | 15.2218 | 102172.0 |
| 2012-01-18 09:10:00 | AAPL | Stock | 15.2236 | 15.2321 | 15.2221 | 15.2268 | 225904.0 |
| 2012-01-18 09:15:00 | AAPL | Stock | 15.2314 | 15.2368 | 15.2289 | 15.2321 | 138908.0 |
| 2012-01-18 09:20:00 | AAPL | Stock | 15.2321 | 15.2325 | 15.2296 | 15.2325 | 39900.0 |
| 2012-01-18 09:25:00 | AAPL | Stock | 15.2321 | 15.2486 | 15.2293 | 15.2475 | 218680.0 |
| 2012-01-18 09:30:00 | AAPL | Stock | 15.2468 | 15.2575 | 15.225 | 15.2475 | 19667704.0 |
| 2012-01-18 09:35:00 | AAPL | Stock | 15.2486 | 15.2839 | 15.2421 | 15.2814 | 14630588.0 |
| 2012-01-18 09:40:00 | AAPL | Stock | 15.28 | 15.2886 | 15.2571 | 15.2814 | 9764216.0 |
| 2012-01-18 09:45:00 | AAPL | Stock | 15.2782 | 15.2839 | 15.2629 | 15.2682 | 6786500.0 |
| 2012-01-18 09:50:00 | AAPL | Stock | 15.2706 | 15.2786 | 15.2471 | 15.2604 | 6861288.0 |
| 2012-01-18 09:55:00 | AAPL | Stock | 15.2604 | 15.2643 | 15.2329 | 15.2471 | 5410076.0 |
| 2012-01-18 10:00:00 | AAPL | Stock | 15.2474 | 15.2746 | 15.2461 | 15.2711 | 6618976.0 |
| 2012-01-18 10:05:00 | AAPL | Stock | 15.2725 | 15.2821 | 15.2657 | 15.2696 | 4170684.0 |
| 2012-01-18 10:10:00 | AAPL | Stock | 15.2696 | 15.2729 | 15.2536 | 15.2586 | 3038952.0 |
| 2012-01-18 10:15:00 | AAPL | Stock | 15.2589 | 15.2618 | 15.2411 | 15.2471 | 4629856.0 |
| 2012-01-18 10:20:00 | AAPL | Stock | 15.2477 | 15.2636 | 15.2436 | 15.2604 | 4323004.0 |
| 2012-01-18 10:25:00 | AAPL | Stock | 15.261 | 15.2679 | 15.2546 | 15.2643 | 2761724.0 |
> showing 50 of 320,568 rows — these rows as CSV