PREVIEW / stock_30min / 2009-07-24
file: by_date/stock_30min/2009/2009-07-24.parquet size: 1.3 MB rows: 71,321 symbols: 3,348
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-07-24 04:00:00 | AAPL | Stock | 5.5971 | 5.5971 | 5.5971 | 5.5971 | 2800.0 |
| 2009-07-24 05:30:00 | AAPL | Stock | 5.5714 | 5.5714 | 5.5714 | 5.5714 | 5600.0 |
| 2009-07-24 06:00:00 | AAPL | Stock | 5.6429 | 5.6429 | 5.6429 | 5.6429 | 2800.0 |
| 2009-07-24 07:00:00 | AAPL | Stock | 5.58 | 5.5979 | 5.58 | 5.5893 | 59388.0 |
| 2009-07-24 07:30:00 | AAPL | Stock | 5.6054 | 5.6054 | 5.5893 | 5.5893 | 5936.0 |
| 2009-07-24 08:00:00 | AAPL | Stock | 5.6007 | 5.6318 | 5.5893 | 5.6143 | 365428.0 |
| 2009-07-24 08:30:00 | AAPL | Stock | 5.6143 | 5.625 | 5.6057 | 5.6061 | 977536.0 |
| 2009-07-24 09:00:00 | AAPL | Stock | 5.6036 | 5.6054 | 5.5893 | 5.6046 | 680204.0 |
| 2009-07-24 09:30:00 | AAPL | Stock | 5.6054 | 5.695 | 5.5893 | 5.6371 | 110131224.0 |
| 2009-07-24 10:00:00 | AAPL | Stock | 5.6386 | 5.6743 | 5.6275 | 5.6718 | 35002436.0 |
| 2009-07-24 10:30:00 | AAPL | Stock | 5.672 | 5.6821 | 5.6389 | 5.6471 | 31493420.0 |
| 2009-07-24 11:00:00 | AAPL | Stock | 5.6464 | 5.6743 | 5.6421 | 5.6714 | 21465668.0 |
| 2009-07-24 11:30:00 | AAPL | Stock | 5.6711 | 5.6857 | 5.6693 | 5.6836 | 25975992.0 |
| 2009-07-24 12:00:00 | AAPL | Stock | 5.6814 | 5.6943 | 5.6786 | 5.6786 | 22258600.0 |
| 2009-07-24 12:30:00 | AAPL | Stock | 5.6793 | 5.6946 | 5.6779 | 5.6871 | 16228856.0 |
| 2009-07-24 13:00:00 | AAPL | Stock | 5.6871 | 5.7011 | 5.6814 | 5.7004 | 18464292.0 |
| 2009-07-24 13:30:00 | AAPL | Stock | 5.6995 | 5.7139 | 5.6995 | 5.7004 | 31503248.0 |
| 2009-07-24 14:00:00 | AAPL | Stock | 5.7011 | 5.7125 | 5.6882 | 5.6914 | 26461400.0 |
| 2009-07-24 14:30:00 | AAPL | Stock | 5.6914 | 5.7079 | 5.6871 | 5.6993 | 21519988.0 |
| 2009-07-24 15:00:00 | AAPL | Stock | 5.6989 | 5.7068 | 5.6875 | 5.7054 | 20353228.0 |
| 2009-07-24 15:30:00 | AAPL | Stock | 5.705 | 5.7143 | 5.695 | 5.7143 | 42128688.0 |
| 2009-07-24 16:00:00 | AAPL | Stock | 5.7139 | 5.7143 | 5.6672 | 5.7125 | 9929332.0 |
| 2009-07-24 16:30:00 | AAPL | Stock | 5.7125 | 5.7139 | 5.679 | 5.7114 | 80864.0 |
| 2009-07-24 17:00:00 | AAPL | Stock | 5.7139 | 5.7143 | 5.7118 | 5.7143 | 262724.0 |
| 2009-07-24 17:30:00 | AAPL | Stock | 5.7118 | 5.7118 | 5.7075 | 5.7096 | 128604.0 |
| 2009-07-24 18:00:00 | AAPL | Stock | 5.7096 | 5.7136 | 5.7089 | 5.7096 | 149352.0 |
| 2009-07-24 18:30:00 | AAPL | Stock | 5.7111 | 5.7132 | 5.7071 | 5.7075 | 146608.0 |
| 2009-07-24 19:00:00 | AAPL | Stock | 5.7075 | 5.7143 | 5.7075 | 5.7143 | 271880.0 |
| 2009-07-24 19:30:00 | AAPL | Stock | 5.7143 | 5.7179 | 5.7129 | 5.7154 | 124656.0 |
| 2009-07-24 04:00:00 | MSFT | Stock | 23.53 | 23.53 | 23.48 | 23.48 | 600.0 |
| 2009-07-24 04:30:00 | MSFT | Stock | 23.7 | 23.71 | 23.7 | 23.7 | 2090.0 |
| 2009-07-24 05:00:00 | MSFT | Stock | 23.7 | 23.79 | 23.7 | 23.79 | 1200.0 |
| 2009-07-24 05:30:00 | MSFT | Stock | 23.79 | 23.79 | 23.6 | 23.65 | 1400.0 |
| 2009-07-24 06:00:00 | MSFT | Stock | 23.69 | 23.69 | 23.69 | 23.69 | 1385.0 |
| 2009-07-24 06:30:00 | MSFT | Stock | 23.74 | 23.79 | 23.74 | 23.75 | 25000.0 |
| 2009-07-24 07:00:00 | MSFT | Stock | 23.68 | 23.84 | 23.65 | 23.7 | 104349.0 |
| 2009-07-24 07:30:00 | MSFT | Stock | 23.75 | 24.04 | 23.7 | 23.95 | 261837.0 |
| 2009-07-24 08:00:00 | MSFT | Stock | 23.95 | 23.97 | 23.62 | 23.7 | 1302010.0 |
| 2009-07-24 08:30:00 | MSFT | Stock | 23.69 | 23.7 | 23.53 | 23.56 | 1200457.0 |
| 2009-07-24 09:00:00 | MSFT | Stock | 23.57 | 23.75 | 23.45 | 23.61 | 2353925.0 |
| 2009-07-24 09:30:00 | MSFT | Stock | 23.62 | 23.89 | 22.96 | 22.97 | 48584719.0 |
| 2009-07-24 10:00:00 | MSFT | Stock | 22.97 | 23.15 | 22.81 | 23.03 | 33111854.0 |
| 2009-07-24 10:30:00 | MSFT | Stock | 23.03 | 23.26 | 23.03 | 23.1 | 21404803.0 |
| 2009-07-24 11:00:00 | MSFT | Stock | 23.11 | 23.25 | 23.055 | 23.16 | 10375346.0 |
| 2009-07-24 11:30:00 | MSFT | Stock | 23.16 | 23.45 | 23.15 | 23.43 | 13907661.0 |
| 2009-07-24 12:00:00 | MSFT | Stock | 23.44 | 23.46 | 23.3 | 23.31 | 9621080.0 |
| 2009-07-24 12:30:00 | MSFT | Stock | 23.3 | 23.31 | 23.22 | 23.27 | 5473496.0 |
| 2009-07-24 13:00:00 | MSFT | Stock | 23.269 | 23.29 | 23.2 | 23.26 | 8122838.0 |
| 2009-07-24 13:30:00 | MSFT | Stock | 23.26 | 23.36 | 23.255 | 23.3 | 7994770.0 |
| 2009-07-24 14:00:00 | MSFT | Stock | 23.307 | 23.35 | 23.25 | 23.29 | 7044163.0 |
> showing 50 of 71,321 rows — these rows as CSV