PREVIEW / stock_1hour / 2003-03-07
file: by_date/stock_1hour/2003/2003-03-07.parquet size: 399 KB rows: 19,485 symbols: 1,539
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-07 08:00:00 | AAPL | Stock | 0.2602 | 0.2602 | 0.2602 | 0.2602 | 3180800.0 |
| 2003-03-07 09:00:00 | AAPL | Stock | 0.2588 | 0.2589 | 0.2566 | 0.2584 | 21044744.0 |
| 2003-03-07 10:00:00 | AAPL | Stock | 0.258 | 0.2613 | 0.2555 | 0.258 | 37147768.0 |
| 2003-03-07 11:00:00 | AAPL | Stock | 0.258 | 0.2607 | 0.2575 | 0.2607 | 10307976.0 |
| 2003-03-07 12:00:00 | AAPL | Stock | 0.2607 | 0.2627 | 0.2588 | 0.2616 | 21024808.0 |
| 2003-03-07 13:00:00 | AAPL | Stock | 0.2614 | 0.2616 | 0.2596 | 0.2596 | 3884832.0 |
| 2003-03-07 14:00:00 | AAPL | Stock | 0.2596 | 0.2605 | 0.2566 | 0.26 | 17871448.0 |
| 2003-03-07 15:00:00 | AAPL | Stock | 0.26 | 0.2618 | 0.2589 | 0.2595 | 18004840.0 |
| 2003-03-07 16:00:00 | AAPL | Stock | 0.2595 | 0.2607 | 0.2595 | 0.2595 | 2942800.0 |
| 2003-03-07 17:00:00 | AAPL | Stock | 0.2591 | 0.2591 | 0.2591 | 0.2591 | 963200.0 |
| 2003-03-07 08:00:00 | MSFT | Stock | 23.06 | 24.47 | 22.85 | 22.9 | 233244.0 |
| 2003-03-07 09:00:00 | MSFT | Stock | 22.92 | 24.47 | 22.89 | 23.185 | 9701567.0 |
| 2003-03-07 10:00:00 | MSFT | Stock | 23.19 | 23.58 | 23.11 | 23.261 | 13567100.0 |
| 2003-03-07 11:00:00 | MSFT | Stock | 23.26 | 23.55 | 23.23 | 23.54 | 7982028.0 |
| 2003-03-07 12:00:00 | MSFT | Stock | 23.54 | 23.79 | 23.44 | 23.63 | 8138828.0 |
| 2003-03-07 13:00:00 | MSFT | Stock | 23.63 | 23.65 | 23.35 | 23.399 | 4975721.0 |
| 2003-03-07 14:00:00 | MSFT | Stock | 23.39 | 23.44 | 23.17 | 23.4 | 5329319.0 |
| 2003-03-07 15:00:00 | MSFT | Stock | 23.39 | 23.7 | 23.3 | 23.62 | 8317970.0 |
| 2003-03-07 16:00:00 | MSFT | Stock | 23.62 | 23.76 | 23.3 | 23.69 | 800807.0 |
| 2003-03-07 17:00:00 | MSFT | Stock | 23.69 | 23.7 | 23.66 | 23.7 | 20000.0 |
| 2003-03-07 18:00:00 | MSFT | Stock | 23.7 | 23.7 | 23.67 | 23.67 | 12913.0 |
| 2003-03-07 08:00:00 | NVDA | Stock | 0.1008 | 0.1024 | 0.1 | 0.101 | 1866000.0 |
| 2003-03-07 09:00:00 | NVDA | Stock | 0.1008 | 0.1025 | 0.1 | 0.1022 | 107975160.0 |
| 2003-03-07 10:00:00 | NVDA | Stock | 0.1023 | 0.1037 | 0.1017 | 0.1022 | 96715080.0 |
| 2003-03-07 11:00:00 | NVDA | Stock | 0.1022 | 0.1032 | 0.1021 | 0.1032 | 36678960.0 |
| 2003-03-07 12:00:00 | NVDA | Stock | 0.1031 | 0.1036 | 0.1025 | 0.103 | 62936040.0 |
| 2003-03-07 13:00:00 | NVDA | Stock | 0.103 | 0.1032 | 0.1023 | 0.1026 | 41268480.0 |
| 2003-03-07 14:00:00 | NVDA | Stock | 0.1026 | 0.1026 | 0.1017 | 0.1024 | 46532160.0 |
| 2003-03-07 15:00:00 | NVDA | Stock | 0.1026 | 0.1044 | 0.1022 | 0.1042 | 131803920.0 |
| 2003-03-07 16:00:00 | NVDA | Stock | 0.1042 | 0.1042 | 0.1035 | 0.1042 | 4527000.0 |
| 2003-03-07 17:00:00 | NVDA | Stock | 0.1042 | 0.1042 | 0.104 | 0.1042 | 1014000.0 |
| 2003-03-07 18:00:00 | NVDA | Stock | 0.104 | 0.104 | 0.104 | 0.104 | 120000.0 |
| 2003-03-07 08:00:00 | AMZN | Stock | 1.1256 | 1.135 | 1.1195 | 1.135 | 862000.0 |
| 2003-03-07 09:00:00 | AMZN | Stock | 1.12 | 1.133 | 1.114 | 1.123 | 11568940.0 |
| 2003-03-07 10:00:00 | AMZN | Stock | 1.123 | 1.1405 | 1.1215 | 1.139 | 14580160.0 |
| 2003-03-07 11:00:00 | AMZN | Stock | 1.139 | 1.1435 | 1.1335 | 1.1426 | 7828100.0 |
| 2003-03-07 12:00:00 | AMZN | Stock | 1.1425 | 1.15 | 1.1375 | 1.1485 | 11390960.0 |
| 2003-03-07 13:00:00 | AMZN | Stock | 1.1485 | 1.149 | 1.1435 | 1.145 | 5236820.0 |
| 2003-03-07 14:00:00 | AMZN | Stock | 1.1445 | 1.1455 | 1.1395 | 1.1425 | 7182340.0 |
| 2003-03-07 15:00:00 | AMZN | Stock | 1.1425 | 1.152 | 1.1416 | 1.149 | 19144740.0 |
| 2003-03-07 16:00:00 | AMZN | Stock | 1.15 | 1.151 | 1.1465 | 1.1485 | 8723360.0 |
| 2003-03-07 17:00:00 | AMZN | Stock | 1.1465 | 1.1466 | 1.146 | 1.146 | 30000.0 |
| 2003-03-07 18:00:00 | AMZN | Stock | 1.146 | 1.146 | 1.146 | 1.146 | 4000.0 |
| 2003-03-07 09:00:00 | CL | Stock | 24.5 | 24.55 | 24.375 | 24.545 | 488400.0 |
| 2003-03-07 10:00:00 | CL | Stock | 24.545 | 24.65 | 24.47 | 24.475 | 943000.0 |
| 2003-03-07 11:00:00 | CL | Stock | 24.475 | 24.7 | 24.44 | 24.69 | 593400.0 |
| 2003-03-07 12:00:00 | CL | Stock | 24.695 | 24.835 | 24.69 | 24.795 | 413400.0 |
| 2003-03-07 13:00:00 | CL | Stock | 24.79 | 24.85 | 24.73 | 24.735 | 211000.0 |
| 2003-03-07 14:00:00 | CL | Stock | 24.74 | 24.81 | 24.635 | 24.71 | 450200.0 |
| 2003-03-07 15:00:00 | CL | Stock | 24.71 | 24.81 | 24.7 | 24.81 | 922000.0 |
> showing 50 of 19,485 rows — these rows as CSV