PREVIEW / stock_30min / 2007-06-06
file: by_date/stock_30min/2007/2007-06-06.parquet size: 1.1 MB rows: 63,872 symbols: 3,002
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-06-06 09:30:00 | AAPL | Stock | 4.3679 | 4.4071 | 4.3554 | 4.3882 | 173147912.0 |
| 2007-06-06 10:00:00 | AAPL | Stock | 4.3882 | 4.3882 | 4.3593 | 4.3764 | 143150448.0 |
| 2007-06-06 10:30:00 | AAPL | Stock | 4.3768 | 4.3871 | 4.3675 | 4.3771 | 84005208.0 |
| 2007-06-06 11:00:00 | AAPL | Stock | 4.3773 | 4.4096 | 4.3732 | 4.4032 | 96923120.0 |
| 2007-06-06 11:30:00 | AAPL | Stock | 4.4036 | 4.4121 | 4.3896 | 4.3964 | 70660548.0 |
| 2007-06-06 12:00:00 | AAPL | Stock | 4.3964 | 4.4107 | 4.395 | 4.3979 | 52770900.0 |
| 2007-06-06 12:30:00 | AAPL | Stock | 4.3979 | 4.4043 | 4.39 | 4.3936 | 39304356.0 |
| 2007-06-06 13:00:00 | AAPL | Stock | 4.3936 | 4.3968 | 4.3789 | 4.3819 | 78040620.0 |
| 2007-06-06 13:30:00 | AAPL | Stock | 4.3811 | 4.3996 | 4.3811 | 4.3975 | 38300556.0 |
| 2007-06-06 14:00:00 | AAPL | Stock | 4.3975 | 4.4082 | 4.3957 | 4.3986 | 52994340.0 |
| 2007-06-06 14:30:00 | AAPL | Stock | 4.3986 | 4.4182 | 4.3986 | 4.4121 | 62854988.0 |
| 2007-06-06 15:00:00 | AAPL | Stock | 4.4118 | 4.4282 | 4.4 | 4.4243 | 77544516.0 |
| 2007-06-06 15:30:00 | AAPL | Stock | 4.4236 | 4.4304 | 4.4154 | 4.4157 | 104089916.0 |
| 2007-06-06 16:00:00 | AAPL | Stock | 4.4154 | 4.4157 | 4.4154 | 4.4157 | 5565028.0 |
| 2007-06-06 09:30:00 | MSFT | Stock | 30.37 | 30.5 | 30.25 | 30.48 | 5382812.0 |
| 2007-06-06 10:00:00 | MSFT | Stock | 30.49 | 30.53 | 30.38 | 30.51 | 2048890.0 |
| 2007-06-06 10:30:00 | MSFT | Stock | 30.509 | 30.51 | 30.34 | 30.37 | 2583807.0 |
| 2007-06-06 11:00:00 | MSFT | Stock | 30.375 | 30.411 | 30.32 | 30.32 | 2002835.0 |
| 2007-06-06 11:30:00 | MSFT | Stock | 30.32 | 30.36 | 30.29 | 30.3 | 1815759.0 |
| 2007-06-06 12:00:00 | MSFT | Stock | 30.3 | 30.39 | 30.28 | 30.37 | 1888710.0 |
| 2007-06-06 12:30:00 | MSFT | Stock | 30.372 | 30.39 | 30.3 | 30.3 | 1273251.0 |
| 2007-06-06 13:00:00 | MSFT | Stock | 30.302 | 30.35 | 30.28 | 30.32 | 2108667.0 |
| 2007-06-06 13:30:00 | MSFT | Stock | 30.33 | 30.39 | 30.32 | 30.39 | 1432357.0 |
| 2007-06-06 14:00:00 | MSFT | Stock | 30.39 | 30.39 | 30.31 | 30.33 | 1878507.0 |
| 2007-06-06 14:30:00 | MSFT | Stock | 30.33 | 30.43 | 30.32 | 30.402 | 2511593.0 |
| 2007-06-06 15:00:00 | MSFT | Stock | 30.41 | 30.44 | 30.35 | 30.4 | 2776096.0 |
| 2007-06-06 15:30:00 | MSFT | Stock | 30.4 | 30.46 | 30.29 | 30.29 | 5291685.0 |
| 2007-06-06 16:00:00 | MSFT | Stock | 30.3 | 30.3 | 30.29 | 30.29 | 1158208.0 |
| 2007-06-06 09:00:00 | NVDA | Stock | 0.5992 | 0.5992 | 0.5967 | 0.598 | 1302000.0 |
| 2007-06-06 09:30:00 | NVDA | Stock | 0.5977 | 0.6048 | 0.5952 | 0.601 | 92143920.0 |
| 2007-06-06 10:00:00 | NVDA | Stock | 0.601 | 0.6122 | 0.5973 | 0.6108 | 146782980.0 |
| 2007-06-06 10:30:00 | NVDA | Stock | 0.6108 | 0.616 | 0.61 | 0.6115 | 119430060.0 |
| 2007-06-06 11:00:00 | NVDA | Stock | 0.6115 | 0.6152 | 0.6103 | 0.6132 | 60002820.0 |
| 2007-06-06 11:30:00 | NVDA | Stock | 0.6132 | 0.6133 | 0.609 | 0.6098 | 54349980.0 |
| 2007-06-06 12:00:00 | NVDA | Stock | 0.6098 | 0.6112 | 0.6087 | 0.609 | 39278460.0 |
| 2007-06-06 12:30:00 | NVDA | Stock | 0.609 | 0.6102 | 0.6062 | 0.6063 | 39492720.0 |
| 2007-06-06 13:00:00 | NVDA | Stock | 0.6062 | 0.6082 | 0.6052 | 0.606 | 44600700.0 |
| 2007-06-06 13:30:00 | NVDA | Stock | 0.6062 | 0.6075 | 0.6052 | 0.6065 | 37485540.0 |
| 2007-06-06 14:00:00 | NVDA | Stock | 0.6067 | 0.6077 | 0.606 | 0.607 | 41239260.0 |
| 2007-06-06 14:30:00 | NVDA | Stock | 0.607 | 0.6075 | 0.6063 | 0.6067 | 33000360.0 |
| 2007-06-06 15:00:00 | NVDA | Stock | 0.6067 | 0.6082 | 0.6063 | 0.6068 | 64572180.0 |
| 2007-06-06 15:30:00 | NVDA | Stock | 0.6068 | 0.6108 | 0.606 | 0.6063 | 101607840.0 |
| 2007-06-06 16:00:00 | NVDA | Stock | 0.6072 | 0.6077 | 0.606 | 0.6063 | 1301520.0 |
| 2007-06-06 16:30:00 | NVDA | Stock | 0.6062 | 0.6062 | 0.6062 | 0.6062 | 12000.0 |
| 2007-06-06 17:00:00 | NVDA | Stock | 0.6075 | 0.609 | 0.6057 | 0.6058 | 218820.0 |
| 2007-06-06 17:30:00 | NVDA | Stock | 0.6062 | 0.6062 | 0.6058 | 0.6058 | 15000.0 |
| 2007-06-06 18:00:00 | NVDA | Stock | 0.6082 | 0.6082 | 0.6082 | 0.6082 | 60000.0 |
| 2007-06-06 18:30:00 | NVDA | Stock | 0.6058 | 0.6058 | 0.6057 | 0.6057 | 72000.0 |
| 2007-06-06 05:30:00 | AMZN | Stock | 3.653 | 3.653 | 3.653 | 3.653 | 2000.0 |
| 2007-06-06 07:30:00 | AMZN | Stock | 3.647 | 3.647 | 3.647 | 3.647 | 2000.0 |
> showing 50 of 63,872 rows — these rows as CSV