PREVIEW / stock_5min / 2014-04-03
file: by_date/stock_5min/2014/2014-04-03.parquet size: 5.4 MB rows: 361,564 symbols: 3,534
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-03 06:20:00 | AAPL | Stock | 19.3929 | 19.3929 | 19.3929 | 19.3929 | 2800.0 |
| 2014-04-03 06:50:00 | AAPL | Stock | 19.3918 | 19.3918 | 19.3918 | 19.3918 | 2800.0 |
| 2014-04-03 07:10:00 | AAPL | Stock | 19.3779 | 19.3779 | 19.3779 | 19.3779 | 2800.0 |
| 2014-04-03 07:35:00 | AAPL | Stock | 19.3682 | 19.3682 | 19.295 | 19.295 | 55748.0 |
| 2014-04-03 07:40:00 | AAPL | Stock | 19.3389 | 19.3389 | 19.3364 | 19.3364 | 5600.0 |
| 2014-04-03 07:50:00 | AAPL | Stock | 19.3475 | 19.3475 | 19.3475 | 19.3475 | 2800.0 |
| 2014-04-03 07:55:00 | AAPL | Stock | 19.3568 | 19.3568 | 19.3568 | 19.3568 | 2800.0 |
| 2014-04-03 08:00:00 | AAPL | Stock | 19.3464 | 19.375 | 19.3464 | 19.3536 | 37828.0 |
| 2014-04-03 08:05:00 | AAPL | Stock | 19.3529 | 19.3529 | 19.3214 | 19.3214 | 110040.0 |
| 2014-04-03 08:10:00 | AAPL | Stock | 19.3393 | 19.3464 | 19.3236 | 19.3464 | 34440.0 |
| 2014-04-03 08:15:00 | AAPL | Stock | 19.3236 | 19.325 | 19.3236 | 19.325 | 8400.0 |
| 2014-04-03 08:20:00 | AAPL | Stock | 19.325 | 19.3293 | 19.3232 | 19.325 | 340900.0 |
| 2014-04-03 08:25:00 | AAPL | Stock | 19.325 | 19.325 | 19.3214 | 19.3214 | 320348.0 |
| 2014-04-03 08:30:00 | AAPL | Stock | 19.3168 | 19.3246 | 19.3143 | 19.3161 | 46228.0 |
| 2014-04-03 08:35:00 | AAPL | Stock | 19.3232 | 19.3411 | 19.3232 | 19.3411 | 47460.0 |
| 2014-04-03 08:40:00 | AAPL | Stock | 19.3321 | 19.3389 | 19.3321 | 19.3389 | 17220.0 |
| 2014-04-03 08:50:00 | AAPL | Stock | 19.3232 | 19.3232 | 19.3225 | 19.3225 | 16800.0 |
| 2014-04-03 08:55:00 | AAPL | Stock | 19.3225 | 19.3225 | 19.32 | 19.32 | 34216.0 |
| 2014-04-03 09:00:00 | AAPL | Stock | 19.3246 | 19.3321 | 19.3214 | 19.33 | 53368.0 |
| 2014-04-03 09:05:00 | AAPL | Stock | 19.33 | 19.3321 | 19.3218 | 19.3218 | 11200.0 |
| 2014-04-03 09:10:00 | AAPL | Stock | 19.3207 | 19.3214 | 19.3207 | 19.3214 | 14000.0 |
| 2014-04-03 09:15:00 | AAPL | Stock | 19.325 | 19.3264 | 19.325 | 19.325 | 14000.0 |
| 2014-04-03 09:20:00 | AAPL | Stock | 19.33 | 19.33 | 19.33 | 19.33 | 4088.0 |
| 2014-04-03 09:25:00 | AAPL | Stock | 19.3411 | 19.3482 | 19.3271 | 19.3304 | 142772.0 |
| 2014-04-03 09:30:00 | AAPL | Stock | 19.3354 | 19.3571 | 19.3075 | 19.3186 | 6593692.0 |
| 2014-04-03 09:35:00 | AAPL | Stock | 19.3189 | 19.375 | 19.3164 | 19.3332 | 4309088.0 |
| 2014-04-03 09:40:00 | AAPL | Stock | 19.3289 | 19.3514 | 19.3282 | 19.3429 | 1827000.0 |
| 2014-04-03 09:45:00 | AAPL | Stock | 19.34 | 19.3718 | 19.34 | 19.3568 | 2711128.0 |
| 2014-04-03 09:50:00 | AAPL | Stock | 19.3525 | 19.3625 | 19.3307 | 19.3432 | 2742796.0 |
| 2014-04-03 09:55:00 | AAPL | Stock | 19.3464 | 19.3668 | 19.3425 | 19.3668 | 1651580.0 |
| 2014-04-03 10:00:00 | AAPL | Stock | 19.3657 | 19.3661 | 19.3357 | 19.3425 | 2143512.0 |
| 2014-04-03 10:05:00 | AAPL | Stock | 19.3486 | 19.3486 | 19.3157 | 19.3307 | 2420796.0 |
| 2014-04-03 10:10:00 | AAPL | Stock | 19.3307 | 19.3379 | 19.3093 | 19.3143 | 1615488.0 |
| 2014-04-03 10:15:00 | AAPL | Stock | 19.3129 | 19.3136 | 19.2796 | 19.3025 | 4218704.0 |
| 2014-04-03 10:20:00 | AAPL | Stock | 19.3011 | 19.3261 | 19.2997 | 19.3089 | 2261308.0 |
| 2014-04-03 10:25:00 | AAPL | Stock | 19.3082 | 19.3186 | 19.2857 | 19.2904 | 1128736.0 |
| 2014-04-03 10:30:00 | AAPL | Stock | 19.2929 | 19.3214 | 19.2929 | 19.3016 | 1500184.0 |
| 2014-04-03 10:35:00 | AAPL | Stock | 19.2993 | 19.3107 | 19.2814 | 19.2857 | 2136904.0 |
| 2014-04-03 10:40:00 | AAPL | Stock | 19.2869 | 19.2974 | 19.275 | 19.2827 | 1556660.0 |
| 2014-04-03 10:45:00 | AAPL | Stock | 19.2846 | 19.3054 | 19.2814 | 19.301 | 2875936.0 |
| 2014-04-03 10:50:00 | AAPL | Stock | 19.3046 | 19.3143 | 19.2875 | 19.2875 | 2869020.0 |
| 2014-04-03 10:55:00 | AAPL | Stock | 19.2911 | 19.2971 | 19.2789 | 19.2846 | 3355296.0 |
| 2014-04-03 11:00:00 | AAPL | Stock | 19.2814 | 19.3011 | 19.2814 | 19.2964 | 3099992.0 |
| 2014-04-03 11:05:00 | AAPL | Stock | 19.2968 | 19.3 | 19.2886 | 19.2939 | 1021020.0 |
| 2014-04-03 11:10:00 | AAPL | Stock | 19.2932 | 19.3011 | 19.2804 | 19.2867 | 812728.0 |
| 2014-04-03 11:15:00 | AAPL | Stock | 19.2857 | 19.2964 | 19.2786 | 19.2925 | 1079120.0 |
| 2014-04-03 11:20:00 | AAPL | Stock | 19.2936 | 19.2936 | 19.2818 | 19.2821 | 732452.0 |
| 2014-04-03 11:25:00 | AAPL | Stock | 19.2814 | 19.2925 | 19.2786 | 19.2811 | 1088024.0 |
| 2014-04-03 11:30:00 | AAPL | Stock | 19.2818 | 19.2818 | 19.2507 | 19.2625 | 3116624.0 |
| 2014-04-03 11:35:00 | AAPL | Stock | 19.2621 | 19.2756 | 19.26 | 19.2756 | 1225896.0 |
> showing 50 of 361,564 rows — these rows as CSV