PREVIEW / stock_1min / 2020-01-17
file: by_date/stock_1min/2020/2020-01-17.parquet size: 17.6 MB rows: 1,125,175 symbols: 2,083
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 |
|---|---|---|---|---|---|---|---|
| 2020-01-17 04:00:00 | AAPL | Stock | 79.01 | 79.05 | 79.01 | 79.05 | 5696.0 |
| 2020-01-17 04:06:00 | AAPL | Stock | 79.1 | 79.1375 | 79.1 | 79.1375 | 864.0 |
| 2020-01-17 04:07:00 | AAPL | Stock | 79.15 | 79.15 | 79.15 | 79.15 | 400.0 |
| 2020-01-17 04:08:00 | AAPL | Stock | 79.1525 | 79.1525 | 79.1525 | 79.1525 | 1004.0 |
| 2020-01-17 04:10:00 | AAPL | Stock | 79.1975 | 79.1975 | 79.1975 | 79.1975 | 800.0 |
| 2020-01-17 04:12:00 | AAPL | Stock | 79.2225 | 79.2225 | 79.2225 | 79.2225 | 400.0 |
| 2020-01-17 04:13:00 | AAPL | Stock | 79.25 | 79.25 | 79.25 | 79.25 | 7784.0 |
| 2020-01-17 04:25:00 | AAPL | Stock | 79.26 | 79.26 | 79.26 | 79.26 | 1200.0 |
| 2020-01-17 04:31:00 | AAPL | Stock | 79.2625 | 79.2625 | 79.2625 | 79.2625 | 800.0 |
| 2020-01-17 04:38:00 | AAPL | Stock | 79.3 | 79.3 | 79.3 | 79.3 | 440.0 |
| 2020-01-17 04:39:00 | AAPL | Stock | 79.21 | 79.21 | 79.21 | 79.21 | 1872.0 |
| 2020-01-17 04:48:00 | AAPL | Stock | 79.2325 | 79.2625 | 79.2325 | 79.2625 | 1960.0 |
| 2020-01-17 04:50:00 | AAPL | Stock | 79.2625 | 79.2625 | 79.2625 | 79.2625 | 400.0 |
| 2020-01-17 04:55:00 | AAPL | Stock | 79.2475 | 79.25 | 79.2475 | 79.2475 | 11900.0 |
| 2020-01-17 04:57:00 | AAPL | Stock | 79.2825 | 79.2825 | 79.2475 | 79.2475 | 1600.0 |
| 2020-01-17 05:04:00 | AAPL | Stock | 79.2825 | 79.3 | 79.265 | 79.265 | 6404.0 |
| 2020-01-17 05:05:00 | AAPL | Stock | 79.3 | 79.3 | 79.3 | 79.3 | 1156.0 |
| 2020-01-17 05:07:00 | AAPL | Stock | 79.3 | 79.3 | 79.3 | 79.3 | 6000.0 |
| 2020-01-17 05:12:00 | AAPL | Stock | 79.3125 | 79.3125 | 79.3125 | 79.3125 | 400.0 |
| 2020-01-17 05:14:00 | AAPL | Stock | 79.325 | 79.325 | 79.325 | 79.325 | 1324.0 |
| 2020-01-17 05:16:00 | AAPL | Stock | 79.325 | 79.325 | 79.325 | 79.325 | 5164.0 |
| 2020-01-17 05:20:00 | AAPL | Stock | 79.3375 | 79.3375 | 79.3375 | 79.3375 | 1200.0 |
| 2020-01-17 05:21:00 | AAPL | Stock | 79.3275 | 79.3275 | 79.325 | 79.325 | 2308.0 |
| 2020-01-17 05:22:00 | AAPL | Stock | 79.325 | 79.325 | 79.325 | 79.325 | 400.0 |
| 2020-01-17 05:39:00 | AAPL | Stock | 79.3225 | 79.3225 | 79.3225 | 79.3225 | 800.0 |
| 2020-01-17 05:44:00 | AAPL | Stock | 79.31 | 79.325 | 79.31 | 79.325 | 13292.0 |
| 2020-01-17 05:48:00 | AAPL | Stock | 79.3175 | 79.3175 | 79.3175 | 79.3175 | 448.0 |
| 2020-01-17 05:52:00 | AAPL | Stock | 79.2925 | 79.2925 | 79.255 | 79.255 | 5208.0 |
| 2020-01-17 05:58:00 | AAPL | Stock | 79.255 | 79.255 | 79.255 | 79.255 | 716.0 |
| 2020-01-17 06:14:00 | AAPL | Stock | 79.2525 | 79.2525 | 79.2525 | 79.2525 | 1312.0 |
| 2020-01-17 06:15:00 | AAPL | Stock | 79.25 | 79.25 | 79.25 | 79.25 | 912.0 |
| 2020-01-17 06:17:00 | AAPL | Stock | 79.27 | 79.27 | 79.27 | 79.27 | 3600.0 |
| 2020-01-17 06:19:00 | AAPL | Stock | 79.25 | 79.25 | 79.25 | 79.25 | 400.0 |
| 2020-01-17 06:21:00 | AAPL | Stock | 79.25 | 79.25 | 79.25 | 79.25 | 1200.0 |
| 2020-01-17 06:34:00 | AAPL | Stock | 79.2525 | 79.2525 | 79.2525 | 79.2525 | 2000.0 |
| 2020-01-17 06:42:00 | AAPL | Stock | 79.255 | 79.255 | 79.25 | 79.25 | 10256.0 |
| 2020-01-17 06:55:00 | AAPL | Stock | 79.2425 | 79.2425 | 79.2425 | 79.2425 | 2000.0 |
| 2020-01-17 06:56:00 | AAPL | Stock | 79.2475 | 79.2475 | 79.2475 | 79.2475 | 404.0 |
| 2020-01-17 06:57:00 | AAPL | Stock | 79.2475 | 79.285 | 79.2475 | 79.285 | 12160.0 |
| 2020-01-17 06:58:00 | AAPL | Stock | 79.3 | 79.3 | 79.3 | 79.3 | 2000.0 |
| 2020-01-17 06:59:00 | AAPL | Stock | 79.2875 | 79.2925 | 79.2875 | 79.2875 | 2400.0 |
| 2020-01-17 07:00:00 | AAPL | Stock | 79.255 | 79.31 | 79.23 | 79.2875 | 33192.0 |
| 2020-01-17 07:01:00 | AAPL | Stock | 79.265 | 79.2825 | 79.265 | 79.2825 | 4400.0 |
| 2020-01-17 07:02:00 | AAPL | Stock | 79.295 | 79.295 | 79.2625 | 79.2625 | 6400.0 |
| 2020-01-17 07:04:00 | AAPL | Stock | 79.2825 | 79.2825 | 79.265 | 79.265 | 21124.0 |
| 2020-01-17 07:05:00 | AAPL | Stock | 79.2625 | 79.2625 | 79.25 | 79.25 | 13040.0 |
| 2020-01-17 07:06:00 | AAPL | Stock | 79.255 | 79.27 | 79.2525 | 79.2575 | 2800.0 |
| 2020-01-17 07:07:00 | AAPL | Stock | 79.255 | 79.255 | 79.25 | 79.25 | 13936.0 |
| 2020-01-17 07:08:00 | AAPL | Stock | 79.25 | 79.25 | 79.2375 | 79.25 | 13044.0 |
| 2020-01-17 07:09:00 | AAPL | Stock | 79.25 | 79.255 | 79.25 | 79.255 | 10400.0 |
> showing 50 of 1,125,175 rows — these rows as CSV