PREVIEW / stock_1min / 2022-08-18
file: by_date/stock_1min/2022/2022-08-18.parquet size: 21.7 MB rows: 1,291,424 symbols: 1,992
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 |
|---|---|---|---|---|---|---|---|
| 2022-08-18 04:00:00 | AAPL | Stock | 173.81 | 173.81 | 173.3 | 173.75 | 2819.0 |
| 2022-08-18 04:01:00 | AAPL | Stock | 173.58 | 173.62 | 173.58 | 173.62 | 478.0 |
| 2022-08-18 04:02:00 | AAPL | Stock | 173.66 | 173.72 | 173.64 | 173.66 | 2015.0 |
| 2022-08-18 04:03:00 | AAPL | Stock | 173.65 | 173.74 | 173.63 | 173.63 | 2163.0 |
| 2022-08-18 04:04:00 | AAPL | Stock | 173.63 | 173.75 | 173.56 | 173.59 | 6440.0 |
| 2022-08-18 04:05:00 | AAPL | Stock | 173.57 | 173.59 | 173.5 | 173.5 | 1760.0 |
| 2022-08-18 04:06:00 | AAPL | Stock | 173.55 | 173.57 | 173.47 | 173.47 | 2124.0 |
| 2022-08-18 04:07:00 | AAPL | Stock | 173.47 | 173.55 | 173.44 | 173.55 | 1340.0 |
| 2022-08-18 04:08:00 | AAPL | Stock | 173.55 | 173.57 | 173.49 | 173.53 | 8275.0 |
| 2022-08-18 04:09:00 | AAPL | Stock | 173.51 | 173.55 | 173.5 | 173.5 | 1735.0 |
| 2022-08-18 04:11:00 | AAPL | Stock | 173.47 | 173.47 | 173.42 | 173.42 | 300.0 |
| 2022-08-18 04:12:00 | AAPL | Stock | 173.48 | 173.48 | 173.48 | 173.48 | 3945.0 |
| 2022-08-18 04:14:00 | AAPL | Stock | 173.48 | 173.48 | 173.48 | 173.48 | 752.0 |
| 2022-08-18 04:16:00 | AAPL | Stock | 173.48 | 173.48 | 173.45 | 173.45 | 1430.0 |
| 2022-08-18 04:17:00 | AAPL | Stock | 173.44 | 173.44 | 173.39 | 173.39 | 824.0 |
| 2022-08-18 04:20:00 | AAPL | Stock | 173.3 | 173.3 | 173.25 | 173.25 | 805.0 |
| 2022-08-18 04:21:00 | AAPL | Stock | 173.27 | 173.27 | 173.25 | 173.25 | 200.0 |
| 2022-08-18 04:23:00 | AAPL | Stock | 173.3 | 173.3 | 173.3 | 173.3 | 100.0 |
| 2022-08-18 04:26:00 | AAPL | Stock | 173.33 | 173.34 | 173.3 | 173.3 | 500.0 |
| 2022-08-18 04:28:00 | AAPL | Stock | 173.3 | 173.3 | 173.3 | 173.3 | 1931.0 |
| 2022-08-18 04:29:00 | AAPL | Stock | 173.32 | 173.34 | 173.3 | 173.34 | 3473.0 |
| 2022-08-18 04:30:00 | AAPL | Stock | 173.34 | 173.34 | 173.34 | 173.34 | 924.0 |
| 2022-08-18 04:31:00 | AAPL | Stock | 173.3 | 173.3 | 173.3 | 173.3 | 1404.0 |
| 2022-08-18 04:33:00 | AAPL | Stock | 173.28 | 173.3 | 173.28 | 173.3 | 1647.0 |
| 2022-08-18 04:34:00 | AAPL | Stock | 173.3 | 173.34 | 173.28 | 173.28 | 4090.0 |
| 2022-08-18 04:40:00 | AAPL | Stock | 173.3 | 173.3 | 173.3 | 173.3 | 188.0 |
| 2022-08-18 04:42:00 | AAPL | Stock | 173.38 | 173.38 | 173.38 | 173.38 | 1995.0 |
| 2022-08-18 04:44:00 | AAPL | Stock | 173.41 | 173.48 | 173.41 | 173.43 | 1202.0 |
| 2022-08-18 04:45:00 | AAPL | Stock | 173.48 | 173.48 | 173.48 | 173.48 | 300.0 |
| 2022-08-18 04:46:00 | AAPL | Stock | 173.48 | 173.53 | 173.48 | 173.53 | 1351.0 |
| 2022-08-18 04:47:00 | AAPL | Stock | 173.53 | 173.55 | 173.53 | 173.55 | 3025.0 |
| 2022-08-18 04:48:00 | AAPL | Stock | 173.53 | 173.53 | 173.53 | 173.53 | 400.0 |
| 2022-08-18 04:49:00 | AAPL | Stock | 173.59 | 173.59 | 173.59 | 173.59 | 804.0 |
| 2022-08-18 04:50:00 | AAPL | Stock | 173.65 | 173.65 | 173.65 | 173.65 | 296.0 |
| 2022-08-18 04:52:00 | AAPL | Stock | 173.63 | 173.63 | 173.55 | 173.55 | 923.0 |
| 2022-08-18 04:53:00 | AAPL | Stock | 173.54 | 173.54 | 173.54 | 173.54 | 200.0 |
| 2022-08-18 04:54:00 | AAPL | Stock | 173.54 | 173.54 | 173.54 | 173.54 | 695.0 |
| 2022-08-18 04:55:00 | AAPL | Stock | 173.49 | 173.49 | 173.48 | 173.48 | 200.0 |
| 2022-08-18 04:56:00 | AAPL | Stock | 173.5 | 173.55 | 173.5 | 173.55 | 488.0 |
| 2022-08-18 04:57:00 | AAPL | Stock | 173.55 | 173.55 | 173.55 | 173.55 | 349.0 |
| 2022-08-18 04:59:00 | AAPL | Stock | 173.64 | 173.69 | 173.63 | 173.63 | 1569.0 |
| 2022-08-18 05:01:00 | AAPL | Stock | 173.54 | 173.54 | 173.54 | 173.54 | 100.0 |
| 2022-08-18 05:02:00 | AAPL | Stock | 173.6 | 173.6 | 173.6 | 173.6 | 100.0 |
| 2022-08-18 05:04:00 | AAPL | Stock | 173.59 | 173.64 | 173.59 | 173.64 | 450.0 |
| 2022-08-18 05:05:00 | AAPL | Stock | 173.57 | 173.57 | 173.57 | 173.57 | 105.0 |
| 2022-08-18 05:06:00 | AAPL | Stock | 173.7 | 173.7 | 173.69 | 173.69 | 306.0 |
| 2022-08-18 05:07:00 | AAPL | Stock | 173.72 | 173.79 | 173.72 | 173.79 | 1007.0 |
| 2022-08-18 05:10:00 | AAPL | Stock | 173.66 | 173.66 | 173.66 | 173.66 | 100.0 |
| 2022-08-18 05:11:00 | AAPL | Stock | 173.66 | 173.66 | 173.66 | 173.66 | 400.0 |
| 2022-08-18 05:13:00 | AAPL | Stock | 173.72 | 173.72 | 173.72 | 173.72 | 100.0 |
> showing 50 of 1,291,424 rows — these rows as CSV