PREVIEW / stock_5min / 2011-10-13
file: by_date/stock_5min/2011/2011-10-13.parquet size: 4.6 MB rows: 311,925 symbols: 3,486
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-10-13 04:00:00 | AAPL | Stock | 14.4343 | 14.4343 | 14.4286 | 14.4286 | 5600.0 |
| 2011-10-13 04:20:00 | AAPL | Stock | 14.385 | 14.385 | 14.3821 | 14.3821 | 14000.0 |
| 2011-10-13 04:30:00 | AAPL | Stock | 14.3796 | 14.3796 | 14.375 | 14.375 | 17780.0 |
| 2011-10-13 04:35:00 | AAPL | Stock | 14.3689 | 14.3689 | 14.3689 | 14.3689 | 2800.0 |
| 2011-10-13 04:45:00 | AAPL | Stock | 14.37 | 14.37 | 14.37 | 14.37 | 2800.0 |
| 2011-10-13 05:25:00 | AAPL | Stock | 14.37 | 14.37 | 14.37 | 14.37 | 5600.0 |
| 2011-10-13 05:55:00 | AAPL | Stock | 14.3571 | 14.3571 | 14.3571 | 14.3571 | 2800.0 |
| 2011-10-13 06:40:00 | AAPL | Stock | 14.3414 | 14.3414 | 14.3414 | 14.3414 | 5600.0 |
| 2011-10-13 06:55:00 | AAPL | Stock | 14.3414 | 14.3571 | 14.3414 | 14.3571 | 6300.0 |
| 2011-10-13 07:05:00 | AAPL | Stock | 14.3464 | 14.3464 | 14.3314 | 14.3314 | 30800.0 |
| 2011-10-13 07:15:00 | AAPL | Stock | 14.3325 | 14.3461 | 14.3314 | 14.3314 | 16800.0 |
| 2011-10-13 07:20:00 | AAPL | Stock | 14.3357 | 14.35 | 14.3357 | 14.3411 | 45220.0 |
| 2011-10-13 07:25:00 | AAPL | Stock | 14.3464 | 14.3482 | 14.3314 | 14.3314 | 56000.0 |
| 2011-10-13 07:30:00 | AAPL | Stock | 14.3379 | 14.3379 | 14.3214 | 14.3214 | 50400.0 |
| 2011-10-13 07:35:00 | AAPL | Stock | 14.3218 | 14.3218 | 14.3214 | 14.3214 | 11200.0 |
| 2011-10-13 07:40:00 | AAPL | Stock | 14.3111 | 14.3218 | 14.3111 | 14.3218 | 56000.0 |
| 2011-10-13 07:45:00 | AAPL | Stock | 14.3304 | 14.3311 | 14.3214 | 14.3214 | 28000.0 |
| 2011-10-13 07:50:00 | AAPL | Stock | 14.3214 | 14.3293 | 14.3214 | 14.3218 | 11200.0 |
| 2011-10-13 07:55:00 | AAPL | Stock | 14.3279 | 14.3396 | 14.3279 | 14.3361 | 30800.0 |
| 2011-10-13 08:00:00 | AAPL | Stock | 14.3268 | 14.3407 | 14.3268 | 14.3382 | 176316.0 |
| 2011-10-13 08:05:00 | AAPL | Stock | 14.3375 | 14.3386 | 14.3214 | 14.3314 | 168000.0 |
| 2011-10-13 08:10:00 | AAPL | Stock | 14.3286 | 14.3332 | 14.3161 | 14.3289 | 156296.0 |
| 2011-10-13 08:15:00 | AAPL | Stock | 14.3311 | 14.3571 | 14.3311 | 14.3571 | 168280.0 |
| 2011-10-13 08:20:00 | AAPL | Stock | 14.3568 | 14.4282 | 14.3561 | 14.4107 | 570584.0 |
| 2011-10-13 08:25:00 | AAPL | Stock | 14.4107 | 14.4286 | 14.4007 | 14.4236 | 411236.0 |
| 2011-10-13 08:30:00 | AAPL | Stock | 14.4286 | 14.4475 | 14.4025 | 14.4464 | 586656.0 |
| 2011-10-13 08:35:00 | AAPL | Stock | 14.4464 | 14.4746 | 14.44 | 14.4671 | 654808.0 |
| 2011-10-13 08:40:00 | AAPL | Stock | 14.4679 | 14.4861 | 14.4575 | 14.4736 | 1007244.0 |
| 2011-10-13 08:45:00 | AAPL | Stock | 14.4736 | 14.4886 | 14.4682 | 14.4886 | 324576.0 |
| 2011-10-13 08:50:00 | AAPL | Stock | 14.4814 | 14.4839 | 14.4571 | 14.4614 | 466088.0 |
| 2011-10-13 08:55:00 | AAPL | Stock | 14.4614 | 14.4711 | 14.4475 | 14.4607 | 382956.0 |
| 2011-10-13 09:00:00 | AAPL | Stock | 14.4625 | 14.4775 | 14.4579 | 14.4732 | 150948.0 |
| 2011-10-13 09:05:00 | AAPL | Stock | 14.4661 | 14.4818 | 14.4661 | 14.4757 | 424732.0 |
| 2011-10-13 09:10:00 | AAPL | Stock | 14.4757 | 14.4911 | 14.4746 | 14.4857 | 252420.0 |
| 2011-10-13 09:15:00 | AAPL | Stock | 14.4821 | 14.4821 | 14.4611 | 14.4611 | 844732.0 |
| 2011-10-13 09:20:00 | AAPL | Stock | 14.4643 | 14.4729 | 14.4607 | 14.4729 | 242900.0 |
| 2011-10-13 09:25:00 | AAPL | Stock | 14.4657 | 14.475 | 14.4543 | 14.4643 | 659680.0 |
| 2011-10-13 09:30:00 | AAPL | Stock | 14.465 | 14.5054 | 14.415 | 14.4264 | 23792748.0 |
| 2011-10-13 09:35:00 | AAPL | Stock | 14.4279 | 14.4382 | 14.3875 | 14.4143 | 13530860.0 |
| 2011-10-13 09:40:00 | AAPL | Stock | 14.4121 | 14.4457 | 14.41 | 14.4236 | 10459960.0 |
| 2011-10-13 09:45:00 | AAPL | Stock | 14.4231 | 14.4636 | 14.4039 | 14.46 | 12966296.0 |
| 2011-10-13 09:50:00 | AAPL | Stock | 14.46 | 14.4618 | 14.4011 | 14.4289 | 7063532.0 |
| 2011-10-13 09:55:00 | AAPL | Stock | 14.4326 | 14.4661 | 14.4121 | 14.455 | 8813224.0 |
| 2011-10-13 10:00:00 | AAPL | Stock | 14.4543 | 14.4732 | 14.4268 | 14.4593 | 10075604.0 |
| 2011-10-13 10:05:00 | AAPL | Stock | 14.4597 | 14.4946 | 14.4561 | 14.4843 | 10439548.0 |
| 2011-10-13 10:10:00 | AAPL | Stock | 14.485 | 14.5239 | 14.4825 | 14.4893 | 12259576.0 |
| 2011-10-13 10:15:00 | AAPL | Stock | 14.4889 | 14.5 | 14.4757 | 14.4861 | 4774532.0 |
| 2011-10-13 10:20:00 | AAPL | Stock | 14.4843 | 14.5086 | 14.4804 | 14.5064 | 5010684.0 |
| 2011-10-13 10:25:00 | AAPL | Stock | 14.5064 | 14.5154 | 14.495 | 14.5014 | 5141472.0 |
| 2011-10-13 10:30:00 | AAPL | Stock | 14.4996 | 14.5321 | 14.495 | 14.53 | 6245736.0 |
> showing 50 of 311,925 rows — these rows as CSV