PREVIEW / stock_5min / 2010-07-29
file: by_date/stock_5min/2010/2010-07-29.parquet size: 4.7 MB rows: 319,651 symbols: 3,452
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-29 06:00:00 | AAPL | Stock | 9.3446 | 9.3482 | 9.3446 | 9.3482 | 15120.0 |
| 2010-07-29 06:05:00 | AAPL | Stock | 9.3636 | 9.3636 | 9.3636 | 9.3636 | 2800.0 |
| 2010-07-29 06:40:00 | AAPL | Stock | 9.3518 | 9.3518 | 9.3518 | 9.3518 | 2800.0 |
| 2010-07-29 06:55:00 | AAPL | Stock | 9.3393 | 9.3393 | 9.3393 | 9.3393 | 2800.0 |
| 2010-07-29 07:00:00 | AAPL | Stock | 9.3589 | 9.3589 | 9.3589 | 9.3589 | 2800.0 |
| 2010-07-29 07:05:00 | AAPL | Stock | 9.3479 | 9.3479 | 9.3479 | 9.3479 | 5600.0 |
| 2010-07-29 07:15:00 | AAPL | Stock | 9.3557 | 9.3557 | 9.345 | 9.3518 | 19600.0 |
| 2010-07-29 07:20:00 | AAPL | Stock | 9.3432 | 9.3432 | 9.3393 | 9.3396 | 53536.0 |
| 2010-07-29 07:25:00 | AAPL | Stock | 9.34 | 9.34 | 9.3304 | 9.3321 | 39200.0 |
| 2010-07-29 07:30:00 | AAPL | Stock | 9.325 | 9.3268 | 9.325 | 9.3268 | 16800.0 |
| 2010-07-29 07:40:00 | AAPL | Stock | 9.3364 | 9.3471 | 9.3325 | 9.3464 | 246400.0 |
| 2010-07-29 07:45:00 | AAPL | Stock | 9.3389 | 9.3389 | 9.3382 | 9.3382 | 5600.0 |
| 2010-07-29 07:50:00 | AAPL | Stock | 9.3371 | 9.3371 | 9.3371 | 9.3371 | 11200.0 |
| 2010-07-29 07:55:00 | AAPL | Stock | 9.3286 | 9.3325 | 9.325 | 9.325 | 163100.0 |
| 2010-07-29 08:00:00 | AAPL | Stock | 9.3296 | 9.3343 | 9.3254 | 9.3304 | 195272.0 |
| 2010-07-29 08:05:00 | AAPL | Stock | 9.3289 | 9.3289 | 9.3161 | 9.3179 | 46760.0 |
| 2010-07-29 08:10:00 | AAPL | Stock | 9.3175 | 9.325 | 9.3089 | 9.3214 | 111608.0 |
| 2010-07-29 08:15:00 | AAPL | Stock | 9.3207 | 9.3214 | 9.3182 | 9.3182 | 20440.0 |
| 2010-07-29 08:20:00 | AAPL | Stock | 9.3182 | 9.3182 | 9.3086 | 9.3125 | 98252.0 |
| 2010-07-29 08:25:00 | AAPL | Stock | 9.3125 | 9.3211 | 9.305 | 9.3179 | 118272.0 |
| 2010-07-29 08:30:00 | AAPL | Stock | 9.3207 | 9.3286 | 9.3114 | 9.3161 | 375592.0 |
| 2010-07-29 08:35:00 | AAPL | Stock | 9.3196 | 9.3204 | 9.3107 | 9.3186 | 206780.0 |
| 2010-07-29 08:40:00 | AAPL | Stock | 9.3196 | 9.3211 | 9.3143 | 9.3164 | 353640.0 |
| 2010-07-29 08:45:00 | AAPL | Stock | 9.3161 | 9.3207 | 9.3129 | 9.3182 | 123452.0 |
| 2010-07-29 08:50:00 | AAPL | Stock | 9.3179 | 9.3389 | 9.3175 | 9.3296 | 752780.0 |
| 2010-07-29 08:55:00 | AAPL | Stock | 9.33 | 9.3357 | 9.3214 | 9.325 | 303324.0 |
| 2010-07-29 09:00:00 | AAPL | Stock | 9.3239 | 9.3279 | 9.315 | 9.3179 | 433692.0 |
| 2010-07-29 09:05:00 | AAPL | Stock | 9.3189 | 9.3211 | 9.3143 | 9.3143 | 100296.0 |
| 2010-07-29 09:10:00 | AAPL | Stock | 9.315 | 9.3221 | 9.3146 | 9.3196 | 248388.0 |
| 2010-07-29 09:15:00 | AAPL | Stock | 9.32 | 9.3229 | 9.3171 | 9.3171 | 597100.0 |
| 2010-07-29 09:20:00 | AAPL | Stock | 9.3211 | 9.3243 | 9.3175 | 9.3214 | 221200.0 |
| 2010-07-29 09:25:00 | AAPL | Stock | 9.3214 | 9.3232 | 9.3036 | 9.3093 | 710976.0 |
| 2010-07-29 09:30:00 | AAPL | Stock | 9.3111 | 9.3207 | 9.2679 | 9.2882 | 26539268.0 |
| 2010-07-29 09:35:00 | AAPL | Stock | 9.2882 | 9.3718 | 9.2843 | 9.3639 | 23947196.0 |
| 2010-07-29 09:40:00 | AAPL | Stock | 9.3621 | 9.3714 | 9.3443 | 9.355 | 12734680.0 |
| 2010-07-29 09:45:00 | AAPL | Stock | 9.3539 | 9.3804 | 9.3516 | 9.365 | 19030004.0 |
| 2010-07-29 09:50:00 | AAPL | Stock | 9.365 | 9.3714 | 9.3457 | 9.3589 | 9966964.0 |
| 2010-07-29 09:55:00 | AAPL | Stock | 9.3582 | 9.3582 | 9.3396 | 9.3511 | 6749652.0 |
| 2010-07-29 10:00:00 | AAPL | Stock | 9.3511 | 9.3539 | 9.3143 | 9.3218 | 10189928.0 |
| 2010-07-29 10:05:00 | AAPL | Stock | 9.3186 | 9.3393 | 9.3168 | 9.3387 | 8710184.0 |
| 2010-07-29 10:10:00 | AAPL | Stock | 9.3391 | 9.3471 | 9.3243 | 9.3243 | 7385420.0 |
| 2010-07-29 10:15:00 | AAPL | Stock | 9.3239 | 9.3446 | 9.3218 | 9.3371 | 4745244.0 |
| 2010-07-29 10:20:00 | AAPL | Stock | 9.3343 | 9.3364 | 9.3132 | 9.3311 | 8053696.0 |
| 2010-07-29 10:25:00 | AAPL | Stock | 9.3305 | 9.3354 | 9.3143 | 9.3236 | 5943560.0 |
| 2010-07-29 10:30:00 | AAPL | Stock | 9.3239 | 9.3296 | 9.3082 | 9.3275 | 5706904.0 |
| 2010-07-29 10:35:00 | AAPL | Stock | 9.3279 | 9.33 | 9.3007 | 9.3025 | 5039244.0 |
| 2010-07-29 10:40:00 | AAPL | Stock | 9.3013 | 9.3071 | 9.2907 | 9.3 | 5926816.0 |
| 2010-07-29 10:45:00 | AAPL | Stock | 9.3 | 9.3007 | 9.2871 | 9.2918 | 5525884.0 |
| 2010-07-29 10:50:00 | AAPL | Stock | 9.2918 | 9.3014 | 9.2875 | 9.2946 | 5552036.0 |
| 2010-07-29 10:55:00 | AAPL | Stock | 9.2939 | 9.325 | 9.2882 | 9.2893 | 4683840.0 |
> showing 50 of 319,651 rows — these rows as CSV