PREVIEW / stock_daily / 2012-06-22

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-22.parquet
  size:    201 KB
  rows:    6,182
  symbols: 3,542

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-06-22	AAPL	Stock	20.68	20.7925	20.5507	20.7893	284471600.0
2012-06-22	MSFT	Stock	30.3	30.73	30.03	30.7	45098100.0
2012-06-22	NVDA	Stock	0.325	0.3288	0.3205	0.325	865360000.0
2012-06-22	AMZN	Stock	11.0915	11.1255	10.9675	11.108	43750000.0
2012-06-22	META	Stock	32.41	33.45	32.06	33.05	74834000.0
2012-06-22	TSLA	Stock	2.1733	2.2653	2.164	2.2527	45699000.0
2012-06-22	TLT	Stock	125.9	126.22	125.01	125.02	7830552.0
2012-06-22	ES	Stock	37.71	37.92	37.48	37.76	2600800.0
2012-06-22	CL	Stock	49.96	50.25	49.9	49.95	6369000.0
2012-06-22	A	Stock	28.2403	28.3047	27.4464	27.9185	5137650.0
2012-06-22	AABA-DELISTED	Stock	15.53	15.7	15.52	15.6	10915487.0
2012-06-22	AACC-DELISTED	Stock	6.18	6.42	5.75	5.92	2072599.0
2012-06-22	AACG	Stock	3.9	4.39	3.76	4.16	93300.0
2012-06-22	AAIC-DELISTED	Stock	23.0	23.0	22.74	22.91	204877.0
2012-06-22	AAME	Stock	2.7	2.72	2.55	2.71	8800.0
2012-06-22	AAMRQ-DELISTED	Stock	0.51	0.524	0.501	0.51	1201175.0
2012-06-22	AAON	Stock	5.6533	5.6622	5.5793	5.6059	227475.0
2012-06-22	AAP	Stock	67.59	68.41	67.29	67.93	1240900.0
2012-06-22	AAT	Stock	23.47	23.47	22.85	22.91	1331300.0
2012-06-22	AAU-DELISTED	Stock	2.09	2.17	2.0689	2.15	105637.0
2012-06-22	AAUAF-DELISTED	Stock	2.06	2.15	2.04	2.15	108231.0
2012-06-22	AAV-DELISTED	Stock	2.66	2.68	2.5909	2.64	151655.0
2012-06-22	AAWW-DELISTED	Stock	43.66	44.06	43.17	44.02	213560.0
2012-06-22	AAXJ	Stock	51.36	51.36	50.8709	51.23	708525.0
2012-06-22	AAXN-DELISTED	Stock	5.31	5.34	5.22	5.29	323715.0
2012-06-22	AB	Stock	12.25	12.25	11.99	12.13	138500.0
2012-06-22	ABAC-DELISTED	Stock	1.2	1.233	1.05	1.15	35793.0
2012-06-22	ABAX-DELISTED	Stock	35.23	36.15	34.94	36.03	179129.0
2012-06-22	ABB-DELISTED	Stock	16.19	16.2	15.81	15.83	5110594.0
2012-06-22	ABBNY-DELISTED	Stock	16.19	16.2	15.81	15.81	5232258.0
2012-06-22	ABC-DELISTED	Stock	37.91	38.07	37.58	37.94	1684674.0
2012-06-22	ABCB	Stock	11.76	12.07	11.74	11.87	183800.0
2012-06-22	ABCD-DELISTED	Stock	1.0	1.08	0.99	1.04	1876151.0
2012-06-22	ABCO-DELISTED	Stock	48.63	49.25	48.63	49.07	442223.0
2012-06-22	ABCW-DELISTED	Stock	0.4619	0.4669	0.4518	0.4518	26130.0
2012-06-22	ABE-DELISTED	Stock	18.1576	18.1576	18.1576	18.1576	500.0
2012-06-22	ABEO	Stock	812.5	837.5	775.0	837.5	23.0
2012-06-22	ABFS-DELISTED	Stock	12.47	12.56	12.3	12.52	589277.0
2012-06-22	ABG	Stock	23.93	24.11	23.42	23.86	961700.0
2012-06-22	ABM	Stock	20.61	20.61	20.28	20.47	962400.0
2012-06-22	ABMD-DELISTED	Stock	21.37	21.59	20.91	21.21	575024.0
2012-06-22	ABR	Stock	5.06	5.34	5.06	5.13	173100.0
2012-06-22	ABT	Stock	29.8819	30.1027	29.8004	29.9011	14003126.0
2012-06-22	ABTL-DELISTED	Stock	3.5085	3.6003	3.4304	3.55	61997.0
2012-06-22	ABUS	Stock	2.0	2.08	2.0	2.08	1400.0
2012-06-22	ABV-DELISTED	Stock	37.47	37.66	36.32	36.57	4432636.0
2012-06-22	ABVA-DELISTED	Stock	4.18	4.27	4.18	4.27	730.0
2012-06-22	ABVT-DELISTED	Stock	83.91	83.95	83.9	83.95	151166.0
2012-06-22	ABX-DELISTED	Stock	38.45	38.9	37.46	37.92	8384251.0
2012-06-22	ACAD	Stock	1.53	1.57	1.48	1.5	394800.0

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

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