PREVIEW / stock_30min / 2024-05-14
file: by_date/stock_30min/2024/2024-05-14.parquet size: 2.1 MB rows: 101,015 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-14 04:00:00 | AAPL | Stock | 186.5 | 186.87 | 186.46 | 186.79 | 10783.0 |
| 2024-05-14 04:30:00 | AAPL | Stock | 186.77 | 187.0 | 186.74 | 187.0 | 9045.0 |
| 2024-05-14 05:00:00 | AAPL | Stock | 187.0 | 187.12 | 186.8 | 186.8 | 12627.0 |
| 2024-05-14 05:30:00 | AAPL | Stock | 186.86 | 187.04 | 186.86 | 187.02 | 17967.0 |
| 2024-05-14 06:00:00 | AAPL | Stock | 187.0 | 187.1 | 187.0 | 187.07 | 23915.0 |
| 2024-05-14 06:30:00 | AAPL | Stock | 187.07 | 187.07 | 187.0 | 187.04 | 5064.0 |
| 2024-05-14 07:00:00 | AAPL | Stock | 187.01 | 187.01 | 186.5 | 186.6 | 19511.0 |
| 2024-05-14 07:30:00 | AAPL | Stock | 186.41 | 186.68 | 186.4 | 186.5 | 12314.0 |
| 2024-05-14 08:00:00 | AAPL | Stock | 186.9 | 187.5 | 186.2 | 186.22 | 80181.0 |
| 2024-05-14 08:30:00 | AAPL | Stock | 186.2 | 186.49 | 185.4 | 186.32 | 172436.0 |
| 2024-05-14 09:00:00 | AAPL | Stock | 186.34 | 187.6 | 186.07 | 187.59 | 240084.0 |
| 2024-05-14 09:30:00 | AAPL | Stock | 187.59 | 188.3 | 186.92 | 187.01 | 6627314.0 |
| 2024-05-14 10:00:00 | AAPL | Stock | 187.02 | 187.1487 | 186.55 | 187.01 | 3037839.0 |
| 2024-05-14 10:30:00 | AAPL | Stock | 187.01 | 187.07 | 186.29 | 186.99 | 2174802.0 |
| 2024-05-14 11:00:00 | AAPL | Stock | 187.0 | 187.21 | 186.79 | 186.985 | 1730700.0 |
| 2024-05-14 11:30:00 | AAPL | Stock | 186.985 | 187.005 | 186.51 | 186.91 | 1661748.0 |
| 2024-05-14 12:00:00 | AAPL | Stock | 186.92 | 186.955 | 186.73 | 186.8 | 1137836.0 |
| 2024-05-14 12:30:00 | AAPL | Stock | 186.8 | 186.95 | 186.6 | 186.779 | 1150929.0 |
| 2024-05-14 13:00:00 | AAPL | Stock | 186.78 | 186.9 | 186.451 | 186.53 | 1302741.0 |
| 2024-05-14 13:30:00 | AAPL | Stock | 186.535 | 187.05 | 186.485 | 186.94 | 1375399.0 |
| 2024-05-14 14:00:00 | AAPL | Stock | 186.935 | 187.37 | 186.885 | 187.3294 | 1412260.0 |
| 2024-05-14 14:30:00 | AAPL | Stock | 187.325 | 187.65 | 187.2 | 187.53 | 1634284.0 |
| 2024-05-14 15:00:00 | AAPL | Stock | 187.5208 | 187.815 | 187.51 | 187.745 | 2083273.0 |
| 2024-05-14 15:30:00 | AAPL | Stock | 187.75 | 187.91 | 187.16 | 187.39 | 4285907.0 |
| 2024-05-14 16:00:00 | AAPL | Stock | 187.32 | 187.54 | 187.32 | 187.4842 | 6620212.0 |
| 2024-05-14 16:30:00 | AAPL | Stock | 187.53 | 187.56 | 187.4 | 187.55 | 36616.0 |
| 2024-05-14 17:00:00 | AAPL | Stock | 187.55 | 187.57 | 187.44 | 187.44 | 6030.0 |
| 2024-05-14 17:30:00 | AAPL | Stock | 187.44 | 187.57 | 187.44 | 187.55 | 6244.0 |
| 2024-05-14 18:00:00 | AAPL | Stock | 187.58 | 187.76 | 187.43 | 187.7 | 34634.0 |
| 2024-05-14 18:30:00 | AAPL | Stock | 187.7 | 187.7 | 187.49 | 187.62 | 10821.0 |
| 2024-05-14 19:00:00 | AAPL | Stock | 187.6 | 187.8 | 187.52 | 187.52 | 11368.0 |
| 2024-05-14 19:30:00 | AAPL | Stock | 187.51 | 187.6 | 187.45 | 187.45 | 10615.0 |
| 2024-05-14 04:00:00 | MSFT | Stock | 414.1 | 414.34 | 413.83 | 414.29 | 1483.0 |
| 2024-05-14 04:30:00 | MSFT | Stock | 414.77 | 415.06 | 414.77 | 415.0 | 550.0 |
| 2024-05-14 05:00:00 | MSFT | Stock | 414.51 | 414.51 | 414.51 | 414.51 | 379.0 |
| 2024-05-14 05:30:00 | MSFT | Stock | 414.26 | 414.26 | 414.25 | 414.25 | 200.0 |
| 2024-05-14 06:00:00 | MSFT | Stock | 414.16 | 414.35 | 414.16 | 414.23 | 650.0 |
| 2024-05-14 06:30:00 | MSFT | Stock | 414.27 | 414.27 | 414.0 | 414.0 | 2352.0 |
| 2024-05-14 07:00:00 | MSFT | Stock | 414.01 | 414.1 | 413.5 | 413.5 | 2301.0 |
| 2024-05-14 07:30:00 | MSFT | Stock | 413.25 | 413.5 | 413.12 | 413.12 | 3803.0 |
| 2024-05-14 08:00:00 | MSFT | Stock | 413.3597 | 414.32 | 412.41 | 413.5 | 7293.0 |
| 2024-05-14 08:30:00 | MSFT | Stock | 413.0 | 413.2471 | 411.35 | 411.96 | 23789.0 |
| 2024-05-14 09:00:00 | MSFT | Stock | 411.85 | 412.3286 | 411.2827 | 411.9 | 31956.0 |
| 2024-05-14 09:30:00 | MSFT | Stock | 412.02 | 413.89 | 411.55 | 412.1 | 1085905.0 |
| 2024-05-14 10:00:00 | MSFT | Stock | 412.14 | 415.55 | 411.92 | 415.45 | 902679.0 |
| 2024-05-14 10:30:00 | MSFT | Stock | 415.51 | 415.56 | 413.7806 | 414.62 | 465620.0 |
| 2024-05-14 11:00:00 | MSFT | Stock | 414.67 | 415.23 | 414.22 | 414.56 | 298229.0 |
| 2024-05-14 11:30:00 | MSFT | Stock | 414.54 | 414.54 | 412.905 | 413.005 | 308619.0 |
| 2024-05-14 12:00:00 | MSFT | Stock | 412.965 | 413.32 | 412.16 | 412.22 | 313632.0 |
| 2024-05-14 12:30:00 | MSFT | Stock | 412.2 | 412.785 | 411.9303 | 412.74 | 268817.0 |
> showing 50 of 101,015 rows — these rows as CSV