PREVIEW / stock_30min / 2007-07-26
file: by_date/stock_30min/2007/2007-07-26.parquet size: 1.2 MB rows: 66,959 symbols: 3,110
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-26 09:30:00 | AAPL | Stock | 5.2111 | 5.2679 | 5.0732 | 5.22 | 354548488.0 |
| 2007-07-26 10:00:00 | AAPL | Stock | 5.2204 | 5.2511 | 5.1921 | 5.2271 | 206052980.0 |
| 2007-07-26 10:30:00 | AAPL | Stock | 5.2271 | 5.3036 | 5.2196 | 5.2929 | 204146404.0 |
| 2007-07-26 11:00:00 | AAPL | Stock | 5.2929 | 5.2957 | 5.2275 | 5.2436 | 155361668.0 |
| 2007-07-26 11:30:00 | AAPL | Stock | 5.2439 | 5.2732 | 5.2179 | 5.2679 | 117522636.0 |
| 2007-07-26 12:00:00 | AAPL | Stock | 5.2686 | 5.2746 | 5.2293 | 5.2418 | 81536448.0 |
| 2007-07-26 12:30:00 | AAPL | Stock | 5.2421 | 5.2454 | 5.1643 | 5.2196 | 136533320.0 |
| 2007-07-26 13:00:00 | AAPL | Stock | 5.2218 | 5.225 | 5.1786 | 5.1886 | 79748760.0 |
| 2007-07-26 13:30:00 | AAPL | Stock | 5.1886 | 5.2014 | 5.1357 | 5.1382 | 103902036.0 |
| 2007-07-26 14:00:00 | AAPL | Stock | 5.1382 | 5.1521 | 5.0732 | 5.1068 | 159460056.0 |
| 2007-07-26 14:30:00 | AAPL | Stock | 5.1071 | 5.1661 | 5.0982 | 5.1596 | 121848132.0 |
| 2007-07-26 15:00:00 | AAPL | Stock | 5.1596 | 5.2136 | 5.1471 | 5.1782 | 130948300.0 |
| 2007-07-26 15:30:00 | AAPL | Stock | 5.1786 | 5.2411 | 5.1425 | 5.2389 | 163595236.0 |
| 2007-07-26 16:00:00 | AAPL | Stock | 5.2389 | 5.2389 | 5.2143 | 5.2143 | 26851188.0 |
| 2007-07-26 09:30:00 | MSFT | Stock | 30.24 | 30.471 | 30.12 | 30.33 | 6483606.0 |
| 2007-07-26 10:00:00 | MSFT | Stock | 30.33 | 30.52 | 30.24 | 30.42 | 4850947.0 |
| 2007-07-26 10:30:00 | MSFT | Stock | 30.42 | 30.53 | 30.34 | 30.42 | 3030307.0 |
| 2007-07-26 11:00:00 | MSFT | Stock | 30.42 | 30.43 | 30.09 | 30.12 | 4293664.0 |
| 2007-07-26 11:30:00 | MSFT | Stock | 30.13 | 30.18 | 30.04 | 30.17 | 4387855.0 |
| 2007-07-26 12:00:00 | MSFT | Stock | 30.17 | 30.17 | 29.95 | 30.0 | 4013445.0 |
| 2007-07-26 12:30:00 | MSFT | Stock | 29.99 | 30.02 | 29.8 | 29.96 | 6197032.0 |
| 2007-07-26 13:00:00 | MSFT | Stock | 29.96 | 30.0 | 29.81 | 29.88 | 4067710.0 |
| 2007-07-26 13:30:00 | MSFT | Stock | 29.88 | 29.95 | 29.75 | 29.772 | 4325367.0 |
| 2007-07-26 14:00:00 | MSFT | Stock | 29.78 | 29.85 | 29.61 | 29.71 | 5056218.0 |
| 2007-07-26 14:30:00 | MSFT | Stock | 29.72 | 29.87 | 29.51 | 29.73 | 6384345.0 |
| 2007-07-26 15:00:00 | MSFT | Stock | 29.73 | 30.01 | 29.66 | 29.8 | 6847377.0 |
| 2007-07-26 15:30:00 | MSFT | Stock | 29.79 | 30.11 | 29.72 | 30.07 | 12952401.0 |
| 2007-07-26 16:00:00 | MSFT | Stock | 30.08 | 30.08 | 29.98 | 29.98 | 4435962.0 |
| 2007-07-26 08:00:00 | NVDA | Stock | 0.726 | 0.7267 | 0.726 | 0.7262 | 111000.0 |
| 2007-07-26 08:30:00 | NVDA | Stock | 0.7257 | 0.728 | 0.7242 | 0.7242 | 379500.0 |
| 2007-07-26 09:00:00 | NVDA | Stock | 0.724 | 0.7283 | 0.7217 | 0.7278 | 396000.0 |
| 2007-07-26 09:30:00 | NVDA | Stock | 0.7278 | 0.7333 | 0.7232 | 0.7313 | 44886780.0 |
| 2007-07-26 10:00:00 | NVDA | Stock | 0.7315 | 0.7412 | 0.7288 | 0.741 | 57300900.0 |
| 2007-07-26 10:30:00 | NVDA | Stock | 0.741 | 0.7497 | 0.7403 | 0.7472 | 51819540.0 |
| 2007-07-26 11:00:00 | NVDA | Stock | 0.747 | 0.747 | 0.726 | 0.7325 | 72634980.0 |
| 2007-07-26 11:30:00 | NVDA | Stock | 0.7327 | 0.7348 | 0.7271 | 0.7338 | 37503720.0 |
| 2007-07-26 12:00:00 | NVDA | Stock | 0.7335 | 0.7342 | 0.7258 | 0.73 | 26075040.0 |
| 2007-07-26 12:30:00 | NVDA | Stock | 0.73 | 0.7313 | 0.7212 | 0.7275 | 46093500.0 |
| 2007-07-26 13:00:00 | NVDA | Stock | 0.7272 | 0.729 | 0.723 | 0.7263 | 26045040.0 |
| 2007-07-26 13:30:00 | NVDA | Stock | 0.7267 | 0.7337 | 0.7247 | 0.7328 | 58709880.0 |
| 2007-07-26 14:00:00 | NVDA | Stock | 0.7327 | 0.7358 | 0.7227 | 0.7262 | 48759720.0 |
| 2007-07-26 14:30:00 | NVDA | Stock | 0.7262 | 0.7293 | 0.718 | 0.7292 | 53608500.0 |
| 2007-07-26 15:00:00 | NVDA | Stock | 0.7293 | 0.7358 | 0.7233 | 0.7337 | 55621920.0 |
| 2007-07-26 15:30:00 | NVDA | Stock | 0.7335 | 0.7417 | 0.7308 | 0.7417 | 76746180.0 |
| 2007-07-26 16:00:00 | NVDA | Stock | 0.7417 | 0.745 | 0.7367 | 0.745 | 17990100.0 |
| 2007-07-26 16:30:00 | NVDA | Stock | 0.745 | 0.745 | 0.7367 | 0.7367 | 386640.0 |
| 2007-07-26 17:00:00 | NVDA | Stock | 0.7367 | 0.7393 | 0.7325 | 0.7335 | 1047720.0 |
| 2007-07-26 17:30:00 | NVDA | Stock | 0.7325 | 0.7325 | 0.7313 | 0.7313 | 322500.0 |
| 2007-07-26 18:30:00 | NVDA | Stock | 0.7315 | 0.7345 | 0.7315 | 0.7345 | 58200.0 |
| 2007-07-26 05:00:00 | AMZN | Stock | 4.31 | 4.31 | 4.31 | 4.31 | 3900.0 |
> showing 50 of 66,959 rows — these rows as CSV