PREVIEW / stock_1hour / 2003-03-18
file: by_date/stock_1hour/2003/2003-03-18.parquet size: 427 KB rows: 21,216 symbols: 1,555
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 |
|---|---|---|---|---|---|---|---|
| 2003-03-18 08:00:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 5600.0 |
| 2003-03-18 09:00:00 | AAPL | Stock | 0.2679 | 0.2682 | 0.2646 | 0.2652 | 23651096.0 |
| 2003-03-18 10:00:00 | AAPL | Stock | 0.2652 | 0.2695 | 0.2648 | 0.2664 | 36625232.0 |
| 2003-03-18 11:00:00 | AAPL | Stock | 0.2664 | 0.2677 | 0.2652 | 0.267 | 12327840.0 |
| 2003-03-18 12:00:00 | AAPL | Stock | 0.2673 | 0.2688 | 0.2671 | 0.2684 | 17381336.0 |
| 2003-03-18 13:00:00 | AAPL | Stock | 0.2682 | 0.2694 | 0.268 | 0.2688 | 27557040.0 |
| 2003-03-18 14:00:00 | AAPL | Stock | 0.2688 | 0.2689 | 0.2663 | 0.2686 | 26072704.0 |
| 2003-03-18 15:00:00 | AAPL | Stock | 0.2686 | 0.2693 | 0.2669 | 0.2679 | 59782520.0 |
| 2003-03-18 16:00:00 | AAPL | Stock | 0.2679 | 0.268 | 0.2671 | 0.2675 | 8881600.0 |
| 2003-03-18 17:00:00 | AAPL | Stock | 0.2676 | 0.2677 | 0.2671 | 0.2671 | 6140400.0 |
| 2003-03-18 08:00:00 | MSFT | Stock | 25.85 | 26.6 | 25.85 | 26.08 | 451399.0 |
| 2003-03-18 09:00:00 | MSFT | Stock | 26.08 | 26.27 | 25.5 | 25.541 | 12423919.0 |
| 2003-03-18 10:00:00 | MSFT | Stock | 25.5479 | 26.0 | 25.52 | 25.78 | 13493815.0 |
| 2003-03-18 11:00:00 | MSFT | Stock | 25.78 | 25.92 | 25.646 | 25.76 | 7461692.0 |
| 2003-03-18 12:00:00 | MSFT | Stock | 25.76 | 25.948 | 25.73 | 25.85 | 4600173.0 |
| 2003-03-18 13:00:00 | MSFT | Stock | 25.8421 | 26.004 | 25.79 | 25.93 | 6510511.0 |
| 2003-03-18 14:00:00 | MSFT | Stock | 25.9379 | 25.97 | 25.67 | 25.8 | 11283810.0 |
| 2003-03-18 15:00:00 | MSFT | Stock | 25.799 | 26.04 | 25.72 | 26.04 | 14109305.0 |
| 2003-03-18 16:00:00 | MSFT | Stock | 26.04 | 26.19 | 25.971 | 26.07 | 1470876.0 |
| 2003-03-18 17:00:00 | MSFT | Stock | 26.0267 | 26.093 | 25.65 | 25.829 | 994994.0 |
| 2003-03-18 18:00:00 | MSFT | Stock | 25.79 | 26.04 | 25.76 | 25.831 | 27225.0 |
| 2003-03-18 08:00:00 | NVDA | Stock | 0.1183 | 0.1208 | 0.1183 | 0.12 | 9432120.0 |
| 2003-03-18 09:00:00 | NVDA | Stock | 0.12 | 0.12 | 0.1152 | 0.1153 | 188395200.0 |
| 2003-03-18 10:00:00 | NVDA | Stock | 0.1153 | 0.1191 | 0.115 | 0.1172 | 206390280.0 |
| 2003-03-18 11:00:00 | NVDA | Stock | 0.1172 | 0.1176 | 0.1167 | 0.1173 | 81411960.0 |
| 2003-03-18 12:00:00 | NVDA | Stock | 0.1172 | 0.1177 | 0.1162 | 0.117 | 82699920.0 |
| 2003-03-18 13:00:00 | NVDA | Stock | 0.117 | 0.1177 | 0.1169 | 0.1172 | 73487040.0 |
| 2003-03-18 14:00:00 | NVDA | Stock | 0.1172 | 0.1174 | 0.1158 | 0.1165 | 118372200.0 |
| 2003-03-18 15:00:00 | NVDA | Stock | 0.1167 | 0.1175 | 0.1161 | 0.1175 | 123310560.0 |
| 2003-03-18 16:00:00 | NVDA | Stock | 0.1175 | 0.1175 | 0.1162 | 0.1166 | 10059960.0 |
| 2003-03-18 17:00:00 | NVDA | Stock | 0.1173 | 0.1173 | 0.1166 | 0.1169 | 4872000.0 |
| 2003-03-18 18:00:00 | NVDA | Stock | 0.1169 | 0.1172 | 0.1162 | 0.1163 | 2868000.0 |
| 2003-03-18 08:00:00 | AMZN | Stock | 1.3375 | 1.345 | 1.3225 | 1.3225 | 366000.0 |
| 2003-03-18 09:00:00 | AMZN | Stock | 1.3225 | 1.3275 | 1.3075 | 1.3125 | 41377080.0 |
| 2003-03-18 10:00:00 | AMZN | Stock | 1.313 | 1.323 | 1.305 | 1.309 | 31272660.0 |
| 2003-03-18 11:00:00 | AMZN | Stock | 1.3095 | 1.3225 | 1.307 | 1.315 | 18270580.0 |
| 2003-03-18 12:00:00 | AMZN | Stock | 1.315 | 1.322 | 1.312 | 1.3185 | 9414980.0 |
| 2003-03-18 13:00:00 | AMZN | Stock | 1.3185 | 1.322 | 1.315 | 1.32 | 7189520.0 |
| 2003-03-18 14:00:00 | AMZN | Stock | 1.32 | 1.32 | 1.3095 | 1.318 | 14095180.0 |
| 2003-03-18 15:00:00 | AMZN | Stock | 1.318 | 1.341 | 1.3175 | 1.3385 | 35488380.0 |
| 2003-03-18 16:00:00 | AMZN | Stock | 1.34 | 1.345 | 1.3355 | 1.3375 | 2554000.0 |
| 2003-03-18 17:00:00 | AMZN | Stock | 1.3383 | 1.339 | 1.3193 | 1.339 | 1551300.0 |
| 2003-03-18 18:00:00 | AMZN | Stock | 1.339 | 1.339 | 1.332 | 1.3335 | 194000.0 |
| 2003-03-18 09:00:00 | CL | Stock | 26.825 | 26.845 | 26.65 | 26.67 | 445800.0 |
| 2003-03-18 10:00:00 | CL | Stock | 26.675 | 26.8 | 26.62 | 26.635 | 595800.0 |
| 2003-03-18 11:00:00 | CL | Stock | 26.64 | 26.9 | 26.61 | 26.79 | 446400.0 |
| 2003-03-18 12:00:00 | CL | Stock | 26.785 | 26.885 | 26.735 | 26.88 | 334200.0 |
| 2003-03-18 13:00:00 | CL | Stock | 26.875 | 26.975 | 26.795 | 26.915 | 354000.0 |
| 2003-03-18 14:00:00 | CL | Stock | 26.92 | 26.92 | 26.725 | 26.795 | 565000.0 |
| 2003-03-18 15:00:00 | CL | Stock | 26.765 | 26.785 | 26.6 | 26.745 | 647000.0 |
> showing 50 of 21,216 rows — these rows as CSV