PREVIEW / stock_30min / 2022-08-22
file: by_date/stock_30min/2022/2022-08-22.parquet size: 2.1 MB rows: 106,480 symbols: 2,207
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-22 04:00:00 | AAPL | Stock | 170.29 | 170.29 | 169.01 | 169.18 | 68841.0 |
| 2022-08-22 04:30:00 | AAPL | Stock | 169.18 | 169.18 | 168.64 | 168.74 | 48675.0 |
| 2022-08-22 05:00:00 | AAPL | Stock | 168.8 | 168.9 | 168.61 | 168.72 | 13549.0 |
| 2022-08-22 05:30:00 | AAPL | Stock | 168.75 | 168.84 | 168.53 | 168.68 | 29880.0 |
| 2022-08-22 06:00:00 | AAPL | Stock | 168.79 | 169.04 | 168.69 | 168.95 | 33789.0 |
| 2022-08-22 06:30:00 | AAPL | Stock | 168.89 | 168.94 | 168.66 | 168.88 | 10251.0 |
| 2022-08-22 07:00:00 | AAPL | Stock | 168.9 | 169.3 | 168.86 | 169.16 | 96919.0 |
| 2022-08-22 07:30:00 | AAPL | Stock | 169.16 | 169.27 | 169.08 | 169.15 | 104607.0 |
| 2022-08-22 08:00:00 | AAPL | Stock | 168.9499 | 171.092 | 168.5312 | 168.6012 | 289401.0 |
| 2022-08-22 08:30:00 | AAPL | Stock | 168.6112 | 168.9 | 168.61 | 168.72 | 82874.0 |
| 2022-08-22 09:00:00 | AAPL | Stock | 168.74 | 169.75 | 168.7 | 169.67 | 331320.0 |
| 2022-08-22 09:30:00 | AAPL | Stock | 169.67 | 169.86 | 168.4826 | 168.95 | 8775320.0 |
| 2022-08-22 10:00:00 | AAPL | Stock | 168.96 | 169.31 | 168.5326 | 168.73 | 3809138.0 |
| 2022-08-22 10:30:00 | AAPL | Stock | 168.7284 | 168.88 | 168.06 | 168.075 | 3373792.0 |
| 2022-08-22 11:00:00 | AAPL | Stock | 168.07 | 168.73 | 168.01 | 168.435 | 3006931.0 |
| 2022-08-22 11:30:00 | AAPL | Stock | 168.44 | 168.9 | 168.33 | 168.77 | 2657500.0 |
| 2022-08-22 12:00:00 | AAPL | Stock | 168.765 | 169.05 | 168.58 | 168.8399 | 2239372.0 |
| 2022-08-22 12:30:00 | AAPL | Stock | 168.83 | 169.05 | 168.69 | 168.93 | 1918168.0 |
| 2022-08-22 13:00:00 | AAPL | Stock | 168.925 | 168.98 | 168.61 | 168.66 | 1956556.0 |
| 2022-08-22 13:30:00 | AAPL | Stock | 168.65 | 168.66 | 168.15 | 168.2 | 2333075.0 |
| 2022-08-22 14:00:00 | AAPL | Stock | 168.2 | 168.35 | 167.85 | 167.8701 | 2694080.0 |
| 2022-08-22 14:30:00 | AAPL | Stock | 167.87 | 167.95 | 167.4 | 167.615 | 3328387.0 |
| 2022-08-22 15:00:00 | AAPL | Stock | 167.61 | 167.93 | 167.6 | 167.74 | 3433127.0 |
| 2022-08-22 15:30:00 | AAPL | Stock | 167.735 | 167.78 | 167.135 | 167.59 | 7961868.0 |
| 2022-08-22 16:00:00 | AAPL | Stock | 167.59 | 167.73 | 167.51 | 167.69 | 8062343.0 |
| 2022-08-22 16:30:00 | AAPL | Stock | 167.69 | 167.85 | 167.57 | 167.69 | 38431.0 |
| 2022-08-22 17:00:00 | AAPL | Stock | 167.68 | 167.78 | 167.68 | 167.74 | 31211.0 |
| 2022-08-22 17:30:00 | AAPL | Stock | 167.75 | 167.7692 | 167.73 | 167.7692 | 6958.0 |
| 2022-08-22 18:00:00 | AAPL | Stock | 167.77 | 167.78 | 167.6 | 167.67 | 16778.0 |
| 2022-08-22 18:30:00 | AAPL | Stock | 167.67 | 167.81 | 167.65 | 167.81 | 14832.0 |
| 2022-08-22 19:00:00 | AAPL | Stock | 167.75 | 167.88 | 167.75 | 167.86 | 9082.0 |
| 2022-08-22 19:30:00 | AAPL | Stock | 167.89 | 167.99 | 167.85 | 167.98 | 21963.0 |
| 2022-08-22 04:00:00 | MSFT | Stock | 283.49 | 283.49 | 281.01 | 282.06 | 13001.0 |
| 2022-08-22 04:30:00 | MSFT | Stock | 282.0 | 282.0 | 281.7 | 282.0 | 5070.0 |
| 2022-08-22 05:00:00 | MSFT | Stock | 281.77 | 282.0 | 281.77 | 282.0 | 719.0 |
| 2022-08-22 05:30:00 | MSFT | Stock | 281.7 | 281.74 | 281.36 | 281.74 | 1727.0 |
| 2022-08-22 06:00:00 | MSFT | Stock | 281.78 | 282.39 | 281.74 | 282.39 | 3345.0 |
| 2022-08-22 06:30:00 | MSFT | Stock | 281.88 | 281.88 | 281.88 | 281.88 | 110.0 |
| 2022-08-22 07:00:00 | MSFT | Stock | 282.0 | 282.19 | 281.7 | 281.71 | 4942.0 |
| 2022-08-22 07:30:00 | MSFT | Stock | 281.67 | 281.93 | 281.5 | 281.7 | 7810.0 |
| 2022-08-22 08:00:00 | MSFT | Stock | 281.9822 | 285.435 | 280.729 | 281.19 | 36618.0 |
| 2022-08-22 08:30:00 | MSFT | Stock | 281.06 | 281.6837 | 280.9333 | 281.22 | 16359.0 |
| 2022-08-22 09:00:00 | MSFT | Stock | 281.02 | 282.1 | 280.89 | 282.07 | 41099.0 |
| 2022-08-22 09:30:00 | MSFT | Stock | 282.07 | 282.46 | 278.98 | 279.95 | 2173960.0 |
| 2022-08-22 10:00:00 | MSFT | Stock | 279.93 | 280.45 | 278.78 | 278.9353 | 1220569.0 |
| 2022-08-22 10:30:00 | MSFT | Stock | 278.935 | 279.21 | 278.22 | 278.24 | 885505.0 |
| 2022-08-22 11:00:00 | MSFT | Stock | 278.25 | 278.71 | 277.79 | 278.1 | 709816.0 |
| 2022-08-22 11:30:00 | MSFT | Stock | 278.11 | 279.36 | 278.03 | 279.18 | 730936.0 |
| 2022-08-22 12:00:00 | MSFT | Stock | 279.145 | 279.35 | 278.8 | 278.84 | 494084.0 |
| 2022-08-22 12:30:00 | MSFT | Stock | 278.86 | 279.29 | 278.6034 | 278.9981 | 346967.0 |
> showing 50 of 106,480 rows — these rows as CSV