PREVIEW / stock_30min / 2009-06-23
file: by_date/stock_30min/2009/2009-06-23.parquet size: 1.3 MB rows: 70,015 symbols: 3,356
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-06-23 04:00:00 | AAPL | Stock | 4.9061 | 4.9061 | 4.9061 | 4.9061 | 2800.0 |
| 2009-06-23 05:00:00 | AAPL | Stock | 4.9268 | 4.9268 | 4.9268 | 4.9268 | 5012.0 |
| 2009-06-23 06:30:00 | AAPL | Stock | 4.9268 | 4.9279 | 4.9268 | 4.9279 | 51800.0 |
| 2009-06-23 07:00:00 | AAPL | Stock | 4.9139 | 4.9139 | 4.9061 | 4.9107 | 52920.0 |
| 2009-06-23 07:30:00 | AAPL | Stock | 4.9129 | 4.9171 | 4.9071 | 4.9071 | 94500.0 |
| 2009-06-23 08:00:00 | AAPL | Stock | 4.9114 | 4.9114 | 4.88 | 4.895 | 1098776.0 |
| 2009-06-23 08:30:00 | AAPL | Stock | 4.8921 | 4.8954 | 4.8775 | 4.8893 | 676676.0 |
| 2009-06-23 09:00:00 | AAPL | Stock | 4.8875 | 4.8921 | 4.8657 | 4.8707 | 2399992.0 |
| 2009-06-23 09:30:00 | AAPL | Stock | 4.8714 | 4.8911 | 4.7518 | 4.7589 | 159111764.0 |
| 2009-06-23 10:00:00 | AAPL | Stock | 4.7579 | 4.7929 | 4.7457 | 4.7618 | 111640956.0 |
| 2009-06-23 10:30:00 | AAPL | Stock | 4.7621 | 4.7957 | 4.7507 | 4.7689 | 64327200.0 |
| 2009-06-23 11:00:00 | AAPL | Stock | 4.7693 | 4.7814 | 4.7554 | 4.7761 | 33932500.0 |
| 2009-06-23 11:30:00 | AAPL | Stock | 4.7759 | 4.7946 | 4.7718 | 4.7886 | 30082836.0 |
| 2009-06-23 12:00:00 | AAPL | Stock | 4.7886 | 4.7906 | 4.7596 | 4.7618 | 26461064.0 |
| 2009-06-23 12:30:00 | AAPL | Stock | 4.7618 | 4.7911 | 4.7618 | 4.7696 | 31739260.0 |
| 2009-06-23 13:00:00 | AAPL | Stock | 4.77 | 4.7893 | 4.7682 | 4.7768 | 23190188.0 |
| 2009-06-23 13:30:00 | AAPL | Stock | 4.7764 | 4.7871 | 4.7646 | 4.7742 | 26167288.0 |
| 2009-06-23 14:00:00 | AAPL | Stock | 4.7725 | 4.825 | 4.77 | 4.8021 | 56359268.0 |
| 2009-06-23 14:30:00 | AAPL | Stock | 4.8018 | 4.8146 | 4.7839 | 4.8064 | 32436320.0 |
| 2009-06-23 15:00:00 | AAPL | Stock | 4.8061 | 4.8118 | 4.7896 | 4.8104 | 29639960.0 |
| 2009-06-23 15:30:00 | AAPL | Stock | 4.8107 | 4.8111 | 4.7796 | 4.7843 | 60496436.0 |
| 2009-06-23 16:00:00 | AAPL | Stock | 4.7889 | 4.9061 | 4.7807 | 4.7982 | 10055500.0 |
| 2009-06-23 16:30:00 | AAPL | Stock | 4.7964 | 4.7975 | 4.7861 | 4.7864 | 655396.0 |
| 2009-06-23 17:00:00 | AAPL | Stock | 4.7911 | 4.7975 | 4.7871 | 4.7975 | 81788.0 |
| 2009-06-23 17:30:00 | AAPL | Stock | 4.7918 | 4.7964 | 4.7889 | 4.7889 | 55720.0 |
| 2009-06-23 18:00:00 | AAPL | Stock | 4.7936 | 4.7946 | 4.7836 | 4.7896 | 920248.0 |
| 2009-06-23 18:30:00 | AAPL | Stock | 4.7889 | 4.7918 | 4.7875 | 4.7882 | 123928.0 |
| 2009-06-23 19:00:00 | AAPL | Stock | 4.7882 | 4.7921 | 4.7882 | 4.7921 | 39172.0 |
| 2009-06-23 19:30:00 | AAPL | Stock | 4.7875 | 4.7879 | 4.7757 | 4.7779 | 378616.0 |
| 2009-06-23 06:30:00 | MSFT | Stock | 23.38 | 23.38 | 23.38 | 23.38 | 180.0 |
| 2009-06-23 07:00:00 | MSFT | Stock | 23.45 | 23.46 | 23.45 | 23.46 | 530.0 |
| 2009-06-23 08:00:00 | MSFT | Stock | 23.39 | 23.43 | 23.38 | 23.43 | 3070.0 |
| 2009-06-23 08:30:00 | MSFT | Stock | 23.44 | 23.5 | 23.42 | 23.46 | 33751.0 |
| 2009-06-23 09:00:00 | MSFT | Stock | 23.45 | 23.47 | 23.35 | 23.39 | 37134.0 |
| 2009-06-23 09:30:00 | MSFT | Stock | 23.4 | 23.44 | 23.28 | 23.35 | 7428643.0 |
| 2009-06-23 10:00:00 | MSFT | Stock | 23.35 | 23.42 | 23.21 | 23.35 | 5253221.0 |
| 2009-06-23 10:30:00 | MSFT | Stock | 23.34 | 23.49 | 23.335 | 23.432 | 4276411.0 |
| 2009-06-23 11:00:00 | MSFT | Stock | 23.43 | 23.49 | 23.35 | 23.47 | 3086807.0 |
| 2009-06-23 11:30:00 | MSFT | Stock | 23.47 | 23.6 | 23.47 | 23.565 | 3309768.0 |
| 2009-06-23 12:00:00 | MSFT | Stock | 23.57 | 23.57 | 23.49 | 23.55 | 3163671.0 |
| 2009-06-23 12:30:00 | MSFT | Stock | 23.55 | 23.64 | 23.54 | 23.6 | 3977378.0 |
| 2009-06-23 13:00:00 | MSFT | Stock | 23.6 | 23.66 | 23.59 | 23.59 | 2886732.0 |
| 2009-06-23 13:30:00 | MSFT | Stock | 23.6 | 23.63 | 23.5 | 23.5 | 1963755.0 |
| 2009-06-23 14:00:00 | MSFT | Stock | 23.5 | 23.58 | 23.49 | 23.55 | 2016883.0 |
| 2009-06-23 14:30:00 | MSFT | Stock | 23.55 | 23.55 | 23.41 | 23.48 | 3467897.0 |
| 2009-06-23 15:00:00 | MSFT | Stock | 23.48 | 23.48 | 23.36 | 23.42 | 4040159.0 |
| 2009-06-23 15:30:00 | MSFT | Stock | 23.42 | 23.44 | 23.27 | 23.32 | 8878253.0 |
| 2009-06-23 16:00:00 | MSFT | Stock | 23.33 | 23.443 | 23.25 | 23.39 | 1734142.0 |
| 2009-06-23 16:30:00 | MSFT | Stock | 23.38 | 23.5 | 23.33 | 23.33 | 150813.0 |
| 2009-06-23 17:00:00 | MSFT | Stock | 23.37 | 23.4 | 23.37 | 23.4 | 4450.0 |
> showing 50 of 70,015 rows — these rows as CSV