PREVIEW / stock_1min / 2009-11-16
file: by_date/stock_1min/2009/2009-11-16.parquet size: 13.1 MB rows: 1,000,720 symbols: 2,786
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-16 06:16:00 | AAPL | Stock | 7.35 | 7.35 | 7.35 | 7.35 | 2800.0 |
| 2009-11-16 07:05:00 | AAPL | Stock | 7.3543 | 7.3543 | 7.3543 | 7.3543 | 2800.0 |
| 2009-11-16 07:08:00 | AAPL | Stock | 7.3546 | 7.3546 | 7.3546 | 7.3546 | 2800.0 |
| 2009-11-16 07:12:00 | AAPL | Stock | 7.3568 | 7.3568 | 7.3554 | 7.3554 | 10640.0 |
| 2009-11-16 07:17:00 | AAPL | Stock | 7.3536 | 7.3536 | 7.3536 | 7.3536 | 2800.0 |
| 2009-11-16 07:18:00 | AAPL | Stock | 7.3536 | 7.3536 | 7.3536 | 7.3536 | 2800.0 |
| 2009-11-16 07:22:00 | AAPL | Stock | 7.3536 | 7.3536 | 7.3536 | 7.3536 | 10640.0 |
| 2009-11-16 07:23:00 | AAPL | Stock | 7.3529 | 7.3529 | 7.3529 | 7.3529 | 109200.0 |
| 2009-11-16 07:29:00 | AAPL | Stock | 7.3536 | 7.3536 | 7.3536 | 7.3536 | 2800.0 |
| 2009-11-16 07:31:00 | AAPL | Stock | 7.3536 | 7.3536 | 7.3536 | 7.3536 | 6804.0 |
| 2009-11-16 07:32:00 | AAPL | Stock | 7.3554 | 7.3554 | 7.3554 | 7.3554 | 3556.0 |
| 2009-11-16 07:43:00 | AAPL | Stock | 7.3554 | 7.3554 | 7.3554 | 7.3554 | 33600.0 |
| 2009-11-16 07:45:00 | AAPL | Stock | 7.3518 | 7.3518 | 7.3518 | 7.3518 | 11200.0 |
| 2009-11-16 07:46:00 | AAPL | Stock | 7.3518 | 7.3518 | 7.3482 | 7.3482 | 89600.0 |
| 2009-11-16 07:47:00 | AAPL | Stock | 7.3482 | 7.3482 | 7.3446 | 7.3446 | 128800.0 |
| 2009-11-16 07:48:00 | AAPL | Stock | 7.3446 | 7.3446 | 7.3429 | 7.3429 | 58800.0 |
| 2009-11-16 07:49:00 | AAPL | Stock | 7.3393 | 7.3393 | 7.3375 | 7.3375 | 11200.0 |
| 2009-11-16 07:50:00 | AAPL | Stock | 7.3393 | 7.3393 | 7.3325 | 7.3375 | 50400.0 |
| 2009-11-16 07:52:00 | AAPL | Stock | 7.335 | 7.335 | 7.3321 | 7.3321 | 21028.0 |
| 2009-11-16 07:53:00 | AAPL | Stock | 7.3304 | 7.3304 | 7.3304 | 7.3304 | 28000.0 |
| 2009-11-16 07:54:00 | AAPL | Stock | 7.3286 | 7.3321 | 7.3286 | 7.3304 | 32760.0 |
| 2009-11-16 07:58:00 | AAPL | Stock | 7.33 | 7.3304 | 7.3286 | 7.3286 | 11200.0 |
| 2009-11-16 07:59:00 | AAPL | Stock | 7.3286 | 7.3286 | 7.3286 | 7.3286 | 5600.0 |
| 2009-11-16 08:00:00 | AAPL | Stock | 7.3318 | 7.354 | 7.3214 | 7.3343 | 368984.0 |
| 2009-11-16 08:01:00 | AAPL | Stock | 7.3346 | 7.3371 | 7.3339 | 7.3368 | 148260.0 |
| 2009-11-16 08:02:00 | AAPL | Stock | 7.3357 | 7.3389 | 7.3357 | 7.3389 | 118160.0 |
| 2009-11-16 08:03:00 | AAPL | Stock | 7.3389 | 7.3404 | 7.3382 | 7.3404 | 176736.0 |
| 2009-11-16 08:04:00 | AAPL | Stock | 7.3404 | 7.3446 | 7.3404 | 7.3446 | 193200.0 |
| 2009-11-16 08:05:00 | AAPL | Stock | 7.3461 | 7.3482 | 7.3461 | 7.3464 | 84448.0 |
| 2009-11-16 08:06:00 | AAPL | Stock | 7.3461 | 7.3482 | 7.3461 | 7.3479 | 81396.0 |
| 2009-11-16 08:07:00 | AAPL | Stock | 7.3464 | 7.3479 | 7.345 | 7.345 | 116228.0 |
| 2009-11-16 08:08:00 | AAPL | Stock | 7.3446 | 7.3446 | 7.3393 | 7.3393 | 60844.0 |
| 2009-11-16 08:09:00 | AAPL | Stock | 7.3371 | 7.3393 | 7.3371 | 7.3389 | 12880.0 |
| 2009-11-16 08:10:00 | AAPL | Stock | 7.3389 | 7.3393 | 7.3375 | 7.3375 | 48384.0 |
| 2009-11-16 08:11:00 | AAPL | Stock | 7.3336 | 7.3336 | 7.3329 | 7.3329 | 37632.0 |
| 2009-11-16 08:12:00 | AAPL | Stock | 7.3336 | 7.3339 | 7.3336 | 7.3339 | 22400.0 |
| 2009-11-16 08:13:00 | AAPL | Stock | 7.3339 | 7.3357 | 7.3304 | 7.3357 | 57260.0 |
| 2009-11-16 08:14:00 | AAPL | Stock | 7.3321 | 7.3321 | 7.3286 | 7.3321 | 22960.0 |
| 2009-11-16 08:15:00 | AAPL | Stock | 7.3307 | 7.3311 | 7.3261 | 7.3261 | 31640.0 |
| 2009-11-16 08:16:00 | AAPL | Stock | 7.3311 | 7.335 | 7.3311 | 7.3343 | 70588.0 |
| 2009-11-16 08:17:00 | AAPL | Stock | 7.3354 | 7.3357 | 7.3346 | 7.3357 | 18760.0 |
| 2009-11-16 08:18:00 | AAPL | Stock | 7.3357 | 7.3375 | 7.3343 | 7.3357 | 142240.0 |
| 2009-11-16 08:19:00 | AAPL | Stock | 7.3357 | 7.3386 | 7.3357 | 7.3386 | 100800.0 |
| 2009-11-16 08:21:00 | AAPL | Stock | 7.3386 | 7.3386 | 7.3386 | 7.3386 | 2800.0 |
| 2009-11-16 08:22:00 | AAPL | Stock | 7.3375 | 7.3375 | 7.3357 | 7.3357 | 28000.0 |
| 2009-11-16 08:23:00 | AAPL | Stock | 7.3346 | 7.3346 | 7.3339 | 7.3339 | 18312.0 |
| 2009-11-16 08:24:00 | AAPL | Stock | 7.3375 | 7.3393 | 7.3375 | 7.3393 | 63280.0 |
| 2009-11-16 08:25:00 | AAPL | Stock | 7.3389 | 7.3389 | 7.3339 | 7.3339 | 75600.0 |
| 2009-11-16 08:26:00 | AAPL | Stock | 7.3339 | 7.3346 | 7.3339 | 7.3346 | 24052.0 |
| 2009-11-16 08:27:00 | AAPL | Stock | 7.3321 | 7.3357 | 7.3318 | 7.3357 | 25200.0 |
> showing 50 of 1,000,720 rows — these rows as CSV