PREVIEW / stock_5min / 2013-12-11
file: by_date/stock_5min/2013/2013-12-11.parquet size: 5.5 MB rows: 361,313 symbols: 3,529
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-11 04:00:00 | AAPL | Stock | 20.1786 | 20.1786 | 20.1786 | 20.1786 | 12936.0 |
| 2013-12-11 04:20:00 | AAPL | Stock | 20.1896 | 20.1896 | 20.1896 | 20.1896 | 2800.0 |
| 2013-12-11 04:40:00 | AAPL | Stock | 20.2079 | 20.2079 | 20.2079 | 20.2079 | 2800.0 |
| 2013-12-11 05:45:00 | AAPL | Stock | 20.2329 | 20.2329 | 20.2329 | 20.2329 | 2800.0 |
| 2013-12-11 05:50:00 | AAPL | Stock | 20.2289 | 20.2289 | 20.2289 | 20.2289 | 2800.0 |
| 2013-12-11 06:10:00 | AAPL | Stock | 20.2204 | 20.2204 | 20.2204 | 20.2204 | 2800.0 |
| 2013-12-11 06:15:00 | AAPL | Stock | 20.2014 | 20.2014 | 20.2014 | 20.2014 | 11200.0 |
| 2013-12-11 06:20:00 | AAPL | Stock | 20.2014 | 20.2014 | 20.2014 | 20.2014 | 14000.0 |
| 2013-12-11 06:25:00 | AAPL | Stock | 20.2014 | 20.2014 | 20.2014 | 20.2014 | 16800.0 |
| 2013-12-11 06:30:00 | AAPL | Stock | 20.2132 | 20.2136 | 20.1982 | 20.1982 | 35084.0 |
| 2013-12-11 06:35:00 | AAPL | Stock | 20.1989 | 20.2025 | 20.1989 | 20.2025 | 8204.0 |
| 2013-12-11 06:45:00 | AAPL | Stock | 20.2021 | 20.2021 | 20.2018 | 20.2018 | 8428.0 |
| 2013-12-11 06:50:00 | AAPL | Stock | 20.1979 | 20.1979 | 20.1979 | 20.1979 | 2800.0 |
| 2013-12-11 06:55:00 | AAPL | Stock | 20.1954 | 20.1954 | 20.1954 | 20.1954 | 2800.0 |
| 2013-12-11 07:00:00 | AAPL | Stock | 20.2021 | 20.2321 | 20.2021 | 20.2321 | 19600.0 |
| 2013-12-11 07:05:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2004 | 20.2039 | 16800.0 |
| 2013-12-11 07:10:00 | AAPL | Stock | 20.1996 | 20.1996 | 20.1954 | 20.1954 | 24220.0 |
| 2013-12-11 07:15:00 | AAPL | Stock | 20.1954 | 20.1954 | 20.1464 | 20.1893 | 41160.0 |
| 2013-12-11 07:35:00 | AAPL | Stock | 20.22 | 20.22 | 20.22 | 20.22 | 2800.0 |
| 2013-12-11 07:40:00 | AAPL | Stock | 20.2211 | 20.2321 | 20.2211 | 20.2321 | 31360.0 |
| 2013-12-11 07:45:00 | AAPL | Stock | 20.25 | 20.25 | 20.2464 | 20.2464 | 5600.0 |
| 2013-12-11 07:50:00 | AAPL | Stock | 20.25 | 20.2586 | 20.25 | 20.2586 | 38332.0 |
| 2013-12-11 07:55:00 | AAPL | Stock | 20.2579 | 20.2679 | 20.2579 | 20.2679 | 22400.0 |
| 2013-12-11 08:00:00 | AAPL | Stock | 20.2696 | 20.2754 | 20.1786 | 20.2739 | 168000.0 |
| 2013-12-11 08:05:00 | AAPL | Stock | 20.2661 | 20.2768 | 20.2661 | 20.2679 | 141176.0 |
| 2013-12-11 08:10:00 | AAPL | Stock | 20.28 | 20.2982 | 20.2704 | 20.2936 | 199360.0 |
| 2013-12-11 08:15:00 | AAPL | Stock | 20.2946 | 20.31 | 20.2929 | 20.3036 | 232092.0 |
| 2013-12-11 08:20:00 | AAPL | Stock | 20.3086 | 20.3107 | 20.2907 | 20.2907 | 135520.0 |
| 2013-12-11 08:25:00 | AAPL | Stock | 20.2979 | 20.3025 | 20.2893 | 20.3014 | 54600.0 |
| 2013-12-11 08:30:00 | AAPL | Stock | 20.2875 | 20.2875 | 20.2857 | 20.2857 | 36876.0 |
| 2013-12-11 08:35:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2786 | 20.2786 | 24108.0 |
| 2013-12-11 08:40:00 | AAPL | Stock | 20.2786 | 20.2857 | 20.2786 | 20.2857 | 39564.0 |
| 2013-12-11 08:45:00 | AAPL | Stock | 20.285 | 20.285 | 20.2811 | 20.2818 | 32200.0 |
| 2013-12-11 08:50:00 | AAPL | Stock | 20.2732 | 20.2821 | 20.2718 | 20.2821 | 59920.0 |
| 2013-12-11 08:55:00 | AAPL | Stock | 20.2775 | 20.2775 | 20.2729 | 20.2729 | 16072.0 |
| 2013-12-11 09:00:00 | AAPL | Stock | 20.28 | 20.28 | 20.28 | 20.28 | 2800.0 |
| 2013-12-11 09:05:00 | AAPL | Stock | 20.2786 | 20.28 | 20.2679 | 20.2704 | 82040.0 |
| 2013-12-11 09:10:00 | AAPL | Stock | 20.2732 | 20.2732 | 20.2732 | 20.2732 | 11200.0 |
| 2013-12-11 09:15:00 | AAPL | Stock | 20.2764 | 20.2782 | 20.2671 | 20.2671 | 51240.0 |
| 2013-12-11 09:20:00 | AAPL | Stock | 20.2671 | 20.2679 | 20.2589 | 20.2679 | 79296.0 |
| 2013-12-11 09:25:00 | AAPL | Stock | 20.2636 | 20.2679 | 20.2321 | 20.2343 | 327516.0 |
| 2013-12-11 09:30:00 | AAPL | Stock | 20.2361 | 20.3604 | 20.2343 | 20.3136 | 17102960.0 |
| 2013-12-11 09:35:00 | AAPL | Stock | 20.325 | 20.3918 | 20.3171 | 20.3443 | 10728396.0 |
| 2013-12-11 09:40:00 | AAPL | Stock | 20.3404 | 20.3729 | 20.3043 | 20.3425 | 7261996.0 |
| 2013-12-11 09:45:00 | AAPL | Stock | 20.3443 | 20.3514 | 20.2729 | 20.2973 | 6598592.0 |
| 2013-12-11 09:50:00 | AAPL | Stock | 20.2996 | 20.3054 | 20.2446 | 20.3036 | 5967192.0 |
| 2013-12-11 09:55:00 | AAPL | Stock | 20.3046 | 20.3214 | 20.2871 | 20.2989 | 4068764.0 |
| 2013-12-11 10:00:00 | AAPL | Stock | 20.2936 | 20.2954 | 20.2614 | 20.2786 | 3753736.0 |
| 2013-12-11 10:05:00 | AAPL | Stock | 20.2757 | 20.2757 | 20.1875 | 20.2211 | 7700084.0 |
| 2013-12-11 10:10:00 | AAPL | Stock | 20.2239 | 20.2532 | 20.2179 | 20.235 | 4405884.0 |
> showing 50 of 361,313 rows — these rows as CSV