PREVIEW / stock_30min / 2024-05-08
file: by_date/stock_30min/2024/2024-05-08.parquet size: 2.0 MB rows: 97,388 symbols: 976
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-08 04:00:00 | AAPL | Stock | 182.3 | 183.75 | 182.3 | 183.55 | 44921.0 |
| 2024-05-08 04:30:00 | AAPL | Stock | 183.56 | 183.56 | 183.15 | 183.34 | 12248.0 |
| 2024-05-08 05:00:00 | AAPL | Stock | 183.24 | 183.24 | 183.06 | 183.23 | 6337.0 |
| 2024-05-08 05:30:00 | AAPL | Stock | 183.2 | 183.2 | 183.12 | 183.12 | 2399.0 |
| 2024-05-08 06:00:00 | AAPL | Stock | 182.98 | 183.46 | 182.86 | 183.46 | 11304.0 |
| 2024-05-08 06:30:00 | AAPL | Stock | 183.47 | 183.5 | 183.09 | 183.1 | 8885.0 |
| 2024-05-08 07:00:00 | AAPL | Stock | 183.0 | 183.0 | 182.6 | 182.6 | 12836.0 |
| 2024-05-08 07:30:00 | AAPL | Stock | 182.65 | 182.72 | 182.5 | 182.7 | 13388.0 |
| 2024-05-08 08:00:00 | AAPL | Stock | 182.96 | 183.0 | 181.98 | 182.38 | 71765.0 |
| 2024-05-08 08:30:00 | AAPL | Stock | 182.3 | 182.81 | 182.26 | 182.65 | 43268.0 |
| 2024-05-08 09:00:00 | AAPL | Stock | 182.7 | 182.95 | 182.08 | 182.9 | 68736.0 |
| 2024-05-08 09:30:00 | AAPL | Stock | 182.85 | 182.96 | 181.84 | 182.1 | 5255558.0 |
| 2024-05-08 10:00:00 | AAPL | Stock | 182.1 | 182.38 | 181.45 | 181.9 | 3058529.0 |
| 2024-05-08 10:30:00 | AAPL | Stock | 181.89 | 182.22 | 181.755 | 182.0485 | 2070526.0 |
| 2024-05-08 11:00:00 | AAPL | Stock | 182.042 | 182.38 | 181.975 | 182.285 | 1713461.0 |
| 2024-05-08 11:30:00 | AAPL | Stock | 182.29 | 182.33 | 181.85 | 182.25 | 1667879.0 |
| 2024-05-08 12:00:00 | AAPL | Stock | 182.2487 | 182.61 | 182.125 | 182.34 | 2196073.0 |
| 2024-05-08 12:30:00 | AAPL | Stock | 182.34 | 182.415 | 182.055 | 182.16 | 1182020.0 |
| 2024-05-08 13:00:00 | AAPL | Stock | 182.17 | 182.49 | 182.03 | 182.28 | 1358002.0 |
| 2024-05-08 13:30:00 | AAPL | Stock | 182.31 | 182.72 | 182.295 | 182.65 | 1752115.0 |
| 2024-05-08 14:00:00 | AAPL | Stock | 182.645 | 182.72 | 182.48 | 182.685 | 1635279.0 |
| 2024-05-08 14:30:00 | AAPL | Stock | 182.69 | 182.99 | 182.645 | 182.805 | 1706678.0 |
| 2024-05-08 15:00:00 | AAPL | Stock | 182.805 | 182.92 | 182.61 | 182.8901 | 1899226.0 |
| 2024-05-08 15:30:00 | AAPL | Stock | 182.895 | 183.07 | 182.68 | 182.75 | 4488288.0 |
| 2024-05-08 16:00:00 | AAPL | Stock | 182.74 | 182.86 | 182.03 | 182.4 | 6159299.0 |
| 2024-05-08 16:30:00 | AAPL | Stock | 182.4 | 182.74 | 182.4 | 182.4114 | 23823.0 |
| 2024-05-08 17:00:00 | AAPL | Stock | 182.41 | 182.74 | 182.41 | 182.74 | 9426.0 |
| 2024-05-08 17:30:00 | AAPL | Stock | 182.49 | 182.72 | 182.4119 | 182.57 | 25258.0 |
| 2024-05-08 18:00:00 | AAPL | Stock | 182.57 | 182.6 | 182.45 | 182.5507 | 4866.0 |
| 2024-05-08 18:30:00 | AAPL | Stock | 182.62 | 182.64 | 182.5504 | 182.64 | 2978.0 |
| 2024-05-08 19:00:00 | AAPL | Stock | 182.63 | 182.63 | 182.51 | 182.58 | 1938.0 |
| 2024-05-08 19:30:00 | AAPL | Stock | 182.6 | 182.6 | 182.4 | 182.46 | 6301.0 |
| 2024-05-08 04:00:00 | MSFT | Stock | 410.46 | 410.93 | 410.26 | 410.93 | 1126.0 |
| 2024-05-08 04:30:00 | MSFT | Stock | 410.72 | 410.72 | 410.6 | 410.6 | 486.0 |
| 2024-05-08 05:00:00 | MSFT | Stock | 410.75 | 410.75 | 410.75 | 410.75 | 252.0 |
| 2024-05-08 05:30:00 | MSFT | Stock | 410.79 | 411.0 | 410.79 | 411.0 | 723.0 |
| 2024-05-08 06:00:00 | MSFT | Stock | 410.93 | 410.93 | 410.02 | 410.79 | 625.0 |
| 2024-05-08 06:30:00 | MSFT | Stock | 410.44 | 410.51 | 410.44 | 410.51 | 986.0 |
| 2024-05-08 07:00:00 | MSFT | Stock | 410.37 | 410.52 | 410.09 | 410.09 | 3074.0 |
| 2024-05-08 07:30:00 | MSFT | Stock | 410.0 | 410.1 | 409.5 | 410.1 | 3795.0 |
| 2024-05-08 08:00:00 | MSFT | Stock | 410.58 | 410.69 | 408.88 | 408.88 | 25712.0 |
| 2024-05-08 08:30:00 | MSFT | Stock | 408.77 | 409.02 | 408.44 | 408.7 | 7788.0 |
| 2024-05-08 09:00:00 | MSFT | Stock | 408.65 | 408.7586 | 407.9 | 408.15 | 12667.0 |
| 2024-05-08 09:30:00 | MSFT | Stock | 408.17 | 409.15 | 406.7132 | 408.38 | 1113877.0 |
| 2024-05-08 10:00:00 | MSFT | Stock | 408.38 | 410.98 | 408.26 | 410.74 | 721187.0 |
| 2024-05-08 10:30:00 | MSFT | Stock | 410.75 | 412.03 | 410.3601 | 411.7241 | 435104.0 |
| 2024-05-08 11:00:00 | MSFT | Stock | 411.715 | 412.23 | 411.16 | 412.133 | 378767.0 |
| 2024-05-08 11:30:00 | MSFT | Stock | 412.1 | 412.2299 | 411.23 | 411.61 | 194402.0 |
| 2024-05-08 12:00:00 | MSFT | Stock | 411.61 | 412.1 | 411.41 | 411.41 | 212920.0 |
| 2024-05-08 12:30:00 | MSFT | Stock | 411.47 | 411.52 | 410.82 | 411.11 | 198355.0 |
> showing 50 of 97,388 rows — these rows as CSV