PREVIEW / stock_30min / 2022-08-25
file: by_date/stock_30min/2022/2022-08-25.parquet size: 2.1 MB rows: 103,995 symbols: 2,267
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-25 04:00:00 | AAPL | Stock | 169.02 | 169.8 | 168.61 | 169.24 | 22646.0 |
| 2022-08-25 04:30:00 | AAPL | Stock | 169.2 | 169.4 | 169.2 | 169.32 | 5027.0 |
| 2022-08-25 05:00:00 | AAPL | Stock | 169.3 | 169.38 | 168.7 | 168.7 | 13690.0 |
| 2022-08-25 05:30:00 | AAPL | Stock | 168.86 | 168.9 | 168.62 | 168.8 | 19276.0 |
| 2022-08-25 06:00:00 | AAPL | Stock | 168.8 | 168.8 | 168.63 | 168.78 | 7119.0 |
| 2022-08-25 06:30:00 | AAPL | Stock | 168.78 | 168.87 | 168.72 | 168.86 | 2593.0 |
| 2022-08-25 07:00:00 | AAPL | Stock | 168.75 | 168.94 | 168.55 | 168.91 | 34476.0 |
| 2022-08-25 07:30:00 | AAPL | Stock | 168.82 | 168.88 | 168.66 | 168.73 | 16108.0 |
| 2022-08-25 08:00:00 | AAPL | Stock | 168.71 | 169.99 | 167.112 | 168.6 | 147121.0 |
| 2022-08-25 08:30:00 | AAPL | Stock | 168.6 | 168.88 | 168.29 | 168.69 | 136177.0 |
| 2022-08-25 09:00:00 | AAPL | Stock | 168.71 | 168.84 | 168.5 | 168.83 | 93255.0 |
| 2022-08-25 09:30:00 | AAPL | Stock | 168.78 | 169.76 | 168.68 | 169.58 | 7466520.0 |
| 2022-08-25 10:00:00 | AAPL | Stock | 169.58 | 169.92 | 169.205 | 169.3 | 4361243.0 |
| 2022-08-25 10:30:00 | AAPL | Stock | 169.305 | 169.895 | 169.2191 | 169.27 | 2669712.0 |
| 2022-08-25 11:00:00 | AAPL | Stock | 169.265 | 169.28 | 168.45 | 168.7602 | 2600477.0 |
| 2022-08-25 11:30:00 | AAPL | Stock | 168.77 | 169.1299 | 168.71 | 169.05 | 1876830.0 |
| 2022-08-25 12:00:00 | AAPL | Stock | 169.05 | 169.06 | 168.54 | 168.77 | 1595300.0 |
| 2022-08-25 12:30:00 | AAPL | Stock | 168.7702 | 168.9189 | 168.35 | 168.655 | 1400758.0 |
| 2022-08-25 13:00:00 | AAPL | Stock | 168.65 | 169.01 | 168.54 | 168.9316 | 1874329.0 |
| 2022-08-25 13:30:00 | AAPL | Stock | 168.93 | 169.42 | 168.89 | 169.21 | 2234682.0 |
| 2022-08-25 14:00:00 | AAPL | Stock | 169.21 | 169.36 | 168.91 | 169.32 | 1742040.0 |
| 2022-08-25 14:30:00 | AAPL | Stock | 169.315 | 169.39 | 168.93 | 169.24 | 1571772.0 |
| 2022-08-25 15:00:00 | AAPL | Stock | 169.249 | 169.4199 | 169.0321 | 169.4 | 2251668.0 |
| 2022-08-25 15:30:00 | AAPL | Stock | 169.4 | 170.14 | 169.19 | 170.13 | 6058832.0 |
| 2022-08-25 16:00:00 | AAPL | Stock | 170.07 | 170.1628 | 169.98 | 170.02 | 5317480.0 |
| 2022-08-25 16:30:00 | AAPL | Stock | 170.04 | 170.08 | 170.0 | 170.02 | 46886.0 |
| 2022-08-25 17:00:00 | AAPL | Stock | 170.01 | 170.0488 | 169.98 | 170.01 | 17270.0 |
| 2022-08-25 17:30:00 | AAPL | Stock | 170.02 | 170.11 | 170.02 | 170.05 | 10021.0 |
| 2022-08-25 18:00:00 | AAPL | Stock | 170.1 | 170.12 | 170.0 | 170.01 | 19976.0 |
| 2022-08-25 18:30:00 | AAPL | Stock | 170.0 | 170.1 | 169.98 | 170.07 | 5391.0 |
| 2022-08-25 19:00:00 | AAPL | Stock | 170.09 | 170.35 | 170.09 | 170.3 | 13160.0 |
| 2022-08-25 19:30:00 | AAPL | Stock | 170.25 | 170.35 | 170.2 | 170.2 | 14660.0 |
| 2022-08-25 04:00:00 | MSFT | Stock | 278.37 | 278.37 | 278.18 | 278.22 | 400.0 |
| 2022-08-25 05:00:00 | MSFT | Stock | 278.37 | 278.4 | 278.0 | 278.0 | 2482.0 |
| 2022-08-25 05:30:00 | MSFT | Stock | 277.3 | 277.34 | 276.98 | 276.98 | 924.0 |
| 2022-08-25 06:00:00 | MSFT | Stock | 277.05 | 277.5 | 277.05 | 277.5 | 794.0 |
| 2022-08-25 06:30:00 | MSFT | Stock | 277.77 | 277.78 | 277.55 | 277.75 | 1773.0 |
| 2022-08-25 07:00:00 | MSFT | Stock | 277.9 | 278.16 | 277.72 | 278.1 | 6094.0 |
| 2022-08-25 07:30:00 | MSFT | Stock | 277.75 | 277.82 | 277.5 | 277.59 | 3268.0 |
| 2022-08-25 08:00:00 | MSFT | Stock | 277.97 | 278.3473 | 277.36 | 277.5 | 14895.0 |
| 2022-08-25 08:30:00 | MSFT | Stock | 277.5 | 277.85 | 277.1 | 277.3 | 9852.0 |
| 2022-08-25 09:00:00 | MSFT | Stock | 277.58 | 277.7 | 277.11 | 277.25 | 15373.0 |
| 2022-08-25 09:30:00 | MSFT | Stock | 277.41 | 277.63 | 274.52 | 276.72 | 1830634.0 |
| 2022-08-25 10:00:00 | MSFT | Stock | 276.78 | 277.36 | 276.61 | 277.16 | 802894.0 |
| 2022-08-25 10:30:00 | MSFT | Stock | 277.21 | 277.66 | 276.86 | 276.86 | 620638.0 |
| 2022-08-25 11:00:00 | MSFT | Stock | 276.91 | 277.08 | 275.02 | 275.47 | 695687.0 |
| 2022-08-25 11:30:00 | MSFT | Stock | 275.49 | 275.92 | 275.22 | 275.76 | 600132.0 |
| 2022-08-25 12:00:00 | MSFT | Stock | 275.755 | 276.07 | 275.34 | 275.92 | 460724.0 |
| 2022-08-25 12:30:00 | MSFT | Stock | 275.92 | 275.97 | 275.23 | 275.74 | 298356.0 |
| 2022-08-25 13:00:00 | MSFT | Stock | 275.73 | 276.1601 | 275.48 | 276.11 | 367957.0 |
> showing 50 of 103,995 rows — these rows as CSV