PREVIEW / stock_30min / 2024-05-17
file: by_date/stock_30min/2024/2024-05-17.parquet size: 2.1 MB rows: 99,079 symbols: 964
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 |
|---|---|---|---|---|---|---|---|
| 2024-05-17 04:00:00 | AAPL | Stock | 189.78 | 189.78 | 189.6 | 189.6 | 4713.0 |
| 2024-05-17 04:30:00 | AAPL | Stock | 189.5 | 189.61 | 189.5 | 189.58 | 1597.0 |
| 2024-05-17 05:00:00 | AAPL | Stock | 189.65 | 189.67 | 189.63 | 189.67 | 785.0 |
| 2024-05-17 05:30:00 | AAPL | Stock | 189.7 | 189.75 | 189.7 | 189.75 | 425.0 |
| 2024-05-17 06:00:00 | AAPL | Stock | 189.75 | 189.8 | 189.73 | 189.8 | 739.0 |
| 2024-05-17 06:30:00 | AAPL | Stock | 189.74 | 189.79 | 189.72 | 189.72 | 450.0 |
| 2024-05-17 07:00:00 | AAPL | Stock | 189.74 | 189.85 | 189.7 | 189.85 | 6952.0 |
| 2024-05-17 07:30:00 | AAPL | Stock | 189.84 | 189.91 | 189.8 | 189.82 | 4987.0 |
| 2024-05-17 08:00:00 | AAPL | Stock | 189.78 | 190.25 | 189.7077 | 189.94 | 33135.0 |
| 2024-05-17 08:30:00 | AAPL | Stock | 189.94 | 190.0 | 189.94 | 189.9573 | 8940.0 |
| 2024-05-17 09:00:00 | AAPL | Stock | 189.94 | 190.5 | 189.28 | 189.5 | 188964.0 |
| 2024-05-17 09:30:00 | AAPL | Stock | 189.53 | 190.81 | 189.18 | 190.4 | 6435247.0 |
| 2024-05-17 10:00:00 | AAPL | Stock | 190.4 | 190.52 | 189.97 | 190.1501 | 1921933.0 |
| 2024-05-17 10:30:00 | AAPL | Stock | 190.16 | 190.3 | 189.83 | 189.965 | 1638193.0 |
| 2024-05-17 11:00:00 | AAPL | Stock | 189.98 | 189.98 | 189.652 | 189.697 | 1300548.0 |
| 2024-05-17 11:30:00 | AAPL | Stock | 189.69 | 189.71 | 189.4201 | 189.58 | 1380625.0 |
| 2024-05-17 12:00:00 | AAPL | Stock | 189.5787 | 189.97 | 189.5501 | 189.79 | 1416282.0 |
| 2024-05-17 12:30:00 | AAPL | Stock | 189.795 | 189.99 | 189.645 | 189.9489 | 956372.0 |
| 2024-05-17 13:00:00 | AAPL | Stock | 189.95 | 189.95 | 189.58 | 189.685 | 797737.0 |
| 2024-05-17 13:30:00 | AAPL | Stock | 189.69 | 189.875 | 189.585 | 189.81 | 851790.0 |
| 2024-05-17 14:00:00 | AAPL | Stock | 189.8187 | 189.82 | 189.38 | 189.675 | 943643.0 |
| 2024-05-17 14:30:00 | AAPL | Stock | 189.67 | 190.05 | 189.62 | 189.9738 | 1270703.0 |
| 2024-05-17 15:00:00 | AAPL | Stock | 189.9781 | 190.13 | 189.8902 | 190.105 | 1691749.0 |
| 2024-05-17 15:30:00 | AAPL | Stock | 190.105 | 190.15 | 189.75 | 189.93 | 5049076.0 |
| 2024-05-17 16:00:00 | AAPL | Stock | 189.91 | 189.99 | 189.82 | 189.94 | 6206066.0 |
| 2024-05-17 16:30:00 | AAPL | Stock | 189.96 | 190.07 | 189.87 | 190.04 | 25667.0 |
| 2024-05-17 17:00:00 | AAPL | Stock | 190.03 | 190.04 | 189.87 | 189.98 | 18629.0 |
| 2024-05-17 17:30:00 | AAPL | Stock | 190.0 | 190.03 | 190.0 | 190.0 | 4727.0 |
| 2024-05-17 18:00:00 | AAPL | Stock | 190.0 | 190.0 | 189.99 | 190.0 | 1325.0 |
| 2024-05-17 18:30:00 | AAPL | Stock | 190.0 | 190.0 | 189.99 | 190.0 | 1400.0 |
| 2024-05-17 19:00:00 | AAPL | Stock | 189.99 | 190.05 | 189.99 | 190.01 | 4972.0 |
| 2024-05-17 19:30:00 | AAPL | Stock | 190.0 | 190.0 | 189.9 | 189.92 | 7498.0 |
| 2024-05-17 04:00:00 | MSFT | Stock | 422.0 | 422.17 | 421.6 | 421.6 | 3692.0 |
| 2024-05-17 04:30:00 | MSFT | Stock | 421.48 | 421.83 | 421.0 | 421.83 | 2722.0 |
| 2024-05-17 05:00:00 | MSFT | Stock | 421.84 | 421.84 | 421.84 | 421.84 | 100.0 |
| 2024-05-17 05:30:00 | MSFT | Stock | 422.29 | 422.85 | 422.29 | 422.85 | 454.0 |
| 2024-05-17 06:00:00 | MSFT | Stock | 422.63 | 422.63 | 421.95 | 422.5 | 2912.0 |
| 2024-05-17 06:30:00 | MSFT | Stock | 422.69 | 422.81 | 422.53 | 422.53 | 1615.0 |
| 2024-05-17 07:00:00 | MSFT | Stock | 422.51 | 422.51 | 422.49 | 422.5 | 1641.0 |
| 2024-05-17 07:30:00 | MSFT | Stock | 422.63 | 422.81 | 422.63 | 422.81 | 818.0 |
| 2024-05-17 08:00:00 | MSFT | Stock | 422.71 | 422.75 | 421.44 | 422.73 | 11533.0 |
| 2024-05-17 08:30:00 | MSFT | Stock | 422.73 | 423.0 | 422.66 | 422.95 | 6320.0 |
| 2024-05-17 09:00:00 | MSFT | Stock | 422.6657 | 423.3 | 420.42 | 422.54 | 80053.0 |
| 2024-05-17 09:30:00 | MSFT | Stock | 422.55 | 422.92 | 418.025 | 418.75 | 2284502.0 |
| 2024-05-17 10:00:00 | MSFT | Stock | 418.72 | 420.25 | 418.49 | 419.725 | 601497.0 |
| 2024-05-17 10:30:00 | MSFT | Stock | 419.7204 | 420.48 | 419.37 | 419.517 | 334137.0 |
| 2024-05-17 11:00:00 | MSFT | Stock | 419.5 | 419.66 | 418.405 | 419.56 | 349625.0 |
| 2024-05-17 11:30:00 | MSFT | Stock | 419.61 | 419.72 | 419.15 | 419.66 | 238478.0 |
| 2024-05-17 12:00:00 | MSFT | Stock | 419.64 | 419.695 | 419.139 | 419.34 | 215352.0 |
| 2024-05-17 12:30:00 | MSFT | Stock | 419.3223 | 419.39 | 418.33 | 419.24 | 250342.0 |
> showing 50 of 99,079 rows — these rows as CSV