PREVIEW / stock_daily / 2009-05-07
file: by_date/stock_daily/2009/2009-05-07.parquet size: 180 KB rows: 5,777 symbols: 3,443
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-05-07 | AAPL | Stock | 4.7261 | 4.7282 | 4.5679 | 4.6093 | 531776000.0 |
| 2009-05-07 | MSFT | Stock | 19.96 | 19.99 | 19.14 | 19.32 | 68727200.0 |
| 2009-05-07 | NVDA | Stock | 0.2955 | 0.2955 | 0.2645 | 0.2683 | 1289196000.0 |
| 2009-05-07 | AMZN | Stock | 4.1365 | 4.1375 | 3.894 | 3.964 | 192642000.0 |
| 2009-05-07 | TLT | Stock | 95.94 | 96.7 | 94.33 | 94.71 | 5756391.0 |
| 2009-05-07 | ES | Stock | 21.54 | 21.6 | 21.17 | 21.26 | 1655300.0 |
| 2009-05-07 | CL | Stock | 30.85 | 31.075 | 30.605 | 30.935 | 9419400.0 |
| 2009-05-07 | A | Stock | 13.8412 | 13.8484 | 13.2976 | 13.4263 | 3590903.0 |
| 2009-05-07 | AABA-DELISTED | Stock | 15.07 | 15.1 | 14.38 | 14.77 | 23771554.0 |
| 2009-05-07 | AACC-DELISTED | Stock | 9.54 | 9.54 | 8.69 | 8.92 | 50811.0 |
| 2009-05-07 | AACG | Stock | 5.65 | 5.71 | 5.31 | 5.31 | 4500.0 |
| 2009-05-07 | AAI-DELISTED | Stock | 8.13 | 8.38 | 7.56 | 7.62 | 2171165.0 |
| 2009-05-07 | AAIC-DELISTED | Stock | 8.2 | 10.6 | 7.2 | 8.4 | 3765560.0 |
| 2009-05-07 | AAME | Stock | 0.65 | 0.65 | 0.65 | 0.65 | 500.0 |
| 2009-05-07 | AAON | Stock | 4.1442 | 4.1442 | 3.9486 | 4.0494 | 894544.0 |
| 2009-05-07 | AAP | Stock | 42.96 | 43.05 | 41.53 | 41.85 | 1498300.0 |
| 2009-05-07 | AATI-DELISTED | Stock | 4.61 | 4.65 | 4.13 | 4.18 | 640804.0 |
| 2009-05-07 | AAU-DELISTED | Stock | 0.611 | 0.63 | 0.579 | 0.609 | 93568.0 |
| 2009-05-07 | AAUAF-DELISTED | Stock | 0.612 | 0.64 | 0.58 | 0.61 | 94420.0 |
| 2009-05-07 | AAV-DELISTED | Stock | 3.45 | 3.58 | 3.33 | 3.39 | 1532665.0 |
| 2009-05-07 | AAWW-DELISTED | Stock | 32.74 | 33.49 | 28.35 | 29.46 | 269619.0 |
| 2009-05-07 | AAXJ | Stock | 42.91 | 43.0 | 40.96 | 41.34 | 184329.0 |
| 2009-05-07 | AAXN-DELISTED | Stock | 4.61 | 4.74 | 4.36 | 4.42 | 758489.0 |
| 2009-05-07 | AB | Stock | 19.41 | 19.78 | 17.72 | 18.09 | 698400.0 |
| 2009-05-07 | ABAX-DELISTED | Stock | 16.0 | 17.0 | 16.0 | 16.67 | 397766.0 |
| 2009-05-07 | ABB-DELISTED | Stock | 16.41 | 16.49 | 15.8 | 16.01 | 4150620.0 |
| 2009-05-07 | ABBC-DELISTED | Stock | 8.7 | 8.88 | 8.55 | 8.67 | 55958.0 |
| 2009-05-07 | ABBNY-DELISTED | Stock | 16.41 | 16.49 | 15.8 | 16.03 | 4291583.0 |
| 2009-05-07 | ABC-DELISTED | Stock | 17.7 | 18.34 | 17.55 | 18.18 | 4401984.0 |
| 2009-05-07 | ABCB | Stock | 6.1763 | 6.361 | 5.7483 | 5.7483 | 29713.0 |
| 2009-05-07 | ABCO-DELISTED | Stock | 9.67 | 10.4 | 9.55 | 10.285 | 381687.0 |
| 2009-05-07 | ABCW-DELISTED | Stock | 1.65 | 1.77 | 1.55 | 1.58 | 118620.0 |
| 2009-05-07 | ABD-DELISTED | Stock | 3.31 | 3.47 | 3.1368 | 3.16 | 323170.0 |
| 2009-05-07 | ABE-DELISTED | Stock | 15.0312 | 15.0312 | 14.568 | 14.57 | 13635.0 |
| 2009-05-07 | ABEO | Stock | 1937.5 | 2150.0 | 1700.0 | 2000.0 | 132.0 |
| 2009-05-07 | ABFS-DELISTED | Stock | 26.58 | 27.38 | 25.34 | 25.69 | 422390.0 |
| 2009-05-07 | ABG | Stock | 10.32 | 10.74 | 9.54 | 9.85 | 404100.0 |
| 2009-05-07 | ABII-DELISTED | Stock | 48.31 | 48.77 | 45.19 | 48.38 | 23216.0 |
| 2009-05-07 | ABK-DELISTED | Stock | 1.53 | 1.54 | 1.23 | 1.31 | 22180681.0 |
| 2009-05-07 | ABM | Stock | 17.49 | 17.55 | 16.6 | 16.74 | 198000.0 |
| 2009-05-07 | ABMD-DELISTED | Stock | 7.02 | 7.21 | 6.51 | 6.65 | 405840.0 |
| 2009-05-07 | ABR | Stock | 3.37 | 3.65 | 2.95 | 3.1 | 412600.0 |
| 2009-05-07 | ABT | Stock | 20.7466 | 21.4758 | 20.6314 | 21.4087 | 26699041.0 |
| 2009-05-07 | ABTL-DELISTED | Stock | 2.5 | 2.5 | 2.3 | 2.45 | 4251.0 |
| 2009-05-07 | ABV-DELISTED | Stock | 60.7 | 61.42 | 58.91 | 59.38 | 1084447.0 |
| 2009-05-07 | ABVA-DELISTED | Stock | 2.12 | 2.12 | 2.09 | 2.1 | 1600.0 |
| 2009-05-07 | ABVT-DELISTED | Stock | 57.0 | 57.0 | 56.25 | 56.3 | 3050.0 |
| 2009-05-07 | ABX-DELISTED | Stock | 33.73 | 33.91 | 32.39 | 32.82 | 11359739.0 |
| 2009-05-07 | ACAD | Stock | 2.0 | 2.0 | 1.74 | 1.74 | 596000.0 |
| 2009-05-07 | ACAP-DELISTED | Stock | 40.95 | 41.5 | 39.25 | 41.28 | 50048.0 |
> showing 50 of 5,777 rows — these rows as CSV