PREVIEW / stock_daily / 2012-09-04

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-04.parquet
  size:    199 KB
  rows:    6,131
  symbols: 3,480

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-04	AAPL	Stock	23.7771	24.1121	23.7321	24.1061	367892000.0
2012-09-04	MSFT	Stock	30.45	30.66	30.15	30.39	48556700.0
2012-09-04	NVDA	Stock	0.345	0.3462	0.3288	0.332	694452000.0
2012-09-04	AMZN	Stock	12.4135	12.55	12.233	12.394	79016000.0
2012-09-04	META	Stock	18.08	18.27	17.55	17.73	46622400.0
2012-09-04	TSLA	Stock	1.9013	1.9327	1.86	1.876	11287500.0
2012-09-04	TLT	Stock	126.92	127.63	126.76	127.32	6009260.0
2012-09-04	ES	Stock	37.68	38.02	37.49	38.01	1758600.0
2012-09-04	CL	Stock	53.08	53.7	52.96	53.61	4388400.0
2012-09-04	A	Stock	26.4449	26.8026	26.2589	26.5021	5382300.0
2012-09-04	AABA-DELISTED	Stock	14.64	14.98	14.59	14.89	18239032.0
2012-09-04	AACC-DELISTED	Stock	6.52	6.57	6.2	6.49	41415.0
2012-09-04	AACG	Stock	4.36	4.42	4.36	4.36	1400.0
2012-09-04	AAIC-DELISTED	Stock	22.95	22.95	22.67	22.78	120786.0
2012-09-04	AAME	Stock	2.75	2.75	2.7	2.7	21100.0
2012-09-04	AAMRQ-DELISTED	Stock	0.4895	0.505	0.471	0.478	1720034.0
2012-09-04	AAON	Stock	5.443	5.4696	5.3126	5.4548	75938.0
2012-09-04	AAP	Stock	71.12	71.18	69.0	70.26	843500.0
2012-09-04	AAT	Stock	27.33	27.5	26.99	27.42	123500.0
2012-09-04	AAU-DELISTED	Stock	2.76	2.76	2.71	2.74	172113.0
2012-09-04	AAUAF-DELISTED	Stock	2.76	2.76	2.71	2.74	177219.0
2012-09-04	AAV-DELISTED	Stock	3.48	3.5101	3.46	3.5	116384.0
2012-09-04	AAWW-DELISTED	Stock	51.34	52.4	50.66	52.2	145755.0
2012-09-04	AAXJ	Stock	52.86	53.04	52.59	52.79	200732.0
2012-09-04	AAXN-DELISTED	Stock	5.35	5.43	5.3199	5.42	322427.0
2012-09-04	AB	Stock	14.34	14.43	14.07	14.24	249600.0
2012-09-04	ABAC-DELISTED	Stock	1.08	1.1	1.08	1.1	13100.0
2012-09-04	ABAX-DELISTED	Stock	37.47	38.49	37.06	38.25	92891.0
2012-09-04	ABB-DELISTED	Stock	17.34	17.37	17.14	17.25	1454522.0
2012-09-04	ABBNY-DELISTED	Stock	17.34	17.37	17.14	17.24	1474300.0
2012-09-04	ABC-DELISTED	Stock	38.52	39.0	38.26	38.79	2284430.0
2012-09-04	ABCB	Stock	11.77	12.16	11.77	12.06	46900.0
2012-09-04	ABCD-DELISTED	Stock	1.0	1.01	0.985	0.985	9869.0
2012-09-04	ABCO-DELISTED	Stock	44.18	45.93	44.18	45.85	269489.0
2012-09-04	ABCW-DELISTED	Stock	0.36	0.4	0.36	0.4	16912.0
2012-09-04	ABE-DELISTED	Stock	19.4	19.4099	19.39	19.3917	2536.0
2012-09-04	ABEO	Stock	650.0	825.0	650.0	737.5	10.0
2012-09-04	ABFS-DELISTED	Stock	9.2	9.34	9.03	9.32	290225.0
2012-09-04	ABG	Stock	27.58	28.2	27.35	27.9	257800.0
2012-09-04	ABM	Stock	20.25	20.25	19.83	20.06	519700.0
2012-09-04	ABMD-DELISTED	Stock	22.3	23.0	21.94	22.94	467328.0
2012-09-04	ABR	Stock	5.78	5.8	5.5	5.69	45900.0
2012-09-04	ABT	Stock	31.3117	31.5085	30.9807	31.4077	9572530.0
2012-09-04	ABTL-DELISTED	Stock	3.57	3.69	3.57	3.63	49742.0
2012-09-04	ABUS	Stock	3.3	3.3	3.22	3.23	7600.0
2012-09-04	ABV-DELISTED	Stock	37.5	37.56	36.8	36.87	1592713.0
2012-09-04	ABVA-DELISTED	Stock	4.995	5.0	4.73	5.0	700.0
2012-09-04	ABX-DELISTED	Stock	38.7	38.74	37.95	38.24	6108772.0
2012-09-04	ACAD	Stock	1.79	1.84	1.71	1.75	571500.0
2012-09-04	ACAS-DELISTED	Stock	10.985	11.155	10.955	11.15	4513885.0

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

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