PREVIEW / stock_5min / 2019-07-10
file: by_date/stock_5min/2019/2019-07-10.parquet size: 5.7 MB rows: 365,021 symbols: 2,594
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-07-10 04:35:00 | AAPL | Stock | 50.145 | 50.145 | 50.125 | 50.125 | 1200.0 |
| 2019-07-10 05:05:00 | AAPL | Stock | 50.185 | 50.185 | 50.185 | 50.185 | 8480.0 |
| 2019-07-10 05:10:00 | AAPL | Stock | 50.1875 | 50.1875 | 50.1875 | 50.1875 | 400.0 |
| 2019-07-10 05:25:00 | AAPL | Stock | 50.215 | 50.215 | 50.215 | 50.215 | 5576.0 |
| 2019-07-10 05:30:00 | AAPL | Stock | 50.3275 | 50.3275 | 50.3125 | 50.3275 | 2400.0 |
| 2019-07-10 05:40:00 | AAPL | Stock | 50.3275 | 50.3275 | 50.19 | 50.19 | 6400.0 |
| 2019-07-10 05:45:00 | AAPL | Stock | 50.185 | 50.185 | 50.185 | 50.185 | 400.0 |
| 2019-07-10 06:20:00 | AAPL | Stock | 50.1275 | 50.1275 | 50.1275 | 50.1275 | 420.0 |
| 2019-07-10 06:25:00 | AAPL | Stock | 50.145 | 50.145 | 50.145 | 50.145 | 400.0 |
| 2019-07-10 06:35:00 | AAPL | Stock | 50.0825 | 50.0825 | 50.0825 | 50.0825 | 604.0 |
| 2019-07-10 06:55:00 | AAPL | Stock | 50.1025 | 50.1025 | 50.1025 | 50.1025 | 400.0 |
| 2019-07-10 07:00:00 | AAPL | Stock | 50.1675 | 50.1675 | 50.1275 | 50.1275 | 3276.0 |
| 2019-07-10 07:05:00 | AAPL | Stock | 50.1275 | 50.195 | 50.1275 | 50.1925 | 2828.0 |
| 2019-07-10 07:10:00 | AAPL | Stock | 50.195 | 50.22 | 50.1675 | 50.1675 | 4372.0 |
| 2019-07-10 07:15:00 | AAPL | Stock | 50.1675 | 50.1675 | 50.15 | 50.1525 | 3128.0 |
| 2019-07-10 07:20:00 | AAPL | Stock | 50.15 | 50.15 | 50.15 | 50.15 | 1048.0 |
| 2019-07-10 07:25:00 | AAPL | Stock | 50.1525 | 50.1625 | 50.125 | 50.125 | 4348.0 |
| 2019-07-10 07:30:00 | AAPL | Stock | 50.1625 | 50.1625 | 50.125 | 50.125 | 4804.0 |
| 2019-07-10 07:35:00 | AAPL | Stock | 50.125 | 50.15 | 50.0925 | 50.125 | 14660.0 |
| 2019-07-10 07:40:00 | AAPL | Stock | 50.1475 | 50.15 | 50.0625 | 50.1475 | 10972.0 |
| 2019-07-10 07:45:00 | AAPL | Stock | 50.1375 | 50.1475 | 50.1275 | 50.1475 | 2800.0 |
| 2019-07-10 07:50:00 | AAPL | Stock | 50.155 | 50.155 | 50.155 | 50.155 | 400.0 |
| 2019-07-10 07:55:00 | AAPL | Stock | 50.1525 | 50.1525 | 50.1525 | 50.1525 | 1320.0 |
| 2019-07-10 08:00:00 | AAPL | Stock | 50.1925 | 50.435 | 50.125 | 50.435 | 27956.0 |
| 2019-07-10 08:05:00 | AAPL | Stock | 50.155 | 50.155 | 50.0925 | 50.095 | 13080.0 |
| 2019-07-10 08:10:00 | AAPL | Stock | 50.095 | 50.1575 | 50.095 | 50.15 | 2360.0 |
| 2019-07-10 08:15:00 | AAPL | Stock | 50.155 | 50.2 | 50.155 | 50.2 | 4212.0 |
| 2019-07-10 08:20:00 | AAPL | Stock | 50.17 | 50.2 | 50.1675 | 50.2 | 1316.0 |
| 2019-07-10 08:25:00 | AAPL | Stock | 50.16 | 50.195 | 50.15 | 50.195 | 7840.0 |
| 2019-07-10 08:30:00 | AAPL | Stock | 50.205 | 50.49 | 50.205 | 50.44 | 60128.0 |
| 2019-07-10 08:35:00 | AAPL | Stock | 50.4675 | 50.545 | 50.385 | 50.4025 | 106104.0 |
| 2019-07-10 08:40:00 | AAPL | Stock | 50.4125 | 50.5 | 50.4125 | 50.475 | 33564.0 |
| 2019-07-10 08:45:00 | AAPL | Stock | 50.4502 | 50.5 | 50.405 | 50.5 | 70692.0 |
| 2019-07-10 08:50:00 | AAPL | Stock | 50.5 | 50.575 | 50.48 | 50.5325 | 137600.0 |
| 2019-07-10 08:55:00 | AAPL | Stock | 50.5175 | 50.545 | 50.475 | 50.498 | 87520.0 |
| 2019-07-10 09:00:00 | AAPL | Stock | 50.4875 | 50.5 | 50.4425 | 50.475 | 75024.0 |
| 2019-07-10 09:05:00 | AAPL | Stock | 50.475 | 50.475 | 50.45 | 50.46 | 41780.0 |
| 2019-07-10 09:10:00 | AAPL | Stock | 50.4675 | 50.5425 | 50.4675 | 50.5425 | 80644.0 |
| 2019-07-10 09:15:00 | AAPL | Stock | 50.51 | 50.5675 | 50.505 | 50.5675 | 47048.0 |
| 2019-07-10 09:20:00 | AAPL | Stock | 50.5675 | 50.5725 | 50.54 | 50.54 | 23172.0 |
| 2019-07-10 09:25:00 | AAPL | Stock | 50.555 | 50.5725 | 50.4725 | 50.4925 | 67796.0 |
| 2019-07-10 09:30:00 | AAPL | Stock | 50.475 | 50.7625 | 50.39 | 50.7025 | 4621984.0 |
| 2019-07-10 09:35:00 | AAPL | Stock | 50.7075 | 50.8475 | 50.6775 | 50.745 | 1773108.0 |
| 2019-07-10 09:40:00 | AAPL | Stock | 50.743 | 50.817 | 50.725 | 50.745 | 1509468.0 |
| 2019-07-10 09:45:00 | AAPL | Stock | 50.745 | 50.9325 | 50.7425 | 50.885 | 1828180.0 |
| 2019-07-10 09:50:00 | AAPL | Stock | 50.885 | 50.925 | 50.84 | 50.8675 | 1225768.0 |
| 2019-07-10 09:55:00 | AAPL | Stock | 50.8575 | 50.91 | 50.8425 | 50.873 | 1004984.0 |
| 2019-07-10 10:00:00 | AAPL | Stock | 50.875 | 50.8975 | 50.825 | 50.8275 | 904588.0 |
| 2019-07-10 10:05:00 | AAPL | Stock | 50.8288 | 50.8775 | 50.8 | 50.8625 | 847124.0 |
| 2019-07-10 10:10:00 | AAPL | Stock | 50.8588 | 50.8725 | 50.7575 | 50.7925 | 1055540.0 |
> showing 50 of 365,021 rows — these rows as CSV