PREVIEW / stock_30min / 2024-05-10
file: by_date/stock_30min/2024/2024-05-10.parquet size: 2.0 MB rows: 96,867 symbols: 962
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-10 04:00:00 | AAPL | Stock | 184.57 | 184.85 | 184.56 | 184.8 | 9308.0 |
| 2024-05-10 04:30:00 | AAPL | Stock | 184.8 | 184.86 | 184.8 | 184.82 | 2663.0 |
| 2024-05-10 05:00:00 | AAPL | Stock | 184.81 | 184.82 | 184.7 | 184.75 | 3957.0 |
| 2024-05-10 05:30:00 | AAPL | Stock | 184.75 | 185.0 | 184.75 | 184.94 | 16939.0 |
| 2024-05-10 06:00:00 | AAPL | Stock | 184.95 | 184.95 | 184.9 | 184.9 | 200.0 |
| 2024-05-10 06:30:00 | AAPL | Stock | 184.9 | 184.93 | 184.8 | 184.8 | 1526.0 |
| 2024-05-10 07:00:00 | AAPL | Stock | 184.85 | 184.99 | 184.84 | 184.84 | 10021.0 |
| 2024-05-10 07:30:00 | AAPL | Stock | 184.88 | 184.91 | 184.75 | 184.79 | 2505.0 |
| 2024-05-10 08:00:00 | AAPL | Stock | 184.95 | 185.0 | 184.14 | 184.6881 | 50740.0 |
| 2024-05-10 08:30:00 | AAPL | Stock | 184.72 | 184.85 | 184.65 | 184.69 | 37562.0 |
| 2024-05-10 09:00:00 | AAPL | Stock | 184.69 | 184.98 | 184.68 | 184.91 | 63411.0 |
| 2024-05-10 09:30:00 | AAPL | Stock | 184.92 | 185.09 | 183.36 | 183.6 | 6460644.0 |
| 2024-05-10 10:00:00 | AAPL | Stock | 183.62 | 183.9799 | 183.15 | 183.21 | 3870365.0 |
| 2024-05-10 10:30:00 | AAPL | Stock | 183.21 | 183.3997 | 182.26 | 182.55 | 3501732.0 |
| 2024-05-10 11:00:00 | AAPL | Stock | 182.55 | 182.885 | 182.37 | 182.69 | 2748500.0 |
| 2024-05-10 11:30:00 | AAPL | Stock | 182.7 | 182.735 | 182.3828 | 182.575 | 1636857.0 |
| 2024-05-10 12:00:00 | AAPL | Stock | 182.575 | 182.61 | 182.245 | 182.4888 | 1480939.0 |
| 2024-05-10 12:30:00 | AAPL | Stock | 182.485 | 182.59 | 182.35 | 182.39 | 1326980.0 |
| 2024-05-10 13:00:00 | AAPL | Stock | 182.39 | 182.46 | 182.21 | 182.395 | 1165495.0 |
| 2024-05-10 13:30:00 | AAPL | Stock | 182.39 | 182.5199 | 182.13 | 182.475 | 1342923.0 |
| 2024-05-10 14:00:00 | AAPL | Stock | 182.475 | 182.86 | 182.35 | 182.74 | 2214417.0 |
| 2024-05-10 14:30:00 | AAPL | Stock | 182.73 | 182.93 | 182.57 | 182.9099 | 1619970.0 |
| 2024-05-10 15:00:00 | AAPL | Stock | 182.9078 | 182.97 | 182.675 | 182.94 | 1716954.0 |
| 2024-05-10 15:30:00 | AAPL | Stock | 182.94 | 183.2 | 182.79 | 182.99 | 4257870.0 |
| 2024-05-10 16:00:00 | AAPL | Stock | 182.99 | 183.05 | 182.69 | 182.73 | 7725424.0 |
| 2024-05-10 16:30:00 | AAPL | Stock | 182.73 | 182.73 | 182.58 | 182.58 | 15012.0 |
| 2024-05-10 17:00:00 | AAPL | Stock | 182.57 | 183.06 | 182.55 | 182.83 | 23983.0 |
| 2024-05-10 17:30:00 | AAPL | Stock | 182.8 | 183.05 | 182.75 | 182.75 | 37398.0 |
| 2024-05-10 18:00:00 | AAPL | Stock | 182.82 | 182.84 | 182.75 | 182.75 | 4774.0 |
| 2024-05-10 18:30:00 | AAPL | Stock | 182.75 | 182.82 | 182.75 | 182.82 | 2400.0 |
| 2024-05-10 19:00:00 | AAPL | Stock | 183.05 | 183.05 | 182.7 | 182.7 | 9745.0 |
| 2024-05-10 19:30:00 | AAPL | Stock | 182.7 | 182.7 | 182.5 | 182.5 | 10648.0 |
| 2024-05-10 04:00:00 | MSFT | Stock | 413.26 | 413.6 | 413.0 | 413.6 | 2574.0 |
| 2024-05-10 04:30:00 | MSFT | Stock | 413.5 | 413.66 | 413.5 | 413.66 | 638.0 |
| 2024-05-10 05:00:00 | MSFT | Stock | 413.8 | 414.4 | 413.8 | 414.38 | 1281.0 |
| 2024-05-10 05:30:00 | MSFT | Stock | 414.64 | 414.9 | 414.6 | 414.6 | 700.0 |
| 2024-05-10 06:30:00 | MSFT | Stock | 414.3 | 414.3 | 413.85 | 413.85 | 690.0 |
| 2024-05-10 07:00:00 | MSFT | Stock | 413.33 | 413.85 | 413.33 | 413.66 | 3220.0 |
| 2024-05-10 07:30:00 | MSFT | Stock | 413.76 | 414.34 | 413.76 | 414.2 | 3050.0 |
| 2024-05-10 08:00:00 | MSFT | Stock | 413.65 | 414.3 | 412.79 | 414.08 | 23207.0 |
| 2024-05-10 08:30:00 | MSFT | Stock | 414.0 | 414.0 | 412.85 | 412.85 | 8353.0 |
| 2024-05-10 09:00:00 | MSFT | Stock | 412.72 | 413.3499 | 412.7 | 412.91 | 5104.0 |
| 2024-05-10 09:30:00 | MSFT | Stock | 413.06 | 415.38 | 411.8 | 414.14 | 1206087.0 |
| 2024-05-10 10:00:00 | MSFT | Stock | 414.09 | 414.19 | 412.87 | 413.25 | 589640.0 |
| 2024-05-10 10:30:00 | MSFT | Stock | 413.31 | 414.0797 | 412.74 | 413.2145 | 512849.0 |
| 2024-05-10 11:00:00 | MSFT | Stock | 413.23 | 413.82 | 412.7214 | 413.805 | 316349.0 |
| 2024-05-10 11:30:00 | MSFT | Stock | 413.82 | 413.955 | 412.65 | 413.71 | 266889.0 |
| 2024-05-10 12:00:00 | MSFT | Stock | 413.72 | 414.1199 | 413.35 | 413.81 | 290092.0 |
| 2024-05-10 12:30:00 | MSFT | Stock | 413.81 | 414.64 | 413.74 | 414.4375 | 183660.0 |
| 2024-05-10 13:00:00 | MSFT | Stock | 414.4 | 414.58 | 413.98 | 414.01 | 168778.0 |
> showing 50 of 96,867 rows — these rows as CSV