PREVIEW / stock_daily / 2001-07-05
file: by_date/stock_daily/2001/2001-07-05.parquet size: 100 KB rows: 2,915 symbols: 1,803
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2001-07-05 | AAPL | Stock | 0.4214 | 0.4245 | 0.4109 | 0.4141 | 152292000.0 |
| 2001-07-05 | MSFT | Stock | 35.11 | 35.36 | 34.22 | 34.255 | 49242600.0 |
| 2001-07-05 | NVDA | Stock | 0.3696 | 0.3719 | 0.3465 | 0.3469 | 1020096000.0 |
| 2001-07-05 | AMZN | Stock | 0.714 | 0.7725 | 0.71 | 0.7635 | 241664000.0 |
| 2001-07-05 | CL | Stock | 30.05 | 30.05 | 29.525 | 29.815 | 2311200.0 |
| 2001-07-05 | A | Stock | 23.2546 | 23.5622 | 22.568 | 23.0114 | 2075191.0 |
| 2001-07-05 | AABA-DELISTED | Stock | 10.0 | 10.4350004196167 | 9.47999954223633 | 9.59500026702881 | 19023800.0 |
| 2001-07-05 | AAI-DELISTED | Stock | 9.95 | 10.06 | 9.95 | 9.97 | 219700.0 |
| 2001-07-05 | AAIC-DELISTED | Stock | 136.0 | 139.0 | 134.0 | 135.0 | 61100.0 |
| 2001-07-05 | AAME | Stock | 1.7 | 1.7 | 1.56 | 1.56 | 13200.0 |
| 2001-07-05 | AAON | Stock | 1.4925 | 1.5364 | 1.4866 | 1.5364 | 150356.0 |
| 2001-07-05 | AAXN-DELISTED | Stock | 0.529166638851166 | 0.529166638851166 | 0.529166638851166 | 0.529166638851166 | 16800.0 |
| 2001-07-05 | ABAX-DELISTED | Stock | 5.55 | 5.55 | 5.25 | 5.4 | 12000.0 |
| 2001-07-05 | ABB-DELISTED | Stock | 14.6 | 14.6 | 14.02 | 14.22 | 80900.0 |
| 2001-07-05 | ABC-DELISTED | Stock | 14.0 | 14.1099996566772 | 13.852499961853 | 13.9099998474121 | 1904400.0 |
| 2001-07-05 | ABCB | Stock | 8.997 | 9.3131 | 8.997 | 9.3131 | 1109.0 |
| 2001-07-05 | ABCW-DELISTED | Stock | 15.34 | 15.5 | 15.34 | 15.36 | 23400.0 |
| 2001-07-05 | ABE-DELISTED | Stock | 8.0 | 8.1 | 8.0 | 8.08 | 2800.0 |
| 2001-07-05 | ABFS-DELISTED | Stock | 22.9 | 23.0 | 22.18 | 23.0 | 80000.0 |
| 2001-07-05 | ABK-DELISTED | Stock | 59.7 | 60.6 | 59.7 | 60.06 | 660200.0 |
| 2001-07-05 | ABM | Stock | 18.29 | 18.86 | 18.225 | 18.545 | 118000.0 |
| 2001-07-05 | ABMD-DELISTED | Stock | 28.11 | 28.23 | 25.8 | 26.26 | 1427400.0 |
| 2001-07-05 | ABP-DELISTED | Stock | 3.15 | 3.2 | 3.0 | 3.03 | 80900.0 |
| 2001-07-05 | ABT | Stock | 22.1218 | 22.1892 | 21.5517 | 21.9692 | 5176644.0 |
| 2001-07-05 | ABTL-DELISTED | Stock | 7.55 | 7.75 | 7.25 | 7.45 | 8500.0 |
| 2001-07-05 | ABV-DELISTED | Stock | 21.9 | 21.9 | 20.8 | 21.1 | 471900.0 |
| 2001-07-05 | ABX-DELISTED | Stock | 14.84 | 14.95 | 14.72 | 14.82 | 1969500.0 |
| 2001-07-05 | ACAP-DELISTED | Stock | 20.0 | 20.25 | 19.97 | 20.0 | 82500.0 |
| 2001-07-05 | ACAS-DELISTED | Stock | 27.06 | 27.48 | 26.75 | 26.85 | 228300.0 |
| 2001-07-05 | ACAT-DELISTED | Stock | 15.01 | 15.1 | 14.96 | 15.01 | 29800.0 |
| 2001-07-05 | ACCL-DELISTED | Stock | 14.5263996124268 | 15.0397996902466 | 14.5263996124268 | 15.0397996902466 | 195400.0 |
| 2001-07-05 | ACE-DELISTED | Stock | 38.17 | 38.3 | 37.6 | 37.7 | 812900.0 |
| 2001-07-05 | ACF-DELISTED | Stock | 52.64 | 53.2 | 52.6 | 53.09 | 650500.0 |
| 2001-07-05 | ACG-DELISTED | Stock | 8.66 | 8.75 | 8.65 | 8.68 | 210800.0 |
| 2001-07-05 | ACGL | Stock | 1.8722 | 1.8722 | 1.8333 | 1.8722 | 119700.0 |
| 2001-07-05 | ACGN-DELISTED | Stock | 1303.3288 | 1473.3288 | 1280.6712 | 1303.3288 | 56300.0 |
| 2001-07-05 | ACH | Stock | 12.4333 | 12.56 | 12.4067 | 12.4933 | 81150.0 |
| 2001-07-05 | ACLS | Stock | 53.24 | 57.56 | 52.52 | 56.52 | 170900.0 |
| 2001-07-05 | ACO-DELISTED | Stock | 5.8 | 5.8 | 5.5 | 5.55 | 10400.0 |
| 2001-07-05 | ACPW-DELISTED | Stock | 80.15 | 82.85 | 79.3 | 80.25 | 57300.0 |
| 2001-07-05 | ACS-DELISTED | Stock | 35.485 | 36.06 | 35.485 | 35.82 | 295900.0 |
| 2001-07-05 | ACTA-DELISTED | Stock | 39.0 | 39.2 | 35.6 | 36.6 | 38800.0 |
| 2001-07-05 | ACTU-DELISTED | Stock | 7.63 | 8.18 | 7.55 | 7.96 | 284600.0 |
| 2001-07-05 | ACXM-DELISTED | Stock | 12.0 | 12.22 | 11.62 | 11.82 | 1088227.0 |
| 2001-07-05 | ACY-DELISTED | Stock | 5.08 | 5.08 | 5.08 | 5.08 | 100.0 |
| 2001-07-05 | AD | Stock | 38.5333 | 38.9333 | 38.2 | 38.9333 | 77850.0 |
| 2001-07-05 | ADAT-DELISTED | Stock | 84.6 | 85.68 | 83.34 | 85.68 | 829.0 |
| 2001-07-05 | ADBE | Stock | 22.395 | 23.15 | 22.3 | 22.33 | 4041000.0 |
| 2001-07-05 | ADC | Stock | 18.78 | 18.79 | 18.76 | 18.78 | 1600.0 |
| 2001-07-05 | ADEP-DELISTED | Stock | 47.5 | 48.6 | 47.25 | 47.8 | 14900.0 |
> showing 50 of 2,915 rows — these rows as CSV