PREVIEW / stock_5min / 2019-11-06
file: by_date/stock_5min/2019/2019-11-06.parquet size: 5.7 MB rows: 362,762 symbols: 2,517
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-11-06 04:10:00 | AAPL | Stock | 64.2375 | 64.2375 | 64.2225 | 64.2225 | 1660.0 |
| 2019-11-06 04:20:00 | AAPL | Stock | 64.275 | 64.275 | 64.275 | 64.275 | 400.0 |
| 2019-11-06 04:25:00 | AAPL | Stock | 64.25 | 64.25 | 64.25 | 64.25 | 4000.0 |
| 2019-11-06 04:30:00 | AAPL | Stock | 64.195 | 64.195 | 64.195 | 64.195 | 1600.0 |
| 2019-11-06 04:45:00 | AAPL | Stock | 64.19 | 64.19 | 64.1875 | 64.1875 | 3080.0 |
| 2019-11-06 04:50:00 | AAPL | Stock | 64.165 | 64.175 | 64.1575 | 64.175 | 14160.0 |
| 2019-11-06 05:00:00 | AAPL | Stock | 64.1925 | 64.195 | 64.1925 | 64.195 | 1316.0 |
| 2019-11-06 05:10:00 | AAPL | Stock | 64.1825 | 64.1825 | 64.175 | 64.175 | 4000.0 |
| 2019-11-06 05:15:00 | AAPL | Stock | 64.1275 | 64.1275 | 64.1275 | 64.1275 | 400.0 |
| 2019-11-06 05:20:00 | AAPL | Stock | 64.1525 | 64.1525 | 64.1525 | 64.1525 | 800.0 |
| 2019-11-06 05:25:00 | AAPL | Stock | 64.1475 | 64.155 | 64.1475 | 64.155 | 1516.0 |
| 2019-11-06 05:40:00 | AAPL | Stock | 64.1625 | 64.1625 | 64.1625 | 64.1625 | 3204.0 |
| 2019-11-06 06:00:00 | AAPL | Stock | 64.175 | 64.175 | 64.175 | 64.175 | 400.0 |
| 2019-11-06 06:05:00 | AAPL | Stock | 64.165 | 64.165 | 64.125 | 64.125 | 9340.0 |
| 2019-11-06 06:10:00 | AAPL | Stock | 64.0375 | 64.0875 | 64.0025 | 64.0875 | 6800.0 |
| 2019-11-06 06:15:00 | AAPL | Stock | 64.1175 | 64.1225 | 64.1175 | 64.1225 | 6108.0 |
| 2019-11-06 06:20:00 | AAPL | Stock | 64.1175 | 64.1175 | 64.1125 | 64.1125 | 1400.0 |
| 2019-11-06 06:25:00 | AAPL | Stock | 64.1175 | 64.1225 | 64.1175 | 64.1225 | 1400.0 |
| 2019-11-06 06:40:00 | AAPL | Stock | 64.115 | 64.115 | 64.115 | 64.115 | 816.0 |
| 2019-11-06 06:45:00 | AAPL | Stock | 64.11 | 64.145 | 64.11 | 64.145 | 4800.0 |
| 2019-11-06 06:50:00 | AAPL | Stock | 64.1075 | 64.1075 | 64.1075 | 64.1075 | 800.0 |
| 2019-11-06 06:55:00 | AAPL | Stock | 64.125 | 64.1375 | 64.125 | 64.135 | 8000.0 |
| 2019-11-06 07:00:00 | AAPL | Stock | 64.15 | 64.15 | 64.125 | 64.1275 | 12816.0 |
| 2019-11-06 07:05:00 | AAPL | Stock | 64.15 | 64.1625 | 64.1425 | 64.1625 | 6292.0 |
| 2019-11-06 07:10:00 | AAPL | Stock | 64.175 | 64.2125 | 64.175 | 64.2125 | 16996.0 |
| 2019-11-06 07:15:00 | AAPL | Stock | 64.1875 | 64.22 | 64.1775 | 64.2125 | 22608.0 |
| 2019-11-06 07:20:00 | AAPL | Stock | 64.215 | 64.235 | 64.215 | 64.23 | 14792.0 |
| 2019-11-06 07:25:00 | AAPL | Stock | 64.23 | 64.23 | 64.2 | 64.2 | 5440.0 |
| 2019-11-06 07:30:00 | AAPL | Stock | 64.1775 | 64.1775 | 64.1775 | 64.1775 | 1200.0 |
| 2019-11-06 07:35:00 | AAPL | Stock | 64.175 | 64.195 | 64.17 | 64.195 | 4804.0 |
| 2019-11-06 07:40:00 | AAPL | Stock | 64.195 | 64.22 | 64.1875 | 64.22 | 3704.0 |
| 2019-11-06 07:45:00 | AAPL | Stock | 64.1925 | 64.1975 | 64.1925 | 64.1975 | 1488.0 |
| 2019-11-06 07:50:00 | AAPL | Stock | 64.1925 | 64.25 | 64.1925 | 64.25 | 31764.0 |
| 2019-11-06 07:55:00 | AAPL | Stock | 64.26 | 64.27 | 64.25 | 64.265 | 8824.0 |
| 2019-11-06 08:00:00 | AAPL | Stock | 64.1875 | 64.27 | 64.1225 | 64.25 | 66948.0 |
| 2019-11-06 08:05:00 | AAPL | Stock | 64.24 | 64.25 | 64.24 | 64.25 | 4520.0 |
| 2019-11-06 08:10:00 | AAPL | Stock | 64.2375 | 64.25 | 64.2075 | 64.225 | 36948.0 |
| 2019-11-06 08:15:00 | AAPL | Stock | 64.2125 | 64.2175 | 64.2075 | 64.2175 | 3196.0 |
| 2019-11-06 08:20:00 | AAPL | Stock | 64.2225 | 64.255 | 64.22 | 64.25 | 16396.0 |
| 2019-11-06 08:25:00 | AAPL | Stock | 64.255 | 64.275 | 64.2325 | 64.2475 | 17132.0 |
| 2019-11-06 08:30:00 | AAPL | Stock | 64.2475 | 64.2575 | 64.245 | 64.25 | 7088.0 |
| 2019-11-06 08:35:00 | AAPL | Stock | 64.2325 | 64.265 | 64.2325 | 64.25 | 6312.0 |
| 2019-11-06 08:40:00 | AAPL | Stock | 64.2625 | 64.3125 | 64.2575 | 64.275 | 58288.0 |
| 2019-11-06 08:45:00 | AAPL | Stock | 64.2875 | 64.2875 | 64.2558 | 64.2558 | 11532.0 |
| 2019-11-06 08:50:00 | AAPL | Stock | 64.2588 | 64.27 | 64.22 | 64.22 | 11424.0 |
| 2019-11-06 08:55:00 | AAPL | Stock | 64.2375 | 64.27 | 64.2375 | 64.27 | 1200.0 |
| 2019-11-06 09:00:00 | AAPL | Stock | 64.2375 | 64.24 | 64.215 | 64.215 | 9676.0 |
| 2019-11-06 09:05:00 | AAPL | Stock | 64.2125 | 64.2125 | 64.1875 | 64.1875 | 21520.0 |
| 2019-11-06 09:10:00 | AAPL | Stock | 64.1975 | 64.2025 | 64.1925 | 64.2025 | 6396.0 |
| 2019-11-06 09:15:00 | AAPL | Stock | 64.2025 | 64.2125 | 64.1925 | 64.2025 | 22860.0 |
> showing 50 of 362,762 rows — these rows as CSV