PREVIEW / stock_30min / 2006-10-12
file: by_date/stock_30min/2006/2006-10-12.parquet size: 932 KB rows: 50,710 symbols: 2,389
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-12 07:30:00 | AAPL | Stock | 2.6204 | 2.6204 | 2.6204 | 2.6204 | 33600.0 |
| 2006-10-12 08:00:00 | AAPL | Stock | 2.6196 | 2.6304 | 2.6164 | 2.6304 | 312200.0 |
| 2006-10-12 08:30:00 | AAPL | Stock | 2.6304 | 2.6354 | 2.6225 | 2.635 | 870520.0 |
| 2006-10-12 09:00:00 | AAPL | Stock | 2.6339 | 2.6343 | 2.6279 | 2.6318 | 1388492.0 |
| 2006-10-12 09:30:00 | AAPL | Stock | 2.6289 | 2.67 | 2.6286 | 2.6661 | 104065836.0 |
| 2006-10-12 10:00:00 | AAPL | Stock | 2.6668 | 2.6807 | 2.6621 | 2.6679 | 86186996.0 |
| 2006-10-12 10:30:00 | AAPL | Stock | 2.6682 | 2.6696 | 2.6554 | 2.6582 | 52265360.0 |
| 2006-10-12 11:00:00 | AAPL | Stock | 2.6582 | 2.6661 | 2.6536 | 2.6643 | 35950740.0 |
| 2006-10-12 11:30:00 | AAPL | Stock | 2.6646 | 2.6679 | 2.6557 | 2.6621 | 19828900.0 |
| 2006-10-12 12:00:00 | AAPL | Stock | 2.6621 | 2.6675 | 2.6604 | 2.6625 | 17185280.0 |
| 2006-10-12 12:30:00 | AAPL | Stock | 2.6629 | 2.6707 | 2.6614 | 2.6647 | 19170452.0 |
| 2006-10-12 13:00:00 | AAPL | Stock | 2.665 | 2.6671 | 2.6582 | 2.6614 | 12344920.0 |
| 2006-10-12 13:30:00 | AAPL | Stock | 2.6614 | 2.6639 | 2.6571 | 2.6589 | 15665412.0 |
| 2006-10-12 14:00:00 | AAPL | Stock | 2.6593 | 2.6786 | 2.6586 | 2.6743 | 38973928.0 |
| 2006-10-12 14:30:00 | AAPL | Stock | 2.6746 | 2.6857 | 2.6725 | 2.6821 | 42766948.0 |
| 2006-10-12 15:00:00 | AAPL | Stock | 2.6823 | 2.6879 | 2.6768 | 2.6836 | 55176128.0 |
| 2006-10-12 15:30:00 | AAPL | Stock | 2.6836 | 2.6925 | 2.6804 | 2.6807 | 77178892.0 |
| 2006-10-12 16:00:00 | AAPL | Stock | 2.6807 | 2.6875 | 2.6804 | 2.6875 | 993244.0 |
| 2006-10-12 16:30:00 | AAPL | Stock | 2.6875 | 2.6914 | 2.6875 | 2.6893 | 696640.0 |
| 2006-10-12 17:00:00 | AAPL | Stock | 2.6893 | 2.6911 | 2.6893 | 2.69 | 67200.0 |
| 2006-10-12 17:30:00 | AAPL | Stock | 2.6907 | 2.6911 | 2.6893 | 2.6911 | 93380.0 |
| 2006-10-12 18:00:00 | AAPL | Stock | 2.6904 | 2.6943 | 2.69 | 2.6936 | 237580.0 |
| 2006-10-12 18:30:00 | AAPL | Stock | 2.6936 | 2.6946 | 2.6936 | 2.6946 | 34664.0 |
| 2006-10-12 19:00:00 | AAPL | Stock | 2.6946 | 2.6946 | 2.6946 | 2.6946 | 25284.0 |
| 2006-10-12 19:30:00 | AAPL | Stock | 2.6936 | 2.6936 | 2.6921 | 2.6921 | 14420.0 |
| 2006-10-12 07:00:00 | MSFT | Stock | 27.49 | 27.54 | 27.49 | 27.54 | 200.0 |
| 2006-10-12 07:30:00 | MSFT | Stock | 27.54 | 27.54 | 27.54 | 27.54 | 350.0 |
| 2006-10-12 08:00:00 | MSFT | Stock | 27.51 | 27.54 | 27.51 | 27.54 | 2850.0 |
| 2006-10-12 08:30:00 | MSFT | Stock | 27.52 | 27.55 | 27.52 | 27.52 | 3400.0 |
| 2006-10-12 09:00:00 | MSFT | Stock | 27.55 | 27.59 | 27.53 | 27.59 | 157580.0 |
| 2006-10-12 09:30:00 | MSFT | Stock | 27.58 | 27.89 | 27.54 | 27.86 | 8617142.0 |
| 2006-10-12 10:00:00 | MSFT | Stock | 27.86 | 27.99 | 27.85 | 27.98 | 8224971.0 |
| 2006-10-12 10:30:00 | MSFT | Stock | 27.98 | 28.05 | 27.94 | 28.003 | 10280614.0 |
| 2006-10-12 11:00:00 | MSFT | Stock | 28.01 | 28.07 | 28.0 | 28.04 | 7509299.0 |
| 2006-10-12 11:30:00 | MSFT | Stock | 28.04 | 28.08 | 28.02 | 28.07 | 8019738.0 |
| 2006-10-12 12:00:00 | MSFT | Stock | 28.07 | 28.07 | 28.04 | 28.05 | 5074505.0 |
| 2006-10-12 12:30:00 | MSFT | Stock | 28.05 | 28.13 | 28.03 | 28.05 | 10573937.0 |
| 2006-10-12 13:00:00 | MSFT | Stock | 28.05 | 28.09 | 28.01 | 28.06 | 3497485.0 |
| 2006-10-12 13:30:00 | MSFT | Stock | 28.06 | 28.07 | 28.02 | 28.06 | 3471992.0 |
| 2006-10-12 14:00:00 | MSFT | Stock | 28.07 | 28.13 | 28.06 | 28.08 | 9334205.0 |
| 2006-10-12 14:30:00 | MSFT | Stock | 28.08 | 28.13 | 28.04 | 28.05 | 6030138.0 |
| 2006-10-12 15:00:00 | MSFT | Stock | 28.05 | 28.24 | 28.04 | 28.21 | 13533345.0 |
| 2006-10-12 15:30:00 | MSFT | Stock | 28.21 | 28.29 | 28.18 | 28.28 | 22760281.0 |
| 2006-10-12 16:00:00 | MSFT | Stock | 28.27 | 28.29 | 28.133 | 28.28 | 552050.0 |
| 2006-10-12 16:30:00 | MSFT | Stock | 28.26 | 28.28 | 28.25 | 28.27 | 27038.0 |
| 2006-10-12 17:00:00 | MSFT | Stock | 28.27 | 28.29 | 28.27 | 28.27 | 8900.0 |
| 2006-10-12 17:30:00 | MSFT | Stock | 28.27 | 28.29 | 28.27 | 28.29 | 19359.0 |
| 2006-10-12 18:00:00 | MSFT | Stock | 28.29 | 28.34 | 28.29 | 28.32 | 14735.0 |
| 2006-10-12 18:30:00 | MSFT | Stock | 28.32 | 28.34 | 28.32 | 28.34 | 5200.0 |
| 2006-10-12 19:00:00 | MSFT | Stock | 28.35 | 28.35 | 28.3 | 28.3 | 230.0 |
> showing 50 of 50,710 rows — these rows as CSV