PREVIEW / stock_30min / 2024-05-31
file: by_date/stock_30min/2024/2024-05-31.parquet size: 2.0 MB rows: 98,601 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-31 04:00:00 | AAPL | Stock | 191.0 | 191.6 | 190.66 | 191.6 | 9183.0 |
| 2024-05-31 04:30:00 | AAPL | Stock | 191.51 | 191.51 | 191.15 | 191.15 | 1999.0 |
| 2024-05-31 05:00:00 | AAPL | Stock | 191.03 | 191.03 | 190.76 | 190.9 | 4630.0 |
| 2024-05-31 05:30:00 | AAPL | Stock | 190.95 | 190.98 | 190.9 | 190.98 | 4337.0 |
| 2024-05-31 06:00:00 | AAPL | Stock | 190.99 | 191.04 | 190.84 | 190.87 | 3163.0 |
| 2024-05-31 06:30:00 | AAPL | Stock | 190.94 | 190.95 | 190.53 | 190.68 | 13547.0 |
| 2024-05-31 07:00:00 | AAPL | Stock | 190.6 | 191.01 | 190.5 | 191.01 | 23199.0 |
| 2024-05-31 07:30:00 | AAPL | Stock | 191.0 | 191.2 | 191.0 | 191.2 | 15830.0 |
| 2024-05-31 08:00:00 | AAPL | Stock | 190.84 | 191.6894 | 190.5 | 191.54 | 67080.0 |
| 2024-05-31 08:30:00 | AAPL | Stock | 191.6 | 192.0987 | 191.43 | 191.65 | 165976.0 |
| 2024-05-31 09:00:00 | AAPL | Stock | 191.78 | 191.84 | 190.99 | 191.64 | 128224.0 |
| 2024-05-31 09:30:00 | AAPL | Stock | 191.36 | 192.57 | 191.29 | 191.71 | 5041231.0 |
| 2024-05-31 10:00:00 | AAPL | Stock | 191.71 | 192.4278 | 191.25 | 191.69 | 3123799.0 |
| 2024-05-31 10:30:00 | AAPL | Stock | 191.69 | 191.97 | 191.06 | 191.2001 | 2814655.0 |
| 2024-05-31 11:00:00 | AAPL | Stock | 191.205 | 191.3 | 190.1 | 190.41 | 2759594.0 |
| 2024-05-31 11:30:00 | AAPL | Stock | 190.39 | 190.7074 | 190.08 | 190.335 | 1470938.0 |
| 2024-05-31 12:00:00 | AAPL | Stock | 190.33 | 190.3965 | 189.91 | 190.1972 | 1573161.0 |
| 2024-05-31 12:30:00 | AAPL | Stock | 190.2 | 190.25 | 189.91 | 190.04 | 1208342.0 |
| 2024-05-31 13:00:00 | AAPL | Stock | 190.04 | 190.59 | 189.97 | 190.56 | 1223821.0 |
| 2024-05-31 13:30:00 | AAPL | Stock | 190.57 | 190.79 | 190.468 | 190.7701 | 1051880.0 |
| 2024-05-31 14:00:00 | AAPL | Stock | 190.78 | 190.82 | 190.38 | 190.555 | 1130096.0 |
| 2024-05-31 14:30:00 | AAPL | Stock | 190.55 | 190.79 | 190.33 | 190.76 | 1348884.0 |
| 2024-05-31 15:00:00 | AAPL | Stock | 190.763 | 191.2698 | 190.64 | 191.03 | 2764413.0 |
| 2024-05-31 15:30:00 | AAPL | Stock | 191.02 | 192.5 | 190.9 | 192.47 | 8420622.0 |
| 2024-05-31 16:00:00 | AAPL | Stock | 192.42 | 192.57 | 191.1 | 192.33 | 26294853.0 |
| 2024-05-31 16:30:00 | AAPL | Stock | 192.33 | 192.63 | 192.25 | 192.34 | 69701.0 |
| 2024-05-31 17:00:00 | AAPL | Stock | 192.35 | 192.5 | 192.25 | 192.4 | 71899.0 |
| 2024-05-31 17:30:00 | AAPL | Stock | 192.4 | 192.5 | 192.3152 | 192.46 | 19175.0 |
| 2024-05-31 18:00:00 | AAPL | Stock | 192.4435 | 192.49 | 192.35 | 192.4 | 10817.0 |
| 2024-05-31 18:30:00 | AAPL | Stock | 192.44 | 192.49 | 192.25 | 192.47 | 18105.0 |
| 2024-05-31 19:00:00 | AAPL | Stock | 192.4509 | 192.48 | 192.42 | 192.47 | 1478.0 |
| 2024-05-31 19:30:00 | AAPL | Stock | 192.43 | 192.49 | 192.43 | 192.48 | 9798.0 |
| 2024-05-31 04:00:00 | MSFT | Stock | 413.45 | 416.0 | 413.45 | 415.79 | 3676.0 |
| 2024-05-31 04:30:00 | MSFT | Stock | 415.5 | 415.99 | 415.5 | 415.5 | 3077.0 |
| 2024-05-31 05:00:00 | MSFT | Stock | 415.12 | 415.73 | 414.95 | 415.71 | 2992.0 |
| 2024-05-31 05:30:00 | MSFT | Stock | 416.0 | 416.17 | 415.6 | 415.6 | 3501.0 |
| 2024-05-31 06:00:00 | MSFT | Stock | 415.5 | 415.5 | 414.93 | 414.93 | 745.0 |
| 2024-05-31 06:30:00 | MSFT | Stock | 414.8 | 415.36 | 414.0 | 414.01 | 5053.0 |
| 2024-05-31 07:00:00 | MSFT | Stock | 414.48 | 415.0 | 414.1 | 415.0 | 5096.0 |
| 2024-05-31 07:30:00 | MSFT | Stock | 415.2 | 415.95 | 415.2 | 415.95 | 13555.0 |
| 2024-05-31 08:00:00 | MSFT | Stock | 414.595 | 416.63 | 412.96 | 416.3 | 25478.0 |
| 2024-05-31 08:30:00 | MSFT | Stock | 416.44 | 418.11 | 416.44 | 417.14 | 54638.0 |
| 2024-05-31 09:00:00 | MSFT | Stock | 417.2 | 417.67 | 416.45 | 417.0 | 29719.0 |
| 2024-05-31 09:30:00 | MSFT | Stock | 416.75 | 416.75 | 411.29 | 412.258 | 2018761.0 |
| 2024-05-31 10:00:00 | MSFT | Stock | 412.25 | 412.73 | 410.05 | 410.15 | 3185664.0 |
| 2024-05-31 10:30:00 | MSFT | Stock | 410.155 | 410.23 | 406.06 | 407.66 | 1735197.0 |
| 2024-05-31 11:00:00 | MSFT | Stock | 407.66 | 407.8937 | 406.5101 | 406.83 | 792309.0 |
| 2024-05-31 11:30:00 | MSFT | Stock | 406.84 | 407.23 | 406.3 | 406.44 | 671102.0 |
| 2024-05-31 12:00:00 | MSFT | Stock | 406.46 | 406.64 | 404.51 | 405.46 | 1273349.0 |
| 2024-05-31 12:30:00 | MSFT | Stock | 405.45 | 406.15 | 404.87 | 405.5064 | 637543.0 |
> showing 50 of 98,601 rows — these rows as CSV