PREVIEW / stock_5min / 2019-01-07
file: by_date/stock_5min/2019/2019-01-07.parquet size: 5.8 MB rows: 367,785 symbols: 2,698
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-07 04:00:00 | AAPL | Stock | 37.1625 | 37.1625 | 37.1375 | 37.1375 | 2188.0 |
| 2019-01-07 04:05:00 | AAPL | Stock | 37.1875 | 37.225 | 37.1875 | 37.2 | 9820.0 |
| 2019-01-07 04:10:00 | AAPL | Stock | 37.2 | 37.2125 | 37.1875 | 37.1875 | 1200.0 |
| 2019-01-07 04:15:00 | AAPL | Stock | 37.175 | 37.18 | 37.1275 | 37.165 | 14172.0 |
| 2019-01-07 04:20:00 | AAPL | Stock | 37.15 | 37.15 | 37.15 | 37.15 | 2000.0 |
| 2019-01-07 04:25:00 | AAPL | Stock | 37.1375 | 37.1375 | 37.095 | 37.095 | 1392.0 |
| 2019-01-07 04:30:00 | AAPL | Stock | 37.115 | 37.115 | 37.115 | 37.115 | 400.0 |
| 2019-01-07 04:35:00 | AAPL | Stock | 37.1125 | 37.1125 | 37.1125 | 37.1125 | 1916.0 |
| 2019-01-07 04:40:00 | AAPL | Stock | 37.0925 | 37.0925 | 37.0625 | 37.0625 | 4612.0 |
| 2019-01-07 04:45:00 | AAPL | Stock | 37.0625 | 37.0625 | 37.0625 | 37.0625 | 400.0 |
| 2019-01-07 04:50:00 | AAPL | Stock | 37.0575 | 37.0575 | 37.0575 | 37.0575 | 1600.0 |
| 2019-01-07 04:55:00 | AAPL | Stock | 37.04 | 37.04 | 37.0375 | 37.0375 | 940.0 |
| 2019-01-07 05:00:00 | AAPL | Stock | 37.05 | 37.05 | 37.05 | 37.05 | 1788.0 |
| 2019-01-07 05:05:00 | AAPL | Stock | 37.0625 | 37.0625 | 37.0625 | 37.0625 | 2060.0 |
| 2019-01-07 05:10:00 | AAPL | Stock | 37.065 | 37.0875 | 37.0625 | 37.075 | 12224.0 |
| 2019-01-07 05:15:00 | AAPL | Stock | 37.1 | 37.1 | 37.1 | 37.1 | 1200.0 |
| 2019-01-07 05:20:00 | AAPL | Stock | 37.1 | 37.1275 | 37.075 | 37.1275 | 10328.0 |
| 2019-01-07 05:25:00 | AAPL | Stock | 37.145 | 37.1475 | 37.145 | 37.1475 | 1000.0 |
| 2019-01-07 05:30:00 | AAPL | Stock | 37.12 | 37.12 | 37.075 | 37.075 | 14184.0 |
| 2019-01-07 05:35:00 | AAPL | Stock | 37.075 | 37.075 | 37.075 | 37.075 | 12400.0 |
| 2019-01-07 05:40:00 | AAPL | Stock | 37.015 | 37.135 | 37.015 | 37.135 | 6724.0 |
| 2019-01-07 05:45:00 | AAPL | Stock | 37.0 | 37.0 | 37.0 | 37.0 | 936.0 |
| 2019-01-07 05:50:00 | AAPL | Stock | 37.1 | 37.1 | 37.1 | 37.1 | 1520.0 |
| 2019-01-07 05:55:00 | AAPL | Stock | 37.1125 | 37.125 | 37.1125 | 37.125 | 4800.0 |
| 2019-01-07 06:00:00 | AAPL | Stock | 37.125 | 37.125 | 37.0975 | 37.0975 | 3696.0 |
| 2019-01-07 06:05:00 | AAPL | Stock | 37.0525 | 37.055 | 37.0525 | 37.055 | 2112.0 |
| 2019-01-07 06:10:00 | AAPL | Stock | 37.045 | 37.045 | 37.0 | 37.0125 | 2076.0 |
| 2019-01-07 06:15:00 | AAPL | Stock | 37.1 | 37.1 | 36.9975 | 36.9975 | 6808.0 |
| 2019-01-07 06:20:00 | AAPL | Stock | 36.9975 | 36.9975 | 36.9975 | 36.9975 | 400.0 |
| 2019-01-07 06:25:00 | AAPL | Stock | 37.05 | 37.05 | 37.05 | 37.05 | 488.0 |
| 2019-01-07 06:30:00 | AAPL | Stock | 37.0625 | 37.0625 | 37.045 | 37.0625 | 5600.0 |
| 2019-01-07 06:35:00 | AAPL | Stock | 37.05 | 37.05 | 37.0075 | 37.0075 | 1836.0 |
| 2019-01-07 06:45:00 | AAPL | Stock | 37.05 | 37.06 | 37.05 | 37.06 | 1200.0 |
| 2019-01-07 06:50:00 | AAPL | Stock | 37.05 | 37.07 | 37.05 | 37.07 | 2976.0 |
| 2019-01-07 06:55:00 | AAPL | Stock | 37.0575 | 37.0575 | 37.05 | 37.0575 | 4176.0 |
| 2019-01-07 07:00:00 | AAPL | Stock | 37.0525 | 37.15 | 37.0525 | 37.125 | 25580.0 |
| 2019-01-07 07:05:00 | AAPL | Stock | 37.125 | 37.1725 | 37.0675 | 37.075 | 12064.0 |
| 2019-01-07 07:10:00 | AAPL | Stock | 37.0675 | 37.075 | 37.0475 | 37.055 | 4260.0 |
| 2019-01-07 07:15:00 | AAPL | Stock | 37.0525 | 37.12 | 37.0525 | 37.12 | 8240.0 |
| 2019-01-07 07:20:00 | AAPL | Stock | 37.1 | 37.12 | 37.0875 | 37.115 | 7460.0 |
| 2019-01-07 07:25:00 | AAPL | Stock | 37.0975 | 37.0975 | 37.0625 | 37.0625 | 3520.0 |
| 2019-01-07 07:30:00 | AAPL | Stock | 37.0875 | 37.115 | 37.0675 | 37.1075 | 9824.0 |
| 2019-01-07 07:35:00 | AAPL | Stock | 37.1 | 37.1 | 37.0125 | 37.02 | 29360.0 |
| 2019-01-07 07:40:00 | AAPL | Stock | 37.0125 | 37.0375 | 37.0025 | 37.0125 | 33516.0 |
| 2019-01-07 07:45:00 | AAPL | Stock | 37.0375 | 37.1075 | 37.035 | 37.075 | 41528.0 |
| 2019-01-07 07:50:00 | AAPL | Stock | 37.07 | 37.07 | 37.0625 | 37.07 | 24888.0 |
| 2019-01-07 07:55:00 | AAPL | Stock | 37.1 | 37.115 | 37.08 | 37.1 | 26524.0 |
| 2019-01-07 08:00:00 | AAPL | Stock | 37.1882 | 37.1882 | 37.0 | 37.075 | 125952.0 |
| 2019-01-07 08:05:00 | AAPL | Stock | 37.1 | 37.1125 | 37.0625 | 37.1 | 53516.0 |
| 2019-01-07 08:10:00 | AAPL | Stock | 37.11 | 37.1125 | 37.075 | 37.075 | 30372.0 |
> showing 50 of 367,785 rows — these rows as CSV