PREVIEW / stock_5min / 2016-02-22
file: by_date/stock_5min/2016/2016-02-22.parquet size: 5.4 MB rows: 359,122 symbols: 3,365
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-22 04:00:00 | AAPL | Stock | 24.095 | 24.2375 | 24.095 | 24.2375 | 9000.0 |
| 2016-02-22 04:05:00 | AAPL | Stock | 24.1875 | 24.1875 | 24.1875 | 24.1875 | 4000.0 |
| 2016-02-22 04:20:00 | AAPL | Stock | 24.19 | 24.19 | 24.19 | 24.19 | 760.0 |
| 2016-02-22 04:40:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 7560.0 |
| 2016-02-22 04:55:00 | AAPL | Stock | 24.285 | 24.3125 | 24.285 | 24.3125 | 5648.0 |
| 2016-02-22 05:05:00 | AAPL | Stock | 24.2525 | 24.2525 | 24.1925 | 24.1925 | 2800.0 |
| 2016-02-22 05:55:00 | AAPL | Stock | 24.265 | 24.265 | 24.265 | 24.265 | 456.0 |
| 2016-02-22 06:25:00 | AAPL | Stock | 24.2725 | 24.275 | 24.2725 | 24.275 | 2468.0 |
| 2016-02-22 06:50:00 | AAPL | Stock | 24.235 | 24.235 | 24.235 | 24.235 | 1116.0 |
| 2016-02-22 06:55:00 | AAPL | Stock | 24.2275 | 24.2275 | 24.2025 | 24.2025 | 5724.0 |
| 2016-02-22 07:00:00 | AAPL | Stock | 24.2025 | 24.2025 | 24.18 | 24.2025 | 7600.0 |
| 2016-02-22 07:05:00 | AAPL | Stock | 24.19 | 24.19 | 24.18 | 24.18 | 2400.0 |
| 2016-02-22 07:10:00 | AAPL | Stock | 24.1875 | 24.1875 | 24.1525 | 24.1625 | 14636.0 |
| 2016-02-22 07:15:00 | AAPL | Stock | 24.1825 | 24.1825 | 24.175 | 24.175 | 800.0 |
| 2016-02-22 07:20:00 | AAPL | Stock | 24.1625 | 24.1825 | 24.1525 | 24.1825 | 4732.0 |
| 2016-02-22 07:25:00 | AAPL | Stock | 24.1575 | 24.2025 | 24.15 | 24.2 | 32480.0 |
| 2016-02-22 07:30:00 | AAPL | Stock | 24.2 | 24.2 | 24.2 | 24.2 | 7720.0 |
| 2016-02-22 07:35:00 | AAPL | Stock | 24.1525 | 24.1525 | 24.15 | 24.15 | 1600.0 |
| 2016-02-22 07:40:00 | AAPL | Stock | 24.15 | 24.15 | 24.15 | 24.15 | 2000.0 |
| 2016-02-22 07:45:00 | AAPL | Stock | 24.1375 | 24.1425 | 24.1325 | 24.1325 | 3200.0 |
| 2016-02-22 07:50:00 | AAPL | Stock | 24.1375 | 24.15 | 24.1375 | 24.1475 | 14624.0 |
| 2016-02-22 07:55:00 | AAPL | Stock | 24.1425 | 24.15 | 24.1425 | 24.15 | 17728.0 |
| 2016-02-22 08:00:00 | AAPL | Stock | 24.1425 | 24.19 | 24.11 | 24.1275 | 145772.0 |
| 2016-02-22 08:05:00 | AAPL | Stock | 24.13 | 24.1625 | 24.13 | 24.15 | 63948.0 |
| 2016-02-22 08:10:00 | AAPL | Stock | 24.145 | 24.165 | 24.14 | 24.1625 | 53116.0 |
| 2016-02-22 08:15:00 | AAPL | Stock | 24.1725 | 24.1725 | 24.1425 | 24.145 | 22404.0 |
| 2016-02-22 08:20:00 | AAPL | Stock | 24.1375 | 24.1375 | 24.1175 | 24.1275 | 42748.0 |
| 2016-02-22 08:25:00 | AAPL | Stock | 24.13 | 24.135 | 24.1075 | 24.1225 | 25872.0 |
| 2016-02-22 08:30:00 | AAPL | Stock | 24.125 | 24.13 | 24.0875 | 24.09 | 67312.0 |
| 2016-02-22 08:35:00 | AAPL | Stock | 24.09 | 24.09 | 24.0625 | 24.075 | 49488.0 |
| 2016-02-22 08:40:00 | AAPL | Stock | 24.0875 | 24.0975 | 24.0875 | 24.0875 | 15528.0 |
| 2016-02-22 08:45:00 | AAPL | Stock | 24.085 | 24.1075 | 24.085 | 24.0975 | 7648.0 |
| 2016-02-22 08:50:00 | AAPL | Stock | 24.105 | 24.11 | 24.0975 | 24.11 | 51288.0 |
| 2016-02-22 08:55:00 | AAPL | Stock | 24.11 | 24.115 | 24.105 | 24.1075 | 10088.0 |
| 2016-02-22 09:00:00 | AAPL | Stock | 24.1125 | 24.115 | 24.0925 | 24.0925 | 15364.0 |
| 2016-02-22 09:05:00 | AAPL | Stock | 24.1075 | 24.1075 | 24.0925 | 24.1025 | 15676.0 |
| 2016-02-22 09:10:00 | AAPL | Stock | 24.1075 | 24.1075 | 24.095 | 24.1 | 17824.0 |
| 2016-02-22 09:15:00 | AAPL | Stock | 24.1 | 24.105 | 24.095 | 24.095 | 6420.0 |
| 2016-02-22 09:20:00 | AAPL | Stock | 24.105 | 24.1225 | 24.105 | 24.1175 | 5316.0 |
| 2016-02-22 09:25:00 | AAPL | Stock | 24.125 | 24.125 | 24.065 | 24.075 | 138064.0 |
| 2016-02-22 09:30:00 | AAPL | Stock | 24.0775 | 24.125 | 24.0175 | 24.065 | 4136084.0 |
| 2016-02-22 09:35:00 | AAPL | Stock | 24.065 | 24.095 | 23.98 | 24.0075 | 3084440.0 |
| 2016-02-22 09:40:00 | AAPL | Stock | 24.0075 | 24.06 | 23.995 | 24.0175 | 2631280.0 |
| 2016-02-22 09:45:00 | AAPL | Stock | 24.015 | 24.0925 | 24.015 | 24.0912 | 2482412.0 |
| 2016-02-22 09:50:00 | AAPL | Stock | 24.0938 | 24.145 | 24.075 | 24.1425 | 3379288.0 |
| 2016-02-22 09:55:00 | AAPL | Stock | 24.1475 | 24.1825 | 24.1075 | 24.1375 | 4959824.0 |
| 2016-02-22 10:00:00 | AAPL | Stock | 24.1375 | 24.1875 | 24.135 | 24.18 | 2486080.0 |
| 2016-02-22 10:05:00 | AAPL | Stock | 24.1785 | 24.18 | 24.1075 | 24.1075 | 2461524.0 |
| 2016-02-22 10:10:00 | AAPL | Stock | 24.11 | 24.1375 | 24.0775 | 24.08 | 2506816.0 |
| 2016-02-22 10:15:00 | AAPL | Stock | 24.0825 | 24.0975 | 24.0325 | 24.035 | 1823096.0 |
> showing 50 of 359,122 rows — these rows as CSV