PREVIEW / stock_5min / 2014-07-21
file: by_date/stock_5min/2014/2014-07-21.parquet size: 5.2 MB rows: 350,424 symbols: 3,570
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-07-21 04:00:00 | AAPL | Stock | 23.625 | 23.625 | 23.5725 | 23.5725 | 4480.0 |
| 2014-07-21 04:05:00 | AAPL | Stock | 23.5625 | 23.6125 | 23.5625 | 23.6125 | 12800.0 |
| 2014-07-21 04:10:00 | AAPL | Stock | 23.6225 | 23.665 | 23.6225 | 23.65 | 26860.0 |
| 2014-07-21 04:15:00 | AAPL | Stock | 23.7125 | 23.7125 | 23.7125 | 23.7125 | 5600.0 |
| 2014-07-21 04:20:00 | AAPL | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 2000.0 |
| 2014-07-21 04:25:00 | AAPL | Stock | 23.7 | 23.75 | 23.7 | 23.75 | 3400.0 |
| 2014-07-21 04:40:00 | AAPL | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 4364.0 |
| 2014-07-21 04:55:00 | AAPL | Stock | 23.7775 | 23.79 | 23.7775 | 23.79 | 4036.0 |
| 2014-07-21 05:05:00 | AAPL | Stock | 23.7875 | 23.79 | 23.7875 | 23.79 | 1600.0 |
| 2014-07-21 05:10:00 | AAPL | Stock | 23.8 | 23.805 | 23.7975 | 23.7975 | 4800.0 |
| 2014-07-21 05:15:00 | AAPL | Stock | 23.805 | 23.8125 | 23.775 | 23.8 | 27240.0 |
| 2014-07-21 05:35:00 | AAPL | Stock | 23.815 | 23.815 | 23.81 | 23.8125 | 6256.0 |
| 2014-07-21 05:45:00 | AAPL | Stock | 23.8125 | 23.8125 | 23.8125 | 23.8125 | 800.0 |
| 2014-07-21 05:50:00 | AAPL | Stock | 23.7875 | 23.7875 | 23.775 | 23.775 | 8544.0 |
| 2014-07-21 05:55:00 | AAPL | Stock | 23.79 | 23.7925 | 23.79 | 23.7925 | 10144.0 |
| 2014-07-21 06:05:00 | AAPL | Stock | 23.7925 | 23.7925 | 23.7925 | 23.7925 | 400.0 |
| 2014-07-21 06:10:00 | AAPL | Stock | 23.795 | 23.8 | 23.775 | 23.775 | 11836.0 |
| 2014-07-21 06:15:00 | AAPL | Stock | 23.775 | 23.775 | 23.7725 | 23.7725 | 3880.0 |
| 2014-07-21 06:20:00 | AAPL | Stock | 23.7775 | 23.7775 | 23.7775 | 23.7775 | 800.0 |
| 2014-07-21 06:25:00 | AAPL | Stock | 23.7625 | 23.7625 | 23.75 | 23.75 | 8000.0 |
| 2014-07-21 06:30:00 | AAPL | Stock | 23.7625 | 23.7625 | 23.75 | 23.75 | 3800.0 |
| 2014-07-21 06:35:00 | AAPL | Stock | 23.7575 | 23.76 | 23.7575 | 23.76 | 6388.0 |
| 2014-07-21 06:40:00 | AAPL | Stock | 23.77 | 23.78 | 23.7675 | 23.775 | 28772.0 |
| 2014-07-21 06:45:00 | AAPL | Stock | 23.7525 | 23.785 | 23.7525 | 23.7525 | 37040.0 |
| 2014-07-21 06:50:00 | AAPL | Stock | 23.76 | 23.7625 | 23.725 | 23.725 | 7900.0 |
| 2014-07-21 06:55:00 | AAPL | Stock | 23.7225 | 23.735 | 23.7225 | 23.735 | 3600.0 |
| 2014-07-21 07:00:00 | AAPL | Stock | 23.7375 | 23.7375 | 23.725 | 23.725 | 4400.0 |
| 2014-07-21 07:05:00 | AAPL | Stock | 23.715 | 23.725 | 23.7125 | 23.725 | 4616.0 |
| 2014-07-21 07:10:00 | AAPL | Stock | 23.725 | 23.74 | 23.725 | 23.74 | 16328.0 |
| 2014-07-21 07:15:00 | AAPL | Stock | 23.7125 | 23.7125 | 23.7125 | 23.7125 | 12200.0 |
| 2014-07-21 07:20:00 | AAPL | Stock | 23.7125 | 23.755 | 23.7125 | 23.755 | 21600.0 |
| 2014-07-21 07:25:00 | AAPL | Stock | 23.76 | 23.7625 | 23.75 | 23.75 | 4352.0 |
| 2014-07-21 07:30:00 | AAPL | Stock | 23.7525 | 23.755 | 23.7425 | 23.755 | 11440.0 |
| 2014-07-21 07:35:00 | AAPL | Stock | 23.7625 | 23.7625 | 23.7525 | 23.76 | 24524.0 |
| 2014-07-21 07:40:00 | AAPL | Stock | 23.76 | 23.76 | 23.75 | 23.7525 | 10400.0 |
| 2014-07-21 07:45:00 | AAPL | Stock | 23.7575 | 23.7625 | 23.75 | 23.75 | 46368.0 |
| 2014-07-21 07:50:00 | AAPL | Stock | 23.75 | 23.75 | 23.7225 | 23.7375 | 58700.0 |
| 2014-07-21 07:55:00 | AAPL | Stock | 23.75 | 23.8 | 23.7475 | 23.78 | 40736.0 |
| 2014-07-21 08:00:00 | AAPL | Stock | 23.7625 | 23.7875 | 23.6575 | 23.6875 | 331804.0 |
| 2014-07-21 08:05:00 | AAPL | Stock | 23.675 | 23.7 | 23.655 | 23.655 | 73984.0 |
| 2014-07-21 08:10:00 | AAPL | Stock | 23.665 | 23.665 | 23.6175 | 23.635 | 90040.0 |
| 2014-07-21 08:15:00 | AAPL | Stock | 23.63 | 23.695 | 23.6225 | 23.69 | 271192.0 |
| 2014-07-21 08:20:00 | AAPL | Stock | 23.675 | 23.675 | 23.6425 | 23.645 | 45260.0 |
| 2014-07-21 08:25:00 | AAPL | Stock | 23.66 | 23.67 | 23.645 | 23.6575 | 50720.0 |
| 2014-07-21 08:30:00 | AAPL | Stock | 23.6625 | 23.675 | 23.6575 | 23.6625 | 42524.0 |
| 2014-07-21 08:35:00 | AAPL | Stock | 23.6625 | 23.6625 | 23.6475 | 23.65 | 37756.0 |
| 2014-07-21 08:40:00 | AAPL | Stock | 23.65 | 23.6575 | 23.6425 | 23.6575 | 56296.0 |
| 2014-07-21 08:45:00 | AAPL | Stock | 23.6575 | 23.7 | 23.65 | 23.6825 | 111604.0 |
| 2014-07-21 08:50:00 | AAPL | Stock | 23.68 | 23.68 | 23.6625 | 23.6625 | 49340.0 |
| 2014-07-21 08:55:00 | AAPL | Stock | 23.665 | 23.67 | 23.66 | 23.6625 | 48976.0 |
> showing 50 of 350,424 rows — these rows as CSV