PREVIEW / stock_daily / 2005-05-17
file: by_date/stock_daily/2005/2005-05-17.parquet size: 135 KB rows: 4,070 symbols: 2,548
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-17 | AAPL | Stock | 1.255 | 1.2664 | 1.2336 | 1.2629 | 588344400.0 |
| 2005-05-17 | MSFT | Stock | 25.31 | 25.5 | 25.25 | 25.46 | 39983200.0 |
| 2005-05-17 | NVDA | Stock | 0.2106 | 0.2152 | 0.2104 | 0.2142 | 639804000.0 |
| 2005-05-17 | AMZN | Stock | 1.7225 | 1.741 | 1.7045 | 1.7365 | 66314000.0 |
| 2005-05-17 | CL | Stock | 24.465 | 24.795 | 24.465 | 24.795 | 5239600.0 |
| 2005-05-17 | A | Stock | 15.6652 | 16.166 | 15.1717 | 16.0801 | 6143371.0 |
| 2005-05-17 | AABA-DELISTED | Stock | 35.2000007629395 | 35.7999992370605 | 35.1399993896484 | 35.6800003051758 | 13178400.0 |
| 2005-05-17 | AACC-DELISTED | Stock | 23.05 | 23.49 | 22.75 | 23.39 | 160417.0 |
| 2005-05-17 | AACQ-DELISTED | Stock | 5.075 | 5.075 | 5.0 | 5.0 | 58100.0 |
| 2005-05-17 | AACQU-DELISTED | Stock | 6.04 | 6.04 | 6.04 | 6.04 | 1500.0 |
| 2005-05-17 | AAI-DELISTED | Stock | 8.2 | 8.36 | 8.15 | 8.34 | 1073200.0 |
| 2005-05-17 | AAIC-DELISTED | Stock | 250.6 | 251.2 | 244.4 | 249.0 | 1775000.0 |
| 2005-05-17 | AAME | Stock | 3.01 | 3.01 | 3.01 | 3.01 | 300.0 |
| 2005-05-17 | AAON | Stock | 2.3967 | 2.3967 | 2.3309 | 2.377 | 235406.0 |
| 2005-05-17 | AAP | Stock | 35.9867 | 36.8667 | 35.94 | 36.5333 | 1191900.0 |
| 2005-05-17 | AAV-DELISTED | Stock | 13.4 | 14.82 | 12.94 | 13.4 | 138300.0 |
| 2005-05-17 | AAXN-DELISTED | Stock | 11.5100002288818 | 11.6000003814697 | 10.210000038147 | 10.3299999237061 | 11576400.0 |
| 2005-05-17 | ABAX-DELISTED | Stock | 9.99 | 10.08 | 9.87 | 10.02 | 42990.0 |
| 2005-05-17 | ABB-DELISTED | Stock | 6.41 | 6.48 | 6.4 | 6.47 | 334000.0 |
| 2005-05-17 | ABBC-DELISTED | Stock | 11.11 | 11.11 | 11.05 | 11.1 | 4131.0 |
| 2005-05-17 | ABC-DELISTED | Stock | 16.18 | 16.48 | 16.16 | 16.46 | 3695200.0 |
| 2005-05-17 | ABCB | Stock | 17.9842 | 17.9842 | 17.6535 | 17.6632 | 9561.0 |
| 2005-05-17 | ABCO-DELISTED | Stock | 21.87 | 22.42 | 21.46 | 22.37 | 283014.0 |
| 2005-05-17 | ABCW-DELISTED | Stock | 26.9 | 27.42 | 26.9 | 27.31 | 33600.0 |
| 2005-05-17 | ABE-DELISTED | Stock | 9.52 | 9.52 | 9.41 | 9.41 | 5300.0 |
| 2005-05-17 | ABFS-DELISTED | Stock | 32.0 | 32.59 | 31.78 | 32.35 | 310378.0 |
| 2005-05-17 | ABG | Stock | 13.69 | 14.0 | 13.69 | 13.98 | 49100.0 |
| 2005-05-17 | ABK-DELISTED | Stock | 70.04 | 70.8 | 69.65 | 70.63 | 672900.0 |
| 2005-05-17 | ABM | Stock | 18.7 | 18.95 | 18.5 | 18.74 | 67300.0 |
| 2005-05-17 | ABMD-DELISTED | Stock | 9.28 | 9.5 | 9.26 | 9.47 | 104303.0 |
| 2005-05-17 | ABP-DELISTED | Stock | 2.31 | 2.31 | 2.25 | 2.27 | 52100.0 |
| 2005-05-17 | ABR | Stock | 26.15 | 26.5 | 26.15 | 26.39 | 85200.0 |
| 2005-05-17 | ABT | Stock | 23.6302 | 23.7165 | 23.4574 | 23.7069 | 6476032.0 |
| 2005-05-17 | ABTL-DELISTED | Stock | 19.65 | 19.9 | 17.85 | 18.3 | 147900.0 |
| 2005-05-17 | ABV-DELISTED | Stock | 28.86 | 28.87 | 28.45 | 28.84 | 267400.0 |
| 2005-05-17 | ABVA-DELISTED | Stock | 14.5 | 14.75 | 14.5 | 14.75 | 1100.0 |
| 2005-05-17 | ABX-DELISTED | Stock | 21.37 | 21.82 | 21.37 | 21.75 | 1929400.0 |
| 2005-05-17 | ACAD | Stock | 7.2 | 7.36 | 7.17 | 7.21 | 182200.0 |
| 2005-05-17 | ACAP-DELISTED | Stock | 33.12 | 34.37 | 33.02 | 34.14 | 45183.0 |
| 2005-05-17 | ACAS-DELISTED | Stock | 33.5 | 33.76 | 33.37 | 33.76 | 538694.0 |
| 2005-05-17 | ACAT-DELISTED | Stock | 20.56 | 21.08 | 20.45 | 21.0 | 121718.0 |
| 2005-05-17 | ACC-DELISTED | Stock | 20.35 | 20.65 | 20.25 | 20.56 | 9600.0 |
| 2005-05-17 | ACCL-DELISTED | Stock | 5.35 | 5.35 | 5.2 | 5.26 | 131912.0 |
| 2005-05-17 | ACE-DELISTED | Stock | 42.63 | 43.63 | 42.43 | 43.54 | 797800.0 |
| 2005-05-17 | ACF-DELISTED | Stock | 23.04 | 23.37 | 22.88 | 23.2 | 2075200.0 |
| 2005-05-17 | ACFC-DELISTED | Stock | 59.34 | 60.66 | 59.34 | 60.36 | 674.0 |
| 2005-05-17 | ACG-DELISTED | Stock | 8.1 | 8.11 | 8.09 | 8.09 | 372100.0 |
| 2005-05-17 | ACGL | Stock | 4.6422 | 4.7156 | 4.6411 | 4.7 | 1386900.0 |
| 2005-05-17 | ACGN-DELISTED | Stock | 680.0 | 691.3288 | 646.0 | 668.6712 | 290000.0 |
| 2005-05-17 | ACH | Stock | 20.0533 | 20.3133 | 19.82 | 20.1533 | 227100.0 |
> showing 50 of 4,070 rows — these rows as CSV