PREVIEW / stock_1hour / 2002-05-16
file: by_date/stock_1hour/2002/2002-05-16.parquet size: 411 KB rows: 18,899 symbols: 1,414
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-05-16 08:00:00 | AAPL | Stock | 0.4513 | 0.4861 | 0.4511 | 0.4511 | 296800.0 |
| 2002-05-16 09:00:00 | AAPL | Stock | 0.4513 | 0.4513 | 0.4425 | 0.4434 | 30884000.0 |
| 2002-05-16 10:00:00 | AAPL | Stock | 0.4446 | 0.4538 | 0.4434 | 0.4538 | 46866400.0 |
| 2002-05-16 11:00:00 | AAPL | Stock | 0.4536 | 0.4545 | 0.4491 | 0.4496 | 20759200.0 |
| 2002-05-16 12:00:00 | AAPL | Stock | 0.4491 | 0.4491 | 0.442 | 0.4486 | 22293600.0 |
| 2002-05-16 13:00:00 | AAPL | Stock | 0.4484 | 0.4489 | 0.4455 | 0.4466 | 13580000.0 |
| 2002-05-16 14:00:00 | AAPL | Stock | 0.4468 | 0.4527 | 0.4466 | 0.4511 | 16072000.0 |
| 2002-05-16 15:00:00 | AAPL | Stock | 0.4511 | 0.4513 | 0.4454 | 0.4505 | 58021600.0 |
| 2002-05-16 16:00:00 | AAPL | Stock | 0.4502 | 0.4596 | 0.448 | 0.4502 | 8506400.0 |
| 2002-05-16 17:00:00 | AAPL | Stock | 0.448 | 0.4496 | 0.448 | 0.4496 | 240800.0 |
| 2002-05-16 08:00:00 | MSFT | Stock | 27.5 | 27.725 | 27.03 | 27.35 | 174400.0 |
| 2002-05-16 09:00:00 | MSFT | Stock | 27.325 | 27.745 | 27.125 | 27.58 | 8204400.0 |
| 2002-05-16 10:00:00 | MSFT | Stock | 27.5755 | 28.02 | 27.505 | 27.955 | 11518200.0 |
| 2002-05-16 11:00:00 | MSFT | Stock | 27.9545 | 28.005 | 27.78 | 27.885 | 4828400.0 |
| 2002-05-16 12:00:00 | MSFT | Stock | 27.89 | 27.9 | 27.5845 | 27.735 | 5031600.0 |
| 2002-05-16 13:00:00 | MSFT | Stock | 27.725 | 27.846 | 27.65 | 27.685 | 3911000.0 |
| 2002-05-16 14:00:00 | MSFT | Stock | 27.685 | 27.875 | 27.655 | 27.69 | 5504200.0 |
| 2002-05-16 15:00:00 | MSFT | Stock | 27.69 | 27.89 | 27.5775 | 27.875 | 8368800.0 |
| 2002-05-16 16:00:00 | MSFT | Stock | 27.87 | 28.0 | 27.625 | 27.875 | 2733200.0 |
| 2002-05-16 17:00:00 | MSFT | Stock | 27.905 | 27.95 | 27.67 | 27.945 | 345600.0 |
| 2002-05-16 18:00:00 | MSFT | Stock | 27.88 | 27.88 | 27.125 | 27.125 | 11200.0 |
| 2002-05-16 08:00:00 | NVDA | Stock | 0.316 | 0.3204 | 0.3144 | 0.3144 | 2136000.0 |
| 2002-05-16 09:00:00 | NVDA | Stock | 0.315 | 0.3229 | 0.3112 | 0.3145 | 185760000.0 |
| 2002-05-16 10:00:00 | NVDA | Stock | 0.3145 | 0.3167 | 0.3096 | 0.3157 | 241980000.0 |
| 2002-05-16 11:00:00 | NVDA | Stock | 0.3157 | 0.3158 | 0.3125 | 0.3127 | 74616000.0 |
| 2002-05-16 12:00:00 | NVDA | Stock | 0.3127 | 0.3181 | 0.3107 | 0.3173 | 109836000.0 |
| 2002-05-16 13:00:00 | NVDA | Stock | 0.3173 | 0.3189 | 0.3158 | 0.3172 | 82404000.0 |
| 2002-05-16 14:00:00 | NVDA | Stock | 0.3171 | 0.3204 | 0.315 | 0.315 | 97944000.0 |
| 2002-05-16 15:00:00 | NVDA | Stock | 0.3149 | 0.3175 | 0.3149 | 0.3165 | 110196000.0 |
| 2002-05-16 16:00:00 | NVDA | Stock | 0.3165 | 0.3196 | 0.3149 | 0.3172 | 27900000.0 |
| 2002-05-16 17:00:00 | NVDA | Stock | 0.3177 | 0.3183 | 0.3164 | 0.3171 | 1044000.0 |
| 2002-05-16 18:00:00 | NVDA | Stock | 0.3171 | 0.3187 | 0.3171 | 0.3182 | 228000.0 |
| 2002-05-16 08:00:00 | AMZN | Stock | 0.9925 | 1.008 | 0.976 | 0.9925 | 156000.0 |
| 2002-05-16 09:00:00 | AMZN | Stock | 0.9875 | 0.9955 | 0.967 | 0.9725 | 32808000.0 |
| 2002-05-16 10:00:00 | AMZN | Stock | 0.97 | 0.9975 | 0.9685 | 0.9925 | 30880000.0 |
| 2002-05-16 11:00:00 | AMZN | Stock | 0.993 | 0.9975 | 0.985 | 0.9875 | 15390000.0 |
| 2002-05-16 12:00:00 | AMZN | Stock | 0.9875 | 0.9885 | 0.9805 | 0.983 | 14850000.0 |
| 2002-05-16 13:00:00 | AMZN | Stock | 0.9825 | 0.984 | 0.971 | 0.973 | 15248000.0 |
| 2002-05-16 14:00:00 | AMZN | Stock | 0.973 | 0.978 | 0.9645 | 0.9725 | 18786000.0 |
| 2002-05-16 15:00:00 | AMZN | Stock | 0.973 | 0.9815 | 0.968 | 0.9795 | 20592000.0 |
| 2002-05-16 16:00:00 | AMZN | Stock | 0.982 | 0.9895 | 0.98 | 0.986 | 1894000.0 |
| 2002-05-16 17:00:00 | AMZN | Stock | 0.9808 | 0.9935 | 0.9805 | 0.9805 | 102000.0 |
| 2002-05-16 18:00:00 | AMZN | Stock | 0.993 | 0.994 | 0.9865 | 0.9865 | 22000.0 |
| 2002-05-16 09:00:00 | CL | Stock | 27.755 | 27.755 | 27.625 | 27.65 | 1212000.0 |
| 2002-05-16 10:00:00 | CL | Stock | 27.65 | 27.915 | 27.65 | 27.875 | 276200.0 |
| 2002-05-16 11:00:00 | CL | Stock | 27.875 | 27.875 | 27.63 | 27.635 | 238600.0 |
| 2002-05-16 12:00:00 | CL | Stock | 27.63 | 27.8 | 27.6 | 27.8 | 250200.0 |
| 2002-05-16 13:00:00 | CL | Stock | 27.795 | 27.825 | 27.75 | 27.825 | 114200.0 |
| 2002-05-16 14:00:00 | CL | Stock | 27.83 | 27.91 | 27.805 | 27.88 | 210200.0 |
| 2002-05-16 15:00:00 | CL | Stock | 27.88 | 27.89 | 27.75 | 27.825 | 601000.0 |
> showing 50 of 18,899 rows — these rows as CSV