PREVIEW / stock_30min / 2009-12-18
file: by_date/stock_30min/2009/2009-12-18.parquet size: 1.5 MB rows: 79,158 symbols: 3,450
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-18 04:00:00 | AAPL | Stock | 6.9089 | 6.9089 | 6.9089 | 6.9089 | 2800.0 |
| 2009-12-18 06:30:00 | AAPL | Stock | 6.8893 | 6.8893 | 6.8893 | 6.8893 | 2800.0 |
| 2009-12-18 07:00:00 | AAPL | Stock | 6.9018 | 6.9107 | 6.8964 | 6.9004 | 61796.0 |
| 2009-12-18 07:30:00 | AAPL | Stock | 6.9004 | 6.9071 | 6.8946 | 6.8961 | 146300.0 |
| 2009-12-18 08:00:00 | AAPL | Stock | 6.8996 | 6.92 | 6.8893 | 6.9054 | 1406888.0 |
| 2009-12-18 08:30:00 | AAPL | Stock | 6.9054 | 6.91 | 6.9 | 6.9014 | 807380.0 |
| 2009-12-18 09:00:00 | AAPL | Stock | 6.9007 | 6.9011 | 6.8929 | 6.8973 | 707476.0 |
| 2009-12-18 09:30:00 | AAPL | Stock | 6.8989 | 6.9318 | 6.8786 | 6.9243 | 158720072.0 |
| 2009-12-18 10:00:00 | AAPL | Stock | 6.9236 | 6.9375 | 6.9129 | 6.9289 | 43289064.0 |
| 2009-12-18 10:30:00 | AAPL | Stock | 6.9296 | 6.9311 | 6.8821 | 6.9061 | 40660732.0 |
| 2009-12-18 11:00:00 | AAPL | Stock | 6.9071 | 6.9107 | 6.8807 | 6.8857 | 21695940.0 |
| 2009-12-18 11:30:00 | AAPL | Stock | 6.8857 | 6.9011 | 6.8846 | 6.9004 | 15033592.0 |
| 2009-12-18 12:00:00 | AAPL | Stock | 6.8996 | 6.925 | 6.8954 | 6.9146 | 21878332.0 |
| 2009-12-18 12:30:00 | AAPL | Stock | 6.9143 | 6.9214 | 6.9107 | 6.9175 | 12850320.0 |
| 2009-12-18 13:00:00 | AAPL | Stock | 6.9171 | 6.9304 | 6.9 | 6.9275 | 20763764.0 |
| 2009-12-18 13:30:00 | AAPL | Stock | 6.9275 | 6.9307 | 6.9136 | 6.9275 | 18660516.0 |
| 2009-12-18 14:00:00 | AAPL | Stock | 6.9268 | 6.9461 | 6.9214 | 6.9329 | 32108972.0 |
| 2009-12-18 14:30:00 | AAPL | Stock | 6.9329 | 6.96 | 6.9214 | 6.959 | 50731576.0 |
| 2009-12-18 15:00:00 | AAPL | Stock | 6.9589 | 6.9607 | 6.9357 | 6.9421 | 28257740.0 |
| 2009-12-18 15:30:00 | AAPL | Stock | 6.9421 | 6.9736 | 6.9404 | 6.9736 | 81141060.0 |
| 2009-12-18 16:00:00 | AAPL | Stock | 6.97 | 6.9835 | 6.8999 | 6.9693 | 34294148.0 |
| 2009-12-18 16:30:00 | AAPL | Stock | 6.9431 | 6.9856 | 6.9431 | 6.9675 | 5489344.0 |
| 2009-12-18 17:00:00 | AAPL | Stock | 6.9675 | 6.9854 | 6.9625 | 6.9625 | 6357008.0 |
| 2009-12-18 17:30:00 | AAPL | Stock | 6.9607 | 6.9823 | 6.9604 | 6.9679 | 152740.0 |
| 2009-12-18 18:00:00 | AAPL | Stock | 6.9671 | 6.9796 | 6.9671 | 6.9682 | 457492.0 |
| 2009-12-18 18:30:00 | AAPL | Stock | 6.9686 | 6.9711 | 6.965 | 6.9682 | 86632.0 |
| 2009-12-18 19:00:00 | AAPL | Stock | 6.9643 | 6.9714 | 6.9607 | 6.9714 | 312704.0 |
| 2009-12-18 19:30:00 | AAPL | Stock | 6.9714 | 6.975 | 6.9654 | 6.9729 | 287140.0 |
| 2009-12-18 07:30:00 | MSFT | Stock | 29.72 | 29.72 | 29.72 | 29.72 | 1100.0 |
| 2009-12-18 08:00:00 | MSFT | Stock | 29.82 | 29.84 | 29.65 | 29.8 | 5085.0 |
| 2009-12-18 08:30:00 | MSFT | Stock | 29.79 | 29.81 | 29.72 | 29.77 | 11974.0 |
| 2009-12-18 09:00:00 | MSFT | Stock | 29.77 | 29.84 | 29.71 | 29.83 | 290126.0 |
| 2009-12-18 09:30:00 | MSFT | Stock | 29.84 | 30.1 | 29.8 | 30.02 | 22706531.0 |
| 2009-12-18 10:00:00 | MSFT | Stock | 30.02 | 30.16 | 29.98 | 30.16 | 4643738.0 |
| 2009-12-18 10:30:00 | MSFT | Stock | 30.15 | 30.16 | 29.99 | 30.05 | 3464823.0 |
| 2009-12-18 11:00:00 | MSFT | Stock | 30.05 | 30.1 | 29.99 | 30.01 | 3742379.0 |
| 2009-12-18 11:30:00 | MSFT | Stock | 30.0 | 30.08 | 29.995 | 30.01 | 2663114.0 |
| 2009-12-18 12:00:00 | MSFT | Stock | 30.02 | 30.09 | 30.0 | 30.06 | 2287161.0 |
| 2009-12-18 12:30:00 | MSFT | Stock | 30.06 | 30.07 | 30.011 | 30.039 | 1885278.0 |
| 2009-12-18 13:00:00 | MSFT | Stock | 30.04 | 30.06 | 30.0 | 30.04 | 1806701.0 |
| 2009-12-18 13:30:00 | MSFT | Stock | 30.04 | 30.05 | 30.01 | 30.01 | 1186290.0 |
| 2009-12-18 14:00:00 | MSFT | Stock | 30.01 | 30.02 | 30.0 | 30.002 | 1117885.0 |
| 2009-12-18 14:30:00 | MSFT | Stock | 30.01 | 30.06 | 30.0 | 30.05 | 3285177.0 |
| 2009-12-18 15:00:00 | MSFT | Stock | 30.05 | 30.14 | 30.0 | 30.054 | 4802636.0 |
| 2009-12-18 15:30:00 | MSFT | Stock | 30.07 | 30.45 | 30.04 | 30.37 | 16057089.0 |
| 2009-12-18 16:00:00 | MSFT | Stock | 30.37 | 30.45 | 30.026 | 30.245 | 15773079.0 |
| 2009-12-18 16:30:00 | MSFT | Stock | 30.043 | 30.41 | 30.026 | 30.32 | 2215484.0 |
| 2009-12-18 17:00:00 | MSFT | Stock | 30.254 | 30.38 | 30.234 | 30.38 | 1864336.0 |
| 2009-12-18 17:30:00 | MSFT | Stock | 30.035 | 30.245 | 30.035 | 30.24 | 45619.0 |
| 2009-12-18 18:00:00 | MSFT | Stock | 30.38 | 30.39 | 30.34 | 30.39 | 47521.0 |
> showing 50 of 79,158 rows — these rows as CSV