PREVIEW / stock_daily / 2014-10-03

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-03.parquet
  size:    222 KB
  rows:    6,637
  symbols: 3,575

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-10-03	AAPL	Stock	24.86	25.0525	24.76	24.905	173878400.0
2014-10-03	MSFT	Stock	45.98	46.3	45.61	46.09	32453200.0
2014-10-03	NVDA	Stock	0.4575	0.4638	0.4558	0.4558	239140000.0
2014-10-03	AMZN	Stock	16.018	16.258	15.9765	16.137	60748000.0
2014-10-03	GOOGL	Stock	29.205	29.4145	29.175	29.3125	24291860.0
2014-10-03	META	Stock	77.76	78.06	77.26	77.44	23340000.0
2014-10-03	TSLA	Stock	16.8707	17.1	16.7353	17.014	81094500.0
2014-10-03	TLT	Stock	117.0	117.77	116.825	117.7	8561520.0
2014-10-03	ES	Stock	45.1	45.63	44.84	45.55	2112300.0
2014-10-03	CL	Stock	65.21	65.61	64.86	65.46	3793100.0
2014-10-03	A	Stock	40.2217	40.7797	40.1717	40.7082	2205065.0
2014-10-03	AA.B-DELISTED	Stock	48.77	49.39	48.7	49.0	24729.0
2014-10-03	AABA-DELISTED	Stock	40.79	41.69	40.65	41.01	36826664.0
2014-10-03	AAC-DELISTED	Stock	18.2	18.75	18.05	18.75	150558.0
2014-10-03	AACG	Stock	4.27	4.49	4.27	4.46	4700.0
2014-10-03	AAIC-DELISTED	Stock	25.54	25.65	25.38	25.44	288914.0
2014-10-03	AAL	Stock	34.66	36.32	34.61	36.23	15076600.0
2014-10-03	AAMC-DELISTED	Stock	202.0588	205.8588	202.0588	205.8588	6905.0
2014-10-03	AAME	Stock	4.0	4.0	3.87	4.0	2300.0
2014-10-03	AAOI	Stock	15.37	16.14	15.12	15.79	165200.0
2014-10-03	AAON	Stock	11.88	11.9533	11.6067	11.88	350100.0
2014-10-03	AAP	Stock	133.76	135.39	132.21	135.13	806000.0
2014-10-03	AAT	Stock	33.91	34.0	33.37	33.92	125000.0
2014-10-03	AAU-DELISTED	Stock	1.313	1.32	1.2	1.25	220478.0
2014-10-03	AAUAF-DELISTED	Stock	1.2903	1.3	1.2	1.25	225704.0
2014-10-03	AAV-DELISTED	Stock	4.97	5.07	4.86	4.87	232427.0
2014-10-03	AAVL-DELISTED	Stock	34.56	34.98	33.68	33.7	71452.0
2014-10-03	AAWW-DELISTED	Stock	32.3	32.98	32.032	32.455	276563.0
2014-10-03	AAXJ	Stock	60.93	61.19	60.692	61.06	733126.0
2014-10-03	AAXN-DELISTED	Stock	15.39	15.39	14.65	15.07	1713943.0
2014-10-03	AB	Stock	25.64	26.47	25.53	26.06	327300.0
2014-10-03	ABAC-DELISTED	Stock	2.0	2.05	2.0	2.0499	26000.0
2014-10-03	ABAX-DELISTED	Stock	52.05	52.3	50.8	50.95	425516.0
2014-10-03	ABB-DELISTED	Stock	21.57	21.68	21.56	21.62	1856462.0
2014-10-03	ABBNY-DELISTED	Stock	21.57	21.68	21.56	21.63	1968525.0
2014-10-03	ABBV	Stock	57.42	58.78	57.34	58.69	11675600.0
2014-10-03	ABC-DELISTED	Stock	77.11	78.21	77.11	77.895	1354675.0
2014-10-03	ABCB	Stock	22.6	22.6	22.26	22.41	95800.0
2014-10-03	ABCO-DELISTED	Stock	46.43	46.44	45.06	45.39	255689.0
2014-10-03	ABDC-DELISTED	Stock	12.51	13.28	12.51	13.08	82450.0
2014-10-03	ABE-DELISTED	Stock	13.93	13.93	13.86	13.8801	5085.0
2014-10-03	ABEO	Stock	337.5	337.5	337.5	337.5	9.0
2014-10-03	ABEV	Stock	6.31	6.6	6.31	6.56	27384400.0
2014-10-03	ABG	Stock	66.15	68.87	65.52	68.75	646300.0
2014-10-03	ABGB-DELISTED	Stock	23.77	24.31	23.77	24.3	15545.0
2014-10-03	ABM	Stock	25.78	26.05	25.64	25.92	212800.0
2014-10-03	ABMD-DELISTED	Stock	24.59	24.92	24.35	24.71	160626.0
2014-10-03	ABR	Stock	6.64	6.66	6.55	6.59	71200.0
2014-10-03	ABR.A-DELISTED	Stock	24.4	24.56	24.28	24.4705	10527.0
2014-10-03	ABR.B-DELISTED	Stock	24.1411	24.37	24.1411	24.36	1138.0

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

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