PREVIEW / stock_1hour / 2003-02-20
file: by_date/stock_1hour/2003/2003-02-20.parquet size: 396 KB rows: 19,401 symbols: 1,552
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-02-20 08:00:00 | AAPL | Stock | 0.2664 | 0.2664 | 0.2654 | 0.2654 | 1002400.0 |
| 2003-02-20 09:00:00 | AAPL | Stock | 0.2654 | 0.2671 | 0.2645 | 0.2661 | 27226920.0 |
| 2003-02-20 10:00:00 | AAPL | Stock | 0.2661 | 0.2668 | 0.263 | 0.2636 | 36190672.0 |
| 2003-02-20 11:00:00 | AAPL | Stock | 0.2636 | 0.2648 | 0.2632 | 0.2648 | 20974128.0 |
| 2003-02-20 12:00:00 | AAPL | Stock | 0.2648 | 0.2659 | 0.2634 | 0.2641 | 18985456.0 |
| 2003-02-20 13:00:00 | AAPL | Stock | 0.2641 | 0.2641 | 0.2627 | 0.2639 | 10253096.0 |
| 2003-02-20 14:00:00 | AAPL | Stock | 0.2638 | 0.2643 | 0.2636 | 0.2639 | 15754424.0 |
| 2003-02-20 15:00:00 | AAPL | Stock | 0.2639 | 0.2661 | 0.2629 | 0.2632 | 38633728.0 |
| 2003-02-20 16:00:00 | AAPL | Stock | 0.2636 | 0.2641 | 0.2629 | 0.2638 | 5706400.0 |
| 2003-02-20 08:00:00 | MSFT | Stock | 24.7 | 24.82 | 24.54 | 24.76 | 285705.0 |
| 2003-02-20 09:00:00 | MSFT | Stock | 24.64 | 24.87 | 24.52 | 24.73 | 5492031.0 |
| 2003-02-20 10:00:00 | MSFT | Stock | 24.7289 | 24.79 | 24.32 | 24.375 | 8514943.0 |
| 2003-02-20 11:00:00 | MSFT | Stock | 24.37 | 24.42 | 24.21 | 24.33 | 5340463.0 |
| 2003-02-20 12:00:00 | MSFT | Stock | 24.33 | 24.36 | 24.21 | 24.25 | 4173568.0 |
| 2003-02-20 13:00:00 | MSFT | Stock | 24.25 | 24.29 | 24.14 | 24.24 | 3499540.0 |
| 2003-02-20 14:00:00 | MSFT | Stock | 24.23 | 24.3 | 24.1 | 24.138 | 4662156.0 |
| 2003-02-20 15:00:00 | MSFT | Stock | 24.13 | 24.448 | 24.12 | 24.14 | 10022298.0 |
| 2003-02-20 16:00:00 | MSFT | Stock | 24.14 | 24.3 | 24.1 | 24.2 | 1099674.0 |
| 2003-02-20 17:00:00 | MSFT | Stock | 24.2 | 24.2 | 24.16 | 24.18 | 34150.0 |
| 2003-02-20 18:00:00 | MSFT | Stock | 24.2 | 24.211 | 24.19 | 24.2 | 3220.0 |
| 2003-02-20 08:00:00 | NVDA | Stock | 0.1079 | 0.1091 | 0.1079 | 0.1085 | 6915600.0 |
| 2003-02-20 09:00:00 | NVDA | Stock | 0.1084 | 0.1103 | 0.1071 | 0.1088 | 207375600.0 |
| 2003-02-20 10:00:00 | NVDA | Stock | 0.1087 | 0.1096 | 0.1075 | 0.108 | 164625600.0 |
| 2003-02-20 11:00:00 | NVDA | Stock | 0.108 | 0.1082 | 0.1069 | 0.1078 | 123463320.0 |
| 2003-02-20 12:00:00 | NVDA | Stock | 0.1078 | 0.108 | 0.1073 | 0.1073 | 72362280.0 |
| 2003-02-20 13:00:00 | NVDA | Stock | 0.1073 | 0.1075 | 0.1067 | 0.1074 | 67751640.0 |
| 2003-02-20 14:00:00 | NVDA | Stock | 0.1073 | 0.1078 | 0.1067 | 0.1069 | 59731440.0 |
| 2003-02-20 15:00:00 | NVDA | Stock | 0.1069 | 0.1081 | 0.1067 | 0.1071 | 162972840.0 |
| 2003-02-20 16:00:00 | NVDA | Stock | 0.1071 | 0.1074 | 0.1067 | 0.1067 | 12723480.0 |
| 2003-02-20 17:00:00 | NVDA | Stock | 0.107 | 0.1072 | 0.1068 | 0.1068 | 744000.0 |
| 2003-02-20 18:00:00 | NVDA | Stock | 0.107 | 0.107 | 0.1065 | 0.1065 | 544920.0 |
| 2003-02-20 08:00:00 | AMZN | Stock | 1.0625 | 1.0625 | 1.0595 | 1.06 | 174000.0 |
| 2003-02-20 09:00:00 | AMZN | Stock | 1.0595 | 1.0675 | 1.055 | 1.057 | 11048660.0 |
| 2003-02-20 10:00:00 | AMZN | Stock | 1.057 | 1.0625 | 1.0545 | 1.057 | 15343600.0 |
| 2003-02-20 11:00:00 | AMZN | Stock | 1.057 | 1.062 | 1.056 | 1.0615 | 6956220.0 |
| 2003-02-20 12:00:00 | AMZN | Stock | 1.062 | 1.0635 | 1.0578 | 1.062 | 4752860.0 |
| 2003-02-20 13:00:00 | AMZN | Stock | 1.062 | 1.0655 | 1.06 | 1.063 | 6647200.0 |
| 2003-02-20 14:00:00 | AMZN | Stock | 1.0635 | 1.071 | 1.0615 | 1.068 | 12592380.0 |
| 2003-02-20 15:00:00 | AMZN | Stock | 1.069 | 1.0751 | 1.061 | 1.0648 | 17704980.0 |
| 2003-02-20 16:00:00 | AMZN | Stock | 1.0675 | 1.072 | 1.063 | 1.071 | 642000.0 |
| 2003-02-20 17:00:00 | AMZN | Stock | 1.071 | 1.071 | 1.0635 | 1.0635 | 204000.0 |
| 2003-02-20 18:00:00 | AMZN | Stock | 1.0686 | 1.0686 | 1.068 | 1.0685 | 30000.0 |
| 2003-02-20 09:00:00 | CL | Stock | 25.2 | 25.325 | 25.15 | 25.25 | 250800.0 |
| 2003-02-20 10:00:00 | CL | Stock | 25.25 | 25.25 | 25.0 | 25.005 | 314800.0 |
| 2003-02-20 11:00:00 | CL | Stock | 25.005 | 25.195 | 25.0 | 25.17 | 393800.0 |
| 2003-02-20 12:00:00 | CL | Stock | 25.16 | 25.16 | 25.0 | 25.05 | 210600.0 |
| 2003-02-20 13:00:00 | CL | Stock | 25.045 | 25.08 | 24.96 | 25.03 | 278000.0 |
| 2003-02-20 14:00:00 | CL | Stock | 25.03 | 25.08 | 24.97 | 24.985 | 367800.0 |
| 2003-02-20 15:00:00 | CL | Stock | 24.985 | 25.125 | 24.98 | 25.035 | 488800.0 |
| 2003-02-20 16:00:00 | CL | Stock | 25.04 | 25.04 | 25.035 | 25.035 | 123600.0 |
> showing 50 of 19,401 rows — these rows as CSV