PREVIEW / stock_1min / 2020-03-31
file: by_date/stock_1min/2020/2020-03-31.parquet size: 19.2 MB rows: 1,320,052 symbols: 2,071
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-03-31 04:00:00 | AAPL | Stock | 64.3275 | 64.3275 | 64.3275 | 64.3275 | 2760.0 |
| 2020-03-31 04:01:00 | AAPL | Stock | 64.18 | 64.18 | 64.18 | 64.18 | 4400.0 |
| 2020-03-31 04:04:00 | AAPL | Stock | 64.2525 | 64.2525 | 64.2525 | 64.2525 | 1932.0 |
| 2020-03-31 04:06:00 | AAPL | Stock | 64.1025 | 64.1025 | 64.1 | 64.1 | 1360.0 |
| 2020-03-31 04:07:00 | AAPL | Stock | 64.1875 | 64.275 | 64.1875 | 64.275 | 4284.0 |
| 2020-03-31 04:10:00 | AAPL | Stock | 64.36 | 64.36 | 64.2675 | 64.2675 | 1600.0 |
| 2020-03-31 04:11:00 | AAPL | Stock | 64.3125 | 64.3125 | 64.3075 | 64.3125 | 4136.0 |
| 2020-03-31 04:12:00 | AAPL | Stock | 64.3575 | 64.36 | 64.3575 | 64.36 | 2564.0 |
| 2020-03-31 04:13:00 | AAPL | Stock | 64.31 | 64.355 | 64.3075 | 64.3075 | 1992.0 |
| 2020-03-31 04:14:00 | AAPL | Stock | 64.275 | 64.275 | 64.275 | 64.275 | 400.0 |
| 2020-03-31 04:15:00 | AAPL | Stock | 64.32 | 64.32 | 64.25 | 64.25 | 2840.0 |
| 2020-03-31 04:18:00 | AAPL | Stock | 64.3125 | 64.3125 | 64.3125 | 64.3125 | 2000.0 |
| 2020-03-31 04:19:00 | AAPL | Stock | 64.26 | 64.26 | 64.25 | 64.2575 | 1644.0 |
| 2020-03-31 04:20:00 | AAPL | Stock | 64.3125 | 64.3125 | 64.3125 | 64.3125 | 400.0 |
| 2020-03-31 04:21:00 | AAPL | Stock | 64.3125 | 64.3125 | 64.2525 | 64.2525 | 1568.0 |
| 2020-03-31 04:24:00 | AAPL | Stock | 64.3375 | 64.3375 | 64.3375 | 64.3375 | 1164.0 |
| 2020-03-31 04:27:00 | AAPL | Stock | 64.475 | 64.475 | 64.475 | 64.475 | 728.0 |
| 2020-03-31 04:28:00 | AAPL | Stock | 64.475 | 64.475 | 64.475 | 64.475 | 1680.0 |
| 2020-03-31 04:32:00 | AAPL | Stock | 64.475 | 64.5 | 64.475 | 64.5 | 2480.0 |
| 2020-03-31 04:35:00 | AAPL | Stock | 64.5 | 64.5 | 64.5 | 64.5 | 1996.0 |
| 2020-03-31 04:36:00 | AAPL | Stock | 64.515 | 64.515 | 64.4375 | 64.4375 | 2400.0 |
| 2020-03-31 04:37:00 | AAPL | Stock | 64.425 | 64.425 | 64.425 | 64.425 | 824.0 |
| 2020-03-31 04:42:00 | AAPL | Stock | 64.575 | 64.575 | 64.575 | 64.575 | 2400.0 |
| 2020-03-31 04:44:00 | AAPL | Stock | 64.575 | 64.575 | 64.575 | 64.575 | 800.0 |
| 2020-03-31 04:45:00 | AAPL | Stock | 64.5075 | 64.5075 | 64.39 | 64.39 | 2464.0 |
| 2020-03-31 04:46:00 | AAPL | Stock | 64.4675 | 64.4675 | 64.4675 | 64.4675 | 400.0 |
| 2020-03-31 04:47:00 | AAPL | Stock | 64.31 | 64.3875 | 64.31 | 64.3875 | 844.0 |
| 2020-03-31 04:51:00 | AAPL | Stock | 64.4975 | 64.4975 | 64.4725 | 64.4725 | 988.0 |
| 2020-03-31 04:54:00 | AAPL | Stock | 64.4875 | 64.4875 | 64.4875 | 64.4875 | 1600.0 |
| 2020-03-31 04:55:00 | AAPL | Stock | 64.675 | 64.675 | 64.675 | 64.675 | 556.0 |
| 2020-03-31 04:58:00 | AAPL | Stock | 64.575 | 64.575 | 64.48 | 64.48 | 4472.0 |
| 2020-03-31 04:59:00 | AAPL | Stock | 64.625 | 64.625 | 64.625 | 64.625 | 800.0 |
| 2020-03-31 05:00:00 | AAPL | Stock | 64.53 | 64.53 | 64.53 | 64.53 | 2804.0 |
| 2020-03-31 05:01:00 | AAPL | Stock | 64.5075 | 64.5075 | 64.5075 | 64.5075 | 1196.0 |
| 2020-03-31 05:03:00 | AAPL | Stock | 64.5625 | 64.5625 | 64.5625 | 64.5625 | 2000.0 |
| 2020-03-31 05:10:00 | AAPL | Stock | 64.5275 | 64.5275 | 64.5275 | 64.5275 | 440.0 |
| 2020-03-31 05:15:00 | AAPL | Stock | 64.595 | 64.595 | 64.595 | 64.595 | 800.0 |
| 2020-03-31 05:18:00 | AAPL | Stock | 64.575 | 64.575 | 64.575 | 64.575 | 1768.0 |
| 2020-03-31 05:21:00 | AAPL | Stock | 64.575 | 64.575 | 64.575 | 64.575 | 1600.0 |
| 2020-03-31 05:22:00 | AAPL | Stock | 64.625 | 64.625 | 64.625 | 64.625 | 656.0 |
| 2020-03-31 05:24:00 | AAPL | Stock | 64.6175 | 64.625 | 64.6175 | 64.625 | 3900.0 |
| 2020-03-31 05:26:00 | AAPL | Stock | 64.6125 | 64.6125 | 64.5925 | 64.5925 | 1676.0 |
| 2020-03-31 05:31:00 | AAPL | Stock | 64.5875 | 64.6025 | 64.5875 | 64.5875 | 5560.0 |
| 2020-03-31 05:34:00 | AAPL | Stock | 64.5875 | 64.5875 | 64.5875 | 64.5875 | 1040.0 |
| 2020-03-31 05:38:00 | AAPL | Stock | 64.5375 | 64.625 | 64.5375 | 64.55 | 1524.0 |
| 2020-03-31 05:43:00 | AAPL | Stock | 64.5 | 64.5 | 64.5 | 64.5 | 400.0 |
| 2020-03-31 05:44:00 | AAPL | Stock | 64.5 | 64.5 | 64.5 | 64.5 | 1600.0 |
| 2020-03-31 05:45:00 | AAPL | Stock | 64.5 | 64.5 | 64.48 | 64.48 | 1200.0 |
| 2020-03-31 05:48:00 | AAPL | Stock | 64.435 | 64.435 | 64.435 | 64.435 | 800.0 |
| 2020-03-31 05:50:00 | AAPL | Stock | 64.3775 | 64.3775 | 64.375 | 64.375 | 1800.0 |
> showing 50 of 1,320,052 rows — these rows as CSV