PREVIEW / stock_1hour / 2003-03-06
file: by_date/stock_1hour/2003/2003-03-06.parquet size: 399 KB rows: 19,753 symbols: 1,544
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-03-06 09:00:00 | AAPL | Stock | 0.2586 | 0.2611 | 0.2575 | 0.2588 | 20011432.0 |
| 2003-03-06 10:00:00 | AAPL | Stock | 0.2588 | 0.2607 | 0.2579 | 0.2591 | 18058824.0 |
| 2003-03-06 11:00:00 | AAPL | Stock | 0.2591 | 0.26 | 0.2577 | 0.2586 | 9358832.0 |
| 2003-03-06 12:00:00 | AAPL | Stock | 0.2586 | 0.2588 | 0.2571 | 0.2584 | 4578112.0 |
| 2003-03-06 13:00:00 | AAPL | Stock | 0.2584 | 0.2596 | 0.258 | 0.2589 | 4144224.0 |
| 2003-03-06 14:00:00 | AAPL | Stock | 0.2589 | 0.2604 | 0.2572 | 0.2594 | 9149616.0 |
| 2003-03-06 15:00:00 | AAPL | Stock | 0.2596 | 0.2607 | 0.2584 | 0.2598 | 18465440.0 |
| 2003-03-06 16:00:00 | AAPL | Stock | 0.2598 | 0.26 | 0.2591 | 0.26 | 3136000.0 |
| 2003-03-06 17:00:00 | AAPL | Stock | 0.2584 | 0.2584 | 0.2577 | 0.2577 | 67200.0 |
| 2003-03-06 08:00:00 | MSFT | Stock | 23.43 | 23.451 | 23.25 | 23.31 | 286200.0 |
| 2003-03-06 09:00:00 | MSFT | Stock | 23.28 | 23.44 | 23.13 | 23.19 | 8355954.0 |
| 2003-03-06 10:00:00 | MSFT | Stock | 23.17 | 23.5 | 23.15 | 23.32 | 10222762.0 |
| 2003-03-06 11:00:00 | MSFT | Stock | 23.32 | 23.42 | 23.22 | 23.32 | 5305575.0 |
| 2003-03-06 12:00:00 | MSFT | Stock | 23.32 | 23.365 | 23.18 | 23.32 | 3805770.0 |
| 2003-03-06 13:00:00 | MSFT | Stock | 23.32 | 23.4 | 23.31 | 23.35 | 3853395.0 |
| 2003-03-06 14:00:00 | MSFT | Stock | 23.34 | 23.42 | 23.24 | 23.355 | 5323451.0 |
| 2003-03-06 15:00:00 | MSFT | Stock | 23.36 | 23.5 | 23.24 | 23.27 | 7932763.0 |
| 2003-03-06 16:00:00 | MSFT | Stock | 23.27 | 23.27 | 23.0 | 23.11 | 1048279.0 |
| 2003-03-06 17:00:00 | MSFT | Stock | 23.11 | 23.12 | 23.01 | 23.05 | 86067.0 |
| 2003-03-06 18:00:00 | MSFT | Stock | 23.08 | 23.11 | 23.0 | 23.1 | 63005.0 |
| 2003-03-06 08:00:00 | NVDA | Stock | 0.1042 | 0.1042 | 0.1042 | 0.1042 | 48000.0 |
| 2003-03-06 09:00:00 | NVDA | Stock | 0.1042 | 0.1043 | 0.1022 | 0.1029 | 135610080.0 |
| 2003-03-06 10:00:00 | NVDA | Stock | 0.1027 | 0.1037 | 0.1026 | 0.1029 | 86163840.0 |
| 2003-03-06 11:00:00 | NVDA | Stock | 0.1031 | 0.1034 | 0.1026 | 0.1029 | 40176600.0 |
| 2003-03-06 12:00:00 | NVDA | Stock | 0.1029 | 0.1031 | 0.1021 | 0.1024 | 41137440.0 |
| 2003-03-06 13:00:00 | NVDA | Stock | 0.1023 | 0.1032 | 0.1023 | 0.1026 | 27786480.0 |
| 2003-03-06 14:00:00 | NVDA | Stock | 0.1026 | 0.1028 | 0.1022 | 0.1025 | 42018720.0 |
| 2003-03-06 15:00:00 | NVDA | Stock | 0.1026 | 0.1029 | 0.1021 | 0.1025 | 81412080.0 |
| 2003-03-06 16:00:00 | NVDA | Stock | 0.1025 | 0.1025 | 0.1011 | 0.1011 | 4742160.0 |
| 2003-03-06 17:00:00 | NVDA | Stock | 0.101 | 0.1017 | 0.101 | 0.1017 | 480000.0 |
| 2003-03-06 18:00:00 | NVDA | Stock | 0.102 | 0.102 | 0.1015 | 0.1017 | 324000.0 |
| 2003-03-06 08:00:00 | AMZN | Stock | 1.121 | 1.121 | 1.11 | 1.11 | 103000.0 |
| 2003-03-06 09:00:00 | AMZN | Stock | 1.1205 | 1.121 | 1.106 | 1.1135 | 9597040.0 |
| 2003-03-06 10:00:00 | AMZN | Stock | 1.113 | 1.1425 | 1.112 | 1.1365 | 36974700.0 |
| 2003-03-06 11:00:00 | AMZN | Stock | 1.1375 | 1.141 | 1.124 | 1.126 | 15202700.0 |
| 2003-03-06 12:00:00 | AMZN | Stock | 1.127 | 1.1285 | 1.122 | 1.1245 | 7295040.0 |
| 2003-03-06 13:00:00 | AMZN | Stock | 1.1245 | 1.1325 | 1.1245 | 1.13 | 5584860.0 |
| 2003-03-06 14:00:00 | AMZN | Stock | 1.1315 | 1.136 | 1.1275 | 1.1345 | 7882420.0 |
| 2003-03-06 15:00:00 | AMZN | Stock | 1.134 | 1.141 | 1.1315 | 1.134 | 14063420.0 |
| 2003-03-06 16:00:00 | AMZN | Stock | 1.1344 | 1.136 | 1.127 | 1.128 | 694000.0 |
| 2003-03-06 17:00:00 | AMZN | Stock | 1.131 | 1.1345 | 1.1295 | 1.1295 | 122000.0 |
| 2003-03-06 09:00:00 | CL | Stock | 25.075 | 25.075 | 24.725 | 24.76 | 226200.0 |
| 2003-03-06 10:00:00 | CL | Stock | 24.75 | 24.94 | 24.74 | 24.835 | 457200.0 |
| 2003-03-06 11:00:00 | CL | Stock | 24.825 | 24.885 | 24.665 | 24.765 | 225200.0 |
| 2003-03-06 12:00:00 | CL | Stock | 24.77 | 24.805 | 24.69 | 24.77 | 179400.0 |
| 2003-03-06 13:00:00 | CL | Stock | 24.77 | 24.85 | 24.725 | 24.805 | 265000.0 |
| 2003-03-06 14:00:00 | CL | Stock | 24.805 | 24.915 | 24.725 | 24.805 | 239000.0 |
| 2003-03-06 15:00:00 | CL | Stock | 24.815 | 24.89 | 24.765 | 24.82 | 356000.0 |
| 2003-03-06 16:00:00 | CL | Stock | 24.82 | 24.825 | 24.82 | 24.825 | 79800.0 |
> showing 49 of 19,753 rows — these rows as CSV