PREVIEW / stock_30min / 2004-07-13
file: by_date/stock_30min/2004/2004-07-13.parquet size: 737 KB rows: 39,812 symbols: 1,801
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 |
|---|---|---|---|---|---|---|---|
| 2004-07-13 08:00:00 | AAPL | Stock | 0.5232 | 0.5232 | 0.5225 | 0.5225 | 11200.0 |
| 2004-07-13 08:30:00 | AAPL | Stock | 0.5221 | 0.5223 | 0.5218 | 0.5223 | 280000.0 |
| 2004-07-13 09:00:00 | AAPL | Stock | 0.5223 | 0.5239 | 0.5205 | 0.5223 | 1867880.0 |
| 2004-07-13 09:30:00 | AAPL | Stock | 0.5223 | 0.5279 | 0.5209 | 0.5257 | 37541448.0 |
| 2004-07-13 10:00:00 | AAPL | Stock | 0.5257 | 0.5259 | 0.5213 | 0.5257 | 23126656.0 |
| 2004-07-13 10:30:00 | AAPL | Stock | 0.5254 | 0.5268 | 0.5241 | 0.5248 | 16414608.0 |
| 2004-07-13 11:00:00 | AAPL | Stock | 0.5248 | 0.5252 | 0.5232 | 0.5252 | 11576992.0 |
| 2004-07-13 11:30:00 | AAPL | Stock | 0.5252 | 0.5255 | 0.522 | 0.5241 | 10894856.0 |
| 2004-07-13 12:00:00 | AAPL | Stock | 0.5241 | 0.5259 | 0.5236 | 0.5239 | 10866240.0 |
| 2004-07-13 12:30:00 | AAPL | Stock | 0.5236 | 0.5259 | 0.5236 | 0.5248 | 15708560.0 |
| 2004-07-13 13:00:00 | AAPL | Stock | 0.5246 | 0.525 | 0.5213 | 0.5232 | 20030920.0 |
| 2004-07-13 13:30:00 | AAPL | Stock | 0.523 | 0.5236 | 0.5207 | 0.5229 | 17257968.0 |
| 2004-07-13 14:00:00 | AAPL | Stock | 0.5229 | 0.5238 | 0.5216 | 0.5223 | 17207400.0 |
| 2004-07-13 14:30:00 | AAPL | Stock | 0.5221 | 0.5229 | 0.5182 | 0.5191 | 23721208.0 |
| 2004-07-13 15:00:00 | AAPL | Stock | 0.5189 | 0.5223 | 0.5189 | 0.52 | 15398768.0 |
| 2004-07-13 15:30:00 | AAPL | Stock | 0.5202 | 0.5234 | 0.5191 | 0.5209 | 34935768.0 |
| 2004-07-13 16:00:00 | AAPL | Stock | 0.5211 | 0.5229 | 0.5082 | 0.517 | 4854248.0 |
| 2004-07-13 16:30:00 | AAPL | Stock | 0.5218 | 0.5218 | 0.5164 | 0.5164 | 443408.0 |
| 2004-07-13 17:00:00 | AAPL | Stock | 0.5218 | 0.5218 | 0.5161 | 0.5161 | 4074168.0 |
| 2004-07-13 17:30:00 | AAPL | Stock | 0.5161 | 0.5161 | 0.5161 | 0.5161 | 28000.0 |
| 2004-07-13 18:00:00 | AAPL | Stock | 0.5145 | 0.5145 | 0.5145 | 0.5145 | 28000.0 |
| 2004-07-13 08:00:00 | MSFT | Stock | 27.93 | 27.94 | 27.9 | 27.91 | 48620.0 |
| 2004-07-13 08:30:00 | MSFT | Stock | 27.92 | 27.93 | 27.91 | 27.93 | 6315.0 |
| 2004-07-13 09:00:00 | MSFT | Stock | 27.95 | 27.96 | 27.9 | 27.9 | 63255.0 |
| 2004-07-13 09:30:00 | MSFT | Stock | 27.91 | 27.95 | 27.82 | 27.88 | 3280362.0 |
| 2004-07-13 10:00:00 | MSFT | Stock | 27.89 | 27.92 | 27.73 | 27.79 | 4063214.0 |
| 2004-07-13 10:30:00 | MSFT | Stock | 27.78 | 27.79 | 27.7 | 27.71 | 2153674.0 |
| 2004-07-13 11:00:00 | MSFT | Stock | 27.72 | 27.74 | 27.68 | 27.71 | 2258474.0 |
| 2004-07-13 11:30:00 | MSFT | Stock | 27.71 | 27.72 | 27.66 | 27.7 | 1994433.0 |
| 2004-07-13 12:00:00 | MSFT | Stock | 27.69 | 27.7 | 27.65 | 27.65 | 1587306.0 |
| 2004-07-13 12:30:00 | MSFT | Stock | 27.65 | 27.76 | 27.65 | 27.73 | 2791328.0 |
| 2004-07-13 13:00:00 | MSFT | Stock | 27.73 | 27.77 | 27.66 | 27.7 | 2757277.0 |
| 2004-07-13 13:30:00 | MSFT | Stock | 27.699 | 27.74 | 27.61 | 27.73 | 3596032.0 |
| 2004-07-13 14:00:00 | MSFT | Stock | 27.73 | 27.75 | 27.63 | 27.65 | 2568626.0 |
| 2004-07-13 14:30:00 | MSFT | Stock | 27.66 | 27.73 | 27.65 | 27.66 | 2949184.0 |
| 2004-07-13 15:00:00 | MSFT | Stock | 27.66 | 27.72 | 27.62 | 27.66 | 2694203.0 |
| 2004-07-13 15:30:00 | MSFT | Stock | 27.66 | 27.7 | 27.61 | 27.61 | 5609767.0 |
| 2004-07-13 16:00:00 | MSFT | Stock | 27.61 | 27.7314 | 27.47 | 27.55 | 794116.0 |
| 2004-07-13 16:30:00 | MSFT | Stock | 27.51 | 27.61 | 27.32 | 27.38 | 530684.0 |
| 2004-07-13 17:00:00 | MSFT | Stock | 27.4 | 27.61 | 27.34 | 27.38 | 562373.0 |
| 2004-07-13 17:30:00 | MSFT | Stock | 27.38 | 27.4 | 27.32 | 27.34 | 121500.0 |
| 2004-07-13 18:00:00 | MSFT | Stock | 27.32 | 27.38 | 27.3 | 27.38 | 74200.0 |
| 2004-07-13 08:30:00 | NVDA | Stock | 0.1383 | 0.1383 | 0.1383 | 0.1383 | 132000.0 |
| 2004-07-13 09:00:00 | NVDA | Stock | 0.1385 | 0.1392 | 0.1379 | 0.1392 | 1282800.0 |
| 2004-07-13 09:30:00 | NVDA | Stock | 0.1392 | 0.1414 | 0.1379 | 0.1384 | 37393440.0 |
| 2004-07-13 10:00:00 | NVDA | Stock | 0.1387 | 0.1389 | 0.1369 | 0.1382 | 58899240.0 |
| 2004-07-13 10:30:00 | NVDA | Stock | 0.1382 | 0.1387 | 0.137 | 0.1377 | 43009560.0 |
| 2004-07-13 11:00:00 | NVDA | Stock | 0.1378 | 0.1387 | 0.1377 | 0.1387 | 22565280.0 |
| 2004-07-13 11:30:00 | NVDA | Stock | 0.1387 | 0.1388 | 0.1377 | 0.1381 | 31435440.0 |
| 2004-07-13 12:00:00 | NVDA | Stock | 0.1382 | 0.1382 | 0.1379 | 0.1381 | 24750840.0 |
> showing 50 of 39,812 rows — these rows as CSV