PREVIEW / stock_1min / 2011-01-14
file: by_date/stock_1min/2011/2011-01-14.parquet size: 13.2 MB rows: 987,242 symbols: 2,861
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-14 05:22:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 2800.0 |
| 2011-01-14 05:23:00 | AAPL | Stock | 12.3875 | 12.3875 | 12.3875 | 12.3875 | 2800.0 |
| 2011-01-14 05:24:00 | AAPL | Stock | 12.3925 | 12.3925 | 12.3925 | 12.3925 | 2800.0 |
| 2011-01-14 05:27:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 5600.0 |
| 2011-01-14 05:29:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 7000.0 |
| 2011-01-14 05:42:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 26712.0 |
| 2011-01-14 06:03:00 | AAPL | Stock | 12.3964 | 12.3964 | 12.3964 | 12.3964 | 5600.0 |
| 2011-01-14 06:12:00 | AAPL | Stock | 12.3932 | 12.3932 | 12.3929 | 12.3929 | 33600.0 |
| 2011-01-14 07:03:00 | AAPL | Stock | 12.3854 | 12.3854 | 12.3854 | 12.3854 | 39200.0 |
| 2011-01-14 07:04:00 | AAPL | Stock | 12.3854 | 12.3854 | 12.3854 | 12.3854 | 25200.0 |
| 2011-01-14 07:05:00 | AAPL | Stock | 12.3711 | 12.3711 | 12.3571 | 12.3571 | 22120.0 |
| 2011-01-14 07:06:00 | AAPL | Stock | 12.3571 | 12.3571 | 12.3571 | 12.3571 | 2800.0 |
| 2011-01-14 07:09:00 | AAPL | Stock | 12.345 | 12.345 | 12.345 | 12.345 | 30800.0 |
| 2011-01-14 07:10:00 | AAPL | Stock | 12.3529 | 12.3529 | 12.3529 | 12.3529 | 2800.0 |
| 2011-01-14 07:17:00 | AAPL | Stock | 12.3482 | 12.3482 | 12.3468 | 12.3468 | 14644.0 |
| 2011-01-14 07:18:00 | AAPL | Stock | 12.3429 | 12.3464 | 12.34 | 12.3464 | 11200.0 |
| 2011-01-14 07:21:00 | AAPL | Stock | 12.3482 | 12.3482 | 12.3482 | 12.3482 | 14000.0 |
| 2011-01-14 07:22:00 | AAPL | Stock | 12.3396 | 12.3429 | 12.3396 | 12.3429 | 16800.0 |
| 2011-01-14 07:24:00 | AAPL | Stock | 12.3475 | 12.3496 | 12.3475 | 12.3496 | 5600.0 |
| 2011-01-14 07:25:00 | AAPL | Stock | 12.3496 | 12.3496 | 12.3496 | 12.3496 | 2800.0 |
| 2011-01-14 07:26:00 | AAPL | Stock | 12.3493 | 12.3536 | 12.3489 | 12.3536 | 44800.0 |
| 2011-01-14 07:27:00 | AAPL | Stock | 12.3536 | 12.3536 | 12.3536 | 12.3536 | 7700.0 |
| 2011-01-14 07:29:00 | AAPL | Stock | 12.3639 | 12.3639 | 12.3571 | 12.3571 | 8400.0 |
| 2011-01-14 07:30:00 | AAPL | Stock | 12.3568 | 12.3568 | 12.35 | 12.35 | 36988.0 |
| 2011-01-14 07:31:00 | AAPL | Stock | 12.3439 | 12.3439 | 12.3439 | 12.3439 | 2800.0 |
| 2011-01-14 07:33:00 | AAPL | Stock | 12.3446 | 12.3446 | 12.3446 | 12.3446 | 2800.0 |
| 2011-01-14 07:35:00 | AAPL | Stock | 12.3375 | 12.3375 | 12.3375 | 12.3375 | 2800.0 |
| 2011-01-14 07:36:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3429 | 12.3429 | 2800.0 |
| 2011-01-14 07:37:00 | AAPL | Stock | 12.3443 | 12.3443 | 12.3443 | 12.3443 | 2800.0 |
| 2011-01-14 07:38:00 | AAPL | Stock | 12.3443 | 12.3443 | 12.3443 | 12.3443 | 5600.0 |
| 2011-01-14 07:42:00 | AAPL | Stock | 12.3446 | 12.3446 | 12.3446 | 12.3446 | 2800.0 |
| 2011-01-14 07:44:00 | AAPL | Stock | 12.3496 | 12.3496 | 12.3464 | 12.3464 | 30800.0 |
| 2011-01-14 07:46:00 | AAPL | Stock | 12.3525 | 12.3525 | 12.35 | 12.3504 | 14000.0 |
| 2011-01-14 07:49:00 | AAPL | Stock | 12.3486 | 12.3486 | 12.3486 | 12.3486 | 2800.0 |
| 2011-01-14 07:52:00 | AAPL | Stock | 12.3464 | 12.3464 | 12.3429 | 12.3429 | 24416.0 |
| 2011-01-14 07:53:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3429 | 12.3429 | 4088.0 |
| 2011-01-14 07:55:00 | AAPL | Stock | 12.3375 | 12.3411 | 12.3218 | 12.3218 | 93464.0 |
| 2011-01-14 07:56:00 | AAPL | Stock | 12.3218 | 12.3218 | 12.3218 | 12.3218 | 8400.0 |
| 2011-01-14 07:57:00 | AAPL | Stock | 12.3411 | 12.3411 | 12.3411 | 12.3411 | 44464.0 |
| 2011-01-14 07:59:00 | AAPL | Stock | 12.3357 | 12.3357 | 12.3357 | 12.3357 | 2800.0 |
| 2011-01-14 08:00:00 | AAPL | Stock | 12.3393 | 12.3421 | 12.3357 | 12.3357 | 67060.0 |
| 2011-01-14 08:01:00 | AAPL | Stock | 12.3386 | 12.3389 | 12.3379 | 12.3389 | 36400.0 |
| 2011-01-14 08:02:00 | AAPL | Stock | 12.3382 | 12.3382 | 12.3339 | 12.3339 | 14000.0 |
| 2011-01-14 08:03:00 | AAPL | Stock | 12.3375 | 12.3382 | 12.3304 | 12.3304 | 27160.0 |
| 2011-01-14 08:04:00 | AAPL | Stock | 12.3307 | 12.3357 | 12.3304 | 12.3339 | 22400.0 |
| 2011-01-14 08:05:00 | AAPL | Stock | 12.3286 | 12.3286 | 12.3268 | 12.3268 | 40600.0 |
| 2011-01-14 08:06:00 | AAPL | Stock | 12.3268 | 12.3339 | 12.3232 | 12.3286 | 85176.0 |
| 2011-01-14 08:07:00 | AAPL | Stock | 12.3293 | 12.3293 | 12.3286 | 12.3286 | 22400.0 |
| 2011-01-14 08:08:00 | AAPL | Stock | 12.3318 | 12.3339 | 12.3286 | 12.3339 | 39424.0 |
| 2011-01-14 08:09:00 | AAPL | Stock | 12.3382 | 12.3382 | 12.3382 | 12.3382 | 2800.0 |
> showing 50 of 987,242 rows — these rows as CSV