PREVIEW / stock_30min / 2007-07-11
file: by_date/stock_30min/2007/2007-07-11.parquet size: 1.1 MB rows: 64,527 symbols: 3,077
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-11 09:30:00 | AAPL | Stock | 4.7168 | 4.7407 | 4.6896 | 4.7189 | 141604624.0 |
| 2007-07-11 10:00:00 | AAPL | Stock | 4.7193 | 4.7618 | 4.7075 | 4.7514 | 94510052.0 |
| 2007-07-11 10:30:00 | AAPL | Stock | 4.7514 | 4.7704 | 4.7471 | 4.76 | 72176328.0 |
| 2007-07-11 11:00:00 | AAPL | Stock | 4.76 | 4.7696 | 4.7554 | 4.7661 | 46208624.0 |
| 2007-07-11 11:30:00 | AAPL | Stock | 4.7661 | 4.775 | 4.7518 | 4.7543 | 62231960.0 |
| 2007-07-11 12:00:00 | AAPL | Stock | 4.7543 | 4.7671 | 4.7518 | 4.7582 | 43518608.0 |
| 2007-07-11 12:30:00 | AAPL | Stock | 4.7582 | 4.7582 | 4.7332 | 4.7411 | 34291096.0 |
| 2007-07-11 13:00:00 | AAPL | Stock | 4.7411 | 4.7543 | 4.7375 | 4.7432 | 31884580.0 |
| 2007-07-11 13:30:00 | AAPL | Stock | 4.7432 | 4.7536 | 4.7289 | 4.7314 | 46143188.0 |
| 2007-07-11 14:00:00 | AAPL | Stock | 4.7314 | 4.7389 | 4.7229 | 4.7279 | 56743932.0 |
| 2007-07-11 14:30:00 | AAPL | Stock | 4.7275 | 4.7311 | 4.6986 | 4.7061 | 50310932.0 |
| 2007-07-11 15:00:00 | AAPL | Stock | 4.7061 | 4.7229 | 4.7036 | 4.7207 | 47885320.0 |
| 2007-07-11 15:30:00 | AAPL | Stock | 4.7207 | 4.7304 | 4.7164 | 4.7246 | 56140196.0 |
| 2007-07-11 16:00:00 | AAPL | Stock | 4.7246 | 4.7282 | 4.7246 | 4.7282 | 11141480.0 |
| 2007-07-11 09:30:00 | MSFT | Stock | 29.24 | 29.49 | 29.21 | 29.43 | 5317988.0 |
| 2007-07-11 10:00:00 | MSFT | Stock | 29.44 | 29.52 | 29.39 | 29.51 | 4929205.0 |
| 2007-07-11 10:30:00 | MSFT | Stock | 29.51 | 29.55 | 29.45 | 29.54 | 3310609.0 |
| 2007-07-11 11:00:00 | MSFT | Stock | 29.54 | 29.65 | 29.447 | 29.6 | 3701982.0 |
| 2007-07-11 11:30:00 | MSFT | Stock | 29.595 | 29.595 | 29.48 | 29.5 | 1771953.0 |
| 2007-07-11 12:00:00 | MSFT | Stock | 29.5 | 29.56 | 29.48 | 29.5 | 2521270.0 |
| 2007-07-11 12:30:00 | MSFT | Stock | 29.51 | 29.53 | 29.5 | 29.51 | 941996.0 |
| 2007-07-11 13:00:00 | MSFT | Stock | 29.51 | 29.55 | 29.51 | 29.53 | 1273086.0 |
| 2007-07-11 13:30:00 | MSFT | Stock | 29.53 | 29.64 | 29.53 | 29.58 | 2076436.0 |
| 2007-07-11 14:00:00 | MSFT | Stock | 29.57 | 29.63 | 29.53 | 29.595 | 2369313.0 |
| 2007-07-11 14:30:00 | MSFT | Stock | 29.59 | 29.62 | 29.44 | 29.481 | 2555303.0 |
| 2007-07-11 15:00:00 | MSFT | Stock | 29.48 | 29.58 | 29.46 | 29.57 | 2103276.0 |
| 2007-07-11 15:30:00 | MSFT | Stock | 29.57 | 29.59 | 29.44 | 29.5 | 6176250.0 |
| 2007-07-11 16:00:00 | MSFT | Stock | 29.49 | 29.5 | 29.49 | 29.49 | 1685680.0 |
| 2007-07-11 09:00:00 | NVDA | Stock | 0.7582 | 0.7582 | 0.7567 | 0.7578 | 252000.0 |
| 2007-07-11 09:30:00 | NVDA | Stock | 0.7578 | 0.763 | 0.748 | 0.7483 | 51295020.0 |
| 2007-07-11 10:00:00 | NVDA | Stock | 0.7482 | 0.7538 | 0.7463 | 0.7505 | 66109920.0 |
| 2007-07-11 10:30:00 | NVDA | Stock | 0.7503 | 0.7527 | 0.7467 | 0.7467 | 62623740.0 |
| 2007-07-11 11:00:00 | NVDA | Stock | 0.7467 | 0.7502 | 0.7442 | 0.7492 | 40340280.0 |
| 2007-07-11 11:30:00 | NVDA | Stock | 0.7493 | 0.7503 | 0.7473 | 0.7482 | 29739540.0 |
| 2007-07-11 12:00:00 | NVDA | Stock | 0.7482 | 0.7497 | 0.7477 | 0.7495 | 30026820.0 |
| 2007-07-11 12:30:00 | NVDA | Stock | 0.7497 | 0.7515 | 0.7483 | 0.7508 | 23158380.0 |
| 2007-07-11 13:00:00 | NVDA | Stock | 0.7508 | 0.7523 | 0.7498 | 0.7518 | 26920560.0 |
| 2007-07-11 13:30:00 | NVDA | Stock | 0.7518 | 0.7547 | 0.7517 | 0.7518 | 26915640.0 |
| 2007-07-11 14:00:00 | NVDA | Stock | 0.7518 | 0.7558 | 0.7517 | 0.7555 | 79502640.0 |
| 2007-07-11 14:30:00 | NVDA | Stock | 0.7555 | 0.7558 | 0.7492 | 0.751 | 42425460.0 |
| 2007-07-11 15:00:00 | NVDA | Stock | 0.751 | 0.7532 | 0.7508 | 0.7527 | 28034880.0 |
| 2007-07-11 15:30:00 | NVDA | Stock | 0.7527 | 0.7547 | 0.7515 | 0.7538 | 45343260.0 |
| 2007-07-11 16:00:00 | NVDA | Stock | 0.7545 | 0.7567 | 0.7542 | 0.7542 | 15171480.0 |
| 2007-07-11 16:30:00 | NVDA | Stock | 0.755 | 0.755 | 0.755 | 0.755 | 95400.0 |
| 2007-07-11 17:00:00 | NVDA | Stock | 0.755 | 0.755 | 0.7548 | 0.7548 | 60000.0 |
| 2007-07-11 17:30:00 | NVDA | Stock | 0.7548 | 0.7548 | 0.7548 | 0.7548 | 6000.0 |
| 2007-07-11 07:00:00 | AMZN | Stock | 3.513 | 3.513 | 3.513 | 3.513 | 8000.0 |
| 2007-07-11 07:30:00 | AMZN | Stock | 3.513 | 3.513 | 3.513 | 3.513 | 31060.0 |
| 2007-07-11 08:00:00 | AMZN | Stock | 3.5145 | 3.5145 | 3.5125 | 3.513 | 82000.0 |
| 2007-07-11 08:30:00 | AMZN | Stock | 3.5155 | 3.5155 | 3.515 | 3.515 | 4000.0 |
> showing 50 of 64,527 rows — these rows as CSV