PREVIEW / stock_1hour / 2007-07-03
file: by_date/stock_1hour/2007/2007-07-03.parquet size: 517 KB rows: 22,812 symbols: 2,990
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-03 09:00:00 | AAPL | Stock | 4.3571 | 4.3746 | 4.3393 | 4.3725 | 126419692.0 |
| 2007-07-03 10:00:00 | AAPL | Stock | 4.3721 | 4.5443 | 4.3661 | 4.5296 | 540448216.0 |
| 2007-07-03 11:00:00 | AAPL | Stock | 4.5296 | 4.5343 | 4.4946 | 4.5243 | 226090592.0 |
| 2007-07-03 12:00:00 | AAPL | Stock | 4.5239 | 4.55 | 4.5054 | 4.5407 | 227140564.0 |
| 2007-07-03 13:00:00 | AAPL | Stock | 4.5418 | 4.5421 | 4.5404 | 4.5418 | 7394492.0 |
| 2007-07-03 09:00:00 | MSFT | Stock | 29.785 | 30.0 | 29.78 | 29.99 | 8846050.0 |
| 2007-07-03 10:00:00 | MSFT | Stock | 29.98 | 30.22 | 29.97 | 30.11 | 9389723.0 |
| 2007-07-03 11:00:00 | MSFT | Stock | 30.1 | 30.12 | 30.03 | 30.05 | 4701264.0 |
| 2007-07-03 12:00:00 | MSFT | Stock | 30.04 | 30.13 | 29.99 | 30.04 | 5596077.0 |
| 2007-07-03 13:00:00 | MSFT | Stock | 30.02 | 30.02 | 30.02 | 30.02 | 837275.0 |
| 2007-07-03 08:00:00 | NVDA | Stock | 0.7213 | 0.7213 | 0.7213 | 0.7213 | 54000.0 |
| 2007-07-03 09:00:00 | NVDA | Stock | 0.7213 | 0.7238 | 0.7108 | 0.7238 | 49482360.0 |
| 2007-07-03 10:00:00 | NVDA | Stock | 0.7238 | 0.724 | 0.7152 | 0.7152 | 64303560.0 |
| 2007-07-03 11:00:00 | NVDA | Stock | 0.715 | 0.7168 | 0.7125 | 0.7163 | 60886980.0 |
| 2007-07-03 12:00:00 | NVDA | Stock | 0.7163 | 0.7183 | 0.716 | 0.7183 | 55727640.0 |
| 2007-07-03 13:00:00 | NVDA | Stock | 0.7178 | 0.7183 | 0.7178 | 0.7183 | 3094080.0 |
| 2007-07-03 08:00:00 | AMZN | Stock | 3.4945 | 3.4945 | 3.4805 | 3.4895 | 64320.0 |
| 2007-07-03 09:00:00 | AMZN | Stock | 3.4925 | 3.5095 | 3.467 | 3.4845 | 10214340.0 |
| 2007-07-03 10:00:00 | AMZN | Stock | 3.4845 | 3.486 | 3.453 | 3.453 | 15006680.0 |
| 2007-07-03 11:00:00 | AMZN | Stock | 3.453 | 3.469 | 3.451 | 3.463 | 8171680.0 |
| 2007-07-03 12:00:00 | AMZN | Stock | 3.4635 | 3.4725 | 3.459 | 3.4725 | 8512740.0 |
| 2007-07-03 13:00:00 | AMZN | Stock | 3.4725 | 3.4725 | 3.4725 | 3.4725 | 1431660.0 |
| 2007-07-03 16:00:00 | AMZN | Stock | 3.4725 | 3.4725 | 3.4725 | 3.4725 | 3000.0 |
| 2007-07-03 09:00:00 | TLT | Stock | 85.25 | 85.34 | 85.15 | 85.25 | 202400.0 |
| 2007-07-03 10:00:00 | TLT | Stock | 85.26 | 85.34 | 84.85 | 84.85 | 196545.0 |
| 2007-07-03 11:00:00 | TLT | Stock | 84.84 | 84.9 | 84.75 | 84.76 | 530930.0 |
| 2007-07-03 12:00:00 | TLT | Stock | 84.75 | 84.8 | 84.71 | 84.75 | 346000.0 |
| 2007-07-03 13:00:00 | TLT | Stock | 84.75 | 84.77 | 84.72 | 84.77 | 76300.0 |
| 2007-07-03 09:00:00 | CL | Stock | 32.7 | 32.745 | 32.645 | 32.72 | 400000.0 |
| 2007-07-03 10:00:00 | CL | Stock | 32.715 | 32.735 | 32.65 | 32.735 | 912800.0 |
| 2007-07-03 11:00:00 | CL | Stock | 32.73 | 32.74 | 32.69 | 32.72 | 941200.0 |
| 2007-07-03 12:00:00 | CL | Stock | 32.73 | 32.86 | 32.72 | 32.805 | 1037000.0 |
| 2007-07-03 13:00:00 | CL | Stock | 32.79 | 32.79 | 32.79 | 32.79 | 74600.0 |
> showing 33 of 22,812 rows — these rows as CSV