PREVIEW / stock_5min / 2013-06-24
file: by_date/stock_5min/2013/2013-06-24.parquet size: 5.5 MB rows: 364,856 symbols: 3,521
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-06-24 04:00:00 | AAPL | Stock | 14.7143 | 14.7304 | 14.7143 | 14.7304 | 11200.0 |
| 2013-06-24 04:10:00 | AAPL | Stock | 14.6786 | 14.6786 | 14.6786 | 14.6786 | 2800.0 |
| 2013-06-24 04:15:00 | AAPL | Stock | 14.6825 | 14.6825 | 14.6825 | 14.6825 | 2800.0 |
| 2013-06-24 04:35:00 | AAPL | Stock | 14.6589 | 14.6589 | 14.6589 | 14.6589 | 2800.0 |
| 2013-06-24 04:50:00 | AAPL | Stock | 14.6536 | 14.6589 | 14.6536 | 14.6589 | 14112.0 |
| 2013-06-24 05:05:00 | AAPL | Stock | 14.6432 | 14.6432 | 14.6429 | 14.6429 | 21336.0 |
| 2013-06-24 06:20:00 | AAPL | Stock | 14.6429 | 14.6429 | 14.6429 | 14.6429 | 5600.0 |
| 2013-06-24 06:30:00 | AAPL | Stock | 14.6321 | 14.6321 | 14.6321 | 14.6321 | 2800.0 |
| 2013-06-24 06:35:00 | AAPL | Stock | 14.6064 | 14.625 | 14.5896 | 14.595 | 30968.0 |
| 2013-06-24 06:40:00 | AAPL | Stock | 14.6071 | 14.6071 | 14.6071 | 14.6071 | 14000.0 |
| 2013-06-24 06:45:00 | AAPL | Stock | 14.5954 | 14.5954 | 14.5954 | 14.5954 | 2800.0 |
| 2013-06-24 06:55:00 | AAPL | Stock | 14.6 | 14.6 | 14.6 | 14.6 | 2800.0 |
| 2013-06-24 07:00:00 | AAPL | Stock | 14.6107 | 14.6111 | 14.6 | 14.6 | 16296.0 |
| 2013-06-24 07:05:00 | AAPL | Stock | 14.6068 | 14.6196 | 14.6068 | 14.6196 | 49784.0 |
| 2013-06-24 07:10:00 | AAPL | Stock | 14.6196 | 14.6196 | 14.6196 | 14.6196 | 2800.0 |
| 2013-06-24 07:15:00 | AAPL | Stock | 14.6196 | 14.6196 | 14.6196 | 14.6196 | 5600.0 |
| 2013-06-24 07:20:00 | AAPL | Stock | 14.6125 | 14.6125 | 14.5964 | 14.5964 | 30800.0 |
| 2013-06-24 07:25:00 | AAPL | Stock | 14.6014 | 14.6018 | 14.5968 | 14.5968 | 36204.0 |
| 2013-06-24 07:30:00 | AAPL | Stock | 14.5957 | 14.5957 | 14.5693 | 14.5714 | 88760.0 |
| 2013-06-24 07:35:00 | AAPL | Stock | 14.5696 | 14.5714 | 14.5271 | 14.5536 | 149352.0 |
| 2013-06-24 07:40:00 | AAPL | Stock | 14.5693 | 14.5714 | 14.5371 | 14.5543 | 73360.0 |
| 2013-06-24 07:45:00 | AAPL | Stock | 14.5689 | 14.5714 | 14.5561 | 14.5607 | 19600.0 |
| 2013-06-24 07:50:00 | AAPL | Stock | 14.5661 | 14.5754 | 14.5661 | 14.5754 | 16800.0 |
| 2013-06-24 07:55:00 | AAPL | Stock | 14.5786 | 14.5786 | 14.5689 | 14.5689 | 28000.0 |
| 2013-06-24 08:00:00 | AAPL | Stock | 14.5714 | 14.75 | 14.5357 | 14.5714 | 408744.0 |
| 2013-06-24 08:05:00 | AAPL | Stock | 14.5682 | 14.5714 | 14.5607 | 14.5643 | 55692.0 |
| 2013-06-24 08:10:00 | AAPL | Stock | 14.5714 | 14.5714 | 14.5539 | 14.5625 | 51492.0 |
| 2013-06-24 08:15:00 | AAPL | Stock | 14.5625 | 14.5625 | 14.5379 | 14.5536 | 243208.0 |
| 2013-06-24 08:20:00 | AAPL | Stock | 14.5536 | 14.5607 | 14.5432 | 14.5536 | 88200.0 |
| 2013-06-24 08:25:00 | AAPL | Stock | 14.5536 | 14.5536 | 14.5429 | 14.5429 | 30800.0 |
| 2013-06-24 08:30:00 | AAPL | Stock | 14.5443 | 14.5539 | 14.5393 | 14.55 | 144004.0 |
| 2013-06-24 08:35:00 | AAPL | Stock | 14.5468 | 14.5536 | 14.5446 | 14.5496 | 130060.0 |
| 2013-06-24 08:40:00 | AAPL | Stock | 14.5529 | 14.5714 | 14.5471 | 14.5693 | 315420.0 |
| 2013-06-24 08:45:00 | AAPL | Stock | 14.5675 | 14.5886 | 14.5675 | 14.5882 | 207844.0 |
| 2013-06-24 08:50:00 | AAPL | Stock | 14.5893 | 14.6018 | 14.5886 | 14.5961 | 365316.0 |
| 2013-06-24 08:55:00 | AAPL | Stock | 14.5982 | 14.6129 | 14.5929 | 14.6032 | 385532.0 |
| 2013-06-24 09:00:00 | AAPL | Stock | 14.6 | 14.6014 | 14.5804 | 14.5811 | 284928.0 |
| 2013-06-24 09:05:00 | AAPL | Stock | 14.5714 | 14.58 | 14.5618 | 14.5704 | 262584.0 |
| 2013-06-24 09:10:00 | AAPL | Stock | 14.5693 | 14.5704 | 14.5518 | 14.5518 | 158368.0 |
| 2013-06-24 09:15:00 | AAPL | Stock | 14.55 | 14.5689 | 14.5464 | 14.5668 | 161056.0 |
| 2013-06-24 09:20:00 | AAPL | Stock | 14.5639 | 14.5664 | 14.5632 | 14.5632 | 43820.0 |
| 2013-06-24 09:25:00 | AAPL | Stock | 14.5557 | 14.5696 | 14.5461 | 14.5504 | 516376.0 |
| 2013-06-24 09:30:00 | AAPL | Stock | 14.55 | 14.595 | 14.4429 | 14.4611 | 19889884.0 |
| 2013-06-24 09:35:00 | AAPL | Stock | 14.4528 | 14.5064 | 14.445 | 14.462 | 11298644.0 |
| 2013-06-24 09:40:00 | AAPL | Stock | 14.4611 | 14.5032 | 14.43 | 14.4675 | 8322664.0 |
| 2013-06-24 09:45:00 | AAPL | Stock | 14.4664 | 14.5032 | 14.4429 | 14.4866 | 8719060.0 |
| 2013-06-24 09:50:00 | AAPL | Stock | 14.4854 | 14.4893 | 14.3664 | 14.3768 | 15422904.0 |
| 2013-06-24 09:55:00 | AAPL | Stock | 14.3755 | 14.3932 | 14.3336 | 14.3696 | 13396628.0 |
| 2013-06-24 10:00:00 | AAPL | Stock | 14.3682 | 14.3807 | 14.3332 | 14.3804 | 8542660.0 |
| 2013-06-24 10:05:00 | AAPL | Stock | 14.3793 | 14.38 | 14.3321 | 14.3679 | 8542884.0 |
> showing 50 of 364,856 rows — these rows as CSV