PREVIEW / stock_30min / 2009-08-05
file: by_date/stock_30min/2009/2009-08-05.parquet size: 1.3 MB rows: 73,880 symbols: 3,362
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-05 07:00:00 | AAPL | Stock | 5.8857 | 5.9246 | 5.8857 | 5.9246 | 9800.0 |
| 2009-08-05 07:30:00 | AAPL | Stock | 5.9018 | 5.9018 | 5.9018 | 5.9018 | 5600.0 |
| 2009-08-05 08:00:00 | AAPL | Stock | 5.9107 | 5.9364 | 5.8946 | 5.9321 | 612080.0 |
| 2009-08-05 08:30:00 | AAPL | Stock | 5.9314 | 5.9321 | 5.9143 | 5.9268 | 643300.0 |
| 2009-08-05 09:00:00 | AAPL | Stock | 5.9254 | 5.9282 | 5.9221 | 5.9221 | 353780.0 |
| 2009-08-05 09:30:00 | AAPL | Stock | 5.9214 | 5.9782 | 5.9107 | 5.9236 | 78740620.0 |
| 2009-08-05 10:00:00 | AAPL | Stock | 5.9236 | 5.9268 | 5.8886 | 5.92 | 48302520.0 |
| 2009-08-05 10:30:00 | AAPL | Stock | 5.9193 | 5.9201 | 5.8893 | 5.8932 | 27822676.0 |
| 2009-08-05 11:00:00 | AAPL | Stock | 5.8936 | 5.9089 | 5.8821 | 5.8889 | 23169776.0 |
| 2009-08-05 11:30:00 | AAPL | Stock | 5.8886 | 5.8957 | 5.8786 | 5.8836 | 18559884.0 |
| 2009-08-05 12:00:00 | AAPL | Stock | 5.8836 | 5.9011 | 5.8793 | 5.8907 | 21316344.0 |
| 2009-08-05 12:30:00 | AAPL | Stock | 5.8904 | 5.8918 | 5.8716 | 5.8761 | 21806288.0 |
| 2009-08-05 13:00:00 | AAPL | Stock | 5.8757 | 5.89 | 5.8646 | 5.885 | 20792352.0 |
| 2009-08-05 13:30:00 | AAPL | Stock | 5.8854 | 5.8907 | 5.8736 | 5.8767 | 15861020.0 |
| 2009-08-05 14:00:00 | AAPL | Stock | 5.8761 | 5.8836 | 5.8711 | 5.8771 | 14211624.0 |
| 2009-08-05 14:30:00 | AAPL | Stock | 5.8775 | 5.905 | 5.8707 | 5.8993 | 26252100.0 |
| 2009-08-05 15:00:00 | AAPL | Stock | 5.8993 | 5.91 | 5.8889 | 5.9021 | 24212272.0 |
| 2009-08-05 15:30:00 | AAPL | Stock | 5.9014 | 5.9071 | 5.8793 | 5.8929 | 43307208.0 |
| 2009-08-05 16:00:00 | AAPL | Stock | 5.9004 | 5.9056 | 5.8839 | 5.8968 | 24848152.0 |
| 2009-08-05 16:30:00 | AAPL | Stock | 5.8989 | 5.8989 | 5.8786 | 5.8829 | 876204.0 |
| 2009-08-05 17:00:00 | AAPL | Stock | 5.9074 | 5.9074 | 5.8679 | 5.8714 | 1950844.0 |
| 2009-08-05 17:30:00 | AAPL | Stock | 5.8714 | 5.8814 | 5.8607 | 5.8607 | 281624.0 |
| 2009-08-05 18:00:00 | AAPL | Stock | 5.8968 | 5.8968 | 5.8593 | 5.8643 | 180628.0 |
| 2009-08-05 18:30:00 | AAPL | Stock | 5.8611 | 5.8661 | 5.8504 | 5.8643 | 256928.0 |
| 2009-08-05 19:00:00 | AAPL | Stock | 5.8625 | 5.8679 | 5.8625 | 5.8643 | 51940.0 |
| 2009-08-05 19:30:00 | AAPL | Stock | 5.8643 | 5.8643 | 5.8579 | 5.8607 | 41356.0 |
| 2009-08-05 08:00:00 | MSFT | Stock | 23.77 | 23.84 | 23.75 | 23.79 | 19707.0 |
| 2009-08-05 08:30:00 | MSFT | Stock | 23.75 | 23.84 | 23.75 | 23.84 | 12961.0 |
| 2009-08-05 09:00:00 | MSFT | Stock | 23.84 | 23.88 | 23.73 | 23.83 | 18525.0 |
| 2009-08-05 09:30:00 | MSFT | Stock | 23.84 | 24.25 | 23.84 | 23.99 | 9588168.0 |
| 2009-08-05 10:00:00 | MSFT | Stock | 24.0 | 24.09 | 23.91 | 24.07 | 5616802.0 |
| 2009-08-05 10:30:00 | MSFT | Stock | 24.073 | 24.14 | 24.01 | 24.06 | 4030221.0 |
| 2009-08-05 11:00:00 | MSFT | Stock | 24.06 | 24.1 | 23.98 | 24.0 | 2811976.0 |
| 2009-08-05 11:30:00 | MSFT | Stock | 24.0 | 24.04 | 23.95 | 23.97 | 2129086.0 |
| 2009-08-05 12:00:00 | MSFT | Stock | 23.98 | 24.0 | 23.93 | 23.95 | 1698868.0 |
| 2009-08-05 12:30:00 | MSFT | Stock | 23.94 | 24.04 | 23.94 | 23.95 | 2490304.0 |
| 2009-08-05 13:00:00 | MSFT | Stock | 23.96 | 23.99 | 23.92 | 23.98 | 2726769.0 |
| 2009-08-05 13:30:00 | MSFT | Stock | 23.98 | 23.99 | 23.89 | 23.91 | 2372494.0 |
| 2009-08-05 14:00:00 | MSFT | Stock | 23.91 | 23.93 | 23.81 | 23.84 | 2010869.0 |
| 2009-08-05 14:30:00 | MSFT | Stock | 23.84 | 23.95 | 23.82 | 23.93 | 2648879.0 |
| 2009-08-05 15:00:00 | MSFT | Stock | 23.93 | 23.99 | 23.85 | 23.89 | 4253223.0 |
| 2009-08-05 15:30:00 | MSFT | Stock | 23.9 | 24.005 | 23.79 | 23.82 | 6812934.0 |
| 2009-08-05 16:00:00 | MSFT | Stock | 23.82 | 23.995 | 23.78 | 23.81 | 2915721.0 |
| 2009-08-05 16:30:00 | MSFT | Stock | 23.83 | 23.976 | 23.75 | 23.77 | 105844.0 |
| 2009-08-05 17:00:00 | MSFT | Stock | 23.75 | 23.77 | 23.7 | 23.74 | 32100.0 |
| 2009-08-05 17:30:00 | MSFT | Stock | 23.74 | 23.74 | 23.7 | 23.71 | 9100.0 |
| 2009-08-05 18:00:00 | MSFT | Stock | 23.71 | 23.74 | 23.71 | 23.72 | 6100.0 |
| 2009-08-05 18:30:00 | MSFT | Stock | 23.7 | 23.72 | 23.7 | 23.71 | 4601.0 |
| 2009-08-05 19:00:00 | MSFT | Stock | 23.74 | 23.85 | 23.71 | 23.82 | 13250.0 |
| 2009-08-05 19:30:00 | MSFT | Stock | 23.82 | 23.82 | 23.71 | 23.75 | 14050.0 |
> showing 50 of 73,880 rows — these rows as CSV