PREVIEW / stock_1min / 2021-09-09
file: by_date/stock_1min/2021/2021-09-09.parquet size: 23.6 MB rows: 1,357,418 symbols: 2,328
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 |
|---|---|---|---|---|---|---|---|
| 2021-09-09 04:00:00 | AAPL | Stock | 154.98 | 155.0 | 154.98 | 155.0 | 301.0 |
| 2021-09-09 04:01:00 | AAPL | Stock | 154.81 | 154.81 | 154.72 | 154.72 | 880.0 |
| 2021-09-09 04:02:00 | AAPL | Stock | 154.93 | 154.95 | 154.93 | 154.94 | 600.0 |
| 2021-09-09 04:03:00 | AAPL | Stock | 154.98 | 154.98 | 154.91 | 154.91 | 610.0 |
| 2021-09-09 04:04:00 | AAPL | Stock | 154.89 | 154.89 | 154.86 | 154.86 | 254.0 |
| 2021-09-09 04:06:00 | AAPL | Stock | 154.87 | 154.87 | 154.87 | 154.87 | 185.0 |
| 2021-09-09 04:07:00 | AAPL | Stock | 154.85 | 154.85 | 154.85 | 154.85 | 118.0 |
| 2021-09-09 04:08:00 | AAPL | Stock | 154.83 | 154.83 | 154.7 | 154.8 | 1637.0 |
| 2021-09-09 04:09:00 | AAPL | Stock | 154.75 | 154.75 | 154.74 | 154.74 | 300.0 |
| 2021-09-09 04:11:00 | AAPL | Stock | 154.73 | 154.73 | 154.73 | 154.73 | 127.0 |
| 2021-09-09 04:12:00 | AAPL | Stock | 154.73 | 154.73 | 154.73 | 154.73 | 100.0 |
| 2021-09-09 04:14:00 | AAPL | Stock | 154.73 | 154.73 | 154.73 | 154.73 | 375.0 |
| 2021-09-09 04:16:00 | AAPL | Stock | 154.73 | 154.73 | 154.73 | 154.73 | 200.0 |
| 2021-09-09 04:17:00 | AAPL | Stock | 154.72 | 154.72 | 154.72 | 154.72 | 946.0 |
| 2021-09-09 04:18:00 | AAPL | Stock | 154.72 | 154.78 | 154.72 | 154.74 | 2408.0 |
| 2021-09-09 04:21:00 | AAPL | Stock | 154.75 | 154.75 | 154.75 | 154.75 | 400.0 |
| 2021-09-09 04:24:00 | AAPL | Stock | 154.72 | 154.72 | 154.72 | 154.72 | 500.0 |
| 2021-09-09 04:25:00 | AAPL | Stock | 154.7 | 154.7 | 154.7 | 154.7 | 150.0 |
| 2021-09-09 04:27:00 | AAPL | Stock | 154.62 | 154.66 | 154.62 | 154.62 | 959.0 |
| 2021-09-09 04:34:00 | AAPL | Stock | 154.66 | 154.66 | 154.66 | 154.66 | 329.0 |
| 2021-09-09 04:42:00 | AAPL | Stock | 154.56 | 154.56 | 154.56 | 154.56 | 226.0 |
| 2021-09-09 04:44:00 | AAPL | Stock | 154.48 | 154.48 | 154.48 | 154.48 | 293.0 |
| 2021-09-09 04:45:00 | AAPL | Stock | 154.41 | 154.41 | 154.41 | 154.41 | 221.0 |
| 2021-09-09 04:49:00 | AAPL | Stock | 154.5 | 154.5 | 154.5 | 154.5 | 400.0 |
| 2021-09-09 04:56:00 | AAPL | Stock | 154.45 | 154.45 | 154.45 | 154.45 | 100.0 |
| 2021-09-09 04:59:00 | AAPL | Stock | 154.45 | 154.45 | 154.45 | 154.45 | 130.0 |
| 2021-09-09 05:00:00 | AAPL | Stock | 154.43 | 154.45 | 154.4 | 154.45 | 522.0 |
| 2021-09-09 05:05:00 | AAPL | Stock | 154.45 | 154.53 | 154.45 | 154.53 | 377.0 |
| 2021-09-09 05:10:00 | AAPL | Stock | 154.48 | 154.5 | 154.48 | 154.5 | 260.0 |
| 2021-09-09 05:11:00 | AAPL | Stock | 154.44 | 154.44 | 154.44 | 154.44 | 100.0 |
| 2021-09-09 05:13:00 | AAPL | Stock | 154.43 | 154.43 | 154.39 | 154.39 | 1190.0 |
| 2021-09-09 05:14:00 | AAPL | Stock | 154.5 | 154.6 | 154.5 | 154.55 | 400.0 |
| 2021-09-09 05:17:00 | AAPL | Stock | 154.53 | 154.53 | 154.53 | 154.53 | 200.0 |
| 2021-09-09 05:23:00 | AAPL | Stock | 154.68 | 154.68 | 154.68 | 154.68 | 300.0 |
| 2021-09-09 05:24:00 | AAPL | Stock | 154.6 | 154.6 | 154.6 | 154.6 | 1327.0 |
| 2021-09-09 05:29:00 | AAPL | Stock | 154.66 | 154.66 | 154.66 | 154.66 | 500.0 |
| 2021-09-09 05:30:00 | AAPL | Stock | 154.69 | 154.77 | 154.69 | 154.77 | 1459.0 |
| 2021-09-09 05:31:00 | AAPL | Stock | 154.8 | 154.8 | 154.8 | 154.8 | 238.0 |
| 2021-09-09 05:32:00 | AAPL | Stock | 154.8 | 154.8 | 154.8 | 154.8 | 147.0 |
| 2021-09-09 05:33:00 | AAPL | Stock | 154.8 | 154.8 | 154.8 | 154.8 | 2346.0 |
| 2021-09-09 05:34:00 | AAPL | Stock | 154.8 | 154.8 | 154.8 | 154.8 | 200.0 |
| 2021-09-09 05:35:00 | AAPL | Stock | 154.8 | 154.8 | 154.8 | 154.8 | 723.0 |
| 2021-09-09 05:37:00 | AAPL | Stock | 154.8 | 154.8 | 154.8 | 154.8 | 958.0 |
| 2021-09-09 05:38:00 | AAPL | Stock | 154.8 | 154.8 | 154.8 | 154.8 | 156.0 |
| 2021-09-09 05:41:00 | AAPL | Stock | 154.8 | 154.8 | 154.8 | 154.8 | 418.0 |
| 2021-09-09 05:43:00 | AAPL | Stock | 154.8 | 154.8 | 154.8 | 154.8 | 1002.0 |
| 2021-09-09 05:46:00 | AAPL | Stock | 154.75 | 154.75 | 154.75 | 154.75 | 382.0 |
| 2021-09-09 05:52:00 | AAPL | Stock | 154.77 | 154.77 | 154.77 | 154.77 | 142.0 |
| 2021-09-09 05:53:00 | AAPL | Stock | 154.8 | 154.84 | 154.8 | 154.84 | 855.0 |
| 2021-09-09 05:59:00 | AAPL | Stock | 154.79 | 154.79 | 154.79 | 154.79 | 241.0 |
> showing 50 of 1,357,418 rows — these rows as CSV