PREVIEW / stock_30min / 2004-09-27
file: by_date/stock_30min/2004/2004-09-27.parquet size: 769 KB rows: 41,627 symbols: 1,835
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-27 08:00:00 | AAPL | Stock | 0.6639 | 0.6639 | 0.6638 | 0.6638 | 48720.0 |
| 2004-09-27 08:30:00 | AAPL | Stock | 0.6618 | 0.6638 | 0.6618 | 0.6636 | 89600.0 |
| 2004-09-27 09:00:00 | AAPL | Stock | 0.662 | 0.6641 | 0.6602 | 0.6604 | 2745400.0 |
| 2004-09-27 09:30:00 | AAPL | Stock | 0.6602 | 0.663 | 0.6577 | 0.6627 | 60188520.0 |
| 2004-09-27 10:00:00 | AAPL | Stock | 0.6625 | 0.6727 | 0.662 | 0.6727 | 44311176.0 |
| 2004-09-27 10:30:00 | AAPL | Stock | 0.6725 | 0.6757 | 0.6723 | 0.6739 | 63212744.0 |
| 2004-09-27 11:00:00 | AAPL | Stock | 0.6738 | 0.6782 | 0.6736 | 0.6771 | 45382624.0 |
| 2004-09-27 11:30:00 | AAPL | Stock | 0.677 | 0.6782 | 0.6761 | 0.6777 | 25634392.0 |
| 2004-09-27 12:00:00 | AAPL | Stock | 0.6779 | 0.6779 | 0.6721 | 0.6732 | 29834392.0 |
| 2004-09-27 12:30:00 | AAPL | Stock | 0.6732 | 0.6766 | 0.6707 | 0.6759 | 19423768.0 |
| 2004-09-27 13:00:00 | AAPL | Stock | 0.6761 | 0.6761 | 0.6725 | 0.6755 | 10683288.0 |
| 2004-09-27 13:30:00 | AAPL | Stock | 0.6755 | 0.6755 | 0.6734 | 0.675 | 6427568.0 |
| 2004-09-27 14:00:00 | AAPL | Stock | 0.675 | 0.6768 | 0.6713 | 0.6729 | 10932040.0 |
| 2004-09-27 14:30:00 | AAPL | Stock | 0.6727 | 0.6743 | 0.6725 | 0.6729 | 7948696.0 |
| 2004-09-27 15:00:00 | AAPL | Stock | 0.6732 | 0.6743 | 0.6714 | 0.6738 | 16656080.0 |
| 2004-09-27 15:30:00 | AAPL | Stock | 0.6739 | 0.6739 | 0.6689 | 0.67 | 27363840.0 |
| 2004-09-27 16:00:00 | AAPL | Stock | 0.6702 | 0.6721 | 0.6696 | 0.6705 | 4021976.0 |
| 2004-09-27 16:30:00 | AAPL | Stock | 0.6702 | 0.6702 | 0.6702 | 0.6702 | 1300152.0 |
| 2004-09-27 17:00:00 | AAPL | Stock | 0.6705 | 0.6705 | 0.6702 | 0.6702 | 868336.0 |
| 2004-09-27 08:30:00 | MSFT | Stock | 27.27 | 27.27 | 27.22 | 27.23 | 14600.0 |
| 2004-09-27 09:00:00 | MSFT | Stock | 27.22 | 27.25 | 27.16 | 27.17 | 326800.0 |
| 2004-09-27 09:30:00 | MSFT | Stock | 27.16 | 27.2858 | 27.13 | 27.248 | 5393508.0 |
| 2004-09-27 10:00:00 | MSFT | Stock | 27.25 | 27.26 | 27.21 | 27.23 | 2573441.0 |
| 2004-09-27 10:30:00 | MSFT | Stock | 27.22 | 27.28 | 27.21 | 27.24 | 2727528.0 |
| 2004-09-27 11:00:00 | MSFT | Stock | 27.24 | 27.29 | 27.23 | 27.27 | 1693638.0 |
| 2004-09-27 11:30:00 | MSFT | Stock | 27.27 | 27.28 | 27.23 | 27.26 | 2009928.0 |
| 2004-09-27 12:00:00 | MSFT | Stock | 27.26 | 27.31 | 27.25 | 27.26 | 2287202.0 |
| 2004-09-27 12:30:00 | MSFT | Stock | 27.26 | 27.32 | 27.25 | 27.29 | 1758257.0 |
| 2004-09-27 13:00:00 | MSFT | Stock | 27.29 | 27.3 | 27.25 | 27.29 | 1199746.0 |
| 2004-09-27 13:30:00 | MSFT | Stock | 27.29 | 27.3 | 27.26 | 27.27 | 1483728.0 |
| 2004-09-27 14:00:00 | MSFT | Stock | 27.28 | 27.3 | 27.23 | 27.26 | 2699216.0 |
| 2004-09-27 14:30:00 | MSFT | Stock | 27.26 | 27.3 | 27.25 | 27.26 | 4097600.0 |
| 2004-09-27 15:00:00 | MSFT | Stock | 27.26 | 27.2736 | 27.23 | 27.24 | 2448726.0 |
| 2004-09-27 15:30:00 | MSFT | Stock | 27.24 | 27.26 | 27.14 | 27.24 | 8796503.0 |
| 2004-09-27 16:00:00 | MSFT | Stock | 27.23 | 27.29 | 27.15 | 27.28 | 3904751.0 |
| 2004-09-27 16:30:00 | MSFT | Stock | 27.26 | 27.3 | 27.19 | 27.25 | 474369.0 |
| 2004-09-27 17:00:00 | MSFT | Stock | 27.26 | 27.26 | 27.19 | 27.25 | 132718.0 |
| 2004-09-27 17:30:00 | MSFT | Stock | 27.25 | 27.2524 | 27.25 | 27.2524 | 87400.0 |
| 2004-09-27 18:00:00 | MSFT | Stock | 27.25 | 27.26 | 27.25 | 27.25 | 4750.0 |
| 2004-09-27 09:00:00 | NVDA | Stock | 0.1158 | 0.1164 | 0.1158 | 0.1162 | 744000.0 |
| 2004-09-27 09:30:00 | NVDA | Stock | 0.1162 | 0.1165 | 0.1129 | 0.1145 | 83488920.0 |
| 2004-09-27 10:00:00 | NVDA | Stock | 0.1144 | 0.1165 | 0.1142 | 0.1162 | 61001400.0 |
| 2004-09-27 10:30:00 | NVDA | Stock | 0.1162 | 0.1175 | 0.116 | 0.1162 | 40152480.0 |
| 2004-09-27 11:00:00 | NVDA | Stock | 0.1162 | 0.1171 | 0.116 | 0.1162 | 30259320.0 |
| 2004-09-27 11:30:00 | NVDA | Stock | 0.1162 | 0.1163 | 0.1154 | 0.1158 | 19138440.0 |
| 2004-09-27 12:00:00 | NVDA | Stock | 0.1157 | 0.1166 | 0.1155 | 0.1156 | 10410600.0 |
| 2004-09-27 12:30:00 | NVDA | Stock | 0.1156 | 0.1164 | 0.1153 | 0.1162 | 12303600.0 |
| 2004-09-27 13:00:00 | NVDA | Stock | 0.1162 | 0.1162 | 0.1155 | 0.1161 | 10758240.0 |
| 2004-09-27 13:30:00 | NVDA | Stock | 0.1162 | 0.1165 | 0.1157 | 0.1165 | 12046200.0 |
| 2004-09-27 14:00:00 | NVDA | Stock | 0.1166 | 0.1167 | 0.1157 | 0.1157 | 9505320.0 |
> showing 50 of 41,627 rows — these rows as CSV