PREVIEW / stock_30min / 2005-03-28
file: by_date/stock_30min/2005/2005-03-28.parquet size: 814 KB rows: 43,740 symbols: 1,946
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-28 08:00:00 | AAPL | Stock | 1.5196 | 1.5286 | 1.5196 | 1.5257 | 342972.0 |
| 2005-03-28 08:30:00 | AAPL | Stock | 1.525 | 1.5321 | 1.525 | 1.5321 | 1003856.0 |
| 2005-03-28 09:00:00 | AAPL | Stock | 1.5311 | 1.5329 | 1.5214 | 1.5279 | 737492.0 |
| 2005-03-28 09:30:00 | AAPL | Stock | 1.5268 | 1.5343 | 1.5196 | 1.5243 | 38878308.0 |
| 2005-03-28 10:00:00 | AAPL | Stock | 1.5246 | 1.5289 | 1.5211 | 1.5279 | 28769384.0 |
| 2005-03-28 10:30:00 | AAPL | Stock | 1.5282 | 1.5332 | 1.525 | 1.5289 | 26600476.0 |
| 2005-03-28 11:00:00 | AAPL | Stock | 1.5289 | 1.534 | 1.5268 | 1.53 | 23326912.0 |
| 2005-03-28 11:30:00 | AAPL | Stock | 1.53 | 1.5311 | 1.525 | 1.5279 | 15467788.0 |
| 2005-03-28 12:00:00 | AAPL | Stock | 1.5275 | 1.5286 | 1.5236 | 1.5264 | 11694060.0 |
| 2005-03-28 12:30:00 | AAPL | Stock | 1.5264 | 1.5282 | 1.525 | 1.5275 | 8120504.0 |
| 2005-03-28 13:00:00 | AAPL | Stock | 1.5271 | 1.5336 | 1.5268 | 1.5289 | 14835408.0 |
| 2005-03-28 13:30:00 | AAPL | Stock | 1.5286 | 1.5329 | 1.5286 | 1.5286 | 11484620.0 |
| 2005-03-28 14:00:00 | AAPL | Stock | 1.5286 | 1.5289 | 1.5246 | 1.5275 | 14913864.0 |
| 2005-03-28 14:30:00 | AAPL | Stock | 1.5271 | 1.5307 | 1.5254 | 1.5279 | 14726152.0 |
| 2005-03-28 15:00:00 | AAPL | Stock | 1.5279 | 1.5296 | 1.525 | 1.5261 | 11158392.0 |
| 2005-03-28 15:30:00 | AAPL | Stock | 1.5261 | 1.5286 | 1.5168 | 1.5196 | 39150580.0 |
| 2005-03-28 16:00:00 | AAPL | Stock | 1.5193 | 1.5286 | 1.5186 | 1.52 | 1724520.0 |
| 2005-03-28 16:30:00 | AAPL | Stock | 1.5214 | 1.5214 | 1.5189 | 1.5214 | 365092.0 |
| 2005-03-28 17:00:00 | AAPL | Stock | 1.5214 | 1.5214 | 1.5207 | 1.5214 | 28000.0 |
| 2005-03-28 17:30:00 | AAPL | Stock | 1.5214 | 1.5232 | 1.5214 | 1.5232 | 75600.0 |
| 2005-03-28 18:00:00 | AAPL | Stock | 1.5218 | 1.525 | 1.5214 | 1.525 | 47600.0 |
| 2005-03-28 08:00:00 | MSFT | Stock | 24.46 | 24.46 | 24.38 | 24.38 | 13605.0 |
| 2005-03-28 08:30:00 | MSFT | Stock | 24.38 | 24.42 | 24.35 | 24.39 | 37600.0 |
| 2005-03-28 09:00:00 | MSFT | Stock | 24.37 | 24.41 | 24.35 | 24.41 | 142234.0 |
| 2005-03-28 09:30:00 | MSFT | Stock | 24.4 | 24.47 | 24.34 | 24.4 | 6023204.0 |
| 2005-03-28 10:00:00 | MSFT | Stock | 24.41 | 24.43 | 24.36 | 24.39 | 4892618.0 |
| 2005-03-28 10:30:00 | MSFT | Stock | 24.39 | 24.416 | 24.34 | 24.34 | 3766535.0 |
| 2005-03-28 11:00:00 | MSFT | Stock | 24.35 | 24.41 | 24.28 | 24.36 | 2856357.0 |
| 2005-03-28 11:30:00 | MSFT | Stock | 24.37 | 24.4 | 24.32 | 24.35 | 2103124.0 |
| 2005-03-28 12:00:00 | MSFT | Stock | 24.36 | 24.37 | 24.31 | 24.35 | 3214620.0 |
| 2005-03-28 12:30:00 | MSFT | Stock | 24.35 | 24.36 | 24.32 | 24.34 | 787822.0 |
| 2005-03-28 13:00:00 | MSFT | Stock | 24.332 | 24.389 | 24.32 | 24.36 | 3628110.0 |
| 2005-03-28 13:30:00 | MSFT | Stock | 24.36 | 24.39 | 24.35 | 24.35 | 1675088.0 |
| 2005-03-28 14:00:00 | MSFT | Stock | 24.35 | 24.37 | 24.31 | 24.32 | 3229852.0 |
| 2005-03-28 14:30:00 | MSFT | Stock | 24.32 | 24.38 | 24.32 | 24.35 | 4410630.0 |
| 2005-03-28 15:00:00 | MSFT | Stock | 24.35 | 24.36 | 24.27 | 24.28 | 3085254.0 |
| 2005-03-28 15:30:00 | MSFT | Stock | 24.28 | 24.3 | 24.18 | 24.19 | 7620710.0 |
| 2005-03-28 16:00:00 | MSFT | Stock | 24.2 | 24.22 | 24.18 | 24.2 | 499547.0 |
| 2005-03-28 16:30:00 | MSFT | Stock | 24.2 | 24.22 | 24.19 | 24.19 | 72715.0 |
| 2005-03-28 17:00:00 | MSFT | Stock | 24.19 | 24.22 | 24.19 | 24.22 | 4583.0 |
| 2005-03-28 17:30:00 | MSFT | Stock | 24.23 | 24.23 | 24.23 | 24.23 | 700.0 |
| 2005-03-28 18:00:00 | MSFT | Stock | 24.23 | 24.23 | 24.21 | 24.21 | 7200.0 |
| 2005-03-28 09:00:00 | NVDA | Stock | 0.2101 | 0.2106 | 0.21 | 0.2106 | 123240.0 |
| 2005-03-28 09:30:00 | NVDA | Stock | 0.2095 | 0.2125 | 0.2095 | 0.2108 | 118583760.0 |
| 2005-03-28 10:00:00 | NVDA | Stock | 0.2108 | 0.2108 | 0.2061 | 0.2065 | 73801680.0 |
| 2005-03-28 10:30:00 | NVDA | Stock | 0.2065 | 0.2073 | 0.2061 | 0.2064 | 35094720.0 |
| 2005-03-28 11:00:00 | NVDA | Stock | 0.2063 | 0.2096 | 0.2062 | 0.2071 | 35881320.0 |
| 2005-03-28 11:30:00 | NVDA | Stock | 0.2069 | 0.2072 | 0.2051 | 0.2059 | 39939240.0 |
| 2005-03-28 12:00:00 | NVDA | Stock | 0.2059 | 0.2067 | 0.2055 | 0.2067 | 27945000.0 |
| 2005-03-28 12:30:00 | NVDA | Stock | 0.2067 | 0.208 | 0.2066 | 0.2072 | 30006720.0 |
> showing 50 of 43,740 rows — these rows as CSV