PREVIEW / stock_30min / 2007-05-22
file: by_date/stock_30min/2007/2007-05-22.parquet size: 1.1 MB rows: 63,268 symbols: 3,019
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-05-22 09:30:00 | AAPL | Stock | 4.0175 | 4.0314 | 4.0071 | 4.02 | 75114704.0 |
| 2007-05-22 10:00:00 | AAPL | Stock | 4.02 | 4.0268 | 4.0057 | 4.0196 | 59972192.0 |
| 2007-05-22 10:30:00 | AAPL | Stock | 4.0193 | 4.0268 | 4.0136 | 4.0261 | 36817200.0 |
| 2007-05-22 11:00:00 | AAPL | Stock | 4.0261 | 4.0286 | 4.0121 | 4.0164 | 33275424.0 |
| 2007-05-22 11:30:00 | AAPL | Stock | 4.0161 | 4.0193 | 4.0004 | 4.0071 | 33802580.0 |
| 2007-05-22 12:00:00 | AAPL | Stock | 4.0064 | 4.0257 | 4.0057 | 4.0196 | 24527104.0 |
| 2007-05-22 12:30:00 | AAPL | Stock | 4.0196 | 4.0289 | 4.0136 | 4.0282 | 29485792.0 |
| 2007-05-22 13:00:00 | AAPL | Stock | 4.0286 | 4.0382 | 4.0196 | 4.0318 | 37499392.0 |
| 2007-05-22 13:30:00 | AAPL | Stock | 4.0321 | 4.0425 | 4.0243 | 4.0368 | 36835624.0 |
| 2007-05-22 14:00:00 | AAPL | Stock | 4.0367 | 4.0514 | 4.0336 | 4.0466 | 40829740.0 |
| 2007-05-22 14:30:00 | AAPL | Stock | 4.0464 | 4.0554 | 4.0329 | 4.0525 | 45857868.0 |
| 2007-05-22 15:00:00 | AAPL | Stock | 4.0529 | 4.0625 | 4.045 | 4.0504 | 42114884.0 |
| 2007-05-22 15:30:00 | AAPL | Stock | 4.0504 | 4.0593 | 4.0475 | 4.0543 | 45618496.0 |
| 2007-05-22 16:00:00 | AAPL | Stock | 4.055 | 4.0554 | 4.055 | 4.055 | 4024916.0 |
| 2007-05-22 09:30:00 | MSFT | Stock | 30.9 | 30.93 | 30.81 | 30.82 | 5601566.0 |
| 2007-05-22 10:00:00 | MSFT | Stock | 30.81 | 30.88 | 30.77 | 30.83 | 3408446.0 |
| 2007-05-22 10:30:00 | MSFT | Stock | 30.82 | 30.88 | 30.81 | 30.84 | 2448673.0 |
| 2007-05-22 11:00:00 | MSFT | Stock | 30.838 | 30.87 | 30.76 | 30.841 | 2074014.0 |
| 2007-05-22 11:30:00 | MSFT | Stock | 30.84 | 30.86 | 30.79 | 30.812 | 2039225.0 |
| 2007-05-22 12:00:00 | MSFT | Stock | 30.82 | 30.83 | 30.78 | 30.83 | 986371.0 |
| 2007-05-22 12:30:00 | MSFT | Stock | 30.82 | 30.87 | 30.8 | 30.87 | 1498127.0 |
| 2007-05-22 13:00:00 | MSFT | Stock | 30.87 | 30.92 | 30.85 | 30.89 | 1947406.0 |
| 2007-05-22 13:30:00 | MSFT | Stock | 30.89 | 30.92 | 30.85 | 30.86 | 1842396.0 |
| 2007-05-22 14:00:00 | MSFT | Stock | 30.86 | 30.92 | 30.86 | 30.87 | 1650443.0 |
| 2007-05-22 14:30:00 | MSFT | Stock | 30.867 | 30.89 | 30.81 | 30.83 | 2093575.0 |
| 2007-05-22 15:00:00 | MSFT | Stock | 30.83 | 30.84 | 30.74 | 30.76 | 4269275.0 |
| 2007-05-22 15:30:00 | MSFT | Stock | 30.76 | 30.78 | 30.66 | 30.69 | 6874352.0 |
| 2007-05-22 16:00:00 | MSFT | Stock | 30.683 | 30.69 | 30.683 | 30.69 | 787304.0 |
| 2007-05-22 08:30:00 | NVDA | Stock | 0.5892 | 0.5892 | 0.5892 | 0.5892 | 12000.0 |
| 2007-05-22 09:00:00 | NVDA | Stock | 0.5883 | 0.5883 | 0.5858 | 0.5858 | 186000.0 |
| 2007-05-22 09:30:00 | NVDA | Stock | 0.586 | 0.5893 | 0.5843 | 0.5867 | 34746060.0 |
| 2007-05-22 10:00:00 | NVDA | Stock | 0.5863 | 0.5872 | 0.5775 | 0.5812 | 60805560.0 |
| 2007-05-22 10:30:00 | NVDA | Stock | 0.5812 | 0.5817 | 0.5765 | 0.5788 | 23652300.0 |
| 2007-05-22 11:00:00 | NVDA | Stock | 0.5788 | 0.5837 | 0.5785 | 0.5837 | 17210220.0 |
| 2007-05-22 11:30:00 | NVDA | Stock | 0.5835 | 0.5852 | 0.5802 | 0.5807 | 20776380.0 |
| 2007-05-22 12:00:00 | NVDA | Stock | 0.5805 | 0.5867 | 0.5805 | 0.5865 | 18422100.0 |
| 2007-05-22 12:30:00 | NVDA | Stock | 0.5867 | 0.5895 | 0.586 | 0.5895 | 20361060.0 |
| 2007-05-22 13:00:00 | NVDA | Stock | 0.5895 | 0.5897 | 0.588 | 0.588 | 11552940.0 |
| 2007-05-22 13:30:00 | NVDA | Stock | 0.5882 | 0.5905 | 0.5882 | 0.5885 | 29306340.0 |
| 2007-05-22 14:00:00 | NVDA | Stock | 0.5883 | 0.5913 | 0.5883 | 0.59 | 27966960.0 |
| 2007-05-22 14:30:00 | NVDA | Stock | 0.5902 | 0.592 | 0.5898 | 0.5918 | 29360040.0 |
| 2007-05-22 15:00:00 | NVDA | Stock | 0.5918 | 0.594 | 0.5893 | 0.5897 | 55545900.0 |
| 2007-05-22 15:30:00 | NVDA | Stock | 0.5895 | 0.5905 | 0.5885 | 0.5887 | 37695120.0 |
| 2007-05-22 16:00:00 | NVDA | Stock | 0.5887 | 0.5887 | 0.5858 | 0.5858 | 4786860.0 |
| 2007-05-22 16:30:00 | NVDA | Stock | 0.5858 | 0.5858 | 0.5858 | 0.5858 | 18000.0 |
| 2007-05-22 17:00:00 | NVDA | Stock | 0.586 | 0.586 | 0.5858 | 0.5858 | 60000.0 |
| 2007-05-22 17:30:00 | NVDA | Stock | 0.5853 | 0.5853 | 0.5853 | 0.5853 | 12000.0 |
| 2007-05-22 18:30:00 | NVDA | Stock | 0.5852 | 0.5852 | 0.585 | 0.585 | 258000.0 |
| 2007-05-22 07:30:00 | AMZN | Stock | 3.4225 | 3.4225 | 3.4155 | 3.4155 | 18000.0 |
| 2007-05-22 08:00:00 | AMZN | Stock | 3.4255 | 3.43 | 3.4095 | 3.425 | 416360.0 |
> showing 50 of 63,268 rows — these rows as CSV