PREVIEW / stock_daily / 2012-09-21

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-21.parquet
  size:    203 KB
  rows:    6,206
  symbols: 3,527

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-09-21	AAPL	Stock	25.0861	25.1811	24.9771	25.0032	571589200.0
2012-09-21	MSFT	Stock	31.43	31.61	31.09	31.19	102348900.0
2012-09-21	NVDA	Stock	0.3408	0.3438	0.3395	0.3418	340136000.0
2012-09-21	AMZN	Stock	13.087	13.1	12.837	12.8735	121186000.0
2012-09-21	META	Stock	22.97	23.24	22.6	22.86	51218100.0
2012-09-21	TSLA	Stock	2.0733	2.0993	1.9693	2.0013	28050000.0
2012-09-21	TLT	Stock	120.75	121.64	120.67	121.55	4144263.0
2012-09-21	ES	Stock	37.08	37.54	36.79	37.43	2777600.0
2012-09-21	CL	Stock	53.5	53.575	53.05	53.265	11937600.0
2012-09-21	A	Stock	28.2761	28.4835	27.897	27.897	4927950.0
2012-09-21	AABA-DELISTED	Stock	15.7	15.82	15.66	15.715	48222377.0
2012-09-21	AACC-DELISTED	Stock	7.6	7.6	7.49	7.49	76407.0
2012-09-21	AACG	Stock	4.64	4.97	4.6	4.72	4100.0
2012-09-21	AAIC-DELISTED	Stock	24.65	24.85	24.63	24.82	3182115.0
2012-09-21	AAME	Stock	2.62	2.73	2.6	2.65	7800.0
2012-09-21	AAMRQ-DELISTED	Stock	0.361	0.449	0.361	0.425	4675274.0
2012-09-21	AAON	Stock	5.9259	5.9615	5.7304	5.9259	381713.0
2012-09-21	AAP	Stock	69.5	69.5	68.42	68.47	1087700.0
2012-09-21	AAT	Stock	27.07	27.15	26.89	26.96	371400.0
2012-09-21	AAU-DELISTED	Stock	3.05	3.06	2.91	2.97	201995.0
2012-09-21	AAUAF-DELISTED	Stock	3.05	3.06	2.91	2.97	213099.0
2012-09-21	AAV-DELISTED	Stock	3.81	3.95	3.78	3.9	213578.0
2012-09-21	AAWW-DELISTED	Stock	56.56	56.59	55.38	55.47	289523.0
2012-09-21	AAXJ	Stock	56.58	56.6799	56.33	56.33	67171.0
2012-09-21	AAXN-DELISTED	Stock	5.84	5.85	5.66	5.66	736795.0
2012-09-21	AB	Stock	15.19	15.57	15.08	15.49	301400.0
2012-09-21	ABAC-DELISTED	Stock	1.205	1.3	1.1101	1.29	8175.0
2012-09-21	ABAX-DELISTED	Stock	37.37	37.89	36.9	37.23	227524.0
2012-09-21	ABB-DELISTED	Stock	19.7	19.71	19.48	19.49	1497461.0
2012-09-21	ABBNY-DELISTED	Stock	19.7	19.71	19.48	19.5	1532376.0
2012-09-21	ABC-DELISTED	Stock	38.46	39.04	38.44	38.95	3211481.0
2012-09-21	ABCB	Stock	12.86	12.95	12.64	12.85	91600.0
2012-09-21	ABCD-DELISTED	Stock	1.09	1.1	1.01	1.01	21126.0
2012-09-21	ABCO-DELISTED	Stock	46.9	47.16	46.67	46.72	244004.0
2012-09-21	ABCW-DELISTED	Stock	0.38	0.41	0.38	0.4	15473.0
2012-09-21	ABE-DELISTED	Stock	20.31	20.64	20.31	20.55	20701.0
2012-09-21	ABEO	Stock	512.5	562.5	512.5	562.5	2.0
2012-09-21	ABFS-DELISTED	Stock	7.67	7.9	7.3216	7.41	994007.0
2012-09-21	ABG	Stock	29.3	29.3	28.03	28.24	369600.0
2012-09-21	ABM	Stock	18.76	19.02	18.74	18.91	620400.0
2012-09-21	ABMD-DELISTED	Stock	21.65	22.48	21.55	22.06	679489.0
2012-09-21	ABR	Stock	6.37	6.45	6.2	6.34	172600.0
2012-09-21	ABT	Stock	33.538	33.5812	33.4037	33.4037	19436640.0
2012-09-21	ABTL-DELISTED	Stock	3.63	3.65	3.52	3.6	67148.0
2012-09-21	ABUS	Stock	4.18	4.22	4.0	4.11	28800.0
2012-09-21	ABV-DELISTED	Stock	38.22	38.66	38.18	38.43	2364290.0
2012-09-21	ABVA-DELISTED	Stock	4.58	4.6	4.5	4.6	2651.0
2012-09-21	ABX-DELISTED	Stock	43.03	43.27	42.43	42.78	10145311.0
2012-09-21	ACAD	Stock	2.81	2.84	2.52	2.62	3573500.0
2012-09-21	ACAS-DELISTED	Stock	11.86	11.86	11.76	11.76	1447766.0

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

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