PREVIEW / stock_1min / 2019-07-10
file: by_date/stock_1min/2019/2019-07-10.parquet size: 15.7 MB rows: 1,103,249 symbols: 2,185
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:39:00 | AAPL | Stock | 50.145 | 50.145 | 50.125 | 50.125 | 1200.0 |
| 2019-07-10 05:07:00 | AAPL | Stock | 50.185 | 50.185 | 50.185 | 50.185 | 5836.0 |
| 2019-07-10 05:08:00 | AAPL | Stock | 50.185 | 50.185 | 50.185 | 50.185 | 1844.0 |
| 2019-07-10 05:09:00 | AAPL | Stock | 50.185 | 50.185 | 50.185 | 50.185 | 800.0 |
| 2019-07-10 05:12:00 | AAPL | Stock | 50.1875 | 50.1875 | 50.1875 | 50.1875 | 400.0 |
| 2019-07-10 05:27:00 | AAPL | Stock | 50.215 | 50.215 | 50.215 | 50.215 | 5576.0 |
| 2019-07-10 05:34: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.3275 | 50.3275 | 2400.0 |
| 2019-07-10 05:41:00 | AAPL | Stock | 50.3275 | 50.3275 | 50.3275 | 50.3275 | 400.0 |
| 2019-07-10 05:42:00 | AAPL | Stock | 50.3275 | 50.3275 | 50.285 | 50.285 | 1200.0 |
| 2019-07-10 05:43:00 | AAPL | Stock | 50.225 | 50.225 | 50.19 | 50.19 | 2000.0 |
| 2019-07-10 05:44:00 | AAPL | Stock | 50.19 | 50.19 | 50.19 | 50.19 | 400.0 |
| 2019-07-10 05:45:00 | AAPL | Stock | 50.185 | 50.185 | 50.185 | 50.185 | 400.0 |
| 2019-07-10 06:21:00 | AAPL | Stock | 50.1275 | 50.1275 | 50.1275 | 50.1275 | 420.0 |
| 2019-07-10 06:29:00 | AAPL | Stock | 50.145 | 50.145 | 50.145 | 50.145 | 400.0 |
| 2019-07-10 06:38:00 | AAPL | Stock | 50.0825 | 50.0825 | 50.0825 | 50.0825 | 604.0 |
| 2019-07-10 06:59: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.1675 | 50.1675 | 2356.0 |
| 2019-07-10 07:04:00 | AAPL | Stock | 50.1625 | 50.1625 | 50.1275 | 50.1275 | 920.0 |
| 2019-07-10 07:05:00 | AAPL | Stock | 50.1275 | 50.1275 | 50.1275 | 50.1275 | 1116.0 |
| 2019-07-10 07:06:00 | AAPL | Stock | 50.1625 | 50.1625 | 50.1625 | 50.1625 | 900.0 |
| 2019-07-10 07:09:00 | AAPL | Stock | 50.195 | 50.195 | 50.1925 | 50.1925 | 812.0 |
| 2019-07-10 07:10:00 | AAPL | Stock | 50.195 | 50.22 | 50.195 | 50.22 | 2772.0 |
| 2019-07-10 07:12:00 | AAPL | Stock | 50.2125 | 50.2125 | 50.2125 | 50.2125 | 800.0 |
| 2019-07-10 07:14:00 | AAPL | Stock | 50.175 | 50.175 | 50.1675 | 50.1675 | 800.0 |
| 2019-07-10 07:15:00 | AAPL | Stock | 50.1675 | 50.1675 | 50.1675 | 50.1675 | 400.0 |
| 2019-07-10 07:16:00 | AAPL | Stock | 50.15 | 50.155 | 50.15 | 50.15 | 1528.0 |
| 2019-07-10 07:18:00 | AAPL | Stock | 50.1675 | 50.1675 | 50.1675 | 50.1675 | 400.0 |
| 2019-07-10 07:19:00 | AAPL | Stock | 50.1625 | 50.1625 | 50.1525 | 50.1525 | 800.0 |
| 2019-07-10 07:20:00 | AAPL | Stock | 50.15 | 50.15 | 50.15 | 50.15 | 1048.0 |
| 2019-07-10 07:26:00 | AAPL | Stock | 50.1525 | 50.1525 | 50.1525 | 50.1525 | 1996.0 |
| 2019-07-10 07:27:00 | AAPL | Stock | 50.1625 | 50.1625 | 50.1625 | 50.1625 | 600.0 |
| 2019-07-10 07:28:00 | AAPL | Stock | 50.1625 | 50.1625 | 50.1625 | 50.1625 | 400.0 |
| 2019-07-10 07:29:00 | AAPL | Stock | 50.1425 | 50.1425 | 50.125 | 50.125 | 1352.0 |
| 2019-07-10 07:30:00 | AAPL | Stock | 50.1625 | 50.1625 | 50.1625 | 50.1625 | 404.0 |
| 2019-07-10 07:31:00 | AAPL | Stock | 50.1625 | 50.1625 | 50.1625 | 50.1625 | 800.0 |
| 2019-07-10 07:32:00 | AAPL | Stock | 50.1625 | 50.1625 | 50.15 | 50.15 | 2400.0 |
| 2019-07-10 07:34:00 | AAPL | Stock | 50.125 | 50.125 | 50.125 | 50.125 | 1200.0 |
| 2019-07-10 07:35:00 | AAPL | Stock | 50.125 | 50.125 | 50.0925 | 50.0925 | 884.0 |
| 2019-07-10 07:36:00 | AAPL | Stock | 50.125 | 50.1375 | 50.125 | 50.135 | 7788.0 |
| 2019-07-10 07:39:00 | AAPL | Stock | 50.15 | 50.15 | 50.125 | 50.125 | 5988.0 |
| 2019-07-10 07:41:00 | AAPL | Stock | 50.1475 | 50.15 | 50.1475 | 50.15 | 2000.0 |
| 2019-07-10 07:43:00 | AAPL | Stock | 50.125 | 50.125 | 50.0625 | 50.07 | 7672.0 |
| 2019-07-10 07:44:00 | AAPL | Stock | 50.125 | 50.1475 | 50.125 | 50.1475 | 1300.0 |
| 2019-07-10 07:45:00 | AAPL | Stock | 50.1375 | 50.145 | 50.1375 | 50.145 | 2000.0 |
| 2019-07-10 07:46:00 | AAPL | Stock | 50.1275 | 50.1275 | 50.1275 | 50.1275 | 400.0 |
| 2019-07-10 07:48:00 | AAPL | Stock | 50.1475 | 50.1475 | 50.1475 | 50.1475 | 400.0 |
| 2019-07-10 07:51:00 | AAPL | Stock | 50.155 | 50.155 | 50.155 | 50.155 | 400.0 |
| 2019-07-10 07:58:00 | AAPL | Stock | 50.1525 | 50.1525 | 50.1525 | 50.1525 | 400.0 |
| 2019-07-10 07:59:00 | AAPL | Stock | 50.1525 | 50.1525 | 50.1525 | 50.1525 | 920.0 |
> showing 50 of 1,103,249 rows — these rows as CSV