PREVIEW / stock_30min / 2024-02-26
file: by_date/stock_30min/2024/2024-02-26.parquet size: 2.1 MB rows: 101,181 symbols: 1,153
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-02-26 04:00:00 | AAPL | Stock | 182.27 | 182.3 | 181.99 | 182.1 | 3610.0 |
| 2024-02-26 04:30:00 | AAPL | Stock | 182.14 | 182.21 | 182.14 | 182.2 | 1232.0 |
| 2024-02-26 05:00:00 | AAPL | Stock | 182.11 | 182.16 | 182.1 | 182.16 | 851.0 |
| 2024-02-26 05:30:00 | AAPL | Stock | 182.12 | 182.24 | 182.12 | 182.18 | 2923.0 |
| 2024-02-26 06:00:00 | AAPL | Stock | 182.14 | 182.18 | 182.08 | 182.15 | 2420.0 |
| 2024-02-26 06:30:00 | AAPL | Stock | 182.15 | 182.15 | 181.82 | 181.92 | 4025.0 |
| 2024-02-26 07:00:00 | AAPL | Stock | 181.9 | 182.17 | 181.9 | 182.07 | 15021.0 |
| 2024-02-26 07:30:00 | AAPL | Stock | 182.12 | 182.14 | 182.04 | 182.06 | 8444.0 |
| 2024-02-26 08:00:00 | AAPL | Stock | 182.15 | 182.466 | 181.76 | 182.32 | 50353.0 |
| 2024-02-26 08:30:00 | AAPL | Stock | 182.31 | 182.5 | 182.21 | 182.44 | 35378.0 |
| 2024-02-26 09:00:00 | AAPL | Stock | 182.49 | 182.49 | 182.02 | 182.27 | 46891.0 |
| 2024-02-26 09:30:00 | AAPL | Stock | 182.33 | 182.76 | 181.1484 | 181.515 | 4639470.0 |
| 2024-02-26 10:00:00 | AAPL | Stock | 181.52 | 181.845 | 181.2 | 181.6022 | 2433746.0 |
| 2024-02-26 10:30:00 | AAPL | Stock | 181.61 | 181.85 | 181.24 | 181.24 | 1960959.0 |
| 2024-02-26 11:00:00 | AAPL | Stock | 181.235 | 181.27 | 180.74 | 180.94 | 2611528.0 |
| 2024-02-26 11:30:00 | AAPL | Stock | 180.94 | 181.26 | 180.925 | 181.205 | 1595165.0 |
| 2024-02-26 12:00:00 | AAPL | Stock | 181.205 | 181.21 | 180.835 | 180.97 | 1388275.0 |
| 2024-02-26 12:30:00 | AAPL | Stock | 180.9731 | 181.005 | 180.65 | 180.805 | 1356119.0 |
| 2024-02-26 13:00:00 | AAPL | Stock | 180.805 | 181.33 | 180.71 | 180.985 | 1714755.0 |
| 2024-02-26 13:30:00 | AAPL | Stock | 180.99 | 181.39 | 180.85 | 181.3899 | 1478421.0 |
| 2024-02-26 14:00:00 | AAPL | Stock | 181.3854 | 181.73 | 181.335 | 181.712 | 1739756.0 |
| 2024-02-26 14:30:00 | AAPL | Stock | 181.71 | 181.78 | 181.48 | 181.49 | 1168581.0 |
| 2024-02-26 15:00:00 | AAPL | Stock | 181.5 | 181.61 | 181.26 | 181.38 | 1583070.0 |
| 2024-02-26 15:30:00 | AAPL | Stock | 181.38 | 181.47 | 181.075 | 181.14 | 3301913.0 |
| 2024-02-26 16:00:00 | AAPL | Stock | 181.16 | 181.19 | 181.02 | 181.08 | 6340124.0 |
| 2024-02-26 16:30:00 | AAPL | Stock | 181.1 | 181.16 | 181.04 | 181.07 | 55579.0 |
| 2024-02-26 17:00:00 | AAPL | Stock | 181.09 | 181.14 | 181.05 | 181.0604 | 6490.0 |
| 2024-02-26 17:30:00 | AAPL | Stock | 181.1 | 181.14 | 181.06 | 181.06 | 3485.0 |
| 2024-02-26 18:00:00 | AAPL | Stock | 181.05 | 181.12 | 181.02 | 181.09 | 6138.0 |
| 2024-02-26 18:30:00 | AAPL | Stock | 181.1 | 181.16 | 181.04 | 181.04 | 8853.0 |
| 2024-02-26 19:00:00 | AAPL | Stock | 181.13 | 181.13 | 181.0 | 181.05 | 9512.0 |
| 2024-02-26 19:30:00 | AAPL | Stock | 181.05 | 181.1 | 181.0 | 181.03 | 10268.0 |
| 2024-02-26 04:00:00 | MSFT | Stock | 410.44 | 410.46 | 410.44 | 410.46 | 711.0 |
| 2024-02-26 04:30:00 | MSFT | Stock | 410.46 | 410.46 | 409.95 | 409.95 | 1555.0 |
| 2024-02-26 05:00:00 | MSFT | Stock | 410.19 | 410.19 | 410.1 | 410.1 | 274.0 |
| 2024-02-26 05:30:00 | MSFT | Stock | 410.49 | 410.63 | 410.49 | 410.56 | 1257.0 |
| 2024-02-26 06:00:00 | MSFT | Stock | 410.82 | 411.51 | 410.77 | 411.5 | 3997.0 |
| 2024-02-26 06:30:00 | MSFT | Stock | 411.01 | 411.28 | 410.83 | 410.83 | 1251.0 |
| 2024-02-26 07:00:00 | MSFT | Stock | 410.81 | 410.99 | 410.5 | 410.81 | 4806.0 |
| 2024-02-26 07:30:00 | MSFT | Stock | 410.99 | 410.99 | 410.3 | 410.3 | 4952.0 |
| 2024-02-26 08:00:00 | MSFT | Stock | 410.6 | 411.04 | 409.75 | 410.6 | 15980.0 |
| 2024-02-26 08:30:00 | MSFT | Stock | 410.7698 | 411.45 | 410.7698 | 411.3 | 10079.0 |
| 2024-02-26 09:00:00 | MSFT | Stock | 411.2271 | 411.41 | 410.63 | 411.4 | 10333.0 |
| 2024-02-26 09:30:00 | MSFT | Stock | 411.4 | 412.16 | 408.62 | 408.68 | 1551689.0 |
| 2024-02-26 10:00:00 | MSFT | Stock | 408.71 | 410.3105 | 408.3 | 409.42 | 841413.0 |
| 2024-02-26 10:30:00 | MSFT | Stock | 409.42 | 410.1 | 409.11 | 409.45 | 489723.0 |
| 2024-02-26 11:00:00 | MSFT | Stock | 409.465 | 409.73 | 408.01 | 408.39 | 489511.0 |
| 2024-02-26 11:30:00 | MSFT | Stock | 408.405 | 409.27 | 408.29 | 409.03 | 444214.0 |
| 2024-02-26 12:00:00 | MSFT | Stock | 409.02 | 409.6 | 408.49 | 409.3 | 312225.0 |
| 2024-02-26 12:30:00 | MSFT | Stock | 409.29 | 409.54 | 408.58 | 408.7227 | 309310.0 |
> showing 50 of 101,181 rows — these rows as CSV