PREVIEW / stock_daily / 2012-07-06

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-06.parquet
  size:    197 KB
  rows:    6,129
  symbols: 3,492

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-06	AAPL	Stock	21.6818	21.73	21.485	21.6386	418930400.0
2012-07-06	MSFT	Stock	30.61	30.7	29.95	30.19	38294800.0
2012-07-06	NVDA	Stock	0.339	0.34	0.3313	0.335	382760000.0
2012-07-06	AMZN	Stock	11.3175	11.445	11.209	11.2525	64064000.0
2012-07-06	META	Stock	31.44	31.9	31.26	31.73	10945600.0
2012-07-06	TSLA	Stock	2.066	2.1153	2.0533	2.066	11767500.0
2012-07-06	TLT	Stock	126.67	127.205	126.61	127.06	5819078.0
2012-07-06	ES	Stock	38.5	38.74	38.39	38.69	950600.0
2012-07-06	CL	Stock	52.05	52.315	51.96	52.145	1952000.0
2012-07-06	A	Stock	27.7539	27.7754	26.8813	27.1602	4664287.0
2012-07-06	AABA-DELISTED	Stock	15.8	15.91	15.68	15.79	11801507.0
2012-07-06	AACC-DELISTED	Stock	7.82	7.84	7.26	7.33	123805.0
2012-07-06	AACG	Stock	4.13	4.38	4.11	4.14	1900.0
2012-07-06	AAIC-DELISTED	Stock	22.2	22.46	22.114	22.35	44571.0
2012-07-06	AAME	Stock	2.75	2.76	2.62	2.72	6700.0
2012-07-06	AAMRQ-DELISTED	Stock	0.49	0.5028	0.487	0.49	489003.0
2012-07-06	AAON	Stock	5.757	5.9793	5.757	5.9674	131963.0
2012-07-06	AAP	Stock	68.49	69.32	68.39	69.05	970200.0
2012-07-06	AAT	Stock	24.51	24.9	24.51	24.88	50600.0
2012-07-06	AAU-DELISTED	Stock	2.12	2.135	2.02	2.1	79213.0
2012-07-06	AAUAF-DELISTED	Stock	2.11	2.1299	2.02	2.11	79898.0
2012-07-06	AAV-DELISTED	Stock	3.3	3.4001	3.27	3.3	638716.0
2012-07-06	AAWW-DELISTED	Stock	45.18	45.52	45.0	45.46	137039.0
2012-07-06	AAXJ	Stock	52.54	52.6991	52.25	52.46	169596.0
2012-07-06	AAXN-DELISTED	Stock	5.25	5.2894	5.17	5.22	162653.0
2012-07-06	AB	Stock	12.74	12.85	12.66	12.79	162100.0
2012-07-06	ABAC-DELISTED	Stock	1.17	1.21	1.17	1.18	3250.0
2012-07-06	ABAX-DELISTED	Stock	38.62	38.9999	38.37	38.57	102550.0
2012-07-06	ABB-DELISTED	Stock	16.17	16.2	16.02	16.11	1680903.0
2012-07-06	ABBNY-DELISTED	Stock	16.17	16.2	16.02	16.11	1723063.0
2012-07-06	ABC-DELISTED	Stock	39.13	39.425	38.69	38.77	1891967.0
2012-07-06	ABCB	Stock	12.38	12.57	12.28	12.48	17200.0
2012-07-06	ABCD-DELISTED	Stock	1.2	1.22	1.12	1.12	36519.0
2012-07-06	ABCO-DELISTED	Stock	50.95	51.45	50.72	50.87	48809.0
2012-07-06	ABCW-DELISTED	Stock	0.53	0.53	0.45	0.45	2871.0
2012-07-06	ABE-DELISTED	Stock	18.94	19.0076	18.93	18.99	4213.0
2012-07-06	ABEO	Stock	762.5	762.5	750.0	750.0	17.0
2012-07-06	ABFS-DELISTED	Stock	12.81	13.02	12.78	12.83	200025.0
2012-07-06	ABG	Stock	25.83	26.07	25.53	25.79	221900.0
2012-07-06	ABM	Stock	19.17	19.52	19.0	19.11	525600.0
2012-07-06	ABMD-DELISTED	Stock	23.39	23.86	23.2201	23.5	232864.0
2012-07-06	ABR	Stock	5.3	5.4	5.3	5.37	9300.0
2012-07-06	ABT	Stock	30.8943	31.0718	30.7936	31.067	44201751.0
2012-07-06	ABTL-DELISTED	Stock	3.9509	4.0522	3.8116	4.0	3875.0
2012-07-06	ABUS	Stock	2.05	2.1	2.05	2.1	400.0
2012-07-06	ABV-DELISTED	Stock	38.29	38.29	37.47	37.79	1603872.0
2012-07-06	ABVA-DELISTED	Stock	4.33	4.3652	4.33	4.34	1196.0
2012-07-06	ABX-DELISTED	Stock	37.37	37.94	36.85	36.87	6872406.0
2012-07-06	ACAD	Stock	1.87	1.89	1.77	1.83	466900.0
2012-07-06	ACAS-DELISTED	Stock	10.1	10.2	10.04	10.07	1869154.0

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

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