PREVIEW / stock_daily / 2017-12-20

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-20.parquet
  size:    216 KB
  rows:    6,506
  symbols: 2,901

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
2017-12-20	AAPL	Stock	43.7175	43.855	43.3125	43.5875	93902400.0
2017-12-20	MSFT	Stock	86.2	86.3	84.71	85.52	23674900.0
2017-12-20	NVDA	Stock	4.9425	4.9518	4.8638	4.92	288820000.0
2017-12-20	AMZN	Stock	59.525	59.55	58.8	58.881	47424000.0
2017-12-20	GOOGL	Stock	54.046	54.0618	53.43	53.678	28727820.0
2017-12-20	META	Stock	179.81	179.81	177.36	177.89	11860500.0
2017-12-20	TSLA	Stock	22.1793	22.2067	21.6693	21.932	89307000.0
2017-12-20	TLT	Stock	124.31	124.71	123.95	124.14	10005783.0
2017-12-20	ES	Stock	62.69	62.93	62.21	62.22	1012600.0
2017-12-20	CL	Stock	75.29	75.34	74.39	74.52	3770400.0
2017-12-20	A	Stock	67.81	68.14	67.16	67.4	1363000.0
2017-12-20	AA	Stock	48.2	49.67	47.629	49.26	7170900.0
2017-12-20	AAAP-DELISTED	Stock	81.56	81.6	81.56	81.58	476908.0
2017-12-20	AABA-DELISTED	Stock	70.6	71.05	70.17	70.9	11109052.0
2017-12-20	AAC-DELISTED	Stock	8.45	8.6099	8.33	8.47	97754.0
2017-12-20	AACG	Stock	5.07	5.34	5.07	5.18	3000.0
2017-12-20	AAIC-DELISTED	Stock	12.38	12.43	12.31	12.39	360653.0
2017-12-20	AAL	Stock	51.57	52.1	51.17	51.92	5172800.0
2017-12-20	AAM.A-DELISTED	Stock	26.29	26.38	26.2	26.21	22131.0
2017-12-20	AAME	Stock	3.6	3.7	3.43	3.45	3100.0
2017-12-20	AAMI	Stock	16.98	17.05	16.88	16.91	255100.0
2017-12-20	AAOI	Stock	42.41	42.88	40.75	41.3	907000.0
2017-12-20	AAON	Stock	23.6667	24.1	23.5	23.9667	188100.0
2017-12-20	AAP	Stock	100.03	100.91	98.03	98.59	1081700.0
2017-12-20	AAT	Stock	38.01	38.47	37.34	37.98	280700.0
2017-12-20	AAU-DELISTED	Stock	1.0	1.01	0.9833	0.99	342882.0
2017-12-20	AAUAF-DELISTED	Stock	1.0	1.01	0.9833	0.99	366208.0
2017-12-20	AAV-DELISTED	Stock	3.9	4.15	3.875	4.05	714939.0
2017-12-20	AAWW-DELISTED	Stock	59.05	59.75	58.55	59.25	105679.0
2017-12-20	AAXJ	Stock	74.8	74.81	74.55	74.6	882962.0
2017-12-20	AAXN-DELISTED	Stock	26.67	26.67	25.75	25.8	400235.0
2017-12-20	AB	Stock	25.55	25.75	25.35	25.35	219100.0
2017-12-20	ABAC-DELISTED	Stock	3.25	3.25	3.1005	3.1005	300.0
2017-12-20	ABAX-DELISTED	Stock	49.05	49.11	48.85	48.95	41827.0
2017-12-20	ABB-DELISTED	Stock	26.62	26.695	26.53	26.56	1335977.0
2017-12-20	ABBNY-DELISTED	Stock	26.62	26.695	26.53	26.56	1783310.0
2017-12-20	ABBV	Stock	97.86	98.9	97.22	97.41	3411900.0
2017-12-20	ABC-DELISTED	Stock	93.67	94.24	92.96	93.74	1224068.0
2017-12-20	ABCB	Stock	49.55	49.6	48.35	49.0	228000.0
2017-12-20	ABCD-DELISTED	Stock	5.8	5.82	5.66	5.7	48946.0
2017-12-20	ABDC-DELISTED	Stock	8.5	8.52	8.31	8.5	114660.0
2017-12-20	ABE-DELISTED	Stock	14.33	14.33	14.26	14.27	26915.0
2017-12-20	ABEO	Stock	386.25	389.75	370.75	377.5	26196.0
2017-12-20	ABEV	Stock	6.2	6.26	6.19	6.24	9844500.0
2017-12-20	ABG	Stock	65.3	66.0	65.0	65.3	773100.0
2017-12-20	ABIL-DELISTED	Stock	0.4125	0.4125	0.3855	0.395	94962.0
2017-12-20	ABLX-DELISTED	Stock	24.7	24.72	24.28	24.31	86164.0
2017-12-20	ABM	Stock	38.66	38.83	38.28	38.55	717000.0
2017-12-20	ABMD-DELISTED	Stock	193.82	194.865	192.31	193.68	107114.0
2017-12-20	ABR	Stock	8.56	8.7	8.56	8.65	435300.0

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

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