PREVIEW / stock_30min / 2024-06-25
file: by_date/stock_30min/2024/2024-06-25.parquet size: 2.0 MB rows: 97,851 symbols: 931
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-25 04:00:00 | AAPL | Stock | 208.92 | 209.5 | 208.76 | 209.37 | 9461.0 |
| 2024-06-25 04:30:00 | AAPL | Stock | 209.19 | 209.31 | 208.51 | 209.15 | 15900.0 |
| 2024-06-25 05:00:00 | AAPL | Stock | 208.91 | 209.38 | 208.6 | 209.37 | 16106.0 |
| 2024-06-25 05:30:00 | AAPL | Stock | 209.38 | 209.39 | 209.01 | 209.01 | 10272.0 |
| 2024-06-25 06:00:00 | AAPL | Stock | 209.0 | 209.69 | 209.0 | 209.69 | 15470.0 |
| 2024-06-25 06:30:00 | AAPL | Stock | 209.7 | 209.75 | 209.52 | 209.71 | 4919.0 |
| 2024-06-25 07:00:00 | AAPL | Stock | 209.8 | 209.85 | 209.55 | 209.7 | 17823.0 |
| 2024-06-25 07:30:00 | AAPL | Stock | 209.69 | 209.8 | 209.5 | 209.7 | 11261.0 |
| 2024-06-25 08:00:00 | AAPL | Stock | 209.7 | 210.03 | 208.8262 | 210.03 | 141475.0 |
| 2024-06-25 08:30:00 | AAPL | Stock | 209.99 | 210.0 | 209.57 | 209.7997 | 55253.0 |
| 2024-06-25 09:00:00 | AAPL | Stock | 209.71 | 210.16 | 208.95 | 209.1 | 249221.0 |
| 2024-06-25 09:30:00 | AAPL | Stock | 209.14 | 211.38 | 208.61 | 210.1096 | 7901042.0 |
| 2024-06-25 10:00:00 | AAPL | Stock | 210.11 | 210.72 | 209.32 | 209.7999 | 3251551.0 |
| 2024-06-25 10:30:00 | AAPL | Stock | 209.8 | 210.16 | 209.2001 | 209.3 | 2237380.0 |
| 2024-06-25 11:00:00 | AAPL | Stock | 209.29 | 210.26 | 209.29 | 209.71 | 2036632.0 |
| 2024-06-25 11:30:00 | AAPL | Stock | 209.72 | 210.48 | 209.71 | 210.33 | 1510762.0 |
| 2024-06-25 12:00:00 | AAPL | Stock | 210.32 | 210.485 | 209.83 | 210.0314 | 1221732.0 |
| 2024-06-25 12:30:00 | AAPL | Stock | 210.03 | 210.16 | 209.535 | 209.7166 | 1225022.0 |
| 2024-06-25 13:00:00 | AAPL | Stock | 209.715 | 210.19 | 209.38 | 210.115 | 1512788.0 |
| 2024-06-25 13:30:00 | AAPL | Stock | 210.115 | 210.39 | 209.94 | 210.28 | 1421529.0 |
| 2024-06-25 14:00:00 | AAPL | Stock | 210.2801 | 210.6701 | 210.04 | 210.66 | 1324293.0 |
| 2024-06-25 14:30:00 | AAPL | Stock | 210.6589 | 210.67 | 209.89 | 210.46 | 1561342.0 |
| 2024-06-25 15:00:00 | AAPL | Stock | 210.45 | 210.45 | 209.96 | 210.1401 | 1371996.0 |
| 2024-06-25 15:30:00 | AAPL | Stock | 210.14 | 210.14 | 208.82 | 209.07 | 4368160.0 |
| 2024-06-25 16:00:00 | AAPL | Stock | 209.07 | 209.69 | 208.9 | 209.1083 | 12351017.0 |
| 2024-06-25 16:30:00 | AAPL | Stock | 209.07 | 209.25 | 209.07 | 209.1608 | 680524.0 |
| 2024-06-25 17:00:00 | AAPL | Stock | 209.14 | 209.33 | 209.09 | 209.3 | 24743.0 |
| 2024-06-25 17:30:00 | AAPL | Stock | 209.3 | 209.3 | 209.21 | 209.26 | 8562.0 |
| 2024-06-25 18:00:00 | AAPL | Stock | 209.26 | 209.3 | 209.11 | 209.24 | 15281.0 |
| 2024-06-25 18:30:00 | AAPL | Stock | 209.23 | 209.23 | 209.07 | 209.19 | 8254.0 |
| 2024-06-25 19:00:00 | AAPL | Stock | 209.13 | 209.27 | 209.1 | 209.1101 | 12365.0 |
| 2024-06-25 19:30:00 | AAPL | Stock | 209.14 | 209.15 | 209.08 | 209.14 | 23787.0 |
| 2024-06-25 04:00:00 | MSFT | Stock | 446.06 | 447.29 | 446.06 | 447.29 | 1500.0 |
| 2024-06-25 04:30:00 | MSFT | Stock | 447.2 | 447.2 | 446.78 | 446.78 | 1006.0 |
| 2024-06-25 05:00:00 | MSFT | Stock | 447.0 | 447.01 | 446.21 | 446.21 | 3262.0 |
| 2024-06-25 05:30:00 | MSFT | Stock | 446.2 | 446.2 | 446.0 | 446.0 | 548.0 |
| 2024-06-25 06:00:00 | MSFT | Stock | 446.2 | 446.27 | 446.18 | 446.27 | 826.0 |
| 2024-06-25 06:30:00 | MSFT | Stock | 446.15 | 446.2 | 446.15 | 446.2 | 387.0 |
| 2024-06-25 07:00:00 | MSFT | Stock | 446.4 | 447.5 | 446.4 | 447.5 | 2426.0 |
| 2024-06-25 07:30:00 | MSFT | Stock | 447.15 | 447.24 | 447.0 | 447.1 | 1405.0 |
| 2024-06-25 08:00:00 | MSFT | Stock | 446.39 | 449.4 | 446.39 | 448.8888 | 21027.0 |
| 2024-06-25 08:30:00 | MSFT | Stock | 448.02 | 449.1 | 447.82 | 448.5793 | 13846.0 |
| 2024-06-25 09:00:00 | MSFT | Stock | 448.58 | 448.58 | 447.76 | 448.05 | 15866.0 |
| 2024-06-25 09:30:00 | MSFT | Stock | 448.06 | 449.0 | 446.75 | 447.645 | 1169694.0 |
| 2024-06-25 10:00:00 | MSFT | Stock | 447.645 | 449.4 | 446.93 | 448.92 | 635474.0 |
| 2024-06-25 10:30:00 | MSFT | Stock | 448.97 | 450.12 | 448.73 | 449.0 | 538219.0 |
| 2024-06-25 11:00:00 | MSFT | Stock | 449.035 | 449.76 | 448.54 | 449.51 | 372316.0 |
| 2024-06-25 11:30:00 | MSFT | Stock | 449.495 | 450.07 | 448.93 | 449.94 | 358437.0 |
| 2024-06-25 12:00:00 | MSFT | Stock | 449.91 | 450.3 | 449.12 | 449.36 | 329497.0 |
| 2024-06-25 12:30:00 | MSFT | Stock | 449.385 | 449.48 | 448.81 | 449.2 | 259975.0 |
> showing 50 of 97,851 rows — these rows as CSV