PREVIEW / stock_30min / 2004-08-05
file: by_date/stock_30min/2004/2004-08-05.parquet size: 750 KB rows: 40,573 symbols: 1,811
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-08-05 09:00:00 | AAPL | Stock | 0.5677 | 0.5684 | 0.5677 | 0.5679 | 8741600.0 |
| 2004-08-05 09:30:00 | AAPL | Stock | 0.567 | 0.5768 | 0.5661 | 0.5755 | 30723560.0 |
| 2004-08-05 10:00:00 | AAPL | Stock | 0.5755 | 0.5768 | 0.5734 | 0.5746 | 23464112.0 |
| 2004-08-05 10:30:00 | AAPL | Stock | 0.5745 | 0.5757 | 0.5723 | 0.5736 | 15631784.0 |
| 2004-08-05 11:00:00 | AAPL | Stock | 0.5738 | 0.5752 | 0.5736 | 0.5746 | 8292928.0 |
| 2004-08-05 11:30:00 | AAPL | Stock | 0.5746 | 0.5752 | 0.5725 | 0.5741 | 18793096.0 |
| 2004-08-05 12:00:00 | AAPL | Stock | 0.5741 | 0.5748 | 0.5695 | 0.5696 | 18494728.0 |
| 2004-08-05 12:30:00 | AAPL | Stock | 0.5696 | 0.5698 | 0.5666 | 0.5668 | 14205408.0 |
| 2004-08-05 13:00:00 | AAPL | Stock | 0.5668 | 0.5686 | 0.5629 | 0.5632 | 12595800.0 |
| 2004-08-05 13:30:00 | AAPL | Stock | 0.5632 | 0.5663 | 0.563 | 0.5652 | 9205672.0 |
| 2004-08-05 14:00:00 | AAPL | Stock | 0.5652 | 0.5684 | 0.5643 | 0.568 | 12249216.0 |
| 2004-08-05 14:30:00 | AAPL | Stock | 0.5679 | 0.5686 | 0.5643 | 0.5648 | 19783176.0 |
| 2004-08-05 15:00:00 | AAPL | Stock | 0.5646 | 0.5661 | 0.5598 | 0.5604 | 22171016.0 |
| 2004-08-05 15:30:00 | AAPL | Stock | 0.5605 | 0.563 | 0.558 | 0.5607 | 27344464.0 |
| 2004-08-05 16:00:00 | AAPL | Stock | 0.5607 | 0.5607 | 0.5582 | 0.5605 | 2403016.0 |
| 2004-08-05 16:30:00 | AAPL | Stock | 0.5607 | 0.5607 | 0.5605 | 0.5607 | 277200.0 |
| 2004-08-05 17:00:00 | AAPL | Stock | 0.5605 | 0.5605 | 0.5605 | 0.5605 | 67200.0 |
| 2004-08-05 08:30:00 | MSFT | Stock | 28.08 | 28.15 | 28.08 | 28.14 | 17900.0 |
| 2004-08-05 09:00:00 | MSFT | Stock | 28.13 | 28.16 | 28.11 | 28.15 | 59765.0 |
| 2004-08-05 09:30:00 | MSFT | Stock | 28.14 | 28.21 | 28.11 | 28.17 | 4013869.0 |
| 2004-08-05 10:00:00 | MSFT | Stock | 28.17 | 28.17 | 28.07 | 28.09 | 3332727.0 |
| 2004-08-05 10:30:00 | MSFT | Stock | 28.1 | 28.15 | 28.05 | 28.09 | 4035195.0 |
| 2004-08-05 11:00:00 | MSFT | Stock | 28.08 | 28.14 | 28.02 | 28.03 | 3363314.0 |
| 2004-08-05 11:30:00 | MSFT | Stock | 28.04 | 28.05 | 27.93 | 27.95 | 3202209.0 |
| 2004-08-05 12:00:00 | MSFT | Stock | 27.95 | 27.95 | 27.8 | 27.9418 | 4880409.0 |
| 2004-08-05 12:30:00 | MSFT | Stock | 27.94 | 27.96 | 27.81 | 27.83 | 2416779.0 |
| 2004-08-05 13:00:00 | MSFT | Stock | 27.83 | 27.87 | 27.76 | 27.77 | 2327122.0 |
| 2004-08-05 13:30:00 | MSFT | Stock | 27.76 | 27.86 | 27.75 | 27.83 | 2435804.0 |
| 2004-08-05 14:00:00 | MSFT | Stock | 27.83 | 27.84 | 27.75 | 27.77 | 2573873.0 |
| 2004-08-05 14:30:00 | MSFT | Stock | 27.78 | 27.82 | 27.64 | 27.66 | 5996282.0 |
| 2004-08-05 15:00:00 | MSFT | Stock | 27.66 | 27.71 | 27.6 | 27.61 | 4575754.0 |
| 2004-08-05 15:30:00 | MSFT | Stock | 27.62 | 27.72 | 27.52 | 27.54 | 9081377.0 |
| 2004-08-05 16:00:00 | MSFT | Stock | 27.53 | 27.56 | 27.46 | 27.47 | 836530.0 |
| 2004-08-05 16:30:00 | MSFT | Stock | 27.49 | 27.53 | 27.47 | 27.47 | 95461.0 |
| 2004-08-05 17:00:00 | MSFT | Stock | 27.5 | 27.53 | 27.47 | 27.53 | 16900.0 |
| 2004-08-05 17:30:00 | MSFT | Stock | 27.52 | 27.55 | 27.52 | 27.55 | 2800.0 |
| 2004-08-05 18:00:00 | MSFT | Stock | 27.55 | 27.56 | 27.5 | 27.52 | 4050.0 |
| 2004-08-05 18:30:00 | MSFT | Stock | 27.52 | 27.52 | 27.52 | 27.52 | 100.0 |
| 2004-08-05 08:00:00 | NVDA | Stock | 0.1254 | 0.1254 | 0.1254 | 0.1254 | 360000.0 |
| 2004-08-05 09:00:00 | NVDA | Stock | 0.1255 | 0.1257 | 0.1252 | 0.1254 | 1131120.0 |
| 2004-08-05 09:30:00 | NVDA | Stock | 0.1254 | 0.1267 | 0.1243 | 0.125 | 68648520.0 |
| 2004-08-05 10:00:00 | NVDA | Stock | 0.125 | 0.1251 | 0.1229 | 0.1241 | 64602000.0 |
| 2004-08-05 10:30:00 | NVDA | Stock | 0.1241 | 0.1257 | 0.1238 | 0.1255 | 44195400.0 |
| 2004-08-05 11:00:00 | NVDA | Stock | 0.1254 | 0.1261 | 0.1252 | 0.1254 | 32769600.0 |
| 2004-08-05 11:30:00 | NVDA | Stock | 0.1254 | 0.1258 | 0.1248 | 0.1253 | 39494880.0 |
| 2004-08-05 12:00:00 | NVDA | Stock | 0.1252 | 0.1255 | 0.1246 | 0.1249 | 29057760.0 |
| 2004-08-05 12:30:00 | NVDA | Stock | 0.1249 | 0.125 | 0.1238 | 0.1246 | 27084600.0 |
| 2004-08-05 13:00:00 | NVDA | Stock | 0.1247 | 0.1251 | 0.1245 | 0.1248 | 29874720.0 |
| 2004-08-05 13:30:00 | NVDA | Stock | 0.1248 | 0.1259 | 0.1247 | 0.1255 | 30860280.0 |
| 2004-08-05 14:00:00 | NVDA | Stock | 0.1254 | 0.1259 | 0.1249 | 0.1255 | 30245640.0 |
> showing 50 of 40,573 rows — these rows as CSV