PREVIEW / stock_5min / 2011-11-02
file: by_date/stock_5min/2011/2011-11-02.parquet size: 4.8 MB rows: 323,649 symbols: 3,495
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-02 04:00:00 | AAPL | Stock | 14.2686 | 14.2686 | 14.2686 | 14.2686 | 5600.0 |
| 2011-11-02 04:05:00 | AAPL | Stock | 14.2786 | 14.2996 | 14.2786 | 14.2996 | 11200.0 |
| 2011-11-02 04:10:00 | AAPL | Stock | 14.3036 | 14.3036 | 14.3036 | 14.3036 | 2800.0 |
| 2011-11-02 04:20:00 | AAPL | Stock | 14.315 | 14.315 | 14.315 | 14.315 | 8400.0 |
| 2011-11-02 04:45:00 | AAPL | Stock | 14.2875 | 14.2875 | 14.2875 | 14.2875 | 2800.0 |
| 2011-11-02 04:55:00 | AAPL | Stock | 14.3125 | 14.3125 | 14.3125 | 14.3125 | 14000.0 |
| 2011-11-02 05:00:00 | AAPL | Stock | 14.3125 | 14.3125 | 14.3125 | 14.3125 | 2800.0 |
| 2011-11-02 05:10:00 | AAPL | Stock | 14.2964 | 14.2964 | 14.2964 | 14.2964 | 5600.0 |
| 2011-11-02 05:25:00 | AAPL | Stock | 14.2857 | 14.2857 | 14.2857 | 14.2857 | 8400.0 |
| 2011-11-02 05:30:00 | AAPL | Stock | 14.2732 | 14.2732 | 14.2732 | 14.2732 | 8400.0 |
| 2011-11-02 05:40:00 | AAPL | Stock | 14.25 | 14.25 | 14.25 | 14.25 | 2800.0 |
| 2011-11-02 05:50:00 | AAPL | Stock | 14.2179 | 14.2179 | 14.2143 | 14.2143 | 11200.0 |
| 2011-11-02 05:55:00 | AAPL | Stock | 14.2286 | 14.2286 | 14.2286 | 14.2286 | 16800.0 |
| 2011-11-02 06:00:00 | AAPL | Stock | 14.2214 | 14.2214 | 14.2214 | 14.2214 | 2800.0 |
| 2011-11-02 06:10:00 | AAPL | Stock | 14.2286 | 14.2286 | 14.2286 | 14.2286 | 8400.0 |
| 2011-11-02 06:15:00 | AAPL | Stock | 14.2286 | 14.2286 | 14.2286 | 14.2286 | 2800.0 |
| 2011-11-02 06:50:00 | AAPL | Stock | 14.225 | 14.225 | 14.225 | 14.225 | 2800.0 |
| 2011-11-02 07:00:00 | AAPL | Stock | 14.2286 | 14.2286 | 14.2286 | 14.2286 | 2800.0 |
| 2011-11-02 07:05:00 | AAPL | Stock | 14.2314 | 14.2321 | 14.2314 | 14.2321 | 5600.0 |
| 2011-11-02 07:15:00 | AAPL | Stock | 14.2321 | 14.2321 | 14.2321 | 14.2321 | 19600.0 |
| 2011-11-02 07:25:00 | AAPL | Stock | 14.2436 | 14.2679 | 14.2436 | 14.2679 | 68040.0 |
| 2011-11-02 07:30:00 | AAPL | Stock | 14.2679 | 14.2679 | 14.2679 | 14.2679 | 2800.0 |
| 2011-11-02 07:40:00 | AAPL | Stock | 14.25 | 14.25 | 14.25 | 14.25 | 28840.0 |
| 2011-11-02 07:45:00 | AAPL | Stock | 14.2611 | 14.2679 | 14.2611 | 14.2679 | 11200.0 |
| 2011-11-02 07:50:00 | AAPL | Stock | 14.2679 | 14.2857 | 14.2679 | 14.2682 | 44520.0 |
| 2011-11-02 07:55:00 | AAPL | Stock | 14.2679 | 14.2679 | 14.2679 | 14.2679 | 8400.0 |
| 2011-11-02 08:00:00 | AAPL | Stock | 14.25 | 14.2679 | 14.25 | 14.2614 | 100548.0 |
| 2011-11-02 08:05:00 | AAPL | Stock | 14.2575 | 14.2743 | 14.2571 | 14.2732 | 150584.0 |
| 2011-11-02 08:10:00 | AAPL | Stock | 14.2736 | 14.2739 | 14.2643 | 14.2643 | 103992.0 |
| 2011-11-02 08:15:00 | AAPL | Stock | 14.2661 | 14.2768 | 14.2414 | 14.2514 | 328636.0 |
| 2011-11-02 08:20:00 | AAPL | Stock | 14.25 | 14.2568 | 14.2325 | 14.2329 | 126784.0 |
| 2011-11-02 08:25:00 | AAPL | Stock | 14.2411 | 14.2461 | 14.2357 | 14.2461 | 51520.0 |
| 2011-11-02 08:30:00 | AAPL | Stock | 14.2464 | 14.2607 | 14.2461 | 14.2461 | 153328.0 |
| 2011-11-02 08:35:00 | AAPL | Stock | 14.2496 | 14.2496 | 14.2396 | 14.2396 | 49196.0 |
| 2011-11-02 08:40:00 | AAPL | Stock | 14.2471 | 14.25 | 14.2411 | 14.2471 | 89040.0 |
| 2011-11-02 08:45:00 | AAPL | Stock | 14.2489 | 14.2493 | 14.2429 | 14.2429 | 14000.0 |
| 2011-11-02 08:50:00 | AAPL | Stock | 14.2464 | 14.2568 | 14.2464 | 14.2568 | 114296.0 |
| 2011-11-02 08:55:00 | AAPL | Stock | 14.2554 | 14.2554 | 14.245 | 14.2518 | 154168.0 |
| 2011-11-02 09:00:00 | AAPL | Stock | 14.2536 | 14.2675 | 14.2536 | 14.2657 | 283024.0 |
| 2011-11-02 09:05:00 | AAPL | Stock | 14.2679 | 14.29 | 14.2679 | 14.2839 | 245448.0 |
| 2011-11-02 09:10:00 | AAPL | Stock | 14.2786 | 14.3 | 14.2786 | 14.2986 | 231280.0 |
| 2011-11-02 09:15:00 | AAPL | Stock | 14.3011 | 14.3121 | 14.2982 | 14.3036 | 395808.0 |
| 2011-11-02 09:20:00 | AAPL | Stock | 14.3018 | 14.3164 | 14.2911 | 14.2957 | 461860.0 |
| 2011-11-02 09:25:00 | AAPL | Stock | 14.295 | 14.3018 | 14.2768 | 14.2884 | 331100.0 |
| 2011-11-02 09:30:00 | AAPL | Stock | 14.2929 | 14.3014 | 14.2375 | 14.2464 | 13378960.0 |
| 2011-11-02 09:35:00 | AAPL | Stock | 14.2454 | 14.2589 | 14.2143 | 14.2168 | 9279200.0 |
| 2011-11-02 09:40:00 | AAPL | Stock | 14.2186 | 14.2304 | 14.2075 | 14.2246 | 6924540.0 |
| 2011-11-02 09:45:00 | AAPL | Stock | 14.2243 | 14.2414 | 14.2132 | 14.2346 | 4796232.0 |
| 2011-11-02 09:50:00 | AAPL | Stock | 14.2329 | 14.235 | 14.2014 | 14.2173 | 4775428.0 |
| 2011-11-02 09:55:00 | AAPL | Stock | 14.2164 | 14.2177 | 14.1889 | 14.2086 | 5371772.0 |
> showing 50 of 323,649 rows — these rows as CSV