PREVIEW / stock_5min / 2019-12-16
file: by_date/stock_5min/2019/2019-12-16.parquet size: 6.1 MB rows: 379,182 symbols: 2,521
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-12-16 04:00:00 | AAPL | Stock | 68.94 | 69.0775 | 68.94 | 69.075 | 11452.0 |
| 2019-12-16 04:05:00 | AAPL | Stock | 69.0925 | 69.0925 | 69.0925 | 69.0925 | 436.0 |
| 2019-12-16 04:10:00 | AAPL | Stock | 69.05 | 69.0975 | 69.05 | 69.0975 | 7272.0 |
| 2019-12-16 04:20:00 | AAPL | Stock | 69.0975 | 69.1175 | 69.0975 | 69.1175 | 2036.0 |
| 2019-12-16 04:25:00 | AAPL | Stock | 69.13 | 69.1475 | 69.13 | 69.1475 | 3720.0 |
| 2019-12-16 04:30:00 | AAPL | Stock | 69.125 | 69.125 | 69.125 | 69.125 | 1100.0 |
| 2019-12-16 04:40:00 | AAPL | Stock | 69.165 | 69.165 | 69.165 | 69.165 | 776.0 |
| 2019-12-16 04:50:00 | AAPL | Stock | 69.15 | 69.1875 | 69.15 | 69.1875 | 2124.0 |
| 2019-12-16 04:55:00 | AAPL | Stock | 69.1625 | 69.205 | 69.1625 | 69.205 | 4360.0 |
| 2019-12-16 05:00:00 | AAPL | Stock | 69.1775 | 69.1775 | 69.1775 | 69.1775 | 1200.0 |
| 2019-12-16 05:15:00 | AAPL | Stock | 69.1375 | 69.1375 | 69.1375 | 69.1375 | 7400.0 |
| 2019-12-16 05:20:00 | AAPL | Stock | 69.115 | 69.115 | 69.115 | 69.115 | 400.0 |
| 2019-12-16 05:30:00 | AAPL | Stock | 69.115 | 69.115 | 69.0875 | 69.1 | 15960.0 |
| 2019-12-16 05:40:00 | AAPL | Stock | 69.1 | 69.1 | 69.0875 | 69.0875 | 1344.0 |
| 2019-12-16 05:50:00 | AAPL | Stock | 69.05 | 69.0825 | 69.05 | 69.0825 | 8000.0 |
| 2019-12-16 05:55:00 | AAPL | Stock | 69.11 | 69.125 | 69.11 | 69.1125 | 3260.0 |
| 2019-12-16 06:00:00 | AAPL | Stock | 69.1325 | 69.1325 | 69.1325 | 69.1325 | 400.0 |
| 2019-12-16 06:05:00 | AAPL | Stock | 69.1625 | 69.19 | 69.1625 | 69.19 | 800.0 |
| 2019-12-16 06:10:00 | AAPL | Stock | 69.1375 | 69.19 | 69.1125 | 69.19 | 3600.0 |
| 2019-12-16 06:15:00 | AAPL | Stock | 69.1675 | 69.17 | 69.1675 | 69.17 | 1212.0 |
| 2019-12-16 06:25:00 | AAPL | Stock | 69.2 | 69.2 | 69.2 | 69.2 | 1676.0 |
| 2019-12-16 06:45:00 | AAPL | Stock | 69.1625 | 69.1625 | 69.1625 | 69.1625 | 1200.0 |
| 2019-12-16 07:00:00 | AAPL | Stock | 69.125 | 69.175 | 69.1 | 69.1175 | 49216.0 |
| 2019-12-16 07:05:00 | AAPL | Stock | 69.1125 | 69.125 | 69.085 | 69.1125 | 25900.0 |
| 2019-12-16 07:10:00 | AAPL | Stock | 69.12 | 69.1475 | 69.1125 | 69.1475 | 20392.0 |
| 2019-12-16 07:15:00 | AAPL | Stock | 69.15 | 69.2 | 69.15 | 69.2 | 16236.0 |
| 2019-12-16 07:20:00 | AAPL | Stock | 69.1975 | 69.1975 | 69.1725 | 69.195 | 20476.0 |
| 2019-12-16 07:25:00 | AAPL | Stock | 69.165 | 69.1975 | 69.165 | 69.1875 | 16884.0 |
| 2019-12-16 07:30:00 | AAPL | Stock | 69.175 | 69.2 | 69.175 | 69.175 | 10536.0 |
| 2019-12-16 07:35:00 | AAPL | Stock | 69.1875 | 69.195 | 69.175 | 69.18 | 4800.0 |
| 2019-12-16 07:40:00 | AAPL | Stock | 69.195 | 69.2175 | 69.17 | 69.2125 | 7808.0 |
| 2019-12-16 07:45:00 | AAPL | Stock | 69.2 | 69.2175 | 69.1925 | 69.2175 | 9672.0 |
| 2019-12-16 07:50:00 | AAPL | Stock | 69.225 | 69.2275 | 69.2 | 69.2 | 24060.0 |
| 2019-12-16 07:55:00 | AAPL | Stock | 69.225 | 69.2375 | 69.225 | 69.235 | 4120.0 |
| 2019-12-16 08:00:00 | AAPL | Stock | 69.1125 | 69.3 | 69.085 | 69.28 | 234896.0 |
| 2019-12-16 08:05:00 | AAPL | Stock | 69.2875 | 69.2875 | 69.2275 | 69.2375 | 61124.0 |
| 2019-12-16 08:10:00 | AAPL | Stock | 69.25 | 69.2725 | 69.2375 | 69.2575 | 43336.0 |
| 2019-12-16 08:15:00 | AAPL | Stock | 69.25 | 69.3375 | 69.2375 | 69.325 | 139476.0 |
| 2019-12-16 08:20:00 | AAPL | Stock | 69.335 | 69.3575 | 69.3 | 69.3 | 64400.0 |
| 2019-12-16 08:25:00 | AAPL | Stock | 69.3125 | 69.33 | 69.29 | 69.29 | 54012.0 |
| 2019-12-16 08:30:00 | AAPL | Stock | 69.2875 | 69.325 | 69.275 | 69.28 | 70344.0 |
| 2019-12-16 08:35:00 | AAPL | Stock | 69.26 | 69.275 | 69.25 | 69.275 | 38244.0 |
| 2019-12-16 08:40:00 | AAPL | Stock | 69.2525 | 69.27 | 69.25 | 69.2698 | 10256.0 |
| 2019-12-16 08:45:00 | AAPL | Stock | 69.27 | 69.3 | 69.2525 | 69.3 | 59548.0 |
| 2019-12-16 08:50:00 | AAPL | Stock | 69.3222 | 69.3225 | 69.2625 | 69.28 | 27808.0 |
| 2019-12-16 08:55:00 | AAPL | Stock | 69.2725 | 69.3 | 69.2725 | 69.2875 | 21364.0 |
| 2019-12-16 09:00:00 | AAPL | Stock | 69.3 | 69.35 | 69.3 | 69.3425 | 105892.0 |
| 2019-12-16 09:05:00 | AAPL | Stock | 69.3375 | 69.3525 | 69.325 | 69.3325 | 50256.0 |
| 2019-12-16 09:10:00 | AAPL | Stock | 69.3475 | 69.365 | 69.3475 | 69.365 | 53728.0 |
| 2019-12-16 09:15:00 | AAPL | Stock | 69.3575 | 69.365 | 69.3125 | 69.325 | 56816.0 |
> showing 50 of 379,182 rows — these rows as CSV