PREVIEW / stock_5min / 2015-11-04
file: by_date/stock_5min/2015/2015-11-04.parquet size: 5.5 MB rows: 365,805 symbols: 3,404
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-04 04:00:00 | AAPL | Stock | 30.675 | 30.7325 | 30.675 | 30.7325 | 6300.0 |
| 2015-11-04 04:30:00 | AAPL | Stock | 30.74 | 30.75 | 30.74 | 30.75 | 2400.0 |
| 2015-11-04 05:00:00 | AAPL | Stock | 30.7475 | 30.7475 | 30.7475 | 30.7475 | 560.0 |
| 2015-11-04 05:45:00 | AAPL | Stock | 30.745 | 30.745 | 30.745 | 30.745 | 3396.0 |
| 2015-11-04 05:50:00 | AAPL | Stock | 30.725 | 30.725 | 30.725 | 30.725 | 400.0 |
| 2015-11-04 05:55:00 | AAPL | Stock | 30.75 | 30.75 | 30.75 | 30.75 | 448.0 |
| 2015-11-04 06:00:00 | AAPL | Stock | 30.7675 | 30.7875 | 30.7525 | 30.7525 | 4696.0 |
| 2015-11-04 06:05:00 | AAPL | Stock | 30.75 | 30.75 | 30.75 | 30.75 | 2000.0 |
| 2015-11-04 06:10:00 | AAPL | Stock | 30.725 | 30.725 | 30.725 | 30.725 | 400.0 |
| 2015-11-04 06:15:00 | AAPL | Stock | 30.725 | 30.725 | 30.725 | 30.725 | 7188.0 |
| 2015-11-04 06:20:00 | AAPL | Stock | 30.725 | 30.775 | 30.725 | 30.775 | 5376.0 |
| 2015-11-04 06:25:00 | AAPL | Stock | 30.725 | 30.7775 | 30.725 | 30.7775 | 12800.0 |
| 2015-11-04 06:50:00 | AAPL | Stock | 30.7775 | 30.7775 | 30.7775 | 30.7775 | 1600.0 |
| 2015-11-04 07:05:00 | AAPL | Stock | 30.7725 | 30.785 | 30.75 | 30.775 | 20952.0 |
| 2015-11-04 07:10:00 | AAPL | Stock | 30.765 | 30.775 | 30.75 | 30.77 | 10280.0 |
| 2015-11-04 07:15:00 | AAPL | Stock | 30.7525 | 30.7525 | 30.7525 | 30.7525 | 5200.0 |
| 2015-11-04 07:20:00 | AAPL | Stock | 30.7525 | 30.7525 | 30.75 | 30.75 | 1660.0 |
| 2015-11-04 07:25:00 | AAPL | Stock | 30.75 | 30.765 | 30.75 | 30.7625 | 4400.0 |
| 2015-11-04 07:30:00 | AAPL | Stock | 30.77 | 30.7725 | 30.7625 | 30.7625 | 30408.0 |
| 2015-11-04 07:35:00 | AAPL | Stock | 30.755 | 30.775 | 30.755 | 30.775 | 4400.0 |
| 2015-11-04 07:40:00 | AAPL | Stock | 30.7725 | 30.775 | 30.76 | 30.77 | 21400.0 |
| 2015-11-04 07:45:00 | AAPL | Stock | 30.7725 | 30.7725 | 30.77 | 30.77 | 10832.0 |
| 2015-11-04 07:50:00 | AAPL | Stock | 30.77 | 30.7725 | 30.76 | 30.76 | 14800.0 |
| 2015-11-04 07:55:00 | AAPL | Stock | 30.7725 | 30.7775 | 30.7675 | 30.7675 | 65964.0 |
| 2015-11-04 08:00:00 | AAPL | Stock | 30.7675 | 30.7775 | 30.575 | 30.775 | 306932.0 |
| 2015-11-04 08:05:00 | AAPL | Stock | 30.7725 | 30.7925 | 30.7725 | 30.79 | 92144.0 |
| 2015-11-04 08:10:00 | AAPL | Stock | 30.79 | 30.7975 | 30.7875 | 30.7875 | 94892.0 |
| 2015-11-04 08:15:00 | AAPL | Stock | 30.7925 | 30.81 | 30.7875 | 30.81 | 43536.0 |
| 2015-11-04 08:20:00 | AAPL | Stock | 30.8085 | 30.81 | 30.8025 | 30.8075 | 31276.0 |
| 2015-11-04 08:25:00 | AAPL | Stock | 30.8075 | 30.8175 | 30.805 | 30.815 | 86080.0 |
| 2015-11-04 08:30:00 | AAPL | Stock | 30.8125 | 30.82 | 30.8125 | 30.8125 | 30400.0 |
| 2015-11-04 08:35:00 | AAPL | Stock | 30.815 | 30.8425 | 30.815 | 30.825 | 94792.0 |
| 2015-11-04 08:40:00 | AAPL | Stock | 30.83 | 30.83 | 30.8 | 30.81 | 44224.0 |
| 2015-11-04 08:45:00 | AAPL | Stock | 30.805 | 30.805 | 30.7925 | 30.8 | 47832.0 |
| 2015-11-04 08:50:00 | AAPL | Stock | 30.8 | 30.8 | 30.79 | 30.8 | 54300.0 |
| 2015-11-04 08:55:00 | AAPL | Stock | 30.805 | 30.835 | 30.805 | 30.83 | 66812.0 |
| 2015-11-04 09:00:00 | AAPL | Stock | 30.825 | 30.8325 | 30.805 | 30.82 | 50512.0 |
| 2015-11-04 09:05:00 | AAPL | Stock | 30.82 | 30.8225 | 30.8075 | 30.8075 | 40872.0 |
| 2015-11-04 09:10:00 | AAPL | Stock | 30.8125 | 30.825 | 30.8125 | 30.815 | 21208.0 |
| 2015-11-04 09:15:00 | AAPL | Stock | 30.8125 | 30.82 | 30.79 | 30.795 | 51352.0 |
| 2015-11-04 09:20:00 | AAPL | Stock | 30.795 | 30.795 | 30.7725 | 30.78 | 47100.0 |
| 2015-11-04 09:25:00 | AAPL | Stock | 30.775 | 30.78 | 30.7575 | 30.77 | 48252.0 |
| 2015-11-04 09:30:00 | AAPL | Stock | 30.7825 | 30.955 | 30.7625 | 30.9388 | 7837120.0 |
| 2015-11-04 09:35:00 | AAPL | Stock | 30.94 | 30.945 | 30.88 | 30.91 | 4834996.0 |
| 2015-11-04 09:40:00 | AAPL | Stock | 30.9098 | 30.9375 | 30.8375 | 30.8525 | 4242532.0 |
| 2015-11-04 09:45:00 | AAPL | Stock | 30.8525 | 30.865 | 30.7825 | 30.7952 | 3988092.0 |
| 2015-11-04 09:50:00 | AAPL | Stock | 30.7975 | 30.8075 | 30.725 | 30.805 | 4562016.0 |
| 2015-11-04 09:55:00 | AAPL | Stock | 30.805 | 30.8475 | 30.785 | 30.8125 | 3065648.0 |
| 2015-11-04 10:00:00 | AAPL | Stock | 30.8125 | 30.8425 | 30.75 | 30.834 | 2995572.0 |
| 2015-11-04 10:05:00 | AAPL | Stock | 30.8325 | 30.84 | 30.755 | 30.792 | 1803644.0 |
> showing 50 of 365,805 rows — these rows as CSV