PREVIEW / stock_5min / 2014-01-07
file: by_date/stock_5min/2014/2014-01-07.parquet size: 5.5 MB rows: 360,961 symbols: 3,530
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-01-07 04:15:00 | AAPL | Stock | 19.4446 | 19.4446 | 19.4446 | 19.4446 | 13300.0 |
| 2014-01-07 04:45:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 2800.0 |
| 2014-01-07 05:10:00 | AAPL | Stock | 19.4764 | 19.4764 | 19.4746 | 19.4746 | 14000.0 |
| 2014-01-07 05:15:00 | AAPL | Stock | 19.4839 | 19.4839 | 19.4839 | 19.4839 | 2828.0 |
| 2014-01-07 05:25:00 | AAPL | Stock | 19.4839 | 19.4839 | 19.4839 | 19.4839 | 5740.0 |
| 2014-01-07 05:30:00 | AAPL | Stock | 19.4839 | 19.4839 | 19.4839 | 19.4839 | 15932.0 |
| 2014-01-07 05:50:00 | AAPL | Stock | 19.48 | 19.48 | 19.4436 | 19.4436 | 24836.0 |
| 2014-01-07 06:05:00 | AAPL | Stock | 19.4957 | 19.4964 | 19.4957 | 19.4964 | 5600.0 |
| 2014-01-07 06:15:00 | AAPL | Stock | 19.4925 | 19.4925 | 19.4925 | 19.4925 | 2800.0 |
| 2014-01-07 06:20:00 | AAPL | Stock | 19.4882 | 19.4882 | 19.4882 | 19.4882 | 2800.0 |
| 2014-01-07 06:35:00 | AAPL | Stock | 19.4654 | 19.4654 | 19.4643 | 19.4643 | 16800.0 |
| 2014-01-07 06:50:00 | AAPL | Stock | 19.4618 | 19.4725 | 19.4618 | 19.4725 | 19600.0 |
| 2014-01-07 06:55:00 | AAPL | Stock | 19.4732 | 19.4732 | 19.4732 | 19.4732 | 2800.0 |
| 2014-01-07 07:00:00 | AAPL | Stock | 19.475 | 19.4889 | 19.475 | 19.4889 | 16800.0 |
| 2014-01-07 07:05:00 | AAPL | Stock | 19.4918 | 19.4918 | 19.4825 | 19.4825 | 5600.0 |
| 2014-01-07 07:20:00 | AAPL | Stock | 19.4893 | 19.4925 | 19.4825 | 19.4825 | 34160.0 |
| 2014-01-07 07:30:00 | AAPL | Stock | 19.4832 | 19.4832 | 19.4768 | 19.4768 | 21280.0 |
| 2014-01-07 07:35:00 | AAPL | Stock | 19.4721 | 19.4721 | 19.4721 | 19.4721 | 2800.0 |
| 2014-01-07 07:45:00 | AAPL | Stock | 19.4782 | 19.4939 | 19.4782 | 19.4843 | 70840.0 |
| 2014-01-07 07:50:00 | AAPL | Stock | 19.4889 | 19.4893 | 19.4846 | 19.4846 | 11200.0 |
| 2014-01-07 07:55:00 | AAPL | Stock | 19.4893 | 19.4964 | 19.4846 | 19.4846 | 40964.0 |
| 2014-01-07 08:00:00 | AAPL | Stock | 19.4925 | 19.4975 | 19.4814 | 19.4964 | 347032.0 |
| 2014-01-07 08:05:00 | AAPL | Stock | 19.4882 | 19.4957 | 19.4882 | 19.4929 | 102592.0 |
| 2014-01-07 08:10:00 | AAPL | Stock | 19.4893 | 19.4975 | 19.4893 | 19.4975 | 70700.0 |
| 2014-01-07 08:15:00 | AAPL | Stock | 19.4975 | 19.4992 | 19.4768 | 19.4786 | 162092.0 |
| 2014-01-07 08:20:00 | AAPL | Stock | 19.475 | 19.475 | 19.4554 | 19.4671 | 126616.0 |
| 2014-01-07 08:25:00 | AAPL | Stock | 19.4682 | 19.4771 | 19.4661 | 19.4679 | 103096.0 |
| 2014-01-07 08:30:00 | AAPL | Stock | 19.4661 | 19.4746 | 19.4646 | 19.4746 | 59360.0 |
| 2014-01-07 08:35:00 | AAPL | Stock | 19.4657 | 19.4779 | 19.4629 | 19.4771 | 128800.0 |
| 2014-01-07 08:40:00 | AAPL | Stock | 19.4657 | 19.4786 | 19.4646 | 19.4754 | 102536.0 |
| 2014-01-07 08:45:00 | AAPL | Stock | 19.4754 | 19.4754 | 19.4575 | 19.4679 | 288260.0 |
| 2014-01-07 08:50:00 | AAPL | Stock | 19.4657 | 19.4732 | 19.4643 | 19.4732 | 225120.0 |
| 2014-01-07 08:55:00 | AAPL | Stock | 19.4721 | 19.4729 | 19.4643 | 19.4643 | 150108.0 |
| 2014-01-07 09:00:00 | AAPL | Stock | 19.4646 | 19.4661 | 19.4504 | 19.4504 | 233856.0 |
| 2014-01-07 09:05:00 | AAPL | Stock | 19.4611 | 19.4611 | 19.4543 | 19.4575 | 41104.0 |
| 2014-01-07 09:10:00 | AAPL | Stock | 19.4575 | 19.4607 | 19.4575 | 19.46 | 61600.0 |
| 2014-01-07 09:15:00 | AAPL | Stock | 19.4586 | 19.4604 | 19.4514 | 19.4514 | 78288.0 |
| 2014-01-07 09:20:00 | AAPL | Stock | 19.4511 | 19.4511 | 19.4268 | 19.4268 | 253792.0 |
| 2014-01-07 09:25:00 | AAPL | Stock | 19.4361 | 19.445 | 19.4164 | 19.4318 | 364280.0 |
| 2014-01-07 09:30:00 | AAPL | Stock | 19.44 | 19.4454 | 19.3407 | 19.3639 | 13902308.0 |
| 2014-01-07 09:35:00 | AAPL | Stock | 19.3661 | 19.4068 | 19.3134 | 19.3357 | 8767360.0 |
| 2014-01-07 09:40:00 | AAPL | Stock | 19.3354 | 19.3443 | 19.2907 | 19.3193 | 6619760.0 |
| 2014-01-07 09:45:00 | AAPL | Stock | 19.3175 | 19.3457 | 19.2961 | 19.3243 | 5434912.0 |
| 2014-01-07 09:50:00 | AAPL | Stock | 19.3261 | 19.3282 | 19.2825 | 19.3068 | 12405064.0 |
| 2014-01-07 09:55:00 | AAPL | Stock | 19.3029 | 19.3714 | 19.2925 | 19.3671 | 7635488.0 |
| 2014-01-07 10:00:00 | AAPL | Stock | 19.3714 | 19.4157 | 19.3671 | 19.3918 | 8452640.0 |
| 2014-01-07 10:05:00 | AAPL | Stock | 19.3968 | 19.4546 | 19.3786 | 19.4539 | 6110664.0 |
| 2014-01-07 10:10:00 | AAPL | Stock | 19.4539 | 19.4786 | 19.4443 | 19.4643 | 6305964.0 |
| 2014-01-07 10:15:00 | AAPL | Stock | 19.4643 | 19.4786 | 19.4493 | 19.4682 | 4888632.0 |
| 2014-01-07 10:20:00 | AAPL | Stock | 19.4693 | 19.4986 | 19.4614 | 19.4818 | 4696888.0 |
> showing 50 of 360,961 rows — these rows as CSV