PREVIEW / stock_30min / 2006-07-03
file: by_date/stock_30min/2006/2006-07-03.parquet size: 583 KB rows: 28,013 symbols: 2,241
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-07-03 08:00:00 | AAPL | Stock | 2.0525 | 2.0689 | 2.0525 | 2.0625 | 660520.0 |
| 2006-07-03 08:30:00 | AAPL | Stock | 2.0607 | 2.0625 | 2.0596 | 2.0625 | 133000.0 |
| 2006-07-03 09:00:00 | AAPL | Stock | 2.0625 | 2.0629 | 2.04 | 2.0514 | 657916.0 |
| 2006-07-03 09:30:00 | AAPL | Stock | 2.0543 | 2.0779 | 2.0479 | 2.0743 | 58577540.0 |
| 2006-07-03 10:00:00 | AAPL | Stock | 2.0739 | 2.0743 | 2.0543 | 2.07 | 32228952.0 |
| 2006-07-03 10:30:00 | AAPL | Stock | 2.07 | 2.0732 | 2.065 | 2.0689 | 18127144.0 |
| 2006-07-03 11:00:00 | AAPL | Stock | 2.0689 | 2.0743 | 2.0686 | 2.07 | 17731840.0 |
| 2006-07-03 11:30:00 | AAPL | Stock | 2.07 | 2.0736 | 2.0675 | 2.0693 | 11225144.0 |
| 2006-07-03 12:00:00 | AAPL | Stock | 2.0693 | 2.0732 | 2.0689 | 2.0714 | 15454348.0 |
| 2006-07-03 12:30:00 | AAPL | Stock | 2.0714 | 2.0721 | 2.0625 | 2.0696 | 35637336.0 |
| 2006-07-03 13:00:00 | AAPL | Stock | 2.07 | 2.07 | 2.0696 | 2.0696 | 708456.0 |
| 2006-07-03 07:00:00 | MSFT | Stock | 23.45 | 23.45 | 23.45 | 23.45 | 600.0 |
| 2006-07-03 08:00:00 | MSFT | Stock | 23.39 | 23.49 | 23.39 | 23.46 | 16620.0 |
| 2006-07-03 08:30:00 | MSFT | Stock | 23.46 | 23.48 | 23.3 | 23.3 | 15295.0 |
| 2006-07-03 09:00:00 | MSFT | Stock | 23.48 | 23.54 | 23.3 | 23.54 | 125260.0 |
| 2006-07-03 09:30:00 | MSFT | Stock | 23.53 | 23.65 | 23.45 | 23.582 | 4016188.0 |
| 2006-07-03 10:00:00 | MSFT | Stock | 23.58 | 23.6 | 23.57 | 23.57 | 2568465.0 |
| 2006-07-03 10:30:00 | MSFT | Stock | 23.57 | 23.62 | 23.57 | 23.62 | 2930608.0 |
| 2006-07-03 11:00:00 | MSFT | Stock | 23.61 | 23.63 | 23.6 | 23.6 | 1391293.0 |
| 2006-07-03 11:30:00 | MSFT | Stock | 23.61 | 23.63 | 23.58 | 23.6 | 3352136.0 |
| 2006-07-03 12:00:00 | MSFT | Stock | 23.6 | 23.65 | 23.59 | 23.63 | 3039858.0 |
| 2006-07-03 12:30:00 | MSFT | Stock | 23.63 | 23.72 | 23.622 | 23.68 | 7457432.0 |
| 2006-07-03 13:00:00 | MSFT | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 295203.0 |
| 2006-07-03 09:00:00 | NVDA | Stock | 0.358 | 0.3628 | 0.3577 | 0.3618 | 1316760.0 |
| 2006-07-03 09:30:00 | NVDA | Stock | 0.363 | 0.3633 | 0.3575 | 0.3587 | 33572700.0 |
| 2006-07-03 10:00:00 | NVDA | Stock | 0.3587 | 0.36 | 0.3585 | 0.3588 | 21988560.0 |
| 2006-07-03 10:30:00 | NVDA | Stock | 0.359 | 0.3603 | 0.3587 | 0.359 | 19299720.0 |
| 2006-07-03 11:00:00 | NVDA | Stock | 0.359 | 0.36 | 0.3578 | 0.358 | 18706320.0 |
| 2006-07-03 11:30:00 | NVDA | Stock | 0.358 | 0.3588 | 0.3577 | 0.358 | 15447000.0 |
| 2006-07-03 12:00:00 | NVDA | Stock | 0.358 | 0.3588 | 0.3577 | 0.3588 | 16023720.0 |
| 2006-07-03 12:30:00 | NVDA | Stock | 0.3588 | 0.3602 | 0.3587 | 0.3595 | 25805280.0 |
| 2006-07-03 13:00:00 | NVDA | Stock | 0.3595 | 0.36 | 0.3595 | 0.36 | 2793660.0 |
| 2006-07-03 08:00:00 | AMZN | Stock | 1.934 | 1.934 | 1.934 | 1.934 | 432000.0 |
| 2006-07-03 09:00:00 | AMZN | Stock | 1.934 | 1.9345 | 1.925 | 1.925 | 84740.0 |
| 2006-07-03 09:30:00 | AMZN | Stock | 1.926 | 1.931 | 1.919 | 1.919 | 4473640.0 |
| 2006-07-03 10:00:00 | AMZN | Stock | 1.9195 | 1.926 | 1.9115 | 1.912 | 3660720.0 |
| 2006-07-03 10:30:00 | AMZN | Stock | 1.912 | 1.9275 | 1.9115 | 1.9165 | 3815700.0 |
| 2006-07-03 11:00:00 | AMZN | Stock | 1.917 | 1.9185 | 1.9145 | 1.9165 | 3112280.0 |
| 2006-07-03 11:30:00 | AMZN | Stock | 1.9165 | 1.927 | 1.915 | 1.9265 | 3165340.0 |
| 2006-07-03 12:00:00 | AMZN | Stock | 1.9265 | 1.9305 | 1.9225 | 1.9235 | 3242560.0 |
| 2006-07-03 12:30:00 | AMZN | Stock | 1.9235 | 1.9308 | 1.923 | 1.9295 | 5288360.0 |
| 2006-07-03 13:00:00 | AMZN | Stock | 1.9305 | 1.9305 | 1.9305 | 1.9305 | 213220.0 |
| 2006-07-03 09:30:00 | CL | Stock | 29.635 | 29.77 | 29.635 | 29.745 | 550400.0 |
| 2006-07-03 10:00:00 | CL | Stock | 29.755 | 29.775 | 29.695 | 29.755 | 267000.0 |
| 2006-07-03 10:30:00 | CL | Stock | 29.76 | 29.825 | 29.755 | 29.825 | 165400.0 |
| 2006-07-03 11:00:00 | CL | Stock | 29.83 | 29.96 | 29.79 | 29.955 | 201200.0 |
| 2006-07-03 11:30:00 | CL | Stock | 29.96 | 29.985 | 29.955 | 29.965 | 210600.0 |
| 2006-07-03 12:00:00 | CL | Stock | 29.965 | 29.97 | 29.905 | 29.915 | 185400.0 |
| 2006-07-03 12:30:00 | CL | Stock | 29.915 | 29.975 | 29.905 | 29.97 | 205600.0 |
| 2006-07-03 13:00:00 | CL | Stock | 29.95 | 29.95 | 29.94 | 29.94 | 64600.0 |
> showing 50 of 28,013 rows — these rows as CSV