PREVIEW / stock_5min / 2017-05-11
file: by_date/stock_5min/2017/2017-05-11.parquet size: 5.4 MB rows: 353,862 symbols: 3,034
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-05-11 04:00:00 | AAPL | Stock | 38.3225 | 38.3225 | 38.3225 | 38.3225 | 400.0 |
| 2017-05-11 04:05:00 | AAPL | Stock | 38.2325 | 38.2325 | 38.2325 | 38.2325 | 2000.0 |
| 2017-05-11 04:35:00 | AAPL | Stock | 38.2075 | 38.2075 | 38.2075 | 38.2075 | 484.0 |
| 2017-05-11 05:55:00 | AAPL | Stock | 38.18 | 38.18 | 38.18 | 38.18 | 400.0 |
| 2017-05-11 06:05:00 | AAPL | Stock | 38.1875 | 38.1875 | 38.1875 | 38.1875 | 400.0 |
| 2017-05-11 06:10:00 | AAPL | Stock | 38.2025 | 38.2025 | 38.2 | 38.2 | 1600.0 |
| 2017-05-11 06:40:00 | AAPL | Stock | 38.1975 | 38.1975 | 38.1975 | 38.1975 | 6020.0 |
| 2017-05-11 06:45:00 | AAPL | Stock | 38.175 | 38.175 | 38.175 | 38.175 | 1600.0 |
| 2017-05-11 07:00:00 | AAPL | Stock | 38.1525 | 38.1525 | 38.105 | 38.12 | 22864.0 |
| 2017-05-11 07:05:00 | AAPL | Stock | 38.12 | 38.12 | 38.12 | 38.12 | 2548.0 |
| 2017-05-11 07:10:00 | AAPL | Stock | 38.1325 | 38.175 | 38.1325 | 38.1325 | 6656.0 |
| 2017-05-11 07:15:00 | AAPL | Stock | 38.1675 | 38.175 | 38.1675 | 38.175 | 6000.0 |
| 2017-05-11 07:20:00 | AAPL | Stock | 38.17 | 38.17 | 38.15 | 38.15 | 5324.0 |
| 2017-05-11 07:25:00 | AAPL | Stock | 38.14 | 38.1425 | 38.135 | 38.1425 | 8256.0 |
| 2017-05-11 07:30:00 | AAPL | Stock | 38.1425 | 38.15 | 38.1425 | 38.15 | 3600.0 |
| 2017-05-11 07:35:00 | AAPL | Stock | 38.15 | 38.1625 | 38.1475 | 38.1625 | 22000.0 |
| 2017-05-11 07:40:00 | AAPL | Stock | 38.1675 | 38.1675 | 38.1375 | 38.1375 | 10868.0 |
| 2017-05-11 07:45:00 | AAPL | Stock | 38.1375 | 38.1375 | 38.125 | 38.125 | 50808.0 |
| 2017-05-11 07:50:00 | AAPL | Stock | 38.125 | 38.13 | 38.125 | 38.13 | 4700.0 |
| 2017-05-11 08:00:00 | AAPL | Stock | 38.145 | 38.175 | 38.12 | 38.15 | 95616.0 |
| 2017-05-11 08:05:00 | AAPL | Stock | 38.15 | 38.1575 | 38.145 | 38.1575 | 37092.0 |
| 2017-05-11 08:10:00 | AAPL | Stock | 38.155 | 38.1625 | 38.13 | 38.145 | 31184.0 |
| 2017-05-11 08:15:00 | AAPL | Stock | 38.15 | 38.1575 | 38.15 | 38.15 | 8992.0 |
| 2017-05-11 08:20:00 | AAPL | Stock | 38.1575 | 38.1575 | 38.15 | 38.15 | 1200.0 |
| 2017-05-11 08:25:00 | AAPL | Stock | 38.1575 | 38.165 | 38.1425 | 38.165 | 32168.0 |
| 2017-05-11 08:30:00 | AAPL | Stock | 38.1425 | 38.165 | 38.1375 | 38.1625 | 23468.0 |
| 2017-05-11 08:35:00 | AAPL | Stock | 38.1675 | 38.2 | 38.1675 | 38.1925 | 25220.0 |
| 2017-05-11 08:40:00 | AAPL | Stock | 38.1925 | 38.2025 | 38.1875 | 38.2 | 22588.0 |
| 2017-05-11 08:45:00 | AAPL | Stock | 38.2025 | 38.215 | 38.2 | 38.2 | 15836.0 |
| 2017-05-11 08:50:00 | AAPL | Stock | 38.2 | 38.2 | 38.18 | 38.18 | 17512.0 |
| 2017-05-11 08:55:00 | AAPL | Stock | 38.18 | 38.18 | 38.1675 | 38.17 | 17200.0 |
| 2017-05-11 09:00:00 | AAPL | Stock | 38.1675 | 38.1675 | 38.1575 | 38.1575 | 14048.0 |
| 2017-05-11 09:05:00 | AAPL | Stock | 38.1675 | 38.1675 | 38.16 | 38.1625 | 29296.0 |
| 2017-05-11 09:10:00 | AAPL | Stock | 38.1575 | 38.1625 | 38.155 | 38.155 | 6000.0 |
| 2017-05-11 09:15:00 | AAPL | Stock | 38.155 | 38.1625 | 38.155 | 38.1625 | 6000.0 |
| 2017-05-11 09:20:00 | AAPL | Stock | 38.165 | 38.1675 | 38.165 | 38.1675 | 5196.0 |
| 2017-05-11 09:25:00 | AAPL | Stock | 38.155 | 38.1675 | 38.155 | 38.1675 | 16328.0 |
| 2017-05-11 09:30:00 | AAPL | Stock | 38.1125 | 38.2825 | 38.1125 | 38.2525 | 4419196.0 |
| 2017-05-11 09:35:00 | AAPL | Stock | 38.255 | 38.36 | 38.2175 | 38.313 | 2471560.0 |
| 2017-05-11 09:40:00 | AAPL | Stock | 38.3125 | 38.39 | 38.3 | 38.3525 | 2328564.0 |
| 2017-05-11 09:45:00 | AAPL | Stock | 38.35 | 38.35 | 38.24 | 38.3095 | 1863828.0 |
| 2017-05-11 09:50:00 | AAPL | Stock | 38.3073 | 38.31 | 38.2025 | 38.2088 | 1380668.0 |
| 2017-05-11 09:55:00 | AAPL | Stock | 38.21 | 38.22 | 38.0875 | 38.14 | 2178796.0 |
| 2017-05-11 10:00:00 | AAPL | Stock | 38.135 | 38.14 | 38.0775 | 38.125 | 1744772.0 |
| 2017-05-11 10:05:00 | AAPL | Stock | 38.125 | 38.2075 | 38.0975 | 38.1968 | 1634500.0 |
| 2017-05-11 10:10:00 | AAPL | Stock | 38.1982 | 38.2275 | 38.185 | 38.2025 | 1362804.0 |
| 2017-05-11 10:15:00 | AAPL | Stock | 38.2025 | 38.235 | 38.18 | 38.2075 | 962884.0 |
| 2017-05-11 10:20:00 | AAPL | Stock | 38.2075 | 38.2138 | 38.15 | 38.19 | 1485916.0 |
| 2017-05-11 10:25:00 | AAPL | Stock | 38.1875 | 38.2025 | 38.155 | 38.1875 | 1008844.0 |
| 2017-05-11 10:30:00 | AAPL | Stock | 38.1875 | 38.1915 | 38.1075 | 38.155 | 957720.0 |
> showing 50 of 353,862 rows — these rows as CSV