PREVIEW / stock_daily / 2017-12-06

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-06.parquet
  size:    217 KB
  rows:    6,498
  symbols: 2,910

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-06	AAPL	Stock	41.875	42.55	41.615	42.2525	114240000.0
2017-12-06	MSFT	Stock	81.55	83.14	81.43	82.78	26162100.0
2017-12-06	NVDA	Stock	4.6425	4.7535	4.621	4.7315	467032000.0
2017-12-06	AMZN	Stock	56.8995	57.7945	56.804	57.6175	57066000.0
2017-12-06	GOOGL	Stock	50.826	51.979	50.7655	51.636	28710980.0
2017-12-06	META	Stock	172.5	176.77	171.9	176.06	20255800.0
2017-12-06	TSLA	Stock	20.0067	20.8927	20.0	20.884	107929500.0
2017-12-06	TLT	Stock	127.87	128.23	127.655	127.68	11834449.0
2017-12-06	ES	Stock	64.97	65.35	64.84	65.11	1596500.0
2017-12-06	CL	Stock	74.36	74.75	74.12	74.25	2698300.0
2017-12-06	A	Stock	65.88	66.25	65.6	65.89	1690100.0
2017-12-06	AA	Stock	40.8	41.49	40.3	41.31	5437800.0
2017-12-06	AAAP-DELISTED	Stock	81.4	81.5	81.36	81.5	784061.0
2017-12-06	AABA-DELISTED	Stock	67.46	69.62	67.36	69.41	9803152.0
2017-12-06	AAC-DELISTED	Stock	8.44	8.59	8.26	8.5	141220.0
2017-12-06	AACG	Stock	5.16	5.16	5.12	5.14	19300.0
2017-12-06	AAIC-DELISTED	Stock	11.88	12.0	11.88	11.96	280987.0
2017-12-06	AAL	Stock	49.39	49.81	49.19	49.61	2835500.0
2017-12-06	AAM.A-DELISTED	Stock	26.21	26.21	26.02	26.14	19306.0
2017-12-06	AAMC-DELISTED	Stock	20.6324	21.2353	20.6324	21.2353	4855.0
2017-12-06	AAME	Stock	3.63	3.63	3.63	3.63	35700.0
2017-12-06	AAMI	Stock	16.05	16.17	15.93	15.95	484200.0
2017-12-06	AAOI	Stock	41.99	42.379	40.67	40.74	1071100.0
2017-12-06	AAON	Stock	24.9667	25.2333	24.0867	24.2	312600.0
2017-12-06	AAP	Stock	100.87	101.42	97.47	97.5	1285800.0
2017-12-06	AAT	Stock	38.59	38.81	38.18	38.37	195900.0
2017-12-06	AAU-DELISTED	Stock	0.84	0.85	0.815	0.83	297240.0
2017-12-06	AAUAF-DELISTED	Stock	0.84	0.85	0.815	0.83	304344.0
2017-12-06	AAV-DELISTED	Stock	4.7	4.7	4.2	4.2	373328.0
2017-12-06	AAWW-DELISTED	Stock	56.75	57.35	55.9	56.45	100450.0
2017-12-06	AAXJ	Stock	73.8	74.035	73.56	73.86	2058666.0
2017-12-06	AAXN-DELISTED	Stock	24.09	24.28	23.85	23.99	463262.0
2017-12-06	AB	Stock	25.2	25.75	25.2	25.65	231600.0
2017-12-06	ABAC-DELISTED	Stock	2.84	2.84	2.78	2.84	6905.0
2017-12-06	ABAX-DELISTED	Stock	47.09	48.75	47.09	48.24	92198.0
2017-12-06	ABB-DELISTED	Stock	25.57	25.72	25.55	25.65	1074316.0
2017-12-06	ABBNY-DELISTED	Stock	25.57	25.72	25.55	25.65	1152817.0
2017-12-06	ABBV	Stock	95.7	95.79	93.47	94.4	5114200.0
2017-12-06	ABC-DELISTED	Stock	86.2	86.79	85.37	85.99	1116909.0
2017-12-06	ABCB	Stock	49.2	49.3	48.3	48.4	151000.0
2017-12-06	ABCD-DELISTED	Stock	5.68	5.87	5.66	5.75	42072.0
2017-12-06	ABDC-DELISTED	Stock	8.34	8.37	8.28	8.32	52475.0
2017-12-06	ABE-DELISTED	Stock	14.12	14.12	13.97	14.06	10920.0
2017-12-06	ABEO	Stock	388.75	393.5	367.5	370.0	25004.0
2017-12-06	ABEOW-DELISTED	Stock	10.44	10.449	10.2618	10.2618	500.0
2017-12-06	ABEV	Stock	6.33	6.38	6.25	6.34	13259100.0
2017-12-06	ABG	Stock	67.65	67.65	66.0	66.2	86400.0
2017-12-06	ABIL-DELISTED	Stock	0.47	0.49	0.4609	0.4893	53259.0
2017-12-06	ABLX-DELISTED	Stock	22.63	22.77	22.431	22.62	90461.0
2017-12-06	ABM	Stock	43.49	43.9	42.95	43.54	196500.0

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

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