PREVIEW / stock_5min / 2014-10-24
file: by_date/stock_5min/2014/2014-10-24.parquet size: 5.2 MB rows: 342,905 symbols: 3,537
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-10-24 04:00:00 | AAPL | Stock | 26.2025 | 26.2025 | 26.2025 | 26.2025 | 1680.0 |
| 2014-10-24 04:10:00 | AAPL | Stock | 26.2175 | 26.2175 | 26.2175 | 26.2175 | 1200.0 |
| 2014-10-24 04:30:00 | AAPL | Stock | 26.18 | 26.18 | 26.18 | 26.18 | 800.0 |
| 2014-10-24 04:35:00 | AAPL | Stock | 26.2025 | 26.2025 | 26.2025 | 26.2025 | 400.0 |
| 2014-10-24 04:40:00 | AAPL | Stock | 26.205 | 26.205 | 26.205 | 26.205 | 400.0 |
| 2014-10-24 04:45:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 6000.0 |
| 2014-10-24 05:00:00 | AAPL | Stock | 26.1925 | 26.1925 | 26.1875 | 26.1875 | 1200.0 |
| 2014-10-24 05:10:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 2800.0 |
| 2014-10-24 05:15:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 1200.0 |
| 2014-10-24 05:25:00 | AAPL | Stock | 26.1825 | 26.1825 | 26.1825 | 26.1825 | 400.0 |
| 2014-10-24 05:30:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 1368.0 |
| 2014-10-24 05:35:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 2592.0 |
| 2014-10-24 05:50:00 | AAPL | Stock | 26.1775 | 26.1775 | 26.175 | 26.175 | 8932.0 |
| 2014-10-24 05:55:00 | AAPL | Stock | 26.1525 | 26.1525 | 26.15 | 26.15 | 4000.0 |
| 2014-10-24 06:00:00 | AAPL | Stock | 26.17 | 26.17 | 26.17 | 26.17 | 772.0 |
| 2014-10-24 06:05:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 724.0 |
| 2014-10-24 06:20:00 | AAPL | Stock | 26.15 | 26.1625 | 26.15 | 26.1625 | 7336.0 |
| 2014-10-24 06:30:00 | AAPL | Stock | 26.15 | 26.165 | 26.15 | 26.165 | 11528.0 |
| 2014-10-24 06:35:00 | AAPL | Stock | 26.1725 | 26.175 | 26.1675 | 26.1675 | 10020.0 |
| 2014-10-24 06:40:00 | AAPL | Stock | 26.15 | 26.1575 | 26.15 | 26.1575 | 2196.0 |
| 2014-10-24 06:45:00 | AAPL | Stock | 26.175 | 26.1875 | 26.175 | 26.18 | 8000.0 |
| 2014-10-24 07:00:00 | AAPL | Stock | 26.1925 | 26.2225 | 26.1925 | 26.2225 | 9980.0 |
| 2014-10-24 07:05:00 | AAPL | Stock | 26.2125 | 26.235 | 26.2025 | 26.2125 | 21608.0 |
| 2014-10-24 07:10:00 | AAPL | Stock | 26.2025 | 26.2125 | 26.2 | 26.2125 | 2400.0 |
| 2014-10-24 07:15:00 | AAPL | Stock | 26.2 | 26.2075 | 26.2 | 26.2075 | 1200.0 |
| 2014-10-24 07:20:00 | AAPL | Stock | 26.2075 | 26.2075 | 26.2 | 26.205 | 2580.0 |
| 2014-10-24 07:25:00 | AAPL | Stock | 26.2 | 26.2075 | 26.2 | 26.2075 | 9560.0 |
| 2014-10-24 07:30:00 | AAPL | Stock | 26.2025 | 26.2025 | 26.2 | 26.2 | 9348.0 |
| 2014-10-24 07:35:00 | AAPL | Stock | 26.19 | 26.19 | 26.185 | 26.185 | 7476.0 |
| 2014-10-24 07:40:00 | AAPL | Stock | 26.1925 | 26.1925 | 26.1925 | 26.1925 | 6200.0 |
| 2014-10-24 07:45:00 | AAPL | Stock | 26.1925 | 26.1925 | 26.1825 | 26.1825 | 4200.0 |
| 2014-10-24 07:50:00 | AAPL | Stock | 26.1825 | 26.1825 | 26.165 | 26.165 | 22400.0 |
| 2014-10-24 07:55:00 | AAPL | Stock | 26.165 | 26.2 | 26.1625 | 26.2 | 95748.0 |
| 2014-10-24 08:00:00 | AAPL | Stock | 26.195 | 26.2125 | 26.15 | 26.175 | 204464.0 |
| 2014-10-24 08:05:00 | AAPL | Stock | 26.1725 | 26.2025 | 26.1725 | 26.2 | 37696.0 |
| 2014-10-24 08:10:00 | AAPL | Stock | 26.205 | 26.21 | 26.2 | 26.21 | 54836.0 |
| 2014-10-24 08:15:00 | AAPL | Stock | 26.2125 | 26.2425 | 26.205 | 26.235 | 85104.0 |
| 2014-10-24 08:20:00 | AAPL | Stock | 26.2225 | 26.26 | 26.2225 | 26.2575 | 65512.0 |
| 2014-10-24 08:25:00 | AAPL | Stock | 26.255 | 26.3025 | 26.25 | 26.3025 | 116392.0 |
| 2014-10-24 08:30:00 | AAPL | Stock | 26.3025 | 26.35 | 26.3 | 26.35 | 135876.0 |
| 2014-10-24 08:35:00 | AAPL | Stock | 26.35 | 26.3625 | 26.325 | 26.3425 | 279568.0 |
| 2014-10-24 08:40:00 | AAPL | Stock | 26.3425 | 26.3475 | 26.2925 | 26.305 | 223332.0 |
| 2014-10-24 08:45:00 | AAPL | Stock | 26.3125 | 26.3375 | 26.3 | 26.33 | 317432.0 |
| 2014-10-24 08:50:00 | AAPL | Stock | 26.33 | 26.345 | 26.325 | 26.345 | 90640.0 |
| 2014-10-24 08:55:00 | AAPL | Stock | 26.335 | 26.3375 | 26.315 | 26.33 | 75488.0 |
| 2014-10-24 09:00:00 | AAPL | Stock | 26.33 | 26.335 | 26.3075 | 26.3075 | 81732.0 |
| 2014-10-24 09:05:00 | AAPL | Stock | 26.3075 | 26.335 | 26.3075 | 26.33 | 63284.0 |
| 2014-10-24 09:10:00 | AAPL | Stock | 26.3325 | 26.3325 | 26.315 | 26.33 | 68344.0 |
| 2014-10-24 09:15:00 | AAPL | Stock | 26.32 | 26.335 | 26.3175 | 26.3325 | 43336.0 |
| 2014-10-24 09:20:00 | AAPL | Stock | 26.3325 | 26.365 | 26.315 | 26.35 | 105364.0 |
> showing 50 of 342,905 rows — these rows as CSV