PREVIEW / stock_1min / 2013-12-24
file: by_date/stock_1min/2013/2013-12-24.parquet size: 8.0 MB rows: 565,290 symbols: 2,802
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-12-24 04:12:00 | AAPL | Stock | 20.37 | 20.37 | 20.37 | 20.37 | 2800.0 |
| 2013-12-24 05:01:00 | AAPL | Stock | 20.3854 | 20.3854 | 20.3854 | 20.3854 | 5600.0 |
| 2013-12-24 05:02:00 | AAPL | Stock | 20.3929 | 20.4064 | 20.3929 | 20.4064 | 30800.0 |
| 2013-12-24 05:15:00 | AAPL | Stock | 20.4 | 20.4 | 20.4 | 20.4 | 2800.0 |
| 2013-12-24 05:49:00 | AAPL | Stock | 20.435 | 20.435 | 20.435 | 20.435 | 2800.0 |
| 2013-12-24 06:03:00 | AAPL | Stock | 20.435 | 20.435 | 20.435 | 20.435 | 2800.0 |
| 2013-12-24 06:11:00 | AAPL | Stock | 20.4286 | 20.4286 | 20.4286 | 20.4286 | 2800.0 |
| 2013-12-24 06:17:00 | AAPL | Stock | 20.4039 | 20.4039 | 20.3929 | 20.3929 | 6524.0 |
| 2013-12-24 06:34:00 | AAPL | Stock | 20.4286 | 20.4286 | 20.4286 | 20.4286 | 2800.0 |
| 2013-12-24 06:59:00 | AAPL | Stock | 20.4264 | 20.4264 | 20.4261 | 20.4261 | 5600.0 |
| 2013-12-24 07:03:00 | AAPL | Stock | 20.4246 | 20.4246 | 20.4236 | 20.4236 | 14000.0 |
| 2013-12-24 07:08:00 | AAPL | Stock | 20.3929 | 20.3929 | 20.3929 | 20.3929 | 20468.0 |
| 2013-12-24 07:09:00 | AAPL | Stock | 20.3929 | 20.3982 | 20.3929 | 20.3982 | 37828.0 |
| 2013-12-24 07:10:00 | AAPL | Stock | 20.3929 | 20.3929 | 20.3929 | 20.3929 | 11200.0 |
| 2013-12-24 07:11:00 | AAPL | Stock | 20.3929 | 20.3936 | 20.3929 | 20.3929 | 44800.0 |
| 2013-12-24 07:17:00 | AAPL | Stock | 20.3771 | 20.3771 | 20.3718 | 20.3718 | 23100.0 |
| 2013-12-24 07:18:00 | AAPL | Stock | 20.375 | 20.375 | 20.3661 | 20.3661 | 5600.0 |
| 2013-12-24 07:25:00 | AAPL | Stock | 20.3679 | 20.3679 | 20.3571 | 20.3571 | 16800.0 |
| 2013-12-24 07:29:00 | AAPL | Stock | 20.3357 | 20.3357 | 20.3329 | 20.3329 | 5600.0 |
| 2013-12-24 07:30:00 | AAPL | Stock | 20.3429 | 20.3429 | 20.3429 | 20.3429 | 5544.0 |
| 2013-12-24 07:35:00 | AAPL | Stock | 20.3571 | 20.3571 | 20.3571 | 20.3571 | 14000.0 |
| 2013-12-24 07:36:00 | AAPL | Stock | 20.3686 | 20.3732 | 20.3686 | 20.3732 | 14000.0 |
| 2013-12-24 07:37:00 | AAPL | Stock | 20.375 | 20.375 | 20.375 | 20.375 | 14000.0 |
| 2013-12-24 07:50:00 | AAPL | Stock | 20.3729 | 20.3739 | 20.3729 | 20.3729 | 12432.0 |
| 2013-12-24 07:57:00 | AAPL | Stock | 20.3679 | 20.3679 | 20.3679 | 20.3679 | 8120.0 |
| 2013-12-24 07:58:00 | AAPL | Stock | 20.3643 | 20.3743 | 20.3643 | 20.3714 | 33600.0 |
| 2013-12-24 07:59:00 | AAPL | Stock | 20.3571 | 20.3571 | 20.3571 | 20.3571 | 2800.0 |
| 2013-12-24 08:00:00 | AAPL | Stock | 20.3446 | 20.4257 | 20.3446 | 20.3571 | 124964.0 |
| 2013-12-24 08:01:00 | AAPL | Stock | 20.35 | 20.3572 | 20.35 | 20.3571 | 75320.0 |
| 2013-12-24 08:02:00 | AAPL | Stock | 20.3571 | 20.3572 | 20.35 | 20.35 | 45556.0 |
| 2013-12-24 08:03:00 | AAPL | Stock | 20.35 | 20.35 | 20.3393 | 20.3393 | 77896.0 |
| 2013-12-24 08:04:00 | AAPL | Stock | 20.3532 | 20.3532 | 20.3532 | 20.3532 | 2800.0 |
| 2013-12-24 08:05:00 | AAPL | Stock | 20.3397 | 20.3397 | 20.3397 | 20.3397 | 9800.0 |
| 2013-12-24 08:06:00 | AAPL | Stock | 20.3468 | 20.3468 | 20.3468 | 20.3468 | 2800.0 |
| 2013-12-24 08:07:00 | AAPL | Stock | 20.3418 | 20.3418 | 20.3375 | 20.3375 | 39200.0 |
| 2013-12-24 08:09:00 | AAPL | Stock | 20.3314 | 20.3393 | 20.3293 | 20.3393 | 18900.0 |
| 2013-12-24 08:10:00 | AAPL | Stock | 20.3375 | 20.3375 | 20.3375 | 20.3375 | 2800.0 |
| 2013-12-24 08:13:00 | AAPL | Stock | 20.3279 | 20.3279 | 20.3279 | 20.3279 | 2800.0 |
| 2013-12-24 08:15:00 | AAPL | Stock | 20.3375 | 20.3396 | 20.3375 | 20.3382 | 18480.0 |
| 2013-12-24 08:16:00 | AAPL | Stock | 20.3375 | 20.3375 | 20.3375 | 20.3375 | 2800.0 |
| 2013-12-24 08:19:00 | AAPL | Stock | 20.3393 | 20.3393 | 20.3393 | 20.3393 | 2800.0 |
| 2013-12-24 08:20:00 | AAPL | Stock | 20.3393 | 20.345 | 20.3393 | 20.345 | 8400.0 |
| 2013-12-24 08:21:00 | AAPL | Stock | 20.3393 | 20.3393 | 20.3393 | 20.3393 | 5600.0 |
| 2013-12-24 08:24:00 | AAPL | Stock | 20.3379 | 20.3379 | 20.3379 | 20.3379 | 2800.0 |
| 2013-12-24 08:25:00 | AAPL | Stock | 20.3411 | 20.3411 | 20.3357 | 20.3357 | 7952.0 |
| 2013-12-24 08:26:00 | AAPL | Stock | 20.3354 | 20.3357 | 20.3354 | 20.3357 | 5600.0 |
| 2013-12-24 08:27:00 | AAPL | Stock | 20.3296 | 20.3357 | 20.3293 | 20.3357 | 25200.0 |
| 2013-12-24 08:30:00 | AAPL | Stock | 20.3367 | 20.3367 | 20.3367 | 20.3367 | 2800.0 |
| 2013-12-24 08:32:00 | AAPL | Stock | 20.3304 | 20.3304 | 20.3304 | 20.3304 | 4200.0 |
| 2013-12-24 08:34:00 | AAPL | Stock | 20.3346 | 20.3357 | 20.3346 | 20.3354 | 14616.0 |
> showing 50 of 565,290 rows — these rows as CSV