PREVIEW / stock_1hour / 2002-12-13
file: by_date/stock_1hour/2002/2002-12-13.parquet size: 403 KB rows: 19,373 symbols: 1,519
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 |
|---|---|---|---|---|---|---|---|
| 2002-12-13 08:00:00 | AAPL | Stock | 0.2716 | 0.2716 | 0.2716 | 0.2716 | 28000.0 |
| 2002-12-13 09:00:00 | AAPL | Stock | 0.2714 | 0.2714 | 0.2655 | 0.2661 | 25442592.0 |
| 2002-12-13 10:00:00 | AAPL | Stock | 0.2659 | 0.2659 | 0.263 | 0.2641 | 30687496.0 |
| 2002-12-13 11:00:00 | AAPL | Stock | 0.2641 | 0.2643 | 0.2616 | 0.2629 | 23107224.0 |
| 2002-12-13 12:00:00 | AAPL | Stock | 0.2627 | 0.2657 | 0.2627 | 0.265 | 11311944.0 |
| 2002-12-13 13:00:00 | AAPL | Stock | 0.2652 | 0.2664 | 0.2627 | 0.2638 | 9735208.0 |
| 2002-12-13 14:00:00 | AAPL | Stock | 0.2636 | 0.2657 | 0.263 | 0.2643 | 15478064.0 |
| 2002-12-13 15:00:00 | AAPL | Stock | 0.2641 | 0.2658 | 0.2625 | 0.2638 | 24790920.0 |
| 2002-12-13 16:00:00 | AAPL | Stock | 0.2645 | 0.2657 | 0.2623 | 0.2641 | 6864648.0 |
| 2002-12-13 08:00:00 | MSFT | Stock | 26.9225 | 26.925 | 26.745 | 26.825 | 150440.0 |
| 2002-12-13 09:00:00 | MSFT | Stock | 26.8 | 27.095 | 26.59 | 26.635 | 8994956.0 |
| 2002-12-13 10:00:00 | MSFT | Stock | 26.63 | 26.69 | 26.33 | 26.5155 | 14095574.0 |
| 2002-12-13 11:00:00 | MSFT | Stock | 26.5155 | 26.565 | 26.405 | 26.455 | 6148690.0 |
| 2002-12-13 12:00:00 | MSFT | Stock | 26.46 | 26.7 | 26.4 | 26.65 | 6259728.0 |
| 2002-12-13 13:00:00 | MSFT | Stock | 26.65 | 26.71 | 26.5 | 26.54 | 4578168.0 |
| 2002-12-13 14:00:00 | MSFT | Stock | 26.545 | 26.5555 | 26.3505 | 26.3505 | 5096746.0 |
| 2002-12-13 15:00:00 | MSFT | Stock | 26.3555 | 26.465 | 26.25 | 26.265 | 10539944.0 |
| 2002-12-13 16:00:00 | MSFT | Stock | 26.262 | 26.325 | 26.23 | 26.25 | 3202298.0 |
| 2002-12-13 17:00:00 | MSFT | Stock | 26.25 | 26.27 | 26.205 | 26.245 | 35560.0 |
| 2002-12-13 18:00:00 | MSFT | Stock | 26.2255 | 26.325 | 26.225 | 26.325 | 17472.0 |
| 2002-12-13 08:00:00 | NVDA | Stock | 0.1133 | 0.1133 | 0.1102 | 0.1125 | 2790000.0 |
| 2002-12-13 09:00:00 | NVDA | Stock | 0.1124 | 0.1164 | 0.1109 | 0.1111 | 125142840.0 |
| 2002-12-13 10:00:00 | NVDA | Stock | 0.111 | 0.1119 | 0.1109 | 0.1117 | 98136240.0 |
| 2002-12-13 11:00:00 | NVDA | Stock | 0.1117 | 0.1117 | 0.1102 | 0.1115 | 103687680.0 |
| 2002-12-13 12:00:00 | NVDA | Stock | 0.1114 | 0.112 | 0.1106 | 0.1118 | 84396480.0 |
| 2002-12-13 13:00:00 | NVDA | Stock | 0.1118 | 0.112 | 0.1104 | 0.1114 | 63167400.0 |
| 2002-12-13 14:00:00 | NVDA | Stock | 0.1114 | 0.1114 | 0.1095 | 0.1099 | 61251240.0 |
| 2002-12-13 15:00:00 | NVDA | Stock | 0.11 | 0.1117 | 0.1095 | 0.1103 | 114522360.0 |
| 2002-12-13 16:00:00 | NVDA | Stock | 0.1103 | 0.1105 | 0.1096 | 0.1103 | 11108040.0 |
| 2002-12-13 17:00:00 | NVDA | Stock | 0.1102 | 0.1104 | 0.1098 | 0.1104 | 678000.0 |
| 2002-12-13 18:00:00 | NVDA | Stock | 0.1104 | 0.1105 | 0.1101 | 0.1101 | 768000.0 |
| 2002-12-13 08:00:00 | AMZN | Stock | 1.1025 | 1.1026 | 1.0935 | 1.0955 | 205560.0 |
| 2002-12-13 09:00:00 | AMZN | Stock | 1.0955 | 1.113 | 1.0935 | 1.1025 | 9145940.0 |
| 2002-12-13 10:00:00 | AMZN | Stock | 1.1025 | 1.111 | 1.0975 | 1.1005 | 13410660.0 |
| 2002-12-13 11:00:00 | AMZN | Stock | 1.101 | 1.102 | 1.0993 | 1.1 | 4377540.0 |
| 2002-12-13 12:00:00 | AMZN | Stock | 1.0995 | 1.1075 | 1.0955 | 1.1056 | 8028560.0 |
| 2002-12-13 13:00:00 | AMZN | Stock | 1.1055 | 1.11 | 1.1015 | 1.107 | 6653980.0 |
| 2002-12-13 14:00:00 | AMZN | Stock | 1.1065 | 1.1135 | 1.1065 | 1.1085 | 10239080.0 |
| 2002-12-13 15:00:00 | AMZN | Stock | 1.1085 | 1.1175 | 1.1045 | 1.109 | 13419880.0 |
| 2002-12-13 16:00:00 | AMZN | Stock | 1.109 | 1.116 | 1.105 | 1.109 | 1363560.0 |
| 2002-12-13 17:00:00 | AMZN | Stock | 1.1089 | 1.1135 | 1.104 | 1.105 | 639440.0 |
| 2002-12-13 18:00:00 | AMZN | Stock | 1.108 | 1.108 | 1.108 | 1.108 | 30000.0 |
| 2002-12-13 09:00:00 | CL | Stock | 26.545 | 26.545 | 26.29 | 26.36 | 293200.0 |
| 2002-12-13 10:00:00 | CL | Stock | 26.355 | 26.405 | 26.275 | 26.275 | 504600.0 |
| 2002-12-13 11:00:00 | CL | Stock | 26.27 | 26.275 | 26.17 | 26.17 | 511000.0 |
| 2002-12-13 12:00:00 | CL | Stock | 26.17 | 26.335 | 26.095 | 26.325 | 554800.0 |
| 2002-12-13 13:00:00 | CL | Stock | 26.325 | 26.335 | 26.19 | 26.28 | 498600.0 |
| 2002-12-13 14:00:00 | CL | Stock | 26.285 | 26.4 | 26.28 | 26.285 | 402000.0 |
| 2002-12-13 15:00:00 | CL | Stock | 26.285 | 26.505 | 26.275 | 26.4 | 1083600.0 |
| 2002-12-13 16:00:00 | CL | Stock | 26.425 | 26.45 | 26.415 | 26.45 | 264400.0 |
> showing 50 of 19,373 rows — these rows as CSV