PREVIEW / stock_daily / 2012-07-13

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-13.parquet
  size:    198 KB
  rows:    6,136
  symbols: 3,508

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-07-13	AAPL	Stock	21.5339	21.6854	21.4286	21.6061	311427200.0
2012-07-13	MSFT	Stock	28.76	29.48	28.72	29.39	39085000.0
2012-07-13	NVDA	Stock	0.3103	0.3155	0.3083	0.314	324260000.0
2012-07-13	AMZN	Stock	10.7815	10.9655	10.694	10.9195	44438000.0
2012-07-13	META	Stock	31.04	31.07	30.56	30.72	8108300.0
2012-07-13	TSLA	Stock	2.198	2.2933	2.1887	2.2833	19572000.0
2012-07-13	TLT	Stock	129.23	129.24	128.6	129.17	4175473.0
2012-07-13	ES	Stock	39.12	39.97	39.12	39.88	1624600.0
2012-07-13	CL	Stock	51.855	52.88	51.855	52.73	2849200.0
2012-07-13	A	Stock	26.1445	26.7811	26.0086	26.495	4727477.0
2012-07-13	AABA-DELISTED	Stock	15.73	15.81	15.69	15.75	11492845.0
2012-07-13	AACC-DELISTED	Stock	6.99	6.99	6.9	6.95	49190.0
2012-07-13	AACG	Stock	4.06	4.22	4.06	4.22	1900.0
2012-07-13	AAIC-DELISTED	Stock	22.04	22.45	22.0	22.29	47397.0
2012-07-13	AAME	Stock	2.78	2.8	2.74	2.75	3400.0
2012-07-13	AAMRQ-DELISTED	Stock	0.515	0.549	0.515	0.535	641092.0
2012-07-13	AAON	Stock	5.8963	6.1304	5.8963	6.1037	95175.0
2012-07-13	AAP	Stock	71.75	72.51	71.34	71.6	1338800.0
2012-07-13	AAT	Stock	25.02	25.13	24.84	24.88	155100.0
2012-07-13	AAU-DELISTED	Stock	1.96	1.96	1.91	1.93	27540.0
2012-07-13	AAUAF-DELISTED	Stock	1.95	1.95	1.91	1.94	27711.0
2012-07-13	AAV-DELISTED	Stock	3.21	3.26	3.17	3.2	135499.0
2012-07-13	AAWW-DELISTED	Stock	44.85	46.05	44.56	45.34	136101.0
2012-07-13	AAXJ	Stock	51.47	52.07	51.3901	51.97	164986.0
2012-07-13	AAXN-DELISTED	Stock	5.06	5.19	5.0009	5.13	142772.0
2012-07-13	AB	Stock	12.32	12.51	12.26	12.42	243600.0
2012-07-13	ABAC-DELISTED	Stock	1.19	1.19	1.15	1.19	2000.0
2012-07-13	ABAX-DELISTED	Stock	39.15	40.17	39.01	39.51	222878.0
2012-07-13	ABB-DELISTED	Stock	15.81	16.09	15.81	16.07	1194682.0
2012-07-13	ABBNY-DELISTED	Stock	15.81	16.09	15.81	16.08	1236931.0
2012-07-13	ABC-DELISTED	Stock	39.22	39.81	38.92	39.64	1685829.0
2012-07-13	ABCB	Stock	12.38	12.75	12.3	12.67	92200.0
2012-07-13	ABCD-DELISTED	Stock	1.09	1.15	1.09	1.13	9725.0
2012-07-13	ABCO-DELISTED	Stock	50.62	51.66	50.62	51.22	121477.0
2012-07-13	ABCW-DELISTED	Stock	0.54	0.54	0.41	0.5	6275.0
2012-07-13	ABE-DELISTED	Stock	18.79	19.0199	18.79	19.007	3864.0
2012-07-13	ABEO	Stock	700.0	712.5	700.0	700.0	14.0
2012-07-13	ABFS-DELISTED	Stock	11.23	12.11	11.21	11.99	433507.0
2012-07-13	ABG	Stock	25.38	26.5	25.28	26.44	357300.0
2012-07-13	ABM	Stock	18.05	18.37	17.9	18.19	757700.0
2012-07-13	ABMD-DELISTED	Stock	23.85	24.5	23.8012	24.43	292465.0
2012-07-13	ABR	Stock	5.25	5.3	5.17	5.27	21500.0
2012-07-13	ABT	Stock	31.3022	31.4269	31.2494	31.4029	9690288.0
2012-07-13	ABTL-DELISTED	Stock	3.85	3.95	3.76	3.85	19764.0
2012-07-13	ABUS	Stock	2.2	2.24	2.2	2.24	3000.0
2012-07-13	ABV-DELISTED	Stock	36.68	37.05	36.67	36.75	1743478.0
2012-07-13	ABX-DELISTED	Stock	34.84	35.18	34.52	34.84	7188062.0
2012-07-13	ACAD	Stock	1.68	1.74	1.5	1.62	1525500.0
2012-07-13	ACAS-DELISTED	Stock	9.83	10.01	9.83	9.99	1542799.0
2012-07-13	ACAT-DELISTED	Stock	35.91	37.07	35.6	36.11	145937.0

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

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