PREVIEW / stock_daily / 2012-06-19

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-19.parquet
  size:    200 KB
  rows:    6,194
  symbols: 3,549

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-19	AAPL	Stock	20.8357	21.0714	20.825	20.9789	361404400.0
2012-06-19	MSFT	Stock	30.19	31.11	30.05	30.7	75725800.0
2012-06-19	NVDA	Stock	0.3228	0.3358	0.3213	0.331	960476000.0
2012-06-19	AMZN	Stock	11.163	11.26	11.083	11.2015	54332000.0
2012-06-19	META	Stock	31.54	32.18	30.7	31.91	30849000.0
2012-06-19	TSLA	Stock	2.1347	2.1773	2.1	2.1393	13666500.0
2012-06-19	TLT	Stock	126.275	126.37	125.3282	125.42	8233200.0
2012-06-19	ES	Stock	38.77	38.95	38.48	38.57	1951200.0
2012-06-19	CL	Stock	50.82	50.985	50.505	50.65	3321800.0
2012-06-19	A	Stock	28.9485	29.5565	28.8913	29.4349	4213852.0
2012-06-19	AABA-DELISTED	Stock	15.52	15.68	15.51	15.65	10236360.0
2012-06-19	AACC-DELISTED	Stock	5.92	6.26	5.89	6.26	86721.0
2012-06-19	AACG	Stock	3.55	3.9	3.55	3.75	4000.0
2012-06-19	AAIC-DELISTED	Stock	22.79	23.0	22.73	22.95	141696.0
2012-06-19	AAME	Stock	2.7	2.72	2.6	2.72	9600.0
2012-06-19	AAMRQ-DELISTED	Stock	0.444	0.469	0.441	0.469	4220478.0
2012-06-19	AAON	Stock	5.8993	5.9704	5.8222	5.9319	251438.0
2012-06-19	AAP	Stock	70.78	70.78	68.65	68.86	2496900.0
2012-06-19	AAT	Stock	23.47	23.93	23.4	23.59	156400.0
2012-06-19	AAU-DELISTED	Stock	2.22	2.24	2.205	2.21	35397.0
2012-06-19	AAUAF-DELISTED	Stock	2.25	2.27	2.21	2.21	35103.0
2012-06-19	AAV-DELISTED	Stock	2.86	2.95	2.86	2.9	140882.0
2012-06-19	AAWW-DELISTED	Stock	43.2	45.07	43.2	44.42	202162.0
2012-06-19	AAXJ	Stock	52.87	53.53	52.87	53.19	937696.0
2012-06-19	AAXN-DELISTED	Stock	5.4	5.58	5.37	5.44	390926.0
2012-06-19	AB	Stock	11.83	12.12	11.75	12.03	386700.0
2012-06-19	ABAC-DELISTED	Stock	1.48	1.48	1.21	1.21	116566.0
2012-06-19	ABAX-DELISTED	Stock	34.99	36.29	34.99	35.48	139285.0
2012-06-19	ABB-DELISTED	Stock	16.29	16.62	16.29	16.47	2475297.0
2012-06-19	ABBNY-DELISTED	Stock	16.29	16.62	16.29	16.48	2575467.0
2012-06-19	ABC-DELISTED	Stock	37.86	38.53	37.78	38.05	2124507.0
2012-06-19	ABCB	Stock	11.66	12.13	11.64	11.96	67900.0
2012-06-19	ABCD-DELISTED	Stock	1.13	1.15	1.1	1.1	21589.0
2012-06-19	ABCO-DELISTED	Stock	48.41	50.97	47.95	50.4	423334.0
2012-06-19	ABCW-DELISTED	Stock	0.4016	0.4719	0.4016	0.4518	10560.0
2012-06-19	ABE-DELISTED	Stock	18.28	18.41	18.24	18.38	5615.0
2012-06-19	ABEO	Stock	812.5	875.0	812.5	850.0	9.0
2012-06-19	ABFS-DELISTED	Stock	12.54	12.75	12.46	12.6	390698.0
2012-06-19	ABG	Stock	24.54	25.34	24.39	25.07	248100.0
2012-06-19	ABM	Stock	20.64	21.03	20.59	20.79	181000.0
2012-06-19	ABMD-DELISTED	Stock	21.88	22.39	21.65	21.9	574828.0
2012-06-19	ABR	Stock	5.0	5.15	5.0	5.04	107200.0
2012-06-19	ABT	Stock	30.1266	30.2754	30.1074	30.165	9409962.0
2012-06-19	ABTL-DELISTED	Stock	3.7017	3.8983	3.7012	3.8983	14258.0
2012-06-19	ABUS	Stock	2.07	2.07	1.93	1.99	3700.0
2012-06-19	ABV-DELISTED	Stock	38.15	39.35	38.12	38.89	4269872.0
2012-06-19	ABVA-DELISTED	Stock	4.2	4.2	4.18	4.19	1525.0
2012-06-19	ABVT-DELISTED	Stock	83.87	83.9	83.87	83.87	203531.0
2012-06-19	ABX-DELISTED	Stock	40.28	40.46	39.7	40.27	9129345.0
2012-06-19	ACAD	Stock	1.53	1.6	1.5	1.53	350100.0

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

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