PREVIEW / stock_30min / 2004-07-19
file: by_date/stock_30min/2004/2004-07-19.parquet size: 748 KB rows: 40,525 symbols: 1,798
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-19 08:30:00 | AAPL | Stock | 0.5754 | 0.5754 | 0.57 | 0.5714 | 909440.0 |
| 2004-07-19 09:00:00 | AAPL | Stock | 0.5714 | 0.5734 | 0.5707 | 0.5723 | 3222464.0 |
| 2004-07-19 09:30:00 | AAPL | Stock | 0.5723 | 0.5723 | 0.5659 | 0.5698 | 106546160.0 |
| 2004-07-19 10:00:00 | AAPL | Stock | 0.5698 | 0.5716 | 0.5693 | 0.57 | 39447744.0 |
| 2004-07-19 10:30:00 | AAPL | Stock | 0.57 | 0.5732 | 0.5686 | 0.5727 | 39507160.0 |
| 2004-07-19 11:00:00 | AAPL | Stock | 0.573 | 0.5754 | 0.572 | 0.5743 | 29695680.0 |
| 2004-07-19 11:30:00 | AAPL | Stock | 0.5745 | 0.5748 | 0.5707 | 0.5713 | 44037952.0 |
| 2004-07-19 12:00:00 | AAPL | Stock | 0.5714 | 0.5725 | 0.5705 | 0.5714 | 30928520.0 |
| 2004-07-19 12:30:00 | AAPL | Stock | 0.5713 | 0.5714 | 0.5689 | 0.5693 | 22219960.0 |
| 2004-07-19 13:00:00 | AAPL | Stock | 0.5693 | 0.5696 | 0.5654 | 0.5675 | 29062544.0 |
| 2004-07-19 13:30:00 | AAPL | Stock | 0.5675 | 0.5689 | 0.5659 | 0.5664 | 16246048.0 |
| 2004-07-19 14:00:00 | AAPL | Stock | 0.5661 | 0.5721 | 0.5661 | 0.572 | 51660896.0 |
| 2004-07-19 14:30:00 | AAPL | Stock | 0.5718 | 0.5738 | 0.5695 | 0.5729 | 34020560.0 |
| 2004-07-19 15:00:00 | AAPL | Stock | 0.5729 | 0.5738 | 0.5713 | 0.5714 | 20730696.0 |
| 2004-07-19 15:30:00 | AAPL | Stock | 0.5716 | 0.5725 | 0.5693 | 0.5704 | 31945032.0 |
| 2004-07-19 16:00:00 | AAPL | Stock | 0.5705 | 0.5723 | 0.5696 | 0.5696 | 4521720.0 |
| 2004-07-19 16:30:00 | AAPL | Stock | 0.5696 | 0.5709 | 0.5696 | 0.5709 | 17024.0 |
| 2004-07-19 17:00:00 | AAPL | Stock | 0.5732 | 0.5732 | 0.5732 | 0.5732 | 5600.0 |
| 2004-07-19 17:30:00 | AAPL | Stock | 0.5729 | 0.573 | 0.5729 | 0.5729 | 61600.0 |
| 2004-07-19 08:00:00 | MSFT | Stock | 27.55 | 27.6 | 27.5 | 27.58 | 7300.0 |
| 2004-07-19 08:30:00 | MSFT | Stock | 27.57 | 27.6 | 27.5 | 27.57 | 41369.0 |
| 2004-07-19 09:00:00 | MSFT | Stock | 27.6 | 27.62 | 27.54 | 27.6 | 78755.0 |
| 2004-07-19 09:30:00 | MSFT | Stock | 27.62 | 27.79 | 27.6 | 27.78 | 7399273.0 |
| 2004-07-19 10:00:00 | MSFT | Stock | 27.77 | 27.86 | 27.74 | 27.79 | 6273121.0 |
| 2004-07-19 10:30:00 | MSFT | Stock | 27.79 | 27.91 | 27.75 | 27.87 | 3908297.0 |
| 2004-07-19 11:00:00 | MSFT | Stock | 27.87 | 27.92 | 27.8 | 27.83 | 3141941.0 |
| 2004-07-19 11:30:00 | MSFT | Stock | 27.84 | 27.86 | 27.73 | 27.77 | 3518730.0 |
| 2004-07-19 12:00:00 | MSFT | Stock | 27.77 | 27.81 | 27.68 | 27.77 | 4356665.0 |
| 2004-07-19 12:30:00 | MSFT | Stock | 27.76 | 27.87 | 27.73 | 27.86 | 2545856.0 |
| 2004-07-19 13:00:00 | MSFT | Stock | 27.86 | 27.92 | 27.81 | 27.829 | 3601033.0 |
| 2004-07-19 13:30:00 | MSFT | Stock | 27.81 | 27.85 | 27.75 | 27.84 | 1945758.0 |
| 2004-07-19 14:00:00 | MSFT | Stock | 27.84 | 28.16 | 27.83 | 28.16 | 6403202.0 |
| 2004-07-19 14:30:00 | MSFT | Stock | 28.14 | 28.26 | 28.09 | 28.13 | 5624301.0 |
| 2004-07-19 15:00:00 | MSFT | Stock | 28.13 | 28.14 | 28.0 | 28.04 | 4383636.0 |
| 2004-07-19 15:30:00 | MSFT | Stock | 28.04 | 28.08 | 27.93 | 27.96 | 5022754.0 |
| 2004-07-19 16:00:00 | MSFT | Stock | 27.96 | 28.04 | 27.9 | 27.97 | 332106.0 |
| 2004-07-19 16:30:00 | MSFT | Stock | 27.96 | 27.97 | 27.95 | 27.95 | 46265.0 |
| 2004-07-19 17:00:00 | MSFT | Stock | 27.95 | 28.0 | 27.95 | 28.0 | 27050.0 |
| 2004-07-19 17:30:00 | MSFT | Stock | 28.0 | 28.06 | 28.0 | 28.01 | 10800.0 |
| 2004-07-19 18:00:00 | MSFT | Stock | 28.0 | 28.04 | 28.0 | 28.04 | 2600.0 |
| 2004-07-19 08:00:00 | NVDA | Stock | 0.1282 | 0.1282 | 0.1282 | 0.1282 | 42000.0 |
| 2004-07-19 08:30:00 | NVDA | Stock | 0.1275 | 0.1275 | 0.1273 | 0.1275 | 2324040.0 |
| 2004-07-19 09:00:00 | NVDA | Stock | 0.1275 | 0.1282 | 0.1271 | 0.1282 | 931920.0 |
| 2004-07-19 09:30:00 | NVDA | Stock | 0.1283 | 0.1293 | 0.1268 | 0.1282 | 48288840.0 |
| 2004-07-19 10:00:00 | NVDA | Stock | 0.1283 | 0.129 | 0.1267 | 0.1269 | 28729800.0 |
| 2004-07-19 10:30:00 | NVDA | Stock | 0.1269 | 0.1277 | 0.1265 | 0.1268 | 22499880.0 |
| 2004-07-19 11:00:00 | NVDA | Stock | 0.1267 | 0.1272 | 0.1265 | 0.1265 | 22938960.0 |
| 2004-07-19 11:30:00 | NVDA | Stock | 0.1265 | 0.1266 | 0.1259 | 0.1259 | 22680480.0 |
| 2004-07-19 12:00:00 | NVDA | Stock | 0.126 | 0.1263 | 0.1253 | 0.126 | 18458040.0 |
| 2004-07-19 12:30:00 | NVDA | Stock | 0.1259 | 0.1261 | 0.1251 | 0.1257 | 20495760.0 |
> showing 50 of 40,525 rows — these rows as CSV