PREVIEW / stock_daily / 2009-11-18
file: by_date/stock_daily/2009/2009-11-18.parquet size: 187 KB rows: 5,888 symbols: 3,504
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-18 | AAPL | Stock | 7.3764 | 7.3929 | 7.2857 | 7.3557 | 374320800.0 |
| 2009-11-18 | MSFT | Stock | 30.0 | 30.14 | 29.81 | 30.11 | 59431200.0 |
| 2009-11-18 | NVDA | Stock | 0.34 | 0.3413 | 0.3322 | 0.338 | 455516000.0 |
| 2009-11-18 | AMZN | Stock | 6.545 | 6.5705 | 6.4765 | 6.5645 | 104270000.0 |
| 2009-11-18 | TLT | Stock | 95.44 | 95.53 | 94.74 | 94.97 | 2413548.0 |
| 2009-11-18 | ES | Stock | 23.97 | 24.05 | 23.82 | 23.97 | 902300.0 |
| 2009-11-18 | CL | Stock | 41.31 | 43.695 | 41.06 | 42.935 | 27909800.0 |
| 2009-11-18 | A | Stock | 21.0944 | 21.1016 | 20.8441 | 21.073 | 3923906.0 |
| 2009-11-18 | AABA-DELISTED | Stock | 16.02 | 16.13 | 15.84 | 15.98 | 12558559.0 |
| 2009-11-18 | AACC-DELISTED | Stock | 5.32 | 5.469 | 5.26 | 5.43 | 122011.0 |
| 2009-11-18 | AACG | Stock | 4.9 | 5.0 | 4.8 | 5.0 | 15800.0 |
| 2009-11-18 | AAI-DELISTED | Stock | 4.5 | 4.5 | 4.34 | 4.36 | 2419905.0 |
| 2009-11-18 | AAIC-DELISTED | Stock | 12.8 | 13.34 | 12.699 | 13.33 | 44642.0 |
| 2009-11-18 | AAME | Stock | 1.26 | 1.26 | 1.26 | 1.26 | 200.0 |
| 2009-11-18 | AAON | Stock | 4.0079 | 4.0158 | 3.9111 | 3.9763 | 294131.0 |
| 2009-11-18 | AAP | Stock | 39.85 | 41.05 | 39.85 | 40.96 | 3238300.0 |
| 2009-11-18 | AATI-DELISTED | Stock | 3.03 | 3.32 | 3.03 | 3.29 | 561214.0 |
| 2009-11-18 | AAU-DELISTED | Stock | 0.77 | 0.7914 | 0.76 | 0.768 | 182794.0 |
| 2009-11-18 | AAUAF-DELISTED | Stock | 0.77 | 0.79 | 0.76 | 0.767 | 185400.0 |
| 2009-11-18 | AAV-DELISTED | Stock | 6.14 | 6.18 | 5.91 | 5.93 | 687364.0 |
| 2009-11-18 | AAWW-DELISTED | Stock | 29.82 | 30.54 | 29.47 | 29.92 | 404954.0 |
| 2009-11-18 | AAXJ | Stock | 56.38 | 56.39 | 55.668 | 55.89 | 142061.0 |
| 2009-11-18 | AAXN-DELISTED | Stock | 4.23 | 4.25 | 4.15 | 4.18 | 326372.0 |
| 2009-11-18 | AB | Stock | 27.04 | 27.25 | 26.37 | 27.21 | 761600.0 |
| 2009-11-18 | ABAX-DELISTED | Stock | 23.61 | 23.87 | 23.06 | 23.52 | 60609.0 |
| 2009-11-18 | ABB-DELISTED | Stock | 19.24 | 19.31 | 19.04 | 19.18 | 3676329.0 |
| 2009-11-18 | ABBC-DELISTED | Stock | 7.13 | 7.16 | 6.92 | 7.01 | 28345.0 |
| 2009-11-18 | ABBNY-DELISTED | Stock | 19.24 | 19.31 | 19.04 | 19.17 | 3688692.0 |
| 2009-11-18 | ABC-DELISTED | Stock | 24.16 | 24.52 | 24.11 | 24.47 | 2502547.0 |
| 2009-11-18 | ABCB | Stock | 6.214 | 6.3022 | 6.1748 | 6.2826 | 38873.0 |
| 2009-11-18 | ABCO-DELISTED | Stock | 13.083 | 13.083 | 12.832 | 13.002 | 106683.0 |
| 2009-11-18 | ABCW-DELISTED | Stock | 0.95 | 1.0 | 0.76 | 0.79 | 695450.0 |
| 2009-11-18 | ABD-DELISTED | Stock | 6.91 | 6.91 | 6.75 | 6.83 | 140710.0 |
| 2009-11-18 | ABE-DELISTED | Stock | 16.82 | 16.89 | 16.7675 | 16.84 | 12093.0 |
| 2009-11-18 | ABEO | Stock | 3925.0 | 3937.5 | 3750.0 | 3900.0 | 15.0 |
| 2009-11-18 | ABFS-DELISTED | Stock | 25.54 | 25.88 | 25.15 | 25.77 | 452867.0 |
| 2009-11-18 | ABG | Stock | 10.48 | 10.55 | 9.97 | 10.24 | 261300.0 |
| 2009-11-18 | ABII-DELISTED | Stock | 35.01 | 35.01 | 34.06 | 34.53 | 18652.0 |
| 2009-11-18 | ABK-DELISTED | Stock | 0.7108 | 1.03 | 0.7108 | 1.01 | 85889204.0 |
| 2009-11-18 | ABM | Stock | 19.69 | 19.92 | 19.37 | 19.51 | 92700.0 |
| 2009-11-18 | ABMD-DELISTED | Stock | 9.11 | 9.14 | 8.92 | 9.05 | 73911.0 |
| 2009-11-18 | ABR | Stock | 1.75 | 1.83 | 1.75 | 1.81 | 100200.0 |
| 2009-11-18 | ABT | Stock | 25.5781 | 25.5781 | 25.1895 | 25.5158 | 10070654.0 |
| 2009-11-18 | ABTL-DELISTED | Stock | 4.15 | 4.25 | 3.98 | 4.15 | 9662.0 |
| 2009-11-18 | ABV-DELISTED | Stock | 102.17 | 102.54 | 99.61 | 100.28 | 1232415.0 |
| 2009-11-18 | ABVT-DELISTED | Stock | 55.95 | 56.78 | 55.85 | 56.59 | 170431.0 |
| 2009-11-18 | ABX-DELISTED | Stock | 45.49 | 45.5 | 43.42 | 43.68 | 13217220.0 |
| 2009-11-18 | ACAD | Stock | 1.38 | 1.42 | 1.36 | 1.36 | 291700.0 |
| 2009-11-18 | ACAP-DELISTED | Stock | 28.25 | 28.25 | 27.74 | 28.05 | 110757.0 |
| 2009-11-18 | ACAS-DELISTED | Stock | 2.8848 | 3.09 | 2.8848 | 3.08 | 4697660.0 |
> showing 50 of 5,888 rows — these rows as CSV