PREVIEW / stock_5min / 2011-03-11
file: by_date/stock_5min/2011/2011-03-11.parquet size: 4.9 MB rows: 331,104 symbols: 3,488
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-03-11 04:00:00 | AAPL | Stock | 12.3246 | 12.3246 | 12.3246 | 12.3246 | 5600.0 |
| 2011-03-11 04:25:00 | AAPL | Stock | 12.2679 | 12.2679 | 12.2679 | 12.2679 | 12292.0 |
| 2011-03-11 04:40:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 8400.0 |
| 2011-03-11 04:50:00 | AAPL | Stock | 12.2661 | 12.2661 | 12.2661 | 12.2661 | 2800.0 |
| 2011-03-11 04:55:00 | AAPL | Stock | 12.2729 | 12.2729 | 12.2729 | 12.2729 | 2800.0 |
| 2011-03-11 05:00:00 | AAPL | Stock | 12.2511 | 12.2511 | 12.2511 | 12.2511 | 2800.0 |
| 2011-03-11 05:15:00 | AAPL | Stock | 12.2679 | 12.2679 | 12.2679 | 12.2679 | 7000.0 |
| 2011-03-11 05:20:00 | AAPL | Stock | 12.2236 | 12.2236 | 12.2214 | 12.2214 | 13300.0 |
| 2011-03-11 05:25:00 | AAPL | Stock | 12.2464 | 12.2489 | 12.2464 | 12.2489 | 7000.0 |
| 2011-03-11 05:30:00 | AAPL | Stock | 12.2321 | 12.2321 | 12.2286 | 12.2289 | 56000.0 |
| 2011-03-11 05:40:00 | AAPL | Stock | 12.2579 | 12.2579 | 12.2218 | 12.2475 | 148400.0 |
| 2011-03-11 05:45:00 | AAPL | Stock | 12.2468 | 12.25 | 12.2468 | 12.25 | 50400.0 |
| 2011-03-11 05:50:00 | AAPL | Stock | 12.2364 | 12.2375 | 12.2364 | 12.2375 | 28000.0 |
| 2011-03-11 06:00:00 | AAPL | Stock | 12.25 | 12.25 | 12.2464 | 12.2464 | 24920.0 |
| 2011-03-11 06:05:00 | AAPL | Stock | 12.2425 | 12.2679 | 12.2425 | 12.2679 | 93744.0 |
| 2011-03-11 06:10:00 | AAPL | Stock | 12.2679 | 12.2679 | 12.2679 | 12.2679 | 30800.0 |
| 2011-03-11 06:25:00 | AAPL | Stock | 12.2518 | 12.2518 | 12.2275 | 12.2336 | 18760.0 |
| 2011-03-11 06:30:00 | AAPL | Stock | 12.2464 | 12.2464 | 12.2464 | 12.2464 | 33600.0 |
| 2011-03-11 06:45:00 | AAPL | Stock | 12.2679 | 12.2804 | 12.2668 | 12.2804 | 25200.0 |
| 2011-03-11 06:50:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 28000.0 |
| 2011-03-11 06:55:00 | AAPL | Stock | 12.2939 | 12.2939 | 12.2939 | 12.2939 | 42000.0 |
| 2011-03-11 07:00:00 | AAPL | Stock | 12.2939 | 12.3161 | 12.2929 | 12.2943 | 92120.0 |
| 2011-03-11 07:05:00 | AAPL | Stock | 12.2943 | 12.2982 | 12.2714 | 12.2714 | 55384.0 |
| 2011-03-11 07:10:00 | AAPL | Stock | 12.2961 | 12.2961 | 12.2786 | 12.2857 | 57400.0 |
| 2011-03-11 07:15:00 | AAPL | Stock | 12.2868 | 12.2946 | 12.2864 | 12.2943 | 16800.0 |
| 2011-03-11 07:20:00 | AAPL | Stock | 12.2943 | 12.3179 | 12.2864 | 12.3111 | 75040.0 |
| 2011-03-11 07:25:00 | AAPL | Stock | 12.3118 | 12.3393 | 12.3118 | 12.325 | 101724.0 |
| 2011-03-11 07:30:00 | AAPL | Stock | 12.32 | 12.3214 | 12.3071 | 12.315 | 90160.0 |
| 2011-03-11 07:35:00 | AAPL | Stock | 12.3107 | 12.3161 | 12.3107 | 12.3114 | 36904.0 |
| 2011-03-11 07:40:00 | AAPL | Stock | 12.31 | 12.3296 | 12.31 | 12.3296 | 76524.0 |
| 2011-03-11 07:45:00 | AAPL | Stock | 12.325 | 12.325 | 12.325 | 12.325 | 2800.0 |
| 2011-03-11 07:50:00 | AAPL | Stock | 12.3368 | 12.3368 | 12.3261 | 12.3318 | 46480.0 |
| 2011-03-11 07:55:00 | AAPL | Stock | 12.3318 | 12.3318 | 12.3214 | 12.3304 | 38500.0 |
| 2011-03-11 08:00:00 | AAPL | Stock | 12.3304 | 12.375 | 12.2857 | 12.3257 | 492464.0 |
| 2011-03-11 08:05:00 | AAPL | Stock | 12.3257 | 12.3393 | 12.325 | 12.3254 | 234108.0 |
| 2011-03-11 08:10:00 | AAPL | Stock | 12.3268 | 12.3339 | 12.3225 | 12.3236 | 98980.0 |
| 2011-03-11 08:15:00 | AAPL | Stock | 12.3314 | 12.3429 | 12.3314 | 12.3429 | 236180.0 |
| 2011-03-11 08:20:00 | AAPL | Stock | 12.3464 | 12.3464 | 12.3314 | 12.3407 | 119084.0 |
| 2011-03-11 08:25:00 | AAPL | Stock | 12.3382 | 12.35 | 12.3382 | 12.35 | 91700.0 |
| 2011-03-11 08:30:00 | AAPL | Stock | 12.3496 | 12.3625 | 12.3446 | 12.3625 | 196140.0 |
| 2011-03-11 08:35:00 | AAPL | Stock | 12.3614 | 12.3643 | 12.3589 | 12.3607 | 354788.0 |
| 2011-03-11 08:40:00 | AAPL | Stock | 12.3618 | 12.3618 | 12.3554 | 12.3554 | 260960.0 |
| 2011-03-11 08:45:00 | AAPL | Stock | 12.3536 | 12.3679 | 12.3536 | 12.3611 | 653576.0 |
| 2011-03-11 08:50:00 | AAPL | Stock | 12.3607 | 12.3621 | 12.3536 | 12.3586 | 455504.0 |
| 2011-03-11 08:55:00 | AAPL | Stock | 12.3582 | 12.3636 | 12.3571 | 12.3636 | 74564.0 |
| 2011-03-11 09:00:00 | AAPL | Stock | 12.3629 | 12.3636 | 12.3604 | 12.3625 | 70532.0 |
| 2011-03-11 09:05:00 | AAPL | Stock | 12.3607 | 12.3607 | 12.3482 | 12.3482 | 204848.0 |
| 2011-03-11 09:10:00 | AAPL | Stock | 12.3514 | 12.3571 | 12.3457 | 12.3557 | 90748.0 |
| 2011-03-11 09:15:00 | AAPL | Stock | 12.3518 | 12.3518 | 12.3429 | 12.345 | 49728.0 |
| 2011-03-11 09:20:00 | AAPL | Stock | 12.345 | 12.3521 | 12.3411 | 12.3521 | 86688.0 |
> showing 50 of 331,104 rows — these rows as CSV