PREVIEW / stock_5min / 2019-01-08
file: by_date/stock_5min/2019/2019-01-08.parquet size: 5.7 MB rows: 362,423 symbols: 2,696
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 |
|---|---|---|---|---|---|---|---|
| 2019-01-08 04:00:00 | AAPL | Stock | 37.125 | 37.125 | 37.125 | 37.125 | 400.0 |
| 2019-01-08 04:05:00 | AAPL | Stock | 37.1375 | 37.1375 | 37.1375 | 37.1375 | 536.0 |
| 2019-01-08 04:10:00 | AAPL | Stock | 37.1375 | 37.1375 | 37.1 | 37.135 | 4492.0 |
| 2019-01-08 04:15:00 | AAPL | Stock | 37.15 | 37.15 | 37.15 | 37.15 | 400.0 |
| 2019-01-08 04:20:00 | AAPL | Stock | 37.15 | 37.15 | 37.14 | 37.14 | 8000.0 |
| 2019-01-08 04:25:00 | AAPL | Stock | 37.125 | 37.125 | 37.125 | 37.125 | 400.0 |
| 2019-01-08 04:30:00 | AAPL | Stock | 37.1375 | 37.1375 | 37.125 | 37.125 | 2400.0 |
| 2019-01-08 04:35:00 | AAPL | Stock | 37.125 | 37.125 | 37.125 | 37.125 | 2264.0 |
| 2019-01-08 04:40:00 | AAPL | Stock | 37.125 | 37.125 | 37.0275 | 37.0275 | 1640.0 |
| 2019-01-08 04:45:00 | AAPL | Stock | 37.1125 | 37.125 | 37.1125 | 37.125 | 1120.0 |
| 2019-01-08 05:00:00 | AAPL | Stock | 37.0525 | 37.0525 | 37.0 | 37.0 | 1800.0 |
| 2019-01-08 05:05:00 | AAPL | Stock | 37.0 | 37.0 | 36.9975 | 36.9975 | 1672.0 |
| 2019-01-08 05:10:00 | AAPL | Stock | 36.9975 | 36.9975 | 36.9975 | 36.9975 | 400.0 |
| 2019-01-08 05:35:00 | AAPL | Stock | 37.05 | 37.05 | 37.05 | 37.05 | 15200.0 |
| 2019-01-08 05:45:00 | AAPL | Stock | 37.05 | 37.05 | 37.05 | 37.05 | 400.0 |
| 2019-01-08 05:50:00 | AAPL | Stock | 37.05 | 37.05 | 37.05 | 37.05 | 22400.0 |
| 2019-01-08 06:00:00 | AAPL | Stock | 37.0875 | 37.09 | 37.0875 | 37.0875 | 4744.0 |
| 2019-01-08 06:05:00 | AAPL | Stock | 37.075 | 37.085 | 37.075 | 37.085 | 2500.0 |
| 2019-01-08 06:10:00 | AAPL | Stock | 37.115 | 37.125 | 37.1125 | 37.1125 | 3504.0 |
| 2019-01-08 06:20:00 | AAPL | Stock | 37.0875 | 37.0875 | 37.075 | 37.0875 | 3000.0 |
| 2019-01-08 06:25:00 | AAPL | Stock | 37.1 | 37.1125 | 37.1 | 37.1125 | 3600.0 |
| 2019-01-08 06:30:00 | AAPL | Stock | 37.0875 | 37.0875 | 37.0875 | 37.0875 | 1820.0 |
| 2019-01-08 06:45:00 | AAPL | Stock | 37.105 | 37.115 | 37.105 | 37.115 | 2536.0 |
| 2019-01-08 06:50:00 | AAPL | Stock | 37.105 | 37.1375 | 37.105 | 37.1375 | 29528.0 |
| 2019-01-08 06:55:00 | AAPL | Stock | 37.125 | 37.125 | 37.125 | 37.125 | 400.0 |
| 2019-01-08 07:00:00 | AAPL | Stock | 37.11 | 37.185 | 37.11 | 37.185 | 24880.0 |
| 2019-01-08 07:05:00 | AAPL | Stock | 37.1875 | 37.1875 | 37.15 | 37.15 | 800.0 |
| 2019-01-08 07:10:00 | AAPL | Stock | 37.155 | 37.16 | 37.125 | 37.125 | 29152.0 |
| 2019-01-08 07:15:00 | AAPL | Stock | 37.1225 | 37.1575 | 37.1225 | 37.155 | 6800.0 |
| 2019-01-08 07:20:00 | AAPL | Stock | 37.1625 | 37.1625 | 37.125 | 37.125 | 31984.0 |
| 2019-01-08 07:25:00 | AAPL | Stock | 37.1225 | 37.1425 | 37.1225 | 37.1425 | 4328.0 |
| 2019-01-08 07:30:00 | AAPL | Stock | 37.135 | 37.1425 | 37.135 | 37.14 | 6528.0 |
| 2019-01-08 07:35:00 | AAPL | Stock | 37.1375 | 37.1625 | 37.1375 | 37.1425 | 5864.0 |
| 2019-01-08 07:40:00 | AAPL | Stock | 37.14 | 37.175 | 37.135 | 37.175 | 32856.0 |
| 2019-01-08 07:45:00 | AAPL | Stock | 37.175 | 37.175 | 37.0875 | 37.0875 | 26868.0 |
| 2019-01-08 07:50:00 | AAPL | Stock | 37.0825 | 37.145 | 37.0775 | 37.145 | 44592.0 |
| 2019-01-08 07:55:00 | AAPL | Stock | 37.15 | 37.1625 | 37.0925 | 37.1325 | 32116.0 |
| 2019-01-08 08:00:00 | AAPL | Stock | 37.1625 | 37.1875 | 37.1175 | 37.1325 | 163576.0 |
| 2019-01-08 08:05:00 | AAPL | Stock | 37.1425 | 37.1425 | 37.1 | 37.1 | 47660.0 |
| 2019-01-08 08:10:00 | AAPL | Stock | 37.1 | 37.1 | 37.0675 | 37.0875 | 28344.0 |
| 2019-01-08 08:15:00 | AAPL | Stock | 37.09 | 37.145 | 37.09 | 37.12 | 34600.0 |
| 2019-01-08 08:20:00 | AAPL | Stock | 37.13 | 37.15 | 37.125 | 37.145 | 34564.0 |
| 2019-01-08 08:25:00 | AAPL | Stock | 37.145 | 37.1475 | 37.12 | 37.12 | 5256.0 |
| 2019-01-08 08:30:00 | AAPL | Stock | 37.1 | 37.1425 | 37.095 | 37.1 | 30360.0 |
| 2019-01-08 08:35:00 | AAPL | Stock | 37.095 | 37.1425 | 37.095 | 37.1425 | 10780.0 |
| 2019-01-08 08:40:00 | AAPL | Stock | 37.1325 | 37.175 | 37.1325 | 37.1725 | 44820.0 |
| 2019-01-08 08:45:00 | AAPL | Stock | 37.1725 | 37.18 | 37.15 | 37.1525 | 62160.0 |
| 2019-01-08 08:50:00 | AAPL | Stock | 37.1675 | 37.2225 | 37.1625 | 37.2075 | 61256.0 |
| 2019-01-08 08:55:00 | AAPL | Stock | 37.1925 | 37.24 | 37.1925 | 37.24 | 130276.0 |
| 2019-01-08 09:00:00 | AAPL | Stock | 37.24 | 37.25 | 37.2225 | 37.225 | 59788.0 |
> showing 50 of 362,423 rows — these rows as CSV