PREVIEW / stock_daily / 2011-01-12

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-12.parquet
  size:    197 KB
  rows:    6,055
  symbols: 3,543

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
2011-01-12	AAPL	Stock	12.2589	12.3011	12.2143	12.3007	302590400.0
2011-01-12	MSFT	Stock	28.12	28.59	28.07	28.55	52631100.0
2011-01-12	NVDA	Stock	0.508	0.5843	0.5062	0.5838	3431896000.0
2011-01-12	AMZN	Stock	9.268	9.269	9.165	9.204	53582000.0
2011-01-12	TSLA	Stock	1.8007	1.8267	1.768	1.7973	14466000.0
2011-01-12	TLT	Stock	91.74	92.17	91.45	91.61	9524134.0
2011-01-12	ES	Stock	31.7	31.79	31.57	31.62	1727700.0
2011-01-12	CL	Stock	39.285	39.44	38.885	39.205	5763200.0
2011-01-12	A	Stock	30.9013	31.0515	30.7296	30.8512	3443554.0
2011-01-12	AABA-DELISTED	Stock	16.71	16.81	16.59	16.65	14420286.0
2011-01-12	AACC-DELISTED	Stock	6.29	6.51	6.21	6.38	16482.0
2011-01-12	AACG	Stock	3.85	3.86	3.85	3.86	2900.0
2011-01-12	AAI-DELISTED	Stock	7.49	7.51	7.48	7.5	2322894.0
2011-01-12	AAIC-DELISTED	Stock	24.37	24.37	24.04	24.1	18423.0
2011-01-12	AAME	Stock	2.0	2.0	2.0	2.0	100.0
2011-01-12	AAON	Stock	5.4222	5.4933	5.3926	5.4202	218700.0
2011-01-12	AAP	Stock	62.23	63.63	62.11	62.8	1024600.0
2011-01-12	AATI-DELISTED	Stock	4.7	4.7	4.4296	4.45	133952.0
2011-01-12	AAU-DELISTED	Stock	4.7	4.75	4.46	4.56	525904.0
2011-01-12	AAUAF-DELISTED	Stock	4.7	4.75	4.46	4.56	528834.0
2011-01-12	AAV-DELISTED	Stock	6.95	7.05	6.92	7.04	536615.0
2011-01-12	AAWW-DELISTED	Stock	52.4	52.96	52.05	52.11	275923.0
2011-01-12	AAXJ	Stock	64.16	64.51	64.06	64.41	231890.0
2011-01-12	AAXN-DELISTED	Stock	4.91	4.91	4.77	4.79	318342.0
2011-01-12	AB	Stock	23.34	23.78	23.3	23.71	337400.0
2011-01-12	ABAC-DELISTED	Stock	6.15	6.15	5.95	5.99	68848.0
2011-01-12	ABAX-DELISTED	Stock	25.47	25.89	25.44	25.62	100273.0
2011-01-12	ABB-DELISTED	Stock	22.73	22.88	22.7	22.88	1853642.0
2011-01-12	ABBC-DELISTED	Stock	11.88	11.94	11.74	11.79	20329.0
2011-01-12	ABBNY-DELISTED	Stock	22.73	22.9	22.7	22.9	1856090.0
2011-01-12	ABC-DELISTED	Stock	35.21	35.25	34.76	34.84	1727577.0
2011-01-12	ABCB	Stock	10.88	10.97	10.78	10.96	28300.0
2011-01-12	ABCD-DELISTED	Stock	3.41	3.47	3.34	3.43	53739.0
2011-01-12	ABCO-DELISTED	Stock	24.21	24.31	23.93	24.11	60073.0
2011-01-12	ABCW-DELISTED	Stock	1.3618	1.4309	1.3509	1.42	284370.0
2011-01-12	ABD-DELISTED	Stock	8.245	8.455	8.184	8.445	183670.0
2011-01-12	ABE-DELISTED	Stock	19.11	19.27	19.076	19.21	17945.0
2011-01-12	ABEO	Stock	3012.5	3025.0	3000.0	3025.0	25.0
2011-01-12	ABFS-DELISTED	Stock	25.66	26.63	25.52	26.0	191414.0
2011-01-12	ABG	Stock	19.0	19.03	18.71	18.83	209300.0
2011-01-12	ABH-DELISTED	Stock	24.74	26.19	24.74	25.4999	840772.0
2011-01-12	ABM	Stock	26.3	26.38	26.16	26.27	131500.0
2011-01-12	ABMD-DELISTED	Stock	10.14	10.31	10.06	10.24	95821.0
2011-01-12	ABR	Stock	5.77	5.96	5.77	5.93	21200.0
2011-01-12	ABT	Stock	22.944	22.9488	22.8049	22.8289	19803251.0
2011-01-12	ABTL-DELISTED	Stock	5.15	5.5	5.0	5.25	22219.0
2011-01-12	ABUS	Stock	5.92	5.92	5.55	5.55	3800.0
2011-01-12	ABV-DELISTED	Stock	29.62	29.76	29.25	29.36	5107170.0
2011-01-12	ABVA-DELISTED	Stock	4.75	5.13	4.75	4.878	10888.0
2011-01-12	ABVT-DELISTED	Stock	60.54	60.7	59.93	60.59	57476.0

> showing 50 of 6,055 rows — these rows as CSV

> unlock the full archive -- $79 one-time