PREVIEW / stock_daily / 2010-06-23

all stock daily files

  file:    by_date/stock_daily/2010/2010-06-23.parquet
  size:    187 KB
  rows:    5,893
  symbols: 3,462

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
2010-06-23	AAPL	Stock	9.8064	9.8093	9.5679	9.6775	768457200.0
2010-06-23	MSFT	Stock	25.78	25.78	25.22	25.31	61466200.0
2010-06-23	NVDA	Stock	0.2918	0.2952	0.2835	0.2922	614060000.0
2010-06-23	AMZN	Stock	6.1055	6.161	6.002	6.0725	109102000.0
2010-06-23	TLT	Stock	98.61	99.57	98.57	99.24	9137828.0
2010-06-23	ES	Stock	26.09	26.09	25.55	25.66	1058400.0
2010-06-23	CL	Stock	40.355	40.54	40.025	40.165	4431200.0
2010-06-23	A	Stock	22.9471	23.1259	22.5179	22.8684	3223229.0
2010-06-23	AABA-DELISTED	Stock	15.16	15.3905	14.95	15.24	13121093.0
2010-06-23	AACC-DELISTED	Stock	4.7	4.81	4.61	4.71	109557.0
2010-06-23	AAI-DELISTED	Stock	5.12	5.3	5.06	5.21	3979260.0
2010-06-23	AAIC-DELISTED	Stock	20.25	20.35	19.4	19.55	59186.0
2010-06-23	AAME	Stock	1.48	1.48	1.48	1.48	300.0
2010-06-23	AAON	Stock	4.7723	4.8277	4.6973	4.7407	212625.0
2010-06-23	AAP	Stock	50.08	51.21	50.05	50.87	802200.0
2010-06-23	AATI-DELISTED	Stock	3.41	3.46	3.36	3.37	109635.0
2010-06-23	AAU-DELISTED	Stock	0.95	0.9601	0.92	0.95	57370.0
2010-06-23	AAUAF-DELISTED	Stock	0.95	0.9601	0.92	0.95	57970.0
2010-06-23	AAV-DELISTED	Stock	6.58	6.67	6.42	6.59	410681.0
2010-06-23	AAWW-DELISTED	Stock	51.02	52.19	50.62	51.37	142114.0
2010-06-23	AAXJ	Stock	55.94	55.94	54.3	54.64	1714268.0
2010-06-23	AAXN-DELISTED	Stock	3.86	3.96	3.8281	3.93	957727.0
2010-06-23	AB	Stock	28.98	29.34	28.54	29.31	232600.0
2010-06-23	ABAX-DELISTED	Stock	21.92	22.09	21.25	21.4	198137.0
2010-06-23	ABB-DELISTED	Stock	18.71	18.72	18.29	18.4	6004073.0
2010-06-23	ABBC-DELISTED	Stock	8.99	9.0	8.83	8.86	47755.0
2010-06-23	ABBNY-DELISTED	Stock	18.71	18.72	18.29	18.39	6059255.0
2010-06-23	ABC-DELISTED	Stock	31.82	32.05	31.51	31.85	3267495.0
2010-06-23	ABCB	Stock	9.9128	10.072	9.9028	9.9128	61190.0
2010-06-23	ABCD-DELISTED	Stock	4.63	4.67	4.31	4.43	79759.0
2010-06-23	ABCO-DELISTED	Stock	20.89	21.31	20.5	21.02	95532.0
2010-06-23	ABCW-DELISTED	Stock	0.6587	0.6695	0.639	0.64	42310.0
2010-06-23	ABD-DELISTED	Stock	5.43	5.55	5.25	5.4	557690.0
2010-06-23	ABE-DELISTED	Stock	16.02	16.04	15.82	16.01	7320.0
2010-06-23	ABEO	Stock	2787.5	3000.0	2700.0	2937.5	30.0
2010-06-23	ABFS-DELISTED	Stock	19.87	20.8	19.87	20.49	593677.0
2010-06-23	ABG	Stock	11.38	11.9	11.09	11.72	875200.0
2010-06-23	ABII-DELISTED	Stock	60.68	61.41	59.9	60.98	69389.0
2010-06-23	ABK-DELISTED	Stock	0.79	0.8075	0.7512	0.7801	4750268.0
2010-06-23	ABM	Stock	22.09	22.27	21.85	22.06	211000.0
2010-06-23	ABMD-DELISTED	Stock	9.53	9.63	9.4	9.43	110491.0
2010-06-23	ABR	Stock	5.26	5.4	5.12	5.16	81300.0
2010-06-23	ABT	Stock	23.0496	23.1072	22.7329	22.8193	13522926.0
2010-06-23	ABTL-DELISTED	Stock	5.85	5.9	5.6	5.75	23469.0
2010-06-23	ABV-DELISTED	Stock	106.69	107.67	105.13	107.41	651551.0
2010-06-23	ABVA-DELISTED	Stock	2.62	2.62	2.499	2.6	9124.0
2010-06-23	ABVT-DELISTED	Stock	48.23	49.06	47.8	48.83	128083.0
2010-06-23	ABX-DELISTED	Stock	44.24	44.96	43.91	44.76	8114320.0
2010-06-23	ACAD	Stock	1.24	1.25	1.22	1.23	90700.0
2010-06-23	ACAP-DELISTED	Stock	31.51	31.91	31.5	31.67	40118.0

> showing 50 of 5,893 rows — these rows as CSV

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