PREVIEW / stock_5min / 2011-11-23
file: by_date/stock_5min/2011/2011-11-23.parquet size: 4.7 MB rows: 326,268 symbols: 3,534
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-11-23 06:30:00 | AAPL | Stock | 13.3421 | 13.3421 | 13.3421 | 13.3421 | 5600.0 |
| 2011-11-23 06:40:00 | AAPL | Stock | 13.3543 | 13.3543 | 13.3543 | 13.3543 | 5600.0 |
| 2011-11-23 06:50:00 | AAPL | Stock | 13.375 | 13.375 | 13.375 | 13.375 | 2800.0 |
| 2011-11-23 07:00:00 | AAPL | Stock | 13.3893 | 13.3893 | 13.3679 | 13.3679 | 8652.0 |
| 2011-11-23 07:05:00 | AAPL | Stock | 13.3786 | 13.3786 | 13.3596 | 13.3614 | 35000.0 |
| 2011-11-23 07:10:00 | AAPL | Stock | 13.3675 | 13.3739 | 13.3675 | 13.3714 | 22400.0 |
| 2011-11-23 07:15:00 | AAPL | Stock | 13.3732 | 13.3836 | 13.3618 | 13.3636 | 56000.0 |
| 2011-11-23 07:20:00 | AAPL | Stock | 13.3614 | 13.3614 | 13.3571 | 13.3571 | 22400.0 |
| 2011-11-23 07:25:00 | AAPL | Stock | 13.3411 | 13.3543 | 13.3393 | 13.3543 | 8400.0 |
| 2011-11-23 07:30:00 | AAPL | Stock | 13.3464 | 13.3471 | 13.3393 | 13.3429 | 35280.0 |
| 2011-11-23 07:35:00 | AAPL | Stock | 13.3357 | 13.3557 | 13.3357 | 13.3557 | 33600.0 |
| 2011-11-23 07:40:00 | AAPL | Stock | 13.3561 | 13.3571 | 13.35 | 13.3568 | 86100.0 |
| 2011-11-23 07:45:00 | AAPL | Stock | 13.3564 | 13.36 | 13.3564 | 13.36 | 16800.0 |
| 2011-11-23 07:50:00 | AAPL | Stock | 13.3439 | 13.36 | 13.3439 | 13.36 | 25200.0 |
| 2011-11-23 08:00:00 | AAPL | Stock | 13.3554 | 13.3721 | 13.3504 | 13.3575 | 266588.0 |
| 2011-11-23 08:05:00 | AAPL | Stock | 13.3557 | 13.3557 | 13.3482 | 13.3504 | 48720.0 |
| 2011-11-23 08:10:00 | AAPL | Stock | 13.3518 | 13.3518 | 13.3243 | 13.3393 | 140616.0 |
| 2011-11-23 08:15:00 | AAPL | Stock | 13.3393 | 13.3393 | 13.3286 | 13.3393 | 89320.0 |
| 2011-11-23 08:20:00 | AAPL | Stock | 13.3332 | 13.3357 | 13.3304 | 13.3346 | 46648.0 |
| 2011-11-23 08:25:00 | AAPL | Stock | 13.3357 | 13.3393 | 13.3304 | 13.3393 | 39200.0 |
| 2011-11-23 08:30:00 | AAPL | Stock | 13.3393 | 13.3568 | 13.3314 | 13.3564 | 342608.0 |
| 2011-11-23 08:35:00 | AAPL | Stock | 13.3536 | 13.3796 | 13.3518 | 13.3571 | 194040.0 |
| 2011-11-23 08:40:00 | AAPL | Stock | 13.3575 | 13.3618 | 13.3532 | 13.3536 | 91700.0 |
| 2011-11-23 08:45:00 | AAPL | Stock | 13.3511 | 13.3546 | 13.3464 | 13.3464 | 112140.0 |
| 2011-11-23 08:50:00 | AAPL | Stock | 13.3464 | 13.3521 | 13.32 | 13.3214 | 267904.0 |
| 2011-11-23 08:55:00 | AAPL | Stock | 13.3179 | 13.3396 | 13.3179 | 13.3393 | 70980.0 |
| 2011-11-23 09:00:00 | AAPL | Stock | 13.3393 | 13.3393 | 13.3307 | 13.3307 | 41944.0 |
| 2011-11-23 09:05:00 | AAPL | Stock | 13.3379 | 13.3393 | 13.3214 | 13.3225 | 90496.0 |
| 2011-11-23 09:10:00 | AAPL | Stock | 13.3218 | 13.3346 | 13.3211 | 13.3346 | 151312.0 |
| 2011-11-23 09:15:00 | AAPL | Stock | 13.3382 | 13.3571 | 13.3382 | 13.3571 | 168840.0 |
| 2011-11-23 09:20:00 | AAPL | Stock | 13.3607 | 13.3986 | 13.3607 | 13.3986 | 468496.0 |
| 2011-11-23 09:25:00 | AAPL | Stock | 13.3964 | 13.3964 | 13.3729 | 13.3754 | 519848.0 |
| 2011-11-23 09:30:00 | AAPL | Stock | 13.3821 | 13.4193 | 13.3646 | 13.415 | 20750996.0 |
| 2011-11-23 09:35:00 | AAPL | Stock | 13.4116 | 13.4229 | 13.3857 | 13.4036 | 9955204.0 |
| 2011-11-23 09:40:00 | AAPL | Stock | 13.4036 | 13.4107 | 13.3036 | 13.33 | 13553764.0 |
| 2011-11-23 09:45:00 | AAPL | Stock | 13.3313 | 13.3493 | 13.3039 | 13.3071 | 7258580.0 |
| 2011-11-23 09:50:00 | AAPL | Stock | 13.3057 | 13.3336 | 13.2896 | 13.3222 | 7069692.0 |
| 2011-11-23 09:55:00 | AAPL | Stock | 13.3225 | 13.3246 | 13.2614 | 13.2644 | 7447440.0 |
| 2011-11-23 10:00:00 | AAPL | Stock | 13.2636 | 13.2825 | 13.2321 | 13.2499 | 10975608.0 |
| 2011-11-23 10:05:00 | AAPL | Stock | 13.25 | 13.25 | 13.1971 | 13.2256 | 13475952.0 |
| 2011-11-23 10:10:00 | AAPL | Stock | 13.2257 | 13.2342 | 13.1711 | 13.1839 | 10897684.0 |
| 2011-11-23 10:15:00 | AAPL | Stock | 13.1857 | 13.2139 | 13.1518 | 13.1725 | 8370320.0 |
| 2011-11-23 10:20:00 | AAPL | Stock | 13.1719 | 13.1843 | 13.1354 | 13.1489 | 10378872.0 |
| 2011-11-23 10:25:00 | AAPL | Stock | 13.1496 | 13.1786 | 13.1489 | 13.1696 | 6910988.0 |
| 2011-11-23 10:30:00 | AAPL | Stock | 13.1696 | 13.175 | 13.1393 | 13.1734 | 6197884.0 |
| 2011-11-23 10:35:00 | AAPL | Stock | 13.1699 | 13.2157 | 13.1699 | 13.2013 | 11215372.0 |
| 2011-11-23 10:40:00 | AAPL | Stock | 13.2025 | 13.2121 | 13.19 | 13.1982 | 5230792.0 |
| 2011-11-23 10:45:00 | AAPL | Stock | 13.1981 | 13.2111 | 13.1858 | 13.2028 | 4148592.0 |
| 2011-11-23 10:50:00 | AAPL | Stock | 13.1989 | 13.2221 | 13.1943 | 13.2221 | 4420164.0 |
| 2011-11-23 10:55:00 | AAPL | Stock | 13.2221 | 13.2232 | 13.1968 | 13.2121 | 5503960.0 |
> showing 50 of 326,268 rows — these rows as CSV