PREVIEW / stock_5min / 2013-12-04
file: by_date/stock_5min/2013/2013-12-04.parquet size: 5.4 MB rows: 357,067 symbols: 3,535
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-04 04:05:00 | AAPL | Stock | 20.2771 | 20.2771 | 20.2771 | 20.2771 | 5600.0 |
| 2013-12-04 04:50:00 | AAPL | Stock | 20.2936 | 20.2936 | 20.2936 | 20.2936 | 7924.0 |
| 2013-12-04 05:35:00 | AAPL | Stock | 20.2986 | 20.2986 | 20.2986 | 20.2986 | 11088.0 |
| 2013-12-04 06:00:00 | AAPL | Stock | 20.3125 | 20.3125 | 20.3125 | 20.3125 | 5600.0 |
| 2013-12-04 06:10:00 | AAPL | Stock | 20.3029 | 20.3029 | 20.3029 | 20.3029 | 2800.0 |
| 2013-12-04 06:15:00 | AAPL | Stock | 20.3 | 20.3 | 20.3 | 20.3 | 5600.0 |
| 2013-12-04 06:20:00 | AAPL | Stock | 20.3125 | 20.3125 | 20.3125 | 20.3125 | 7280.0 |
| 2013-12-04 06:25:00 | AAPL | Stock | 20.3036 | 20.3036 | 20.3036 | 20.3036 | 2800.0 |
| 2013-12-04 06:30:00 | AAPL | Stock | 20.3036 | 20.3036 | 20.3 | 20.3 | 8400.0 |
| 2013-12-04 06:35:00 | AAPL | Stock | 20.31 | 20.31 | 20.31 | 20.31 | 2800.0 |
| 2013-12-04 06:40:00 | AAPL | Stock | 20.3118 | 20.3118 | 20.2864 | 20.2875 | 43988.0 |
| 2013-12-04 06:45:00 | AAPL | Stock | 20.2857 | 20.2904 | 20.2857 | 20.2904 | 32396.0 |
| 2013-12-04 06:55:00 | AAPL | Stock | 20.2757 | 20.2757 | 20.2707 | 20.2757 | 11200.0 |
| 2013-12-04 07:00:00 | AAPL | Stock | 20.2757 | 20.2964 | 20.2646 | 20.2882 | 120036.0 |
| 2013-12-04 07:05:00 | AAPL | Stock | 20.2857 | 20.3036 | 20.2804 | 20.3036 | 51800.0 |
| 2013-12-04 07:10:00 | AAPL | Stock | 20.2996 | 20.3036 | 20.2946 | 20.3036 | 34636.0 |
| 2013-12-04 07:15:00 | AAPL | Stock | 20.3096 | 20.3214 | 20.3036 | 20.3036 | 104720.0 |
| 2013-12-04 07:20:00 | AAPL | Stock | 20.3007 | 20.3093 | 20.2982 | 20.3036 | 118440.0 |
| 2013-12-04 07:25:00 | AAPL | Stock | 20.3096 | 20.3096 | 20.3089 | 20.3089 | 44800.0 |
| 2013-12-04 07:30:00 | AAPL | Stock | 20.3032 | 20.3386 | 20.3014 | 20.325 | 349440.0 |
| 2013-12-04 07:35:00 | AAPL | Stock | 20.325 | 20.3357 | 20.3214 | 20.3339 | 69384.0 |
| 2013-12-04 07:40:00 | AAPL | Stock | 20.3354 | 20.3354 | 20.3139 | 20.3179 | 37520.0 |
| 2013-12-04 07:45:00 | AAPL | Stock | 20.3143 | 20.3143 | 20.2982 | 20.2982 | 112056.0 |
| 2013-12-04 07:50:00 | AAPL | Stock | 20.2971 | 20.2982 | 20.2664 | 20.2786 | 194712.0 |
| 2013-12-04 07:55:00 | AAPL | Stock | 20.2893 | 20.2893 | 20.275 | 20.275 | 54040.0 |
| 2013-12-04 08:00:00 | AAPL | Stock | 20.275 | 20.3382 | 20.1679 | 20.2786 | 676620.0 |
| 2013-12-04 08:05:00 | AAPL | Stock | 20.2718 | 20.2721 | 20.2454 | 20.2532 | 232372.0 |
| 2013-12-04 08:10:00 | AAPL | Stock | 20.25 | 20.2661 | 20.2143 | 20.2143 | 216412.0 |
| 2013-12-04 08:15:00 | AAPL | Stock | 20.2143 | 20.2339 | 20.2143 | 20.2314 | 211092.0 |
| 2013-12-04 08:20:00 | AAPL | Stock | 20.2196 | 20.2321 | 20.2064 | 20.2064 | 382508.0 |
| 2013-12-04 08:25:00 | AAPL | Stock | 20.2021 | 20.2107 | 20.1929 | 20.2107 | 338912.0 |
| 2013-12-04 08:30:00 | AAPL | Stock | 20.2114 | 20.2596 | 20.2114 | 20.2571 | 401268.0 |
| 2013-12-04 08:35:00 | AAPL | Stock | 20.2532 | 20.2718 | 20.25 | 20.2679 | 234416.0 |
| 2013-12-04 08:40:00 | AAPL | Stock | 20.2661 | 20.2661 | 20.2568 | 20.2568 | 169652.0 |
| 2013-12-04 08:45:00 | AAPL | Stock | 20.2607 | 20.2643 | 20.2543 | 20.2571 | 141568.0 |
| 2013-12-04 08:50:00 | AAPL | Stock | 20.2543 | 20.2557 | 20.2321 | 20.2321 | 58016.0 |
| 2013-12-04 08:55:00 | AAPL | Stock | 20.2332 | 20.2371 | 20.2179 | 20.2371 | 278796.0 |
| 2013-12-04 09:00:00 | AAPL | Stock | 20.2371 | 20.2371 | 20.22 | 20.22 | 21308.0 |
| 2013-12-04 09:05:00 | AAPL | Stock | 20.2179 | 20.2204 | 20.1975 | 20.21 | 301280.0 |
| 2013-12-04 09:10:00 | AAPL | Stock | 20.21 | 20.225 | 20.2054 | 20.2054 | 103740.0 |
| 2013-12-04 09:15:00 | AAPL | Stock | 20.2054 | 20.2143 | 20.2054 | 20.2143 | 16800.0 |
| 2013-12-04 09:20:00 | AAPL | Stock | 20.2068 | 20.2068 | 20.1893 | 20.1982 | 93660.0 |
| 2013-12-04 09:25:00 | AAPL | Stock | 20.1964 | 20.2143 | 20.1946 | 20.1964 | 93800.0 |
| 2013-12-04 09:30:00 | AAPL | Stock | 20.1964 | 20.2143 | 20.0464 | 20.1035 | 22349712.0 |
| 2013-12-04 09:35:00 | AAPL | Stock | 20.1032 | 20.1589 | 20.0982 | 20.1432 | 10054548.0 |
| 2013-12-04 09:40:00 | AAPL | Stock | 20.1429 | 20.1532 | 20.0907 | 20.1143 | 7038388.0 |
| 2013-12-04 09:45:00 | AAPL | Stock | 20.1136 | 20.125 | 20.09 | 20.1148 | 6532428.0 |
| 2013-12-04 09:50:00 | AAPL | Stock | 20.115 | 20.125 | 20.0293 | 20.0375 | 10902780.0 |
| 2013-12-04 09:55:00 | AAPL | Stock | 20.0386 | 20.0957 | 20.0325 | 20.0725 | 6310108.0 |
| 2013-12-04 10:00:00 | AAPL | Stock | 20.0725 | 20.1014 | 20.05 | 20.0979 | 8224328.0 |
> showing 50 of 357,067 rows — these rows as CSV