PREVIEW / stock_30min / 2008-09-24
file: by_date/stock_30min/2008/2008-09-24.parquet size: 1.2 MB rows: 68,765 symbols: 3,323
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-24 05:30:00 | AAPL | Stock | 4.6071 | 4.6071 | 4.5732 | 4.5732 | 15680.0 |
| 2008-09-24 06:00:00 | AAPL | Stock | 4.6071 | 4.6071 | 4.6071 | 4.6071 | 4480.0 |
| 2008-09-24 06:30:00 | AAPL | Stock | 4.5732 | 4.5893 | 4.5714 | 4.5893 | 50400.0 |
| 2008-09-24 07:00:00 | AAPL | Stock | 4.5893 | 4.6246 | 4.5739 | 4.5739 | 260316.0 |
| 2008-09-24 07:30:00 | AAPL | Stock | 4.5664 | 4.5786 | 4.5375 | 4.5614 | 168672.0 |
| 2008-09-24 08:00:00 | AAPL | Stock | 4.5607 | 4.5889 | 4.5464 | 4.5821 | 2660196.0 |
| 2008-09-24 08:30:00 | AAPL | Stock | 4.5786 | 4.5875 | 4.5714 | 4.5857 | 1712256.0 |
| 2008-09-24 09:00:00 | AAPL | Stock | 4.5857 | 4.5929 | 4.5393 | 4.5529 | 4891740.0 |
| 2008-09-24 09:30:00 | AAPL | Stock | 4.5521 | 4.5775 | 4.4696 | 4.5614 | 159486824.0 |
| 2008-09-24 10:00:00 | AAPL | Stock | 4.5618 | 4.5871 | 4.5043 | 4.5693 | 95653964.0 |
| 2008-09-24 10:30:00 | AAPL | Stock | 4.5693 | 4.6429 | 4.5632 | 4.6396 | 97382908.0 |
| 2008-09-24 11:00:00 | AAPL | Stock | 4.6382 | 4.6539 | 4.5843 | 4.6236 | 80037832.0 |
| 2008-09-24 11:30:00 | AAPL | Stock | 4.6236 | 4.6336 | 4.5639 | 4.5945 | 55409564.0 |
| 2008-09-24 12:00:00 | AAPL | Stock | 4.5949 | 4.6264 | 4.5714 | 4.5975 | 43047452.0 |
| 2008-09-24 12:30:00 | AAPL | Stock | 4.5979 | 4.6321 | 4.5914 | 4.6121 | 37668512.0 |
| 2008-09-24 13:00:00 | AAPL | Stock | 4.6114 | 4.6511 | 4.5936 | 4.6425 | 64052716.0 |
| 2008-09-24 13:30:00 | AAPL | Stock | 4.6418 | 4.6464 | 4.6007 | 4.6093 | 61803784.0 |
| 2008-09-24 14:00:00 | AAPL | Stock | 4.61 | 4.6375 | 4.6011 | 4.6325 | 54311040.0 |
| 2008-09-24 14:30:00 | AAPL | Stock | 4.6325 | 4.6768 | 4.6239 | 4.6318 | 67981032.0 |
| 2008-09-24 15:00:00 | AAPL | Stock | 4.6314 | 4.6518 | 4.5536 | 4.5879 | 93384088.0 |
| 2008-09-24 15:30:00 | AAPL | Stock | 4.5893 | 4.6071 | 4.5318 | 4.5971 | 100927596.0 |
| 2008-09-24 16:00:00 | AAPL | Stock | 4.6032 | 4.6214 | 4.5915 | 4.6161 | 13735120.0 |
| 2008-09-24 16:30:00 | AAPL | Stock | 4.6175 | 4.6175 | 4.5536 | 4.5543 | 816592.0 |
| 2008-09-24 17:00:00 | AAPL | Stock | 4.5543 | 4.5968 | 4.5536 | 4.5846 | 1641752.0 |
| 2008-09-24 17:30:00 | AAPL | Stock | 4.5846 | 4.5968 | 4.5775 | 4.5857 | 166376.0 |
| 2008-09-24 18:00:00 | AAPL | Stock | 4.5886 | 4.5961 | 4.5821 | 4.5961 | 99400.0 |
| 2008-09-24 18:30:00 | AAPL | Stock | 4.5961 | 4.6071 | 4.5929 | 4.5964 | 143808.0 |
| 2008-09-24 19:00:00 | AAPL | Stock | 4.6 | 4.6036 | 4.5964 | 4.5964 | 48300.0 |
| 2008-09-24 19:30:00 | AAPL | Stock | 4.5893 | 4.5986 | 4.5821 | 4.5946 | 145264.0 |
| 2008-09-24 07:30:00 | MSFT | Stock | 25.7 | 25.7 | 25.69 | 25.69 | 300.0 |
| 2008-09-24 08:00:00 | MSFT | Stock | 25.66 | 25.84 | 25.61 | 25.79 | 36927.0 |
| 2008-09-24 08:30:00 | MSFT | Stock | 25.77 | 25.84 | 25.69 | 25.75 | 42578.0 |
| 2008-09-24 09:00:00 | MSFT | Stock | 25.75 | 25.77 | 25.44 | 25.57 | 1221683.0 |
| 2008-09-24 09:30:00 | MSFT | Stock | 25.53 | 25.7 | 25.46 | 25.53 | 7426983.0 |
| 2008-09-24 10:00:00 | MSFT | Stock | 25.52 | 25.65 | 25.46 | 25.61 | 5911682.0 |
| 2008-09-24 10:30:00 | MSFT | Stock | 25.617 | 25.8 | 25.59 | 25.76 | 5206059.0 |
| 2008-09-24 11:00:00 | MSFT | Stock | 25.75 | 25.76 | 25.51 | 25.67 | 3439997.0 |
| 2008-09-24 11:30:00 | MSFT | Stock | 25.67 | 25.72 | 25.5 | 25.63 | 4187035.0 |
| 2008-09-24 12:00:00 | MSFT | Stock | 25.64 | 25.78 | 25.54 | 25.71 | 5279844.0 |
| 2008-09-24 12:30:00 | MSFT | Stock | 25.71 | 25.75 | 25.67 | 25.714 | 3033363.0 |
| 2008-09-24 13:00:00 | MSFT | Stock | 25.725 | 26.03 | 25.7 | 26.01 | 5117943.0 |
| 2008-09-24 13:30:00 | MSFT | Stock | 26.01 | 26.09 | 25.86 | 25.918 | 6568003.0 |
| 2008-09-24 14:00:00 | MSFT | Stock | 25.92 | 25.96 | 25.82 | 25.95 | 3855542.0 |
| 2008-09-24 14:30:00 | MSFT | Stock | 25.942 | 26.05 | 25.82 | 25.85 | 4268349.0 |
| 2008-09-24 15:00:00 | MSFT | Stock | 25.84 | 25.88 | 25.63 | 25.715 | 5451117.0 |
| 2008-09-24 15:30:00 | MSFT | Stock | 25.71 | 25.99 | 25.53 | 25.75 | 8379896.0 |
| 2008-09-24 16:00:00 | MSFT | Stock | 25.72 | 25.93 | 25.64 | 25.85 | 9766031.0 |
| 2008-09-24 16:30:00 | MSFT | Stock | 25.85 | 25.85 | 25.83 | 25.85 | 3634.0 |
| 2008-09-24 17:00:00 | MSFT | Stock | 25.85 | 25.89 | 25.72 | 25.83 | 414873.0 |
| 2008-09-24 17:30:00 | MSFT | Stock | 25.85 | 25.85 | 25.85 | 25.85 | 2000.0 |
> showing 50 of 68,765 rows — these rows as CSV