PREVIEW / stock_30min / 2009-07-27
file: by_date/stock_30min/2009/2009-07-27.parquet size: 1.3 MB rows: 71,168 symbols: 3,349
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-27 07:00:00 | AAPL | Stock | 5.7511 | 5.7629 | 5.7511 | 5.7596 | 50400.0 |
| 2009-07-27 07:30:00 | AAPL | Stock | 5.7514 | 5.7675 | 5.7446 | 5.7464 | 182560.0 |
| 2009-07-27 08:00:00 | AAPL | Stock | 5.7493 | 5.7504 | 5.7321 | 5.7375 | 1644384.0 |
| 2009-07-27 08:30:00 | AAPL | Stock | 5.7386 | 5.7411 | 5.7204 | 5.7339 | 685496.0 |
| 2009-07-27 09:00:00 | AAPL | Stock | 5.7346 | 5.7429 | 5.7143 | 5.7179 | 1397256.0 |
| 2009-07-27 09:30:00 | AAPL | Stock | 5.7204 | 5.7457 | 5.6911 | 5.6971 | 78091524.0 |
| 2009-07-27 10:00:00 | AAPL | Stock | 5.6971 | 5.725 | 5.6429 | 5.65 | 65094904.0 |
| 2009-07-27 10:30:00 | AAPL | Stock | 5.6504 | 5.6586 | 5.6164 | 5.6582 | 39926376.0 |
| 2009-07-27 11:00:00 | AAPL | Stock | 5.6582 | 5.6914 | 5.6536 | 5.6818 | 37531564.0 |
| 2009-07-27 11:30:00 | AAPL | Stock | 5.6821 | 5.6957 | 5.6761 | 5.6793 | 21453768.0 |
| 2009-07-27 12:00:00 | AAPL | Stock | 5.6789 | 5.7021 | 5.6768 | 5.69 | 20197576.0 |
| 2009-07-27 12:30:00 | AAPL | Stock | 5.6904 | 5.6939 | 5.6761 | 5.6812 | 15975624.0 |
| 2009-07-27 13:00:00 | AAPL | Stock | 5.6814 | 5.6896 | 5.6732 | 5.6754 | 14316428.0 |
| 2009-07-27 13:30:00 | AAPL | Stock | 5.675 | 5.7089 | 5.6746 | 5.7061 | 20273820.0 |
| 2009-07-27 14:00:00 | AAPL | Stock | 5.7061 | 5.7089 | 5.695 | 5.6993 | 19744312.0 |
| 2009-07-27 14:30:00 | AAPL | Stock | 5.6989 | 5.7132 | 5.6964 | 5.6996 | 19229644.0 |
| 2009-07-27 15:00:00 | AAPL | Stock | 5.6996 | 5.7064 | 5.6775 | 5.6871 | 27620320.0 |
| 2009-07-27 15:30:00 | AAPL | Stock | 5.6864 | 5.7186 | 5.6782 | 5.7182 | 40495868.0 |
| 2009-07-27 16:00:00 | AAPL | Stock | 5.7182 | 5.7196 | 5.688 | 5.7157 | 6454672.0 |
| 2009-07-27 16:30:00 | AAPL | Stock | 5.715 | 5.7179 | 5.7125 | 5.7179 | 34608.0 |
| 2009-07-27 17:00:00 | AAPL | Stock | 5.7146 | 5.7146 | 5.7114 | 5.7146 | 75068.0 |
| 2009-07-27 17:30:00 | AAPL | Stock | 5.7143 | 5.7146 | 5.7125 | 5.7125 | 48580.0 |
| 2009-07-27 18:00:00 | AAPL | Stock | 5.7146 | 5.7179 | 5.6821 | 5.6821 | 445844.0 |
| 2009-07-27 18:30:00 | AAPL | Stock | 5.6821 | 5.7025 | 5.6821 | 5.7018 | 311136.0 |
| 2009-07-27 19:00:00 | AAPL | Stock | 5.7 | 5.7018 | 5.6943 | 5.6943 | 89824.0 |
| 2009-07-27 19:30:00 | AAPL | Stock | 5.6946 | 5.6993 | 5.6861 | 5.6882 | 112560.0 |
| 2009-07-27 04:30:00 | MSFT | Stock | 23.55 | 23.55 | 23.55 | 23.55 | 175.0 |
| 2009-07-27 05:30:00 | MSFT | Stock | 23.56 | 23.57 | 23.56 | 23.57 | 350.0 |
| 2009-07-27 06:00:00 | MSFT | Stock | 23.6 | 23.6 | 23.6 | 23.6 | 150.0 |
| 2009-07-27 06:30:00 | MSFT | Stock | 23.6 | 23.6 | 23.6 | 23.6 | 137.0 |
| 2009-07-27 07:00:00 | MSFT | Stock | 23.61 | 23.68 | 23.61 | 23.61 | 5200.0 |
| 2009-07-27 07:30:00 | MSFT | Stock | 23.61 | 23.66 | 23.4 | 23.48 | 35768.0 |
| 2009-07-27 08:00:00 | MSFT | Stock | 23.48 | 23.5 | 23.3 | 23.41 | 49890.0 |
| 2009-07-27 08:30:00 | MSFT | Stock | 23.4 | 23.4 | 23.36 | 23.37 | 23923.0 |
| 2009-07-27 09:00:00 | MSFT | Stock | 23.36 | 23.45 | 23.36 | 23.44 | 81090.0 |
| 2009-07-27 09:30:00 | MSFT | Stock | 23.44 | 23.45 | 23.05 | 23.29 | 10984623.0 |
| 2009-07-27 10:00:00 | MSFT | Stock | 23.3 | 23.44 | 23.1 | 23.16 | 9019452.0 |
| 2009-07-27 10:30:00 | MSFT | Stock | 23.16 | 23.19 | 23.03 | 23.11 | 4695642.0 |
| 2009-07-27 11:00:00 | MSFT | Stock | 23.11 | 23.19 | 23.1 | 23.18 | 3535955.0 |
| 2009-07-27 11:30:00 | MSFT | Stock | 23.19 | 23.19 | 23.05 | 23.08 | 5680651.0 |
| 2009-07-27 12:00:00 | MSFT | Stock | 23.079 | 23.12 | 23.0 | 23.027 | 4661343.0 |
| 2009-07-27 12:30:00 | MSFT | Stock | 23.03 | 23.05 | 23.01 | 23.05 | 3714276.0 |
| 2009-07-27 13:00:00 | MSFT | Stock | 23.05 | 23.05 | 22.91 | 22.912 | 4817311.0 |
| 2009-07-27 13:30:00 | MSFT | Stock | 22.91 | 23.03 | 22.9 | 23.008 | 3711539.0 |
| 2009-07-27 14:00:00 | MSFT | Stock | 23.01 | 23.08 | 23.0 | 23.04 | 3444107.0 |
| 2009-07-27 14:30:00 | MSFT | Stock | 23.05 | 23.08 | 23.01 | 23.03 | 4425250.0 |
| 2009-07-27 15:00:00 | MSFT | Stock | 23.03 | 23.05 | 22.92 | 22.95 | 6864111.0 |
| 2009-07-27 15:30:00 | MSFT | Stock | 22.94 | 23.1 | 22.93 | 23.1 | 7903589.0 |
| 2009-07-27 16:00:00 | MSFT | Stock | 23.11 | 23.18 | 23.05 | 23.13 | 4070205.0 |
| 2009-07-27 16:30:00 | MSFT | Stock | 23.14 | 23.14 | 23.11 | 23.14 | 10449.0 |
> showing 50 of 71,168 rows — these rows as CSV