PREVIEW / stock_30min / 2007-07-12
file: by_date/stock_30min/2007/2007-07-12.parquet size: 1.1 MB rows: 64,639 symbols: 3,066
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-12 09:30:00 | AAPL | Stock | 4.7804 | 4.7943 | 4.75 | 4.7589 | 165722900.0 |
| 2007-07-12 10:00:00 | AAPL | Stock | 4.7586 | 4.7779 | 4.7521 | 4.7543 | 57852032.0 |
| 2007-07-12 10:30:00 | AAPL | Stock | 4.7536 | 4.7654 | 4.7429 | 4.7579 | 58460752.0 |
| 2007-07-12 11:00:00 | AAPL | Stock | 4.7575 | 4.7661 | 4.75 | 4.7557 | 27991992.0 |
| 2007-07-12 11:30:00 | AAPL | Stock | 4.7554 | 4.7675 | 4.7282 | 4.7523 | 36557640.0 |
| 2007-07-12 12:00:00 | AAPL | Stock | 4.7521 | 4.7711 | 4.7518 | 4.7602 | 37376136.0 |
| 2007-07-12 12:30:00 | AAPL | Stock | 4.76 | 4.7643 | 4.7464 | 4.7521 | 37130660.0 |
| 2007-07-12 13:00:00 | AAPL | Stock | 4.7525 | 4.7639 | 4.7514 | 4.7554 | 20135360.0 |
| 2007-07-12 13:30:00 | AAPL | Stock | 4.7554 | 4.7668 | 4.7518 | 4.7625 | 24917760.0 |
| 2007-07-12 14:00:00 | AAPL | Stock | 4.7618 | 4.7675 | 4.7571 | 4.7589 | 28898464.0 |
| 2007-07-12 14:30:00 | AAPL | Stock | 4.7593 | 4.7625 | 4.7557 | 4.7596 | 21475720.0 |
| 2007-07-12 15:00:00 | AAPL | Stock | 4.7593 | 4.7768 | 4.7579 | 4.7754 | 54485396.0 |
| 2007-07-12 15:30:00 | AAPL | Stock | 4.7757 | 4.7896 | 4.7739 | 4.7893 | 95402188.0 |
| 2007-07-12 16:00:00 | AAPL | Stock | 4.7893 | 4.7893 | 4.7861 | 4.7882 | 11067504.0 |
| 2007-07-12 09:30:00 | MSFT | Stock | 29.56 | 29.67 | 29.44 | 29.64 | 3435987.0 |
| 2007-07-12 10:00:00 | MSFT | Stock | 29.64 | 29.67 | 29.55 | 29.55 | 2880037.0 |
| 2007-07-12 10:30:00 | MSFT | Stock | 29.55 | 29.67 | 29.55 | 29.61 | 2315913.0 |
| 2007-07-12 11:00:00 | MSFT | Stock | 29.61 | 29.66 | 29.59 | 29.61 | 1920169.0 |
| 2007-07-12 11:30:00 | MSFT | Stock | 29.61 | 29.66 | 29.49 | 29.6 | 1909758.0 |
| 2007-07-12 12:00:00 | MSFT | Stock | 29.61 | 29.7 | 29.6 | 29.69 | 2953516.0 |
| 2007-07-12 12:30:00 | MSFT | Stock | 29.69 | 29.7 | 29.59 | 29.63 | 2501628.0 |
| 2007-07-12 13:00:00 | MSFT | Stock | 29.63 | 29.641 | 29.58 | 29.6 | 2000161.0 |
| 2007-07-12 13:30:00 | MSFT | Stock | 29.6 | 29.69 | 29.59 | 29.62 | 2590401.0 |
| 2007-07-12 14:00:00 | MSFT | Stock | 29.63 | 29.72 | 29.62 | 29.69 | 3823446.0 |
| 2007-07-12 14:30:00 | MSFT | Stock | 29.7 | 29.8 | 29.68 | 29.8 | 3481716.0 |
| 2007-07-12 15:00:00 | MSFT | Stock | 29.79 | 29.99 | 29.78 | 29.98 | 7597218.0 |
| 2007-07-12 15:30:00 | MSFT | Stock | 29.99 | 30.1 | 29.97 | 30.1 | 11805806.0 |
| 2007-07-12 16:00:00 | MSFT | Stock | 30.1 | 30.11 | 30.07 | 30.07 | 2053616.0 |
| 2007-07-12 08:30:00 | NVDA | Stock | 0.7583 | 0.7608 | 0.7583 | 0.7583 | 24840.0 |
| 2007-07-12 09:00:00 | NVDA | Stock | 0.7567 | 0.7593 | 0.7567 | 0.7593 | 102000.0 |
| 2007-07-12 09:30:00 | NVDA | Stock | 0.76 | 0.7633 | 0.7568 | 0.7612 | 35409840.0 |
| 2007-07-12 10:00:00 | NVDA | Stock | 0.761 | 0.7615 | 0.7558 | 0.7588 | 26066520.0 |
| 2007-07-12 10:30:00 | NVDA | Stock | 0.7588 | 0.761 | 0.7583 | 0.7595 | 31569660.0 |
| 2007-07-12 11:00:00 | NVDA | Stock | 0.7597 | 0.7625 | 0.759 | 0.7617 | 24616380.0 |
| 2007-07-12 11:30:00 | NVDA | Stock | 0.7617 | 0.7642 | 0.7547 | 0.7638 | 30188520.0 |
| 2007-07-12 12:00:00 | NVDA | Stock | 0.764 | 0.769 | 0.7637 | 0.7688 | 32074080.0 |
| 2007-07-12 12:30:00 | NVDA | Stock | 0.7688 | 0.7688 | 0.7655 | 0.7668 | 20402760.0 |
| 2007-07-12 13:00:00 | NVDA | Stock | 0.7668 | 0.768 | 0.7653 | 0.768 | 11691960.0 |
| 2007-07-12 13:30:00 | NVDA | Stock | 0.768 | 0.7697 | 0.7667 | 0.7673 | 19572960.0 |
| 2007-07-12 14:00:00 | NVDA | Stock | 0.7673 | 0.768 | 0.7667 | 0.768 | 19348260.0 |
| 2007-07-12 14:30:00 | NVDA | Stock | 0.768 | 0.7688 | 0.7673 | 0.7688 | 28755420.0 |
| 2007-07-12 15:00:00 | NVDA | Stock | 0.7688 | 0.77 | 0.7683 | 0.7692 | 34137960.0 |
| 2007-07-12 15:30:00 | NVDA | Stock | 0.7692 | 0.7698 | 0.768 | 0.7698 | 94071120.0 |
| 2007-07-12 16:00:00 | NVDA | Stock | 0.7698 | 0.7698 | 0.7585 | 0.7667 | 18546960.0 |
| 2007-07-12 16:30:00 | NVDA | Stock | 0.7667 | 0.7698 | 0.7667 | 0.7667 | 121680.0 |
| 2007-07-12 17:00:00 | NVDA | Stock | 0.7663 | 0.7663 | 0.7657 | 0.7657 | 18000.0 |
| 2007-07-12 19:30:00 | NVDA | Stock | 0.7647 | 0.7647 | 0.7645 | 0.7645 | 37200.0 |
| 2007-07-12 08:30:00 | AMZN | Stock | 3.554 | 3.555 | 3.5525 | 3.5525 | 30340.0 |
| 2007-07-12 09:00:00 | AMZN | Stock | 3.555 | 3.5655 | 3.555 | 3.562 | 160200.0 |
| 2007-07-12 09:30:00 | AMZN | Stock | 3.5655 | 3.6785 | 3.561 | 3.6715 | 57899580.0 |
> showing 50 of 64,639 rows — these rows as CSV