PREVIEW / stock_1min / 2018-10-24
file: by_date/stock_1min/2018/2018-10-24.parquet size: 17.1 MB rows: 1,154,095 symbols: 2,321
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 |
|---|---|---|---|---|---|---|---|
| 2018-10-24 04:00:00 | AAPL | Stock | 55.2575 | 55.49 | 55.13 | 55.25 | 2704.0 |
| 2018-10-24 04:01:00 | AAPL | Stock | 55.25 | 55.25 | 55.17 | 55.17 | 1840.0 |
| 2018-10-24 04:02:00 | AAPL | Stock | 55.18 | 55.18 | 55.18 | 55.18 | 3736.0 |
| 2018-10-24 04:03:00 | AAPL | Stock | 55.25 | 55.25 | 55.25 | 55.25 | 2000.0 |
| 2018-10-24 04:04:00 | AAPL | Stock | 55.25 | 55.25 | 55.25 | 55.25 | 1880.0 |
| 2018-10-24 04:05:00 | AAPL | Stock | 55.25 | 55.25 | 55.25 | 55.25 | 2000.0 |
| 2018-10-24 04:14:00 | AAPL | Stock | 55.25 | 55.25 | 55.225 | 55.225 | 800.0 |
| 2018-10-24 04:19:00 | AAPL | Stock | 55.25 | 55.25 | 55.25 | 55.25 | 1252.0 |
| 2018-10-24 04:21:00 | AAPL | Stock | 55.19 | 55.19 | 55.19 | 55.19 | 400.0 |
| 2018-10-24 04:27:00 | AAPL | Stock | 55.185 | 55.185 | 55.185 | 55.185 | 400.0 |
| 2018-10-24 04:28:00 | AAPL | Stock | 55.19 | 55.19 | 55.19 | 55.19 | 2400.0 |
| 2018-10-24 04:30:00 | AAPL | Stock | 55.19 | 55.19 | 55.19 | 55.19 | 1600.0 |
| 2018-10-24 04:31:00 | AAPL | Stock | 55.19 | 55.19 | 55.19 | 55.19 | 400.0 |
| 2018-10-24 04:32:00 | AAPL | Stock | 55.19 | 55.19 | 55.19 | 55.19 | 800.0 |
| 2018-10-24 04:33:00 | AAPL | Stock | 55.19 | 55.19 | 55.19 | 55.19 | 400.0 |
| 2018-10-24 04:34:00 | AAPL | Stock | 55.19 | 55.19 | 55.19 | 55.19 | 1488.0 |
| 2018-10-24 04:35:00 | AAPL | Stock | 55.19 | 55.19 | 55.19 | 55.19 | 1600.0 |
| 2018-10-24 04:36:00 | AAPL | Stock | 55.19 | 55.19 | 55.19 | 55.19 | 400.0 |
| 2018-10-24 04:52:00 | AAPL | Stock | 55.175 | 55.175 | 55.175 | 55.175 | 800.0 |
| 2018-10-24 04:55:00 | AAPL | Stock | 55.1625 | 55.1625 | 55.1625 | 55.1625 | 800.0 |
| 2018-10-24 05:05:00 | AAPL | Stock | 55.055 | 55.055 | 55.055 | 55.055 | 800.0 |
| 2018-10-24 05:08:00 | AAPL | Stock | 55.055 | 55.055 | 55.055 | 55.055 | 600.0 |
| 2018-10-24 05:11:00 | AAPL | Stock | 55.15 | 55.15 | 55.15 | 55.15 | 400.0 |
| 2018-10-24 05:12:00 | AAPL | Stock | 55.1625 | 55.1625 | 55.1625 | 55.1625 | 1200.0 |
| 2018-10-24 05:16:00 | AAPL | Stock | 55.165 | 55.165 | 55.165 | 55.165 | 600.0 |
| 2018-10-24 05:18:00 | AAPL | Stock | 55.1625 | 55.1625 | 55.1625 | 55.1625 | 800.0 |
| 2018-10-24 05:19:00 | AAPL | Stock | 55.165 | 55.165 | 55.165 | 55.165 | 800.0 |
| 2018-10-24 05:28:00 | AAPL | Stock | 55.175 | 55.175 | 55.175 | 55.175 | 400.0 |
| 2018-10-24 05:29:00 | AAPL | Stock | 55.225 | 55.225 | 55.225 | 55.225 | 1720.0 |
| 2018-10-24 05:44:00 | AAPL | Stock | 55.25 | 55.25 | 55.25 | 55.25 | 3548.0 |
| 2018-10-24 05:53:00 | AAPL | Stock | 55.25 | 55.25 | 55.225 | 55.225 | 1776.0 |
| 2018-10-24 06:10:00 | AAPL | Stock | 55.325 | 55.325 | 55.325 | 55.325 | 1808.0 |
| 2018-10-24 06:11:00 | AAPL | Stock | 55.325 | 55.325 | 55.325 | 55.325 | 1200.0 |
| 2018-10-24 06:12:00 | AAPL | Stock | 55.34 | 55.35 | 55.34 | 55.35 | 6640.0 |
| 2018-10-24 06:19:00 | AAPL | Stock | 55.325 | 55.325 | 55.325 | 55.325 | 2400.0 |
| 2018-10-24 06:22:00 | AAPL | Stock | 55.325 | 55.325 | 55.325 | 55.325 | 2000.0 |
| 2018-10-24 06:30:00 | AAPL | Stock | 55.3625 | 55.3625 | 55.3625 | 55.3625 | 1600.0 |
| 2018-10-24 06:32:00 | AAPL | Stock | 55.3225 | 55.3225 | 55.2875 | 55.2875 | 2000.0 |
| 2018-10-24 06:33:00 | AAPL | Stock | 55.2875 | 55.2875 | 55.2875 | 55.2875 | 3200.0 |
| 2018-10-24 06:34:00 | AAPL | Stock | 55.265 | 55.265 | 55.265 | 55.265 | 800.0 |
| 2018-10-24 06:37:00 | AAPL | Stock | 55.275 | 55.275 | 55.265 | 55.265 | 2332.0 |
| 2018-10-24 06:38:00 | AAPL | Stock | 55.2625 | 55.2625 | 55.2625 | 55.2625 | 860.0 |
| 2018-10-24 06:43:00 | AAPL | Stock | 55.2625 | 55.2625 | 55.2625 | 55.2625 | 400.0 |
| 2018-10-24 06:47:00 | AAPL | Stock | 55.305 | 55.305 | 55.305 | 55.305 | 400.0 |
| 2018-10-24 06:48:00 | AAPL | Stock | 55.305 | 55.305 | 55.305 | 55.305 | 2000.0 |
| 2018-10-24 06:49:00 | AAPL | Stock | 55.305 | 55.3725 | 55.305 | 55.3725 | 14852.0 |
| 2018-10-24 06:54:00 | AAPL | Stock | 55.375 | 55.375 | 55.375 | 55.375 | 800.0 |
| 2018-10-24 06:58:00 | AAPL | Stock | 55.37 | 55.37 | 55.37 | 55.37 | 400.0 |
| 2018-10-24 06:59:00 | AAPL | Stock | 55.3925 | 55.395 | 55.3925 | 55.395 | 3560.0 |
| 2018-10-24 07:00:00 | AAPL | Stock | 55.3975 | 55.4325 | 55.3975 | 55.4 | 24836.0 |
> showing 50 of 1,154,095 rows — these rows as CSV