PREVIEW / stock_daily / 2019-10-11

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-11.parquet
  size:    220 KB
  rows:    6,581
  symbols: 2,487

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-10-11	AAPL	Stock	58.2375	59.41	58.0775	59.0525	166795600.0
2019-10-11	MSFT	Stock	140.12	141.03	139.5	139.68	25446000.0
2019-10-11	NVDA	Stock	4.6603	4.7335	4.6412	4.6498	446404000.0
2019-10-11	AMZN	Stock	87.146	87.2725	86.493	86.596	65100000.0
2019-10-11	GOOGL	Stock	61.2015	61.4375	60.6819	60.7855	22529040.0
2019-10-11	META	Stock	182.15	186.49	182.14	184.19	14930500.0
2019-10-11	TSLA	Stock	16.4767	16.7387	16.454	16.526	127131000.0
2019-10-11	TLT	Stock	140.98	141.1	139.71	140.44	28513340.0
2019-10-11	ES	Stock	85.2	86.0	84.9	85.57	1148100.0
2019-10-11	CL	Stock	71.11	71.12	70.22	70.51	2574100.0
2019-10-11	A	Stock	75.55	76.21	75.24	75.3	1200700.0
2019-10-11	AA	Stock	19.16	19.5	18.97	19.28	5999800.0
2019-10-11	AAC-DELISTED	Stock	0.3901	0.4	0.322	0.3501	706093.0
2019-10-11	AACG	Stock	1.69	1.69	1.56	1.56	40100.0
2019-10-11	AAIC-DELISTED	Stock	5.45	5.56	5.45	5.49	345998.0
2019-10-11	AAIC.C-DELISTED	Stock	20.7	21.043	20.6	20.9	7325.0
2019-10-11	AAL	Stock	27.63	28.02	27.34	27.36	7492400.0
2019-10-11	AAM.A-DELISTED	Stock	26.6578	26.66	26.53	26.58	17605.0
2019-10-11	AAM.B-DELISTED	Stock	27.18	27.18	26.99	27.0999	27218.0
2019-10-11	AAMC-DELISTED	Stock	3.8066	3.8235	3.6182	3.7176	30852.0
2019-10-11	AAME	Stock	2.53	2.55	2.53	2.55	1300.0
2019-10-11	AAMI	Stock	9.5	9.62	9.37	9.38	672100.0
2019-10-11	AAOI	Stock	10.33	10.526	10.285	10.395	228700.0
2019-10-11	AAON	Stock	30.76	31.8667	30.6	31.3467	269400.0
2019-10-11	AAP	Stock	157.51	160.0	157.4	158.56	691600.0
2019-10-11	AAT	Stock	46.51	46.98	46.22	46.77	393100.0
2019-10-11	AAU-DELISTED	Stock	0.73	0.73	0.6765	0.68	269519.0
2019-10-11	AAUAF-DELISTED	Stock	0.73	0.73	0.6765	0.68	278746.0
2019-10-11	AAWW-DELISTED	Stock	21.76	22.3	21.05	21.78	693588.0
2019-10-11	AAXJ	Stock	67.69	68.32	67.64	67.69	2070060.0
2019-10-11	AAXN-DELISTED	Stock	53.24	54.89	53.01	53.15	573788.0
2019-10-11	AB	Stock	28.9	29.07	28.46	28.49	214000.0
2019-10-11	ABB-DELISTED	Stock	18.4	18.61	18.37	18.48	1877153.0
2019-10-11	ABBNY-DELISTED	Stock	18.4	18.61	18.37	18.48	1964888.0
2019-10-11	ABBV	Stock	73.97	74.34	73.57	73.63	7164900.0
2019-10-11	ABC-DELISTED	Stock	81.8	83.15	81.16	81.94	717267.0
2019-10-11	ABCB	Stock	40.17	40.78	39.89	39.89	460000.0
2019-10-11	ABDC-DELISTED	Stock	8.85	8.86	8.8	8.81	9612.0
2019-10-11	ABEO	Stock	55.5	57.75	54.0	56.0	10724.0
2019-10-11	ABEV	Stock	4.5	4.6	4.49	4.55	18993800.0
2019-10-11	ABG	Stock	100.55	102.05	99.76	99.86	143500.0
2019-10-11	ABIL-DELISTED	Stock	0.46	0.48	0.4507	0.48	8966.0
2019-10-11	ABM	Stock	35.54	36.97	35.48	36.12	506400.0
2019-10-11	ABMD-DELISTED	Stock	164.1	173.22	163.7343	169.65	450116.0
2019-10-11	ABR	Stock	13.22	13.23	13.11	13.17	1214100.0
2019-10-11	ABR.A-DELISTED	Stock	25.9	25.98	25.9	25.98	1700.0
2019-10-11	ABR.B-DELISTED	Stock	26.0991	26.1	26.0991	26.1	1200.0
2019-10-11	ABR.C-DELISTED	Stock	25.9995	26.05	25.8805	25.995	1600.0
2019-10-11	ABT	Stock	80.73	81.33	79.55	79.63	4423000.0
2019-10-11	ABTC	Stock	166800.0	174900.0	166800.0	171600.0	1.1733333333333333

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

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