PREVIEW / stock_daily / 2005-06-14
file: by_date/stock_daily/2005/2005-06-14.parquet size: 135 KB rows: 4,077 symbols: 2,552
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-06-14 | AAPL | Stock | 1.2829 | 1.2911 | 1.2768 | 1.2857 | 347846800.0 |
| 2005-06-14 | MSFT | Stock | 25.31 | 25.44 | 25.24 | 25.36 | 44243300.0 |
| 2005-06-14 | NVDA | Stock | 0.2384 | 0.2423 | 0.2167 | 0.2242 | 2408412000.0 |
| 2005-06-14 | AMZN | Stock | 1.741 | 1.7585 | 1.7395 | 1.752 | 72688000.0 |
| 2005-06-14 | CL | Stock | 24.775 | 24.9 | 24.735 | 24.825 | 2546800.0 |
| 2005-06-14 | A | Stock | 17.6395 | 17.7396 | 17.5751 | 17.6681 | 1577224.0 |
| 2005-06-14 | AABA-DELISTED | Stock | 36.560001373291 | 37.0499992370605 | 36.4300003051758 | 36.7999992370605 | 12781200.0 |
| 2005-06-14 | AACC-DELISTED | Stock | 25.6 | 25.6 | 25.2 | 25.3 | 68030.0 |
| 2005-06-14 | AACQ-DELISTED | Stock | 4.99 | 5.0 | 4.98 | 4.98 | 21000.0 |
| 2005-06-14 | AACQU-DELISTED | Stock | 6.1 | 6.1 | 6.1 | 6.1 | 990.0 |
| 2005-06-14 | AAI-DELISTED | Stock | 9.92 | 10.06 | 9.87 | 9.93 | 502000.0 |
| 2005-06-14 | AAIC-DELISTED | Stock | 276.6 | 279.4 | 276.6 | 277.4 | 892400.0 |
| 2005-06-14 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 500.0 |
| 2005-06-14 | AAON | Stock | 2.3704 | 2.4033 | 2.3704 | 2.4033 | 80494.0 |
| 2005-06-14 | AAP | Stock | 41.92 | 42.1133 | 41.7467 | 41.92 | 1230150.0 |
| 2005-06-14 | AAV-DELISTED | Stock | 14.24 | 14.26 | 13.9 | 14.24 | 44000.0 |
| 2005-06-14 | AAXN-DELISTED | Stock | 11.1499996185303 | 11.3500003814697 | 11.039999961853 | 11.1099996566772 | 2546700.0 |
| 2005-06-14 | ABAX-DELISTED | Stock | 11.68 | 11.68 | 11.22 | 11.45 | 77776.0 |
| 2005-06-14 | ABB-DELISTED | Stock | 6.82 | 6.86 | 6.82 | 6.85 | 1531500.0 |
| 2005-06-14 | ABBC-DELISTED | Stock | 11.2 | 11.39 | 11.19 | 11.24 | 11526.0 |
| 2005-06-14 | ABC-DELISTED | Stock | 16.4 | 16.84 | 16.4 | 16.81 | 4846000.0 |
| 2005-06-14 | ABCB | Stock | 16.8267 | 17.099 | 16.8072 | 17.0893 | 11823.0 |
| 2005-06-14 | ABCO-DELISTED | Stock | 23.68 | 23.72 | 23.5 | 23.68 | 135761.0 |
| 2005-06-14 | ABCW-DELISTED | Stock | 29.0 | 29.22 | 28.87 | 29.06 | 46460.0 |
| 2005-06-14 | ABE-DELISTED | Stock | 9.68 | 10.05 | 9.68 | 9.96 | 59600.0 |
| 2005-06-14 | ABFS-DELISTED | Stock | 30.91 | 30.97 | 30.61 | 30.75 | 369570.0 |
| 2005-06-14 | ABG | Stock | 14.94 | 15.15 | 14.92 | 14.98 | 30300.0 |
| 2005-06-14 | ABK-DELISTED | Stock | 70.5 | 71.32 | 70.46 | 71.08 | 517300.0 |
| 2005-06-14 | ABM | Stock | 18.21 | 18.65 | 18.21 | 18.49 | 191800.0 |
| 2005-06-14 | ABMD-DELISTED | Stock | 9.08 | 9.25 | 9.07 | 9.25 | 65679.0 |
| 2005-06-14 | ABP-DELISTED | Stock | 2.61 | 2.7 | 2.61 | 2.64 | 52800.0 |
| 2005-06-14 | ABR | Stock | 27.95 | 28.11 | 27.93 | 28.0 | 97100.0 |
| 2005-06-14 | ABT | Stock | 23.3903 | 23.6158 | 23.3903 | 23.5198 | 4279283.0 |
| 2005-06-14 | ABTL-DELISTED | Stock | 25.1 | 25.65 | 25.1 | 25.45 | 20973.0 |
| 2005-06-14 | ABV-DELISTED | Stock | 28.8 | 29.2 | 28.15 | 29.0 | 1162800.0 |
| 2005-06-14 | ABVA-DELISTED | Stock | 14.41 | 14.48 | 14.41 | 14.48 | 950.0 |
| 2005-06-14 | ABVT-DELISTED | Stock | 28.0 | 29.5 | 24.5 | 29.5 | 35100.0 |
| 2005-06-14 | ABX-DELISTED | Stock | 23.25 | 23.42 | 23.05 | 23.18 | 1670531.0 |
| 2005-06-14 | ACAD | Stock | 8.88 | 9.0 | 8.79 | 9.0 | 27100.0 |
| 2005-06-14 | ACAP-DELISTED | Stock | 35.97 | 36.11 | 35.74 | 36.09 | 40189.0 |
| 2005-06-14 | ACAS-DELISTED | Stock | 34.89 | 35.04 | 34.61 | 34.61 | 456795.0 |
| 2005-06-14 | ACAT-DELISTED | Stock | 23.29 | 24.08 | 23.2 | 23.77 | 83620.0 |
| 2005-06-14 | ACC-DELISTED | Stock | 20.65 | 20.95 | 20.63 | 20.95 | 130600.0 |
| 2005-06-14 | ACCL-DELISTED | Stock | 5.11 | 5.2 | 5.03 | 5.2 | 126408.0 |
| 2005-06-14 | ACE-DELISTED | Stock | 45.14 | 45.77 | 44.83 | 45.77 | 1092973.0 |
| 2005-06-14 | ACF-DELISTED | Stock | 25.3 | 25.4 | 24.89 | 24.96 | 949200.0 |
| 2005-06-14 | ACFC-DELISTED | Stock | 59.26 | 60.79 | 59.26 | 60.79 | 1051.0 |
| 2005-06-14 | ACG-DELISTED | Stock | 8.25 | 8.26 | 8.22 | 8.23 | 349600.0 |
| 2005-06-14 | ACGL | Stock | 4.7889 | 4.8744 | 4.7722 | 4.8744 | 378000.0 |
| 2005-06-14 | ACGN-DELISTED | Stock | 725.3288 | 725.3288 | 680.0 | 714.0 | 27300.0 |
> showing 50 of 4,077 rows — these rows as CSV