PREVIEW / stock_5min / 2014-03-25
file: by_date/stock_5min/2014/2014-03-25.parquet size: 5.5 MB rows: 361,215 symbols: 3,522
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-03-25 04:10:00 | AAPL | Stock | 19.2857 | 19.2857 | 19.2857 | 19.2857 | 2800.0 |
| 2014-03-25 04:40:00 | AAPL | Stock | 19.3039 | 19.3039 | 19.3039 | 19.3039 | 2800.0 |
| 2014-03-25 05:15:00 | AAPL | Stock | 19.2857 | 19.2857 | 19.2857 | 19.2857 | 2800.0 |
| 2014-03-25 06:00:00 | AAPL | Stock | 19.3021 | 19.3021 | 19.3021 | 19.3021 | 2800.0 |
| 2014-03-25 06:35:00 | AAPL | Stock | 19.3136 | 19.3136 | 19.3136 | 19.3136 | 8400.0 |
| 2014-03-25 06:40:00 | AAPL | Stock | 19.3029 | 19.3029 | 19.3029 | 19.3029 | 14000.0 |
| 2014-03-25 06:55:00 | AAPL | Stock | 19.2929 | 19.2929 | 19.2786 | 19.2786 | 14056.0 |
| 2014-03-25 07:00:00 | AAPL | Stock | 19.2804 | 19.2818 | 19.2804 | 19.2818 | 10920.0 |
| 2014-03-25 07:10:00 | AAPL | Stock | 19.2804 | 19.2839 | 19.2804 | 19.2829 | 28980.0 |
| 2014-03-25 07:20:00 | AAPL | Stock | 19.2804 | 19.2804 | 19.2804 | 19.2804 | 4984.0 |
| 2014-03-25 07:25:00 | AAPL | Stock | 19.2943 | 19.3082 | 19.2882 | 19.3082 | 49840.0 |
| 2014-03-25 07:35:00 | AAPL | Stock | 19.3079 | 19.3125 | 19.3036 | 19.3079 | 20860.0 |
| 2014-03-25 07:40:00 | AAPL | Stock | 19.3182 | 19.3182 | 19.3071 | 19.3071 | 11200.0 |
| 2014-03-25 07:50:00 | AAPL | Stock | 19.3054 | 19.3304 | 19.3054 | 19.3304 | 76300.0 |
| 2014-03-25 07:55:00 | AAPL | Stock | 19.3311 | 19.35 | 19.3311 | 19.3343 | 146020.0 |
| 2014-03-25 08:00:00 | AAPL | Stock | 19.3304 | 19.3304 | 19.2804 | 19.3221 | 89656.0 |
| 2014-03-25 08:05:00 | AAPL | Stock | 19.33 | 19.33 | 19.3068 | 19.3068 | 108024.0 |
| 2014-03-25 08:10:00 | AAPL | Stock | 19.3036 | 19.3125 | 19.2946 | 19.3036 | 56644.0 |
| 2014-03-25 08:15:00 | AAPL | Stock | 19.3107 | 19.3107 | 19.3036 | 19.3036 | 53508.0 |
| 2014-03-25 08:20:00 | AAPL | Stock | 19.3036 | 19.3036 | 19.2611 | 19.2611 | 146944.0 |
| 2014-03-25 08:25:00 | AAPL | Stock | 19.2836 | 19.2857 | 19.2679 | 19.2754 | 50316.0 |
| 2014-03-25 08:30:00 | AAPL | Stock | 19.275 | 19.3093 | 19.275 | 19.3093 | 162932.0 |
| 2014-03-25 08:35:00 | AAPL | Stock | 19.3075 | 19.3139 | 19.2996 | 19.2996 | 103516.0 |
| 2014-03-25 08:40:00 | AAPL | Stock | 19.3075 | 19.3075 | 19.2968 | 19.3036 | 53424.0 |
| 2014-03-25 08:45:00 | AAPL | Stock | 19.3079 | 19.3082 | 19.2932 | 19.2932 | 84952.0 |
| 2014-03-25 08:50:00 | AAPL | Stock | 19.3071 | 19.3143 | 19.3061 | 19.3143 | 67564.0 |
| 2014-03-25 08:55:00 | AAPL | Stock | 19.3189 | 19.3189 | 19.3079 | 19.3093 | 85708.0 |
| 2014-03-25 09:00:00 | AAPL | Stock | 19.3089 | 19.3146 | 19.3089 | 19.31 | 45500.0 |
| 2014-03-25 09:05:00 | AAPL | Stock | 19.3093 | 19.3196 | 19.3089 | 19.3196 | 81200.0 |
| 2014-03-25 09:10:00 | AAPL | Stock | 19.3179 | 19.3357 | 19.3179 | 19.3357 | 187600.0 |
| 2014-03-25 09:15:00 | AAPL | Stock | 19.3368 | 19.3482 | 19.3368 | 19.3393 | 118160.0 |
| 2014-03-25 09:20:00 | AAPL | Stock | 19.3371 | 19.3567 | 19.3339 | 19.3567 | 98532.0 |
| 2014-03-25 09:25:00 | AAPL | Stock | 19.3504 | 19.3593 | 19.3254 | 19.3311 | 322588.0 |
| 2014-03-25 09:30:00 | AAPL | Stock | 19.3393 | 19.3711 | 19.3004 | 19.3064 | 12472404.0 |
| 2014-03-25 09:35:00 | AAPL | Stock | 19.3079 | 19.3571 | 19.2954 | 19.3332 | 5760552.0 |
| 2014-03-25 09:40:00 | AAPL | Stock | 19.3332 | 19.3629 | 19.3146 | 19.3246 | 5211304.0 |
| 2014-03-25 09:45:00 | AAPL | Stock | 19.325 | 19.3582 | 19.3246 | 19.3579 | 3257940.0 |
| 2014-03-25 09:50:00 | AAPL | Stock | 19.3554 | 19.375 | 19.3511 | 19.3602 | 6007344.0 |
| 2014-03-25 09:55:00 | AAPL | Stock | 19.3632 | 19.3882 | 19.3554 | 19.3754 | 5528040.0 |
| 2014-03-25 10:00:00 | AAPL | Stock | 19.3771 | 19.4075 | 19.3771 | 19.3983 | 6637204.0 |
| 2014-03-25 10:05:00 | AAPL | Stock | 19.3964 | 19.4143 | 19.3857 | 19.4093 | 4647496.0 |
| 2014-03-25 10:10:00 | AAPL | Stock | 19.405 | 19.4107 | 19.3771 | 19.4061 | 3163692.0 |
| 2014-03-25 10:15:00 | AAPL | Stock | 19.405 | 19.425 | 19.4007 | 19.425 | 3547460.0 |
| 2014-03-25 10:20:00 | AAPL | Stock | 19.4257 | 19.4286 | 19.3868 | 19.3964 | 4611012.0 |
| 2014-03-25 10:25:00 | AAPL | Stock | 19.3996 | 19.4071 | 19.3771 | 19.3817 | 2417576.0 |
| 2014-03-25 10:30:00 | AAPL | Stock | 19.3836 | 19.3896 | 19.3579 | 19.3657 | 2928464.0 |
| 2014-03-25 10:35:00 | AAPL | Stock | 19.3661 | 19.3661 | 19.3307 | 19.3475 | 3886624.0 |
| 2014-03-25 10:40:00 | AAPL | Stock | 19.3504 | 19.3736 | 19.3477 | 19.3722 | 3195836.0 |
| 2014-03-25 10:45:00 | AAPL | Stock | 19.3736 | 19.38 | 19.3393 | 19.3486 | 3165876.0 |
| 2014-03-25 10:50:00 | AAPL | Stock | 19.3475 | 19.3532 | 19.3196 | 19.3393 | 3291680.0 |
> showing 50 of 361,215 rows — these rows as CSV