PREVIEW / stock_5min / 2016-02-17
file: by_date/stock_5min/2016/2016-02-17.parquet size: 5.5 MB rows: 364,008 symbols: 3,360
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-02-17 04:45:00 | AAPL | Stock | 24.1325 | 24.1325 | 24.1325 | 24.1325 | 400.0 |
| 2016-02-17 04:55:00 | AAPL | Stock | 24.1325 | 24.1325 | 24.1325 | 24.1325 | 800.0 |
| 2016-02-17 05:05:00 | AAPL | Stock | 24.125 | 24.125 | 24.125 | 24.125 | 5724.0 |
| 2016-02-17 05:10:00 | AAPL | Stock | 24.125 | 24.125 | 24.125 | 24.125 | 2276.0 |
| 2016-02-17 05:20:00 | AAPL | Stock | 24.1625 | 24.22 | 24.1625 | 24.22 | 3440.0 |
| 2016-02-17 05:25:00 | AAPL | Stock | 24.22 | 24.22 | 24.22 | 24.22 | 640.0 |
| 2016-02-17 05:35:00 | AAPL | Stock | 24.19 | 24.1975 | 24.19 | 24.1975 | 800.0 |
| 2016-02-17 05:40:00 | AAPL | Stock | 24.2075 | 24.2375 | 24.2075 | 24.225 | 8124.0 |
| 2016-02-17 05:45:00 | AAPL | Stock | 24.22 | 24.225 | 24.22 | 24.225 | 800.0 |
| 2016-02-17 06:00:00 | AAPL | Stock | 24.22 | 24.2225 | 24.2125 | 24.2125 | 2400.0 |
| 2016-02-17 06:05:00 | AAPL | Stock | 24.215 | 24.215 | 24.215 | 24.215 | 400.0 |
| 2016-02-17 06:10:00 | AAPL | Stock | 24.215 | 24.225 | 24.2 | 24.2 | 4640.0 |
| 2016-02-17 06:15:00 | AAPL | Stock | 24.2125 | 24.225 | 24.2125 | 24.225 | 2000.0 |
| 2016-02-17 06:20:00 | AAPL | Stock | 24.225 | 24.225 | 24.225 | 24.225 | 400.0 |
| 2016-02-17 06:25:00 | AAPL | Stock | 24.22 | 24.22 | 24.2 | 24.2 | 7912.0 |
| 2016-02-17 06:30:00 | AAPL | Stock | 24.2 | 24.2 | 24.2 | 24.2 | 800.0 |
| 2016-02-17 06:35:00 | AAPL | Stock | 24.2125 | 24.215 | 24.2125 | 24.215 | 2680.0 |
| 2016-02-17 06:40:00 | AAPL | Stock | 24.2075 | 24.2225 | 24.2 | 24.2225 | 36032.0 |
| 2016-02-17 06:50:00 | AAPL | Stock | 24.2025 | 24.225 | 24.2025 | 24.22 | 24200.0 |
| 2016-02-17 06:55:00 | AAPL | Stock | 24.2125 | 24.2125 | 24.2125 | 24.2125 | 800.0 |
| 2016-02-17 07:00:00 | AAPL | Stock | 24.2 | 24.2175 | 24.18 | 24.2175 | 8000.0 |
| 2016-02-17 07:05:00 | AAPL | Stock | 24.2 | 24.2175 | 24.18 | 24.1825 | 31528.0 |
| 2016-02-17 07:10:00 | AAPL | Stock | 24.2 | 24.2 | 24.18 | 24.18 | 17100.0 |
| 2016-02-17 07:15:00 | AAPL | Stock | 24.2 | 24.2 | 24.2 | 24.2 | 2000.0 |
| 2016-02-17 07:25:00 | AAPL | Stock | 24.1875 | 24.1875 | 24.15 | 24.1525 | 13432.0 |
| 2016-02-17 07:30:00 | AAPL | Stock | 24.15 | 24.16 | 24.1375 | 24.16 | 16320.0 |
| 2016-02-17 07:35:00 | AAPL | Stock | 24.1725 | 24.1725 | 24.1675 | 24.17 | 10400.0 |
| 2016-02-17 07:40:00 | AAPL | Stock | 24.17 | 24.185 | 24.17 | 24.185 | 14584.0 |
| 2016-02-17 07:45:00 | AAPL | Stock | 24.185 | 24.2125 | 24.185 | 24.21 | 37200.0 |
| 2016-02-17 07:50:00 | AAPL | Stock | 24.205 | 24.205 | 24.2 | 24.2 | 24800.0 |
| 2016-02-17 07:55:00 | AAPL | Stock | 24.185 | 24.2075 | 24.185 | 24.2075 | 6104.0 |
| 2016-02-17 08:00:00 | AAPL | Stock | 24.19 | 24.2125 | 24.055 | 24.1 | 189044.0 |
| 2016-02-17 08:05:00 | AAPL | Stock | 24.1 | 24.1 | 24.0175 | 24.0275 | 105396.0 |
| 2016-02-17 08:10:00 | AAPL | Stock | 24.0275 | 24.065 | 23.9675 | 24.0 | 165688.0 |
| 2016-02-17 08:15:00 | AAPL | Stock | 23.995 | 24.025 | 23.975 | 24.0225 | 92596.0 |
| 2016-02-17 08:20:00 | AAPL | Stock | 24.0175 | 24.05 | 24.0125 | 24.0275 | 105856.0 |
| 2016-02-17 08:25:00 | AAPL | Stock | 24.0425 | 24.0425 | 24.025 | 24.0275 | 34324.0 |
| 2016-02-17 08:30:00 | AAPL | Stock | 24.0375 | 24.06 | 24.0 | 24.06 | 71116.0 |
| 2016-02-17 08:35:00 | AAPL | Stock | 24.0625 | 24.0825 | 24.05 | 24.075 | 56684.0 |
| 2016-02-17 08:40:00 | AAPL | Stock | 24.0825 | 24.0825 | 24.05 | 24.0625 | 102088.0 |
| 2016-02-17 08:45:00 | AAPL | Stock | 24.0625 | 24.0625 | 24.035 | 24.0425 | 20720.0 |
| 2016-02-17 08:50:00 | AAPL | Stock | 24.035 | 24.075 | 24.035 | 24.0525 | 31904.0 |
| 2016-02-17 08:55:00 | AAPL | Stock | 24.07 | 24.075 | 24.055 | 24.055 | 40596.0 |
| 2016-02-17 09:00:00 | AAPL | Stock | 24.055 | 24.0875 | 24.055 | 24.075 | 67788.0 |
| 2016-02-17 09:05:00 | AAPL | Stock | 24.0675 | 24.075 | 24.0225 | 24.025 | 160788.0 |
| 2016-02-17 09:10:00 | AAPL | Stock | 24.0225 | 24.05 | 24.0 | 24.0425 | 201136.0 |
| 2016-02-17 09:15:00 | AAPL | Stock | 24.035 | 24.085 | 24.0225 | 24.05 | 214892.0 |
| 2016-02-17 09:20:00 | AAPL | Stock | 24.0575 | 24.0575 | 23.9875 | 23.9875 | 165624.0 |
| 2016-02-17 09:25:00 | AAPL | Stock | 24.0 | 24.185 | 23.995 | 24.1675 | 610448.0 |
| 2016-02-17 09:30:00 | AAPL | Stock | 24.165 | 24.2488 | 24.06 | 24.22 | 7713884.0 |
> showing 50 of 364,008 rows — these rows as CSV