PREVIEW / stock_30min / 2004-10-18
file: by_date/stock_30min/2004/2004-10-18.parquet size: 773 KB rows: 40,800 symbols: 1,839
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-10-18 08:00:00 | AAPL | Stock | 0.8123 | 0.8125 | 0.8086 | 0.8107 | 67200.0 |
| 2004-10-18 08:30:00 | AAPL | Stock | 0.8086 | 0.8121 | 0.805 | 0.8116 | 1554000.0 |
| 2004-10-18 09:00:00 | AAPL | Stock | 0.8071 | 0.8125 | 0.7964 | 0.7982 | 16671088.0 |
| 2004-10-18 09:30:00 | AAPL | Stock | 0.7998 | 0.8052 | 0.7982 | 0.805 | 159930624.0 |
| 2004-10-18 10:00:00 | AAPL | Stock | 0.8048 | 0.8113 | 0.8025 | 0.8052 | 105552216.0 |
| 2004-10-18 10:30:00 | AAPL | Stock | 0.8052 | 0.8143 | 0.805 | 0.8091 | 73063816.0 |
| 2004-10-18 11:00:00 | AAPL | Stock | 0.8093 | 0.8127 | 0.8071 | 0.8111 | 64159144.0 |
| 2004-10-18 11:30:00 | AAPL | Stock | 0.8098 | 0.8191 | 0.8089 | 0.8146 | 78987048.0 |
| 2004-10-18 12:00:00 | AAPL | Stock | 0.8146 | 0.8241 | 0.8138 | 0.8205 | 86867368.0 |
| 2004-10-18 12:30:00 | AAPL | Stock | 0.8204 | 0.8259 | 0.8196 | 0.8232 | 44874200.0 |
| 2004-10-18 13:00:00 | AAPL | Stock | 0.8232 | 0.8327 | 0.823 | 0.8321 | 67938136.0 |
| 2004-10-18 13:30:00 | AAPL | Stock | 0.832 | 0.833 | 0.8263 | 0.8282 | 41232744.0 |
| 2004-10-18 14:00:00 | AAPL | Stock | 0.828 | 0.8293 | 0.8277 | 0.8288 | 28860664.0 |
| 2004-10-18 14:30:00 | AAPL | Stock | 0.8288 | 0.8379 | 0.8259 | 0.8375 | 97857256.0 |
| 2004-10-18 15:00:00 | AAPL | Stock | 0.8375 | 0.8438 | 0.8357 | 0.8418 | 142158744.0 |
| 2004-10-18 15:30:00 | AAPL | Stock | 0.8416 | 0.8525 | 0.8411 | 0.852 | 142280208.0 |
| 2004-10-18 16:00:00 | AAPL | Stock | 0.852 | 0.8527 | 0.8473 | 0.8527 | 13423872.0 |
| 2004-10-18 16:30:00 | AAPL | Stock | 0.8527 | 0.8539 | 0.8436 | 0.8527 | 2550408.0 |
| 2004-10-18 17:00:00 | AAPL | Stock | 0.8539 | 0.8571 | 0.8525 | 0.8536 | 5007576.0 |
| 2004-10-18 17:30:00 | AAPL | Stock | 0.8536 | 0.8545 | 0.8532 | 0.8545 | 907592.0 |
| 2004-10-18 18:00:00 | AAPL | Stock | 0.8541 | 0.8571 | 0.8541 | 0.8564 | 128576.0 |
| 2004-10-18 08:00:00 | MSFT | Stock | 28.05 | 28.15 | 28.05 | 28.12 | 13815.0 |
| 2004-10-18 08:30:00 | MSFT | Stock | 27.99 | 28.12 | 27.99 | 28.04 | 26600.0 |
| 2004-10-18 09:00:00 | MSFT | Stock | 28.05 | 28.07 | 28.01 | 28.05 | 75908.0 |
| 2004-10-18 09:30:00 | MSFT | Stock | 28.06 | 28.14 | 27.99 | 28.131 | 4819333.0 |
| 2004-10-18 10:00:00 | MSFT | Stock | 28.14 | 28.15 | 28.039 | 28.07 | 4547723.0 |
| 2004-10-18 10:30:00 | MSFT | Stock | 28.069 | 28.1 | 27.98 | 27.99 | 2726452.0 |
| 2004-10-18 11:00:00 | MSFT | Stock | 27.99 | 28.06 | 27.98 | 28.05 | 2072356.0 |
| 2004-10-18 11:30:00 | MSFT | Stock | 28.06 | 28.12 | 28.05 | 28.11 | 2186723.0 |
| 2004-10-18 12:00:00 | MSFT | Stock | 28.12 | 28.4 | 28.11 | 28.38 | 5453080.0 |
| 2004-10-18 12:30:00 | MSFT | Stock | 28.38 | 28.4 | 28.31 | 28.35 | 3315813.0 |
| 2004-10-18 13:00:00 | MSFT | Stock | 28.35 | 28.41 | 28.32 | 28.4 | 2862624.0 |
| 2004-10-18 13:30:00 | MSFT | Stock | 28.4 | 28.41 | 28.26 | 28.33 | 3977084.0 |
| 2004-10-18 14:00:00 | MSFT | Stock | 28.33 | 28.36 | 28.27 | 28.32 | 1812955.0 |
| 2004-10-18 14:30:00 | MSFT | Stock | 28.32 | 28.43 | 28.3 | 28.4 | 3545512.0 |
| 2004-10-18 15:00:00 | MSFT | Stock | 28.4 | 28.41 | 28.32 | 28.39 | 4214496.0 |
| 2004-10-18 15:30:00 | MSFT | Stock | 28.39 | 28.45 | 28.33 | 28.41 | 6033758.0 |
| 2004-10-18 16:00:00 | MSFT | Stock | 28.41 | 28.49 | 28.36 | 28.45 | 505908.0 |
| 2004-10-18 16:30:00 | MSFT | Stock | 28.48 | 28.5 | 28.44 | 28.44 | 24031.0 |
| 2004-10-18 17:00:00 | MSFT | Stock | 28.48 | 28.52 | 28.432 | 28.5 | 169448.0 |
| 2004-10-18 17:30:00 | MSFT | Stock | 28.51 | 28.54 | 28.47 | 28.53 | 9015.0 |
| 2004-10-18 18:00:00 | MSFT | Stock | 28.53 | 28.53 | 28.5 | 28.52 | 8198.0 |
| 2004-10-18 08:30:00 | NVDA | Stock | 0.1116 | 0.1116 | 0.1116 | 0.1116 | 240000.0 |
| 2004-10-18 09:00:00 | NVDA | Stock | 0.1112 | 0.1115 | 0.1111 | 0.1114 | 400320.0 |
| 2004-10-18 09:30:00 | NVDA | Stock | 0.1112 | 0.1117 | 0.1102 | 0.1116 | 42773880.0 |
| 2004-10-18 10:00:00 | NVDA | Stock | 0.1115 | 0.1118 | 0.1105 | 0.1109 | 42970560.0 |
| 2004-10-18 10:30:00 | NVDA | Stock | 0.1108 | 0.1116 | 0.1105 | 0.1111 | 30608400.0 |
| 2004-10-18 11:00:00 | NVDA | Stock | 0.111 | 0.1125 | 0.1106 | 0.1125 | 22720560.0 |
| 2004-10-18 11:30:00 | NVDA | Stock | 0.1125 | 0.1129 | 0.1118 | 0.1129 | 26959080.0 |
| 2004-10-18 12:00:00 | NVDA | Stock | 0.1128 | 0.115 | 0.1127 | 0.1145 | 70350480.0 |
> showing 50 of 40,800 rows — these rows as CSV