PREVIEW / stock_30min / 2004-07-27
file: by_date/stock_30min/2004/2004-07-27.parquet size: 750 KB rows: 40,988 symbols: 1,810
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-27 08:00:00 | AAPL | Stock | 0.5657 | 0.5741 | 0.5657 | 0.5741 | 1010968.0 |
| 2004-07-27 08:30:00 | AAPL | Stock | 0.5739 | 0.5739 | 0.5675 | 0.5709 | 330400.0 |
| 2004-07-27 09:00:00 | AAPL | Stock | 0.5705 | 0.5707 | 0.5671 | 0.5679 | 627592.0 |
| 2004-07-27 09:30:00 | AAPL | Stock | 0.567 | 0.5688 | 0.5638 | 0.5654 | 31310832.0 |
| 2004-07-27 10:00:00 | AAPL | Stock | 0.565 | 0.5757 | 0.565 | 0.5748 | 64144808.0 |
| 2004-07-27 10:30:00 | AAPL | Stock | 0.5748 | 0.5748 | 0.5679 | 0.5705 | 46332552.0 |
| 2004-07-27 11:00:00 | AAPL | Stock | 0.5705 | 0.5729 | 0.5688 | 0.5721 | 29022392.0 |
| 2004-07-27 11:30:00 | AAPL | Stock | 0.5723 | 0.5759 | 0.5714 | 0.5752 | 20340824.0 |
| 2004-07-27 12:00:00 | AAPL | Stock | 0.5754 | 0.5782 | 0.5752 | 0.5775 | 14031136.0 |
| 2004-07-27 12:30:00 | AAPL | Stock | 0.5775 | 0.5782 | 0.5736 | 0.578 | 12559848.0 |
| 2004-07-27 13:00:00 | AAPL | Stock | 0.578 | 0.5784 | 0.5741 | 0.5755 | 13177640.0 |
| 2004-07-27 13:30:00 | AAPL | Stock | 0.5755 | 0.5757 | 0.573 | 0.5752 | 10808672.0 |
| 2004-07-27 14:00:00 | AAPL | Stock | 0.5752 | 0.578 | 0.5732 | 0.578 | 15865864.0 |
| 2004-07-27 14:30:00 | AAPL | Stock | 0.578 | 0.5838 | 0.5777 | 0.5838 | 31046904.0 |
| 2004-07-27 15:00:00 | AAPL | Stock | 0.5838 | 0.5848 | 0.5805 | 0.5805 | 34843536.0 |
| 2004-07-27 15:30:00 | AAPL | Stock | 0.5804 | 0.5839 | 0.5784 | 0.5791 | 48816768.0 |
| 2004-07-27 16:00:00 | AAPL | Stock | 0.5791 | 0.5793 | 0.5768 | 0.5768 | 8441496.0 |
| 2004-07-27 16:30:00 | AAPL | Stock | 0.5791 | 0.5791 | 0.5791 | 0.5791 | 1792000.0 |
| 2004-07-27 17:30:00 | AAPL | Stock | 0.5786 | 0.5788 | 0.5784 | 0.5788 | 39200.0 |
| 2004-07-27 08:00:00 | MSFT | Stock | 28.77 | 28.8 | 28.755 | 28.77 | 12930.0 |
| 2004-07-27 08:30:00 | MSFT | Stock | 28.8 | 29.67 | 28.65 | 28.75 | 313032.0 |
| 2004-07-27 09:00:00 | MSFT | Stock | 28.76 | 28.77 | 28.69 | 28.72 | 108486.0 |
| 2004-07-27 09:30:00 | MSFT | Stock | 28.71 | 28.76 | 28.47 | 28.54 | 5588923.0 |
| 2004-07-27 10:00:00 | MSFT | Stock | 28.54 | 28.59 | 28.43 | 28.47 | 5606595.0 |
| 2004-07-27 10:30:00 | MSFT | Stock | 28.46 | 28.48 | 28.15 | 28.17 | 8383621.0 |
| 2004-07-27 11:00:00 | MSFT | Stock | 28.17 | 28.29 | 28.13 | 28.29 | 4937300.0 |
| 2004-07-27 11:30:00 | MSFT | Stock | 28.28 | 28.4 | 28.26 | 28.38 | 5156272.0 |
| 2004-07-27 12:00:00 | MSFT | Stock | 28.38 | 28.5 | 28.38 | 28.44 | 3881617.0 |
| 2004-07-27 12:30:00 | MSFT | Stock | 28.44 | 28.47 | 28.39 | 28.43 | 2456930.0 |
| 2004-07-27 13:00:00 | MSFT | Stock | 28.43 | 28.45 | 28.34 | 28.39 | 2130100.0 |
| 2004-07-27 13:30:00 | MSFT | Stock | 28.39 | 28.41 | 28.29 | 28.33 | 2515419.0 |
| 2004-07-27 14:00:00 | MSFT | Stock | 28.34 | 28.4 | 28.27 | 28.39 | 2938555.0 |
| 2004-07-27 14:30:00 | MSFT | Stock | 28.39 | 28.46 | 28.35 | 28.39 | 4268626.0 |
| 2004-07-27 15:00:00 | MSFT | Stock | 28.381 | 28.5 | 28.38 | 28.49 | 4579696.0 |
| 2004-07-27 15:30:00 | MSFT | Stock | 28.491 | 28.59 | 28.42 | 28.46 | 6388248.0 |
| 2004-07-27 16:00:00 | MSFT | Stock | 28.47 | 28.5 | 28.35 | 28.48 | 2859596.0 |
| 2004-07-27 16:30:00 | MSFT | Stock | 28.48 | 28.49 | 28.44 | 28.49 | 3498715.0 |
| 2004-07-27 17:00:00 | MSFT | Stock | 28.46 | 28.506 | 28.43 | 28.506 | 24133.0 |
| 2004-07-27 17:30:00 | MSFT | Stock | 28.43 | 28.43 | 28.38 | 28.38 | 16050.0 |
| 2004-07-27 18:00:00 | MSFT | Stock | 28.4 | 28.43 | 28.38 | 28.39 | 5500.0 |
| 2004-07-27 08:00:00 | NVDA | Stock | 0.1167 | 0.1184 | 0.1152 | 0.1167 | 2331720.0 |
| 2004-07-27 08:30:00 | NVDA | Stock | 0.1167 | 0.1174 | 0.1165 | 0.1174 | 294000.0 |
| 2004-07-27 09:00:00 | NVDA | Stock | 0.1172 | 0.1185 | 0.1172 | 0.1183 | 3146640.0 |
| 2004-07-27 09:30:00 | NVDA | Stock | 0.1172 | 0.1175 | 0.116 | 0.1167 | 46497600.0 |
| 2004-07-27 10:00:00 | NVDA | Stock | 0.1167 | 0.1191 | 0.1167 | 0.118 | 36962760.0 |
| 2004-07-27 10:30:00 | NVDA | Stock | 0.1182 | 0.1183 | 0.1164 | 0.1167 | 18002640.0 |
| 2004-07-27 11:00:00 | NVDA | Stock | 0.1167 | 0.117 | 0.1153 | 0.1166 | 32229720.0 |
| 2004-07-27 11:30:00 | NVDA | Stock | 0.1167 | 0.1181 | 0.116 | 0.1181 | 19830480.0 |
| 2004-07-27 12:00:00 | NVDA | Stock | 0.1181 | 0.1182 | 0.1174 | 0.1176 | 29212080.0 |
| 2004-07-27 12:30:00 | NVDA | Stock | 0.1175 | 0.1177 | 0.1172 | 0.1175 | 38695800.0 |
> showing 50 of 40,988 rows — these rows as CSV