PREVIEW / stock_1hour / 2002-07-22
file: by_date/stock_1hour/2002/2002-07-22.parquet size: 380 KB rows: 18,328 symbols: 1,452
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-22 09:00:00 | AAPL | Stock | 0.2634 | 0.2713 | 0.2634 | 0.2646 | 47328904.0 |
| 2002-07-22 10:00:00 | AAPL | Stock | 0.2643 | 0.2682 | 0.2616 | 0.2648 | 46682888.0 |
| 2002-07-22 11:00:00 | AAPL | Stock | 0.2655 | 0.2664 | 0.2609 | 0.2652 | 59550008.0 |
| 2002-07-22 12:00:00 | AAPL | Stock | 0.2652 | 0.2674 | 0.2629 | 0.2664 | 60803680.0 |
| 2002-07-22 13:00:00 | AAPL | Stock | 0.2663 | 0.2682 | 0.2634 | 0.2682 | 69154064.0 |
| 2002-07-22 14:00:00 | AAPL | Stock | 0.2682 | 0.2696 | 0.267 | 0.2682 | 57982232.0 |
| 2002-07-22 15:00:00 | AAPL | Stock | 0.2682 | 0.2691 | 0.2652 | 0.2666 | 71874432.0 |
| 2002-07-22 16:00:00 | AAPL | Stock | 0.2664 | 0.2669 | 0.2661 | 0.2664 | 712040.0 |
| 2002-07-22 09:00:00 | MSFT | Stock | 24.475 | 24.995 | 24.365 | 24.57 | 16392128.0 |
| 2002-07-22 10:00:00 | MSFT | Stock | 24.57 | 24.61 | 24.2 | 24.42 | 20513606.0 |
| 2002-07-22 11:00:00 | MSFT | Stock | 24.415 | 24.435 | 23.55 | 23.72 | 26018728.0 |
| 2002-07-22 12:00:00 | MSFT | Stock | 23.725 | 23.8155 | 22.95 | 23.695 | 33070706.0 |
| 2002-07-22 13:00:00 | MSFT | Stock | 23.6955 | 24.125 | 23.345 | 24.125 | 24810100.0 |
| 2002-07-22 14:00:00 | MSFT | Stock | 24.125 | 24.195 | 23.505 | 23.51 | 23767514.0 |
| 2002-07-22 15:00:00 | MSFT | Stock | 23.515 | 24.05 | 23.085 | 23.16 | 28845366.0 |
| 2002-07-22 16:00:00 | MSFT | Stock | 23.17 | 23.18 | 23.145 | 23.145 | 147000.0 |
| 2002-07-22 09:00:00 | NVDA | Stock | 0.1504 | 0.1547 | 0.1479 | 0.1483 | 143301480.0 |
| 2002-07-22 10:00:00 | NVDA | Stock | 0.149 | 0.1499 | 0.1379 | 0.1435 | 441519600.0 |
| 2002-07-22 11:00:00 | NVDA | Stock | 0.1435 | 0.1442 | 0.1412 | 0.1435 | 128870640.0 |
| 2002-07-22 12:00:00 | NVDA | Stock | 0.1433 | 0.1458 | 0.1417 | 0.145 | 133931400.0 |
| 2002-07-22 13:00:00 | NVDA | Stock | 0.1448 | 0.1486 | 0.1421 | 0.1478 | 174660360.0 |
| 2002-07-22 14:00:00 | NVDA | Stock | 0.1479 | 0.1484 | 0.1431 | 0.1431 | 117239520.0 |
| 2002-07-22 15:00:00 | NVDA | Stock | 0.1431 | 0.1472 | 0.1427 | 0.144 | 126568800.0 |
| 2002-07-22 16:00:00 | NVDA | Stock | 0.1441 | 0.1441 | 0.1441 | 0.1441 | 72000.0 |
| 2002-07-22 09:00:00 | AMZN | Stock | 0.7575 | 0.7825 | 0.7575 | 0.77 | 27059920.0 |
| 2002-07-22 10:00:00 | AMZN | Stock | 0.7695 | 0.779 | 0.766 | 0.7685 | 21842160.0 |
| 2002-07-22 11:00:00 | AMZN | Stock | 0.7685 | 0.77 | 0.75 | 0.7585 | 24960100.0 |
| 2002-07-22 12:00:00 | AMZN | Stock | 0.758 | 0.763 | 0.7505 | 0.761 | 22909600.0 |
| 2002-07-22 13:00:00 | AMZN | Stock | 0.761 | 0.7755 | 0.755 | 0.7755 | 26140920.0 |
| 2002-07-22 14:00:00 | AMZN | Stock | 0.7755 | 0.781 | 0.765 | 0.765 | 24226880.0 |
| 2002-07-22 15:00:00 | AMZN | Stock | 0.765 | 0.778 | 0.7605 | 0.771 | 32765040.0 |
| 2002-07-22 16:00:00 | AMZN | Stock | 0.775 | 0.775 | 0.768 | 0.775 | 356000.0 |
| 2002-07-22 09:00:00 | CL | Stock | 22.4 | 22.63 | 22.275 | 22.39 | 632800.0 |
| 2002-07-22 10:00:00 | CL | Stock | 22.395 | 22.93 | 22.375 | 22.83 | 819400.0 |
| 2002-07-22 11:00:00 | CL | Stock | 22.82 | 22.895 | 22.555 | 22.68 | 810200.0 |
| 2002-07-22 12:00:00 | CL | Stock | 22.675 | 22.75 | 22.285 | 22.57 | 663200.0 |
| 2002-07-22 13:00:00 | CL | Stock | 22.57 | 23.125 | 22.455 | 23.105 | 842000.0 |
| 2002-07-22 14:00:00 | CL | Stock | 23.08 | 23.28 | 22.925 | 22.94 | 748600.0 |
| 2002-07-22 15:00:00 | CL | Stock | 22.94 | 23.05 | 22.635 | 22.665 | 1143200.0 |
| 2002-07-22 16:00:00 | CL | Stock | 22.66 | 22.665 | 22.655 | 22.655 | 92200.0 |
> showing 40 of 18,328 rows — these rows as CSV