PREVIEW / stock_30min / 2005-06-28
file: by_date/stock_30min/2005/2005-06-28.parquet size: 851 KB rows: 46,590 symbols: 2,009
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-28 08:00:00 | AAPL | Stock | 1.3364 | 1.3407 | 1.3357 | 1.3375 | 239680.0 |
| 2005-06-28 08:30:00 | AAPL | Stock | 1.3357 | 1.3393 | 1.3339 | 1.3364 | 327180.0 |
| 2005-06-28 09:00:00 | AAPL | Stock | 1.3364 | 1.3411 | 1.325 | 1.3396 | 3727556.0 |
| 2005-06-28 09:30:00 | AAPL | Stock | 1.3391 | 1.3425 | 1.3304 | 1.3329 | 80200344.0 |
| 2005-06-28 10:00:00 | AAPL | Stock | 1.3332 | 1.3364 | 1.3275 | 1.3346 | 44148412.0 |
| 2005-06-28 10:30:00 | AAPL | Stock | 1.335 | 1.3389 | 1.3321 | 1.3336 | 32623696.0 |
| 2005-06-28 11:00:00 | AAPL | Stock | 1.3336 | 1.3361 | 1.3325 | 1.3332 | 16750916.0 |
| 2005-06-28 11:30:00 | AAPL | Stock | 1.3332 | 1.3425 | 1.3329 | 1.3386 | 24916808.0 |
| 2005-06-28 12:00:00 | AAPL | Stock | 1.3382 | 1.3421 | 1.3357 | 1.3357 | 13624156.0 |
| 2005-06-28 12:30:00 | AAPL | Stock | 1.3357 | 1.3361 | 1.3321 | 1.3325 | 13544048.0 |
| 2005-06-28 13:00:00 | AAPL | Stock | 1.3325 | 1.3382 | 1.3321 | 1.3343 | 20861596.0 |
| 2005-06-28 13:30:00 | AAPL | Stock | 1.3346 | 1.3371 | 1.3332 | 1.3336 | 9415980.0 |
| 2005-06-28 14:00:00 | AAPL | Stock | 1.3336 | 1.3368 | 1.3329 | 1.3346 | 10755696.0 |
| 2005-06-28 14:30:00 | AAPL | Stock | 1.3346 | 1.3393 | 1.3343 | 1.3357 | 19162024.0 |
| 2005-06-28 15:00:00 | AAPL | Stock | 1.3354 | 1.3393 | 1.3354 | 1.3379 | 16376668.0 |
| 2005-06-28 15:30:00 | AAPL | Stock | 1.3379 | 1.3386 | 1.3314 | 1.3318 | 31964100.0 |
| 2005-06-28 16:00:00 | AAPL | Stock | 1.3325 | 1.3357 | 1.3218 | 1.3232 | 3366272.0 |
| 2005-06-28 16:30:00 | AAPL | Stock | 1.33 | 1.33 | 1.3161 | 1.3214 | 2233672.0 |
| 2005-06-28 17:00:00 | AAPL | Stock | 1.3214 | 1.3344 | 1.3175 | 1.3218 | 378336.0 |
| 2005-06-28 17:30:00 | AAPL | Stock | 1.3218 | 1.3254 | 1.3211 | 1.3211 | 191212.0 |
| 2005-06-28 18:00:00 | AAPL | Stock | 1.3211 | 1.3214 | 1.3211 | 1.3214 | 173600.0 |
| 2005-06-28 08:00:00 | MSFT | Stock | 25.13 | 25.2 | 25.1 | 25.2 | 27294.0 |
| 2005-06-28 08:30:00 | MSFT | Stock | 25.19 | 25.2 | 25.12 | 25.17 | 50386.0 |
| 2005-06-28 09:00:00 | MSFT | Stock | 25.15 | 25.16 | 25.05 | 25.08 | 1380301.0 |
| 2005-06-28 09:30:00 | MSFT | Stock | 25.09 | 25.12 | 25.04 | 25.09 | 6450441.0 |
| 2005-06-28 10:00:00 | MSFT | Stock | 25.09 | 25.12 | 25.07 | 25.07 | 3491903.0 |
| 2005-06-28 10:30:00 | MSFT | Stock | 25.07 | 25.12 | 25.029 | 25.05 | 4647853.0 |
| 2005-06-28 11:00:00 | MSFT | Stock | 25.04 | 25.1 | 25.04 | 25.08 | 4125954.0 |
| 2005-06-28 11:30:00 | MSFT | Stock | 25.08 | 25.12 | 25.07 | 25.08 | 2853945.0 |
| 2005-06-28 12:00:00 | MSFT | Stock | 25.08 | 25.11 | 25.041 | 25.071 | 1876094.0 |
| 2005-06-28 12:30:00 | MSFT | Stock | 25.07 | 25.09 | 25.06 | 25.08 | 2137441.0 |
| 2005-06-28 13:00:00 | MSFT | Stock | 25.08 | 25.13 | 25.07 | 25.12 | 2283507.0 |
| 2005-06-28 13:30:00 | MSFT | Stock | 25.12 | 25.12 | 25.07 | 25.07 | 1877254.0 |
| 2005-06-28 14:00:00 | MSFT | Stock | 25.07 | 25.09 | 25.04 | 25.05 | 2024422.0 |
| 2005-06-28 14:30:00 | MSFT | Stock | 25.06 | 25.12 | 25.05 | 25.09 | 4147142.0 |
| 2005-06-28 15:00:00 | MSFT | Stock | 25.1 | 25.15 | 25.09 | 25.13 | 5656906.0 |
| 2005-06-28 15:30:00 | MSFT | Stock | 25.13 | 25.2 | 25.07 | 25.07 | 8399486.0 |
| 2005-06-28 16:00:00 | MSFT | Stock | 25.09 | 25.14 | 25.06 | 25.08 | 425470.0 |
| 2005-06-28 16:30:00 | MSFT | Stock | 25.11 | 25.13 | 25.035 | 25.1 | 32768.0 |
| 2005-06-28 17:00:00 | MSFT | Stock | 25.09 | 25.13 | 25.09 | 25.1 | 8020.0 |
| 2005-06-28 17:30:00 | MSFT | Stock | 25.1 | 25.13 | 25.07 | 25.1 | 24110.0 |
| 2005-06-28 18:00:00 | MSFT | Stock | 25.1 | 25.12 | 25.08 | 25.08 | 21900.0 |
| 2005-06-28 08:30:00 | NVDA | Stock | 0.2262 | 0.2263 | 0.2262 | 0.2263 | 72000.0 |
| 2005-06-28 09:00:00 | NVDA | Stock | 0.2254 | 0.2254 | 0.2246 | 0.2246 | 60000.0 |
| 2005-06-28 09:30:00 | NVDA | Stock | 0.2248 | 0.2268 | 0.2247 | 0.2262 | 33373200.0 |
| 2005-06-28 10:00:00 | NVDA | Stock | 0.2262 | 0.2267 | 0.2252 | 0.2255 | 22545240.0 |
| 2005-06-28 10:30:00 | NVDA | Stock | 0.2255 | 0.2262 | 0.2251 | 0.2252 | 14359320.0 |
| 2005-06-28 11:00:00 | NVDA | Stock | 0.2252 | 0.2257 | 0.2247 | 0.2248 | 12115440.0 |
| 2005-06-28 11:30:00 | NVDA | Stock | 0.2248 | 0.2258 | 0.2246 | 0.2247 | 13726920.0 |
| 2005-06-28 12:00:00 | NVDA | Stock | 0.2247 | 0.2247 | 0.224 | 0.2241 | 12823080.0 |
> showing 50 of 46,590 rows — these rows as CSV