PREVIEW / stock_daily / 2012-06-14

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-14.parquet
  size:    198 KB
  rows:    6,152
  symbols: 3,526

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-14	AAPL	Stock	20.4014	20.4821	20.2593	20.4118	345573200.0
2012-06-14	MSFT	Stock	29.33	29.46	28.88	29.34	39458900.0
2012-06-14	NVDA	Stock	0.304	0.3065	0.2978	0.3008	589884000.0
2012-06-14	AMZN	Stock	10.763	10.825	10.628	10.7225	61218000.0
2012-06-14	META	Stock	27.65	28.32	27.38	28.29	16855000.0
2012-06-14	TSLA	Stock	2.012	2.0433	1.908	1.9593	13083000.0
2012-06-14	TLT	Stock	125.95	126.28	125.19	125.7	7688149.0
2012-06-14	ES	Stock	37.52	38.22	37.52	38.1	1657000.0
2012-06-14	CL	Stock	50.235	50.725	50.135	50.66	3255200.0
2012-06-14	A	Stock	27.9614	28.3691	27.804	28.1474	3236230.0
2012-06-14	AABA-DELISTED	Stock	15.3	15.46	15.25	15.36	11483457.0
2012-06-14	AACC-DELISTED	Stock	5.82	5.925	5.711	5.75	47670.0
2012-06-14	AACG	Stock	4.83	5.07	4.1	4.35	22700.0
2012-06-14	AAIC-DELISTED	Stock	22.63	22.75	22.51	22.55	57383.0
2012-06-14	AAME	Stock	2.72	2.72	2.6	2.72	3800.0
2012-06-14	AAMRQ-DELISTED	Stock	0.458	0.474	0.458	0.46	574035.0
2012-06-14	AAON	Stock	5.6237	5.7985	5.6119	5.7896	98550.0
2012-06-14	AAP	Stock	70.82	72.68	70.23	70.66	1498700.0
2012-06-14	AAT	Stock	22.73	23.37	22.73	23.1	250400.0
2012-06-14	AAU-DELISTED	Stock	2.2	2.33	2.2	2.26	127699.0
2012-06-14	AAUAF-DELISTED	Stock	2.2	2.33	2.2	2.24	127999.0
2012-06-14	AAV-DELISTED	Stock	2.64	2.84	2.63	2.78	335906.0
2012-06-14	AAWW-DELISTED	Stock	42.98	43.54	42.03	42.94	164905.0
2012-06-14	AAXJ	Stock	51.16	51.73	51.02	51.55	202830.0
2012-06-14	AAXN-DELISTED	Stock	5.19	5.28	5.09	5.17	403234.0
2012-06-14	AB	Stock	11.92	11.97	11.74	11.81	360400.0
2012-06-14	ABAC-DELISTED	Stock	1.44	1.464	1.4	1.4	5650.0
2012-06-14	ABAX-DELISTED	Stock	33.78	34.48	33.45	34.25	101325.0
2012-06-14	ABB-DELISTED	Stock	15.92	16.14	15.91	16.05	3237101.0
2012-06-14	ABBNY-DELISTED	Stock	15.92	16.14	15.91	16.06	3244448.0
2012-06-14	ABC-DELISTED	Stock	36.76	37.12	36.68	36.97	1570658.0
2012-06-14	ABCB	Stock	11.7	11.81	11.69	11.78	80600.0
2012-06-14	ABCD-DELISTED	Stock	1.15	1.15	1.03	1.14	58061.0
2012-06-14	ABCO-DELISTED	Stock	47.35	48.17	47.32	48.12	222894.0
2012-06-14	ABCW-DELISTED	Stock	0.4418	0.4619	0.4117	0.4619	8750.0
2012-06-14	ABE-DELISTED	Stock	18.05	18.05	17.85	17.9	33825.0
2012-06-14	ABEO	Stock	875.0	950.0	875.0	950.0	4.0
2012-06-14	ABFS-DELISTED	Stock	10.6	11.81	10.38	11.62	1338425.0
2012-06-14	ABG	Stock	23.67	24.44	23.56	24.35	333500.0
2012-06-14	ABM	Stock	20.43	20.89	20.34	20.81	292500.0
2012-06-14	ABMD-DELISTED	Stock	21.0	21.89	21.0	21.42	469104.0
2012-06-14	ABR	Stock	5.25	5.27	5.25	5.25	126700.0
2012-06-14	ABT	Stock	29.5509	29.8819	29.4501	29.8148	12803668.0
2012-06-14	ABTL-DELISTED	Stock	3.85	3.9	3.7075	3.9	9060.0
2012-06-14	ABUS	Stock	2.12	2.12	2.12	2.12	100.0
2012-06-14	ABV-DELISTED	Stock	36.32	37.08	36.19	36.85	2363280.0
2012-06-14	ABVA-DELISTED	Stock	4.22	4.35	4.2001	4.2001	1600.0
2012-06-14	ABVT-DELISTED	Stock	83.75	83.8	83.71	83.78	86029.0
2012-06-14	ABX-DELISTED	Stock	38.89	39.04	38.11	38.97	9406123.0
2012-06-14	ACAD	Stock	1.36	1.41	1.36	1.39	146600.0

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

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