PREVIEW / stock_5min / 2014-06-16
file: by_date/stock_5min/2014/2014-06-16.parquet size: 5.4 MB rows: 363,049 symbols: 3,543
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-06-16 04:00:00 | AAPL | Stock | 22.85 | 22.85 | 22.7625 | 22.7625 | 7200.0 |
| 2014-06-16 04:05:00 | AAPL | Stock | 22.7625 | 22.7625 | 22.725 | 22.725 | 5200.0 |
| 2014-06-16 04:30:00 | AAPL | Stock | 22.7375 | 22.7375 | 22.7375 | 22.7375 | 1988.0 |
| 2014-06-16 04:40:00 | AAPL | Stock | 22.755 | 22.755 | 22.755 | 22.755 | 2860.0 |
| 2014-06-16 04:50:00 | AAPL | Stock | 22.75 | 22.75 | 22.75 | 22.75 | 1540.0 |
| 2014-06-16 04:55:00 | AAPL | Stock | 22.765 | 22.82 | 22.765 | 22.82 | 3360.0 |
| 2014-06-16 05:25:00 | AAPL | Stock | 22.7625 | 22.7625 | 22.7625 | 22.7625 | 1464.0 |
| 2014-06-16 05:50:00 | AAPL | Stock | 22.825 | 22.825 | 22.825 | 22.825 | 8000.0 |
| 2014-06-16 06:00:00 | AAPL | Stock | 22.8025 | 22.8025 | 22.8025 | 22.8025 | 3080.0 |
| 2014-06-16 06:15:00 | AAPL | Stock | 22.825 | 22.825 | 22.825 | 22.825 | 1600.0 |
| 2014-06-16 06:25:00 | AAPL | Stock | 22.825 | 22.825 | 22.815 | 22.815 | 1600.0 |
| 2014-06-16 06:40:00 | AAPL | Stock | 22.8375 | 22.8625 | 22.8375 | 22.86 | 16800.0 |
| 2014-06-16 06:50:00 | AAPL | Stock | 22.84 | 22.84 | 22.84 | 22.84 | 2000.0 |
| 2014-06-16 07:00:00 | AAPL | Stock | 22.8625 | 22.8725 | 22.8475 | 22.855 | 2700.0 |
| 2014-06-16 07:05:00 | AAPL | Stock | 22.855 | 22.855 | 22.85 | 22.85 | 8000.0 |
| 2014-06-16 07:20:00 | AAPL | Stock | 22.8575 | 22.8575 | 22.8525 | 22.8525 | 19992.0 |
| 2014-06-16 07:25:00 | AAPL | Stock | 22.8525 | 22.8525 | 22.85 | 22.85 | 17276.0 |
| 2014-06-16 07:35:00 | AAPL | Stock | 22.8625 | 22.865 | 22.8575 | 22.865 | 4100.0 |
| 2014-06-16 07:40:00 | AAPL | Stock | 22.8675 | 22.8675 | 22.8675 | 22.8675 | 4000.0 |
| 2014-06-16 07:45:00 | AAPL | Stock | 22.865 | 22.865 | 22.86 | 22.86 | 4000.0 |
| 2014-06-16 07:55:00 | AAPL | Stock | 22.8675 | 22.87 | 22.8625 | 22.8625 | 5200.0 |
| 2014-06-16 08:00:00 | AAPL | Stock | 22.8575 | 22.875 | 22.805 | 22.8225 | 86300.0 |
| 2014-06-16 08:05:00 | AAPL | Stock | 22.815 | 22.8525 | 22.8075 | 22.83 | 128664.0 |
| 2014-06-16 08:10:00 | AAPL | Stock | 22.8375 | 22.8575 | 22.8375 | 22.85 | 58476.0 |
| 2014-06-16 08:15:00 | AAPL | Stock | 22.85 | 22.91 | 22.85 | 22.9 | 95976.0 |
| 2014-06-16 08:20:00 | AAPL | Stock | 22.9 | 22.9 | 22.885 | 22.8975 | 16352.0 |
| 2014-06-16 08:25:00 | AAPL | Stock | 22.8875 | 22.895 | 22.87 | 22.87 | 28692.0 |
| 2014-06-16 08:30:00 | AAPL | Stock | 22.87 | 22.905 | 22.87 | 22.885 | 116816.0 |
| 2014-06-16 08:35:00 | AAPL | Stock | 22.88 | 22.91 | 22.88 | 22.8925 | 6800.0 |
| 2014-06-16 08:40:00 | AAPL | Stock | 22.9 | 22.925 | 22.8925 | 22.9 | 49776.0 |
| 2014-06-16 08:45:00 | AAPL | Stock | 22.9075 | 22.92 | 22.9 | 22.92 | 25300.0 |
| 2014-06-16 08:50:00 | AAPL | Stock | 22.9125 | 22.92 | 22.8875 | 22.8975 | 45716.0 |
| 2014-06-16 08:55:00 | AAPL | Stock | 22.9 | 22.915 | 22.9 | 22.9125 | 16032.0 |
| 2014-06-16 09:00:00 | AAPL | Stock | 22.9125 | 22.9175 | 22.9025 | 22.9175 | 28792.0 |
| 2014-06-16 09:05:00 | AAPL | Stock | 22.905 | 22.9225 | 22.9025 | 22.905 | 42800.0 |
| 2014-06-16 09:10:00 | AAPL | Stock | 22.9125 | 22.9125 | 22.885 | 22.885 | 118944.0 |
| 2014-06-16 09:15:00 | AAPL | Stock | 22.8975 | 22.9 | 22.895 | 22.9 | 60724.0 |
| 2014-06-16 09:20:00 | AAPL | Stock | 22.9 | 22.9125 | 22.8875 | 22.9125 | 54192.0 |
| 2014-06-16 09:25:00 | AAPL | Stock | 22.9125 | 22.925 | 22.8725 | 22.89 | 112552.0 |
| 2014-06-16 09:30:00 | AAPL | Stock | 22.8875 | 22.9725 | 22.8625 | 22.9212 | 8454852.0 |
| 2014-06-16 09:35:00 | AAPL | Stock | 22.9225 | 22.965 | 22.92 | 22.935 | 3590864.0 |
| 2014-06-16 09:40:00 | AAPL | Stock | 22.9342 | 23.0 | 22.9275 | 22.9975 | 3911880.0 |
| 2014-06-16 09:45:00 | AAPL | Stock | 23.0 | 23.0475 | 22.995 | 23.03 | 4599500.0 |
| 2014-06-16 09:50:00 | AAPL | Stock | 23.03 | 23.035 | 22.985 | 23.018 | 2619260.0 |
| 2014-06-16 09:55:00 | AAPL | Stock | 23.02 | 23.0625 | 23.0175 | 23.0325 | 3226760.0 |
| 2014-06-16 10:00:00 | AAPL | Stock | 23.035 | 23.095 | 23.0345 | 23.0712 | 3008528.0 |
| 2014-06-16 10:05:00 | AAPL | Stock | 23.07 | 23.095 | 23.0595 | 23.075 | 2233820.0 |
| 2014-06-16 10:10:00 | AAPL | Stock | 23.0772 | 23.1525 | 23.075 | 23.1495 | 3552780.0 |
| 2014-06-16 10:15:00 | AAPL | Stock | 23.1475 | 23.1725 | 23.1425 | 23.1638 | 3083672.0 |
| 2014-06-16 10:20:00 | AAPL | Stock | 23.165 | 23.1875 | 23.13 | 23.1425 | 3452736.0 |
> showing 50 of 363,049 rows — these rows as CSV