PREVIEW / stock_5min / 2013-02-06
file: by_date/stock_5min/2013/2013-02-06.parquet size: 4.8 MB rows: 323,319 symbols: 3,460
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-06 04:35:00 | AAPL | Stock | 16.3754 | 16.3754 | 16.375 | 16.375 | 5600.0 |
| 2013-02-06 05:05:00 | AAPL | Stock | 16.3307 | 16.3311 | 16.3 | 16.3 | 30800.0 |
| 2013-02-06 05:10:00 | AAPL | Stock | 16.2979 | 16.2979 | 16.2714 | 16.2714 | 55860.0 |
| 2013-02-06 05:20:00 | AAPL | Stock | 16.2779 | 16.2779 | 16.2779 | 16.2779 | 2800.0 |
| 2013-02-06 05:25:00 | AAPL | Stock | 16.2775 | 16.2775 | 16.2643 | 16.2643 | 22960.0 |
| 2013-02-06 05:45:00 | AAPL | Stock | 16.2857 | 16.2857 | 16.2857 | 16.2857 | 2800.0 |
| 2013-02-06 06:00:00 | AAPL | Stock | 16.2964 | 16.2964 | 16.2964 | 16.2964 | 4200.0 |
| 2013-02-06 06:10:00 | AAPL | Stock | 16.3032 | 16.3089 | 16.3032 | 16.3089 | 16240.0 |
| 2013-02-06 06:20:00 | AAPL | Stock | 16.3214 | 16.3307 | 16.3214 | 16.3307 | 8400.0 |
| 2013-02-06 06:25:00 | AAPL | Stock | 16.3536 | 16.3536 | 16.3536 | 16.3536 | 18200.0 |
| 2013-02-06 06:30:00 | AAPL | Stock | 16.3536 | 16.3536 | 16.3432 | 16.3432 | 5600.0 |
| 2013-02-06 06:35:00 | AAPL | Stock | 16.3393 | 16.3393 | 16.3393 | 16.3393 | 2800.0 |
| 2013-02-06 06:40:00 | AAPL | Stock | 16.3307 | 16.3307 | 16.3214 | 16.325 | 8400.0 |
| 2013-02-06 06:45:00 | AAPL | Stock | 16.3354 | 16.3354 | 16.3354 | 16.3354 | 4256.0 |
| 2013-02-06 06:55:00 | AAPL | Stock | 16.325 | 16.325 | 16.325 | 16.325 | 5600.0 |
| 2013-02-06 07:00:00 | AAPL | Stock | 16.3214 | 16.3357 | 16.3214 | 16.3332 | 28000.0 |
| 2013-02-06 07:05:00 | AAPL | Stock | 16.3304 | 16.3393 | 16.3304 | 16.3393 | 33600.0 |
| 2013-02-06 07:10:00 | AAPL | Stock | 16.3425 | 16.3461 | 16.3279 | 16.3279 | 19600.0 |
| 2013-02-06 07:15:00 | AAPL | Stock | 16.3214 | 16.3214 | 16.3025 | 16.3036 | 33488.0 |
| 2013-02-06 07:20:00 | AAPL | Stock | 16.3036 | 16.3082 | 16.2893 | 16.3082 | 41888.0 |
| 2013-02-06 07:25:00 | AAPL | Stock | 16.3004 | 16.3004 | 16.2818 | 16.2857 | 111328.0 |
| 2013-02-06 07:30:00 | AAPL | Stock | 16.2896 | 16.2964 | 16.2861 | 16.2964 | 14560.0 |
| 2013-02-06 07:35:00 | AAPL | Stock | 16.3004 | 16.3168 | 16.2946 | 16.3168 | 50568.0 |
| 2013-02-06 07:40:00 | AAPL | Stock | 16.3207 | 16.3207 | 16.2936 | 16.2936 | 52360.0 |
| 2013-02-06 07:45:00 | AAPL | Stock | 16.2943 | 16.3057 | 16.2932 | 16.2932 | 33040.0 |
| 2013-02-06 07:50:00 | AAPL | Stock | 16.2929 | 16.2929 | 16.2904 | 16.2904 | 8400.0 |
| 2013-02-06 07:55:00 | AAPL | Stock | 16.2811 | 16.315 | 16.2782 | 16.3021 | 56560.0 |
| 2013-02-06 08:00:00 | AAPL | Stock | 16.2871 | 16.3393 | 16.2779 | 16.2839 | 210140.0 |
| 2013-02-06 08:05:00 | AAPL | Stock | 16.2814 | 16.2814 | 16.2082 | 16.2171 | 1061228.0 |
| 2013-02-06 08:10:00 | AAPL | Stock | 16.2221 | 16.2293 | 16.2039 | 16.2225 | 276528.0 |
| 2013-02-06 08:15:00 | AAPL | Stock | 16.2246 | 16.2446 | 16.2246 | 16.2446 | 185332.0 |
| 2013-02-06 08:20:00 | AAPL | Stock | 16.2439 | 16.2693 | 16.2439 | 16.2664 | 161280.0 |
| 2013-02-06 08:25:00 | AAPL | Stock | 16.2607 | 16.2661 | 16.2557 | 16.2661 | 41048.0 |
| 2013-02-06 08:30:00 | AAPL | Stock | 16.2625 | 16.2654 | 16.2429 | 16.25 | 228368.0 |
| 2013-02-06 08:35:00 | AAPL | Stock | 16.25 | 16.2514 | 16.2414 | 16.25 | 35196.0 |
| 2013-02-06 08:40:00 | AAPL | Stock | 16.2482 | 16.2532 | 16.2343 | 16.2411 | 339612.0 |
| 2013-02-06 08:45:00 | AAPL | Stock | 16.2493 | 16.2504 | 16.2404 | 16.2482 | 66500.0 |
| 2013-02-06 08:50:00 | AAPL | Stock | 16.2421 | 16.2679 | 16.2421 | 16.2679 | 158592.0 |
| 2013-02-06 08:55:00 | AAPL | Stock | 16.2679 | 16.3057 | 16.2679 | 16.3057 | 415968.0 |
| 2013-02-06 09:00:00 | AAPL | Stock | 16.3054 | 16.3068 | 16.2843 | 16.2857 | 227948.0 |
| 2013-02-06 09:05:00 | AAPL | Stock | 16.2768 | 16.2786 | 16.2611 | 16.2771 | 149772.0 |
| 2013-02-06 09:10:00 | AAPL | Stock | 16.2811 | 16.2857 | 16.2679 | 16.2696 | 250432.0 |
| 2013-02-06 09:15:00 | AAPL | Stock | 16.2825 | 16.2836 | 16.2679 | 16.2754 | 296520.0 |
| 2013-02-06 09:20:00 | AAPL | Stock | 16.2839 | 16.3179 | 16.2796 | 16.3125 | 252952.0 |
| 2013-02-06 09:25:00 | AAPL | Stock | 16.3125 | 16.3189 | 16.2957 | 16.3182 | 473200.0 |
| 2013-02-06 09:30:00 | AAPL | Stock | 16.3182 | 16.3893 | 16.2771 | 16.2971 | 18632544.0 |
| 2013-02-06 09:35:00 | AAPL | Stock | 16.2971 | 16.4193 | 16.2771 | 16.3911 | 15271844.0 |
| 2013-02-06 09:40:00 | AAPL | Stock | 16.3879 | 16.3896 | 16.2857 | 16.2911 | 10324888.0 |
| 2013-02-06 09:45:00 | AAPL | Stock | 16.2893 | 16.3307 | 16.2629 | 16.2964 | 9328900.0 |
| 2013-02-06 09:50:00 | AAPL | Stock | 16.2911 | 16.3107 | 16.2375 | 16.2491 | 10308620.0 |
> showing 50 of 323,319 rows — these rows as CSV