PREVIEW / stock_5min / 2013-02-20
file: by_date/stock_5min/2013/2013-02-20.parquet size: 5.1 MB rows: 337,713 symbols: 3,497
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-02-20 04:00:00 | AAPL | Stock | 16.4286 | 16.4286 | 16.4286 | 16.4286 | 2800.0 |
| 2013-02-20 04:05:00 | AAPL | Stock | 16.4464 | 16.4464 | 16.4464 | 16.4464 | 11200.0 |
| 2013-02-20 04:20:00 | AAPL | Stock | 16.4464 | 16.4464 | 16.4464 | 16.4464 | 25200.0 |
| 2013-02-20 06:05:00 | AAPL | Stock | 16.4107 | 16.4107 | 16.3221 | 16.3221 | 56000.0 |
| 2013-02-20 06:10:00 | AAPL | Stock | 16.3043 | 16.3043 | 16.2936 | 16.2964 | 102200.0 |
| 2013-02-20 06:15:00 | AAPL | Stock | 16.3054 | 16.3214 | 16.3054 | 16.3214 | 16520.0 |
| 2013-02-20 06:20:00 | AAPL | Stock | 16.315 | 16.315 | 16.315 | 16.315 | 11200.0 |
| 2013-02-20 06:25:00 | AAPL | Stock | 16.3054 | 16.3054 | 16.3046 | 16.3046 | 5600.0 |
| 2013-02-20 06:30:00 | AAPL | Stock | 16.3036 | 16.3036 | 16.3036 | 16.3036 | 5348.0 |
| 2013-02-20 06:35:00 | AAPL | Stock | 16.3039 | 16.3039 | 16.2818 | 16.2861 | 155988.0 |
| 2013-02-20 06:40:00 | AAPL | Stock | 16.2857 | 16.2857 | 16.2521 | 16.275 | 57736.0 |
| 2013-02-20 06:45:00 | AAPL | Stock | 16.2721 | 16.2721 | 16.2514 | 16.2518 | 163184.0 |
| 2013-02-20 06:50:00 | AAPL | Stock | 16.2514 | 16.2514 | 16.2318 | 16.2318 | 26488.0 |
| 2013-02-20 06:55:00 | AAPL | Stock | 16.2414 | 16.2454 | 16.2314 | 16.2454 | 25200.0 |
| 2013-02-20 07:00:00 | AAPL | Stock | 16.2329 | 16.2461 | 16.2257 | 16.2321 | 141932.0 |
| 2013-02-20 07:05:00 | AAPL | Stock | 16.2389 | 16.2429 | 16.2304 | 16.2321 | 98000.0 |
| 2013-02-20 07:10:00 | AAPL | Stock | 16.2361 | 16.2361 | 16.1311 | 16.1589 | 410144.0 |
| 2013-02-20 07:15:00 | AAPL | Stock | 16.1586 | 16.1657 | 16.1318 | 16.1643 | 392980.0 |
| 2013-02-20 07:20:00 | AAPL | Stock | 16.1643 | 16.1996 | 16.1518 | 16.1625 | 280000.0 |
| 2013-02-20 07:25:00 | AAPL | Stock | 16.1696 | 16.1886 | 16.1557 | 16.1557 | 287840.0 |
| 2013-02-20 07:30:00 | AAPL | Stock | 16.1611 | 16.1611 | 16.1429 | 16.1518 | 135884.0 |
| 2013-02-20 07:35:00 | AAPL | Stock | 16.1607 | 16.1764 | 16.1521 | 16.1607 | 119896.0 |
| 2013-02-20 07:40:00 | AAPL | Stock | 16.1689 | 16.1779 | 16.1429 | 16.1429 | 279888.0 |
| 2013-02-20 07:45:00 | AAPL | Stock | 16.1396 | 16.1396 | 16.1161 | 16.125 | 398132.0 |
| 2013-02-20 07:50:00 | AAPL | Stock | 16.1396 | 16.2971 | 16.1396 | 16.2964 | 2863756.0 |
| 2013-02-20 07:55:00 | AAPL | Stock | 16.2771 | 16.3343 | 16.2607 | 16.2793 | 856912.0 |
| 2013-02-20 08:00:00 | AAPL | Stock | 16.2682 | 16.327 | 16.1786 | 16.2846 | 871864.0 |
| 2013-02-20 08:05:00 | AAPL | Stock | 16.2964 | 16.4214 | 16.2743 | 16.2861 | 373352.0 |
| 2013-02-20 08:10:00 | AAPL | Stock | 16.2861 | 16.3014 | 16.2679 | 16.2682 | 315448.0 |
| 2013-02-20 08:15:00 | AAPL | Stock | 16.2682 | 16.2821 | 16.2446 | 16.2796 | 392280.0 |
| 2013-02-20 08:20:00 | AAPL | Stock | 16.2854 | 16.3121 | 16.2821 | 16.3036 | 289128.0 |
| 2013-02-20 08:25:00 | AAPL | Stock | 16.2932 | 16.3036 | 16.2857 | 16.2893 | 322476.0 |
| 2013-02-20 08:30:00 | AAPL | Stock | 16.2896 | 16.2896 | 16.2768 | 16.2768 | 113764.0 |
| 2013-02-20 08:35:00 | AAPL | Stock | 16.2754 | 16.2754 | 16.2679 | 16.2693 | 173684.0 |
| 2013-02-20 08:40:00 | AAPL | Stock | 16.2693 | 16.2857 | 16.2679 | 16.2854 | 394408.0 |
| 2013-02-20 08:45:00 | AAPL | Stock | 16.285 | 16.2857 | 16.25 | 16.2575 | 411040.0 |
| 2013-02-20 08:50:00 | AAPL | Stock | 16.2514 | 16.2686 | 16.2489 | 16.2679 | 275828.0 |
| 2013-02-20 08:55:00 | AAPL | Stock | 16.2764 | 16.2764 | 16.2589 | 16.2757 | 70000.0 |
| 2013-02-20 09:00:00 | AAPL | Stock | 16.2693 | 16.3179 | 16.2679 | 16.3157 | 708960.0 |
| 2013-02-20 09:05:00 | AAPL | Stock | 16.3111 | 16.3154 | 16.2929 | 16.3004 | 292600.0 |
| 2013-02-20 09:10:00 | AAPL | Stock | 16.2996 | 16.3093 | 16.2932 | 16.3093 | 276416.0 |
| 2013-02-20 09:15:00 | AAPL | Stock | 16.3 | 16.3075 | 16.2964 | 16.3032 | 183344.0 |
| 2013-02-20 09:20:00 | AAPL | Stock | 16.3036 | 16.3179 | 16.2893 | 16.3071 | 376684.0 |
| 2013-02-20 09:25:00 | AAPL | Stock | 16.3071 | 16.4104 | 16.3039 | 16.3454 | 1103704.0 |
| 2013-02-20 09:30:00 | AAPL | Stock | 16.3461 | 16.3461 | 16.2521 | 16.2855 | 16348892.0 |
| 2013-02-20 09:35:00 | AAPL | Stock | 16.2857 | 16.2886 | 16.2021 | 16.2164 | 16303672.0 |
| 2013-02-20 09:40:00 | AAPL | Stock | 16.218 | 16.2214 | 16.1618 | 16.2088 | 14249088.0 |
| 2013-02-20 09:45:00 | AAPL | Stock | 16.2064 | 16.2171 | 16.1757 | 16.1838 | 7966896.0 |
| 2013-02-20 09:50:00 | AAPL | Stock | 16.1832 | 16.2257 | 16.175 | 16.1836 | 7977760.0 |
| 2013-02-20 09:55:00 | AAPL | Stock | 16.1825 | 16.1825 | 16.1329 | 16.1406 | 14008092.0 |
> showing 50 of 337,713 rows — these rows as CSV