PREVIEW / stock_daily / 2019-09-10

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-10.parquet
  size:    220 KB
  rows:    6,578
  symbols: 2,519

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-09-10	AAPL	Stock	53.465	54.195	52.9275	54.175	127111600.0
2019-09-10	MSFT	Stock	136.8	136.89	134.51	136.08	28903400.0
2019-09-10	NVDA	Stock	4.4795	4.6062	4.4698	4.5795	352812000.0
2019-09-10	AMZN	Stock	91.1375	91.2905	90.267	91.0275	52278000.0
2019-09-10	GOOGL	Stock	59.8045	60.5	59.8005	60.285	27921540.0
2019-09-10	META	Stock	187.44	188.1	184.55	186.17	15455900.0
2019-09-10	TSLA	Stock	15.3867	15.7027	15.2627	15.7027	73255500.0
2019-09-10	TLT	Stock	142.84	143.29	140.66	140.69	13851422.0
2019-09-10	ES	Stock	81.62	81.89	80.95	81.87	2448500.0
2019-09-10	CL	Stock	72.51	72.52	71.18	72.12	4712900.0
2019-09-10	A	Stock	73.5	75.03	73.29	74.77	2838000.0
2019-09-10	AA	Stock	20.39	20.89	19.85	20.83	3213800.0
2019-09-10	AABA-DELISTED	Stock	70.0	70.11	69.991	70.03	4799384.0
2019-09-10	AAC-DELISTED	Stock	0.59	0.74	0.59	0.6905	524134.0
2019-09-10	AACG	Stock	1.86	1.91	1.81	1.9	31900.0
2019-09-10	AAIC-DELISTED	Stock	5.22	5.485	5.21	5.43	428856.0
2019-09-10	AAIC.C-DELISTED	Stock	21.94	21.98	21.8442	21.89	18754.0
2019-09-10	AAL	Stock	28.28	29.18	28.21	29.12	6377300.0
2019-09-10	AAM.A-DELISTED	Stock	26.42	26.4473	26.3297	26.36	41489.0
2019-09-10	AAM.B-DELISTED	Stock	26.31	26.3968	26.24	26.27	24859.0
2019-09-10	AAMC-DELISTED	Stock	2.9294	2.9324	2.9294	2.9324	1629.0
2019-09-10	AAMI	Stock	10.18	10.52	10.07	10.34	618800.0
2019-09-10	AAOI	Stock	10.51	11.6	10.51	11.44	935800.0
2019-09-10	AAON	Stock	31.64	32.1267	30.9733	31.8733	157050.0
2019-09-10	AAP	Stock	147.37	155.38	146.79	154.7	1403200.0
2019-09-10	AAT	Stock	47.77	48.18	47.1	47.43	803600.0
2019-09-10	AAU-DELISTED	Stock	0.66	0.71	0.635	0.695	310641.0
2019-09-10	AAUAF-DELISTED	Stock	0.66	0.71	0.652	0.6936	327454.0
2019-09-10	AAWW-DELISTED	Stock	29.2	29.75	29.05	29.16	262743.0
2019-09-10	AAXJ	Stock	67.41	67.57	67.14	67.5	1029791.0
2019-09-10	AAXN-DELISTED	Stock	59.29	60.6	58.11	60.57	382033.0
2019-09-10	AB	Stock	29.4	29.62	29.04	29.25	148200.0
2019-09-10	ABB-DELISTED	Stock	19.92	20.05	19.855	20.04	1438719.0
2019-09-10	ABBNY-DELISTED	Stock	19.92	20.05	19.855	20.04	1586643.0
2019-09-10	ABBV	Stock	66.07	68.18	65.65	68.18	12155700.0
2019-09-10	ABC-DELISTED	Stock	86.46	86.82	84.23	85.86	1487516.0
2019-09-10	ABCB	Stock	35.78	36.87	35.73	36.83	402000.0
2019-09-10	ABDC-DELISTED	Stock	8.93	9.0	8.92	8.94	29209.0
2019-09-10	ABEO	Stock	75.0	80.5	72.0	79.25	36016.0
2019-09-10	ABEOW-DELISTED	Stock	0.3	0.3	0.2992	0.2992	5000.0
2019-09-10	ABEV	Stock	4.59	4.67	4.54	4.6	19609000.0
2019-09-10	ABG	Stock	99.91	101.84	99.28	101.48	299400.0
2019-09-10	ABIL-DELISTED	Stock	0.605	0.6415	0.5	0.6025	46968.0
2019-09-10	ABM	Stock	34.85	36.27	34.62	36.04	384000.0
2019-09-10	ABMD-DELISTED	Stock	186.0	192.9874	185.22	191.74	481125.0
2019-09-10	ABR	Stock	12.52	12.64	12.48	12.6	1046000.0
2019-09-10	ABR.A-DELISTED	Stock	26.1564	26.267	26.144	26.267	2140.0
2019-09-10	ABR.B-DELISTED	Stock	25.84	25.97	25.772	25.97	2896.0
2019-09-10	ABR.C-DELISTED	Stock	26.35	26.35	26.3131	26.3131	500.0
2019-09-10	ABT	Stock	83.44	83.48	81.02	83.21	5613100.0

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

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