PREVIEW / stock_5min / 2016-08-10
file: by_date/stock_5min/2016/2016-08-10.parquet size: 5.4 MB rows: 355,183 symbols: 3,266
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 |
|---|---|---|---|---|---|---|---|
| 2016-08-10 04:00:00 | AAPL | Stock | 27.1675 | 27.1675 | 27.1675 | 27.1675 | 512.0 |
| 2016-08-10 04:25:00 | AAPL | Stock | 27.1625 | 27.1625 | 27.1625 | 27.1625 | 600.0 |
| 2016-08-10 04:35:00 | AAPL | Stock | 27.1925 | 27.1925 | 27.1925 | 27.1925 | 400.0 |
| 2016-08-10 04:45:00 | AAPL | Stock | 27.1925 | 27.1925 | 27.1925 | 27.1925 | 1200.0 |
| 2016-08-10 04:50:00 | AAPL | Stock | 27.165 | 27.165 | 27.165 | 27.165 | 2400.0 |
| 2016-08-10 04:55:00 | AAPL | Stock | 27.1675 | 27.1675 | 27.1675 | 27.1675 | 704.0 |
| 2016-08-10 05:00:00 | AAPL | Stock | 27.1625 | 27.1625 | 27.1625 | 27.1625 | 424.0 |
| 2016-08-10 05:15:00 | AAPL | Stock | 27.175 | 27.175 | 27.175 | 27.175 | 400.0 |
| 2016-08-10 05:25:00 | AAPL | Stock | 27.185 | 27.185 | 27.185 | 27.185 | 756.0 |
| 2016-08-10 05:30:00 | AAPL | Stock | 27.175 | 27.175 | 27.175 | 27.175 | 1608.0 |
| 2016-08-10 05:55:00 | AAPL | Stock | 27.1725 | 27.1725 | 27.1725 | 27.1725 | 1000.0 |
| 2016-08-10 06:15:00 | AAPL | Stock | 27.1725 | 27.1725 | 27.1725 | 27.1725 | 400.0 |
| 2016-08-10 06:20:00 | AAPL | Stock | 27.1725 | 27.1725 | 27.1725 | 27.1725 | 840.0 |
| 2016-08-10 06:30:00 | AAPL | Stock | 27.155 | 27.155 | 27.1325 | 27.1325 | 4796.0 |
| 2016-08-10 07:00:00 | AAPL | Stock | 27.15 | 27.15 | 27.15 | 27.15 | 3200.0 |
| 2016-08-10 07:10:00 | AAPL | Stock | 27.15 | 27.15 | 27.15 | 27.15 | 400.0 |
| 2016-08-10 07:15:00 | AAPL | Stock | 27.15 | 27.2025 | 27.15 | 27.2025 | 11000.0 |
| 2016-08-10 07:20:00 | AAPL | Stock | 27.1575 | 27.16 | 27.1575 | 27.16 | 1400.0 |
| 2016-08-10 07:30:00 | AAPL | Stock | 27.165 | 27.165 | 27.165 | 27.165 | 800.0 |
| 2016-08-10 07:35:00 | AAPL | Stock | 27.1975 | 27.205 | 27.1975 | 27.205 | 3304.0 |
| 2016-08-10 07:50:00 | AAPL | Stock | 27.2125 | 27.2125 | 27.2125 | 27.2125 | 2400.0 |
| 2016-08-10 07:55:00 | AAPL | Stock | 27.2125 | 27.2125 | 27.2 | 27.2 | 5600.0 |
| 2016-08-10 08:00:00 | AAPL | Stock | 27.21 | 27.225 | 27.1325 | 27.22 | 54628.0 |
| 2016-08-10 08:05:00 | AAPL | Stock | 27.22 | 27.22 | 27.22 | 27.22 | 5600.0 |
| 2016-08-10 08:10:00 | AAPL | Stock | 27.22 | 27.2225 | 27.215 | 27.215 | 7200.0 |
| 2016-08-10 08:15:00 | AAPL | Stock | 27.215 | 27.2225 | 27.215 | 27.2175 | 11220.0 |
| 2016-08-10 08:20:00 | AAPL | Stock | 27.2175 | 27.2225 | 27.2175 | 27.2225 | 3600.0 |
| 2016-08-10 08:25:00 | AAPL | Stock | 27.2175 | 27.2175 | 27.2175 | 27.2175 | 1200.0 |
| 2016-08-10 08:30:00 | AAPL | Stock | 27.2175 | 27.2225 | 27.2175 | 27.2175 | 14248.0 |
| 2016-08-10 08:35:00 | AAPL | Stock | 27.215 | 27.2175 | 27.21 | 27.21 | 40484.0 |
| 2016-08-10 08:40:00 | AAPL | Stock | 27.205 | 27.21 | 27.2025 | 27.21 | 14400.0 |
| 2016-08-10 08:50:00 | AAPL | Stock | 27.2025 | 27.205 | 27.2 | 27.205 | 9200.0 |
| 2016-08-10 08:55:00 | AAPL | Stock | 27.21 | 27.21 | 27.205 | 27.205 | 8800.0 |
| 2016-08-10 09:00:00 | AAPL | Stock | 27.2075 | 27.2175 | 27.205 | 27.2075 | 11320.0 |
| 2016-08-10 09:05:00 | AAPL | Stock | 27.2175 | 27.225 | 27.2075 | 27.21 | 19876.0 |
| 2016-08-10 09:10:00 | AAPL | Stock | 27.215 | 27.215 | 27.215 | 27.215 | 9184.0 |
| 2016-08-10 09:15:00 | AAPL | Stock | 27.2125 | 27.2325 | 27.2125 | 27.23 | 13840.0 |
| 2016-08-10 09:20:00 | AAPL | Stock | 27.23 | 27.23 | 27.215 | 27.215 | 19392.0 |
| 2016-08-10 09:25:00 | AAPL | Stock | 27.215 | 27.215 | 27.16 | 27.16 | 290664.0 |
| 2016-08-10 09:30:00 | AAPL | Stock | 27.16 | 27.2175 | 27.1325 | 27.1775 | 3728076.0 |
| 2016-08-10 09:35:00 | AAPL | Stock | 27.1762 | 27.215 | 27.17 | 27.215 | 2093652.0 |
| 2016-08-10 09:40:00 | AAPL | Stock | 27.215 | 27.225 | 27.1525 | 27.1575 | 2279724.0 |
| 2016-08-10 09:45:00 | AAPL | Stock | 27.1575 | 27.195 | 27.1475 | 27.1662 | 1350936.0 |
| 2016-08-10 09:50:00 | AAPL | Stock | 27.1675 | 27.1775 | 27.1375 | 27.145 | 926588.0 |
| 2016-08-10 09:55:00 | AAPL | Stock | 27.145 | 27.1625 | 27.1 | 27.1025 | 2059376.0 |
| 2016-08-10 10:00:00 | AAPL | Stock | 27.1025 | 27.14 | 27.1025 | 27.13 | 1451968.0 |
| 2016-08-10 10:05:00 | AAPL | Stock | 27.1325 | 27.135 | 27.0925 | 27.1225 | 2068216.0 |
| 2016-08-10 10:10:00 | AAPL | Stock | 27.1225 | 27.1288 | 27.0925 | 27.1002 | 1320888.0 |
| 2016-08-10 10:15:00 | AAPL | Stock | 27.1012 | 27.11 | 27.0825 | 27.0938 | 1693928.0 |
| 2016-08-10 10:20:00 | AAPL | Stock | 27.0938 | 27.14 | 27.0938 | 27.1175 | 1424400.0 |
> showing 50 of 355,183 rows — these rows as CSV