PREVIEW / stock_5min / 2019-08-13
file: by_date/stock_5min/2019/2019-08-13.parquet size: 5.7 MB rows: 360,737 symbols: 2,571
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-08-13 04:25:00 | AAPL | Stock | 50.015 | 50.015 | 50.015 | 50.015 | 748.0 |
| 2019-08-13 04:40:00 | AAPL | Stock | 50.0675 | 50.0675 | 50.0675 | 50.0675 | 400.0 |
| 2019-08-13 05:00:00 | AAPL | Stock | 50.0 | 50.0 | 49.9975 | 49.9975 | 3320.0 |
| 2019-08-13 05:10:00 | AAPL | Stock | 50.0 | 50.0 | 49.88 | 49.88 | 5600.0 |
| 2019-08-13 05:15:00 | AAPL | Stock | 49.825 | 49.825 | 49.825 | 49.825 | 1000.0 |
| 2019-08-13 05:20:00 | AAPL | Stock | 49.83 | 49.83 | 49.83 | 49.83 | 772.0 |
| 2019-08-13 05:25:00 | AAPL | Stock | 49.8375 | 49.8375 | 49.8 | 49.8 | 18640.0 |
| 2019-08-13 05:30:00 | AAPL | Stock | 49.7625 | 49.7675 | 49.7625 | 49.7675 | 800.0 |
| 2019-08-13 05:35:00 | AAPL | Stock | 49.8125 | 49.8125 | 49.78 | 49.78 | 4400.0 |
| 2019-08-13 05:40:00 | AAPL | Stock | 49.835 | 49.835 | 49.835 | 49.835 | 400.0 |
| 2019-08-13 05:45:00 | AAPL | Stock | 49.8325 | 49.8325 | 49.83 | 49.83 | 800.0 |
| 2019-08-13 06:05:00 | AAPL | Stock | 49.8525 | 49.8525 | 49.8525 | 49.8525 | 800.0 |
| 2019-08-13 06:10:00 | AAPL | Stock | 49.9 | 49.9 | 49.8525 | 49.86 | 4680.0 |
| 2019-08-13 06:15:00 | AAPL | Stock | 49.86 | 49.86 | 49.74 | 49.8475 | 3016.0 |
| 2019-08-13 06:30:00 | AAPL | Stock | 49.9725 | 49.9975 | 49.96 | 49.965 | 2000.0 |
| 2019-08-13 06:35:00 | AAPL | Stock | 49.9625 | 50.0 | 49.9625 | 50.0 | 18772.0 |
| 2019-08-13 06:40:00 | AAPL | Stock | 49.995 | 50.0 | 49.995 | 50.0 | 6828.0 |
| 2019-08-13 06:45:00 | AAPL | Stock | 50.0 | 50.0 | 50.0 | 50.0 | 800.0 |
| 2019-08-13 06:50:00 | AAPL | Stock | 50.03 | 50.03 | 50.03 | 50.03 | 800.0 |
| 2019-08-13 07:00:00 | AAPL | Stock | 50.0 | 50.135 | 50.0 | 50.06 | 32960.0 |
| 2019-08-13 07:05:00 | AAPL | Stock | 50.0975 | 50.1325 | 50.06 | 50.1325 | 47468.0 |
| 2019-08-13 07:10:00 | AAPL | Stock | 50.1625 | 50.25 | 50.15 | 50.2125 | 9344.0 |
| 2019-08-13 07:15:00 | AAPL | Stock | 50.155 | 50.155 | 50.125 | 50.125 | 20592.0 |
| 2019-08-13 07:20:00 | AAPL | Stock | 50.13 | 50.1375 | 50.125 | 50.125 | 17124.0 |
| 2019-08-13 07:25:00 | AAPL | Stock | 50.125 | 50.1275 | 50.085 | 50.1025 | 37624.0 |
| 2019-08-13 07:30:00 | AAPL | Stock | 50.1025 | 50.1025 | 50.0625 | 50.0625 | 21136.0 |
| 2019-08-13 07:35:00 | AAPL | Stock | 50.075 | 50.16 | 50.075 | 50.16 | 4400.0 |
| 2019-08-13 07:40:00 | AAPL | Stock | 50.125 | 50.1375 | 50.11 | 50.11 | 4000.0 |
| 2019-08-13 07:45:00 | AAPL | Stock | 50.1075 | 50.125 | 50.08 | 50.08 | 7344.0 |
| 2019-08-13 07:50:00 | AAPL | Stock | 50.1 | 50.165 | 50.1 | 50.1475 | 12252.0 |
| 2019-08-13 07:55:00 | AAPL | Stock | 50.175 | 50.2075 | 50.1625 | 50.18 | 16240.0 |
| 2019-08-13 08:00:00 | AAPL | Stock | 50.1175 | 50.2 | 50.0 | 50.125 | 40004.0 |
| 2019-08-13 08:05:00 | AAPL | Stock | 50.125 | 50.125 | 50.125 | 50.125 | 4000.0 |
| 2019-08-13 08:10:00 | AAPL | Stock | 50.125 | 50.15 | 50.1075 | 50.125 | 24484.0 |
| 2019-08-13 08:15:00 | AAPL | Stock | 50.13 | 50.175 | 50.13 | 50.175 | 1600.0 |
| 2019-08-13 08:20:00 | AAPL | Stock | 50.195 | 50.195 | 50.14 | 50.14 | 2400.0 |
| 2019-08-13 08:25:00 | AAPL | Stock | 50.175 | 50.2125 | 50.1525 | 50.2125 | 6764.0 |
| 2019-08-13 08:30:00 | AAPL | Stock | 50.1375 | 50.2028 | 50.075 | 50.1025 | 19432.0 |
| 2019-08-13 08:35:00 | AAPL | Stock | 50.1525 | 50.1525 | 49.99 | 50.0375 | 40444.0 |
| 2019-08-13 08:40:00 | AAPL | Stock | 50.0375 | 50.08 | 50.01 | 50.07 | 11416.0 |
| 2019-08-13 08:45:00 | AAPL | Stock | 50.0625 | 50.0825 | 49.9895 | 49.9925 | 10516.0 |
| 2019-08-13 08:50:00 | AAPL | Stock | 49.9825 | 50.025 | 49.9825 | 50.025 | 2416.0 |
| 2019-08-13 08:55:00 | AAPL | Stock | 50.04 | 50.08 | 50.0225 | 50.08 | 20016.0 |
| 2019-08-13 09:00:00 | AAPL | Stock | 50.08 | 50.08 | 50.03 | 50.0525 | 19464.0 |
| 2019-08-13 09:05:00 | AAPL | Stock | 50.05 | 50.125 | 50.05 | 50.1225 | 20920.0 |
| 2019-08-13 09:10:00 | AAPL | Stock | 50.125 | 50.2065 | 50.0875 | 50.2065 | 38484.0 |
| 2019-08-13 09:15:00 | AAPL | Stock | 50.1775 | 50.25 | 50.1675 | 50.2275 | 51712.0 |
| 2019-08-13 09:20:00 | AAPL | Stock | 50.24 | 50.325 | 50.2375 | 50.25 | 121952.0 |
| 2019-08-13 09:25:00 | AAPL | Stock | 50.2375 | 50.31 | 50.205 | 50.25 | 40664.0 |
| 2019-08-13 09:30:00 | AAPL | Stock | 50.255 | 50.605 | 50.2075 | 50.59 | 4755176.0 |
> showing 50 of 360,737 rows — these rows as CSV