PREVIEW / stock_1min / 2021-09-07
file: by_date/stock_1min/2021/2021-09-07.parquet size: 24.3 MB rows: 1,400,388 symbols: 2,324
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-07 04:00:00 | AAPL | Stock | 154.6 | 154.66 | 154.27 | 154.62 | 1854.0 |
| 2021-09-07 04:02:00 | AAPL | Stock | 154.65 | 154.71 | 154.65 | 154.7 | 976.0 |
| 2021-09-07 04:03:00 | AAPL | Stock | 154.7 | 154.7 | 154.7 | 154.7 | 739.0 |
| 2021-09-07 04:04:00 | AAPL | Stock | 154.58 | 154.62 | 154.55 | 154.55 | 4125.0 |
| 2021-09-07 04:06:00 | AAPL | Stock | 154.54 | 154.54 | 154.54 | 154.54 | 400.0 |
| 2021-09-07 04:07:00 | AAPL | Stock | 154.55 | 154.55 | 154.47 | 154.47 | 1821.0 |
| 2021-09-07 04:08:00 | AAPL | Stock | 154.4 | 154.4 | 154.4 | 154.4 | 472.0 |
| 2021-09-07 04:10:00 | AAPL | Stock | 154.37 | 154.39 | 154.35 | 154.35 | 1487.0 |
| 2021-09-07 04:11:00 | AAPL | Stock | 154.37 | 154.37 | 154.35 | 154.35 | 228.0 |
| 2021-09-07 04:13:00 | AAPL | Stock | 154.35 | 154.35 | 154.35 | 154.35 | 250.0 |
| 2021-09-07 04:16:00 | AAPL | Stock | 154.48 | 154.49 | 154.48 | 154.49 | 1136.0 |
| 2021-09-07 04:18:00 | AAPL | Stock | 154.55 | 154.55 | 154.55 | 154.55 | 677.0 |
| 2021-09-07 04:19:00 | AAPL | Stock | 154.6 | 154.61 | 154.6 | 154.61 | 300.0 |
| 2021-09-07 04:20:00 | AAPL | Stock | 154.61 | 154.61 | 154.6 | 154.6 | 300.0 |
| 2021-09-07 04:21:00 | AAPL | Stock | 154.59 | 154.59 | 154.59 | 154.59 | 200.0 |
| 2021-09-07 04:22:00 | AAPL | Stock | 154.59 | 154.6 | 154.59 | 154.6 | 2693.0 |
| 2021-09-07 04:24:00 | AAPL | Stock | 154.6 | 154.63 | 154.6 | 154.6 | 2134.0 |
| 2021-09-07 04:25:00 | AAPL | Stock | 154.61 | 154.61 | 154.61 | 154.61 | 436.0 |
| 2021-09-07 04:26:00 | AAPL | Stock | 154.61 | 154.61 | 154.61 | 154.61 | 200.0 |
| 2021-09-07 04:27:00 | AAPL | Stock | 154.6 | 154.61 | 154.6 | 154.61 | 3134.0 |
| 2021-09-07 04:28:00 | AAPL | Stock | 154.68 | 154.72 | 154.68 | 154.72 | 1422.0 |
| 2021-09-07 04:29:00 | AAPL | Stock | 154.71 | 154.71 | 154.71 | 154.71 | 299.0 |
| 2021-09-07 04:30:00 | AAPL | Stock | 154.7 | 154.7 | 154.7 | 154.7 | 1240.0 |
| 2021-09-07 04:31:00 | AAPL | Stock | 154.7 | 154.7 | 154.7 | 154.7 | 100.0 |
| 2021-09-07 04:32:00 | AAPL | Stock | 154.7 | 154.7 | 154.7 | 154.7 | 638.0 |
| 2021-09-07 04:33:00 | AAPL | Stock | 154.7 | 154.7 | 154.7 | 154.7 | 1947.0 |
| 2021-09-07 04:34:00 | AAPL | Stock | 154.7 | 154.72 | 154.69 | 154.72 | 1090.0 |
| 2021-09-07 04:37:00 | AAPL | Stock | 154.7 | 154.75 | 154.7 | 154.75 | 878.0 |
| 2021-09-07 04:40:00 | AAPL | Stock | 154.7 | 154.7 | 154.7 | 154.7 | 300.0 |
| 2021-09-07 04:41:00 | AAPL | Stock | 154.73 | 154.73 | 154.7 | 154.7 | 590.0 |
| 2021-09-07 04:43:00 | AAPL | Stock | 154.7 | 154.74 | 154.7 | 154.74 | 600.0 |
| 2021-09-07 04:51:00 | AAPL | Stock | 154.73 | 154.77 | 154.73 | 154.77 | 800.0 |
| 2021-09-07 04:52:00 | AAPL | Stock | 154.77 | 154.77 | 154.75 | 154.75 | 7198.0 |
| 2021-09-07 04:56:00 | AAPL | Stock | 154.73 | 154.73 | 154.72 | 154.72 | 200.0 |
| 2021-09-07 04:59:00 | AAPL | Stock | 154.69 | 154.69 | 154.69 | 154.69 | 191.0 |
| 2021-09-07 05:00:00 | AAPL | Stock | 154.66 | 154.71 | 154.56 | 154.71 | 1772.0 |
| 2021-09-07 05:02:00 | AAPL | Stock | 154.6 | 154.6 | 154.6 | 154.6 | 142.0 |
| 2021-09-07 05:08:00 | AAPL | Stock | 154.62 | 154.62 | 154.6 | 154.6 | 1083.0 |
| 2021-09-07 05:10:00 | AAPL | Stock | 154.59 | 154.6 | 154.43 | 154.49 | 1416.0 |
| 2021-09-07 05:11:00 | AAPL | Stock | 154.59 | 154.59 | 154.59 | 154.59 | 102.0 |
| 2021-09-07 05:13:00 | AAPL | Stock | 154.6 | 154.6 | 154.6 | 154.6 | 445.0 |
| 2021-09-07 05:14:00 | AAPL | Stock | 154.55 | 154.55 | 154.53 | 154.53 | 629.0 |
| 2021-09-07 05:23:00 | AAPL | Stock | 154.53 | 154.55 | 154.4 | 154.4 | 1413.0 |
| 2021-09-07 05:24:00 | AAPL | Stock | 154.4 | 154.45 | 154.4 | 154.45 | 741.0 |
| 2021-09-07 05:25:00 | AAPL | Stock | 154.42 | 154.7 | 154.42 | 154.56 | 4372.0 |
| 2021-09-07 05:26:00 | AAPL | Stock | 154.54 | 154.54 | 154.54 | 154.54 | 200.0 |
| 2021-09-07 05:27:00 | AAPL | Stock | 154.56 | 154.56 | 154.56 | 154.56 | 146.0 |
| 2021-09-07 05:30:00 | AAPL | Stock | 154.57 | 154.57 | 154.57 | 154.57 | 100.0 |
| 2021-09-07 05:31:00 | AAPL | Stock | 154.47 | 154.47 | 154.47 | 154.47 | 456.0 |
| 2021-09-07 05:32:00 | AAPL | Stock | 154.47 | 154.47 | 154.44 | 154.44 | 400.0 |
> showing 50 of 1,400,388 rows — these rows as CSV