PREVIEW / stock_1hour / 2003-01-28
file: by_date/stock_1hour/2003/2003-01-28.parquet size: 421 KB rows: 20,001 symbols: 1,540
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-01-28 09:00:00 | AAPL | Stock | 0.2548 | 0.257 | 0.2525 | 0.2545 | 32611712.0 |
| 2003-01-28 10:00:00 | AAPL | Stock | 0.2545 | 0.2589 | 0.2545 | 0.2554 | 50606248.0 |
| 2003-01-28 11:00:00 | AAPL | Stock | 0.2555 | 0.2575 | 0.2548 | 0.2563 | 24081176.0 |
| 2003-01-28 12:00:00 | AAPL | Stock | 0.2566 | 0.2566 | 0.2529 | 0.2552 | 25352880.0 |
| 2003-01-28 13:00:00 | AAPL | Stock | 0.2552 | 0.2568 | 0.2548 | 0.2568 | 17567368.0 |
| 2003-01-28 14:00:00 | AAPL | Stock | 0.2568 | 0.2596 | 0.2568 | 0.2586 | 27572664.0 |
| 2003-01-28 15:00:00 | AAPL | Stock | 0.2586 | 0.2623 | 0.2583 | 0.2607 | 72646112.0 |
| 2003-01-28 16:00:00 | AAPL | Stock | 0.2604 | 0.2613 | 0.2586 | 0.2604 | 8257480.0 |
| 2003-01-28 17:00:00 | AAPL | Stock | 0.2604 | 0.2607 | 0.2593 | 0.2604 | 156800.0 |
| 2003-01-28 18:00:00 | AAPL | Stock | 0.2616 | 0.2616 | 0.2616 | 0.2616 | 5600.0 |
| 2003-01-28 08:00:00 | MSFT | Stock | 24.625 | 24.755 | 24.6 | 24.725 | 228006.0 |
| 2003-01-28 09:00:00 | MSFT | Stock | 24.715 | 24.875 | 24.505 | 24.58 | 10969098.0 |
| 2003-01-28 10:00:00 | MSFT | Stock | 24.585 | 24.765 | 24.355 | 24.3925 | 17161724.0 |
| 2003-01-28 11:00:00 | MSFT | Stock | 24.39 | 24.55 | 24.385 | 24.4305 | 9668680.0 |
| 2003-01-28 12:00:00 | MSFT | Stock | 24.435 | 24.475 | 24.2805 | 24.385 | 5841792.0 |
| 2003-01-28 13:00:00 | MSFT | Stock | 24.385 | 24.515 | 24.36 | 24.505 | 5762094.0 |
| 2003-01-28 14:00:00 | MSFT | Stock | 24.51 | 24.635 | 24.42 | 24.42 | 13289742.0 |
| 2003-01-28 15:00:00 | MSFT | Stock | 24.425 | 24.595 | 24.33 | 24.4305 | 13851280.0 |
| 2003-01-28 16:00:00 | MSFT | Stock | 24.405 | 24.835 | 24.375 | 24.425 | 3040674.0 |
| 2003-01-28 17:00:00 | MSFT | Stock | 24.4 | 24.45 | 24.4 | 24.42 | 285000.0 |
| 2003-01-28 18:00:00 | MSFT | Stock | 24.425 | 24.48 | 24.425 | 24.445 | 16278.0 |
| 2003-01-28 08:00:00 | NVDA | Stock | 0.0833 | 0.0838 | 0.083 | 0.0831 | 11184000.0 |
| 2003-01-28 09:00:00 | NVDA | Stock | 0.0831 | 0.0835 | 0.0812 | 0.0819 | 234804720.0 |
| 2003-01-28 10:00:00 | NVDA | Stock | 0.0819 | 0.0826 | 0.0797 | 0.0802 | 331988520.0 |
| 2003-01-28 11:00:00 | NVDA | Stock | 0.0802 | 0.0819 | 0.0799 | 0.0813 | 191885040.0 |
| 2003-01-28 12:00:00 | NVDA | Stock | 0.0812 | 0.0815 | 0.0809 | 0.0812 | 55584000.0 |
| 2003-01-28 13:00:00 | NVDA | Stock | 0.0812 | 0.0828 | 0.0811 | 0.0821 | 184700520.0 |
| 2003-01-28 14:00:00 | NVDA | Stock | 0.0821 | 0.0872 | 0.0818 | 0.0869 | 331519560.0 |
| 2003-01-28 15:00:00 | NVDA | Stock | 0.0869 | 0.0881 | 0.0854 | 0.0865 | 281417520.0 |
| 2003-01-28 16:00:00 | NVDA | Stock | 0.0866 | 0.0878 | 0.0862 | 0.0877 | 26938320.0 |
| 2003-01-28 17:00:00 | NVDA | Stock | 0.0875 | 0.0896 | 0.0865 | 0.0865 | 2235600.0 |
| 2003-01-28 18:00:00 | NVDA | Stock | 0.0875 | 0.0883 | 0.0875 | 0.0879 | 642840.0 |
| 2003-01-28 08:00:00 | AMZN | Stock | 1.087 | 1.0926 | 1.087 | 1.0925 | 88800.0 |
| 2003-01-28 09:00:00 | AMZN | Stock | 1.0985 | 1.105 | 1.09 | 1.093 | 15090740.0 |
| 2003-01-28 10:00:00 | AMZN | Stock | 1.0925 | 1.098 | 1.085 | 1.087 | 31071360.0 |
| 2003-01-28 11:00:00 | AMZN | Stock | 1.0865 | 1.09 | 1.082 | 1.0855 | 18438740.0 |
| 2003-01-28 12:00:00 | AMZN | Stock | 1.0855 | 1.086 | 1.0615 | 1.067 | 23403200.0 |
| 2003-01-28 13:00:00 | AMZN | Stock | 1.067 | 1.075 | 1.067 | 1.0741 | 17536420.0 |
| 2003-01-28 14:00:00 | AMZN | Stock | 1.075 | 1.086 | 1.071 | 1.0775 | 24279180.0 |
| 2003-01-28 15:00:00 | AMZN | Stock | 1.077 | 1.09 | 1.0725 | 1.081 | 15776020.0 |
| 2003-01-28 16:00:00 | AMZN | Stock | 1.081 | 1.087 | 1.08 | 1.0825 | 2264000.0 |
| 2003-01-28 17:00:00 | AMZN | Stock | 1.0855 | 1.0855 | 1.081 | 1.081 | 130000.0 |
| 2003-01-28 18:00:00 | AMZN | Stock | 1.085 | 1.085 | 1.085 | 1.085 | 14000.0 |
| 2003-01-28 09:00:00 | CL | Stock | 25.425 | 25.7 | 25.28 | 25.67 | 412400.0 |
| 2003-01-28 10:00:00 | CL | Stock | 25.675 | 25.955 | 25.67 | 25.735 | 502400.0 |
| 2003-01-28 11:00:00 | CL | Stock | 25.73 | 25.855 | 25.725 | 25.845 | 429600.0 |
| 2003-01-28 12:00:00 | CL | Stock | 25.845 | 25.905 | 25.65 | 25.72 | 416600.0 |
| 2003-01-28 13:00:00 | CL | Stock | 25.715 | 25.81 | 25.71 | 25.805 | 253600.0 |
| 2003-01-28 14:00:00 | CL | Stock | 25.805 | 25.85 | 25.735 | 25.75 | 350800.0 |
| 2003-01-28 15:00:00 | CL | Stock | 25.75 | 25.845 | 25.7 | 25.805 | 453400.0 |
> showing 50 of 20,001 rows — these rows as CSV