PREVIEW / stock_5min / 2012-10-31
file: by_date/stock_5min/2012/2012-10-31.parquet size: 4.8 MB rows: 321,367 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 |
|---|---|---|---|---|---|---|---|
| 2012-10-31 04:35:00 | AAPL | Stock | 21.5357 | 21.5357 | 21.5357 | 21.5357 | 5600.0 |
| 2012-10-31 04:45:00 | AAPL | Stock | 21.5357 | 21.5357 | 21.5357 | 21.5357 | 2856.0 |
| 2012-10-31 05:30:00 | AAPL | Stock | 21.5482 | 21.5482 | 21.5482 | 21.5482 | 2800.0 |
| 2012-10-31 05:40:00 | AAPL | Stock | 21.5689 | 21.5689 | 21.5689 | 21.5689 | 10080.0 |
| 2012-10-31 06:05:00 | AAPL | Stock | 21.5482 | 21.5482 | 21.5157 | 21.5157 | 11900.0 |
| 2012-10-31 06:25:00 | AAPL | Stock | 21.5357 | 21.5357 | 21.5357 | 21.5357 | 2800.0 |
| 2012-10-31 06:35:00 | AAPL | Stock | 21.5536 | 21.5536 | 21.5536 | 21.5536 | 14000.0 |
| 2012-10-31 06:55:00 | AAPL | Stock | 21.5536 | 21.5536 | 21.5536 | 21.5536 | 3164.0 |
| 2012-10-31 07:00:00 | AAPL | Stock | 21.5289 | 21.5289 | 21.4643 | 21.4643 | 61908.0 |
| 2012-10-31 07:05:00 | AAPL | Stock | 21.4643 | 21.4643 | 21.3754 | 21.3754 | 140560.0 |
| 2012-10-31 07:10:00 | AAPL | Stock | 21.3932 | 21.4279 | 21.3846 | 21.3968 | 191436.0 |
| 2012-10-31 07:15:00 | AAPL | Stock | 21.4143 | 21.4375 | 21.4143 | 21.4286 | 111972.0 |
| 2012-10-31 07:20:00 | AAPL | Stock | 21.4289 | 21.4289 | 21.3929 | 21.4196 | 86912.0 |
| 2012-10-31 07:25:00 | AAPL | Stock | 21.4193 | 21.4643 | 21.4193 | 21.4286 | 171052.0 |
| 2012-10-31 07:30:00 | AAPL | Stock | 21.4289 | 21.4289 | 21.4289 | 21.4289 | 2800.0 |
| 2012-10-31 07:35:00 | AAPL | Stock | 21.4586 | 21.4586 | 21.4586 | 21.4586 | 2800.0 |
| 2012-10-31 07:40:00 | AAPL | Stock | 21.45 | 21.45 | 21.4286 | 21.4286 | 8400.0 |
| 2012-10-31 07:45:00 | AAPL | Stock | 21.4232 | 21.4232 | 21.4232 | 21.4232 | 4984.0 |
| 2012-10-31 07:50:00 | AAPL | Stock | 21.4036 | 21.4196 | 21.3929 | 21.4 | 164528.0 |
| 2012-10-31 07:55:00 | AAPL | Stock | 21.4 | 21.4232 | 21.4 | 21.4179 | 73444.0 |
| 2012-10-31 08:00:00 | AAPL | Stock | 21.4161 | 21.4232 | 21.3696 | 21.3839 | 313740.0 |
| 2012-10-31 08:05:00 | AAPL | Stock | 21.3768 | 21.3893 | 21.3571 | 21.3575 | 271964.0 |
| 2012-10-31 08:10:00 | AAPL | Stock | 21.3571 | 21.3571 | 21.2975 | 21.3218 | 285040.0 |
| 2012-10-31 08:15:00 | AAPL | Stock | 21.3289 | 21.365 | 21.3275 | 21.3482 | 218736.0 |
| 2012-10-31 08:20:00 | AAPL | Stock | 21.3432 | 21.3461 | 21.3268 | 21.3268 | 84476.0 |
| 2012-10-31 08:25:00 | AAPL | Stock | 21.3275 | 21.3386 | 21.2982 | 21.3089 | 121296.0 |
| 2012-10-31 08:30:00 | AAPL | Stock | 21.3036 | 21.3275 | 21.2946 | 21.3082 | 391580.0 |
| 2012-10-31 08:35:00 | AAPL | Stock | 21.3071 | 21.3179 | 21.3071 | 21.3104 | 134400.0 |
| 2012-10-31 08:40:00 | AAPL | Stock | 21.3089 | 21.3132 | 21.2921 | 21.3054 | 157192.0 |
| 2012-10-31 08:45:00 | AAPL | Stock | 21.3071 | 21.3279 | 21.3036 | 21.3154 | 514360.0 |
| 2012-10-31 08:50:00 | AAPL | Stock | 21.3204 | 21.33 | 21.3161 | 21.3268 | 98000.0 |
| 2012-10-31 08:55:00 | AAPL | Stock | 21.3286 | 21.3318 | 21.3214 | 21.3214 | 424984.0 |
| 2012-10-31 09:00:00 | AAPL | Stock | 21.325 | 21.3318 | 21.325 | 21.33 | 88480.0 |
| 2012-10-31 09:05:00 | AAPL | Stock | 21.3311 | 21.3343 | 21.3221 | 21.3221 | 135352.0 |
| 2012-10-31 09:10:00 | AAPL | Stock | 21.3232 | 21.325 | 21.3146 | 21.3214 | 263172.0 |
| 2012-10-31 09:15:00 | AAPL | Stock | 21.3296 | 21.3296 | 21.3143 | 21.3225 | 103600.0 |
| 2012-10-31 09:20:00 | AAPL | Stock | 21.3225 | 21.3225 | 21.3154 | 21.3214 | 101948.0 |
| 2012-10-31 09:25:00 | AAPL | Stock | 21.3204 | 21.3214 | 21.2211 | 21.2211 | 715260.0 |
| 2012-10-31 09:30:00 | AAPL | Stock | 21.2211 | 21.25 | 21.1114 | 21.1882 | 26923456.0 |
| 2012-10-31 09:35:00 | AAPL | Stock | 21.1882 | 21.1957 | 21.0429 | 21.1004 | 24280928.0 |
| 2012-10-31 09:40:00 | AAPL | Stock | 21.0978 | 21.1186 | 20.9893 | 21.0071 | 16828140.0 |
| 2012-10-31 09:45:00 | AAPL | Stock | 21.0082 | 21.1429 | 20.9991 | 21.1346 | 18907672.0 |
| 2012-10-31 09:50:00 | AAPL | Stock | 21.1332 | 21.2375 | 21.1271 | 21.1721 | 17617740.0 |
| 2012-10-31 09:55:00 | AAPL | Stock | 21.1714 | 21.1857 | 21.0939 | 21.1246 | 9486428.0 |
| 2012-10-31 10:00:00 | AAPL | Stock | 21.1246 | 21.1868 | 21.1218 | 21.13 | 8805272.0 |
| 2012-10-31 10:05:00 | AAPL | Stock | 21.1306 | 21.1582 | 21.1007 | 21.1207 | 6100976.0 |
| 2012-10-31 10:10:00 | AAPL | Stock | 21.1248 | 21.1325 | 21.0193 | 21.035 | 11508616.0 |
| 2012-10-31 10:15:00 | AAPL | Stock | 21.0299 | 21.0854 | 21.0286 | 21.0425 | 8878548.0 |
| 2012-10-31 10:20:00 | AAPL | Stock | 21.0457 | 21.13 | 21.0357 | 21.1232 | 6112344.0 |
| 2012-10-31 10:25:00 | AAPL | Stock | 21.13 | 21.2014 | 21.1168 | 21.1964 | 6224792.0 |
> showing 50 of 321,367 rows — these rows as CSV