PREVIEW / stock_1min / 2022-04-20
file: by_date/stock_1min/2022/2022-04-20.parquet size: 22.4 MB rows: 1,346,809 symbols: 2,187
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-04-20 04:00:00 | AAPL | Stock | 166.8 | 166.8 | 166.31 | 166.35 | 1229.0 |
| 2022-04-20 04:03:00 | AAPL | Stock | 166.59 | 166.6 | 166.59 | 166.6 | 536.0 |
| 2022-04-20 04:04:00 | AAPL | Stock | 166.52 | 166.66 | 166.52 | 166.66 | 908.0 |
| 2022-04-20 04:07:00 | AAPL | Stock | 166.62 | 166.62 | 166.62 | 166.62 | 331.0 |
| 2022-04-20 04:08:00 | AAPL | Stock | 166.64 | 166.72 | 166.64 | 166.72 | 644.0 |
| 2022-04-20 04:09:00 | AAPL | Stock | 166.64 | 166.64 | 166.63 | 166.63 | 440.0 |
| 2022-04-20 04:10:00 | AAPL | Stock | 166.63 | 166.63 | 166.63 | 166.63 | 445.0 |
| 2022-04-20 04:11:00 | AAPL | Stock | 166.63 | 166.63 | 166.63 | 166.63 | 400.0 |
| 2022-04-20 04:15:00 | AAPL | Stock | 166.67 | 166.67 | 166.67 | 166.67 | 1055.0 |
| 2022-04-20 04:17:00 | AAPL | Stock | 166.7 | 166.77 | 166.7 | 166.7 | 605.0 |
| 2022-04-20 04:19:00 | AAPL | Stock | 166.65 | 166.65 | 166.65 | 166.65 | 100.0 |
| 2022-04-20 04:20:00 | AAPL | Stock | 166.63 | 166.63 | 166.63 | 166.63 | 649.0 |
| 2022-04-20 04:22:00 | AAPL | Stock | 166.65 | 166.7 | 166.65 | 166.7 | 1481.0 |
| 2022-04-20 04:27:00 | AAPL | Stock | 166.69 | 166.69 | 166.69 | 166.69 | 100.0 |
| 2022-04-20 04:30:00 | AAPL | Stock | 166.69 | 166.73 | 166.69 | 166.69 | 916.0 |
| 2022-04-20 04:34:00 | AAPL | Stock | 166.78 | 166.78 | 166.71 | 166.71 | 1068.0 |
| 2022-04-20 04:35:00 | AAPL | Stock | 166.78 | 166.78 | 166.78 | 166.78 | 151.0 |
| 2022-04-20 04:36:00 | AAPL | Stock | 166.86 | 166.86 | 166.86 | 166.86 | 100.0 |
| 2022-04-20 04:38:00 | AAPL | Stock | 166.96 | 166.96 | 166.94 | 166.94 | 792.0 |
| 2022-04-20 04:39:00 | AAPL | Stock | 166.85 | 166.85 | 166.85 | 166.85 | 100.0 |
| 2022-04-20 04:41:00 | AAPL | Stock | 166.86 | 166.86 | 166.86 | 166.86 | 129.0 |
| 2022-04-20 04:42:00 | AAPL | Stock | 166.87 | 166.93 | 166.85 | 166.85 | 2334.0 |
| 2022-04-20 04:43:00 | AAPL | Stock | 166.81 | 166.81 | 166.8 | 166.8 | 1100.0 |
| 2022-04-20 04:49:00 | AAPL | Stock | 166.78 | 166.78 | 166.78 | 166.78 | 129.0 |
| 2022-04-20 04:56:00 | AAPL | Stock | 166.9 | 166.93 | 166.9 | 166.93 | 222.0 |
| 2022-04-20 04:58:00 | AAPL | Stock | 166.93 | 167.0 | 166.93 | 166.99 | 1953.0 |
| 2022-04-20 05:00:00 | AAPL | Stock | 167.02 | 167.02 | 167.0 | 167.0 | 702.0 |
| 2022-04-20 05:01:00 | AAPL | Stock | 167.06 | 167.06 | 167.06 | 167.06 | 2438.0 |
| 2022-04-20 05:02:00 | AAPL | Stock | 167.06 | 167.1 | 167.06 | 167.1 | 327.0 |
| 2022-04-20 05:03:00 | AAPL | Stock | 167.1 | 167.1 | 167.1 | 167.1 | 114.0 |
| 2022-04-20 05:06:00 | AAPL | Stock | 167.06 | 167.06 | 167.06 | 167.06 | 488.0 |
| 2022-04-20 05:09:00 | AAPL | Stock | 167.19 | 167.19 | 167.16 | 167.16 | 1115.0 |
| 2022-04-20 05:11:00 | AAPL | Stock | 167.17 | 167.17 | 167.17 | 167.17 | 100.0 |
| 2022-04-20 05:12:00 | AAPL | Stock | 167.21 | 167.21 | 167.21 | 167.21 | 150.0 |
| 2022-04-20 05:18:00 | AAPL | Stock | 167.13 | 167.13 | 167.13 | 167.13 | 383.0 |
| 2022-04-20 05:19:00 | AAPL | Stock | 167.27 | 167.38 | 167.27 | 167.38 | 538.0 |
| 2022-04-20 05:20:00 | AAPL | Stock | 167.31 | 167.34 | 167.31 | 167.34 | 527.0 |
| 2022-04-20 05:21:00 | AAPL | Stock | 167.42 | 167.59 | 167.42 | 167.59 | 896.0 |
| 2022-04-20 05:22:00 | AAPL | Stock | 167.43 | 167.43 | 167.43 | 167.43 | 179.0 |
| 2022-04-20 05:23:00 | AAPL | Stock | 167.47 | 167.47 | 167.47 | 167.47 | 124.0 |
| 2022-04-20 05:25:00 | AAPL | Stock | 167.47 | 167.47 | 167.47 | 167.47 | 168.0 |
| 2022-04-20 05:26:00 | AAPL | Stock | 167.48 | 167.5 | 167.48 | 167.5 | 479.0 |
| 2022-04-20 05:27:00 | AAPL | Stock | 167.6 | 167.62 | 167.53 | 167.53 | 920.0 |
| 2022-04-20 05:30:00 | AAPL | Stock | 167.49 | 167.49 | 167.47 | 167.47 | 800.0 |
| 2022-04-20 05:31:00 | AAPL | Stock | 167.42 | 167.42 | 167.41 | 167.41 | 538.0 |
| 2022-04-20 05:33:00 | AAPL | Stock | 167.54 | 167.55 | 167.44 | 167.44 | 3280.0 |
| 2022-04-20 05:34:00 | AAPL | Stock | 167.44 | 167.44 | 167.44 | 167.44 | 179.0 |
| 2022-04-20 05:35:00 | AAPL | Stock | 167.69 | 167.69 | 167.68 | 167.69 | 440.0 |
| 2022-04-20 05:36:00 | AAPL | Stock | 167.77 | 167.78 | 167.77 | 167.78 | 660.0 |
| 2022-04-20 05:38:00 | AAPL | Stock | 167.76 | 167.76 | 167.76 | 167.76 | 750.0 |
> showing 50 of 1,346,809 rows — these rows as CSV