PREVIEW / stock_daily / 2019-11-25

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-25.parquet
  size:    223 KB
  rows:    6,635
  symbols: 2,480

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-11-25	AAPL	Stock	65.6775	66.61	65.63	66.5925	84020400.0
2019-11-25	MSFT	Stock	150.0	151.35	149.92	151.23	22420900.0
2019-11-25	NVDA	Stock	5.401	5.5353	5.388	5.5303	506476000.0
2019-11-25	AMZN	Stock	87.6625	88.871	87.662	88.692	69724000.0
2019-11-25	GOOGL	Stock	64.813	65.5205	64.7805	65.282	23593160.0
2019-11-25	META	Stock	199.52	200.97	199.25	199.79	15272300.0
2019-11-25	TSLA	Stock	22.9547	22.9713	22.2973	22.4227	185092500.0
2019-11-25	TLT	Stock	140.3	140.53	140.18	140.31	4157476.0
2019-11-25	ES	Stock	82.25	82.57	81.83	82.15	1767500.0
2019-11-25	CL	Stock	66.83	66.98	66.34	66.98	3020200.0
2019-11-25	A	Stock	79.45	80.46	79.3	80.26	2640800.0
2019-11-25	AA	Stock	20.75	20.9	20.4	20.44	2775200.0
2019-11-25	AACG	Stock	1.81	1.81	1.75	1.79	13000.0
2019-11-25	AAIC-DELISTED	Stock	5.66	5.75	5.66	5.7	299287.0
2019-11-25	AAIC.C-DELISTED	Stock	21.75	21.8	21.5671	21.8	4679.0
2019-11-25	AAL	Stock	28.8	29.18	28.62	28.99	5171200.0
2019-11-25	AAM.A-DELISTED	Stock	26.6	26.66	26.6	26.61	9984.0
2019-11-25	AAM.B-DELISTED	Stock	27.1	27.18	27.1	27.116	11759.0
2019-11-25	AAMC-DELISTED	Stock	3.7471	3.9412	3.7265	3.8235	19635.0
2019-11-25	AAME	Stock	1.92	1.92	1.74	1.74	5500.0
2019-11-25	AAMI	Stock	9.67	9.74	9.59	9.71	298100.0
2019-11-25	AAOI	Stock	10.245	10.42	10.02	10.29	326000.0
2019-11-25	AAON	Stock	32.4267	33.2933	32.3667	33.04	357300.0
2019-11-25	AAP	Stock	158.36	160.5	157.59	159.15	647500.0
2019-11-25	AAT	Stock	46.21	46.69	46.14	46.3	282200.0
2019-11-25	AAU-DELISTED	Stock	0.4736	0.4769	0.465	0.4688	197821.0
2019-11-25	AAUAF-DELISTED	Stock	0.4736	0.48	0.465	0.4688	208615.0
2019-11-25	AAWW-DELISTED	Stock	25.04	26.23	25.0	26.18	210636.0
2019-11-25	AAXJ	Stock	70.48	70.83	70.42	70.8	1413411.0
2019-11-25	AAXN-DELISTED	Stock	72.74	74.85	72.4055	74.31	518902.0
2019-11-25	AB	Stock	29.26	29.35	28.85	28.96	271600.0
2019-11-25	ABB-DELISTED	Stock	21.82	22.0274	21.8	22.01	1091009.0
2019-11-25	ABBNY-DELISTED	Stock	21.82	22.0274	21.8	22.0	1140594.0
2019-11-25	ABBV	Stock	86.85	87.88	86.06	87.76	9522100.0
2019-11-25	ABC-DELISTED	Stock	90.52	90.81	89.8671	90.64	684215.0
2019-11-25	ABCB	Stock	42.81	43.74	42.61	43.5	306000.0
2019-11-25	ABDC-DELISTED	Stock	9.06	9.06	9.0	9.0	30800.0
2019-11-25	ABEO	Stock	64.5	75.5	64.25	71.75	35640.0
2019-11-25	ABEOW-DELISTED	Stock	0.13	0.13	0.1	0.1258	6300.0
2019-11-25	ABEV	Stock	4.28	4.34	4.27	4.3	15871600.0
2019-11-25	ABG	Stock	110.19	111.87	109.99	111.14	100700.0
2019-11-25	ABIL-DELISTED	Stock	0.34	0.34	0.3102	0.32	61703.0
2019-11-25	ABM	Stock	37.93	38.49	37.64	38.32	327200.0
2019-11-25	ABMD-DELISTED	Stock	182.0	188.89	181.215	187.55	496803.0
2019-11-25	ABR	Stock	14.95	15.03	14.92	14.98	730500.0
2019-11-25	ABR.A-DELISTED	Stock	25.93	25.93	25.8863	25.8908	1100.0
2019-11-25	ABR.B-DELISTED	Stock	25.76	25.8307	25.76	25.8307	374.0
2019-11-25	ABR.C-DELISTED	Stock	26.044	26.17	25.99	26.0944	1200.0
2019-11-25	ABT	Stock	83.91	84.81	83.88	84.49	5704000.0
2019-11-25	ABTC	Stock	209100.0	217200.0	181500.0	183870.0	10.933333333333334

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

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