PREVIEW / stock_30min / 2006-10-02
file: by_date/stock_30min/2006/2006-10-02.parquet size: 931 KB rows: 50,734 symbols: 2,384
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 |
|---|---|---|---|---|---|---|---|
| 2006-10-02 04:30:00 | AAPL | Stock | 2.7639 | 2.7679 | 2.7639 | 2.7679 | 10500.0 |
| 2006-10-02 05:00:00 | AAPL | Stock | 2.75 | 2.7511 | 2.7271 | 2.7271 | 19600.0 |
| 2006-10-02 05:30:00 | AAPL | Stock | 2.7271 | 2.7271 | 2.7271 | 2.7271 | 5600.0 |
| 2006-10-02 06:00:00 | AAPL | Stock | 2.6979 | 2.6979 | 2.6961 | 2.6961 | 114184.0 |
| 2006-10-02 06:30:00 | AAPL | Stock | 2.6979 | 2.6979 | 2.6979 | 2.6979 | 56000.0 |
| 2006-10-02 07:00:00 | AAPL | Stock | 2.6982 | 2.6982 | 2.6786 | 2.6821 | 733124.0 |
| 2006-10-02 07:30:00 | AAPL | Stock | 2.6893 | 2.6893 | 2.6843 | 2.6857 | 42000.0 |
| 2006-10-02 08:00:00 | AAPL | Stock | 2.6839 | 2.6996 | 2.6839 | 2.6943 | 4240404.0 |
| 2006-10-02 08:30:00 | AAPL | Stock | 2.6929 | 2.6964 | 2.6875 | 2.6911 | 3004316.0 |
| 2006-10-02 09:00:00 | AAPL | Stock | 2.6893 | 2.6929 | 2.6789 | 2.6821 | 3578484.0 |
| 2006-10-02 09:30:00 | AAPL | Stock | 2.6821 | 2.6914 | 2.6536 | 2.6632 | 141454208.0 |
| 2006-10-02 10:00:00 | AAPL | Stock | 2.6632 | 2.6693 | 2.6564 | 2.6664 | 67963980.0 |
| 2006-10-02 10:30:00 | AAPL | Stock | 2.6668 | 2.6714 | 2.6629 | 2.6664 | 52324580.0 |
| 2006-10-02 11:00:00 | AAPL | Stock | 2.6664 | 2.6707 | 2.6639 | 2.6707 | 28257488.0 |
| 2006-10-02 11:30:00 | AAPL | Stock | 2.6704 | 2.6818 | 2.67 | 2.6789 | 58034984.0 |
| 2006-10-02 12:00:00 | AAPL | Stock | 2.6793 | 2.7018 | 2.6786 | 2.6954 | 59810996.0 |
| 2006-10-02 12:30:00 | AAPL | Stock | 2.6954 | 2.7096 | 2.6929 | 2.6954 | 37645272.0 |
| 2006-10-02 13:00:00 | AAPL | Stock | 2.6957 | 2.6993 | 2.6914 | 2.6929 | 21893396.0 |
| 2006-10-02 13:30:00 | AAPL | Stock | 2.6929 | 2.6939 | 2.6657 | 2.67 | 57837836.0 |
| 2006-10-02 14:00:00 | AAPL | Stock | 2.6702 | 2.6871 | 2.665 | 2.675 | 38651620.0 |
| 2006-10-02 14:30:00 | AAPL | Stock | 2.675 | 2.6821 | 2.6704 | 2.675 | 28536452.0 |
| 2006-10-02 15:00:00 | AAPL | Stock | 2.675 | 2.6814 | 2.6711 | 2.6807 | 32210192.0 |
| 2006-10-02 15:30:00 | AAPL | Stock | 2.6807 | 2.6839 | 2.6732 | 2.6732 | 51581292.0 |
| 2006-10-02 16:00:00 | AAPL | Stock | 2.6732 | 2.6782 | 2.6696 | 2.6732 | 1071952.0 |
| 2006-10-02 16:30:00 | AAPL | Stock | 2.6732 | 2.6736 | 2.6729 | 2.6729 | 400680.0 |
| 2006-10-02 17:00:00 | AAPL | Stock | 2.6714 | 2.6736 | 2.6711 | 2.6725 | 778400.0 |
| 2006-10-02 17:30:00 | AAPL | Stock | 2.6725 | 2.6736 | 2.6721 | 2.6721 | 391104.0 |
| 2006-10-02 18:00:00 | AAPL | Stock | 2.6721 | 2.6736 | 2.6714 | 2.6721 | 277788.0 |
| 2006-10-02 18:30:00 | AAPL | Stock | 2.6729 | 2.6736 | 2.6729 | 2.6736 | 5600.0 |
| 2006-10-02 19:00:00 | AAPL | Stock | 2.675 | 2.675 | 2.6729 | 2.6729 | 54740.0 |
| 2006-10-02 19:30:00 | AAPL | Stock | 2.6736 | 2.675 | 2.6729 | 2.675 | 74200.0 |
| 2006-10-02 07:30:00 | MSFT | Stock | 27.27 | 27.27 | 27.27 | 27.27 | 1000.0 |
| 2006-10-02 08:00:00 | MSFT | Stock | 27.2 | 27.23 | 27.2 | 27.23 | 5200.0 |
| 2006-10-02 08:30:00 | MSFT | Stock | 27.21 | 27.35 | 27.21 | 27.35 | 62930.0 |
| 2006-10-02 09:00:00 | MSFT | Stock | 27.22 | 27.32 | 27.18 | 27.32 | 194855.0 |
| 2006-10-02 09:30:00 | MSFT | Stock | 27.32 | 27.38 | 27.17 | 27.37 | 4080908.0 |
| 2006-10-02 10:00:00 | MSFT | Stock | 27.36 | 27.45 | 27.35 | 27.45 | 3031752.0 |
| 2006-10-02 10:30:00 | MSFT | Stock | 27.45 | 27.48 | 27.42 | 27.46 | 2328156.0 |
| 2006-10-02 11:00:00 | MSFT | Stock | 27.46 | 27.46 | 27.38 | 27.41 | 2519833.0 |
| 2006-10-02 11:30:00 | MSFT | Stock | 27.41 | 27.49 | 27.41 | 27.47 | 2722367.0 |
| 2006-10-02 12:00:00 | MSFT | Stock | 27.47 | 27.48 | 27.46 | 27.48 | 1612868.0 |
| 2006-10-02 12:30:00 | MSFT | Stock | 27.47 | 27.48 | 27.43 | 27.44 | 1874387.0 |
| 2006-10-02 13:00:00 | MSFT | Stock | 27.44 | 27.46 | 27.42 | 27.44 | 1845326.0 |
| 2006-10-02 13:30:00 | MSFT | Stock | 27.44 | 27.45 | 27.15 | 27.33 | 8696817.0 |
| 2006-10-02 14:00:00 | MSFT | Stock | 27.34 | 27.44 | 27.3 | 27.37 | 4166014.0 |
| 2006-10-02 14:30:00 | MSFT | Stock | 27.36 | 27.39 | 27.34 | 27.35 | 2810760.0 |
| 2006-10-02 15:00:00 | MSFT | Stock | 27.36 | 27.42 | 27.35 | 27.41 | 2731261.0 |
| 2006-10-02 15:30:00 | MSFT | Stock | 27.41 | 27.44 | 27.32 | 27.34 | 6298228.0 |
| 2006-10-02 16:00:00 | MSFT | Stock | 27.35 | 27.37 | 27.31 | 27.34 | 297868.0 |
| 2006-10-02 16:30:00 | MSFT | Stock | 27.31 | 27.32 | 27.25 | 27.32 | 12603.0 |
> showing 50 of 50,734 rows — these rows as CSV