PREVIEW / stock_daily / 2012-11-19

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-19.parquet
  size:    200 KB
  rows:    6,205
  symbols: 3,498

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
2012-11-19	AAPL	Stock	19.3111	20.2679	19.2814	20.2046	823317600.0
2012-11-19	MSFT	Stock	26.8	26.8	26.47	26.73	57179300.0
2012-11-19	NVDA	Stock	0.2898	0.2935	0.2862	0.2925	404092000.0
2012-11-19	AMZN	Stock	11.416	11.625	11.3725	11.4855	71824000.0
2012-11-19	META	Stock	23.96	24.12	22.82	22.92	85021300.0
2012-11-19	TSLA	Stock	2.138	2.2167	2.1227	2.1947	20886000.0
2012-11-19	TLT	Stock	125.46	125.81	125.3	125.66	3623180.0
2012-11-19	ES	Stock	38.5	38.57	37.95	38.17	1420000.0
2012-11-19	CL	Stock	52.955	53.455	52.9	53.455	3025800.0
2012-11-19	A	Stock	26.4735	27.1674	26.4735	26.8312	7159438.0
2012-11-19	AABA-DELISTED	Stock	18.02	18.37	17.87	18.35	30607983.0
2012-11-19	AACC-DELISTED	Stock	4.3	4.55	4.3	4.51	47144.0
2012-11-19	AACG	Stock	4.42	4.61	4.42	4.56	4900.0
2012-11-19	AAIC-DELISTED	Stock	20.48	20.96	20.43	20.63	149659.0
2012-11-19	AAME	Stock	2.9	2.94	2.9	2.9	3500.0
2012-11-19	AAMRQ-DELISTED	Stock	0.366	0.376	0.363	0.374	521665.0
2012-11-19	AAON	Stock	5.7215	5.8637	5.603	5.7956	227138.0
2012-11-19	AAP	Stock	77.43	78.22	77.14	77.79	813200.0
2012-11-19	AAT	Stock	26.69	27.57	26.68	27.19	216800.0
2012-11-19	AAU-DELISTED	Stock	2.5	2.6	2.49	2.54	61845.0
2012-11-19	AAUAF-DELISTED	Stock	2.57	2.65	2.54	2.54	61148.0
2012-11-19	AAV-DELISTED	Stock	3.4	3.41	3.35	3.37	341782.0
2012-11-19	AAWW-DELISTED	Stock	42.23	42.38	41.34	42.34	149872.0
2012-11-19	AAXJ	Stock	56.15	56.59	56.15	56.59	124243.0
2012-11-19	AAXN-DELISTED	Stock	7.76	8.16	7.69	8.1	541334.0
2012-11-19	AB	Stock	16.01	16.75	16.0	16.63	264900.0
2012-11-19	ABAC-DELISTED	Stock	0.83	0.86	0.782	0.782	11606.0
2012-11-19	ABAX-DELISTED	Stock	35.23	35.76	35.11	35.76	59496.0
2012-11-19	ABB-DELISTED	Stock	17.98	18.1	17.975	18.04	2363152.0
2012-11-19	ABBNY-DELISTED	Stock	17.98	18.1	17.975	18.05	2878662.0
2012-11-19	ABC-DELISTED	Stock	40.48	40.79	40.37	40.68	1401362.0
2012-11-19	ABCB	Stock	10.66	10.92	10.66	10.88	51700.0
2012-11-19	ABCD-DELISTED	Stock	1.0	1.01	0.89	1.0	17229.0
2012-11-19	ABCO-DELISTED	Stock	44.08	44.36	43.11	43.66	259663.0
2012-11-19	ABCW-DELISTED	Stock	0.3801	0.4199	0.3601	0.394	37406.0
2012-11-19	ABE-DELISTED	Stock	19.65	20.26	19.62	20.05	18140.0
2012-11-19	ABEO	Stock	337.5	337.5	287.5	312.5	40.0
2012-11-19	ABFS-DELISTED	Stock	6.66	7.19	6.65	7.17	453885.0
2012-11-19	ABG	Stock	28.8	29.61	28.75	29.17	280500.0
2012-11-19	ABM	Stock	18.5	18.61	18.19	18.36	247600.0
2012-11-19	ABMD-DELISTED	Stock	14.39	14.4	14.0	14.1	523830.0
2012-11-19	ABR	Stock	5.13	5.21	5.0	5.08	131200.0
2012-11-19	ABT	Stock	30.3474	30.4769	30.0595	30.189	18098583.0
2012-11-19	ABTL-DELISTED	Stock	3.94	3.95	3.82	3.95	20530.0
2012-11-19	ABUS	Stock	5.17	5.36	5.17	5.25	166800.0
2012-11-19	ABV-DELISTED	Stock	40.38	40.74	40.14	40.33	1949908.0
2012-11-19	ABVA-DELISTED	Stock	4.37	4.399	4.21	4.356	8311.0
2012-11-19	ABX-DELISTED	Stock	34.25	34.54	34.13	34.3	6495792.0
2012-11-19	ACAD	Stock	1.96	2.28	1.9	2.26	2979300.0
2012-11-19	ACAS-DELISTED	Stock	11.57	11.68	11.55	11.61	2201175.0

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

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