PREVIEW / stock_30min / 2022-12-12
file: by_date/stock_30min/2022/2022-12-12.parquet size: 2.1 MB rows: 103,302 symbols: 2,005
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-12-12 04:00:00 | AAPL | Stock | 142.14 | 142.7 | 142.14 | 142.41 | 7774.0 |
| 2022-12-12 04:30:00 | AAPL | Stock | 142.55 | 142.61 | 142.51 | 142.54 | 2973.0 |
| 2022-12-12 05:00:00 | AAPL | Stock | 142.55 | 142.6 | 142.55 | 142.56 | 4463.0 |
| 2022-12-12 05:30:00 | AAPL | Stock | 142.6 | 142.77 | 142.6 | 142.74 | 3301.0 |
| 2022-12-12 06:00:00 | AAPL | Stock | 142.7 | 142.7 | 142.57 | 142.6 | 2278.0 |
| 2022-12-12 06:30:00 | AAPL | Stock | 142.63 | 142.74 | 142.63 | 142.66 | 2957.0 |
| 2022-12-12 07:00:00 | AAPL | Stock | 142.62 | 142.65 | 142.43 | 142.43 | 30119.0 |
| 2022-12-12 07:30:00 | AAPL | Stock | 142.42 | 142.55 | 142.41 | 142.54 | 18712.0 |
| 2022-12-12 08:00:00 | AAPL | Stock | 142.4899 | 142.7695 | 141.56 | 142.6 | 92728.0 |
| 2022-12-12 08:30:00 | AAPL | Stock | 142.58 | 142.8 | 142.51 | 142.52 | 62430.0 |
| 2022-12-12 09:00:00 | AAPL | Stock | 142.56 | 142.9 | 142.26 | 142.9 | 125113.0 |
| 2022-12-12 09:30:00 | AAPL | Stock | 142.9 | 143.01 | 141.64 | 142.679 | 5979656.0 |
| 2022-12-12 10:00:00 | AAPL | Stock | 142.69 | 142.88 | 141.971 | 142.125 | 4000935.0 |
| 2022-12-12 10:30:00 | AAPL | Stock | 142.125 | 142.13 | 141.06 | 141.77 | 3886354.0 |
| 2022-12-12 11:00:00 | AAPL | Stock | 141.77 | 142.47 | 141.73 | 142.13 | 3280967.0 |
| 2022-12-12 11:30:00 | AAPL | Stock | 142.14 | 142.28 | 141.8 | 141.9481 | 2266496.0 |
| 2022-12-12 12:00:00 | AAPL | Stock | 141.95 | 142.22 | 141.84 | 142.04 | 1935817.0 |
| 2022-12-12 12:30:00 | AAPL | Stock | 142.03 | 142.45 | 141.95 | 142.2799 | 2169583.0 |
| 2022-12-12 13:00:00 | AAPL | Stock | 142.2773 | 142.69 | 142.045 | 142.365 | 2253440.0 |
| 2022-12-12 13:30:00 | AAPL | Stock | 142.36 | 142.885 | 142.22 | 142.7 | 2425889.0 |
| 2022-12-12 14:00:00 | AAPL | Stock | 142.71 | 142.785 | 142.39 | 142.655 | 2367418.0 |
| 2022-12-12 14:30:00 | AAPL | Stock | 142.6596 | 143.93 | 142.57 | 143.815 | 4222430.0 |
| 2022-12-12 15:00:00 | AAPL | Stock | 143.82 | 144.15 | 143.48 | 143.9124 | 3917383.0 |
| 2022-12-12 15:30:00 | AAPL | Stock | 143.92 | 144.5 | 143.66 | 144.495 | 6256213.0 |
| 2022-12-12 16:00:00 | AAPL | Stock | 144.48 | 144.55 | 142.9411 | 144.4 | 12811941.0 |
| 2022-12-12 16:30:00 | AAPL | Stock | 144.37 | 144.4 | 144.2 | 144.31 | 30342.0 |
| 2022-12-12 17:00:00 | AAPL | Stock | 144.32 | 144.43 | 144.24 | 144.43 | 16145.0 |
| 2022-12-12 17:30:00 | AAPL | Stock | 144.43 | 144.49 | 144.28 | 144.3 | 40656.0 |
| 2022-12-12 18:00:00 | AAPL | Stock | 144.3 | 144.39 | 144.2419 | 144.2419 | 8494.0 |
| 2022-12-12 18:30:00 | AAPL | Stock | 144.28 | 144.4 | 144.25 | 144.38 | 10994.0 |
| 2022-12-12 19:00:00 | AAPL | Stock | 144.37 | 144.44 | 144.37 | 144.38 | 8428.0 |
| 2022-12-12 19:30:00 | AAPL | Stock | 144.38 | 144.44 | 144.35 | 144.44 | 10227.0 |
| 2022-12-12 04:00:00 | MSFT | Stock | 245.17 | 245.17 | 244.76 | 244.76 | 1585.0 |
| 2022-12-12 04:30:00 | MSFT | Stock | 245.07 | 245.46 | 245.07 | 245.46 | 368.0 |
| 2022-12-12 05:00:00 | MSFT | Stock | 245.9 | 246.2 | 245.9 | 246.18 | 2649.0 |
| 2022-12-12 05:30:00 | MSFT | Stock | 246.39 | 246.57 | 246.39 | 246.45 | 1003.0 |
| 2022-12-12 06:00:00 | MSFT | Stock | 246.51 | 246.6 | 246.31 | 246.46 | 1773.0 |
| 2022-12-12 06:30:00 | MSFT | Stock | 246.45 | 246.86 | 246.45 | 246.6 | 1361.0 |
| 2022-12-12 07:00:00 | MSFT | Stock | 246.47 | 246.62 | 246.37 | 246.61 | 6952.0 |
| 2022-12-12 07:30:00 | MSFT | Stock | 246.65 | 246.8 | 246.58 | 246.6 | 2071.0 |
| 2022-12-12 08:00:00 | MSFT | Stock | 246.65 | 246.9869 | 246.33 | 246.7 | 9896.0 |
| 2022-12-12 08:30:00 | MSFT | Stock | 246.65 | 246.88 | 246.0501 | 246.6162 | 8534.0 |
| 2022-12-12 09:00:00 | MSFT | Stock | 246.41 | 247.5 | 245.95 | 247.47 | 47038.0 |
| 2022-12-12 09:30:00 | MSFT | Stock | 247.47 | 252.16 | 247.17 | 251.1855 | 3542371.0 |
| 2022-12-12 10:00:00 | MSFT | Stock | 251.21 | 251.3019 | 250.16 | 250.7799 | 1825539.0 |
| 2022-12-12 10:30:00 | MSFT | Stock | 250.78 | 250.78 | 248.79 | 249.75 | 1487151.0 |
| 2022-12-12 11:00:00 | MSFT | Stock | 249.765 | 250.905 | 249.765 | 250.36 | 1377483.0 |
| 2022-12-12 11:30:00 | MSFT | Stock | 250.38 | 250.59 | 249.62 | 250.35 | 979119.0 |
| 2022-12-12 12:00:00 | MSFT | Stock | 250.35 | 250.4 | 249.69 | 249.89 | 916364.0 |
| 2022-12-12 12:30:00 | MSFT | Stock | 249.875 | 250.4348 | 249.74 | 250.235 | 804652.0 |
> showing 50 of 103,302 rows — these rows as CSV