PREVIEW / stock_1min / 2008-08-13
file: by_date/stock_1min/2008/2008-08-13.parquet size: 12.7 MB rows: 1,025,884 symbols: 2,705
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-08-13 04:56:00 | AAPL | Stock | 6.2996 | 6.2996 | 6.2996 | 6.2996 | 2800.0 |
| 2008-08-13 06:09:00 | AAPL | Stock | 6.2804 | 6.2804 | 6.2804 | 6.2804 | 5936.0 |
| 2008-08-13 06:42:00 | AAPL | Stock | 6.2804 | 6.2804 | 6.2804 | 6.2804 | 5600.0 |
| 2008-08-13 06:43:00 | AAPL | Stock | 6.2804 | 6.2804 | 6.2804 | 6.2804 | 5600.0 |
| 2008-08-13 06:48:00 | AAPL | Stock | 6.2804 | 6.2804 | 6.2804 | 6.2804 | 7000.0 |
| 2008-08-13 06:50:00 | AAPL | Stock | 6.2804 | 6.2804 | 6.2804 | 6.2804 | 2800.0 |
| 2008-08-13 07:00:00 | AAPL | Stock | 6.2979 | 6.3136 | 6.2979 | 6.3136 | 25200.0 |
| 2008-08-13 07:02:00 | AAPL | Stock | 6.3318 | 6.3318 | 6.3318 | 6.3318 | 5600.0 |
| 2008-08-13 07:03:00 | AAPL | Stock | 6.3036 | 6.3036 | 6.3036 | 6.3036 | 5600.0 |
| 2008-08-13 07:07:00 | AAPL | Stock | 6.3143 | 6.3143 | 6.3143 | 6.3143 | 2800.0 |
| 2008-08-13 07:08:00 | AAPL | Stock | 6.3118 | 6.3118 | 6.3118 | 6.3118 | 8400.0 |
| 2008-08-13 07:27:00 | AAPL | Stock | 6.3043 | 6.3043 | 6.3043 | 6.3043 | 4200.0 |
| 2008-08-13 07:36:00 | AAPL | Stock | 6.3043 | 6.3043 | 6.2939 | 6.2939 | 11200.0 |
| 2008-08-13 07:38:00 | AAPL | Stock | 6.3175 | 6.3214 | 6.3175 | 6.3214 | 16800.0 |
| 2008-08-13 07:40:00 | AAPL | Stock | 6.3214 | 6.3214 | 6.3214 | 6.3214 | 28000.0 |
| 2008-08-13 07:46:00 | AAPL | Stock | 6.3336 | 6.3339 | 6.3336 | 6.3339 | 13440.0 |
| 2008-08-13 07:49:00 | AAPL | Stock | 6.3379 | 6.3382 | 6.3321 | 6.3321 | 47320.0 |
| 2008-08-13 07:50:00 | AAPL | Stock | 6.3357 | 6.3393 | 6.3357 | 6.3393 | 64400.0 |
| 2008-08-13 07:51:00 | AAPL | Stock | 6.3446 | 6.3461 | 6.3446 | 6.3461 | 22400.0 |
| 2008-08-13 07:52:00 | AAPL | Stock | 6.34 | 6.34 | 6.34 | 6.34 | 98000.0 |
| 2008-08-13 07:53:00 | AAPL | Stock | 6.3464 | 6.3464 | 6.3464 | 6.3464 | 25200.0 |
| 2008-08-13 07:55:00 | AAPL | Stock | 6.3579 | 6.3661 | 6.3579 | 6.3661 | 17948.0 |
| 2008-08-13 07:56:00 | AAPL | Stock | 6.3643 | 6.3786 | 6.36 | 6.36 | 142800.0 |
| 2008-08-13 07:57:00 | AAPL | Stock | 6.3643 | 6.3646 | 6.3571 | 6.3571 | 128352.0 |
| 2008-08-13 07:58:00 | AAPL | Stock | 6.3571 | 6.3575 | 6.3532 | 6.3532 | 117600.0 |
| 2008-08-13 07:59:00 | AAPL | Stock | 6.3482 | 6.3482 | 6.3482 | 6.3482 | 28000.0 |
| 2008-08-13 08:00:00 | AAPL | Stock | 6.3536 | 6.3732 | 6.3393 | 6.3514 | 385812.0 |
| 2008-08-13 08:01:00 | AAPL | Stock | 6.3482 | 6.3482 | 6.3454 | 6.3471 | 80668.0 |
| 2008-08-13 08:02:00 | AAPL | Stock | 6.3432 | 6.3475 | 6.3411 | 6.3411 | 51212.0 |
| 2008-08-13 08:03:00 | AAPL | Stock | 6.3454 | 6.3482 | 6.3286 | 6.3464 | 224952.0 |
| 2008-08-13 08:04:00 | AAPL | Stock | 6.3482 | 6.35 | 6.3482 | 6.3486 | 28000.0 |
| 2008-08-13 08:05:00 | AAPL | Stock | 6.3482 | 6.35 | 6.345 | 6.3479 | 193200.0 |
| 2008-08-13 08:06:00 | AAPL | Stock | 6.3464 | 6.3493 | 6.3464 | 6.3486 | 45976.0 |
| 2008-08-13 08:07:00 | AAPL | Stock | 6.3479 | 6.3571 | 6.3479 | 6.35 | 165032.0 |
| 2008-08-13 08:08:00 | AAPL | Stock | 6.3536 | 6.3679 | 6.3536 | 6.3586 | 194544.0 |
| 2008-08-13 08:09:00 | AAPL | Stock | 6.3611 | 6.3611 | 6.3589 | 6.3589 | 26600.0 |
| 2008-08-13 08:10:00 | AAPL | Stock | 6.3607 | 6.3607 | 6.3568 | 6.3571 | 128912.0 |
| 2008-08-13 08:11:00 | AAPL | Stock | 6.3557 | 6.3557 | 6.3557 | 6.3557 | 5600.0 |
| 2008-08-13 08:13:00 | AAPL | Stock | 6.3507 | 6.3554 | 6.3507 | 6.3554 | 8400.0 |
| 2008-08-13 08:14:00 | AAPL | Stock | 6.3507 | 6.3511 | 6.3493 | 6.3496 | 29400.0 |
| 2008-08-13 08:15:00 | AAPL | Stock | 6.35 | 6.35 | 6.3496 | 6.3496 | 30800.0 |
| 2008-08-13 08:16:00 | AAPL | Stock | 6.3514 | 6.3514 | 6.3514 | 6.3514 | 5600.0 |
| 2008-08-13 08:17:00 | AAPL | Stock | 6.3496 | 6.3561 | 6.3496 | 6.3496 | 32620.0 |
| 2008-08-13 08:18:00 | AAPL | Stock | 6.3496 | 6.3561 | 6.3414 | 6.3507 | 63532.0 |
| 2008-08-13 08:19:00 | AAPL | Stock | 6.3521 | 6.3532 | 6.3504 | 6.3532 | 39200.0 |
| 2008-08-13 08:20:00 | AAPL | Stock | 6.35 | 6.3518 | 6.3464 | 6.3464 | 98840.0 |
| 2008-08-13 08:21:00 | AAPL | Stock | 6.3457 | 6.3457 | 6.3425 | 6.3429 | 68460.0 |
| 2008-08-13 08:22:00 | AAPL | Stock | 6.3411 | 6.3432 | 6.3393 | 6.3411 | 58800.0 |
| 2008-08-13 08:23:00 | AAPL | Stock | 6.3446 | 6.3475 | 6.3411 | 6.3475 | 51240.0 |
| 2008-08-13 08:24:00 | AAPL | Stock | 6.3504 | 6.3504 | 6.3461 | 6.3496 | 28000.0 |
> showing 50 of 1,025,884 rows — these rows as CSV