PREVIEW / stock_30min / 2022-06-21
file: by_date/stock_30min/2022/2022-06-21.parquet size: 2.2 MB rows: 108,282 symbols: 2,376
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-06-21 04:00:00 | AAPL | Stock | 132.51 | 135.99 | 132.51 | 134.46 | 81689.0 |
| 2022-06-21 04:30:00 | AAPL | Stock | 134.52 | 134.57 | 134.15 | 134.44 | 35958.0 |
| 2022-06-21 05:00:00 | AAPL | Stock | 134.45 | 134.5 | 134.25 | 134.25 | 12911.0 |
| 2022-06-21 05:30:00 | AAPL | Stock | 134.21 | 134.28 | 133.93 | 134.02 | 17690.0 |
| 2022-06-21 06:00:00 | AAPL | Stock | 134.09 | 134.39 | 133.96 | 134.19 | 45486.0 |
| 2022-06-21 06:30:00 | AAPL | Stock | 134.21 | 134.43 | 134.19 | 134.23 | 12688.0 |
| 2022-06-21 07:00:00 | AAPL | Stock | 134.21 | 134.3 | 133.66 | 133.92 | 93670.0 |
| 2022-06-21 07:30:00 | AAPL | Stock | 133.81 | 133.93 | 133.4 | 133.44 | 60397.0 |
| 2022-06-21 08:00:00 | AAPL | Stock | 134.2 | 134.2 | 131.232 | 133.65 | 344440.0 |
| 2022-06-21 08:30:00 | AAPL | Stock | 133.66 | 133.9 | 133.44 | 133.48 | 165265.0 |
| 2022-06-21 09:00:00 | AAPL | Stock | 133.51 | 133.95 | 133.2 | 133.44 | 286642.0 |
| 2022-06-21 09:30:00 | AAPL | Stock | 133.42 | 136.46 | 133.32 | 136.34 | 14042563.0 |
| 2022-06-21 10:00:00 | AAPL | Stock | 136.35 | 136.8 | 135.79 | 136.3453 | 6591859.0 |
| 2022-06-21 10:30:00 | AAPL | Stock | 136.345 | 136.9 | 136.28 | 136.8094 | 4191459.0 |
| 2022-06-21 11:00:00 | AAPL | Stock | 136.81 | 137.06 | 136.54 | 136.5734 | 3649124.0 |
| 2022-06-21 11:30:00 | AAPL | Stock | 136.58 | 136.72 | 135.99 | 135.99 | 3325769.0 |
| 2022-06-21 12:00:00 | AAPL | Stock | 135.995 | 136.25 | 135.7 | 136.005 | 3506073.0 |
| 2022-06-21 12:30:00 | AAPL | Stock | 136.01 | 136.12 | 135.71 | 136.07 | 2405857.0 |
| 2022-06-21 13:00:00 | AAPL | Stock | 136.075 | 136.18 | 135.74 | 135.89 | 2010006.0 |
| 2022-06-21 13:30:00 | AAPL | Stock | 135.89 | 136.1169 | 135.64 | 135.82 | 2014470.0 |
| 2022-06-21 14:00:00 | AAPL | Stock | 135.83 | 135.8957 | 135.535 | 135.88 | 2450942.0 |
| 2022-06-21 14:30:00 | AAPL | Stock | 135.89 | 136.23 | 135.47 | 136.195 | 3079689.0 |
| 2022-06-21 15:00:00 | AAPL | Stock | 136.2 | 136.41 | 135.88 | 136.09 | 3801219.0 |
| 2022-06-21 15:30:00 | AAPL | Stock | 136.09 | 136.25 | 135.585 | 135.86 | 6626981.0 |
| 2022-06-21 16:00:00 | AAPL | Stock | 135.86 | 135.99 | 135.71 | 135.92 | 11980842.0 |
| 2022-06-21 16:30:00 | AAPL | Stock | 135.91 | 135.95 | 135.85 | 135.87 | 36278.0 |
| 2022-06-21 17:00:00 | AAPL | Stock | 135.88 | 135.94 | 135.81 | 135.84 | 27387.0 |
| 2022-06-21 17:30:00 | AAPL | Stock | 135.84 | 135.86 | 135.78 | 135.84 | 19119.0 |
| 2022-06-21 18:00:00 | AAPL | Stock | 135.8 | 135.8 | 135.6 | 135.69 | 16964.0 |
| 2022-06-21 18:30:00 | AAPL | Stock | 135.7 | 135.73 | 135.53 | 135.61 | 14291.0 |
| 2022-06-21 19:00:00 | AAPL | Stock | 135.64 | 135.65 | 135.51 | 135.59 | 16939.0 |
| 2022-06-21 19:30:00 | AAPL | Stock | 135.61 | 135.7 | 135.55 | 135.6 | 27954.0 |
| 2022-06-21 04:00:00 | MSFT | Stock | 249.01 | 252.7 | 249.01 | 252.38 | 3537.0 |
| 2022-06-21 04:30:00 | MSFT | Stock | 252.41 | 252.41 | 251.8 | 252.06 | 6722.0 |
| 2022-06-21 05:00:00 | MSFT | Stock | 252.2 | 252.2 | 252.07 | 252.1 | 2400.0 |
| 2022-06-21 05:30:00 | MSFT | Stock | 251.91 | 251.91 | 251.59 | 251.59 | 573.0 |
| 2022-06-21 06:00:00 | MSFT | Stock | 251.59 | 251.83 | 251.59 | 251.83 | 1743.0 |
| 2022-06-21 06:30:00 | MSFT | Stock | 251.74 | 251.84 | 251.74 | 251.79 | 780.0 |
| 2022-06-21 07:00:00 | MSFT | Stock | 251.51 | 251.76 | 250.96 | 251.1 | 12494.0 |
| 2022-06-21 07:30:00 | MSFT | Stock | 251.25 | 251.28 | 250.64 | 250.75 | 6151.0 |
| 2022-06-21 08:00:00 | MSFT | Stock | 251.6 | 251.7899 | 247.031 | 250.7128 | 24995.0 |
| 2022-06-21 08:30:00 | MSFT | Stock | 250.87 | 251.53 | 250.37 | 250.37 | 31617.0 |
| 2022-06-21 09:00:00 | MSFT | Stock | 250.11 | 250.93 | 250.0 | 250.0 | 40605.0 |
| 2022-06-21 09:30:00 | MSFT | Stock | 250.255 | 254.35 | 249.51 | 253.14 | 2966090.0 |
| 2022-06-21 10:00:00 | MSFT | Stock | 253.06 | 254.75 | 252.77 | 254.28 | 1463149.0 |
| 2022-06-21 10:30:00 | MSFT | Stock | 254.29 | 254.72 | 253.76 | 254.33 | 1267255.0 |
| 2022-06-21 11:00:00 | MSFT | Stock | 254.325 | 254.41 | 253.47 | 253.846 | 858596.0 |
| 2022-06-21 11:30:00 | MSFT | Stock | 253.84 | 254.0409 | 253.15 | 253.38 | 783341.0 |
| 2022-06-21 12:00:00 | MSFT | Stock | 253.37 | 253.82 | 252.77 | 252.99 | 738714.0 |
| 2022-06-21 12:30:00 | MSFT | Stock | 253.03 | 253.74 | 252.865 | 253.72 | 535768.0 |
> showing 50 of 108,282 rows — these rows as CSV