PREVIEW / stock_30min / 2024-02-09
file: by_date/stock_30min/2024/2024-02-09.parquet size: 2.1 MB rows: 98,638 symbols: 1,140
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-09 04:00:00 | AAPL | Stock | 188.5 | 188.5 | 188.3 | 188.3 | 1190.0 |
| 2024-02-09 04:30:00 | AAPL | Stock | 188.35 | 188.4 | 188.33 | 188.4 | 815.0 |
| 2024-02-09 05:00:00 | AAPL | Stock | 188.4 | 188.43 | 188.4 | 188.43 | 1723.0 |
| 2024-02-09 05:30:00 | AAPL | Stock | 188.48 | 188.52 | 188.46 | 188.46 | 1897.0 |
| 2024-02-09 06:00:00 | AAPL | Stock | 188.46 | 188.49 | 188.46 | 188.49 | 355.0 |
| 2024-02-09 06:30:00 | AAPL | Stock | 188.45 | 188.55 | 188.45 | 188.51 | 2223.0 |
| 2024-02-09 07:00:00 | AAPL | Stock | 188.54 | 188.68 | 188.5 | 188.55 | 10010.0 |
| 2024-02-09 07:30:00 | AAPL | Stock | 188.6 | 188.88 | 188.48 | 188.76 | 15225.0 |
| 2024-02-09 08:00:00 | AAPL | Stock | 188.54 | 188.93 | 188.12 | 188.76 | 62475.0 |
| 2024-02-09 08:30:00 | AAPL | Stock | 188.75 | 189.33 | 188.6 | 188.75 | 73671.0 |
| 2024-02-09 09:00:00 | AAPL | Stock | 188.76 | 188.89 | 188.45 | 188.73 | 62614.0 |
| 2024-02-09 09:30:00 | AAPL | Stock | 188.64 | 188.93 | 188.0 | 188.67 | 3395013.0 |
| 2024-02-09 10:00:00 | AAPL | Stock | 188.67 | 188.76 | 188.355 | 188.49 | 2382949.0 |
| 2024-02-09 10:30:00 | AAPL | Stock | 188.49 | 188.8385 | 188.4 | 188.6762 | 2204312.0 |
| 2024-02-09 11:00:00 | AAPL | Stock | 188.685 | 189.86 | 188.68 | 189.5858 | 3881384.0 |
| 2024-02-09 11:30:00 | AAPL | Stock | 189.5884 | 189.99 | 189.525 | 189.77 | 2871510.0 |
| 2024-02-09 12:00:00 | AAPL | Stock | 189.775 | 189.84 | 189.1001 | 189.34 | 2181622.0 |
| 2024-02-09 12:30:00 | AAPL | Stock | 189.335 | 189.68 | 189.15 | 189.6477 | 1912336.0 |
| 2024-02-09 13:00:00 | AAPL | Stock | 189.645 | 189.66 | 189.32 | 189.4701 | 1452254.0 |
| 2024-02-09 13:30:00 | AAPL | Stock | 189.48 | 189.53 | 189.04 | 189.08 | 1792024.0 |
| 2024-02-09 14:00:00 | AAPL | Stock | 189.08 | 189.08 | 188.7 | 188.85 | 1597017.0 |
| 2024-02-09 14:30:00 | AAPL | Stock | 188.8407 | 189.03 | 188.75 | 188.944 | 1371891.0 |
| 2024-02-09 15:00:00 | AAPL | Stock | 188.95 | 188.965 | 188.565 | 188.81 | 1900016.0 |
| 2024-02-09 15:30:00 | AAPL | Stock | 188.81 | 188.91 | 188.57 | 188.83 | 3678660.0 |
| 2024-02-09 16:00:00 | AAPL | Stock | 188.83 | 188.89 | 188.65 | 188.7 | 6868160.0 |
| 2024-02-09 16:30:00 | AAPL | Stock | 188.68 | 188.85 | 188.5 | 188.62 | 42214.0 |
| 2024-02-09 17:00:00 | AAPL | Stock | 188.61 | 188.71 | 188.59 | 188.66 | 21409.0 |
| 2024-02-09 17:30:00 | AAPL | Stock | 188.58 | 188.72 | 188.52 | 188.7 | 10169.0 |
| 2024-02-09 18:00:00 | AAPL | Stock | 188.6505 | 188.74 | 188.5597 | 188.6 | 15615.0 |
| 2024-02-09 18:30:00 | AAPL | Stock | 188.6 | 188.63 | 188.55 | 188.62 | 12564.0 |
| 2024-02-09 19:00:00 | AAPL | Stock | 188.62 | 188.6299 | 188.6 | 188.6299 | 6997.0 |
| 2024-02-09 19:30:00 | AAPL | Stock | 188.6 | 188.62 | 188.52 | 188.53 | 15545.0 |
| 2024-02-09 04:00:00 | MSFT | Stock | 415.3 | 415.3 | 414.7 | 414.75 | 1391.0 |
| 2024-02-09 04:30:00 | MSFT | Stock | 414.77 | 415.2 | 414.77 | 415.2 | 1116.0 |
| 2024-02-09 05:00:00 | MSFT | Stock | 415.3 | 415.5 | 415.3 | 415.5 | 571.0 |
| 2024-02-09 05:30:00 | MSFT | Stock | 415.74 | 415.75 | 415.74 | 415.74 | 755.0 |
| 2024-02-09 06:00:00 | MSFT | Stock | 415.86 | 415.86 | 415.86 | 415.86 | 100.0 |
| 2024-02-09 06:30:00 | MSFT | Stock | 415.96 | 416.4 | 415.96 | 416.25 | 3455.0 |
| 2024-02-09 07:00:00 | MSFT | Stock | 416.25 | 416.25 | 415.82 | 416.0 | 13044.0 |
| 2024-02-09 07:30:00 | MSFT | Stock | 415.94 | 416.14 | 415.78 | 416.04 | 6738.0 |
| 2024-02-09 08:00:00 | MSFT | Stock | 416.14 | 416.6 | 414.0 | 416.4001 | 29204.0 |
| 2024-02-09 08:30:00 | MSFT | Stock | 416.4 | 417.1 | 416.3 | 416.72 | 27019.0 |
| 2024-02-09 09:00:00 | MSFT | Stock | 416.7 | 417.4 | 415.07 | 415.47 | 74497.0 |
| 2024-02-09 09:30:00 | MSFT | Stock | 415.44 | 417.42 | 415.09 | 417.345 | 1847767.0 |
| 2024-02-09 10:00:00 | MSFT | Stock | 417.37 | 418.84 | 416.82 | 418.84 | 1318329.0 |
| 2024-02-09 10:30:00 | MSFT | Stock | 418.85 | 419.505 | 418.3 | 418.89 | 1125153.0 |
| 2024-02-09 11:00:00 | MSFT | Stock | 418.91 | 420.39 | 418.62 | 419.7827 | 1057902.0 |
| 2024-02-09 11:30:00 | MSFT | Stock | 419.8 | 420.39 | 419.4 | 419.5217 | 754944.0 |
| 2024-02-09 12:00:00 | MSFT | Stock | 419.53 | 419.53 | 418.89 | 419.4 | 644112.0 |
| 2024-02-09 12:30:00 | MSFT | Stock | 419.39 | 420.01 | 419.21 | 419.76 | 557634.0 |
> showing 50 of 98,638 rows — these rows as CSV