PREVIEW / stock_30min / 2024-06-03
file: by_date/stock_30min/2024/2024-06-03.parquet size: 2.0 MB rows: 96,269 symbols: 975
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-06-03 04:00:00 | AAPL | Stock | 192.45 | 193.3 | 192.45 | 192.85 | 36388.0 |
| 2024-06-03 04:30:00 | AAPL | Stock | 192.93 | 193.15 | 192.91 | 193.1 | 14607.0 |
| 2024-06-03 05:00:00 | AAPL | Stock | 193.0 | 193.11 | 192.95 | 192.97 | 16049.0 |
| 2024-06-03 05:30:00 | AAPL | Stock | 192.98 | 193.08 | 192.92 | 192.98 | 13335.0 |
| 2024-06-03 06:00:00 | AAPL | Stock | 193.0 | 193.08 | 192.97 | 193.02 | 3715.0 |
| 2024-06-03 06:30:00 | AAPL | Stock | 193.05 | 193.07 | 192.79 | 192.8 | 11530.0 |
| 2024-06-03 07:00:00 | AAPL | Stock | 192.85 | 193.0 | 192.71 | 192.76 | 20468.0 |
| 2024-06-03 07:30:00 | AAPL | Stock | 192.9 | 193.1 | 192.62 | 192.95 | 12594.0 |
| 2024-06-03 08:00:00 | AAPL | Stock | 192.8014 | 193.53 | 191.77 | 192.99 | 104574.0 |
| 2024-06-03 08:30:00 | AAPL | Stock | 192.93 | 192.99 | 192.82 | 192.82 | 71195.0 |
| 2024-06-03 09:00:00 | AAPL | Stock | 192.8 | 193.12 | 192.48 | 193.01 | 98514.0 |
| 2024-06-03 09:30:00 | AAPL | Stock | 193.01 | 194.56 | 192.52 | 194.11 | 7370601.0 |
| 2024-06-03 10:00:00 | AAPL | Stock | 194.13 | 194.99 | 194.0 | 194.835 | 4052448.0 |
| 2024-06-03 10:30:00 | AAPL | Stock | 194.835 | 194.92 | 193.91 | 193.95 | 3019596.0 |
| 2024-06-03 11:00:00 | AAPL | Stock | 193.94 | 194.43 | 193.58 | 194.13 | 2027482.0 |
| 2024-06-03 11:30:00 | AAPL | Stock | 194.12 | 194.39 | 193.66 | 193.93 | 1853683.0 |
| 2024-06-03 12:00:00 | AAPL | Stock | 193.9202 | 194.09 | 193.24 | 193.2894 | 2067638.0 |
| 2024-06-03 12:30:00 | AAPL | Stock | 193.28 | 193.37 | 192.92 | 193.255 | 1591191.0 |
| 2024-06-03 13:00:00 | AAPL | Stock | 193.255 | 193.8264 | 192.84 | 193.77 | 1896104.0 |
| 2024-06-03 13:30:00 | AAPL | Stock | 193.76 | 194.055 | 193.52 | 193.61 | 1398196.0 |
| 2024-06-03 14:00:00 | AAPL | Stock | 193.61 | 193.66 | 193.09 | 193.1 | 1503306.0 |
| 2024-06-03 14:30:00 | AAPL | Stock | 193.1 | 193.52 | 192.9101 | 193.0499 | 1529374.0 |
| 2024-06-03 15:00:00 | AAPL | Stock | 193.04 | 193.46 | 192.945 | 193.354 | 1566716.0 |
| 2024-06-03 15:30:00 | AAPL | Stock | 193.36 | 194.11 | 193.28 | 194.09 | 4148810.0 |
| 2024-06-03 16:00:00 | AAPL | Stock | 194.03 | 194.4 | 194.02 | 194.14 | 5744321.0 |
| 2024-06-03 16:30:00 | AAPL | Stock | 194.18 | 194.28 | 194.03 | 194.1 | 89117.0 |
| 2024-06-03 17:00:00 | AAPL | Stock | 194.1 | 194.15 | 194.06 | 194.13 | 11973.0 |
| 2024-06-03 17:30:00 | AAPL | Stock | 194.08 | 194.1153 | 194.03 | 194.1 | 24607.0 |
| 2024-06-03 18:00:00 | AAPL | Stock | 194.1 | 194.1298 | 194.03 | 194.12 | 11146.0 |
| 2024-06-03 18:30:00 | AAPL | Stock | 194.12 | 194.29 | 194.03 | 194.03 | 13920.0 |
| 2024-06-03 19:00:00 | AAPL | Stock | 194.03 | 194.11 | 194.03 | 194.04 | 5472.0 |
| 2024-06-03 19:30:00 | AAPL | Stock | 194.03 | 194.0999 | 194.03 | 194.08 | 10901.0 |
| 2024-06-03 04:00:00 | MSFT | Stock | 416.5 | 416.5 | 416.0 | 416.35 | 2765.0 |
| 2024-06-03 04:30:00 | MSFT | Stock | 416.33 | 416.39 | 415.7 | 416.34 | 6081.0 |
| 2024-06-03 05:00:00 | MSFT | Stock | 416.35 | 416.91 | 416.17 | 416.5 | 4809.0 |
| 2024-06-03 05:30:00 | MSFT | Stock | 416.29 | 416.29 | 415.24 | 416.06 | 2849.0 |
| 2024-06-03 06:00:00 | MSFT | Stock | 416.01 | 416.2 | 416.01 | 416.2 | 748.0 |
| 2024-06-03 06:30:00 | MSFT | Stock | 416.38 | 416.38 | 415.68 | 415.98 | 2796.0 |
| 2024-06-03 07:00:00 | MSFT | Stock | 415.85 | 416.43 | 415.67 | 415.85 | 5173.0 |
| 2024-06-03 07:30:00 | MSFT | Stock | 416.29 | 416.75 | 416.0 | 416.63 | 6571.0 |
| 2024-06-03 08:00:00 | MSFT | Stock | 416.3454 | 417.23 | 415.5416 | 416.85 | 46010.0 |
| 2024-06-03 08:30:00 | MSFT | Stock | 416.87 | 417.22 | 416.2 | 416.259 | 13368.0 |
| 2024-06-03 09:00:00 | MSFT | Stock | 416.35 | 417.35 | 415.33 | 415.65 | 34235.0 |
| 2024-06-03 09:30:00 | MSFT | Stock | 415.52 | 416.43 | 412.9492 | 413.18 | 1844796.0 |
| 2024-06-03 10:00:00 | MSFT | Stock | 413.48 | 414.5909 | 412.65 | 414.15 | 796855.0 |
| 2024-06-03 10:30:00 | MSFT | Stock | 414.16 | 415.04 | 412.22 | 412.57 | 676036.0 |
| 2024-06-03 11:00:00 | MSFT | Stock | 412.555 | 413.0 | 411.25 | 412.4625 | 639615.0 |
| 2024-06-03 11:30:00 | MSFT | Stock | 412.44 | 412.8 | 411.46 | 412.1 | 496487.0 |
| 2024-06-03 12:00:00 | MSFT | Stock | 412.13 | 412.4199 | 408.9234 | 409.09 | 560863.0 |
| 2024-06-03 12:30:00 | MSFT | Stock | 409.1 | 410.69 | 408.93 | 409.94 | 460895.0 |
> showing 50 of 96,269 rows — these rows as CSV