PREVIEW / stock_daily / 2012-08-13

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-13.parquet
  size:    197 KB
  rows:    6,126
  symbols: 3,485

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-08-13	AAPL	Stock	22.2639	22.5	22.2589	22.5	278832400.0
2012-08-13	MSFT	Stock	30.35	30.46	30.16	30.39	23049100.0
2012-08-13	NVDA	Stock	0.366	0.3705	0.3645	0.3703	447244000.0
2012-08-13	AMZN	Stock	11.6115	11.7185	11.55	11.622	39946000.0
2012-08-13	META	Stock	22.15	22.45	21.4	21.6	24973100.0
2012-08-13	TSLA	Stock	1.9793	2.0867	1.94	2.078	13051500.0
2012-08-13	TLT	Stock	126.11	126.38	125.49	125.49	3547652.0
2012-08-13	ES	Stock	39.44	39.61	39.11	39.29	933600.0
2012-08-13	CL	Stock	52.5	52.83	52.39	52.775	2173000.0
2012-08-13	A	Stock	28.8054	29.113	28.7196	28.8841	2601398.0
2012-08-13	AABA-DELISTED	Stock	15.04	15.21	15.0	15.02	20514638.0
2012-08-13	AACC-DELISTED	Stock	5.86	5.93	5.7	5.7	59808.0
2012-08-13	AACG	Stock	4.74	4.75	4.51	4.75	6800.0
2012-08-13	AAIC-DELISTED	Stock	22.93	23.0	22.7	23.0	50407.0
2012-08-13	AAME	Stock	2.56	2.7	2.56	2.7	6200.0
2012-08-13	AAMRQ-DELISTED	Stock	0.4955	0.528	0.49	0.5	2168614.0
2012-08-13	AAON	Stock	5.7452	5.7452	5.52	5.6089	93825.0
2012-08-13	AAP	Stock	68.51	69.32	68.51	69.11	1063600.0
2012-08-13	AAT	Stock	26.0	26.28	25.67	26.12	101700.0
2012-08-13	AAU-DELISTED	Stock	2.13	2.14	2.04	2.12	70543.0
2012-08-13	AAUAF-DELISTED	Stock	2.13	2.14	2.04	2.12	72243.0
2012-08-13	AAV-DELISTED	Stock	3.22	3.27	3.16	3.25	130831.0
2012-08-13	AAWW-DELISTED	Stock	51.53	51.72	50.29	51.02	351879.0
2012-08-13	AAXJ	Stock	54.17	54.37	53.95	54.19	175928.0
2012-08-13	AAXN-DELISTED	Stock	5.56	5.5898	5.39	5.55	311947.0
2012-08-13	AB	Stock	13.02	13.07	12.72	12.93	214200.0
2012-08-13	ABAC-DELISTED	Stock	1.0	1.0	0.9201	0.95	11700.0
2012-08-13	ABAX-DELISTED	Stock	37.07	37.79	37.0	37.6	110034.0
2012-08-13	ABB-DELISTED	Stock	17.83	17.97	17.768	17.83	1696477.0
2012-08-13	ABBNY-DELISTED	Stock	17.84	17.97	17.768	17.84	1735530.0
2012-08-13	ABC-DELISTED	Stock	38.59	38.69	38.145	38.59	1596798.0
2012-08-13	ABCB	Stock	11.38	11.58	11.25	11.47	98300.0
2012-08-13	ABCD-DELISTED	Stock	0.9305	0.95	0.84	0.94	49891.0
2012-08-13	ABCO-DELISTED	Stock	42.22	42.76	41.71	42.36	227979.0
2012-08-13	ABCW-DELISTED	Stock	0.39	0.435	0.39	0.425	1810.0
2012-08-13	ABE-DELISTED	Stock	19.31	19.4	19.25	19.4	7682.0
2012-08-13	ABEO	Stock	575.0	575.0	562.5	575.0	10.0
2012-08-13	ABFS-DELISTED	Stock	10.41	10.52	10.014	10.38	252928.0
2012-08-13	ABG	Stock	26.53	26.82	25.95	26.82	227600.0
2012-08-13	ABM	Stock	19.02	19.02	18.54	19.01	289400.0
2012-08-13	ABMD-DELISTED	Stock	21.32	21.39	20.19	20.26	1030425.0
2012-08-13	ABR	Stock	5.57	5.78	5.57	5.71	41200.0
2012-08-13	ABT	Stock	31.5996	31.6812	31.5133	31.662	5512922.0
2012-08-13	ABTL-DELISTED	Stock	3.55	3.67	3.55	3.6099	2771.0
2012-08-13	ABUS	Stock	3.85	3.85	3.74	3.8	7800.0
2012-08-13	ABV-DELISTED	Stock	38.21	38.26	37.595	37.971	1252403.0
2012-08-13	ABVA-DELISTED	Stock	4.45	4.45	4.42	4.42	3800.0
2012-08-13	ABX-DELISTED	Stock	34.83	35.16	34.1	34.22	6374403.0
2012-08-13	ACAD	Stock	1.6	1.73	1.6	1.71	716500.0
2012-08-13	ACAS-DELISTED	Stock	10.86	10.97	10.85	10.93	3141644.0

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

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