PREVIEW / stock_daily / 2014-01-22

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-22.parquet
  size:    217 KB
  rows:    6,470
  symbols: 3,541

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-01-22	AAPL	Stock	19.6754	19.9032	19.5646	19.6968	379985200.0
2014-01-22	MSFT	Stock	36.26	36.32	35.75	35.93	21904300.0
2014-01-22	NVDA	Stock	0.402	0.4025	0.396	0.4008	337940000.0
2014-01-22	AMZN	Stock	20.4	20.403	20.1	20.227	41210000.0
2014-01-22	META	Stock	58.85	59.31	57.1	57.51	61352900.0
2014-01-22	TSLA	Stock	11.854	12.0213	11.6507	11.904	105339000.0
2014-01-22	TLT	Stock	105.37	105.75	105.24	105.3	4646691.0
2014-01-22	ES	Stock	43.02	43.53	42.99	43.34	2064200.0
2014-01-22	CL	Stock	64.54	64.7	63.87	64.01	2323200.0
2014-01-22	A	Stock	43.505	43.7911	43.4263	43.5837	3871621.0
2014-01-22	AABA-DELISTED	Stock	39.66	40.4	39.32	40.18	12045567.0
2014-01-22	AACG	Stock	3.96	4.08	3.96	4.0	34300.0
2014-01-22	AAIC-DELISTED	Stock	26.65	26.69	26.53	26.59	96561.0
2014-01-22	AAL	Stock	30.71	31.24	30.65	31.2	7578800.0
2014-01-22	AAMC-DELISTED	Stock	346.1765	347.0588	338.2353	338.5971	24732.0
2014-01-22	AAME	Stock	4.01	4.07	4.0	4.0	21600.0
2014-01-22	AAOI	Stock	14.11	14.33	13.92	14.15	41600.0
2014-01-22	AAON	Stock	14.8578	15.2311	14.6933	15.2133	223425.0
2014-01-22	AAP	Stock	118.39	118.71	116.75	117.75	502000.0
2014-01-22	AAT	Stock	32.26	32.45	32.01	32.1	86100.0
2014-01-22	AAU-DELISTED	Stock	1.53	1.56	1.53	1.53	116872.0
2014-01-22	AAUAF-DELISTED	Stock	1.53	1.56	1.53	1.53	117979.0
2014-01-22	AAV-DELISTED	Stock	4.31	4.41	4.27	4.28	107128.0
2014-01-22	AAWW-DELISTED	Stock	39.26	39.88	39.0203	39.43	543775.0
2014-01-22	AAXJ	Stock	58.35	58.67	58.2	58.66	340132.0
2014-01-22	AAXN-DELISTED	Stock	17.86	18.1199	17.35	18.0	1021667.0
2014-01-22	AB	Stock	22.78	23.07	22.71	22.98	170900.0
2014-01-22	ABAC-DELISTED	Stock	2.03	2.09	2.02	2.07	36487.0
2014-01-22	ABAX-DELISTED	Stock	45.15	45.48	43.97	44.09	207344.0
2014-01-22	ABB-DELISTED	Stock	25.57	25.89	25.53	25.6	2688825.0
2014-01-22	ABBNY-DELISTED	Stock	25.57	25.89	25.53	25.59	2764252.0
2014-01-22	ABBV	Stock	49.98	50.0	48.62	49.08	8181700.0
2014-01-22	ABC-DELISTED	Stock	70.8	70.87	69.8	70.28	1604543.0
2014-01-22	ABCB	Stock	21.09	21.2	20.71	20.81	86900.0
2014-01-22	ABCD-DELISTED	Stock	2.0	2.15	1.92	2.0	22107.0
2014-01-22	ABCO-DELISTED	Stock	63.51	63.59	62.0	63.52	172339.0
2014-01-22	ABE-DELISTED	Stock	13.12	13.132	13.07	13.1	3474.0
2014-01-22	ABEO	Stock	450.0	475.0	425.0	462.5	63.0
2014-01-22	ABEV	Stock	7.18	7.22	7.13	7.18	10856200.0
2014-01-22	ABFS-DELISTED	Stock	35.38	35.74	35.12	35.62	173783.0
2014-01-22	ABG	Stock	49.22	50.17	48.72	49.92	429800.0
2014-01-22	ABGB-DELISTED	Stock	17.26	17.41	17.1785	17.41	6425.0
2014-01-22	ABM	Stock	27.98	28.24	27.81	28.21	143200.0
2014-01-22	ABMD-DELISTED	Stock	27.8	27.89	27.52	27.56	177101.0
2014-01-22	ABR	Stock	6.88	7.0	6.86	6.89	114400.0
2014-01-22	ABR.A-DELISTED	Stock	24.97	24.97	24.97	24.97	300.0
2014-01-22	ABR.B-DELISTED	Stock	22.9199	22.9199	22.9199	22.9199	1000.0
2014-01-22	ABT	Stock	38.02	38.87	36.94	38.07	12970000.0
2014-01-22	ABTL-DELISTED	Stock	17.74	18.46	17.46	17.95	302436.0
2014-01-22	ABUS	Stock	12.4	12.44	12.1	12.43	153600.0

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

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