PREVIEW / stock_daily / 2007-11-08
file: by_date/stock_daily/2007/2007-11-08.parquet size: 180 KB rows: 5,589 symbols: 3,388
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-08 | AAPL | Stock | 6.6668 | 6.675 | 5.9918 | 6.2668 | 1890378000.0 |
| 2007-11-08 | MSFT | Stock | 35.6 | 35.9 | 34.4 | 34.74 | 133742400.0 |
| 2007-11-08 | NVDA | Stock | 0.8938 | 0.91 | 0.8203 | 0.846 | 996824000.0 |
| 2007-11-08 | AMZN | Stock | 4.34 | 4.348 | 4.07 | 4.179 | 236064000.0 |
| 2007-11-08 | TLT | Stock | 90.65 | 90.94 | 90.43 | 90.56 | 2180530.0 |
| 2007-11-08 | CL | Stock | 38.035 | 38.035 | 37.235 | 38.01 | 7059000.0 |
| 2007-11-08 | A | Stock | 25.2217 | 25.2217 | 24.4134 | 25.0215 | 3324304.0 |
| 2007-11-08 | AABA-DELISTED | Stock | 28.16 | 28.24 | 25.82 | 26.68 | 58166420.0 |
| 2007-11-08 | AACC-DELISTED | Stock | 10.07 | 10.37 | 9.74 | 10.14 | 472146.0 |
| 2007-11-08 | AAI-DELISTED | Stock | 9.14 | 9.27 | 8.58 | 9.04 | 2737673.0 |
| 2007-11-08 | AAIC-DELISTED | Stock | 76.0 | 76.6 | 69.4 | 76.0 | 1959656.0 |
| 2007-11-08 | AAME | Stock | 2.26 | 2.29 | 2.07 | 2.29 | 15200.0 |
| 2007-11-08 | AAON | Stock | 3.3264 | 3.4923 | 3.3264 | 3.4212 | 633825.0 |
| 2007-11-08 | AAP | Stock | 36.14 | 36.3 | 35.3 | 36.05 | 1663900.0 |
| 2007-11-08 | AATI-DELISTED | Stock | 11.51 | 11.51 | 10.26 | 11.27 | 842261.0 |
| 2007-11-08 | AAU-DELISTED | Stock | 3.21 | 3.26 | 3.04 | 3.07 | 62900.0 |
| 2007-11-08 | AAUAF-DELISTED | Stock | 3.21 | 3.26 | 3.0401 | 3.07 | 63500.0 |
| 2007-11-08 | AAV-DELISTED | Stock | 12.3 | 12.42 | 11.77 | 12.13 | 1306600.0 |
| 2007-11-08 | AAWW-DELISTED | Stock | 56.2 | 57.18 | 56.15 | 56.61 | 189068.0 |
| 2007-11-08 | AAXN-DELISTED | Stock | 15.37 | 15.37 | 13.77 | 14.84 | 3147603.0 |
| 2007-11-08 | AB | Stock | 75.47 | 77.17 | 73.94 | 76.6 | 476300.0 |
| 2007-11-08 | ABAX-DELISTED | Stock | 32.47 | 32.4799 | 31.04 | 32.31 | 482268.0 |
| 2007-11-08 | ABB-DELISTED | Stock | 31.01 | 31.13 | 30.0 | 30.78 | 5528692.0 |
| 2007-11-08 | ABBC-DELISTED | Stock | 9.0 | 9.0 | 8.71 | 8.94 | 148582.0 |
| 2007-11-08 | ABBNY-DELISTED | Stock | 31.01 | 31.13 | 30.0 | 30.78 | 5528692.0 |
| 2007-11-08 | ABC-DELISTED | Stock | 21.68 | 22.49 | 21.58 | 22.36 | 3841400.0 |
| 2007-11-08 | ABCB | Stock | 13.6267 | 14.2589 | 13.4613 | 14.2103 | 76493.0 |
| 2007-11-08 | ABCO-DELISTED | Stock | 32.27 | 32.74 | 31.1 | 32.08 | 243989.0 |
| 2007-11-08 | ABCW-DELISTED | Stock | 21.9 | 22.98 | 21.58 | 22.96 | 115010.0 |
| 2007-11-08 | ABD-DELISTED | Stock | 18.86 | 20.0 | 18.17 | 19.7 | 651970.0 |
| 2007-11-08 | ABE-DELISTED | Stock | 27.14 | 27.14 | 23.5501 | 24.55 | 101600.0 |
| 2007-11-08 | ABEO | Stock | 4625.0 | 4625.0 | 3750.0 | 3925.0 | 34.0 |
| 2007-11-08 | ABFS-DELISTED | Stock | 24.8 | 24.86 | 23.91 | 24.78 | 872351.0 |
| 2007-11-08 | ABG | Stock | 16.7 | 17.59 | 16.45 | 17.45 | 897800.0 |
| 2007-11-08 | ABK-DELISTED | Stock | 25.39 | 26.37 | 23.0 | 24.57 | 11807133.0 |
| 2007-11-08 | ABM | Stock | 22.05 | 22.28 | 21.75 | 22.15 | 419100.0 |
| 2007-11-08 | ABMD-DELISTED | Stock | 12.18 | 12.3 | 11.84 | 12.06 | 277091.0 |
| 2007-11-08 | ABP-DELISTED | Stock | 4.71 | 4.71 | 4.34 | 4.46 | 431930.0 |
| 2007-11-08 | ABR | Stock | 16.93 | 17.09 | 16.25 | 16.76 | 553800.0 |
| 2007-11-08 | ABT | Stock | 25.8132 | 25.9476 | 25.4054 | 25.8708 | 14291788.0 |
| 2007-11-08 | ABTL-DELISTED | Stock | 11.225 | 11.525 | 11.175 | 11.475 | 11089.0 |
| 2007-11-08 | ABV-DELISTED | Stock | 78.9 | 79.4 | 74.47 | 75.89 | 1521628.0 |
| 2007-11-08 | ABVA-DELISTED | Stock | 8.04 | 8.25 | 7.88 | 8.25 | 1715.0 |
| 2007-11-08 | ABX-DELISTED | Stock | 46.39 | 47.25 | 45.08 | 46.16 | 12190825.0 |
| 2007-11-08 | ACAD | Stock | 12.93 | 13.08 | 10.41 | 11.77 | 1153300.0 |
| 2007-11-08 | ACAP-DELISTED | Stock | 41.05 | 41.68 | 40.34 | 41.44 | 49679.0 |
| 2007-11-08 | ACAS-DELISTED | Stock | 39.06 | 39.21 | 36.33 | 38.0 | 4884680.0 |
| 2007-11-08 | ACAT-DELISTED | Stock | 12.99 | 13.1 | 12.49 | 12.96 | 103549.0 |
| 2007-11-08 | ACC-DELISTED | Stock | 26.8 | 27.38 | 25.82 | 26.24 | 313500.0 |
| 2007-11-08 | ACCL-DELISTED | Stock | 7.72 | 7.84 | 7.54 | 7.68 | 108941.0 |
> showing 50 of 5,589 rows — these rows as CSV