PREVIEW / stock_daily / 2019-02-04

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-04.parquet
  size:    219 KB
  rows:    6,510
  symbols: 2,615

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
2019-02-04	AAPL	Stock	41.8525	42.915	41.82	42.8125	125982000.0
2019-02-04	MSFT	Stock	102.87	105.8	102.77	105.74	31315100.0
2019-02-04	NVDA	Stock	3.6342	3.767	3.612	3.7295	528592000.0
2019-02-04	AMZN	Stock	81.15	82.4815	80.675	81.6655	98582000.0
2019-02-04	GOOGL	Stock	55.9505	57.117	55.8755	57.071	78411820.0
2019-02-04	META	Stock	165.7	169.3	163.62	169.25	20036000.0
2019-02-04	TSLA	Stock	20.8653	21.02	20.1253	20.8593	110281500.0
2019-02-04	TLT	Stock	120.44	120.55	120.02	120.42	8966375.0
2019-02-04	ES	Stock	68.64	69.02	68.04	69.02	1790300.0
2019-02-04	CL	Stock	65.29	65.43	64.61	65.19	3612600.0
2019-02-04	A	Stock	76.18	76.23	75.32	76.03	2245900.0
2019-02-04	AA	Stock	28.43	29.19	28.351	29.09	2337200.0
2019-02-04	AABA-DELISTED	Stock	68.19	68.55	67.7481	68.43	6982021.0
2019-02-04	AAC-DELISTED	Stock	2.45	2.89	2.42	2.59	445292.0
2019-02-04	AACG	Stock	1.19	1.23	1.08	1.16	150100.0
2019-02-04	AAIC-DELISTED	Stock	8.74	8.82	8.68	8.73	348281.0
2019-02-04	AAL	Stock	36.16	36.81	36.12	36.78	9089300.0
2019-02-04	AAM.A-DELISTED	Stock	24.49	24.609	24.49	24.5913	17466.0
2019-02-04	AAM.B-DELISTED	Stock	24.34	24.39	24.34	24.3793	21766.0
2019-02-04	AAMC-DELISTED	Stock	8.2324	8.2529	8.0882	8.0882	4675.0
2019-02-04	AAME	Stock	2.85	2.85	2.8	2.8	3100.0
2019-02-04	AAMI	Stock	12.45	12.56	12.37	12.5	613000.0
2019-02-04	AAOI	Stock	17.28	18.04	17.16	17.79	742700.0
2019-02-04	AAON	Stock	24.3533	25.16	23.94	25.1067	138600.0
2019-02-04	AAP	Stock	159.63	161.62	157.76	161.35	665600.0
2019-02-04	AAT	Stock	42.54	43.07	42.16	43.05	106300.0
2019-02-04	AAU-DELISTED	Stock	0.75	0.775	0.75	0.7635	124758.0
2019-02-04	AAUAF-DELISTED	Stock	0.75	0.775	0.75	0.7635	126718.0
2019-02-04	AAWW-DELISTED	Stock	53.49	54.58	53.045	54.49	273599.0
2019-02-04	AAXJ	Stock	68.4	68.935	68.36	68.81	1517541.0
2019-02-04	AAXN-DELISTED	Stock	50.81	52.96	50.7101	52.95	375438.0
2019-02-04	AB	Stock	30.64	30.94	30.53	30.58	271300.0
2019-02-04	ABB-DELISTED	Stock	19.15	19.42	19.13	19.42	3803786.0
2019-02-04	ABBNY-DELISTED	Stock	19.15	19.42	19.13	19.42	4882330.0
2019-02-04	ABBV	Stock	80.3	80.36	77.52	78.53	10205600.0
2019-02-04	ABC-DELISTED	Stock	83.75	85.0	83.2677	84.44	1587290.0
2019-02-04	ABCB	Stock	37.57	38.17	37.46	38.16	312200.0
2019-02-04	ABDC-DELISTED	Stock	7.38	7.82	7.38	7.76	56343.0
2019-02-04	ABEO	Stock	170.5	193.75	168.75	190.0	36956.0
2019-02-04	ABEOW-DELISTED	Stock	3.0	3.35	3.0	3.35	2700.0
2019-02-04	ABEV	Stock	4.87	5.0	4.85	4.97	27220200.0
2019-02-04	ABG	Stock	70.58	72.22	69.81	72.15	252700.0
2019-02-04	ABIL-DELISTED	Stock	2.05	2.06	2.02	2.05	67161.0
2019-02-04	ABM	Stock	33.96	34.5	33.9	34.5	295600.0
2019-02-04	ABMD-DELISTED	Stock	349.18	352.44	316.38	330.42	1303915.0
2019-02-04	ABR	Stock	11.91	12.05	11.9	11.99	734300.0
2019-02-04	ABR.A-DELISTED	Stock	25.84	25.84	25.5	25.56	7413.0
2019-02-04	ABR.B-DELISTED	Stock	25.69	25.7	25.515	25.515	600.0
2019-02-04	ABR.C-DELISTED	Stock	25.6875	25.8723	25.6802	25.7	14398.0
2019-02-04	ABT	Stock	72.39	72.69	71.71	72.5	5278300.0

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

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