PREVIEW / stock_5min / 2014-04-16
file: by_date/stock_5min/2014/2014-04-16.parquet size: 5.3 MB rows: 353,545 symbols: 3,545
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-16 04:05:00 | AAPL | Stock | 18.5436 | 18.5436 | 18.5436 | 18.5436 | 2800.0 |
| 2014-04-16 04:55:00 | AAPL | Stock | 18.5464 | 18.5464 | 18.5464 | 18.5464 | 2800.0 |
| 2014-04-16 05:05:00 | AAPL | Stock | 18.5464 | 18.5464 | 18.5464 | 18.5464 | 2800.0 |
| 2014-04-16 05:35:00 | AAPL | Stock | 18.5536 | 18.5536 | 18.5536 | 18.5536 | 5600.0 |
| 2014-04-16 05:40:00 | AAPL | Stock | 18.5679 | 18.5714 | 18.5679 | 18.5714 | 12572.0 |
| 2014-04-16 06:00:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 2800.0 |
| 2014-04-16 06:10:00 | AAPL | Stock | 18.5536 | 18.5536 | 18.5536 | 18.5536 | 3080.0 |
| 2014-04-16 06:30:00 | AAPL | Stock | 18.5571 | 18.5571 | 18.5571 | 18.5571 | 2800.0 |
| 2014-04-16 06:50:00 | AAPL | Stock | 18.5571 | 18.5571 | 18.5536 | 18.5536 | 7000.0 |
| 2014-04-16 07:00:00 | AAPL | Stock | 18.5693 | 18.5711 | 18.5693 | 18.5711 | 11200.0 |
| 2014-04-16 07:15:00 | AAPL | Stock | 18.5707 | 18.5707 | 18.5707 | 18.5707 | 2800.0 |
| 2014-04-16 07:35:00 | AAPL | Stock | 18.5536 | 18.5536 | 18.55 | 18.55 | 22540.0 |
| 2014-04-16 07:40:00 | AAPL | Stock | 18.55 | 18.5793 | 18.55 | 18.5793 | 23128.0 |
| 2014-04-16 07:45:00 | AAPL | Stock | 18.5721 | 18.5721 | 18.5721 | 18.5721 | 15316.0 |
| 2014-04-16 07:50:00 | AAPL | Stock | 18.5721 | 18.5736 | 18.5711 | 18.5736 | 28560.0 |
| 2014-04-16 08:00:00 | AAPL | Stock | 18.5764 | 18.5875 | 18.5375 | 18.5693 | 84756.0 |
| 2014-04-16 08:05:00 | AAPL | Stock | 18.5811 | 18.5811 | 18.5579 | 18.5579 | 54796.0 |
| 2014-04-16 08:10:00 | AAPL | Stock | 18.5618 | 18.5621 | 18.5618 | 18.5621 | 10080.0 |
| 2014-04-16 08:15:00 | AAPL | Stock | 18.5446 | 18.5446 | 18.5446 | 18.5446 | 2800.0 |
| 2014-04-16 08:20:00 | AAPL | Stock | 18.5389 | 18.5414 | 18.5357 | 18.5357 | 33488.0 |
| 2014-04-16 08:25:00 | AAPL | Stock | 18.5254 | 18.5354 | 18.5189 | 18.5354 | 78848.0 |
| 2014-04-16 08:30:00 | AAPL | Stock | 18.5268 | 18.5268 | 18.5182 | 18.5182 | 30800.0 |
| 2014-04-16 08:35:00 | AAPL | Stock | 18.5357 | 18.5357 | 18.5193 | 18.5268 | 34972.0 |
| 2014-04-16 08:40:00 | AAPL | Stock | 18.5268 | 18.5325 | 18.5196 | 18.5196 | 25200.0 |
| 2014-04-16 08:45:00 | AAPL | Stock | 18.5146 | 18.5154 | 18.4857 | 18.4929 | 127568.0 |
| 2014-04-16 08:50:00 | AAPL | Stock | 18.4857 | 18.4993 | 18.485 | 18.4964 | 39844.0 |
| 2014-04-16 08:55:00 | AAPL | Stock | 18.4993 | 18.4993 | 18.4886 | 18.4886 | 36400.0 |
| 2014-04-16 09:00:00 | AAPL | Stock | 18.4886 | 18.5036 | 18.4886 | 18.4929 | 138180.0 |
| 2014-04-16 09:05:00 | AAPL | Stock | 18.4971 | 18.4979 | 18.4929 | 18.4929 | 21000.0 |
| 2014-04-16 09:10:00 | AAPL | Stock | 18.4929 | 18.4929 | 18.4893 | 18.4911 | 15148.0 |
| 2014-04-16 09:15:00 | AAPL | Stock | 18.4986 | 18.4986 | 18.4929 | 18.4946 | 49000.0 |
| 2014-04-16 09:20:00 | AAPL | Stock | 18.4946 | 18.5089 | 18.4929 | 18.5079 | 118468.0 |
| 2014-04-16 09:25:00 | AAPL | Stock | 18.5107 | 18.5143 | 18.5025 | 18.5086 | 98448.0 |
| 2014-04-16 09:30:00 | AAPL | Stock | 18.5018 | 18.5429 | 18.4593 | 18.4818 | 8642060.0 |
| 2014-04-16 09:35:00 | AAPL | Stock | 18.4803 | 18.4829 | 18.4257 | 18.4371 | 5554556.0 |
| 2014-04-16 09:40:00 | AAPL | Stock | 18.4418 | 18.5 | 18.4325 | 18.4957 | 3638152.0 |
| 2014-04-16 09:45:00 | AAPL | Stock | 18.4989 | 18.4989 | 18.4246 | 18.4318 | 3913308.0 |
| 2014-04-16 09:50:00 | AAPL | Stock | 18.4311 | 18.4536 | 18.4268 | 18.4286 | 2256940.0 |
| 2014-04-16 09:55:00 | AAPL | Stock | 18.4304 | 18.4332 | 18.3989 | 18.4064 | 3812228.0 |
| 2014-04-16 10:00:00 | AAPL | Stock | 18.4007 | 18.4232 | 18.3868 | 18.404 | 3470096.0 |
| 2014-04-16 10:05:00 | AAPL | Stock | 18.4029 | 18.4261 | 18.3936 | 18.4096 | 1894060.0 |
| 2014-04-16 10:10:00 | AAPL | Stock | 18.41 | 18.4279 | 18.397 | 18.4004 | 1986964.0 |
| 2014-04-16 10:15:00 | AAPL | Stock | 18.4064 | 18.4279 | 18.3929 | 18.4271 | 1922256.0 |
| 2014-04-16 10:20:00 | AAPL | Stock | 18.4279 | 18.4568 | 18.4229 | 18.4391 | 3720948.0 |
| 2014-04-16 10:25:00 | AAPL | Stock | 18.4357 | 18.4593 | 18.4232 | 18.425 | 1926120.0 |
| 2014-04-16 10:30:00 | AAPL | Stock | 18.4284 | 18.4496 | 18.4182 | 18.4264 | 2296056.0 |
| 2014-04-16 10:35:00 | AAPL | Stock | 18.4286 | 18.4436 | 18.4221 | 18.4307 | 2375296.0 |
| 2014-04-16 10:40:00 | AAPL | Stock | 18.4279 | 18.4311 | 18.3732 | 18.375 | 3436076.0 |
| 2014-04-16 10:45:00 | AAPL | Stock | 18.3779 | 18.3921 | 18.362 | 18.3875 | 2512440.0 |
| 2014-04-16 10:50:00 | AAPL | Stock | 18.3879 | 18.4 | 18.3768 | 18.3875 | 2050244.0 |
> showing 50 of 353,545 rows — these rows as CSV