PREVIEW / stock_30min / 2009-10-12
file: by_date/stock_30min/2009/2009-10-12.parquet size: 1.3 MB rows: 71,313 symbols: 3,357
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-12 06:00:00 | AAPL | Stock | 6.8529 | 6.8529 | 6.8529 | 6.8529 | 2800.0 |
| 2009-10-12 06:30:00 | AAPL | Stock | 6.8214 | 6.8214 | 6.8214 | 6.8214 | 26656.0 |
| 2009-10-12 07:00:00 | AAPL | Stock | 6.8571 | 6.8579 | 6.8464 | 6.8554 | 64456.0 |
| 2009-10-12 07:30:00 | AAPL | Stock | 6.8393 | 6.8411 | 6.8393 | 6.8393 | 28896.0 |
| 2009-10-12 08:00:00 | AAPL | Stock | 6.8393 | 6.8482 | 6.8054 | 6.8286 | 707280.0 |
| 2009-10-12 08:30:00 | AAPL | Stock | 6.8286 | 6.8429 | 6.8246 | 6.8386 | 429464.0 |
| 2009-10-12 09:00:00 | AAPL | Stock | 6.8407 | 6.8464 | 6.8189 | 6.8204 | 1967252.0 |
| 2009-10-12 09:30:00 | AAPL | Stock | 6.8243 | 6.8396 | 6.7982 | 6.8239 | 51480968.0 |
| 2009-10-12 10:00:00 | AAPL | Stock | 6.8246 | 6.8282 | 6.8043 | 6.8118 | 24359832.0 |
| 2009-10-12 10:30:00 | AAPL | Stock | 6.8116 | 6.8211 | 6.8036 | 6.8186 | 16194220.0 |
| 2009-10-12 11:00:00 | AAPL | Stock | 6.8186 | 6.8321 | 6.8118 | 6.8257 | 15149960.0 |
| 2009-10-12 11:30:00 | AAPL | Stock | 6.8254 | 6.8271 | 6.8054 | 6.8055 | 9389660.0 |
| 2009-10-12 12:00:00 | AAPL | Stock | 6.8054 | 6.8136 | 6.805 | 6.8071 | 13326964.0 |
| 2009-10-12 12:30:00 | AAPL | Stock | 6.8075 | 6.8186 | 6.8061 | 6.8164 | 9154208.0 |
| 2009-10-12 13:00:00 | AAPL | Stock | 6.8162 | 6.8192 | 6.8125 | 6.8143 | 8376200.0 |
| 2009-10-12 13:30:00 | AAPL | Stock | 6.8143 | 6.8171 | 6.8082 | 6.8143 | 6778744.0 |
| 2009-10-12 14:00:00 | AAPL | Stock | 6.8146 | 6.8154 | 6.7875 | 6.7929 | 28186704.0 |
| 2009-10-12 14:30:00 | AAPL | Stock | 6.7925 | 6.7954 | 6.7729 | 6.776 | 33101236.0 |
| 2009-10-12 15:00:00 | AAPL | Stock | 6.7761 | 6.8018 | 6.7757 | 6.8011 | 18925816.0 |
| 2009-10-12 15:30:00 | AAPL | Stock | 6.8018 | 6.8161 | 6.7946 | 6.8146 | 29575028.0 |
| 2009-10-12 16:00:00 | AAPL | Stock | 6.8146 | 6.8255 | 6.8068 | 6.8189 | 4918116.0 |
| 2009-10-12 16:30:00 | AAPL | Stock | 6.8179 | 6.8189 | 6.8073 | 6.8146 | 353612.0 |
| 2009-10-12 17:00:00 | AAPL | Stock | 6.8179 | 6.8179 | 6.8118 | 6.8146 | 88760.0 |
| 2009-10-12 17:30:00 | AAPL | Stock | 6.8146 | 6.8179 | 6.8146 | 6.8154 | 42364.0 |
| 2009-10-12 18:00:00 | AAPL | Stock | 6.8143 | 6.8161 | 6.8143 | 6.8161 | 37296.0 |
| 2009-10-12 18:30:00 | AAPL | Stock | 6.8175 | 6.8175 | 6.81 | 6.81 | 34328.0 |
| 2009-10-12 19:00:00 | AAPL | Stock | 6.8125 | 6.8125 | 6.8107 | 6.8107 | 13972.0 |
| 2009-10-12 19:30:00 | AAPL | Stock | 6.8046 | 6.8179 | 6.8036 | 6.8179 | 68712.0 |
| 2009-10-12 04:30:00 | MSFT | Stock | 25.83 | 25.83 | 25.83 | 25.83 | 174.0 |
| 2009-10-12 05:00:00 | MSFT | Stock | 25.83 | 25.87 | 25.83 | 25.87 | 326.0 |
| 2009-10-12 07:00:00 | MSFT | Stock | 25.78 | 25.78 | 25.78 | 25.78 | 3500.0 |
| 2009-10-12 07:30:00 | MSFT | Stock | 25.75 | 25.75 | 25.75 | 25.75 | 100.0 |
| 2009-10-12 08:00:00 | MSFT | Stock | 25.71 | 25.71 | 25.67 | 25.68 | 3599.0 |
| 2009-10-12 08:30:00 | MSFT | Stock | 25.65 | 25.65 | 25.55 | 25.6 | 13640.0 |
| 2009-10-12 09:00:00 | MSFT | Stock | 25.6 | 25.66 | 25.6 | 25.65 | 7890.0 |
| 2009-10-12 09:30:00 | MSFT | Stock | 25.66 | 25.76 | 25.61 | 25.75 | 2178358.0 |
| 2009-10-12 10:00:00 | MSFT | Stock | 25.75 | 25.87 | 25.75 | 25.86 | 1962024.0 |
| 2009-10-12 10:30:00 | MSFT | Stock | 25.862 | 25.89 | 25.84 | 25.85 | 1588860.0 |
| 2009-10-12 11:00:00 | MSFT | Stock | 25.86 | 25.87 | 25.79 | 25.79 | 1840492.0 |
| 2009-10-12 11:30:00 | MSFT | Stock | 25.795 | 25.8 | 25.74 | 25.76 | 1908222.0 |
| 2009-10-12 12:00:00 | MSFT | Stock | 25.76 | 25.78 | 25.72 | 25.73 | 1336157.0 |
| 2009-10-12 12:30:00 | MSFT | Stock | 25.73 | 25.78 | 25.72 | 25.75 | 1053505.0 |
| 2009-10-12 13:00:00 | MSFT | Stock | 25.755 | 25.76 | 25.7 | 25.75 | 1690789.0 |
| 2009-10-12 13:30:00 | MSFT | Stock | 25.76 | 25.8 | 25.7 | 25.725 | 1558931.0 |
| 2009-10-12 14:00:00 | MSFT | Stock | 25.72 | 25.74 | 25.61 | 25.65 | 2590869.0 |
| 2009-10-12 14:30:00 | MSFT | Stock | 25.65 | 25.65 | 25.55 | 25.642 | 3072362.0 |
| 2009-10-12 15:00:00 | MSFT | Stock | 25.65 | 25.71 | 25.63 | 25.7 | 2038201.0 |
| 2009-10-12 15:30:00 | MSFT | Stock | 25.705 | 25.72 | 25.64 | 25.71 | 3110758.0 |
| 2009-10-12 16:00:00 | MSFT | Stock | 25.72 | 25.803 | 25.66 | 25.68 | 2833369.0 |
| 2009-10-12 16:30:00 | MSFT | Stock | 25.72 | 25.72 | 25.67 | 25.67 | 21981.0 |
> showing 50 of 71,313 rows — these rows as CSV