PREVIEW / stock_30min / 2024-01-25
file: by_date/stock_30min/2024/2024-01-25.parquet size: 2.0 MB rows: 98,148 symbols: 1,160
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-01-25 04:00:00 | AAPL | Stock | 194.0 | 194.0 | 193.42 | 193.42 | 6155.0 |
| 2024-01-25 04:30:00 | AAPL | Stock | 193.45 | 193.79 | 193.45 | 193.66 | 7913.0 |
| 2024-01-25 05:00:00 | AAPL | Stock | 193.57 | 193.71 | 193.5 | 193.67 | 4554.0 |
| 2024-01-25 05:30:00 | AAPL | Stock | 193.62 | 193.65 | 193.6 | 193.64 | 2072.0 |
| 2024-01-25 06:00:00 | AAPL | Stock | 193.6 | 193.6 | 193.53 | 193.59 | 2432.0 |
| 2024-01-25 06:30:00 | AAPL | Stock | 193.59 | 194.0 | 193.55 | 193.99 | 7693.0 |
| 2024-01-25 07:00:00 | AAPL | Stock | 194.0 | 194.5 | 193.91 | 194.13 | 24666.0 |
| 2024-01-25 07:30:00 | AAPL | Stock | 194.11 | 194.17 | 193.89 | 193.94 | 8994.0 |
| 2024-01-25 08:00:00 | AAPL | Stock | 194.23 | 194.5 | 193.6095 | 194.05 | 75975.0 |
| 2024-01-25 08:30:00 | AAPL | Stock | 194.01 | 195.09 | 193.88 | 194.9 | 147907.0 |
| 2024-01-25 09:00:00 | AAPL | Stock | 194.9326 | 195.2 | 194.45 | 195.2 | 137601.0 |
| 2024-01-25 09:30:00 | AAPL | Stock | 195.22 | 195.64 | 194.6903 | 194.8101 | 4437567.0 |
| 2024-01-25 10:00:00 | AAPL | Stock | 194.82 | 195.39 | 194.63 | 195.355 | 2538937.0 |
| 2024-01-25 10:30:00 | AAPL | Stock | 195.36 | 195.63 | 195.14 | 195.4702 | 2949133.0 |
| 2024-01-25 11:00:00 | AAPL | Stock | 195.48 | 195.87 | 195.16 | 195.84 | 2155813.0 |
| 2024-01-25 11:30:00 | AAPL | Stock | 195.84 | 196.2675 | 195.71 | 195.958 | 2787109.0 |
| 2024-01-25 12:00:00 | AAPL | Stock | 195.96 | 196.056 | 195.53 | 195.74 | 2224438.0 |
| 2024-01-25 12:30:00 | AAPL | Stock | 195.75 | 195.87 | 195.54 | 195.805 | 1588453.0 |
| 2024-01-25 13:00:00 | AAPL | Stock | 195.805 | 195.9574 | 194.1 | 194.71 | 5047278.0 |
| 2024-01-25 13:30:00 | AAPL | Stock | 194.705 | 194.935 | 194.05 | 194.125 | 2503693.0 |
| 2024-01-25 14:00:00 | AAPL | Stock | 194.12 | 194.12 | 193.7517 | 193.9111 | 2270751.0 |
| 2024-01-25 14:30:00 | AAPL | Stock | 193.915 | 194.01 | 193.1125 | 193.56 | 2365444.0 |
| 2024-01-25 15:00:00 | AAPL | Stock | 193.55 | 194.13 | 193.45 | 193.8535 | 1882798.0 |
| 2024-01-25 15:30:00 | AAPL | Stock | 193.855 | 194.31 | 193.76 | 194.19 | 4174020.0 |
| 2024-01-25 16:00:00 | AAPL | Stock | 194.05 | 194.55 | 194.05 | 194.38 | 6085599.0 |
| 2024-01-25 16:30:00 | AAPL | Stock | 194.38 | 194.49 | 194.17 | 194.21 | 63112.0 |
| 2024-01-25 17:00:00 | AAPL | Stock | 194.2 | 194.38 | 194.05 | 194.11 | 11932.0 |
| 2024-01-25 17:30:00 | AAPL | Stock | 194.1 | 194.2 | 193.88 | 194.15 | 99844.0 |
| 2024-01-25 18:00:00 | AAPL | Stock | 193.9 | 194.17 | 193.8 | 193.8 | 26095.0 |
| 2024-01-25 18:30:00 | AAPL | Stock | 193.8 | 194.09 | 193.75 | 194.0003 | 9549.0 |
| 2024-01-25 19:00:00 | AAPL | Stock | 194.08 | 194.1 | 193.82 | 193.9 | 7061.0 |
| 2024-01-25 19:30:00 | AAPL | Stock | 193.98 | 194.17 | 193.85 | 194.17 | 22425.0 |
| 2024-01-25 04:00:00 | MSFT | Stock | 404.0 | 404.1 | 403.09 | 403.2 | 5703.0 |
| 2024-01-25 04:30:00 | MSFT | Stock | 403.2 | 403.39 | 402.75 | 402.76 | 2455.0 |
| 2024-01-25 05:00:00 | MSFT | Stock | 402.59 | 402.75 | 402.01 | 402.16 | 4737.0 |
| 2024-01-25 05:30:00 | MSFT | Stock | 402.25 | 402.25 | 401.6 | 401.67 | 3223.0 |
| 2024-01-25 06:00:00 | MSFT | Stock | 401.71 | 402.34 | 401.71 | 402.34 | 429.0 |
| 2024-01-25 06:30:00 | MSFT | Stock | 403.57 | 404.2 | 403.57 | 404.08 | 2168.0 |
| 2024-01-25 07:00:00 | MSFT | Stock | 404.1 | 404.67 | 403.79 | 404.15 | 12056.0 |
| 2024-01-25 07:30:00 | MSFT | Stock | 404.1 | 404.44 | 404.04 | 404.14 | 6125.0 |
| 2024-01-25 08:00:00 | MSFT | Stock | 404.1 | 404.7697 | 403.51 | 404.6886 | 35456.0 |
| 2024-01-25 08:30:00 | MSFT | Stock | 404.7 | 405.55 | 404.4 | 405.5 | 51614.0 |
| 2024-01-25 09:00:00 | MSFT | Stock | 405.53 | 405.6 | 403.55 | 404.07 | 47742.0 |
| 2024-01-25 09:30:00 | MSFT | Stock | 404.32 | 406.0 | 403.365 | 404.3 | 1956900.0 |
| 2024-01-25 10:00:00 | MSFT | Stock | 404.33 | 406.675 | 403.43 | 405.96 | 1304640.0 |
| 2024-01-25 10:30:00 | MSFT | Stock | 406.0 | 407.01 | 405.38 | 406.94 | 783907.0 |
| 2024-01-25 11:00:00 | MSFT | Stock | 406.92 | 406.9493 | 405.875 | 406.417 | 712422.0 |
| 2024-01-25 11:30:00 | MSFT | Stock | 406.41 | 406.84 | 405.75 | 406.185 | 579249.0 |
| 2024-01-25 12:00:00 | MSFT | Stock | 406.1884 | 406.45 | 404.89 | 405.432 | 827347.0 |
| 2024-01-25 12:30:00 | MSFT | Stock | 405.4796 | 405.96 | 405.21 | 405.47 | 710805.0 |
> showing 50 of 98,148 rows — these rows as CSV