PREVIEW / stock_5min / 2014-11-11
file: by_date/stock_5min/2014/2014-11-11.parquet size: 5.3 MB rows: 354,658 symbols: 3,534
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 |
|---|---|---|---|---|---|---|---|
| 2014-11-11 04:35:00 | AAPL | Stock | 27.1875 | 27.1875 | 27.1875 | 27.1875 | 4840.0 |
| 2014-11-11 05:10:00 | AAPL | Stock | 27.1825 | 27.1825 | 27.1825 | 27.1825 | 2000.0 |
| 2014-11-11 05:25:00 | AAPL | Stock | 27.1825 | 27.1825 | 27.1825 | 27.1825 | 1600.0 |
| 2014-11-11 05:30:00 | AAPL | Stock | 27.175 | 27.175 | 27.175 | 27.175 | 2000.0 |
| 2014-11-11 06:00:00 | AAPL | Stock | 27.16 | 27.16 | 27.15 | 27.15 | 800.0 |
| 2014-11-11 06:25:00 | AAPL | Stock | 27.1425 | 27.15 | 27.1425 | 27.15 | 4400.0 |
| 2014-11-11 06:30:00 | AAPL | Stock | 27.15 | 27.15 | 27.1375 | 27.1375 | 7960.0 |
| 2014-11-11 06:35:00 | AAPL | Stock | 27.1425 | 27.15 | 27.1425 | 27.15 | 2800.0 |
| 2014-11-11 06:40:00 | AAPL | Stock | 27.14 | 27.1825 | 27.14 | 27.1825 | 9616.0 |
| 2014-11-11 07:00:00 | AAPL | Stock | 27.1825 | 27.1825 | 27.1825 | 27.1825 | 900.0 |
| 2014-11-11 07:15:00 | AAPL | Stock | 27.1775 | 27.1775 | 27.1775 | 27.1775 | 4000.0 |
| 2014-11-11 07:20:00 | AAPL | Stock | 27.1775 | 27.1775 | 27.1775 | 27.1775 | 6400.0 |
| 2014-11-11 07:25:00 | AAPL | Stock | 27.1825 | 27.1825 | 27.1825 | 27.1825 | 3200.0 |
| 2014-11-11 07:30:00 | AAPL | Stock | 27.1875 | 27.1975 | 27.175 | 27.175 | 3924.0 |
| 2014-11-11 07:35:00 | AAPL | Stock | 27.175 | 27.185 | 27.165 | 27.185 | 8480.0 |
| 2014-11-11 07:40:00 | AAPL | Stock | 27.18 | 27.18 | 27.1775 | 27.18 | 2400.0 |
| 2014-11-11 07:45:00 | AAPL | Stock | 27.175 | 27.175 | 27.165 | 27.165 | 2400.0 |
| 2014-11-11 07:55:00 | AAPL | Stock | 27.165 | 27.18 | 27.165 | 27.18 | 11640.0 |
| 2014-11-11 08:00:00 | AAPL | Stock | 27.18 | 27.215 | 26.95 | 27.1725 | 73020.0 |
| 2014-11-11 08:05:00 | AAPL | Stock | 27.165 | 27.185 | 27.1625 | 27.185 | 19832.0 |
| 2014-11-11 08:10:00 | AAPL | Stock | 27.18 | 27.205 | 27.18 | 27.205 | 22852.0 |
| 2014-11-11 08:15:00 | AAPL | Stock | 27.1925 | 27.1925 | 27.19 | 27.1925 | 3400.0 |
| 2014-11-11 08:20:00 | AAPL | Stock | 27.2 | 27.2075 | 27.19 | 27.19 | 11640.0 |
| 2014-11-11 08:25:00 | AAPL | Stock | 27.1975 | 27.1975 | 27.19 | 27.195 | 3784.0 |
| 2014-11-11 08:30:00 | AAPL | Stock | 27.195 | 27.195 | 27.1925 | 27.1925 | 4180.0 |
| 2014-11-11 08:35:00 | AAPL | Stock | 27.195 | 27.195 | 27.1925 | 27.1925 | 19400.0 |
| 2014-11-11 08:40:00 | AAPL | Stock | 27.1925 | 27.1925 | 27.1875 | 27.1875 | 6940.0 |
| 2014-11-11 08:45:00 | AAPL | Stock | 27.1925 | 27.195 | 27.185 | 27.1925 | 20408.0 |
| 2014-11-11 08:50:00 | AAPL | Stock | 27.1925 | 27.1925 | 27.18 | 27.1875 | 12128.0 |
| 2014-11-11 08:55:00 | AAPL | Stock | 27.18 | 27.19 | 27.18 | 27.18 | 16760.0 |
| 2014-11-11 09:00:00 | AAPL | Stock | 27.18 | 27.18 | 27.18 | 27.18 | 5800.0 |
| 2014-11-11 09:05:00 | AAPL | Stock | 27.1875 | 27.1875 | 27.18 | 27.18 | 8360.0 |
| 2014-11-11 09:10:00 | AAPL | Stock | 27.1825 | 27.21 | 27.1825 | 27.21 | 6800.0 |
| 2014-11-11 09:15:00 | AAPL | Stock | 27.205 | 27.205 | 27.19 | 27.1925 | 19144.0 |
| 2014-11-11 09:20:00 | AAPL | Stock | 27.1925 | 27.2 | 27.1875 | 27.1875 | 41140.0 |
| 2014-11-11 09:25:00 | AAPL | Stock | 27.19 | 27.19 | 27.19 | 27.19 | 5600.0 |
| 2014-11-11 09:30:00 | AAPL | Stock | 27.175 | 27.225 | 27.125 | 27.1598 | 4457396.0 |
| 2014-11-11 09:35:00 | AAPL | Stock | 27.1575 | 27.1575 | 27.1 | 27.145 | 2599916.0 |
| 2014-11-11 09:40:00 | AAPL | Stock | 27.1425 | 27.1475 | 27.105 | 27.141 | 2102280.0 |
| 2014-11-11 09:45:00 | AAPL | Stock | 27.1425 | 27.1725 | 27.1238 | 27.125 | 2146448.0 |
| 2014-11-11 09:50:00 | AAPL | Stock | 27.125 | 27.16 | 27.1125 | 27.125 | 2199020.0 |
| 2014-11-11 09:55:00 | AAPL | Stock | 27.1238 | 27.1575 | 27.115 | 27.13 | 1430336.0 |
| 2014-11-11 10:00:00 | AAPL | Stock | 27.1325 | 27.15 | 27.125 | 27.145 | 1327412.0 |
| 2014-11-11 10:05:00 | AAPL | Stock | 27.145 | 27.1488 | 27.135 | 27.14 | 968216.0 |
| 2014-11-11 10:10:00 | AAPL | Stock | 27.14 | 27.1462 | 27.1275 | 27.1375 | 1144336.0 |
| 2014-11-11 10:15:00 | AAPL | Stock | 27.14 | 27.175 | 27.135 | 27.1722 | 2014972.0 |
| 2014-11-11 10:20:00 | AAPL | Stock | 27.1715 | 27.1962 | 27.1625 | 27.1962 | 1683300.0 |
| 2014-11-11 10:25:00 | AAPL | Stock | 27.195 | 27.2175 | 27.195 | 27.2102 | 1647560.0 |
| 2014-11-11 10:30:00 | AAPL | Stock | 27.2105 | 27.225 | 27.185 | 27.1975 | 1531616.0 |
| 2014-11-11 10:35:00 | AAPL | Stock | 27.2025 | 27.245 | 27.2012 | 27.24 | 1586028.0 |
> showing 50 of 354,658 rows — these rows as CSV