PREVIEW / stock_30min / 2009-08-10
file: by_date/stock_30min/2009/2009-08-10.parquet size: 1.3 MB rows: 71,771 symbols: 3,400
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-08-10 07:00:00 | AAPL | Stock | 5.9193 | 5.92 | 5.9193 | 5.92 | 8400.0 |
| 2009-08-10 07:30:00 | AAPL | Stock | 5.9632 | 5.9643 | 5.9311 | 5.9457 | 124264.0 |
| 2009-08-10 08:00:00 | AAPL | Stock | 5.9382 | 5.9382 | 5.8982 | 5.9286 | 744296.0 |
| 2009-08-10 08:30:00 | AAPL | Stock | 5.9282 | 5.9293 | 5.9229 | 5.925 | 337820.0 |
| 2009-08-10 09:00:00 | AAPL | Stock | 5.9218 | 5.9218 | 5.9 | 5.9061 | 462728.0 |
| 2009-08-10 09:30:00 | AAPL | Stock | 5.9164 | 5.95 | 5.8936 | 5.9283 | 48873328.0 |
| 2009-08-10 10:00:00 | AAPL | Stock | 5.9286 | 5.9357 | 5.9054 | 5.9226 | 29207584.0 |
| 2009-08-10 10:30:00 | AAPL | Stock | 5.9225 | 5.9271 | 5.9007 | 5.9054 | 21046704.0 |
| 2009-08-10 11:00:00 | AAPL | Stock | 5.905 | 5.9143 | 5.8875 | 5.8914 | 22520120.0 |
| 2009-08-10 11:30:00 | AAPL | Stock | 5.8911 | 5.8961 | 5.8811 | 5.8911 | 17756004.0 |
| 2009-08-10 12:00:00 | AAPL | Stock | 5.8911 | 5.9036 | 5.8857 | 5.8864 | 15675408.0 |
| 2009-08-10 12:30:00 | AAPL | Stock | 5.8864 | 5.8868 | 5.8721 | 5.8746 | 15866844.0 |
| 2009-08-10 13:00:00 | AAPL | Stock | 5.8743 | 5.8754 | 5.8593 | 5.8671 | 19377176.0 |
| 2009-08-10 13:30:00 | AAPL | Stock | 5.8669 | 5.8811 | 5.8636 | 5.8664 | 14417788.0 |
| 2009-08-10 14:00:00 | AAPL | Stock | 5.8668 | 5.8714 | 5.845 | 5.8543 | 18210864.0 |
| 2009-08-10 14:30:00 | AAPL | Stock | 5.8546 | 5.8632 | 5.8486 | 5.8632 | 16992500.0 |
| 2009-08-10 15:00:00 | AAPL | Stock | 5.8639 | 5.8861 | 5.8629 | 5.8786 | 24529736.0 |
| 2009-08-10 15:30:00 | AAPL | Stock | 5.8793 | 5.8861 | 5.8721 | 5.8829 | 28515452.0 |
| 2009-08-10 16:00:00 | AAPL | Stock | 5.8807 | 5.893 | 5.8807 | 5.8829 | 4322976.0 |
| 2009-08-10 16:30:00 | AAPL | Stock | 5.8857 | 5.8868 | 5.8829 | 5.8829 | 77280.0 |
| 2009-08-10 17:00:00 | AAPL | Stock | 5.8839 | 5.8839 | 5.8764 | 5.8786 | 63112.0 |
| 2009-08-10 17:30:00 | AAPL | Stock | 5.8821 | 5.8839 | 5.8789 | 5.8789 | 36624.0 |
| 2009-08-10 18:00:00 | AAPL | Stock | 5.8793 | 5.8829 | 5.8768 | 5.8786 | 223020.0 |
| 2009-08-10 18:30:00 | AAPL | Stock | 5.8786 | 5.8789 | 5.875 | 5.875 | 49476.0 |
| 2009-08-10 19:00:00 | AAPL | Stock | 5.8721 | 5.8721 | 5.8714 | 5.8718 | 33320.0 |
| 2009-08-10 19:30:00 | AAPL | Stock | 5.8732 | 5.8814 | 5.8732 | 5.875 | 41552.0 |
| 2009-08-10 04:30:00 | MSFT | Stock | 23.56 | 23.56 | 23.56 | 23.56 | 200.0 |
| 2009-08-10 07:00:00 | MSFT | Stock | 23.58 | 23.58 | 23.56 | 23.56 | 1025.0 |
| 2009-08-10 07:30:00 | MSFT | Stock | 23.52 | 23.52 | 23.44 | 23.44 | 500.0 |
| 2009-08-10 08:00:00 | MSFT | Stock | 23.56 | 23.62 | 23.5 | 23.58 | 10900.0 |
| 2009-08-10 08:30:00 | MSFT | Stock | 23.52 | 23.52 | 23.5 | 23.5 | 4988.0 |
| 2009-08-10 09:00:00 | MSFT | Stock | 23.5 | 23.5 | 23.43 | 23.45 | 12500.0 |
| 2009-08-10 09:30:00 | MSFT | Stock | 23.47 | 23.55 | 23.34 | 23.44 | 4003559.0 |
| 2009-08-10 10:00:00 | MSFT | Stock | 23.44 | 23.53 | 23.39 | 23.53 | 2221053.0 |
| 2009-08-10 10:30:00 | MSFT | Stock | 23.52 | 23.53 | 23.4 | 23.42 | 1804936.0 |
| 2009-08-10 11:00:00 | MSFT | Stock | 23.42 | 23.46 | 23.37 | 23.38 | 1965190.0 |
| 2009-08-10 11:30:00 | MSFT | Stock | 23.39 | 23.42 | 23.37 | 23.39 | 1387921.0 |
| 2009-08-10 12:00:00 | MSFT | Stock | 23.4 | 23.44 | 23.37 | 23.4 | 1121408.0 |
| 2009-08-10 12:30:00 | MSFT | Stock | 23.4 | 23.42 | 23.37 | 23.382 | 1542227.0 |
| 2009-08-10 13:00:00 | MSFT | Stock | 23.39 | 23.39 | 23.32 | 23.36 | 2139110.0 |
| 2009-08-10 13:30:00 | MSFT | Stock | 23.36 | 23.42 | 23.35 | 23.36 | 1290553.0 |
| 2009-08-10 14:00:00 | MSFT | Stock | 23.36 | 23.38 | 23.31 | 23.337 | 2568652.0 |
| 2009-08-10 14:30:00 | MSFT | Stock | 23.34 | 23.4 | 23.32 | 23.39 | 1330336.0 |
| 2009-08-10 15:00:00 | MSFT | Stock | 23.39 | 23.42 | 23.34 | 23.4 | 2028678.0 |
| 2009-08-10 15:30:00 | MSFT | Stock | 23.402 | 23.42 | 23.3 | 23.42 | 7057263.0 |
| 2009-08-10 16:00:00 | MSFT | Stock | 23.42 | 23.44 | 23.333 | 23.44 | 1331728.0 |
| 2009-08-10 16:30:00 | MSFT | Stock | 23.42 | 23.44 | 23.42 | 23.42 | 7044.0 |
| 2009-08-10 17:00:00 | MSFT | Stock | 23.4 | 23.42 | 23.38 | 23.4 | 5784.0 |
| 2009-08-10 17:30:00 | MSFT | Stock | 23.4 | 23.4 | 23.4 | 23.4 | 850.0 |
| 2009-08-10 18:00:00 | MSFT | Stock | 23.38 | 23.38 | 23.38 | 23.38 | 1400.0 |
> showing 50 of 71,771 rows — these rows as CSV