PREVIEW / stock_daily / 2012-06-28

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-28.parquet
  size:    197 KB
  rows:    6,154
  symbols: 3,525

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-28	AAPL	Stock	20.4168	20.5	20.2004	20.3232	282836400.0
2012-06-28	MSFT	Stock	29.98	30.05	29.42	29.91	45328400.0
2012-06-28	NVDA	Stock	0.3255	0.333	0.3228	0.331	545896000.0
2012-06-28	AMZN	Stock	11.196	11.231	10.9375	11.0655	59896000.0
2012-06-28	META	Stock	31.96	32.19	30.9	31.36	17713300.0
2012-06-28	TSLA	Stock	2.1267	2.1407	2.0413	2.094	13711500.0
2012-06-28	TLT	Stock	127.3	127.48	126.79	126.85	5257890.0
2012-06-28	ES	Stock	38.0	38.34	37.96	38.34	971300.0
2012-06-28	CL	Stock	50.56	51.0	50.465	50.995	2936000.0
2012-06-28	A	Stock	27.2175	27.2818	26.5951	26.9814	2798097.0
2012-06-28	AABA-DELISTED	Stock	15.41	15.48	15.29	15.44	11650099.0
2012-06-28	AACC-DELISTED	Stock	6.63	6.68	6.401	6.53	59733.0
2012-06-28	AACG	Stock	4.1	4.12	4.1	4.11	2000.0
2012-06-28	AAIC-DELISTED	Stock	21.48	21.499	20.88	21.44	195422.0
2012-06-28	AAME	Stock	2.7	2.75	2.61	2.75	5300.0
2012-06-28	AAMRQ-DELISTED	Stock	0.55	0.578	0.525	0.569	2347914.0
2012-06-28	AAON	Stock	5.4104	5.4844	5.3333	5.3956	227475.0
2012-06-28	AAP	Stock	64.75	65.76	64.66	65.71	1565200.0
2012-06-28	AAT	Stock	23.47	23.68	23.42	23.6	166900.0
2012-06-28	AAU-DELISTED	Stock	2.05	2.0653	1.96	1.98	105071.0
2012-06-28	AAUAF-DELISTED	Stock	2.05	2.0653	1.96	1.99	106117.0
2012-06-28	AAV-DELISTED	Stock	2.89	3.19	2.82	2.83	804441.0
2012-06-28	AAWW-DELISTED	Stock	41.05	41.4	39.98	40.7	145949.0
2012-06-28	AAXJ	Stock	50.71	50.844	50.34	50.75	1205083.0
2012-06-28	AAXN-DELISTED	Stock	5.17	5.21	4.95	4.99	363188.0
2012-06-28	AB	Stock	12.29	12.43	12.11	12.43	152900.0
2012-06-28	ABAC-DELISTED	Stock	1.14	1.19	1.14	1.15	8417.0
2012-06-28	ABAX-DELISTED	Stock	34.94	35.48	34.59	35.47	85773.0
2012-06-28	ABB-DELISTED	Stock	15.43	15.61	15.38	15.595	2478380.0
2012-06-28	ABBNY-DELISTED	Stock	15.43	15.61	15.38	15.59	2601271.0
2012-06-28	ABC-DELISTED	Stock	37.95	38.81	37.5	38.75	2567087.0
2012-06-28	ABCB	Stock	12.12	12.23	11.87	12.23	28200.0
2012-06-28	ABCD-DELISTED	Stock	1.0	1.01	0.95	0.97	125682.0
2012-06-28	ABCO-DELISTED	Stock	48.44	48.71	47.38	48.07	215708.0
2012-06-28	ABCW-DELISTED	Stock	0.44	0.45	0.44	0.45	11251.0
2012-06-28	ABE-DELISTED	Stock	18.0812	18.11	17.97	18.1	5157.0
2012-06-28	ABEO	Stock	875.0	900.0	812.5	837.5	45.0
2012-06-28	ABFS-DELISTED	Stock	11.95	12.17	11.68	12.155	369985.0
2012-06-28	ABG	Stock	22.15	22.52	21.89	22.5	357900.0
2012-06-28	ABM	Stock	19.95	19.95	19.52	19.83	392800.0
2012-06-28	ABMD-DELISTED	Stock	21.67	21.96	21.1897	21.91	442086.0
2012-06-28	ABR	Stock	5.34	5.4	5.17	5.37	60500.0
2012-06-28	ABT	Stock	30.0643	30.1986	29.8004	30.1842	8991872.0
2012-06-28	ABTL-DELISTED	Stock	3.6366	3.7206	3.5814	3.6634	22339.0
2012-06-28	ABUS	Stock	2.05	2.05	1.98	2.05	17200.0
2012-06-28	ABV-DELISTED	Stock	36.43	36.58	36.06	36.33	3537614.0
2012-06-28	ABVT-DELISTED	Stock	83.95	83.96	83.93	83.95	124341.0
2012-06-28	ABX-DELISTED	Stock	36.2	36.3	35.55	36.22	7464874.0
2012-06-28	ACAD	Stock	1.65	1.81	1.62	1.78	1571300.0
2012-06-28	ACAS-DELISTED	Stock	9.75	9.86	9.7001	9.82	2428732.0

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

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