PREVIEW / stock_1hour / 2003-05-05
file: by_date/stock_1hour/2003/2003-05-05.parquet size: 440 KB rows: 21,375 symbols: 1,580
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-05-05 08:00:00 | AAPL | Stock | 0.2604 | 0.2637 | 0.2598 | 0.2632 | 252952.0 |
| 2003-05-05 09:00:00 | AAPL | Stock | 0.2636 | 0.2679 | 0.2616 | 0.2652 | 117869920.0 |
| 2003-05-05 10:00:00 | AAPL | Stock | 0.2652 | 0.2688 | 0.2652 | 0.2682 | 147353248.0 |
| 2003-05-05 11:00:00 | AAPL | Stock | 0.2684 | 0.2686 | 0.2657 | 0.2679 | 111570704.0 |
| 2003-05-05 12:00:00 | AAPL | Stock | 0.2679 | 0.2705 | 0.2673 | 0.2695 | 108433864.0 |
| 2003-05-05 13:00:00 | AAPL | Stock | 0.2695 | 0.2714 | 0.2684 | 0.2705 | 68474952.0 |
| 2003-05-05 14:00:00 | AAPL | Stock | 0.2705 | 0.2739 | 0.2702 | 0.273 | 142556848.0 |
| 2003-05-05 15:00:00 | AAPL | Stock | 0.2732 | 0.3014 | 0.2729 | 0.2871 | 525121016.0 |
| 2003-05-05 16:00:00 | AAPL | Stock | 0.2877 | 0.2895 | 0.2864 | 0.2893 | 15257480.0 |
| 2003-05-05 17:00:00 | AAPL | Stock | 0.2893 | 0.2895 | 0.2873 | 0.2895 | 784000.0 |
| 2003-05-05 18:00:00 | AAPL | Stock | 0.2895 | 0.2905 | 0.2888 | 0.2902 | 257600.0 |
| 2003-05-05 08:00:00 | MSFT | Stock | 26.145 | 26.369 | 26.145 | 26.301 | 43218.0 |
| 2003-05-05 09:00:00 | MSFT | Stock | 26.35 | 26.36 | 26.098 | 26.19 | 6458341.0 |
| 2003-05-05 10:00:00 | MSFT | Stock | 26.2 | 26.38 | 26.11 | 26.15 | 9440740.0 |
| 2003-05-05 11:00:00 | MSFT | Stock | 26.15 | 26.202 | 26.07 | 26.14 | 5925864.0 |
| 2003-05-05 12:00:00 | MSFT | Stock | 26.137 | 26.24 | 26.12 | 26.2 | 2434768.0 |
| 2003-05-05 13:00:00 | MSFT | Stock | 26.19 | 26.303 | 26.1399 | 26.14 | 3095099.0 |
| 2003-05-05 14:00:00 | MSFT | Stock | 26.14 | 26.17 | 25.89 | 25.8949 | 6943794.0 |
| 2003-05-05 15:00:00 | MSFT | Stock | 25.89 | 26.01 | 25.84 | 25.86 | 7423240.0 |
| 2003-05-05 16:00:00 | MSFT | Stock | 25.86 | 26.28 | 25.83 | 25.86 | 658157.0 |
| 2003-05-05 17:00:00 | MSFT | Stock | 25.86 | 25.899 | 25.86 | 25.87 | 44099.0 |
| 2003-05-05 18:00:00 | MSFT | Stock | 25.87 | 25.87 | 25.86 | 25.86 | 1186.0 |
| 2003-05-05 08:00:00 | NVDA | Stock | 0.1337 | 0.1354 | 0.1332 | 0.1351 | 4726080.0 |
| 2003-05-05 09:00:00 | NVDA | Stock | 0.1352 | 0.1354 | 0.1314 | 0.1345 | 260609160.0 |
| 2003-05-05 10:00:00 | NVDA | Stock | 0.1345 | 0.142 | 0.1345 | 0.1384 | 442035480.0 |
| 2003-05-05 11:00:00 | NVDA | Stock | 0.1384 | 0.1396 | 0.1369 | 0.1396 | 179796000.0 |
| 2003-05-05 12:00:00 | NVDA | Stock | 0.1396 | 0.1397 | 0.1376 | 0.138 | 142059960.0 |
| 2003-05-05 13:00:00 | NVDA | Stock | 0.1379 | 0.1388 | 0.1375 | 0.1375 | 87563520.0 |
| 2003-05-05 14:00:00 | NVDA | Stock | 0.1375 | 0.1376 | 0.1358 | 0.1358 | 113659440.0 |
| 2003-05-05 15:00:00 | NVDA | Stock | 0.1358 | 0.1372 | 0.1351 | 0.1357 | 133473360.0 |
| 2003-05-05 16:00:00 | NVDA | Stock | 0.1357 | 0.1358 | 0.1341 | 0.1343 | 16263720.0 |
| 2003-05-05 17:00:00 | NVDA | Stock | 0.1343 | 0.1368 | 0.1343 | 0.1349 | 4278000.0 |
| 2003-05-05 18:00:00 | NVDA | Stock | 0.1349 | 0.1349 | 0.1344 | 0.1344 | 192000.0 |
| 2003-05-05 08:00:00 | AMZN | Stock | 1.473 | 1.4756 | 1.473 | 1.473 | 102000.0 |
| 2003-05-05 09:00:00 | AMZN | Stock | 1.473 | 1.475 | 1.4505 | 1.4645 | 27374860.0 |
| 2003-05-05 10:00:00 | AMZN | Stock | 1.4645 | 1.489 | 1.4565 | 1.475 | 42638340.0 |
| 2003-05-05 11:00:00 | AMZN | Stock | 1.476 | 1.487 | 1.4735 | 1.486 | 18229380.0 |
| 2003-05-05 12:00:00 | AMZN | Stock | 1.4865 | 1.4965 | 1.483 | 1.496 | 17183540.0 |
| 2003-05-05 13:00:00 | AMZN | Stock | 1.4965 | 1.498 | 1.4912 | 1.4945 | 13006960.0 |
| 2003-05-05 14:00:00 | AMZN | Stock | 1.4945 | 1.4985 | 1.492 | 1.4925 | 26510640.0 |
| 2003-05-05 15:00:00 | AMZN | Stock | 1.4925 | 1.5025 | 1.49 | 1.496 | 41298820.0 |
| 2003-05-05 16:00:00 | AMZN | Stock | 1.4955 | 1.4985 | 1.493 | 1.497 | 4171400.0 |
| 2003-05-05 17:00:00 | AMZN | Stock | 1.499 | 1.5024 | 1.4955 | 1.497 | 262000.0 |
| 2003-05-05 18:00:00 | AMZN | Stock | 1.4975 | 1.5035 | 1.4965 | 1.5035 | 187880.0 |
| 2003-05-05 09:00:00 | CL | Stock | 28.54 | 28.74 | 28.515 | 28.66 | 295200.0 |
| 2003-05-05 10:00:00 | CL | Stock | 28.65 | 28.71 | 28.465 | 28.49 | 399600.0 |
| 2003-05-05 11:00:00 | CL | Stock | 28.5 | 28.55 | 28.38 | 28.5 | 213600.0 |
| 2003-05-05 12:00:00 | CL | Stock | 28.505 | 28.63 | 28.475 | 28.625 | 148800.0 |
| 2003-05-05 13:00:00 | CL | Stock | 28.63 | 28.76 | 28.625 | 28.735 | 334200.0 |
| 2003-05-05 14:00:00 | CL | Stock | 28.73 | 28.755 | 28.655 | 28.67 | 489200.0 |
> showing 50 of 21,375 rows — these rows as CSV