PREVIEW / stock_5min / 2019-04-29
file: by_date/stock_5min/2019/2019-04-29.parquet size: 5.6 MB rows: 356,967 symbols: 2,639
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-04-29 04:00:00 | AAPL | Stock | 51.095 | 51.095 | 51.095 | 51.095 | 1600.0 |
| 2019-04-29 04:10:00 | AAPL | Stock | 51.095 | 51.12 | 51.095 | 51.12 | 4948.0 |
| 2019-04-29 04:20:00 | AAPL | Stock | 51.12 | 51.12 | 51.12 | 51.12 | 400.0 |
| 2019-04-29 04:35:00 | AAPL | Stock | 51.135 | 51.135 | 51.135 | 51.135 | 400.0 |
| 2019-04-29 04:40:00 | AAPL | Stock | 51.135 | 51.135 | 51.135 | 51.135 | 412.0 |
| 2019-04-29 04:50:00 | AAPL | Stock | 51.135 | 51.135 | 51.12 | 51.12 | 1988.0 |
| 2019-04-29 04:55:00 | AAPL | Stock | 51.12 | 51.12 | 51.12 | 51.12 | 548.0 |
| 2019-04-29 05:15:00 | AAPL | Stock | 51.12 | 51.2 | 51.12 | 51.2 | 4756.0 |
| 2019-04-29 05:20:00 | AAPL | Stock | 51.175 | 51.175 | 51.175 | 51.175 | 3692.0 |
| 2019-04-29 05:25:00 | AAPL | Stock | 51.175 | 51.175 | 51.135 | 51.1425 | 3208.0 |
| 2019-04-29 05:30:00 | AAPL | Stock | 51.1475 | 51.1475 | 51.1475 | 51.1475 | 800.0 |
| 2019-04-29 05:55:00 | AAPL | Stock | 51.12 | 51.12 | 51.12 | 51.12 | 5908.0 |
| 2019-04-29 06:05:00 | AAPL | Stock | 51.13 | 51.13 | 51.1275 | 51.1275 | 5600.0 |
| 2019-04-29 06:10:00 | AAPL | Stock | 51.1275 | 51.1275 | 51.12 | 51.12 | 3248.0 |
| 2019-04-29 06:35:00 | AAPL | Stock | 51.0925 | 51.0925 | 51.0925 | 51.0925 | 1200.0 |
| 2019-04-29 06:40:00 | AAPL | Stock | 51.0925 | 51.0925 | 51.055 | 51.055 | 2000.0 |
| 2019-04-29 06:45:00 | AAPL | Stock | 51.06 | 51.06 | 51.06 | 51.06 | 1104.0 |
| 2019-04-29 06:50:00 | AAPL | Stock | 51.0 | 51.0 | 51.0 | 51.0 | 400.0 |
| 2019-04-29 06:55:00 | AAPL | Stock | 50.9925 | 51.0425 | 50.99 | 51.0425 | 23296.0 |
| 2019-04-29 07:00:00 | AAPL | Stock | 51.0 | 51.07 | 50.9675 | 51.04 | 6832.0 |
| 2019-04-29 07:05:00 | AAPL | Stock | 51.055 | 51.055 | 51.05 | 51.05 | 5800.0 |
| 2019-04-29 07:10:00 | AAPL | Stock | 51.045 | 51.045 | 51.0 | 51.0175 | 2840.0 |
| 2019-04-29 07:15:00 | AAPL | Stock | 51.05 | 51.07 | 51.05 | 51.07 | 1200.0 |
| 2019-04-29 07:20:00 | AAPL | Stock | 51.05 | 51.05 | 51.045 | 51.045 | 1600.0 |
| 2019-04-29 07:35:00 | AAPL | Stock | 51.05 | 51.055 | 51.05 | 51.055 | 1212.0 |
| 2019-04-29 07:40:00 | AAPL | Stock | 51.025 | 51.025 | 51.015 | 51.015 | 5076.0 |
| 2019-04-29 07:45:00 | AAPL | Stock | 51.045 | 51.0575 | 51.0375 | 51.0575 | 19084.0 |
| 2019-04-29 07:50:00 | AAPL | Stock | 51.0575 | 51.0625 | 51.0375 | 51.0625 | 9252.0 |
| 2019-04-29 08:00:00 | AAPL | Stock | 51.04 | 51.075 | 51.0 | 51.0312 | 59304.0 |
| 2019-04-29 08:05:00 | AAPL | Stock | 51.0375 | 51.0625 | 51.0375 | 51.05 | 6412.0 |
| 2019-04-29 08:10:00 | AAPL | Stock | 51.04 | 51.075 | 51.04 | 51.0575 | 22936.0 |
| 2019-04-29 08:15:00 | AAPL | Stock | 51.05 | 51.0625 | 51.05 | 51.0575 | 7800.0 |
| 2019-04-29 08:20:00 | AAPL | Stock | 51.0525 | 51.0525 | 51.03 | 51.03 | 18356.0 |
| 2019-04-29 08:25:00 | AAPL | Stock | 51.065 | 51.0675 | 51.065 | 51.0675 | 1496.0 |
| 2019-04-29 08:30:00 | AAPL | Stock | 51.075 | 51.0825 | 51.045 | 51.055 | 26672.0 |
| 2019-04-29 08:35:00 | AAPL | Stock | 51.1 | 51.105 | 51.08 | 51.0875 | 18352.0 |
| 2019-04-29 08:40:00 | AAPL | Stock | 51.075 | 51.08 | 51.0325 | 51.0625 | 25400.0 |
| 2019-04-29 08:45:00 | AAPL | Stock | 51.0575 | 51.0575 | 51.0125 | 51.025 | 20716.0 |
| 2019-04-29 08:50:00 | AAPL | Stock | 51.0125 | 51.0125 | 51.0125 | 51.0125 | 5972.0 |
| 2019-04-29 08:55:00 | AAPL | Stock | 51.0425 | 51.075 | 51.0125 | 51.03 | 22456.0 |
| 2019-04-29 09:00:00 | AAPL | Stock | 51.06 | 51.065 | 51.06 | 51.065 | 2136.0 |
| 2019-04-29 09:05:00 | AAPL | Stock | 51.055 | 51.0625 | 51.0338 | 51.05 | 4332.0 |
| 2019-04-29 09:10:00 | AAPL | Stock | 51.075 | 51.08 | 51.0675 | 51.08 | 5984.0 |
| 2019-04-29 09:15:00 | AAPL | Stock | 51.105 | 51.125 | 51.095 | 51.125 | 10416.0 |
| 2019-04-29 09:20:00 | AAPL | Stock | 51.1375 | 51.175 | 51.12 | 51.145 | 18636.0 |
| 2019-04-29 09:25:00 | AAPL | Stock | 51.145 | 51.1775 | 51.0675 | 51.0675 | 94140.0 |
| 2019-04-29 09:30:00 | AAPL | Stock | 51.1 | 51.285 | 50.965 | 51.27 | 4231460.0 |
| 2019-04-29 09:35:00 | AAPL | Stock | 51.27 | 51.2762 | 51.1775 | 51.2375 | 1362600.0 |
| 2019-04-29 09:40:00 | AAPL | Stock | 51.2388 | 51.2975 | 51.1888 | 51.2638 | 1425552.0 |
| 2019-04-29 09:45:00 | AAPL | Stock | 51.261 | 51.3175 | 51.0925 | 51.1475 | 2229188.0 |
> showing 50 of 356,967 rows — these rows as CSV