PREVIEW / stock_5min / 2017-12-14
file: by_date/stock_5min/2017/2017-12-14.parquet size: 5.7 MB rows: 368,296 symbols: 2,931
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 |
|---|---|---|---|---|---|---|---|
| 2017-12-14 06:55:00 | AAPL | Stock | 43.1275 | 43.1275 | 43.1275 | 43.1275 | 400.0 |
| 2017-12-14 07:00:00 | AAPL | Stock | 43.1425 | 43.1425 | 43.1425 | 43.1425 | 4400.0 |
| 2017-12-14 07:10:00 | AAPL | Stock | 43.1475 | 43.1625 | 43.1475 | 43.1625 | 5888.0 |
| 2017-12-14 07:15:00 | AAPL | Stock | 43.16 | 43.16 | 43.15 | 43.15 | 12600.0 |
| 2017-12-14 07:25:00 | AAPL | Stock | 43.15 | 43.15 | 43.15 | 43.15 | 1988.0 |
| 2017-12-14 07:30:00 | AAPL | Stock | 43.1375 | 43.1375 | 43.1375 | 43.1375 | 1200.0 |
| 2017-12-14 07:40:00 | AAPL | Stock | 43.125 | 43.125 | 43.115 | 43.115 | 2500.0 |
| 2017-12-14 07:45:00 | AAPL | Stock | 43.1075 | 43.1075 | 43.1 | 43.1025 | 6756.0 |
| 2017-12-14 07:55:00 | AAPL | Stock | 43.1225 | 43.125 | 43.1225 | 43.125 | 3212.0 |
| 2017-12-14 08:00:00 | AAPL | Stock | 43.1362 | 43.1775 | 43.125 | 43.1375 | 19060.0 |
| 2017-12-14 08:05:00 | AAPL | Stock | 43.1275 | 43.1375 | 43.1275 | 43.1375 | 800.0 |
| 2017-12-14 08:10:00 | AAPL | Stock | 43.145 | 43.145 | 43.125 | 43.125 | 4352.0 |
| 2017-12-14 08:15:00 | AAPL | Stock | 43.1375 | 43.14 | 43.1375 | 43.14 | 7948.0 |
| 2017-12-14 08:20:00 | AAPL | Stock | 43.1475 | 43.1475 | 43.1475 | 43.1475 | 5000.0 |
| 2017-12-14 08:25:00 | AAPL | Stock | 43.1325 | 43.1325 | 43.13 | 43.13 | 2800.0 |
| 2017-12-14 08:30:00 | AAPL | Stock | 43.125 | 43.1375 | 43.125 | 43.125 | 9228.0 |
| 2017-12-14 08:35:00 | AAPL | Stock | 43.1275 | 43.1275 | 43.1125 | 43.115 | 17600.0 |
| 2017-12-14 08:40:00 | AAPL | Stock | 43.12 | 43.1325 | 43.12 | 43.1325 | 1200.0 |
| 2017-12-14 08:45:00 | AAPL | Stock | 43.115 | 43.13 | 43.115 | 43.125 | 2320.0 |
| 2017-12-14 08:50:00 | AAPL | Stock | 43.135 | 43.1375 | 43.13 | 43.135 | 7000.0 |
| 2017-12-14 08:55:00 | AAPL | Stock | 43.13 | 43.145 | 43.13 | 43.13 | 2400.0 |
| 2017-12-14 09:00:00 | AAPL | Stock | 43.1275 | 43.1475 | 43.1275 | 43.145 | 6800.0 |
| 2017-12-14 09:05:00 | AAPL | Stock | 43.13 | 43.145 | 43.125 | 43.125 | 16000.0 |
| 2017-12-14 09:10:00 | AAPL | Stock | 43.13 | 43.135 | 43.1175 | 43.1175 | 2200.0 |
| 2017-12-14 09:15:00 | AAPL | Stock | 43.135 | 43.135 | 43.1 | 43.1 | 26200.0 |
| 2017-12-14 09:20:00 | AAPL | Stock | 43.1 | 43.1125 | 43.1 | 43.1125 | 12552.0 |
| 2017-12-14 09:25:00 | AAPL | Stock | 43.1 | 43.1125 | 43.0775 | 43.11 | 47892.0 |
| 2017-12-14 09:30:00 | AAPL | Stock | 43.1075 | 43.2825 | 43.08 | 43.235 | 3431256.0 |
| 2017-12-14 09:35:00 | AAPL | Stock | 43.2375 | 43.265 | 43.0975 | 43.1825 | 2042328.0 |
| 2017-12-14 09:40:00 | AAPL | Stock | 43.1735 | 43.235 | 43.1375 | 43.162 | 1248076.0 |
| 2017-12-14 09:45:00 | AAPL | Stock | 43.165 | 43.22 | 43.145 | 43.195 | 1056460.0 |
| 2017-12-14 09:50:00 | AAPL | Stock | 43.2 | 43.2025 | 43.0775 | 43.0922 | 1659060.0 |
| 2017-12-14 09:55:00 | AAPL | Stock | 43.0912 | 43.13 | 43.08 | 43.0975 | 1856320.0 |
| 2017-12-14 10:00:00 | AAPL | Stock | 43.0975 | 43.1425 | 43.0625 | 43.09 | 1381464.0 |
| 2017-12-14 10:05:00 | AAPL | Stock | 43.09 | 43.1925 | 43.09 | 43.14 | 1390628.0 |
| 2017-12-14 10:10:00 | AAPL | Stock | 43.1425 | 43.1938 | 43.1275 | 43.1688 | 1041656.0 |
| 2017-12-14 10:15:00 | AAPL | Stock | 43.1675 | 43.2 | 43.1 | 43.14 | 1074636.0 |
| 2017-12-14 10:20:00 | AAPL | Stock | 43.1425 | 43.1475 | 43.0925 | 43.125 | 1172748.0 |
| 2017-12-14 10:25:00 | AAPL | Stock | 43.13 | 43.1675 | 43.0888 | 43.0962 | 812540.0 |
| 2017-12-14 10:30:00 | AAPL | Stock | 43.1018 | 43.145 | 43.0875 | 43.1395 | 921536.0 |
| 2017-12-14 10:35:00 | AAPL | Stock | 43.1382 | 43.15 | 43.08 | 43.085 | 765412.0 |
| 2017-12-14 10:40:00 | AAPL | Stock | 43.0858 | 43.1225 | 43.0525 | 43.095 | 1124324.0 |
| 2017-12-14 10:45:00 | AAPL | Stock | 43.0975 | 43.115 | 43.075 | 43.0825 | 586460.0 |
| 2017-12-14 10:50:00 | AAPL | Stock | 43.0838 | 43.105 | 43.06 | 43.08 | 757532.0 |
| 2017-12-14 10:55:00 | AAPL | Stock | 43.0825 | 43.1175 | 43.0775 | 43.085 | 1101764.0 |
| 2017-12-14 11:00:00 | AAPL | Stock | 43.085 | 43.11 | 43.0138 | 43.015 | 1502976.0 |
| 2017-12-14 11:05:00 | AAPL | Stock | 43.0175 | 43.0275 | 42.955 | 42.965 | 2028936.0 |
| 2017-12-14 11:10:00 | AAPL | Stock | 42.9625 | 42.9875 | 42.915 | 42.9338 | 1395704.0 |
| 2017-12-14 11:15:00 | AAPL | Stock | 42.9325 | 43.05 | 42.9125 | 43.01 | 1349828.0 |
| 2017-12-14 11:20:00 | AAPL | Stock | 43.005 | 43.0138 | 42.9575 | 43.0075 | 938608.0 |
> showing 50 of 368,296 rows — these rows as CSV