PREVIEW / stock_daily / 2014-07-23

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-23.parquet
  size:    220 KB
  rows:    6,583
  symbols: 3,560

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
2014-07-23	AAPL	Stock	23.855	24.47	23.7925	24.2975	371672000.0
2014-07-23	MSFT	Stock	45.45	45.45	44.62	44.87	52362900.0
2014-07-23	NVDA	Stock	0.462	0.4622	0.4515	0.452	297352000.0
2014-07-23	AMZN	Stock	17.9525	18.0315	17.831	17.907	53746000.0
2014-07-23	GOOGL	Stock	30.1025	30.3525	30.0675	30.2595	22122720.0
2014-07-23	META	Stock	69.74	71.33	69.61	71.29	78435000.0
2014-07-23	TSLA	Stock	14.6673	14.9833	14.6287	14.8327	46249500.0
2014-07-23	TLT	Stock	115.51	115.63	115.17	115.18	3490746.0
2014-07-23	ES	Stock	45.58	45.58	45.22	45.36	896000.0
2014-07-23	CL	Stock	68.6	68.69	67.97	68.17	1919700.0
2014-07-23	A	Stock	41.5665	41.7096	41.0944	41.1087	2032133.0
2014-07-23	AABA-DELISTED	Stock	33.78	34.92	33.68	34.71	37234789.0
2014-07-23	AACG	Stock	4.35	4.6	4.3	4.35	5900.0
2014-07-23	AAIC-DELISTED	Stock	26.9	26.9	26.68	26.75	115267.0
2014-07-23	AAL	Stock	42.72	43.66	42.65	43.33	10166700.0
2014-07-23	AAMC-DELISTED	Stock	205.8824	208.2706	200.0	205.8824	63685.0
2014-07-23	AAME	Stock	3.89	4.05	3.8	3.85	39800.0
2014-07-23	AAOI	Stock	22.71	23.08	21.01	21.35	206700.0
2014-07-23	AAON	Stock	14.5667	14.7333	14.0733	14.1133	121500.0
2014-07-23	AAP	Stock	124.68	124.93	123.25	123.59	653700.0
2014-07-23	AAT	Stock	35.68	35.77	35.38	35.58	89000.0
2014-07-23	AAU-DELISTED	Stock	1.43	1.45	1.4	1.42	93222.0
2014-07-23	AAUAF-DELISTED	Stock	1.4	1.42	1.38	1.42	96106.0
2014-07-23	AAV-DELISTED	Stock	5.42	5.65	5.4	5.56	662578.0
2014-07-23	AAWW-DELISTED	Stock	36.11	36.43	35.71	35.92	145766.0
2014-07-23	AAXJ	Stock	65.04	65.08	64.86	64.9	213693.0
2014-07-23	AAXN-DELISTED	Stock	11.57	11.57	11.22	11.23	485236.0
2014-07-23	AB	Stock	27.59	27.64	26.76	27.3	186300.0
2014-07-23	ABAC-DELISTED	Stock	2.04	2.06	1.95	2.01	83917.0
2014-07-23	ABAX-DELISTED	Stock	42.18	42.39	41.91	42.12	159691.0
2014-07-23	ABB-DELISTED	Stock	23.46	23.84	23.39	23.79	3977811.0
2014-07-23	ABBNY-DELISTED	Stock	23.46	23.84	23.39	23.79	4451633.0
2014-07-23	ABBV	Stock	54.48	54.81	54.07	54.48	15011300.0
2014-07-23	ABC-DELISTED	Stock	73.74	74.28	73.62	74.05	1688895.0
2014-07-23	ABCB	Stock	21.37	21.98	21.25	21.32	33500.0
2014-07-23	ABCD-DELISTED	Stock	1.84	1.96	1.83	1.95	135756.0
2014-07-23	ABCO-DELISTED	Stock	50.27	50.8	49.83	50.13	70323.0
2014-07-23	ABDC-DELISTED	Stock	13.55	14.0	13.55	13.95	44653.0
2014-07-23	ABE-DELISTED	Stock	14.75	14.75	14.7	14.73	6813.0
2014-07-23	ABEO	Stock	375.0	375.0	350.0	375.0	44.0
2014-07-23	ABEV	Stock	7.44	7.47	7.35	7.4	13794800.0
2014-07-23	ABG	Stock	71.33	71.52	70.04	70.34	215200.0
2014-07-23	ABGB-DELISTED	Stock	26.5	26.5	26.0151	26.12	9926.0
2014-07-23	ABIL-DELISTED	Stock	9.77	9.79	9.77	9.79	200.0
2014-07-23	ABM	Stock	25.63	25.74	25.43	25.56	103200.0
2014-07-23	ABMD-DELISTED	Stock	25.76	25.96	25.58	25.8	168694.0
2014-07-23	ABR	Stock	7.3	7.3	7.2	7.24	134300.0
2014-07-23	ABR.A-DELISTED	Stock	24.95	25.01	24.94	24.99	7501.0
2014-07-23	ABR.B-DELISTED	Stock	24.5	24.63	24.5	24.6	36222.0
2014-07-23	ABR.C-DELISTED	Stock	25.37	25.3718	25.37	25.3701	800.0

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

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