PREVIEW / stock_30min / 2024-12-03
file: by_date/stock_30min/2024/2024-12-03.parquet size: 2.2 MB rows: 105,546 symbols: 692
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-12-03 04:00:00 | AAPL | Stock | 240.0 | 240.02 | 239.81 | 239.81 | 11463.0 |
| 2024-12-03 04:30:00 | AAPL | Stock | 239.8 | 239.99 | 239.8 | 239.98 | 3755.0 |
| 2024-12-03 05:00:00 | AAPL | Stock | 239.97 | 240.11 | 239.95 | 240.1 | 3739.0 |
| 2024-12-03 05:30:00 | AAPL | Stock | 239.93 | 239.95 | 239.81 | 239.81 | 2283.0 |
| 2024-12-03 06:00:00 | AAPL | Stock | 239.8 | 239.8 | 239.72 | 239.77 | 2757.0 |
| 2024-12-03 06:30:00 | AAPL | Stock | 239.84 | 240.13 | 239.84 | 240.13 | 4720.0 |
| 2024-12-03 07:00:00 | AAPL | Stock | 240.15 | 240.15 | 239.96 | 240.15 | 10349.0 |
| 2024-12-03 07:30:00 | AAPL | Stock | 240.15 | 240.19 | 240.1 | 240.15 | 4042.0 |
| 2024-12-03 08:00:00 | AAPL | Stock | 240.04 | 240.2 | 238.992 | 240.15 | 63716.0 |
| 2024-12-03 08:30:00 | AAPL | Stock | 240.18 | 240.35 | 240.14 | 240.1795 | 14429.0 |
| 2024-12-03 09:00:00 | AAPL | Stock | 240.15 | 240.17 | 239.59 | 239.9366 | 206281.0 |
| 2024-12-03 09:30:00 | AAPL | Stock | 239.82 | 240.92 | 238.9 | 240.89 | 3586091.0 |
| 2024-12-03 10:00:00 | AAPL | Stock | 240.86 | 241.3699 | 240.36 | 240.47 | 2525014.0 |
| 2024-12-03 10:30:00 | AAPL | Stock | 240.475 | 241.245 | 240.45 | 241.1905 | 1481169.0 |
| 2024-12-03 11:00:00 | AAPL | Stock | 241.19 | 241.34 | 240.81 | 241.33 | 1186080.0 |
| 2024-12-03 11:30:00 | AAPL | Stock | 241.33 | 241.54 | 240.982 | 241.41 | 1470946.0 |
| 2024-12-03 12:00:00 | AAPL | Stock | 241.41 | 241.635 | 241.21 | 241.265 | 1014722.0 |
| 2024-12-03 12:30:00 | AAPL | Stock | 241.265 | 241.7 | 241.14 | 241.6686 | 898104.0 |
| 2024-12-03 13:00:00 | AAPL | Stock | 241.6601 | 241.6979 | 241.32 | 241.42 | 784723.0 |
| 2024-12-03 13:30:00 | AAPL | Stock | 241.42 | 241.8255 | 241.34 | 241.725 | 971466.0 |
| 2024-12-03 14:00:00 | AAPL | Stock | 241.725 | 242.17 | 241.67 | 242.15 | 1709113.0 |
| 2024-12-03 14:30:00 | AAPL | Stock | 242.155 | 242.46 | 242.06 | 242.38 | 1329110.0 |
| 2024-12-03 15:00:00 | AAPL | Stock | 242.38 | 242.38 | 241.84 | 242.06 | 1219461.0 |
| 2024-12-03 15:30:00 | AAPL | Stock | 242.06 | 242.76 | 242.06 | 242.63 | 2934681.0 |
| 2024-12-03 16:00:00 | AAPL | Stock | 242.65 | 242.91 | 242.4 | 242.91 | 6767274.0 |
| 2024-12-03 16:30:00 | AAPL | Stock | 242.91 | 242.96 | 242.65 | 242.85 | 78656.0 |
| 2024-12-03 17:00:00 | AAPL | Stock | 242.88 | 242.88 | 242.7 | 242.75 | 7138.0 |
| 2024-12-03 17:30:00 | AAPL | Stock | 242.75 | 242.9 | 242.69 | 242.81 | 6588.0 |
| 2024-12-03 18:00:00 | AAPL | Stock | 242.8 | 242.8 | 242.65 | 242.76 | 5885.0 |
| 2024-12-03 18:30:00 | AAPL | Stock | 242.74 | 243.0 | 242.7103 | 242.8007 | 16007.0 |
| 2024-12-03 19:00:00 | AAPL | Stock | 242.8166 | 242.96 | 242.7344 | 242.8971 | 2403.0 |
| 2024-12-03 19:30:00 | AAPL | Stock | 242.76 | 243.0 | 242.73 | 243.0 | 14971.0 |
| 2024-12-03 04:00:00 | MSFT | Stock | 431.2 | 431.72 | 431.0 | 431.65 | 2959.0 |
| 2024-12-03 04:30:00 | MSFT | Stock | 431.5 | 431.5 | 431.31 | 431.31 | 540.0 |
| 2024-12-03 05:00:00 | MSFT | Stock | 431.02 | 431.02 | 431.02 | 431.02 | 220.0 |
| 2024-12-03 06:00:00 | MSFT | Stock | 431.0 | 431.0 | 430.24 | 430.26 | 1778.0 |
| 2024-12-03 06:30:00 | MSFT | Stock | 430.05 | 430.1 | 429.55 | 429.55 | 1095.0 |
| 2024-12-03 07:00:00 | MSFT | Stock | 430.38 | 430.45 | 429.8 | 429.92 | 1714.0 |
| 2024-12-03 07:30:00 | MSFT | Stock | 429.93 | 430.25 | 429.64 | 429.64 | 4845.0 |
| 2024-12-03 08:00:00 | MSFT | Stock | 430.4 | 431.2 | 429.35 | 429.42 | 21646.0 |
| 2024-12-03 08:30:00 | MSFT | Stock | 429.5 | 430.0 | 429.3192 | 429.35 | 7147.0 |
| 2024-12-03 09:00:00 | MSFT | Stock | 429.51 | 430.0 | 428.5 | 429.8803 | 13740.0 |
| 2024-12-03 09:30:00 | MSFT | Stock | 429.84 | 431.37 | 428.6 | 431.2161 | 1348183.0 |
| 2024-12-03 10:00:00 | MSFT | Stock | 431.275 | 432.47 | 429.54 | 429.66 | 734391.0 |
| 2024-12-03 10:30:00 | MSFT | Stock | 429.61 | 430.96 | 429.51 | 430.74 | 435328.0 |
| 2024-12-03 11:00:00 | MSFT | Stock | 430.715 | 431.9899 | 430.6901 | 431.395 | 397133.0 |
| 2024-12-03 11:30:00 | MSFT | Stock | 431.45 | 431.74 | 430.11 | 430.58 | 374706.0 |
| 2024-12-03 12:00:00 | MSFT | Stock | 430.53 | 430.88 | 429.92 | 430.09 | 286505.0 |
| 2024-12-03 12:30:00 | MSFT | Stock | 430.075 | 430.67 | 429.5806 | 430.38 | 319762.0 |
| 2024-12-03 13:00:00 | MSFT | Stock | 430.34 | 430.55 | 429.59 | 429.97 | 265391.0 |
> showing 50 of 105,546 rows — these rows as CSV