PREVIEW / stock_30min / 2006-10-24
file: by_date/stock_30min/2006/2006-10-24.parquet size: 946 KB rows: 51,149 symbols: 2,396
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-24 08:00:00 | AAPL | Stock | 2.9054 | 2.9071 | 2.9018 | 2.9054 | 320432.0 |
| 2006-10-24 08:30:00 | AAPL | Stock | 2.9054 | 2.9064 | 2.9018 | 2.9043 | 625632.0 |
| 2006-10-24 09:00:00 | AAPL | Stock | 2.9029 | 2.9104 | 2.9004 | 2.9061 | 662312.0 |
| 2006-10-24 09:30:00 | AAPL | Stock | 2.9004 | 2.9171 | 2.8936 | 2.9043 | 68474112.0 |
| 2006-10-24 10:00:00 | AAPL | Stock | 2.9021 | 2.9054 | 2.8821 | 2.8954 | 56822248.0 |
| 2006-10-24 10:30:00 | AAPL | Stock | 2.8957 | 2.8989 | 2.8746 | 2.8864 | 48655628.0 |
| 2006-10-24 11:00:00 | AAPL | Stock | 2.8868 | 2.8929 | 2.8836 | 2.8914 | 43114960.0 |
| 2006-10-24 11:30:00 | AAPL | Stock | 2.8918 | 2.8954 | 2.8875 | 2.8882 | 27197296.0 |
| 2006-10-24 12:00:00 | AAPL | Stock | 2.8882 | 2.8964 | 2.8857 | 2.8921 | 26399296.0 |
| 2006-10-24 12:30:00 | AAPL | Stock | 2.8914 | 2.8921 | 2.875 | 2.8771 | 28316120.0 |
| 2006-10-24 13:00:00 | AAPL | Stock | 2.8768 | 2.8875 | 2.8746 | 2.8875 | 19423012.0 |
| 2006-10-24 13:30:00 | AAPL | Stock | 2.8871 | 2.8961 | 2.8871 | 2.8925 | 20207040.0 |
| 2006-10-24 14:00:00 | AAPL | Stock | 2.8929 | 2.9107 | 2.8893 | 2.9061 | 29988784.0 |
| 2006-10-24 14:30:00 | AAPL | Stock | 2.9064 | 2.9125 | 2.8643 | 2.9046 | 32195716.0 |
| 2006-10-24 15:00:00 | AAPL | Stock | 2.905 | 2.9064 | 2.8979 | 2.9011 | 17650388.0 |
| 2006-10-24 15:30:00 | AAPL | Stock | 2.9011 | 2.905 | 2.8943 | 2.8957 | 28517048.0 |
| 2006-10-24 16:00:00 | AAPL | Stock | 2.8957 | 2.9014 | 2.8946 | 2.8971 | 1394624.0 |
| 2006-10-24 16:30:00 | AAPL | Stock | 2.9011 | 2.9021 | 2.9011 | 2.9021 | 262668.0 |
| 2006-10-24 17:00:00 | AAPL | Stock | 2.9029 | 2.9057 | 2.8946 | 2.9057 | 308644.0 |
| 2006-10-24 17:30:00 | AAPL | Stock | 2.9036 | 2.9071 | 2.9007 | 2.9071 | 236404.0 |
| 2006-10-24 18:00:00 | AAPL | Stock | 2.9071 | 2.9071 | 2.9071 | 2.9071 | 11200.0 |
| 2006-10-24 18:30:00 | AAPL | Stock | 2.9029 | 2.9029 | 2.9029 | 2.9029 | 5600.0 |
| 2006-10-24 19:00:00 | AAPL | Stock | 2.9029 | 2.9071 | 2.9029 | 2.9071 | 15372.0 |
| 2006-10-24 19:30:00 | AAPL | Stock | 2.9068 | 2.9068 | 2.9068 | 2.9068 | 5600.0 |
| 2006-10-24 07:00:00 | MSFT | Stock | 28.42 | 28.42 | 28.42 | 28.42 | 100.0 |
| 2006-10-24 08:00:00 | MSFT | Stock | 28.43 | 28.43 | 28.4 | 28.4 | 1100.0 |
| 2006-10-24 08:30:00 | MSFT | Stock | 28.39 | 28.4 | 28.38 | 28.38 | 4050.0 |
| 2006-10-24 09:00:00 | MSFT | Stock | 28.38 | 28.44 | 28.34 | 28.38 | 61231.0 |
| 2006-10-24 09:30:00 | MSFT | Stock | 28.43 | 28.43 | 28.26 | 28.27 | 8204222.0 |
| 2006-10-24 10:00:00 | MSFT | Stock | 28.27 | 28.32 | 28.2 | 28.28 | 3994968.0 |
| 2006-10-24 10:30:00 | MSFT | Stock | 28.28 | 28.32 | 28.15 | 28.28 | 4856326.0 |
| 2006-10-24 11:00:00 | MSFT | Stock | 28.28 | 28.3 | 28.2 | 28.27 | 2952320.0 |
| 2006-10-24 11:30:00 | MSFT | Stock | 28.28 | 28.29 | 28.17 | 28.24 | 2554467.0 |
| 2006-10-24 12:00:00 | MSFT | Stock | 28.24 | 28.25 | 28.19 | 28.23 | 1902257.0 |
| 2006-10-24 12:30:00 | MSFT | Stock | 28.23 | 28.26 | 28.14 | 28.17 | 3512200.0 |
| 2006-10-24 13:00:00 | MSFT | Stock | 28.16 | 28.3 | 28.15 | 28.22 | 7529268.0 |
| 2006-10-24 13:30:00 | MSFT | Stock | 28.22 | 28.3 | 28.15 | 28.15 | 3527736.0 |
| 2006-10-24 14:00:00 | MSFT | Stock | 28.158 | 28.27 | 28.15 | 28.18 | 3121628.0 |
| 2006-10-24 14:30:00 | MSFT | Stock | 28.18 | 28.22 | 28.15 | 28.17 | 3291235.0 |
| 2006-10-24 15:00:00 | MSFT | Stock | 28.17 | 28.25 | 28.13 | 28.23 | 3958320.0 |
| 2006-10-24 15:30:00 | MSFT | Stock | 28.23 | 28.3 | 28.19 | 28.19 | 5689706.0 |
| 2006-10-24 16:00:00 | MSFT | Stock | 28.21 | 28.28 | 28.19 | 28.23 | 222120.0 |
| 2006-10-24 16:30:00 | MSFT | Stock | 28.24 | 28.25 | 28.19 | 28.19 | 12643.0 |
| 2006-10-24 17:00:00 | MSFT | Stock | 28.28 | 28.28 | 28.13 | 28.2 | 33069.0 |
| 2006-10-24 17:30:00 | MSFT | Stock | 28.2 | 28.2 | 28.13 | 28.15 | 22118.0 |
| 2006-10-24 18:00:00 | MSFT | Stock | 28.16 | 28.2 | 28.16 | 28.16 | 1984.0 |
| 2006-10-24 18:30:00 | MSFT | Stock | 28.16 | 28.16 | 28.16 | 28.16 | 200.0 |
| 2006-10-24 19:00:00 | MSFT | Stock | 28.16 | 28.16 | 28.16 | 28.16 | 100.0 |
| 2006-10-24 19:30:00 | MSFT | Stock | 28.15 | 28.16 | 28.15 | 28.16 | 1760.0 |
| 2006-10-24 07:00:00 | NVDA | Stock | 0.527 | 0.527 | 0.527 | 0.527 | 12000.0 |
> showing 50 of 51,149 rows — these rows as CSV