PREVIEW / stock_30min / 2006-10-20
file: by_date/stock_30min/2006/2006-10-20.parquet size: 918 KB rows: 49,900 symbols: 2,390
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 |
|---|---|---|---|---|---|---|---|
| 2006-10-20 07:30:00 | AAPL | Stock | 2.8268 | 2.8314 | 2.8211 | 2.8211 | 49000.0 |
| 2006-10-20 08:00:00 | AAPL | Stock | 2.8268 | 2.8321 | 2.8214 | 2.8214 | 1681428.0 |
| 2006-10-20 08:30:00 | AAPL | Stock | 2.825 | 2.825 | 2.815 | 2.8196 | 480396.0 |
| 2006-10-20 09:00:00 | AAPL | Stock | 2.8179 | 2.8293 | 2.8146 | 2.8204 | 2159024.0 |
| 2006-10-20 09:30:00 | AAPL | Stock | 2.8204 | 2.8425 | 2.8096 | 2.8189 | 135057720.0 |
| 2006-10-20 10:00:00 | AAPL | Stock | 2.8196 | 2.8371 | 2.8179 | 2.8339 | 62105148.0 |
| 2006-10-20 10:30:00 | AAPL | Stock | 2.8336 | 2.8418 | 2.8304 | 2.8375 | 52736656.0 |
| 2006-10-20 11:00:00 | AAPL | Stock | 2.8379 | 2.8393 | 2.8279 | 2.8296 | 38173912.0 |
| 2006-10-20 11:30:00 | AAPL | Stock | 2.8295 | 2.8461 | 2.8289 | 2.8421 | 36751680.0 |
| 2006-10-20 12:00:00 | AAPL | Stock | 2.8418 | 2.8436 | 2.8379 | 2.8411 | 22357188.0 |
| 2006-10-20 12:30:00 | AAPL | Stock | 2.8411 | 2.8443 | 2.8382 | 2.8386 | 24016664.0 |
| 2006-10-20 13:00:00 | AAPL | Stock | 2.8386 | 2.8414 | 2.8361 | 2.8411 | 28401772.0 |
| 2006-10-20 13:30:00 | AAPL | Stock | 2.8411 | 2.8418 | 2.8375 | 2.8389 | 29259664.0 |
| 2006-10-20 14:00:00 | AAPL | Stock | 2.8386 | 2.8418 | 2.8375 | 2.8386 | 29204840.0 |
| 2006-10-20 14:30:00 | AAPL | Stock | 2.8387 | 2.8411 | 2.8386 | 2.8393 | 20130208.0 |
| 2006-10-20 15:00:00 | AAPL | Stock | 2.8395 | 2.8532 | 2.8393 | 2.8515 | 55993840.0 |
| 2006-10-20 15:30:00 | AAPL | Stock | 2.8521 | 2.8568 | 2.8504 | 2.8554 | 86534700.0 |
| 2006-10-20 16:00:00 | AAPL | Stock | 2.8554 | 2.8571 | 2.85 | 2.8554 | 3189312.0 |
| 2006-10-20 16:30:00 | AAPL | Stock | 2.8554 | 2.8564 | 2.8543 | 2.8554 | 695128.0 |
| 2006-10-20 17:00:00 | AAPL | Stock | 2.8554 | 2.8561 | 2.8554 | 2.8554 | 124572.0 |
| 2006-10-20 17:30:00 | AAPL | Stock | 2.8561 | 2.8564 | 2.8536 | 2.8536 | 136024.0 |
| 2006-10-20 18:00:00 | AAPL | Stock | 2.8568 | 2.8571 | 2.8546 | 2.8571 | 95452.0 |
| 2006-10-20 18:30:00 | AAPL | Stock | 2.8546 | 2.8571 | 2.8546 | 2.8554 | 137256.0 |
| 2006-10-20 07:30:00 | MSFT | Stock | 28.4 | 28.42 | 28.4 | 28.42 | 800.0 |
| 2006-10-20 08:00:00 | MSFT | Stock | 28.41 | 28.42 | 28.38 | 28.38 | 3700.0 |
| 2006-10-20 08:30:00 | MSFT | Stock | 28.39 | 28.42 | 28.37 | 28.4 | 4030.0 |
| 2006-10-20 09:00:00 | MSFT | Stock | 28.38 | 28.48 | 28.31 | 28.47 | 584690.0 |
| 2006-10-20 09:30:00 | MSFT | Stock | 28.48 | 28.48 | 28.17 | 28.29 | 11323238.0 |
| 2006-10-20 10:00:00 | MSFT | Stock | 28.29 | 28.35 | 28.27 | 28.33 | 3352986.0 |
| 2006-10-20 10:30:00 | MSFT | Stock | 28.33 | 28.37 | 28.269 | 28.37 | 2629271.0 |
| 2006-10-20 11:00:00 | MSFT | Stock | 28.367 | 28.43 | 28.35 | 28.42 | 3520039.0 |
| 2006-10-20 11:30:00 | MSFT | Stock | 28.43 | 28.47 | 28.392 | 28.41 | 3827739.0 |
| 2006-10-20 12:00:00 | MSFT | Stock | 28.41 | 28.41 | 28.37 | 28.393 | 1648668.0 |
| 2006-10-20 12:30:00 | MSFT | Stock | 28.39 | 28.47 | 28.39 | 28.4 | 1687337.0 |
| 2006-10-20 13:00:00 | MSFT | Stock | 28.4 | 28.43 | 28.36 | 28.43 | 1841330.0 |
| 2006-10-20 13:30:00 | MSFT | Stock | 28.429 | 28.45 | 28.37 | 28.38 | 1915023.0 |
| 2006-10-20 14:00:00 | MSFT | Stock | 28.38 | 28.48 | 28.38 | 28.48 | 2166532.0 |
| 2006-10-20 14:30:00 | MSFT | Stock | 28.471 | 28.49 | 28.44 | 28.44 | 2887891.0 |
| 2006-10-20 15:00:00 | MSFT | Stock | 28.449 | 28.47 | 28.37 | 28.381 | 3692902.0 |
| 2006-10-20 15:30:00 | MSFT | Stock | 28.39 | 28.43 | 28.37 | 28.43 | 3702332.0 |
| 2006-10-20 16:00:00 | MSFT | Stock | 28.42 | 28.43 | 28.38 | 28.4 | 1336385.0 |
| 2006-10-20 16:30:00 | MSFT | Stock | 28.43 | 28.43 | 28.41 | 28.41 | 20461.0 |
| 2006-10-20 17:00:00 | MSFT | Stock | 28.41 | 28.41 | 28.41 | 28.41 | 4200.0 |
| 2006-10-20 17:30:00 | MSFT | Stock | 28.296 | 28.43 | 28.296 | 28.43 | 17906.0 |
| 2006-10-20 18:00:00 | MSFT | Stock | 28.4 | 28.4 | 28.4 | 28.4 | 1000.0 |
| 2006-10-20 08:00:00 | NVDA | Stock | 0.5417 | 0.5417 | 0.5417 | 0.5417 | 9960.0 |
| 2006-10-20 09:00:00 | NVDA | Stock | 0.5378 | 0.54 | 0.5378 | 0.54 | 814560.0 |
| 2006-10-20 09:30:00 | NVDA | Stock | 0.5402 | 0.5405 | 0.5258 | 0.531 | 67655820.0 |
| 2006-10-20 10:00:00 | NVDA | Stock | 0.531 | 0.5355 | 0.5263 | 0.5263 | 31802220.0 |
| 2006-10-20 10:30:00 | NVDA | Stock | 0.5262 | 0.527 | 0.523 | 0.526 | 35580780.0 |
> showing 50 of 49,900 rows — these rows as CSV