PREVIEW / stock_1min / 2013-03-27
file: by_date/stock_1min/2013/2013-03-27.parquet size: 12.9 MB rows: 954,280 symbols: 2,812
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-03-27 05:31:00 | AAPL | Stock | 16.4821 | 16.4821 | 16.4821 | 16.4821 | 2800.0 |
| 2013-03-27 05:43:00 | AAPL | Stock | 16.4332 | 16.4332 | 16.4332 | 16.4332 | 26460.0 |
| 2013-03-27 06:34:00 | AAPL | Stock | 16.445 | 16.445 | 16.445 | 16.445 | 2800.0 |
| 2013-03-27 06:37:00 | AAPL | Stock | 16.445 | 16.445 | 16.445 | 16.445 | 9072.0 |
| 2013-03-27 06:40:00 | AAPL | Stock | 16.4293 | 16.4293 | 16.4286 | 16.4286 | 18060.0 |
| 2013-03-27 06:56:00 | AAPL | Stock | 16.4271 | 16.4271 | 16.4271 | 16.4271 | 11200.0 |
| 2013-03-27 07:03:00 | AAPL | Stock | 16.4179 | 16.4179 | 16.4179 | 16.4179 | 2800.0 |
| 2013-03-27 07:08:00 | AAPL | Stock | 16.4279 | 16.4286 | 16.4279 | 16.4286 | 30800.0 |
| 2013-03-27 07:10:00 | AAPL | Stock | 16.4125 | 16.4125 | 16.4125 | 16.4125 | 2800.0 |
| 2013-03-27 07:18:00 | AAPL | Stock | 16.4143 | 16.4143 | 16.4143 | 16.4143 | 5600.0 |
| 2013-03-27 07:19:00 | AAPL | Stock | 16.4025 | 16.4025 | 16.4018 | 16.4018 | 5600.0 |
| 2013-03-27 07:21:00 | AAPL | Stock | 16.3975 | 16.3975 | 16.3975 | 16.3975 | 5600.0 |
| 2013-03-27 07:23:00 | AAPL | Stock | 16.3986 | 16.3986 | 16.3986 | 16.3986 | 2800.0 |
| 2013-03-27 07:24:00 | AAPL | Stock | 16.3932 | 16.3932 | 16.3929 | 16.3929 | 38920.0 |
| 2013-03-27 07:28:00 | AAPL | Stock | 16.3814 | 16.3814 | 16.3643 | 16.3643 | 60732.0 |
| 2013-03-27 07:29:00 | AAPL | Stock | 16.3646 | 16.3646 | 16.3571 | 16.3571 | 32676.0 |
| 2013-03-27 07:30:00 | AAPL | Stock | 16.3346 | 16.3346 | 16.3343 | 16.3343 | 15176.0 |
| 2013-03-27 07:33:00 | AAPL | Stock | 16.3482 | 16.3482 | 16.3457 | 16.3457 | 16800.0 |
| 2013-03-27 07:34:00 | AAPL | Stock | 16.3375 | 16.3375 | 16.3293 | 16.3293 | 61320.0 |
| 2013-03-27 07:35:00 | AAPL | Stock | 16.3336 | 16.3336 | 16.3075 | 16.3075 | 50400.0 |
| 2013-03-27 07:36:00 | AAPL | Stock | 16.3179 | 16.3336 | 16.3136 | 16.3336 | 19600.0 |
| 2013-03-27 07:37:00 | AAPL | Stock | 16.3339 | 16.3357 | 16.3336 | 16.3336 | 53088.0 |
| 2013-03-27 07:38:00 | AAPL | Stock | 16.335 | 16.335 | 16.3336 | 16.3336 | 13468.0 |
| 2013-03-27 07:40:00 | AAPL | Stock | 16.3396 | 16.3396 | 16.3214 | 16.3214 | 28000.0 |
| 2013-03-27 07:41:00 | AAPL | Stock | 16.3446 | 16.3521 | 16.3446 | 16.3521 | 11200.0 |
| 2013-03-27 07:42:00 | AAPL | Stock | 16.3636 | 16.3636 | 16.3632 | 16.3636 | 8400.0 |
| 2013-03-27 07:43:00 | AAPL | Stock | 16.3521 | 16.3521 | 16.3521 | 16.3521 | 3080.0 |
| 2013-03-27 07:45:00 | AAPL | Stock | 16.3582 | 16.3582 | 16.325 | 16.325 | 82460.0 |
| 2013-03-27 07:46:00 | AAPL | Stock | 16.3236 | 16.3236 | 16.3232 | 16.3232 | 11200.0 |
| 2013-03-27 07:50:00 | AAPL | Stock | 16.3357 | 16.3357 | 16.3357 | 16.3357 | 2800.0 |
| 2013-03-27 07:52:00 | AAPL | Stock | 16.3546 | 16.3571 | 16.35 | 16.35 | 15400.0 |
| 2013-03-27 07:55:00 | AAPL | Stock | 16.3586 | 16.3661 | 16.3582 | 16.3661 | 8400.0 |
| 2013-03-27 07:56:00 | AAPL | Stock | 16.3582 | 16.3582 | 16.3582 | 16.3582 | 2800.0 |
| 2013-03-27 07:57:00 | AAPL | Stock | 16.365 | 16.3664 | 16.365 | 16.3664 | 40544.0 |
| 2013-03-27 07:59:00 | AAPL | Stock | 16.3729 | 16.375 | 16.3729 | 16.375 | 28952.0 |
| 2013-03-27 08:00:00 | AAPL | Stock | 16.3696 | 16.3932 | 16.3304 | 16.3625 | 101472.0 |
| 2013-03-27 08:01:00 | AAPL | Stock | 16.3625 | 16.3625 | 16.3625 | 16.3625 | 2800.0 |
| 2013-03-27 08:02:00 | AAPL | Stock | 16.3575 | 16.3582 | 16.3575 | 16.3582 | 26068.0 |
| 2013-03-27 08:03:00 | AAPL | Stock | 16.3586 | 16.4464 | 16.3396 | 16.3396 | 85680.0 |
| 2013-03-27 08:04:00 | AAPL | Stock | 16.3518 | 16.3518 | 16.34 | 16.34 | 33600.0 |
| 2013-03-27 08:05:00 | AAPL | Stock | 16.3393 | 16.3561 | 16.3379 | 16.3379 | 49616.0 |
| 2013-03-27 08:06:00 | AAPL | Stock | 16.3404 | 16.3482 | 16.34 | 16.3407 | 19600.0 |
| 2013-03-27 08:07:00 | AAPL | Stock | 16.3407 | 16.3407 | 16.3389 | 16.34 | 33964.0 |
| 2013-03-27 08:08:00 | AAPL | Stock | 16.3389 | 16.3389 | 16.3307 | 16.3307 | 31780.0 |
| 2013-03-27 08:09:00 | AAPL | Stock | 16.3311 | 16.3311 | 16.33 | 16.33 | 16800.0 |
| 2013-03-27 08:10:00 | AAPL | Stock | 16.3282 | 16.3314 | 16.3268 | 16.3286 | 55300.0 |
| 2013-03-27 08:11:00 | AAPL | Stock | 16.3286 | 16.3307 | 16.3207 | 16.3207 | 64120.0 |
| 2013-03-27 08:12:00 | AAPL | Stock | 16.3175 | 16.3175 | 16.3136 | 16.3136 | 22400.0 |
| 2013-03-27 08:13:00 | AAPL | Stock | 16.3186 | 16.3239 | 16.3179 | 16.3179 | 131264.0 |
| 2013-03-27 08:14:00 | AAPL | Stock | 16.3214 | 16.3214 | 16.32 | 16.3207 | 44800.0 |
> showing 50 of 954,280 rows — these rows as CSV