PREVIEW / stock_30min / 2009-12-14
file: by_date/stock_30min/2009/2009-12-14.parquet size: 1.4 MB rows: 74,024 symbols: 3,446
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-12-14 04:00:00 | AAPL | Stock | 6.9714 | 7.0171 | 6.9714 | 7.0171 | 5600.0 |
| 2009-12-14 05:30:00 | AAPL | Stock | 6.9975 | 6.9975 | 6.9925 | 6.9925 | 8400.0 |
| 2009-12-14 06:00:00 | AAPL | Stock | 6.9864 | 6.9864 | 6.9843 | 6.9843 | 5600.0 |
| 2009-12-14 06:30:00 | AAPL | Stock | 6.9821 | 6.9821 | 6.9821 | 6.9821 | 5600.0 |
| 2009-12-14 07:00:00 | AAPL | Stock | 6.9936 | 7.0143 | 6.9932 | 7.0036 | 98364.0 |
| 2009-12-14 07:30:00 | AAPL | Stock | 7.0036 | 7.0043 | 6.9996 | 6.9996 | 195860.0 |
| 2009-12-14 08:00:00 | AAPL | Stock | 6.9971 | 7.0164 | 6.9525 | 7.0032 | 3067316.0 |
| 2009-12-14 08:30:00 | AAPL | Stock | 7.0004 | 7.0014 | 6.9743 | 6.9764 | 931756.0 |
| 2009-12-14 09:00:00 | AAPL | Stock | 6.9768 | 6.9911 | 6.975 | 6.9796 | 1383648.0 |
| 2009-12-14 09:30:00 | AAPL | Stock | 6.9775 | 6.9861 | 6.9082 | 6.9189 | 65548560.0 |
| 2009-12-14 10:00:00 | AAPL | Stock | 6.9179 | 6.9268 | 6.8771 | 6.9171 | 57974252.0 |
| 2009-12-14 10:30:00 | AAPL | Stock | 6.9169 | 6.9518 | 6.905 | 6.9505 | 26976740.0 |
| 2009-12-14 11:00:00 | AAPL | Stock | 6.9511 | 6.9964 | 6.9486 | 6.9889 | 39212460.0 |
| 2009-12-14 11:30:00 | AAPL | Stock | 6.9901 | 7.0086 | 6.9757 | 6.9784 | 29503600.0 |
| 2009-12-14 12:00:00 | AAPL | Stock | 6.9786 | 6.9993 | 6.9786 | 6.9986 | 12337976.0 |
| 2009-12-14 12:30:00 | AAPL | Stock | 6.9979 | 7.0446 | 6.9964 | 7.0275 | 38117128.0 |
| 2009-12-14 13:00:00 | AAPL | Stock | 7.0271 | 7.0393 | 7.0182 | 7.0321 | 19515384.0 |
| 2009-12-14 13:30:00 | AAPL | Stock | 7.0318 | 7.0354 | 7.0161 | 7.0311 | 18702460.0 |
| 2009-12-14 14:00:00 | AAPL | Stock | 7.0304 | 7.0439 | 7.0118 | 7.015 | 21648928.0 |
| 2009-12-14 14:30:00 | AAPL | Stock | 7.0148 | 7.0489 | 7.0146 | 7.0329 | 31273032.0 |
| 2009-12-14 15:00:00 | AAPL | Stock | 7.0336 | 7.0511 | 7.0171 | 7.0311 | 32632656.0 |
| 2009-12-14 15:30:00 | AAPL | Stock | 7.0307 | 7.0443 | 7.0086 | 7.0364 | 57837304.0 |
| 2009-12-14 16:00:00 | AAPL | Stock | 7.0364 | 7.0364 | 6.9868 | 7.0296 | 16607304.0 |
| 2009-12-14 16:30:00 | AAPL | Stock | 7.0326 | 7.0336 | 6.9525 | 7.0336 | 614292.0 |
| 2009-12-14 17:00:00 | AAPL | Stock | 7.0279 | 7.0354 | 7.0279 | 7.035 | 676200.0 |
| 2009-12-14 17:30:00 | AAPL | Stock | 7.035 | 7.035 | 7.0307 | 7.0311 | 14700.0 |
| 2009-12-14 18:00:00 | AAPL | Stock | 7.0321 | 7.035 | 7.0257 | 7.0257 | 282884.0 |
| 2009-12-14 18:30:00 | AAPL | Stock | 7.0268 | 7.0268 | 7.0254 | 7.0254 | 14000.0 |
| 2009-12-14 19:00:00 | AAPL | Stock | 7.0254 | 7.0279 | 6.9836 | 7.0243 | 3169600.0 |
| 2009-12-14 19:30:00 | AAPL | Stock | 7.0286 | 7.0314 | 7.0186 | 7.0196 | 163212.0 |
| 2009-12-14 06:00:00 | MSFT | Stock | 29.78 | 29.78 | 29.78 | 29.78 | 2000.0 |
| 2009-12-14 07:00:00 | MSFT | Stock | 29.85 | 29.85 | 29.85 | 29.85 | 500.0 |
| 2009-12-14 07:30:00 | MSFT | Stock | 29.85 | 29.85 | 29.85 | 29.85 | 100.0 |
| 2009-12-14 08:00:00 | MSFT | Stock | 29.88 | 29.98 | 29.85 | 29.98 | 19996.0 |
| 2009-12-14 08:30:00 | MSFT | Stock | 29.97 | 29.97 | 29.96 | 29.96 | 5294.0 |
| 2009-12-14 09:00:00 | MSFT | Stock | 29.96 | 29.97 | 29.9 | 29.9 | 10895.0 |
| 2009-12-14 09:30:00 | MSFT | Stock | 29.91 | 30.09 | 29.9 | 30.055 | 4953690.0 |
| 2009-12-14 10:00:00 | MSFT | Stock | 30.051 | 30.06 | 29.99 | 30.04 | 2932154.0 |
| 2009-12-14 10:30:00 | MSFT | Stock | 30.04 | 30.08 | 30.03 | 30.07 | 2675019.0 |
| 2009-12-14 11:00:00 | MSFT | Stock | 30.06 | 30.087 | 30.02 | 30.08 | 2432284.0 |
| 2009-12-14 11:30:00 | MSFT | Stock | 30.08 | 30.1 | 30.04 | 30.065 | 2355263.0 |
| 2009-12-14 12:00:00 | MSFT | Stock | 30.06 | 30.085 | 30.05 | 30.07 | 1482210.0 |
| 2009-12-14 12:30:00 | MSFT | Stock | 30.08 | 30.1 | 30.045 | 30.05 | 1876850.0 |
| 2009-12-14 13:00:00 | MSFT | Stock | 30.05 | 30.07 | 30.04 | 30.065 | 1492567.0 |
| 2009-12-14 13:30:00 | MSFT | Stock | 30.065 | 30.1 | 30.04 | 30.1 | 1986224.0 |
| 2009-12-14 14:00:00 | MSFT | Stock | 30.1 | 30.1 | 30.08 | 30.08 | 1643469.0 |
| 2009-12-14 14:30:00 | MSFT | Stock | 30.09 | 30.15 | 30.08 | 30.125 | 2209344.0 |
| 2009-12-14 15:00:00 | MSFT | Stock | 30.125 | 30.13 | 30.09 | 30.11 | 2158093.0 |
| 2009-12-14 15:30:00 | MSFT | Stock | 30.105 | 30.16 | 30.105 | 30.12 | 3913927.0 |
| 2009-12-14 16:00:00 | MSFT | Stock | 30.12 | 30.134 | 29.993 | 30.11 | 1899414.0 |
> showing 50 of 74,024 rows — these rows as CSV