PREVIEW / stock_5min / 2014-04-15
file: by_date/stock_5min/2014/2014-04-15.parquet size: 5.6 MB rows: 368,182 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-15 07:20:00 | AAPL | Stock | 18.6661 | 18.6786 | 18.6661 | 18.6786 | 33432.0 |
| 2014-04-15 07:50:00 | AAPL | Stock | 18.6571 | 18.6607 | 18.65 | 18.6607 | 11200.0 |
| 2014-04-15 08:00:00 | AAPL | Stock | 18.6518 | 18.6693 | 18.6446 | 18.6607 | 71400.0 |
| 2014-04-15 08:05:00 | AAPL | Stock | 18.6636 | 18.6636 | 18.6514 | 18.6514 | 9156.0 |
| 2014-04-15 08:10:00 | AAPL | Stock | 18.6607 | 18.6611 | 18.6571 | 18.6611 | 15316.0 |
| 2014-04-15 08:20:00 | AAPL | Stock | 18.6518 | 18.6518 | 18.6482 | 18.6482 | 31920.0 |
| 2014-04-15 08:25:00 | AAPL | Stock | 18.6536 | 18.6536 | 18.6536 | 18.6536 | 2800.0 |
| 2014-04-15 08:30:00 | AAPL | Stock | 18.6464 | 18.6464 | 18.625 | 18.6407 | 76608.0 |
| 2014-04-15 08:35:00 | AAPL | Stock | 18.6261 | 18.6261 | 18.615 | 18.615 | 42000.0 |
| 2014-04-15 08:40:00 | AAPL | Stock | 18.6232 | 18.6232 | 18.6232 | 18.6232 | 19600.0 |
| 2014-04-15 08:45:00 | AAPL | Stock | 18.625 | 18.625 | 18.6068 | 18.615 | 36400.0 |
| 2014-04-15 08:50:00 | AAPL | Stock | 18.6093 | 18.6143 | 18.6093 | 18.6107 | 34468.0 |
| 2014-04-15 08:55:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.5932 | 18.5968 | 46200.0 |
| 2014-04-15 09:00:00 | AAPL | Stock | 18.5964 | 18.5982 | 18.595 | 18.5968 | 61656.0 |
| 2014-04-15 09:05:00 | AAPL | Stock | 18.5918 | 18.5918 | 18.5714 | 18.5714 | 133588.0 |
| 2014-04-15 09:10:00 | AAPL | Stock | 18.5839 | 18.5857 | 18.5804 | 18.585 | 39928.0 |
| 2014-04-15 09:15:00 | AAPL | Stock | 18.5814 | 18.585 | 18.5814 | 18.5814 | 16800.0 |
| 2014-04-15 09:20:00 | AAPL | Stock | 18.5839 | 18.5839 | 18.5739 | 18.5739 | 14000.0 |
| 2014-04-15 09:25:00 | AAPL | Stock | 18.5825 | 18.5825 | 18.5561 | 18.5679 | 133700.0 |
| 2014-04-15 09:30:00 | AAPL | Stock | 18.5811 | 18.5986 | 18.5215 | 18.5454 | 6563900.0 |
| 2014-04-15 09:35:00 | AAPL | Stock | 18.5482 | 18.6057 | 18.5339 | 18.5868 | 4165056.0 |
| 2014-04-15 09:40:00 | AAPL | Stock | 18.5886 | 18.6061 | 18.5736 | 18.6039 | 2398228.0 |
| 2014-04-15 09:45:00 | AAPL | Stock | 18.6043 | 18.63 | 18.5996 | 18.6129 | 3226944.0 |
| 2014-04-15 09:50:00 | AAPL | Stock | 18.6154 | 18.6189 | 18.6014 | 18.6152 | 2873892.0 |
| 2014-04-15 09:55:00 | AAPL | Stock | 18.6129 | 18.6159 | 18.5779 | 18.5846 | 2361660.0 |
| 2014-04-15 10:00:00 | AAPL | Stock | 18.5839 | 18.6139 | 18.5839 | 18.5982 | 2133040.0 |
| 2014-04-15 10:05:00 | AAPL | Stock | 18.5968 | 18.6139 | 18.5779 | 18.5836 | 2073316.0 |
| 2014-04-15 10:10:00 | AAPL | Stock | 18.5825 | 18.5839 | 18.5593 | 18.5664 | 2858380.0 |
| 2014-04-15 10:15:00 | AAPL | Stock | 18.5636 | 18.5764 | 18.5296 | 18.5311 | 2546684.0 |
| 2014-04-15 10:20:00 | AAPL | Stock | 18.5293 | 18.5328 | 18.4732 | 18.4732 | 5908308.0 |
| 2014-04-15 10:25:00 | AAPL | Stock | 18.4732 | 18.5061 | 18.4721 | 18.4986 | 4664660.0 |
| 2014-04-15 10:30:00 | AAPL | Stock | 18.4961 | 18.4964 | 18.4425 | 18.4579 | 5619124.0 |
| 2014-04-15 10:35:00 | AAPL | Stock | 18.4564 | 18.4904 | 18.45 | 18.4796 | 4636520.0 |
| 2014-04-15 10:40:00 | AAPL | Stock | 18.4807 | 18.5161 | 18.4736 | 18.4839 | 2599324.0 |
| 2014-04-15 10:45:00 | AAPL | Stock | 18.4839 | 18.4914 | 18.4629 | 18.4764 | 3078152.0 |
| 2014-04-15 10:50:00 | AAPL | Stock | 18.4764 | 18.4875 | 18.4224 | 18.4238 | 2900772.0 |
| 2014-04-15 10:55:00 | AAPL | Stock | 18.4278 | 18.4293 | 18.3704 | 18.3811 | 5851076.0 |
| 2014-04-15 11:00:00 | AAPL | Stock | 18.3771 | 18.3886 | 18.3571 | 18.3809 | 3419780.0 |
| 2014-04-15 11:05:00 | AAPL | Stock | 18.3832 | 18.4182 | 18.3807 | 18.4054 | 2946552.0 |
| 2014-04-15 11:10:00 | AAPL | Stock | 18.4064 | 18.435 | 18.4 | 18.4121 | 1881348.0 |
| 2014-04-15 11:15:00 | AAPL | Stock | 18.4157 | 18.4311 | 18.4021 | 18.4207 | 2016812.0 |
| 2014-04-15 11:20:00 | AAPL | Stock | 18.4193 | 18.4375 | 18.4154 | 18.4225 | 1827868.0 |
| 2014-04-15 11:25:00 | AAPL | Stock | 18.4247 | 18.4318 | 18.3961 | 18.4096 | 1977024.0 |
| 2014-04-15 11:30:00 | AAPL | Stock | 18.4135 | 18.45 | 18.4054 | 18.4432 | 1875328.0 |
| 2014-04-15 11:35:00 | AAPL | Stock | 18.4432 | 18.4432 | 18.4207 | 18.4207 | 1907920.0 |
| 2014-04-15 11:40:00 | AAPL | Stock | 18.4207 | 18.4332 | 18.3954 | 18.4061 | 1487808.0 |
| 2014-04-15 11:45:00 | AAPL | Stock | 18.4068 | 18.4225 | 18.3804 | 18.3929 | 2370088.0 |
| 2014-04-15 11:50:00 | AAPL | Stock | 18.3929 | 18.4079 | 18.3768 | 18.3918 | 1743784.0 |
| 2014-04-15 11:55:00 | AAPL | Stock | 18.3925 | 18.4036 | 18.3575 | 18.3575 | 3258304.0 |
| 2014-04-15 12:00:00 | AAPL | Stock | 18.3632 | 18.3639 | 18.3314 | 18.3446 | 3728144.0 |
> showing 50 of 368,182 rows — these rows as CSV