PREVIEW / stock_daily / 2009-08-18
file: by_date/stock_daily/2009/2009-08-18.parquet size: 184 KB rows: 5,819 symbols: 3,459
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-08-18 | AAPL | Stock | 5.7725 | 5.8657 | 5.7646 | 5.8571 | 431152400.0 |
| 2009-08-18 | MSFT | Stock | 23.29 | 23.65 | 23.27 | 23.58 | 38878900.0 |
| 2009-08-18 | NVDA | Stock | 0.3215 | 0.337 | 0.3213 | 0.3333 | 636200000.0 |
| 2009-08-18 | AMZN | Stock | 4.0705 | 4.1345 | 4.0395 | 4.106 | 117688000.0 |
| 2009-08-18 | TLT | Stock | 94.66 | 94.7694 | 94.01 | 94.18 | 2557827.0 |
| 2009-08-18 | ES | Stock | 23.58 | 23.72 | 23.49 | 23.55 | 1153600.0 |
| 2009-08-18 | CL | Stock | 35.665 | 35.71 | 35.355 | 35.635 | 2967400.0 |
| 2009-08-18 | A | Stock | 17.5393 | 18.598 | 17.2818 | 18.176 | 18696992.0 |
| 2009-08-18 | AABA-DELISTED | Stock | 14.66 | 14.78 | 14.56 | 14.75 | 14726664.0 |
| 2009-08-18 | AACC-DELISTED | Stock | 7.42 | 7.57 | 7.1 | 7.48 | 27102.0 |
| 2009-08-18 | AACG | Stock | 7.18 | 7.5 | 6.66 | 7.0 | 9400.0 |
| 2009-08-18 | AAI-DELISTED | Stock | 6.46 | 6.54 | 6.35 | 6.38 | 1605636.0 |
| 2009-08-18 | AAIC-DELISTED | Stock | 8.6 | 9.2 | 8.4 | 8.8 | 351865.0 |
| 2009-08-18 | AAME | Stock | 0.82 | 0.82 | 0.82 | 0.82 | 4600.0 |
| 2009-08-18 | AAON | Stock | 4.3062 | 4.4089 | 4.2133 | 4.2864 | 8962144.0 |
| 2009-08-18 | AAP | Stock | 43.17 | 43.77 | 42.88 | 43.1 | 1674400.0 |
| 2009-08-18 | AATI-DELISTED | Stock | 4.5 | 4.63 | 4.49 | 4.57 | 149991.0 |
| 2009-08-18 | AAU-DELISTED | Stock | 0.6 | 0.63 | 0.59 | 0.62 | 19215.0 |
| 2009-08-18 | AAUAF-DELISTED | Stock | 0.6 | 0.63 | 0.59 | 0.62 | 21815.0 |
| 2009-08-18 | AAV-DELISTED | Stock | 4.98 | 5.07 | 4.88 | 5.04 | 630951.0 |
| 2009-08-18 | AAWW-DELISTED | Stock | 24.99 | 25.0 | 24.11 | 24.37 | 312036.0 |
| 2009-08-18 | AAXJ | Stock | 48.0 | 48.3 | 47.73 | 48.3 | 155095.0 |
| 2009-08-18 | AAXN-DELISTED | Stock | 4.8 | 4.88 | 4.76 | 4.82 | 259595.0 |
| 2009-08-18 | AB | Stock | 20.54 | 21.1 | 20.5 | 20.63 | 277800.0 |
| 2009-08-18 | ABAX-DELISTED | Stock | 27.5 | 27.78 | 27.16 | 27.35 | 131718.0 |
| 2009-08-18 | ABB-DELISTED | Stock | 17.82 | 18.01 | 17.71 | 17.92 | 2356703.0 |
| 2009-08-18 | ABBC-DELISTED | Stock | 8.21 | 8.26 | 8.05 | 8.13 | 31465.0 |
| 2009-08-18 | ABBNY-DELISTED | Stock | 17.82 | 18.01 | 17.71 | 17.91 | 2490978.0 |
| 2009-08-18 | ABC-DELISTED | Stock | 20.24 | 20.53 | 19.84 | 20.52 | 2817518.0 |
| 2009-08-18 | ABCB | Stock | 6.0791 | 6.3319 | 6.0303 | 6.0596 | 60865.0 |
| 2009-08-18 | ABCO-DELISTED | Stock | 13.363 | 13.533 | 13.187 | 13.342 | 69004.0 |
| 2009-08-18 | ABCW-DELISTED | Stock | 1.5 | 1.51 | 1.42 | 1.48 | 99210.0 |
| 2009-08-18 | ABD-DELISTED | Stock | 4.71 | 5.4 | 4.65 | 5.27 | 639260.0 |
| 2009-08-18 | ABE-DELISTED | Stock | 15.85 | 16.0 | 15.81 | 16.0 | 18607.0 |
| 2009-08-18 | ABEO | Stock | 4850.0 | 5062.5 | 4512.5 | 5000.0 | 31.0 |
| 2009-08-18 | ABFS-DELISTED | Stock | 28.15 | 29.77 | 28.126 | 29.62 | 678618.0 |
| 2009-08-18 | ABG | Stock | 12.39 | 13.01 | 12.09 | 12.85 | 218300.0 |
| 2009-08-18 | ABII-DELISTED | Stock | 29.77 | 30.09 | 29.0 | 29.0 | 210476.0 |
| 2009-08-18 | ABK-DELISTED | Stock | 0.98 | 1.11 | 0.95 | 1.06 | 12661639.0 |
| 2009-08-18 | ABM | Stock | 20.74 | 21.31 | 20.45 | 21.2 | 125700.0 |
| 2009-08-18 | ABMD-DELISTED | Stock | 7.46 | 7.64 | 7.3 | 7.54 | 101993.0 |
| 2009-08-18 | ABR | Stock | 1.81 | 1.96 | 1.81 | 1.96 | 114900.0 |
| 2009-08-18 | ABT | Stock | 21.495 | 21.4998 | 21.1736 | 21.2695 | 14943935.0 |
| 2009-08-18 | ABTL-DELISTED | Stock | 2.3705 | 2.6226 | 2.3705 | 2.55 | 141819.0 |
| 2009-08-18 | ABV-DELISTED | Stock | 73.29 | 73.95 | 72.97 | 73.44 | 255745.0 |
| 2009-08-18 | ABVT-DELISTED | Stock | 92.81 | 94.1399 | 92.645 | 93.49 | 126669.0 |
| 2009-08-18 | ABX-DELISTED | Stock | 33.0 | 33.66 | 32.96 | 33.46 | 6728632.0 |
| 2009-08-18 | ACAD | Stock | 5.75 | 5.95 | 5.58 | 5.75 | 1316800.0 |
| 2009-08-18 | ACAP-DELISTED | Stock | 32.1 | 32.11 | 31.38 | 31.73 | 44650.0 |
| 2009-08-18 | ACAS-DELISTED | Stock | 2.8 | 2.9 | 2.8 | 2.87 | 4010318.0 |
> showing 50 of 5,819 rows — these rows as CSV