PREVIEW / stock_30min / 2024-11-15
file: by_date/stock_30min/2024/2024-11-15.parquet size: 2.2 MB rows: 103,071 symbols: 710
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-11-15 04:00:00 | AAPL | Stock | 226.9 | 226.9 | 226.0 | 226.12 | 19479.0 |
| 2024-11-15 04:30:00 | AAPL | Stock | 226.3 | 226.6 | 225.6 | 225.99 | 12133.0 |
| 2024-11-15 05:00:00 | AAPL | Stock | 226.05 | 226.05 | 225.78 | 225.91 | 2156.0 |
| 2024-11-15 05:30:00 | AAPL | Stock | 225.96 | 225.99 | 225.73 | 225.95 | 8140.0 |
| 2024-11-15 06:00:00 | AAPL | Stock | 225.99 | 226.48 | 225.98 | 226.46 | 8467.0 |
| 2024-11-15 06:30:00 | AAPL | Stock | 226.46 | 226.46 | 226.26 | 226.26 | 5386.0 |
| 2024-11-15 07:00:00 | AAPL | Stock | 226.41 | 226.66 | 226.25 | 226.59 | 20568.0 |
| 2024-11-15 07:30:00 | AAPL | Stock | 226.64 | 226.73 | 226.53 | 226.72 | 6932.0 |
| 2024-11-15 08:00:00 | AAPL | Stock | 226.4 | 228.22 | 225.799 | 226.28 | 48843.0 |
| 2024-11-15 08:30:00 | AAPL | Stock | 226.3 | 226.42 | 225.9006 | 226.0902 | 43775.0 |
| 2024-11-15 09:00:00 | AAPL | Stock | 226.05 | 226.45 | 225.1 | 225.7 | 155298.0 |
| 2024-11-15 09:30:00 | AAPL | Stock | 225.7 | 226.92 | 224.85 | 225.07 | 6837067.0 |
| 2024-11-15 10:00:00 | AAPL | Stock | 225.065 | 225.3 | 224.44 | 224.635 | 2029092.0 |
| 2024-11-15 10:30:00 | AAPL | Stock | 224.63 | 225.17 | 224.51 | 224.62 | 1435315.0 |
| 2024-11-15 11:00:00 | AAPL | Stock | 224.63 | 225.24 | 224.46 | 225.235 | 1298524.0 |
| 2024-11-15 11:30:00 | AAPL | Stock | 225.231 | 225.48 | 224.91 | 225.1 | 1006302.0 |
| 2024-11-15 12:00:00 | AAPL | Stock | 225.1 | 225.18 | 224.67 | 224.8724 | 927603.0 |
| 2024-11-15 12:30:00 | AAPL | Stock | 224.87 | 224.88 | 224.27 | 224.73 | 1001385.0 |
| 2024-11-15 13:00:00 | AAPL | Stock | 224.735 | 224.95 | 224.48 | 224.735 | 878912.0 |
| 2024-11-15 13:30:00 | AAPL | Stock | 224.72 | 224.85 | 224.45 | 224.665 | 756226.0 |
| 2024-11-15 14:00:00 | AAPL | Stock | 224.67 | 224.96 | 224.33 | 224.3999 | 784225.0 |
| 2024-11-15 14:30:00 | AAPL | Stock | 224.4 | 224.95 | 224.3 | 224.825 | 818917.0 |
| 2024-11-15 15:00:00 | AAPL | Stock | 224.825 | 225.31 | 224.8 | 224.81 | 1281130.0 |
| 2024-11-15 15:30:00 | AAPL | Stock | 224.81 | 225.25 | 224.5699 | 224.92 | 3006715.0 |
| 2024-11-15 16:00:00 | AAPL | Stock | 224.92 | 225.2005 | 224.92 | 225.01 | 9605430.0 |
| 2024-11-15 16:30:00 | AAPL | Stock | 225.01 | 225.05 | 225.0 | 225.01 | 78836.0 |
| 2024-11-15 17:00:00 | AAPL | Stock | 225.02 | 225.06 | 225.0 | 225.01 | 572964.0 |
| 2024-11-15 17:30:00 | AAPL | Stock | 225.03 | 225.1 | 225.01 | 225.1 | 5120.0 |
| 2024-11-15 18:00:00 | AAPL | Stock | 225.07 | 225.14 | 225.04 | 225.14 | 3579.0 |
| 2024-11-15 18:30:00 | AAPL | Stock | 225.2 | 225.2 | 225.03 | 225.03 | 3380.0 |
| 2024-11-15 19:00:00 | AAPL | Stock | 225.04 | 225.2 | 225.03 | 225.15 | 3724.0 |
| 2024-11-15 19:30:00 | AAPL | Stock | 225.2 | 225.26 | 225.17 | 225.26 | 3525.0 |
| 2024-11-15 04:00:00 | MSFT | Stock | 423.77 | 423.81 | 423.66 | 423.81 | 1619.0 |
| 2024-11-15 04:30:00 | MSFT | Stock | 423.74 | 423.77 | 423.57 | 423.57 | 1917.0 |
| 2024-11-15 05:00:00 | MSFT | Stock | 423.63 | 423.63 | 422.7 | 422.7 | 1556.0 |
| 2024-11-15 05:30:00 | MSFT | Stock | 422.9 | 423.0 | 422.9 | 423.0 | 883.0 |
| 2024-11-15 06:00:00 | MSFT | Stock | 422.94 | 424.03 | 422.94 | 423.83 | 3587.0 |
| 2024-11-15 06:30:00 | MSFT | Stock | 423.87 | 423.87 | 423.66 | 423.87 | 608.0 |
| 2024-11-15 07:00:00 | MSFT | Stock | 423.82 | 424.8 | 423.82 | 424.4 | 3717.0 |
| 2024-11-15 07:30:00 | MSFT | Stock | 424.44 | 424.65 | 424.22 | 424.65 | 4119.0 |
| 2024-11-15 08:00:00 | MSFT | Stock | 424.1986 | 426.89 | 423.2 | 424.3 | 12075.0 |
| 2024-11-15 08:30:00 | MSFT | Stock | 424.11 | 424.16 | 423.25 | 423.3901 | 11646.0 |
| 2024-11-15 09:00:00 | MSFT | Stock | 423.4104 | 423.6 | 419.57 | 419.57 | 99144.0 |
| 2024-11-15 09:30:00 | MSFT | Stock | 419.57 | 422.8 | 418.21 | 419.065 | 3217575.0 |
| 2024-11-15 10:00:00 | MSFT | Stock | 419.075 | 419.3 | 417.3101 | 417.6499 | 1021179.0 |
| 2024-11-15 10:30:00 | MSFT | Stock | 417.65 | 418.035 | 416.24 | 416.69 | 792225.0 |
| 2024-11-15 11:00:00 | MSFT | Stock | 416.65 | 416.91 | 416.16 | 416.8396 | 462317.0 |
| 2024-11-15 11:30:00 | MSFT | Stock | 416.8 | 417.175 | 414.39 | 414.85 | 588887.0 |
| 2024-11-15 12:00:00 | MSFT | Stock | 414.9 | 415.25 | 414.2259 | 415.18 | 480621.0 |
| 2024-11-15 12:30:00 | MSFT | Stock | 415.15 | 415.24 | 413.64 | 414.755 | 477908.0 |
> showing 50 of 103,071 rows — these rows as CSV