PREVIEW / stock_daily / 2005-03-17
file: by_date/stock_daily/2005/2005-03-17.parquet size: 135 KB rows: 4,026 symbols: 2,529
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-03-17 | AAPL | Stock | 1.4832 | 1.5314 | 1.4757 | 1.5089 | 801920000.0 |
| 2005-03-17 | MSFT | Stock | 24.64 | 24.68 | 24.53 | 24.54 | 60573200.0 |
| 2005-03-17 | NVDA | Stock | 0.2083 | 0.2091 | 0.2051 | 0.2056 | 442584000.0 |
| 2005-03-17 | AMZN | Stock | 1.679 | 1.722 | 1.679 | 1.6985 | 97160000.0 |
| 2005-03-17 | CL | Stock | 26.15 | 26.155 | 25.82 | 25.98 | 2429600.0 |
| 2005-03-17 | A | Stock | 16.0944 | 16.2876 | 16.073 | 16.2089 | 2967674.0 |
| 2005-03-17 | AABA-DELISTED | Stock | 31.7999992370605 | 31.9799995422363 | 31.5400009155273 | 31.6100006103516 | 13760200.0 |
| 2005-03-17 | AACC-DELISTED | Stock | 19.33 | 19.88 | 19.24 | 19.78 | 31249.0 |
| 2005-03-17 | AACQ-DELISTED | Stock | 5.14 | 5.15 | 5.14 | 5.14 | 163800.0 |
| 2005-03-17 | AACQU-DELISTED | Stock | 6.48 | 6.48 | 6.4 | 6.4 | 24000.0 |
| 2005-03-17 | AACQW-DELISTED | Stock | 0.66 | 0.69 | 0.66 | 0.66 | 168250.0 |
| 2005-03-17 | AAI-DELISTED | Stock | 8.42 | 8.52 | 8.31 | 8.52 | 1009300.0 |
| 2005-03-17 | AAIC-DELISTED | Stock | 342.8 | 347.6 | 338.6 | 341.0 | 3055900.0 |
| 2005-03-17 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 1400.0 |
| 2005-03-17 | AAON | Stock | 2.0741 | 2.0767 | 2.0556 | 2.0767 | 274134.0 |
| 2005-03-17 | AAP | Stock | 33.0533 | 33.3067 | 32.7733 | 33.2 | 560400.0 |
| 2005-03-17 | AAV-DELISTED | Stock | 16.63 | 16.8 | 16.53 | 16.63 | 67000.0 |
| 2005-03-17 | AAXN-DELISTED | Stock | 13.3999996185303 | 13.5100002288818 | 12.8500003814697 | 12.9200000762939 | 4087400.0 |
| 2005-03-17 | ABAX-DELISTED | Stock | 9.49 | 9.6 | 9.25 | 9.26 | 111585.0 |
| 2005-03-17 | ABB-DELISTED | Stock | 6.21 | 6.22 | 6.15 | 6.2 | 852400.0 |
| 2005-03-17 | ABBC-DELISTED | Stock | 13.45 | 13.46 | 13.321 | 13.38 | 4763.0 |
| 2005-03-17 | ABC-DELISTED | Stock | 15.0 | 15.24 | 15.0 | 15.2 | 3205200.0 |
| 2005-03-17 | ABCB | Stock | 18.0814 | 18.3732 | 18.0036 | 18.2857 | 11721.0 |
| 2005-03-17 | ABCO-DELISTED | Stock | 20.02 | 20.9 | 19.56 | 20.84 | 706936.0 |
| 2005-03-17 | ABCW-DELISTED | Stock | 27.62 | 27.95 | 27.28 | 27.86 | 31130.0 |
| 2005-03-17 | ABE-DELISTED | Stock | 9.68 | 9.68 | 9.52 | 9.62 | 19700.0 |
| 2005-03-17 | ABFS-DELISTED | Stock | 43.2 | 43.33 | 42.36 | 42.4 | 483704.0 |
| 2005-03-17 | ABG | Stock | 15.1 | 15.3 | 15.01 | 15.07 | 38700.0 |
| 2005-03-17 | ABK-DELISTED | Stock | 77.87 | 78.13 | 77.48 | 77.62 | 213900.0 |
| 2005-03-17 | ABM | Stock | 19.65 | 20.03 | 19.51 | 19.87 | 159000.0 |
| 2005-03-17 | ABMD-DELISTED | Stock | 10.76 | 10.77 | 10.36 | 10.55 | 70969.0 |
| 2005-03-17 | ABP-DELISTED | Stock | 2.65 | 2.8 | 2.65 | 2.74 | 199800.0 |
| 2005-03-17 | ABR | Stock | 25.78 | 26.0 | 25.75 | 25.8 | 34000.0 |
| 2005-03-17 | ABT | Stock | 21.2312 | 21.5334 | 21.1496 | 21.3655 | 9139642.0 |
| 2005-03-17 | ABTL-DELISTED | Stock | 27.0 | 27.75 | 26.4 | 26.5 | 101900.0 |
| 2005-03-17 | ABV-DELISTED | Stock | 28.29 | 28.71 | 28.1 | 28.7 | 297900.0 |
| 2005-03-17 | ABVA-DELISTED | Stock | 16.4 | 16.4 | 16.26 | 16.26 | 200.0 |
| 2005-03-17 | ABX-DELISTED | Stock | 25.35 | 25.72 | 25.26 | 25.69 | 1601698.0 |
| 2005-03-17 | ACAD | Stock | 7.17 | 7.17 | 7.17 | 7.17 | 3600.0 |
| 2005-03-17 | ACAP-DELISTED | Stock | 34.5 | 35.47 | 34.5 | 34.96 | 44351.0 |
| 2005-03-17 | ACAS-DELISTED | Stock | 32.72 | 33.62 | 32.58 | 33.29 | 835965.0 |
| 2005-03-17 | ACAT-DELISTED | Stock | 28.33 | 28.72 | 28.09 | 28.6 | 93593.0 |
| 2005-03-17 | ACC-DELISTED | Stock | 22.1 | 22.26 | 22.07 | 22.24 | 11400.0 |
| 2005-03-17 | ACCL-DELISTED | Stock | 5.38 | 5.38 | 5.25 | 5.25 | 174955.0 |
| 2005-03-17 | ACE-DELISTED | Stock | 44.62 | 44.62 | 43.45 | 43.94 | 1994100.0 |
| 2005-03-17 | ACF-DELISTED | Stock | 24.31 | 24.44 | 24.09 | 24.19 | 997400.0 |
| 2005-03-17 | ACFC-DELISTED | Stock | 67.35 | 67.5 | 66.58 | 66.84 | 2777.0 |
| 2005-03-17 | ACG-DELISTED | Stock | 8.14 | 8.21 | 8.14 | 8.19 | 402400.0 |
| 2005-03-17 | ACGL | Stock | 4.5278 | 4.54 | 4.5144 | 4.5156 | 920700.0 |
| 2005-03-17 | ACGN-DELISTED | Stock | 646.0 | 668.6712 | 623.3288 | 668.6712 | 69900.0 |
> showing 50 of 4,026 rows — these rows as CSV