PREVIEW / stock_30min / 2024-08-19
file: by_date/stock_30min/2024/2024-08-19.parquet size: 2.1 MB rows: 100,641 symbols: 855
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-08-19 04:00:00 | AAPL | Stock | 226.44 | 226.44 | 225.2 | 225.8 | 9622.0 |
| 2024-08-19 04:30:00 | AAPL | Stock | 225.84 | 225.86 | 225.55 | 225.6 | 5824.0 |
| 2024-08-19 05:00:00 | AAPL | Stock | 225.6 | 225.69 | 225.3 | 225.57 | 4760.0 |
| 2024-08-19 05:30:00 | AAPL | Stock | 225.55 | 225.65 | 225.31 | 225.38 | 3590.0 |
| 2024-08-19 06:00:00 | AAPL | Stock | 225.43 | 225.46 | 225.25 | 225.44 | 7818.0 |
| 2024-08-19 06:30:00 | AAPL | Stock | 225.4 | 225.42 | 225.0 | 225.1 | 7648.0 |
| 2024-08-19 07:00:00 | AAPL | Stock | 225.19 | 225.81 | 225.19 | 225.7 | 12865.0 |
| 2024-08-19 07:30:00 | AAPL | Stock | 225.69 | 226.03 | 225.67 | 225.98 | 12748.0 |
| 2024-08-19 08:00:00 | AAPL | Stock | 225.35 | 226.44 | 224.89 | 226.16 | 71273.0 |
| 2024-08-19 08:30:00 | AAPL | Stock | 226.16 | 226.19 | 225.91 | 226.0936 | 28404.0 |
| 2024-08-19 09:00:00 | AAPL | Stock | 226.13 | 226.14 | 225.55 | 225.67 | 68350.0 |
| 2024-08-19 09:30:00 | AAPL | Stock | 225.67 | 225.74 | 224.116 | 224.4 | 3784882.0 |
| 2024-08-19 10:00:00 | AAPL | Stock | 224.4 | 224.52 | 223.04 | 224.16 | 2806147.0 |
| 2024-08-19 10:30:00 | AAPL | Stock | 224.16 | 224.35 | 223.49 | 224.21 | 1594741.0 |
| 2024-08-19 11:00:00 | AAPL | Stock | 224.23 | 224.73 | 223.93 | 224.4302 | 1525563.0 |
| 2024-08-19 11:30:00 | AAPL | Stock | 224.4276 | 224.65 | 223.75 | 223.8647 | 1117431.0 |
| 2024-08-19 12:00:00 | AAPL | Stock | 223.88 | 224.46 | 223.8 | 224.425 | 1044485.0 |
| 2024-08-19 12:30:00 | AAPL | Stock | 224.415 | 224.465 | 224.115 | 224.375 | 923013.0 |
| 2024-08-19 13:00:00 | AAPL | Stock | 224.36 | 224.43 | 223.75 | 224.025 | 1117286.0 |
| 2024-08-19 13:30:00 | AAPL | Stock | 224.025 | 224.35 | 223.8 | 224.315 | 1022666.0 |
| 2024-08-19 14:00:00 | AAPL | Stock | 224.31 | 224.66 | 224.28 | 224.645 | 970206.0 |
| 2024-08-19 14:30:00 | AAPL | Stock | 224.645 | 224.92 | 224.58 | 224.785 | 1089929.0 |
| 2024-08-19 15:00:00 | AAPL | Stock | 224.78 | 224.95 | 224.67 | 224.93 | 997166.0 |
| 2024-08-19 15:30:00 | AAPL | Stock | 224.925 | 225.99 | 224.89 | 225.9 | 3330718.0 |
| 2024-08-19 16:00:00 | AAPL | Stock | 225.9 | 226.0 | 225.65 | 225.99 | 6269616.0 |
| 2024-08-19 16:30:00 | AAPL | Stock | 225.97 | 225.99 | 225.812 | 225.84 | 23632.0 |
| 2024-08-19 17:00:00 | AAPL | Stock | 225.83 | 225.89 | 225.8 | 225.89 | 67452.0 |
| 2024-08-19 17:30:00 | AAPL | Stock | 225.86 | 225.89 | 225.71 | 225.8088 | 5898.0 |
| 2024-08-19 18:00:00 | AAPL | Stock | 225.81 | 226.01 | 225.81 | 225.88 | 23766.0 |
| 2024-08-19 18:30:00 | AAPL | Stock | 225.99 | 226.06 | 225.7989 | 225.9 | 11455.0 |
| 2024-08-19 19:00:00 | AAPL | Stock | 225.92 | 225.92 | 225.76 | 225.76 | 2666.0 |
| 2024-08-19 19:30:00 | AAPL | Stock | 225.72 | 225.97 | 225.6849 | 225.7 | 6265.0 |
| 2024-08-19 04:00:00 | MSFT | Stock | 418.01 | 418.01 | 417.47 | 417.5 | 3020.0 |
| 2024-08-19 04:30:00 | MSFT | Stock | 417.44 | 418.0 | 417.41 | 418.0 | 1439.0 |
| 2024-08-19 05:00:00 | MSFT | Stock | 418.07 | 418.07 | 417.82 | 417.82 | 566.0 |
| 2024-08-19 05:30:00 | MSFT | Stock | 418.57 | 418.57 | 418.17 | 418.55 | 900.0 |
| 2024-08-19 06:00:00 | MSFT | Stock | 418.71 | 418.71 | 418.41 | 418.47 | 1793.0 |
| 2024-08-19 06:30:00 | MSFT | Stock | 418.42 | 418.5 | 418.34 | 418.35 | 2785.0 |
| 2024-08-19 07:00:00 | MSFT | Stock | 418.45 | 418.9 | 418.45 | 418.9 | 1955.0 |
| 2024-08-19 07:30:00 | MSFT | Stock | 418.88 | 419.16 | 418.78 | 418.98 | 4230.0 |
| 2024-08-19 08:00:00 | MSFT | Stock | 418.07 | 419.4 | 417.88 | 419.25 | 15780.0 |
| 2024-08-19 08:30:00 | MSFT | Stock | 419.34 | 419.35 | 418.7049 | 418.8988 | 9110.0 |
| 2024-08-19 09:00:00 | MSFT | Stock | 418.96 | 419.2 | 418.84 | 419.02 | 4279.0 |
| 2024-08-19 09:30:00 | MSFT | Stock | 418.96 | 419.87 | 417.67 | 419.64 | 978719.0 |
| 2024-08-19 10:00:00 | MSFT | Stock | 419.61 | 419.75 | 416.46 | 417.81 | 548091.0 |
| 2024-08-19 10:30:00 | MSFT | Stock | 417.775 | 418.7 | 417.06 | 418.2 | 335529.0 |
| 2024-08-19 11:00:00 | MSFT | Stock | 418.18 | 418.53 | 417.53 | 417.965 | 307155.0 |
| 2024-08-19 11:30:00 | MSFT | Stock | 417.965 | 418.14 | 417.08 | 417.31 | 316494.0 |
| 2024-08-19 12:00:00 | MSFT | Stock | 417.33 | 418.18 | 417.314 | 418.125 | 230171.0 |
| 2024-08-19 12:30:00 | MSFT | Stock | 418.15 | 419.2 | 417.97 | 418.88 | 242102.0 |
> showing 50 of 100,641 rows — these rows as CSV