PREVIEW / stock_30min / 2024-05-15
file: by_date/stock_30min/2024/2024-05-15.parquet size: 2.1 MB rows: 101,376 symbols: 972
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-15 04:00:00 | AAPL | Stock | 187.43 | 187.43 | 187.0 | 187.16 | 4042.0 |
| 2024-05-15 04:30:00 | AAPL | Stock | 187.32 | 187.34 | 187.32 | 187.34 | 1157.0 |
| 2024-05-15 05:00:00 | AAPL | Stock | 187.34 | 187.37 | 187.33 | 187.33 | 1495.0 |
| 2024-05-15 05:30:00 | AAPL | Stock | 187.3 | 187.35 | 187.3 | 187.3 | 2370.0 |
| 2024-05-15 06:00:00 | AAPL | Stock | 187.27 | 187.27 | 187.27 | 187.27 | 170.0 |
| 2024-05-15 06:30:00 | AAPL | Stock | 187.2 | 187.2 | 187.2 | 187.2 | 731.0 |
| 2024-05-15 07:00:00 | AAPL | Stock | 187.24 | 187.35 | 187.2 | 187.2 | 7831.0 |
| 2024-05-15 07:30:00 | AAPL | Stock | 187.25 | 187.3 | 187.2 | 187.3 | 11531.0 |
| 2024-05-15 08:00:00 | AAPL | Stock | 187.29 | 187.44 | 187.0 | 187.1 | 44313.0 |
| 2024-05-15 08:30:00 | AAPL | Stock | 187.15 | 188.23 | 187.15 | 187.75 | 215239.0 |
| 2024-05-15 09:00:00 | AAPL | Stock | 187.76 | 188.0 | 187.2 | 187.83 | 139510.0 |
| 2024-05-15 09:30:00 | AAPL | Stock | 187.83 | 188.89 | 187.37 | 188.87 | 5749245.0 |
| 2024-05-15 10:00:00 | AAPL | Stock | 188.8521 | 189.73 | 188.8 | 189.579 | 5511665.0 |
| 2024-05-15 10:30:00 | AAPL | Stock | 189.58 | 189.95 | 189.52 | 189.92 | 3974098.0 |
| 2024-05-15 11:00:00 | AAPL | Stock | 189.93 | 190.07 | 189.7201 | 189.92 | 4718951.0 |
| 2024-05-15 11:30:00 | AAPL | Stock | 189.925 | 189.94 | 189.54 | 189.885 | 2148292.0 |
| 2024-05-15 12:00:00 | AAPL | Stock | 189.89 | 190.21 | 189.795 | 190.155 | 2313911.0 |
| 2024-05-15 12:30:00 | AAPL | Stock | 190.15 | 190.51 | 190.14 | 190.39 | 2871794.0 |
| 2024-05-15 13:00:00 | AAPL | Stock | 190.395 | 190.65 | 190.2501 | 190.37 | 2296080.0 |
| 2024-05-15 13:30:00 | AAPL | Stock | 190.38 | 190.55 | 190.17 | 190.38 | 1939585.0 |
| 2024-05-15 14:00:00 | AAPL | Stock | 190.385 | 190.39 | 189.8601 | 189.93 | 2519788.0 |
| 2024-05-15 14:30:00 | AAPL | Stock | 189.925 | 190.12 | 189.82 | 189.975 | 1964649.0 |
| 2024-05-15 15:00:00 | AAPL | Stock | 189.975 | 190.26 | 189.82 | 189.875 | 3294312.0 |
| 2024-05-15 15:30:00 | AAPL | Stock | 189.875 | 190.12 | 189.5 | 189.75 | 7001538.0 |
| 2024-05-15 16:00:00 | AAPL | Stock | 189.93 | 190.0 | 189.6 | 189.8 | 9644504.0 |
| 2024-05-15 16:30:00 | AAPL | Stock | 189.77 | 189.86 | 189.72 | 189.78 | 79362.0 |
| 2024-05-15 17:00:00 | AAPL | Stock | 189.75 | 189.78 | 189.71 | 189.75 | 8735.0 |
| 2024-05-15 17:30:00 | AAPL | Stock | 189.75 | 189.78 | 189.71 | 189.72 | 37235.0 |
| 2024-05-15 18:00:00 | AAPL | Stock | 189.78 | 189.85 | 189.76 | 189.84 | 7271.0 |
| 2024-05-15 18:30:00 | AAPL | Stock | 189.8415 | 190.0 | 189.76 | 189.85 | 8507.0 |
| 2024-05-15 19:00:00 | AAPL | Stock | 189.92 | 190.0 | 189.9 | 189.99 | 6079.0 |
| 2024-05-15 19:30:00 | AAPL | Stock | 189.99 | 190.0 | 189.87 | 189.96 | 5247.0 |
| 2024-05-15 04:00:00 | MSFT | Stock | 415.61 | 415.61 | 415.35 | 415.35 | 1731.0 |
| 2024-05-15 04:30:00 | MSFT | Stock | 415.5 | 415.51 | 415.4 | 415.4 | 667.0 |
| 2024-05-15 05:00:00 | MSFT | Stock | 415.63 | 415.63 | 415.63 | 415.63 | 100.0 |
| 2024-05-15 05:30:00 | MSFT | Stock | 415.8 | 415.81 | 415.66 | 415.71 | 867.0 |
| 2024-05-15 06:00:00 | MSFT | Stock | 415.6 | 415.7 | 415.6 | 415.7 | 710.0 |
| 2024-05-15 06:30:00 | MSFT | Stock | 415.7 | 415.83 | 415.7 | 415.74 | 2516.0 |
| 2024-05-15 07:00:00 | MSFT | Stock | 415.92 | 416.62 | 415.92 | 416.62 | 1994.0 |
| 2024-05-15 07:30:00 | MSFT | Stock | 416.39 | 416.7 | 416.39 | 416.5 | 3439.0 |
| 2024-05-15 08:00:00 | MSFT | Stock | 416.61 | 416.8887 | 415.7 | 416.0201 | 6966.0 |
| 2024-05-15 08:30:00 | MSFT | Stock | 416.46 | 418.75 | 416.46 | 417.27 | 58153.0 |
| 2024-05-15 09:00:00 | MSFT | Stock | 417.1 | 418.22 | 416.35 | 417.6 | 25276.0 |
| 2024-05-15 09:30:00 | MSFT | Stock | 417.9 | 420.45 | 417.27 | 418.27 | 1626249.0 |
| 2024-05-15 10:00:00 | MSFT | Stock | 418.21 | 419.51 | 418.2 | 419.39 | 669028.0 |
| 2024-05-15 10:30:00 | MSFT | Stock | 419.45 | 420.3 | 418.98 | 420.1399 | 586979.0 |
| 2024-05-15 11:00:00 | MSFT | Stock | 420.17 | 421.3199 | 420.17 | 421.255 | 532668.0 |
| 2024-05-15 11:30:00 | MSFT | Stock | 421.28 | 422.0976 | 420.71 | 421.6781 | 634030.0 |
| 2024-05-15 12:00:00 | MSFT | Stock | 421.66 | 421.68 | 420.69 | 421.43 | 417696.0 |
| 2024-05-15 12:30:00 | MSFT | Stock | 421.42 | 421.85 | 421.1 | 421.84 | 256319.0 |
> showing 50 of 101,376 rows — these rows as CSV