PREVIEW / stock_1hour / 2003-01-15
file: by_date/stock_1hour/2003/2003-01-15.parquet size: 432 KB rows: 20,092 symbols: 1,529
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-15 08:00:00 | AAPL | Stock | 0.2616 | 0.2616 | 0.2589 | 0.2613 | 67200.0 |
| 2003-01-15 09:00:00 | AAPL | Stock | 0.2598 | 0.2625 | 0.2589 | 0.2607 | 25737376.0 |
| 2003-01-15 10:00:00 | AAPL | Stock | 0.2607 | 0.2623 | 0.2573 | 0.2575 | 71624616.0 |
| 2003-01-15 11:00:00 | AAPL | Stock | 0.2575 | 0.258 | 0.2546 | 0.2575 | 71507688.0 |
| 2003-01-15 12:00:00 | AAPL | Stock | 0.2575 | 0.2591 | 0.2563 | 0.2582 | 30332176.0 |
| 2003-01-15 13:00:00 | AAPL | Stock | 0.2581 | 0.2598 | 0.2575 | 0.2591 | 29000160.0 |
| 2003-01-15 14:00:00 | AAPL | Stock | 0.2591 | 0.2598 | 0.2584 | 0.2588 | 29134840.0 |
| 2003-01-15 15:00:00 | AAPL | Stock | 0.2588 | 0.2602 | 0.257 | 0.2577 | 70271600.0 |
| 2003-01-15 16:00:00 | AAPL | Stock | 0.2579 | 0.2588 | 0.2493 | 0.2562 | 14041328.0 |
| 2003-01-15 17:00:00 | AAPL | Stock | 0.2562 | 0.2578 | 0.2548 | 0.2571 | 3313240.0 |
| 2003-01-15 18:00:00 | AAPL | Stock | 0.2564 | 0.2571 | 0.2557 | 0.2557 | 50400.0 |
| 2003-01-15 08:00:00 | MSFT | Stock | 28.4805 | 28.56 | 28.47 | 28.55 | 110030.0 |
| 2003-01-15 09:00:00 | MSFT | Stock | 28.545 | 28.66 | 28.21 | 28.25 | 11786360.0 |
| 2003-01-15 10:00:00 | MSFT | Stock | 28.25 | 28.35 | 28.145 | 28.1845 | 11355074.0 |
| 2003-01-15 11:00:00 | MSFT | Stock | 28.185 | 28.27 | 28.125 | 28.185 | 6324042.0 |
| 2003-01-15 12:00:00 | MSFT | Stock | 28.185 | 28.2149 | 28.105 | 28.175 | 5268056.0 |
| 2003-01-15 13:00:00 | MSFT | Stock | 28.15 | 28.225 | 28.13 | 28.1755 | 3801906.0 |
| 2003-01-15 14:00:00 | MSFT | Stock | 28.175 | 28.195 | 28.1 | 28.195 | 5493714.0 |
| 2003-01-15 15:00:00 | MSFT | Stock | 28.1905 | 28.33 | 28.134 | 28.14 | 9284450.0 |
| 2003-01-15 16:00:00 | MSFT | Stock | 28.135 | 28.205 | 28.05 | 28.12 | 1591422.0 |
| 2003-01-15 17:00:00 | MSFT | Stock | 28.135 | 28.15 | 28.1015 | 28.12 | 311400.0 |
| 2003-01-15 18:00:00 | MSFT | Stock | 28.1015 | 28.11 | 28.056 | 28.11 | 18398.0 |
| 2003-01-15 08:00:00 | NVDA | Stock | 0.1021 | 0.104 | 0.1021 | 0.104 | 2154000.0 |
| 2003-01-15 09:00:00 | NVDA | Stock | 0.1041 | 0.1041 | 0.1014 | 0.1017 | 155736000.0 |
| 2003-01-15 10:00:00 | NVDA | Stock | 0.1017 | 0.1028 | 0.1014 | 0.1017 | 124734000.0 |
| 2003-01-15 11:00:00 | NVDA | Stock | 0.1016 | 0.1017 | 0.1008 | 0.1014 | 95369880.0 |
| 2003-01-15 12:00:00 | NVDA | Stock | 0.1013 | 0.1013 | 0.1002 | 0.1005 | 72466080.0 |
| 2003-01-15 13:00:00 | NVDA | Stock | 0.1005 | 0.1009 | 0.1003 | 0.1007 | 34442160.0 |
| 2003-01-15 14:00:00 | NVDA | Stock | 0.1007 | 0.1008 | 0.0999 | 0.1002 | 151526400.0 |
| 2003-01-15 15:00:00 | NVDA | Stock | 0.1002 | 0.1007 | 0.0998 | 0.0999 | 196671120.0 |
| 2003-01-15 16:00:00 | NVDA | Stock | 0.0999 | 0.1017 | 0.0983 | 0.0993 | 23874720.0 |
| 2003-01-15 17:00:00 | NVDA | Stock | 0.0993 | 0.0998 | 0.0986 | 0.0987 | 3636000.0 |
| 2003-01-15 18:00:00 | NVDA | Stock | 0.0988 | 0.0988 | 0.0979 | 0.0986 | 1466280.0 |
| 2003-01-15 08:00:00 | AMZN | Stock | 1.1365 | 1.14 | 1.136 | 1.136 | 50000.0 |
| 2003-01-15 09:00:00 | AMZN | Stock | 1.136 | 1.1375 | 1.109 | 1.115 | 17959920.0 |
| 2003-01-15 10:00:00 | AMZN | Stock | 1.1125 | 1.122 | 1.1075 | 1.115 | 28302700.0 |
| 2003-01-15 11:00:00 | AMZN | Stock | 1.115 | 1.1168 | 1.113 | 1.1165 | 10634560.0 |
| 2003-01-15 12:00:00 | AMZN | Stock | 1.116 | 1.1165 | 1.097 | 1.106 | 19608360.0 |
| 2003-01-15 13:00:00 | AMZN | Stock | 1.1065 | 1.1185 | 1.105 | 1.1124 | 18516800.0 |
| 2003-01-15 14:00:00 | AMZN | Stock | 1.112 | 1.1161 | 1.107 | 1.112 | 11513880.0 |
| 2003-01-15 15:00:00 | AMZN | Stock | 1.112 | 1.1165 | 1.1075 | 1.114 | 16087620.0 |
| 2003-01-15 16:00:00 | AMZN | Stock | 1.114 | 1.123 | 1.075 | 1.08 | 6837620.0 |
| 2003-01-15 17:00:00 | AMZN | Stock | 1.0785 | 1.1139 | 1.076 | 1.08 | 1144960.0 |
| 2003-01-15 18:00:00 | AMZN | Stock | 1.0775 | 1.079 | 1.0755 | 1.079 | 210000.0 |
| 2003-01-15 09:00:00 | CL | Stock | 26.3 | 26.35 | 26.18 | 26.3 | 237200.0 |
| 2003-01-15 10:00:00 | CL | Stock | 26.3 | 26.3 | 26.02 | 26.05 | 258600.0 |
| 2003-01-15 11:00:00 | CL | Stock | 26.03 | 26.14 | 26.0 | 26.14 | 226000.0 |
| 2003-01-15 12:00:00 | CL | Stock | 26.14 | 26.2 | 26.06 | 26.11 | 123800.0 |
| 2003-01-15 13:00:00 | CL | Stock | 26.15 | 26.19 | 26.105 | 26.105 | 124200.0 |
| 2003-01-15 14:00:00 | CL | Stock | 26.1 | 26.285 | 26.06 | 26.285 | 214200.0 |
> showing 50 of 20,092 rows — these rows as CSV