PREVIEW / stock_5min / 2012-08-27
file: by_date/stock_5min/2012/2012-08-27.parquet size: 4.5 MB rows: 307,499 symbols: 3,456
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 |
|---|---|---|---|---|---|---|---|
| 2012-08-27 04:00:00 | AAPL | Stock | 24.1425 | 24.2496 | 24.1425 | 24.2036 | 104356.0 |
| 2012-08-27 04:05:00 | AAPL | Stock | 24.2036 | 24.2214 | 24.1457 | 24.1457 | 88956.0 |
| 2012-08-27 04:10:00 | AAPL | Stock | 24.1732 | 24.1786 | 24.1729 | 24.1786 | 42224.0 |
| 2012-08-27 04:15:00 | AAPL | Stock | 24.2025 | 24.2025 | 24.2025 | 24.2025 | 3500.0 |
| 2012-08-27 04:20:00 | AAPL | Stock | 24.175 | 24.175 | 24.175 | 24.175 | 4424.0 |
| 2012-08-27 04:25:00 | AAPL | Stock | 24.2061 | 24.2061 | 24.2061 | 24.2061 | 5600.0 |
| 2012-08-27 04:30:00 | AAPL | Stock | 24.2486 | 24.2496 | 24.2486 | 24.2496 | 6496.0 |
| 2012-08-27 04:35:00 | AAPL | Stock | 24.2496 | 24.2496 | 24.2496 | 24.2496 | 2800.0 |
| 2012-08-27 04:40:00 | AAPL | Stock | 24.2171 | 24.2496 | 24.2171 | 24.2496 | 20384.0 |
| 2012-08-27 04:45:00 | AAPL | Stock | 24.2496 | 24.2496 | 24.2496 | 24.2496 | 11200.0 |
| 2012-08-27 04:50:00 | AAPL | Stock | 24.2293 | 24.2461 | 24.2286 | 24.2461 | 16520.0 |
| 2012-08-27 04:55:00 | AAPL | Stock | 24.2461 | 24.2461 | 24.2461 | 24.2461 | 2800.0 |
| 2012-08-27 05:00:00 | AAPL | Stock | 24.2457 | 24.2457 | 24.2457 | 24.2457 | 2800.0 |
| 2012-08-27 05:05:00 | AAPL | Stock | 24.2457 | 24.2457 | 24.2457 | 24.2457 | 8792.0 |
| 2012-08-27 05:10:00 | AAPL | Stock | 24.25 | 24.2571 | 24.25 | 24.25 | 41692.0 |
| 2012-08-27 05:15:00 | AAPL | Stock | 24.25 | 24.2575 | 24.25 | 24.25 | 31360.0 |
| 2012-08-27 05:20:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 32508.0 |
| 2012-08-27 05:25:00 | AAPL | Stock | 24.2482 | 24.25 | 24.2482 | 24.2482 | 27580.0 |
| 2012-08-27 05:30:00 | AAPL | Stock | 24.2464 | 24.2464 | 24.2464 | 24.2464 | 2800.0 |
| 2012-08-27 05:35:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 7392.0 |
| 2012-08-27 05:50:00 | AAPL | Stock | 24.2532 | 24.255 | 24.2532 | 24.255 | 22120.0 |
| 2012-08-27 05:55:00 | AAPL | Stock | 24.2554 | 24.2554 | 24.2554 | 24.2554 | 14000.0 |
| 2012-08-27 06:00:00 | AAPL | Stock | 24.2554 | 24.2554 | 24.2429 | 24.2429 | 50400.0 |
| 2012-08-27 06:05:00 | AAPL | Stock | 24.2429 | 24.2464 | 24.2429 | 24.2429 | 25200.0 |
| 2012-08-27 06:15:00 | AAPL | Stock | 24.2443 | 24.2443 | 24.2443 | 24.2443 | 8400.0 |
| 2012-08-27 06:20:00 | AAPL | Stock | 24.2446 | 24.2446 | 24.2446 | 24.2446 | 2800.0 |
| 2012-08-27 06:25:00 | AAPL | Stock | 24.2461 | 24.2479 | 24.2446 | 24.2446 | 37184.0 |
| 2012-08-27 06:35:00 | AAPL | Stock | 24.2411 | 24.2411 | 24.2321 | 24.2321 | 106316.0 |
| 2012-08-27 06:40:00 | AAPL | Stock | 24.2268 | 24.2268 | 24.1982 | 24.2089 | 132944.0 |
| 2012-08-27 06:45:00 | AAPL | Stock | 24.2089 | 24.2089 | 24.165 | 24.165 | 28168.0 |
| 2012-08-27 06:50:00 | AAPL | Stock | 24.1768 | 24.2107 | 24.1768 | 24.2054 | 184604.0 |
| 2012-08-27 07:00:00 | AAPL | Stock | 24.2143 | 24.3286 | 24.1896 | 24.2846 | 764736.0 |
| 2012-08-27 07:05:00 | AAPL | Stock | 24.2846 | 24.3036 | 24.25 | 24.2571 | 169232.0 |
| 2012-08-27 07:10:00 | AAPL | Stock | 24.25 | 24.2679 | 24.2468 | 24.25 | 242396.0 |
| 2012-08-27 07:15:00 | AAPL | Stock | 24.25 | 24.3321 | 24.25 | 24.3321 | 247128.0 |
| 2012-08-27 07:20:00 | AAPL | Stock | 24.3214 | 24.3357 | 24.2961 | 24.3214 | 199164.0 |
| 2012-08-27 07:25:00 | AAPL | Stock | 24.3282 | 24.3304 | 24.2964 | 24.3061 | 220668.0 |
| 2012-08-27 07:30:00 | AAPL | Stock | 24.3089 | 24.3107 | 24.2286 | 24.2386 | 675472.0 |
| 2012-08-27 07:35:00 | AAPL | Stock | 24.25 | 24.2779 | 24.25 | 24.2607 | 180656.0 |
| 2012-08-27 07:40:00 | AAPL | Stock | 24.2832 | 24.3275 | 24.2832 | 24.3214 | 134652.0 |
| 2012-08-27 07:45:00 | AAPL | Stock | 24.3264 | 24.3536 | 24.3179 | 24.35 | 489720.0 |
| 2012-08-27 07:50:00 | AAPL | Stock | 24.35 | 24.39 | 24.3464 | 24.3857 | 564592.0 |
| 2012-08-27 07:55:00 | AAPL | Stock | 24.3782 | 24.3843 | 24.2964 | 24.2964 | 628040.0 |
| 2012-08-27 08:00:00 | AAPL | Stock | 24.3125 | 24.3857 | 24.25 | 24.375 | 2164904.0 |
| 2012-08-27 08:05:00 | AAPL | Stock | 24.3754 | 24.3964 | 24.3607 | 24.3786 | 1124732.0 |
| 2012-08-27 08:10:00 | AAPL | Stock | 24.3779 | 24.3929 | 24.3596 | 24.3661 | 1031184.0 |
| 2012-08-27 08:15:00 | AAPL | Stock | 24.3714 | 24.3857 | 24.3614 | 24.3614 | 828240.0 |
| 2012-08-27 08:20:00 | AAPL | Stock | 24.3639 | 24.385 | 24.3464 | 24.3743 | 559048.0 |
| 2012-08-27 08:25:00 | AAPL | Stock | 24.3689 | 24.3786 | 24.3571 | 24.3625 | 270956.0 |
| 2012-08-27 08:30:00 | AAPL | Stock | 24.3579 | 24.3639 | 24.3482 | 24.3521 | 619584.0 |
> showing 50 of 307,499 rows — these rows as CSV