PREVIEW / stock_5min / 2013-12-06
file: by_date/stock_5min/2013/2013-12-06.parquet size: 5.4 MB rows: 355,988 symbols: 3,528
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-06 04:00:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 5320.0 |
| 2013-12-06 04:05:00 | AAPL | Stock | 20.3357 | 20.3357 | 20.3357 | 20.3357 | 2800.0 |
| 2013-12-06 04:15:00 | AAPL | Stock | 20.3279 | 20.3279 | 20.3279 | 20.3279 | 2800.0 |
| 2013-12-06 04:25:00 | AAPL | Stock | 20.3454 | 20.3454 | 20.3454 | 20.3454 | 5600.0 |
| 2013-12-06 04:55:00 | AAPL | Stock | 20.3629 | 20.3629 | 20.3629 | 20.3629 | 2800.0 |
| 2013-12-06 05:00:00 | AAPL | Stock | 20.3721 | 20.3721 | 20.3564 | 20.3564 | 11200.0 |
| 2013-12-06 05:05:00 | AAPL | Stock | 20.3489 | 20.3489 | 20.3489 | 20.3489 | 2800.0 |
| 2013-12-06 05:15:00 | AAPL | Stock | 20.3571 | 20.3571 | 20.3571 | 20.3571 | 2800.0 |
| 2013-12-06 05:20:00 | AAPL | Stock | 20.3489 | 20.3489 | 20.3429 | 20.3429 | 8400.0 |
| 2013-12-06 05:25:00 | AAPL | Stock | 20.3429 | 20.3429 | 20.3429 | 20.3429 | 2912.0 |
| 2013-12-06 05:35:00 | AAPL | Stock | 20.3454 | 20.3571 | 20.3454 | 20.3571 | 16800.0 |
| 2013-12-06 05:45:00 | AAPL | Stock | 20.3432 | 20.3432 | 20.3429 | 20.3429 | 5600.0 |
| 2013-12-06 06:00:00 | AAPL | Stock | 20.3482 | 20.3568 | 20.3482 | 20.3568 | 19600.0 |
| 2013-12-06 06:05:00 | AAPL | Stock | 20.3321 | 20.3321 | 20.3214 | 20.3214 | 9800.0 |
| 2013-12-06 06:10:00 | AAPL | Stock | 20.3171 | 20.3171 | 20.3171 | 20.3171 | 2800.0 |
| 2013-12-06 06:25:00 | AAPL | Stock | 20.3125 | 20.3125 | 20.2857 | 20.2857 | 23856.0 |
| 2013-12-06 06:40:00 | AAPL | Stock | 20.2568 | 20.2568 | 20.2525 | 20.2564 | 30800.0 |
| 2013-12-06 06:45:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2321 | 20.2321 | 4200.0 |
| 2013-12-06 06:50:00 | AAPL | Stock | 20.2254 | 20.2386 | 20.2143 | 20.2386 | 61572.0 |
| 2013-12-06 06:55:00 | AAPL | Stock | 20.2411 | 20.2411 | 20.2411 | 20.2411 | 2800.0 |
| 2013-12-06 07:00:00 | AAPL | Stock | 20.25 | 20.2679 | 20.25 | 20.2679 | 18900.0 |
| 2013-12-06 07:05:00 | AAPL | Stock | 20.25 | 20.2679 | 20.25 | 20.2679 | 22960.0 |
| 2013-12-06 07:10:00 | AAPL | Stock | 20.275 | 20.275 | 20.275 | 20.275 | 25200.0 |
| 2013-12-06 07:15:00 | AAPL | Stock | 20.2682 | 20.2682 | 20.2643 | 20.2643 | 35140.0 |
| 2013-12-06 07:20:00 | AAPL | Stock | 20.2679 | 20.2679 | 20.2621 | 20.2621 | 26600.0 |
| 2013-12-06 07:25:00 | AAPL | Stock | 20.2536 | 20.2536 | 20.1875 | 20.1875 | 88844.0 |
| 2013-12-06 07:30:00 | AAPL | Stock | 20.1879 | 20.2064 | 20.1679 | 20.1971 | 182840.0 |
| 2013-12-06 07:35:00 | AAPL | Stock | 20.1875 | 20.1989 | 20.1875 | 20.1989 | 33600.0 |
| 2013-12-06 07:40:00 | AAPL | Stock | 20.1989 | 20.2143 | 20.1986 | 20.2046 | 41132.0 |
| 2013-12-06 07:45:00 | AAPL | Stock | 20.2125 | 20.2125 | 20.2125 | 20.2125 | 4200.0 |
| 2013-12-06 07:50:00 | AAPL | Stock | 20.2036 | 20.2139 | 20.2036 | 20.2139 | 35924.0 |
| 2013-12-06 07:55:00 | AAPL | Stock | 20.2082 | 20.2318 | 20.2054 | 20.2318 | 92064.0 |
| 2013-12-06 08:00:00 | AAPL | Stock | 20.2432 | 20.3571 | 20.1971 | 20.2107 | 343504.0 |
| 2013-12-06 08:05:00 | AAPL | Stock | 20.2143 | 20.2264 | 20.1986 | 20.1993 | 167972.0 |
| 2013-12-06 08:10:00 | AAPL | Stock | 20.2139 | 20.2321 | 20.2139 | 20.2321 | 72856.0 |
| 2013-12-06 08:15:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2079 | 20.2079 | 248780.0 |
| 2013-12-06 08:20:00 | AAPL | Stock | 20.2079 | 20.2118 | 20.2036 | 20.2071 | 103488.0 |
| 2013-12-06 08:25:00 | AAPL | Stock | 20.2071 | 20.2114 | 20.2054 | 20.2114 | 80416.0 |
| 2013-12-06 08:30:00 | AAPL | Stock | 20.2036 | 20.2389 | 20.1814 | 20.1982 | 804608.0 |
| 2013-12-06 08:35:00 | AAPL | Stock | 20.2004 | 20.2425 | 20.2004 | 20.2321 | 446152.0 |
| 2013-12-06 08:40:00 | AAPL | Stock | 20.2364 | 20.2468 | 20.2214 | 20.2418 | 418376.0 |
| 2013-12-06 08:45:00 | AAPL | Stock | 20.2418 | 20.2482 | 20.2325 | 20.2389 | 300776.0 |
| 2013-12-06 08:50:00 | AAPL | Stock | 20.2386 | 20.2389 | 20.205 | 20.2057 | 769860.0 |
| 2013-12-06 08:55:00 | AAPL | Stock | 20.2107 | 20.2143 | 20.2036 | 20.2143 | 460292.0 |
| 2013-12-06 09:00:00 | AAPL | Stock | 20.2164 | 20.2164 | 20.2075 | 20.2143 | 192220.0 |
| 2013-12-06 09:05:00 | AAPL | Stock | 20.2139 | 20.2214 | 20.2125 | 20.2214 | 124740.0 |
| 2013-12-06 09:10:00 | AAPL | Stock | 20.2214 | 20.2304 | 20.2146 | 20.2232 | 403900.0 |
| 2013-12-06 09:15:00 | AAPL | Stock | 20.2236 | 20.2314 | 20.2143 | 20.2143 | 497336.0 |
| 2013-12-06 09:20:00 | AAPL | Stock | 20.2146 | 20.2146 | 20.1996 | 20.2071 | 266504.0 |
| 2013-12-06 09:25:00 | AAPL | Stock | 20.1964 | 20.2211 | 20.1736 | 20.2175 | 711060.0 |
> showing 50 of 355,988 rows — these rows as CSV