PREVIEW / stock_1hour / 2007-05-22
file: by_date/stock_1hour/2007/2007-05-22.parquet size: 759 KB rows: 37,030 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:00: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.0261 | 96789392.0 |
| 2007-05-22 11:00:00 | AAPL | Stock | 4.0261 | 4.0286 | 4.0004 | 4.0071 | 67078004.0 |
| 2007-05-22 12:00:00 | AAPL | Stock | 4.0064 | 4.0289 | 4.0057 | 4.0282 | 54012896.0 |
| 2007-05-22 13:00:00 | AAPL | Stock | 4.0286 | 4.0425 | 4.0196 | 4.0368 | 74335016.0 |
| 2007-05-22 14:00:00 | AAPL | Stock | 4.0367 | 4.0554 | 4.0329 | 4.0525 | 86687608.0 |
| 2007-05-22 15:00:00 | AAPL | Stock | 4.0529 | 4.0625 | 4.045 | 4.0543 | 87733380.0 |
| 2007-05-22 16:00:00 | AAPL | Stock | 4.055 | 4.0554 | 4.055 | 4.055 | 4024916.0 |
| 2007-05-22 09:00: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.84 | 5857119.0 |
| 2007-05-22 11:00:00 | MSFT | Stock | 30.838 | 30.87 | 30.76 | 30.812 | 4113239.0 |
| 2007-05-22 12:00:00 | MSFT | Stock | 30.82 | 30.87 | 30.78 | 30.87 | 2484498.0 |
| 2007-05-22 13:00:00 | MSFT | Stock | 30.87 | 30.92 | 30.85 | 30.86 | 3789802.0 |
| 2007-05-22 14:00:00 | MSFT | Stock | 30.86 | 30.92 | 30.81 | 30.83 | 3744018.0 |
| 2007-05-22 15:00:00 | MSFT | Stock | 30.83 | 30.84 | 30.66 | 30.69 | 11143627.0 |
| 2007-05-22 16:00:00 | MSFT | Stock | 30.683 | 30.69 | 30.683 | 30.69 | 787304.0 |
| 2007-05-22 08:00:00 | NVDA | Stock | 0.5892 | 0.5892 | 0.5892 | 0.5892 | 12000.0 |
| 2007-05-22 09:00:00 | NVDA | Stock | 0.5883 | 0.5893 | 0.5843 | 0.5867 | 34932060.0 |
| 2007-05-22 10:00:00 | NVDA | Stock | 0.5863 | 0.5872 | 0.5765 | 0.5788 | 84457860.0 |
| 2007-05-22 11:00:00 | NVDA | Stock | 0.5788 | 0.5852 | 0.5785 | 0.5807 | 37986600.0 |
| 2007-05-22 12:00:00 | NVDA | Stock | 0.5805 | 0.5895 | 0.5805 | 0.5895 | 38783160.0 |
| 2007-05-22 13:00:00 | NVDA | Stock | 0.5895 | 0.5905 | 0.588 | 0.5885 | 40859280.0 |
| 2007-05-22 14:00:00 | NVDA | Stock | 0.5883 | 0.592 | 0.5883 | 0.5918 | 57327000.0 |
| 2007-05-22 15:00:00 | NVDA | Stock | 0.5918 | 0.594 | 0.5885 | 0.5887 | 93241020.0 |
| 2007-05-22 16:00:00 | NVDA | Stock | 0.5887 | 0.5887 | 0.5858 | 0.5858 | 4804860.0 |
| 2007-05-22 17:00:00 | NVDA | Stock | 0.586 | 0.586 | 0.5853 | 0.5853 | 72000.0 |
| 2007-05-22 18:00:00 | NVDA | Stock | 0.5852 | 0.5852 | 0.585 | 0.585 | 258000.0 |
| 2007-05-22 07:00:00 | AMZN | Stock | 3.4225 | 3.4225 | 3.4155 | 3.4155 | 18000.0 |
| 2007-05-22 08:00:00 | AMZN | Stock | 3.4255 | 3.433 | 3.4095 | 3.425 | 1294300.0 |
| 2007-05-22 09:00:00 | AMZN | Stock | 3.426 | 3.4475 | 3.398 | 3.412 | 52447380.0 |
| 2007-05-22 10:00:00 | AMZN | Stock | 3.4125 | 3.422 | 3.3675 | 3.378 | 74694420.0 |
| 2007-05-22 11:00:00 | AMZN | Stock | 3.3775 | 3.3875 | 3.3605 | 3.373 | 37967400.0 |
| 2007-05-22 12:00:00 | AMZN | Stock | 3.372 | 3.3945 | 3.365 | 3.3875 | 24557840.0 |
| 2007-05-22 13:00:00 | AMZN | Stock | 3.3865 | 3.4045 | 3.3775 | 3.3965 | 23372760.0 |
| 2007-05-22 14:00:00 | AMZN | Stock | 3.3965 | 3.437 | 3.395 | 3.433 | 49298020.0 |
| 2007-05-22 15:00:00 | AMZN | Stock | 3.4335 | 3.4535 | 3.429 | 3.4445 | 69176600.0 |
| 2007-05-22 16:00:00 | AMZN | Stock | 3.4445 | 3.445 | 3.439 | 3.4405 | 5768440.0 |
| 2007-05-22 17:00:00 | AMZN | Stock | 3.4405 | 3.4435 | 3.44 | 3.4425 | 154640.0 |
| 2007-05-22 18:00:00 | AMZN | Stock | 3.442 | 3.444 | 3.4375 | 3.4375 | 168040.0 |
| 2007-05-22 19:00:00 | AMZN | Stock | 3.4385 | 3.4435 | 3.4325 | 3.4435 | 28940.0 |
| 2007-05-22 09:00:00 | TLT | Stock | 87.18 | 87.18 | 87.12 | 87.14 | 21200.0 |
| 2007-05-22 10:00:00 | TLT | Stock | 87.16 | 87.2 | 87.09 | 87.1 | 93700.0 |
| 2007-05-22 11:00:00 | TLT | Stock | 87.1 | 87.1 | 87.02 | 87.08 | 76700.0 |
| 2007-05-22 12:00:00 | TLT | Stock | 87.07 | 87.07 | 86.74 | 86.81 | 178000.0 |
| 2007-05-22 13:00:00 | TLT | Stock | 86.82 | 86.87 | 86.74 | 86.86 | 75500.0 |
| 2007-05-22 14:00:00 | TLT | Stock | 86.85 | 86.86 | 86.72 | 86.75 | 320100.0 |
| 2007-05-22 15:00:00 | TLT | Stock | 86.74 | 86.77 | 86.68 | 86.7 | 141200.0 |
| 2007-05-22 16:00:00 | TLT | Stock | 86.7 | 86.75 | 86.7 | 86.74 | 6500.0 |
| 2007-05-22 09:00:00 | CL | Stock | 33.475 | 33.475 | 33.335 | 33.35 | 240600.0 |
| 2007-05-22 10:00:00 | CL | Stock | 33.35 | 33.39 | 33.32 | 33.37 | 390000.0 |
> showing 50 of 37,030 rows — these rows as CSV