PREVIEW / stock_1hour / 2004-10-15
file: by_date/stock_1hour/2004/2004-10-15.parquet size: 507 KB rows: 23,804 symbols: 1,836
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-10-15 08:00:00 | AAPL | Stock | 0.8005 | 0.8036 | 0.7993 | 0.8032 | 1280048.0 |
| 2004-10-15 09:00:00 | AAPL | Stock | 0.8032 | 0.8039 | 0.7895 | 0.79 | 152700576.0 |
| 2004-10-15 10:00:00 | AAPL | Stock | 0.79 | 0.8082 | 0.7891 | 0.8038 | 207213720.0 |
| 2004-10-15 11:00:00 | AAPL | Stock | 0.8036 | 0.8041 | 0.7934 | 0.8011 | 92491224.0 |
| 2004-10-15 12:00:00 | AAPL | Stock | 0.8014 | 0.8116 | 0.8 | 0.8104 | 97608112.0 |
| 2004-10-15 13:00:00 | AAPL | Stock | 0.8102 | 0.8118 | 0.8036 | 0.8075 | 106037736.0 |
| 2004-10-15 14:00:00 | AAPL | Stock | 0.8077 | 0.8079 | 0.8 | 0.8052 | 108932992.0 |
| 2004-10-15 15:00:00 | AAPL | Stock | 0.8048 | 0.8145 | 0.8021 | 0.8143 | 189072688.0 |
| 2004-10-15 16:00:00 | AAPL | Stock | 0.8141 | 0.8157 | 0.8125 | 0.8134 | 20065472.0 |
| 2004-10-15 17:00:00 | AAPL | Stock | 0.8134 | 0.8134 | 0.8125 | 0.8132 | 41440.0 |
| 2004-10-15 18:00:00 | AAPL | Stock | 0.8143 | 0.8143 | 0.8143 | 0.8143 | 44800.0 |
| 2004-10-15 08:00:00 | MSFT | Stock | 27.85 | 27.93 | 27.8 | 27.9 | 20281.0 |
| 2004-10-15 09:00:00 | MSFT | Stock | 27.9 | 28.06 | 27.89 | 27.93 | 7957604.0 |
| 2004-10-15 10:00:00 | MSFT | Stock | 27.93 | 28.05 | 27.93 | 28.02 | 6019751.0 |
| 2004-10-15 11:00:00 | MSFT | Stock | 28.02 | 28.07 | 27.95 | 27.97 | 4497296.0 |
| 2004-10-15 12:00:00 | MSFT | Stock | 27.97 | 28.2 | 27.88 | 28.13 | 6987201.0 |
| 2004-10-15 13:00:00 | MSFT | Stock | 28.13 | 28.24 | 28.1 | 28.16 | 4199557.0 |
| 2004-10-15 14:00:00 | MSFT | Stock | 28.16 | 28.21 | 28.02 | 28.04 | 4536283.0 |
| 2004-10-15 15:00:00 | MSFT | Stock | 28.04 | 28.05 | 27.91 | 27.98 | 10054129.0 |
| 2004-10-15 16:00:00 | MSFT | Stock | 27.99 | 28.08 | 27.97 | 28.05 | 1374905.0 |
| 2004-10-15 17:00:00 | MSFT | Stock | 28.06 | 28.07 | 28.0255 | 28.07 | 63708.0 |
| 2004-10-15 09:00:00 | NVDA | Stock | 0.115 | 0.1154 | 0.1131 | 0.1132 | 78473880.0 |
| 2004-10-15 10:00:00 | NVDA | Stock | 0.1132 | 0.1132 | 0.109 | 0.1119 | 453501240.0 |
| 2004-10-15 11:00:00 | NVDA | Stock | 0.1119 | 0.1125 | 0.1112 | 0.1114 | 134410440.0 |
| 2004-10-15 12:00:00 | NVDA | Stock | 0.1113 | 0.1116 | 0.1105 | 0.1107 | 147571440.0 |
| 2004-10-15 13:00:00 | NVDA | Stock | 0.1106 | 0.112 | 0.1106 | 0.1117 | 125255760.0 |
| 2004-10-15 14:00:00 | NVDA | Stock | 0.1117 | 0.1125 | 0.1117 | 0.1125 | 85837440.0 |
| 2004-10-15 15:00:00 | NVDA | Stock | 0.1125 | 0.1125 | 0.1107 | 0.1118 | 206571000.0 |
| 2004-10-15 16:00:00 | NVDA | Stock | 0.1117 | 0.1124 | 0.1116 | 0.1116 | 15782160.0 |
| 2004-10-15 17:00:00 | NVDA | Stock | 0.1116 | 0.1128 | 0.1102 | 0.1128 | 438000.0 |
| 2004-10-15 08:00:00 | AMZN | Stock | 1.95 | 1.9565 | 1.95 | 1.9565 | 439500.0 |
| 2004-10-15 09:00:00 | AMZN | Stock | 1.9565 | 1.9835 | 1.9425 | 1.9445 | 20225080.0 |
| 2004-10-15 10:00:00 | AMZN | Stock | 1.9445 | 1.9575 | 1.936 | 1.936 | 24287560.0 |
| 2004-10-15 11:00:00 | AMZN | Stock | 1.9365 | 1.9365 | 1.907 | 1.912 | 26296540.0 |
| 2004-10-15 12:00:00 | AMZN | Stock | 1.9125 | 1.917 | 1.894 | 1.9165 | 30532560.0 |
| 2004-10-15 13:00:00 | AMZN | Stock | 1.9165 | 1.924 | 1.9125 | 1.921 | 13790000.0 |
| 2004-10-15 14:00:00 | AMZN | Stock | 1.9205 | 1.9245 | 1.9115 | 1.918 | 15714900.0 |
| 2004-10-15 15:00:00 | AMZN | Stock | 1.918 | 1.9276 | 1.91 | 1.9265 | 23656200.0 |
| 2004-10-15 16:00:00 | AMZN | Stock | 1.926 | 1.928 | 1.9185 | 1.9275 | 1694940.0 |
| 2004-10-15 17:00:00 | AMZN | Stock | 1.9275 | 1.9275 | 1.925 | 1.9275 | 155640.0 |
| 2004-10-15 09:00:00 | CL | Stock | 22.125 | 22.14 | 21.905 | 21.925 | 1278200.0 |
| 2004-10-15 10:00:00 | CL | Stock | 21.935 | 21.995 | 21.92 | 21.965 | 734800.0 |
| 2004-10-15 11:00:00 | CL | Stock | 21.96 | 22.075 | 21.93 | 22.065 | 960800.0 |
| 2004-10-15 12:00:00 | CL | Stock | 22.065 | 22.185 | 22.05 | 22.17 | 1221800.0 |
| 2004-10-15 13:00:00 | CL | Stock | 22.17 | 22.175 | 22.12 | 22.125 | 848800.0 |
| 2004-10-15 14:00:00 | CL | Stock | 22.13 | 22.135 | 22.025 | 22.045 | 703600.0 |
| 2004-10-15 15:00:00 | CL | Stock | 22.045 | 22.05 | 21.905 | 21.965 | 1473800.0 |
> showing 47 of 23,804 rows — these rows as CSV