PREVIEW / stock_5min / 2015-06-25
file: by_date/stock_5min/2015/2015-06-25.parquet size: 5.5 MB rows: 366,501 symbols: 3,492
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-06-25 04:00:00 | AAPL | Stock | 32.105 | 32.105 | 32.105 | 32.105 | 800.0 |
| 2015-06-25 04:10:00 | AAPL | Stock | 32.11 | 32.11 | 32.11 | 32.11 | 400.0 |
| 2015-06-25 04:15:00 | AAPL | Stock | 32.1475 | 32.1475 | 32.1475 | 32.1475 | 400.0 |
| 2015-06-25 04:25:00 | AAPL | Stock | 32.1475 | 32.17 | 32.1475 | 32.17 | 13600.0 |
| 2015-06-25 04:30:00 | AAPL | Stock | 32.185 | 32.185 | 32.185 | 32.185 | 712.0 |
| 2015-06-25 04:35:00 | AAPL | Stock | 32.2125 | 32.2125 | 32.2125 | 32.2125 | 3920.0 |
| 2015-06-25 04:45:00 | AAPL | Stock | 32.185 | 32.185 | 32.185 | 32.185 | 400.0 |
| 2015-06-25 05:25:00 | AAPL | Stock | 32.1675 | 32.1675 | 32.1675 | 32.1675 | 7800.0 |
| 2015-06-25 05:30:00 | AAPL | Stock | 32.1675 | 32.1675 | 32.1675 | 32.1675 | 996.0 |
| 2015-06-25 05:40:00 | AAPL | Stock | 32.135 | 32.16 | 32.135 | 32.16 | 3600.0 |
| 2015-06-25 05:45:00 | AAPL | Stock | 32.16 | 32.165 | 32.16 | 32.165 | 2800.0 |
| 2015-06-25 05:50:00 | AAPL | Stock | 32.165 | 32.1675 | 32.165 | 32.1675 | 4400.0 |
| 2015-06-25 06:05:00 | AAPL | Stock | 32.155 | 32.155 | 32.155 | 32.155 | 800.0 |
| 2015-06-25 06:15:00 | AAPL | Stock | 32.16 | 32.16 | 32.16 | 32.16 | 400.0 |
| 2015-06-25 06:20:00 | AAPL | Stock | 32.1625 | 32.19 | 32.1625 | 32.19 | 14172.0 |
| 2015-06-25 06:25:00 | AAPL | Stock | 32.2125 | 32.2125 | 32.2125 | 32.2125 | 400.0 |
| 2015-06-25 06:30:00 | AAPL | Stock | 32.1875 | 32.205 | 32.1875 | 32.205 | 4400.0 |
| 2015-06-25 06:35:00 | AAPL | Stock | 32.2 | 32.2 | 32.1925 | 32.1925 | 2000.0 |
| 2015-06-25 06:40:00 | AAPL | Stock | 32.1875 | 32.1875 | 32.1875 | 32.1875 | 1680.0 |
| 2015-06-25 06:45:00 | AAPL | Stock | 32.1925 | 32.2 | 32.1925 | 32.2 | 4800.0 |
| 2015-06-25 06:50:00 | AAPL | Stock | 32.1975 | 32.1975 | 32.1975 | 32.1975 | 400.0 |
| 2015-06-25 07:00:00 | AAPL | Stock | 32.2 | 32.205 | 32.185 | 32.185 | 16856.0 |
| 2015-06-25 07:05:00 | AAPL | Stock | 32.19 | 32.19 | 32.15 | 32.15 | 3200.0 |
| 2015-06-25 07:10:00 | AAPL | Stock | 32.1625 | 32.18 | 32.1525 | 32.18 | 18800.0 |
| 2015-06-25 07:15:00 | AAPL | Stock | 32.195 | 32.2075 | 32.195 | 32.2075 | 11024.0 |
| 2015-06-25 07:20:00 | AAPL | Stock | 32.205 | 32.2125 | 32.1875 | 32.195 | 6400.0 |
| 2015-06-25 07:25:00 | AAPL | Stock | 32.1925 | 32.2025 | 32.1875 | 32.195 | 10400.0 |
| 2015-06-25 07:30:00 | AAPL | Stock | 32.195 | 32.2025 | 32.1875 | 32.19 | 13420.0 |
| 2015-06-25 07:35:00 | AAPL | Stock | 32.195 | 32.2025 | 32.1925 | 32.2025 | 11608.0 |
| 2015-06-25 07:40:00 | AAPL | Stock | 32.2025 | 32.2025 | 32.1925 | 32.1925 | 8000.0 |
| 2015-06-25 07:45:00 | AAPL | Stock | 32.1925 | 32.1925 | 32.19 | 32.1925 | 12400.0 |
| 2015-06-25 07:50:00 | AAPL | Stock | 32.1875 | 32.1925 | 32.1875 | 32.1925 | 820.0 |
| 2015-06-25 07:55:00 | AAPL | Stock | 32.175 | 32.1925 | 32.1675 | 32.1875 | 9216.0 |
| 2015-06-25 08:00:00 | AAPL | Stock | 32.1925 | 32.2125 | 31.95 | 32.2125 | 197160.0 |
| 2015-06-25 08:05:00 | AAPL | Stock | 32.2075 | 32.2125 | 32.1925 | 32.2 | 27948.0 |
| 2015-06-25 08:10:00 | AAPL | Stock | 32.2 | 32.22 | 32.2 | 32.2175 | 31972.0 |
| 2015-06-25 08:15:00 | AAPL | Stock | 32.2125 | 32.225 | 32.2125 | 32.2225 | 38928.0 |
| 2015-06-25 08:20:00 | AAPL | Stock | 32.22 | 32.2225 | 32.2025 | 32.2075 | 15800.0 |
| 2015-06-25 08:25:00 | AAPL | Stock | 32.1932 | 32.2125 | 32.1925 | 32.2 | 74788.0 |
| 2015-06-25 08:30:00 | AAPL | Stock | 32.2 | 32.2025 | 32.175 | 32.1825 | 60060.0 |
| 2015-06-25 08:35:00 | AAPL | Stock | 32.175 | 32.1875 | 32.17 | 32.175 | 39616.0 |
| 2015-06-25 08:40:00 | AAPL | Stock | 32.175 | 32.175 | 32.1625 | 32.1625 | 9800.0 |
| 2015-06-25 08:45:00 | AAPL | Stock | 32.1625 | 32.1625 | 32.1525 | 32.1625 | 27792.0 |
| 2015-06-25 08:50:00 | AAPL | Stock | 32.1725 | 32.175 | 32.165 | 32.1725 | 13180.0 |
| 2015-06-25 08:55:00 | AAPL | Stock | 32.1718 | 32.2 | 32.1675 | 32.195 | 33820.0 |
| 2015-06-25 09:00:00 | AAPL | Stock | 32.2 | 32.2075 | 32.185 | 32.2025 | 67712.0 |
| 2015-06-25 09:05:00 | AAPL | Stock | 32.2025 | 32.21 | 32.2 | 32.2 | 33836.0 |
| 2015-06-25 09:10:00 | AAPL | Stock | 32.2 | 32.2075 | 32.195 | 32.195 | 15360.0 |
| 2015-06-25 09:15:00 | AAPL | Stock | 32.195 | 32.2 | 32.1825 | 32.1975 | 39224.0 |
| 2015-06-25 09:20:00 | AAPL | Stock | 32.2 | 32.2225 | 32.2 | 32.2125 | 97480.0 |
> showing 50 of 366,501 rows — these rows as CSV