PREVIEW / stock_daily / 2013-01-24
file: by_date/stock_daily/2013/2013-01-24.parquet size: 205 KB rows: 6,247 symbols: 3,510
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-24 | AAPL | Stock | 16.4286 | 16.6332 | 16.0804 | 16.0893 | 1460852400.0 |
| 2013-01-24 | MSFT | Stock | 27.7 | 28.07 | 27.47 | 27.63 | 101739300.0 |
| 2013-01-24 | NVDA | Stock | 0.3022 | 0.306 | 0.3008 | 0.3048 | 396980000.0 |
| 2013-01-24 | AMZN | Stock | 13.4685 | 13.8325 | 13.4685 | 13.673 | 68340000.0 |
| 2013-01-24 | META | Stock | 31.27 | 31.49 | 30.81 | 31.08 | 43845100.0 |
| 2013-01-24 | TSLA | Stock | 2.4 | 2.5147 | 2.3893 | 2.466 | 29556000.0 |
| 2013-01-24 | TLT | Stock | 119.87 | 119.97 | 119.26 | 119.67 | 4178881.0 |
| 2013-01-24 | ES | Stock | 39.75 | 40.15 | 39.7 | 39.91 | 1386200.0 |
| 2013-01-24 | CL | Stock | 54.645 | 55.065 | 54.635 | 54.885 | 3297000.0 |
| 2013-01-24 | A | Stock | 31.8741 | 32.3319 | 31.7811 | 31.9456 | 4350576.0 |
| 2013-01-24 | AABA-DELISTED | Stock | 20.08 | 20.52 | 20.07 | 20.42 | 13530415.0 |
| 2013-01-24 | AACC-DELISTED | Stock | 5.03 | 5.05 | 4.86 | 4.92 | 9781.0 |
| 2013-01-24 | AAIC-DELISTED | Stock | 23.21 | 23.21 | 22.83 | 22.92 | 102898.0 |
| 2013-01-24 | AAMC-DELISTED | Stock | 35.2941 | 35.2941 | 33.3088 | 33.6029 | 28846.0 |
| 2013-01-24 | AAME | Stock | 3.28 | 3.4 | 2.52 | 3.4 | 34600.0 |
| 2013-01-24 | AAMRQ-DELISTED | Stock | 1.415 | 1.42 | 1.35 | 1.4 | 4029816.0 |
| 2013-01-24 | AAON | Stock | 6.6459 | 6.9126 | 6.6163 | 6.8563 | 267975.0 |
| 2013-01-24 | AAP | Stock | 75.0 | 75.48 | 74.31 | 75.01 | 588000.0 |
| 2013-01-24 | AAT | Stock | 28.57 | 28.85 | 28.56 | 28.73 | 173200.0 |
| 2013-01-24 | AAU-DELISTED | Stock | 3.02 | 3.11 | 2.81 | 2.81 | 535300.0 |
| 2013-01-24 | AAUAF-DELISTED | Stock | 3.01 | 3.11 | 2.81 | 2.82 | 535730.0 |
| 2013-01-24 | AAV-DELISTED | Stock | 3.2 | 3.205 | 3.11 | 3.11 | 492313.0 |
| 2013-01-24 | AAWW-DELISTED | Stock | 46.09 | 47.24 | 45.4001 | 46.92 | 117356.0 |
| 2013-01-24 | AAXJ | Stock | 60.81 | 60.92 | 60.551 | 60.66 | 625559.0 |
| 2013-01-24 | AAXN-DELISTED | Stock | 9.3 | 9.53 | 9.21 | 9.35 | 677458.0 |
| 2013-01-24 | AB | Stock | 20.48 | 20.67 | 20.3 | 20.5 | 310500.0 |
| 2013-01-24 | ABAC-DELISTED | Stock | 0.85 | 0.92 | 0.85 | 0.8801 | 5400.0 |
| 2013-01-24 | ABAX-DELISTED | Stock | 38.79 | 40.5 | 38.55 | 40.46 | 94360.0 |
| 2013-01-24 | ABB-DELISTED | Stock | 20.95 | 21.13 | 20.945 | 21.07 | 1888879.0 |
| 2013-01-24 | ABBNY-DELISTED | Stock | 20.95 | 21.13 | 20.945 | 21.08 | 1963716.0 |
| 2013-01-24 | ABBV | Stock | 37.79 | 38.52 | 37.23 | 37.46 | 11327100.0 |
| 2013-01-24 | ABC-DELISTED | Stock | 45.92 | 46.15 | 44.73 | 45.72 | 3534813.0 |
| 2013-01-24 | ABCB | Stock | 13.05 | 13.21 | 12.99 | 13.16 | 18800.0 |
| 2013-01-24 | ABCD-DELISTED | Stock | 1.271 | 1.29 | 1.24 | 1.26 | 29520.0 |
| 2013-01-24 | ABCO-DELISTED | Stock | 53.29 | 54.0 | 53.02 | 53.69 | 109431.0 |
| 2013-01-24 | ABCW-DELISTED | Stock | 0.64 | 0.6897 | 0.64 | 0.65 | 76487.0 |
| 2013-01-24 | ABE-DELISTED | Stock | 22.2 | 22.23 | 22.0279 | 22.0279 | 7522.0 |
| 2013-01-24 | ABEO | Stock | 475.0 | 475.0 | 412.5 | 475.0 | 11.0 |
| 2013-01-24 | ABFS-DELISTED | Stock | 10.51 | 11.15 | 10.39 | 10.95 | 607698.0 |
| 2013-01-24 | ABG | Stock | 34.76 | 35.49 | 34.06 | 34.22 | 266600.0 |
| 2013-01-24 | ABM | Stock | 20.97 | 21.49 | 20.93 | 21.44 | 351100.0 |
| 2013-01-24 | ABMD-DELISTED | Stock | 12.61 | 13.12 | 12.57 | 13.06 | 855091.0 |
| 2013-01-24 | ABR | Stock | 7.1 | 7.19 | 7.04 | 7.12 | 111400.0 |
| 2013-01-24 | ABT | Stock | 32.65 | 32.95 | 32.58 | 32.8 | 17422200.0 |
| 2013-01-24 | ABTL-DELISTED | Stock | 3.99 | 4.03 | 3.98 | 4.01 | 6469.0 |
| 2013-01-24 | ABUS | Stock | 4.88 | 4.88 | 4.68 | 4.8 | 49200.0 |
| 2013-01-24 | ABV-DELISTED | Stock | 45.37 | 45.615 | 45.26 | 45.535 | 1732312.0 |
| 2013-01-24 | ABX-DELISTED | Stock | 33.91 | 33.94 | 33.28 | 33.29 | 11735535.0 |
| 2013-01-24 | ACAD | Stock | 5.94 | 5.95 | 5.6 | 5.9 | 2312200.0 |
| 2013-01-24 | ACAS-DELISTED | Stock | 13.11 | 13.2 | 12.915 | 12.93 | 3236582.0 |
> showing 50 of 6,247 rows — these rows as CSV