PREVIEW / stock_1min / 2008-07-22
file: by_date/stock_1min/2008/2008-07-22.parquet size: 13.1 MB rows: 1,045,185 symbols: 2,706
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-22 04:02:00 | AAPL | Stock | 5.3214 | 5.3214 | 5.3214 | 5.3214 | 28000.0 |
| 2008-07-22 04:03:00 | AAPL | Stock | 5.3214 | 5.3214 | 5.3214 | 5.3214 | 28000.0 |
| 2008-07-22 04:15:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3571 | 5.3571 | 2800.0 |
| 2008-07-22 04:42:00 | AAPL | Stock | 5.3389 | 5.3389 | 5.3389 | 5.3389 | 2800.0 |
| 2008-07-22 05:04:00 | AAPL | Stock | 5.3393 | 5.3393 | 5.3264 | 5.3286 | 67200.0 |
| 2008-07-22 05:19:00 | AAPL | Stock | 5.3189 | 5.3189 | 5.3189 | 5.3189 | 5600.0 |
| 2008-07-22 05:20:00 | AAPL | Stock | 5.3189 | 5.3189 | 5.3186 | 5.3186 | 96432.0 |
| 2008-07-22 05:21:00 | AAPL | Stock | 5.3143 | 5.3143 | 5.3143 | 5.3143 | 26544.0 |
| 2008-07-22 05:22:00 | AAPL | Stock | 5.3214 | 5.3214 | 5.3214 | 5.3214 | 54544.0 |
| 2008-07-22 05:54:00 | AAPL | Stock | 5.3454 | 5.3454 | 5.3454 | 5.3454 | 9240.0 |
| 2008-07-22 05:55:00 | AAPL | Stock | 5.3454 | 5.3464 | 5.3454 | 5.3464 | 186760.0 |
| 2008-07-22 05:56:00 | AAPL | Stock | 5.3464 | 5.3464 | 5.3464 | 5.3464 | 108360.0 |
| 2008-07-22 05:57:00 | AAPL | Stock | 5.3464 | 5.3464 | 5.3464 | 5.3464 | 8400.0 |
| 2008-07-22 05:59:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3571 | 5.3571 | 9240.0 |
| 2008-07-22 06:10:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3571 | 5.3571 | 16800.0 |
| 2008-07-22 07:00:00 | AAPL | Stock | 5.3393 | 5.3393 | 5.3393 | 5.3393 | 2800.0 |
| 2008-07-22 07:02:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3393 | 5.3393 | 22400.0 |
| 2008-07-22 07:04:00 | AAPL | Stock | 5.3393 | 5.3393 | 5.3393 | 5.3393 | 14000.0 |
| 2008-07-22 07:05:00 | AAPL | Stock | 5.3286 | 5.3286 | 5.3286 | 5.3286 | 39200.0 |
| 2008-07-22 07:06:00 | AAPL | Stock | 5.3236 | 5.3236 | 5.3114 | 5.3175 | 134400.0 |
| 2008-07-22 07:08:00 | AAPL | Stock | 5.3214 | 5.3214 | 5.3143 | 5.3214 | 25200.0 |
| 2008-07-22 07:09:00 | AAPL | Stock | 5.3186 | 5.3214 | 5.3179 | 5.3179 | 161000.0 |
| 2008-07-22 07:10:00 | AAPL | Stock | 5.315 | 5.315 | 5.3143 | 5.3143 | 28000.0 |
| 2008-07-22 07:11:00 | AAPL | Stock | 5.3204 | 5.3325 | 5.3204 | 5.3325 | 483280.0 |
| 2008-07-22 07:13:00 | AAPL | Stock | 5.3325 | 5.3325 | 5.3325 | 5.3325 | 14000.0 |
| 2008-07-22 07:14:00 | AAPL | Stock | 5.3321 | 5.3321 | 5.3304 | 5.3304 | 16800.0 |
| 2008-07-22 07:15:00 | AAPL | Stock | 5.325 | 5.325 | 5.325 | 5.325 | 2800.0 |
| 2008-07-22 07:18:00 | AAPL | Stock | 5.3454 | 5.3571 | 5.3318 | 5.3389 | 44800.0 |
| 2008-07-22 07:20:00 | AAPL | Stock | 5.3325 | 5.3325 | 5.3325 | 5.3325 | 2800.0 |
| 2008-07-22 07:22:00 | AAPL | Stock | 5.3386 | 5.3386 | 5.3321 | 5.3321 | 10780.0 |
| 2008-07-22 07:23:00 | AAPL | Stock | 5.3214 | 5.3321 | 5.3214 | 5.3214 | 135520.0 |
| 2008-07-22 07:25:00 | AAPL | Stock | 5.3171 | 5.3171 | 5.3143 | 5.3143 | 80360.0 |
| 2008-07-22 07:26:00 | AAPL | Stock | 5.3143 | 5.3143 | 5.3143 | 5.3143 | 14000.0 |
| 2008-07-22 07:28:00 | AAPL | Stock | 5.325 | 5.3304 | 5.325 | 5.3304 | 7000.0 |
| 2008-07-22 07:29:00 | AAPL | Stock | 5.3321 | 5.3321 | 5.325 | 5.325 | 88200.0 |
| 2008-07-22 07:31:00 | AAPL | Stock | 5.3293 | 5.3293 | 5.3286 | 5.3286 | 8988.0 |
| 2008-07-22 07:32:00 | AAPL | Stock | 5.325 | 5.325 | 5.325 | 5.325 | 2800.0 |
| 2008-07-22 07:33:00 | AAPL | Stock | 5.3379 | 5.3393 | 5.3379 | 5.3393 | 33600.0 |
| 2008-07-22 07:34:00 | AAPL | Stock | 5.3429 | 5.3482 | 5.3429 | 5.3464 | 28000.0 |
| 2008-07-22 07:35:00 | AAPL | Stock | 5.3393 | 5.3482 | 5.3393 | 5.3479 | 60480.0 |
| 2008-07-22 07:36:00 | AAPL | Stock | 5.3568 | 5.3643 | 5.3529 | 5.3571 | 457800.0 |
| 2008-07-22 07:37:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3571 | 5.3571 | 25200.0 |
| 2008-07-22 07:38:00 | AAPL | Stock | 5.3536 | 5.3571 | 5.3536 | 5.3571 | 82600.0 |
| 2008-07-22 07:39:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3507 | 5.3507 | 75600.0 |
| 2008-07-22 07:40:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3568 | 5.3571 | 131684.0 |
| 2008-07-22 07:41:00 | AAPL | Stock | 5.3532 | 5.3571 | 5.3532 | 5.3568 | 22540.0 |
| 2008-07-22 07:42:00 | AAPL | Stock | 5.3532 | 5.3532 | 5.3532 | 5.3532 | 2800.0 |
| 2008-07-22 07:43:00 | AAPL | Stock | 5.3529 | 5.3554 | 5.3529 | 5.3554 | 56840.0 |
| 2008-07-22 07:44:00 | AAPL | Stock | 5.3518 | 5.3554 | 5.3518 | 5.3554 | 41300.0 |
| 2008-07-22 07:45:00 | AAPL | Stock | 5.3536 | 5.3554 | 5.3536 | 5.3554 | 56000.0 |
> showing 50 of 1,045,185 rows — these rows as CSV