PREVIEW / stock_5min / 2013-04-18
file: by_date/stock_5min/2013/2013-04-18.parquet size: 5.0 MB rows: 330,750 symbols: 3,452
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 |
|---|---|---|---|---|---|---|---|
| 2013-04-18 04:20:00 | AAPL | Stock | 14.37 | 14.37 | 14.37 | 14.37 | 2800.0 |
| 2013-04-18 05:00:00 | AAPL | Stock | 14.3864 | 14.3921 | 14.3864 | 14.3921 | 36652.0 |
| 2013-04-18 05:20:00 | AAPL | Stock | 14.3996 | 14.3996 | 14.3996 | 14.3996 | 2800.0 |
| 2013-04-18 05:45:00 | AAPL | Stock | 14.425 | 14.4286 | 14.425 | 14.4286 | 8400.0 |
| 2013-04-18 05:55:00 | AAPL | Stock | 14.4375 | 14.4375 | 14.4375 | 14.4375 | 2800.0 |
| 2013-04-18 06:00:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 2800.0 |
| 2013-04-18 06:10:00 | AAPL | Stock | 14.4375 | 14.4375 | 14.4375 | 14.4375 | 5600.0 |
| 2013-04-18 06:30:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4107 | 14.4107 | 26768.0 |
| 2013-04-18 06:35:00 | AAPL | Stock | 14.4039 | 14.4268 | 14.4039 | 14.4268 | 16660.0 |
| 2013-04-18 06:50:00 | AAPL | Stock | 14.4111 | 14.4111 | 14.4089 | 14.4096 | 19656.0 |
| 2013-04-18 06:55:00 | AAPL | Stock | 14.4018 | 14.4286 | 14.4018 | 14.4286 | 52388.0 |
| 2013-04-18 07:00:00 | AAPL | Stock | 14.4139 | 14.4821 | 14.4139 | 14.4714 | 189364.0 |
| 2013-04-18 07:05:00 | AAPL | Stock | 14.4643 | 14.485 | 14.4643 | 14.485 | 38052.0 |
| 2013-04-18 07:10:00 | AAPL | Stock | 14.4804 | 14.5093 | 14.4804 | 14.5093 | 66416.0 |
| 2013-04-18 07:15:00 | AAPL | Stock | 14.5171 | 14.5171 | 14.4961 | 14.5107 | 58436.0 |
| 2013-04-18 07:20:00 | AAPL | Stock | 14.5 | 14.5 | 14.4911 | 14.4911 | 7000.0 |
| 2013-04-18 07:25:00 | AAPL | Stock | 14.4911 | 14.4911 | 14.4911 | 14.4911 | 5096.0 |
| 2013-04-18 07:30:00 | AAPL | Stock | 14.4907 | 14.4907 | 14.4725 | 14.4725 | 39172.0 |
| 2013-04-18 07:35:00 | AAPL | Stock | 14.475 | 14.4843 | 14.4643 | 14.4643 | 54600.0 |
| 2013-04-18 07:40:00 | AAPL | Stock | 14.4507 | 14.5089 | 14.4507 | 14.5089 | 227220.0 |
| 2013-04-18 07:45:00 | AAPL | Stock | 14.51 | 14.5182 | 14.4932 | 14.5021 | 204904.0 |
| 2013-04-18 07:50:00 | AAPL | Stock | 14.5154 | 14.5629 | 14.5145 | 14.5179 | 283472.0 |
| 2013-04-18 07:55:00 | AAPL | Stock | 14.5186 | 14.55 | 14.5175 | 14.5318 | 226996.0 |
| 2013-04-18 08:00:00 | AAPL | Stock | 14.5379 | 14.55 | 14.4286 | 14.4821 | 728756.0 |
| 2013-04-18 08:05:00 | AAPL | Stock | 14.4825 | 14.5 | 14.4821 | 14.49 | 238896.0 |
| 2013-04-18 08:10:00 | AAPL | Stock | 14.4821 | 14.4964 | 14.465 | 14.4771 | 324184.0 |
| 2013-04-18 08:15:00 | AAPL | Stock | 14.4654 | 14.4821 | 14.4629 | 14.4643 | 197512.0 |
| 2013-04-18 08:20:00 | AAPL | Stock | 14.465 | 14.465 | 14.4071 | 14.4421 | 580356.0 |
| 2013-04-18 08:25:00 | AAPL | Stock | 14.4421 | 14.4768 | 14.4411 | 14.4686 | 358428.0 |
| 2013-04-18 08:30:00 | AAPL | Stock | 14.4686 | 14.4779 | 14.4586 | 14.4586 | 322056.0 |
| 2013-04-18 08:35:00 | AAPL | Stock | 14.4586 | 14.4607 | 14.4143 | 14.4214 | 443996.0 |
| 2013-04-18 08:40:00 | AAPL | Stock | 14.4189 | 14.5 | 14.3929 | 14.4996 | 1803844.0 |
| 2013-04-18 08:45:00 | AAPL | Stock | 14.4979 | 14.515 | 14.4646 | 14.4786 | 2256324.0 |
| 2013-04-18 08:50:00 | AAPL | Stock | 14.4757 | 14.5214 | 14.4757 | 14.4936 | 261828.0 |
| 2013-04-18 08:55:00 | AAPL | Stock | 14.4979 | 14.4979 | 14.4646 | 14.4821 | 299376.0 |
| 2013-04-18 09:00:00 | AAPL | Stock | 14.4821 | 14.5268 | 14.4821 | 14.5089 | 436548.0 |
| 2013-04-18 09:05:00 | AAPL | Stock | 14.5093 | 14.5446 | 14.5089 | 14.5429 | 704340.0 |
| 2013-04-18 09:10:00 | AAPL | Stock | 14.5357 | 14.5511 | 14.5214 | 14.53 | 1474340.0 |
| 2013-04-18 09:15:00 | AAPL | Stock | 14.5193 | 14.5461 | 14.5193 | 14.5357 | 596400.0 |
| 2013-04-18 09:20:00 | AAPL | Stock | 14.5271 | 14.5275 | 14.4939 | 14.4939 | 304332.0 |
| 2013-04-18 09:25:00 | AAPL | Stock | 14.4982 | 14.5111 | 14.4536 | 14.4536 | 848428.0 |
| 2013-04-18 09:30:00 | AAPL | Stock | 14.4643 | 14.4925 | 14.3822 | 14.3889 | 24006920.0 |
| 2013-04-18 09:35:00 | AAPL | Stock | 14.3886 | 14.4157 | 14.3 | 14.3132 | 16007544.0 |
| 2013-04-18 09:40:00 | AAPL | Stock | 14.3154 | 14.3314 | 14.2368 | 14.2646 | 21604296.0 |
| 2013-04-18 09:45:00 | AAPL | Stock | 14.2657 | 14.3314 | 14.25 | 14.2686 | 15131004.0 |
| 2013-04-18 09:50:00 | AAPL | Stock | 14.2694 | 14.3107 | 14.2532 | 14.2796 | 13800052.0 |
| 2013-04-18 09:55:00 | AAPL | Stock | 14.2839 | 14.2968 | 14.25 | 14.25 | 11561732.0 |
| 2013-04-18 10:00:00 | AAPL | Stock | 14.25 | 14.2632 | 14.1186 | 14.1201 | 28647136.0 |
| 2013-04-18 10:05:00 | AAPL | Stock | 14.1202 | 14.1878 | 14.1168 | 14.1493 | 22706376.0 |
| 2013-04-18 10:10:00 | AAPL | Stock | 14.1507 | 14.2196 | 14.1464 | 14.2175 | 13278748.0 |
> showing 50 of 330,750 rows — these rows as CSV