PREVIEW / stock_daily / 2012-07-05

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-05.parquet
  size:    198 KB
  rows:    6,160
  symbols: 3,519

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-05	AAPL	Stock	21.4486	21.9407	21.4161	21.7836	484383200.0
2012-07-05	MSFT	Stock	30.59	30.78	30.38	30.7	28801900.0
2012-07-05	NVDA	Stock	0.3428	0.3442	0.3362	0.3415	280076000.0
2012-07-05	AMZN	Stock	11.431	11.525	11.3265	11.353	53646000.0
2012-07-05	META	Stock	31.32	31.63	31.02	31.47	10032100.0
2012-07-05	TSLA	Stock	2.054	2.1113	2.0533	2.082	18807000.0
2012-07-05	TLT	Stock	125.35	126.32	125.25	125.89	5977153.0
2012-07-05	ES	Stock	39.15	39.27	38.69	38.76	1458100.0
2012-07-05	CL	Stock	52.21	52.5	51.96	52.325	2461200.0
2012-07-05	A	Stock	28.083	28.4979	27.897	28.1617	2244489.0
2012-07-05	AABA-DELISTED	Stock	15.9	15.99	15.81	15.83	11285333.0
2012-07-05	AACC-DELISTED	Stock	7.47	8.16	7.45	7.88	152889.0
2012-07-05	AACG	Stock	4.26	4.36	4.19	4.2	5600.0
2012-07-05	AAIC-DELISTED	Stock	22.6	22.77	22.31	22.38	58657.0
2012-07-05	AAME	Stock	2.63	2.76	2.61	2.72	3000.0
2012-07-05	AAMRQ-DELISTED	Stock	0.54	0.543	0.485	0.49	1182878.0
2012-07-05	AAON	Stock	5.5378	5.8637	5.5378	5.843	99900.0
2012-07-05	AAP	Stock	68.94	70.29	68.73	68.8	1246700.0
2012-07-05	AAT	Stock	24.84	24.97	24.69	24.8	48900.0
2012-07-05	AAU-DELISTED	Stock	2.17	2.25	2.1	2.14	105928.0
2012-07-05	AAUAF-DELISTED	Stock	2.17	2.25	2.1	2.14	106128.0
2012-07-05	AAV-DELISTED	Stock	3.16	3.34	3.09	3.32	545162.0
2012-07-05	AAWW-DELISTED	Stock	45.55	46.55	45.27	45.82	186492.0
2012-07-05	AAXJ	Stock	53.36	53.49	53.04	53.25	335954.0
2012-07-05	AAXN-DELISTED	Stock	5.29	5.34	5.22	5.33	147235.0
2012-07-05	AB	Stock	12.76	12.85	12.68	12.83	224900.0
2012-07-05	ABAC-DELISTED	Stock	1.19	1.22	1.17	1.181	4800.0
2012-07-05	ABAX-DELISTED	Stock	39.4	39.635	38.91	39.1	114687.0
2012-07-05	ABB-DELISTED	Stock	16.39	16.459	16.3	16.34	2604997.0
2012-07-05	ABBNY-DELISTED	Stock	16.39	16.459	16.3	16.32	2677083.0
2012-07-05	ABC-DELISTED	Stock	39.55	39.75	39.31	39.5	1214972.0
2012-07-05	ABCB	Stock	12.57	12.74	12.49	12.53	18500.0
2012-07-05	ABCD-DELISTED	Stock	0.98	1.3	0.96	1.29	140422.0
2012-07-05	ABCO-DELISTED	Stock	51.2	51.93	50.59	51.48	177791.0
2012-07-05	ABCW-DELISTED	Stock	0.42	0.53	0.42	0.52	8295.0
2012-07-05	ABE-DELISTED	Stock	19.0	19.23	18.9864	19.23	1693.0
2012-07-05	ABEO	Stock	750.0	812.5	737.5	812.5	3.0
2012-07-05	ABFS-DELISTED	Stock	12.2	12.95	12.19	12.91	240952.0
2012-07-05	ABG	Stock	25.46	26.44	25.45	26.18	480800.0
2012-07-05	ABM	Stock	19.41	19.57	19.32	19.4	497300.0
2012-07-05	ABMD-DELISTED	Stock	23.38	23.85	23.26	23.74	246623.0
2012-07-05	ABR	Stock	5.4	5.42	5.38	5.39	23100.0
2012-07-05	ABT	Stock	31.067	31.163	30.8943	31.067	41698416.0
2012-07-05	ABTL-DELISTED	Stock	3.85	4.0	3.7	4.0	26619.0
2012-07-05	ABUS	Stock	2.04	2.14	2.04	2.14	1700.0
2012-07-05	ABV-DELISTED	Stock	38.69	38.78	37.84	38.45	1839382.0
2012-07-05	ABVA-DELISTED	Stock	4.66	4.66	4.66	4.66	100.0
2012-07-05	ABX-DELISTED	Stock	38.27	38.41	37.88	38.08	8739947.0
2012-07-05	ACAD	Stock	1.87	1.92	1.85	1.87	454200.0
2012-07-05	ACAS-DELISTED	Stock	10.17	10.3	10.14	10.17	2392764.0

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

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