PREVIEW / stock_daily / 2020-03-18

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-18.parquet
  size:    212 KB
  rows:    6,686
  symbols: 2,426

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
2020-03-18	AAPL	Stock	59.9425	62.5	59.28	61.6675	300233600.0
2020-03-18	MSFT	Stock	138.0	146.0	135.02	140.4	81593200.0
2020-03-18	NVDA	Stock	5.0025	5.2485	4.517	5.0705	874268000.0
2020-03-18	AMZN	Stock	87.5	92.083	87.25	91.5	192904000.0
2020-03-18	GOOGL	Stock	52.997	55.2495	51.85	54.5595	93044760.0
2020-03-18	META	Stock	139.75	148.18	137.1	146.96	37553100.0
2020-03-18	TSLA	Stock	25.9333	26.9907	23.3673	24.0813	356793000.0
2020-03-18	TLT	Stock	152.84	154.14	139.0105	144.35	47060975.0
2020-03-18	ES	Stock	83.2	88.74	78.44	86.25	4556400.0
2020-03-18	CL	Stock	67.8	72.14	65.35	67.69	9189300.0
2020-03-18	A	Stock	65.19	69.88	65.18	68.87	4123900.0
2020-03-18	AA	Stock	6.53	6.68	5.27	5.75	9287100.0
2020-03-18	AACG	Stock	0.85	0.93	0.7	0.73	23600.0
2020-03-18	AAIC-DELISTED	Stock	3.05	3.13	1.4	1.7	1277897.0
2020-03-18	AAIC.C-DELISTED	Stock	13.2001	13.2001	5.06	7.74	12573.0
2020-03-18	AAL	Stock	14.24	14.28	10.17	11.65	78458800.0
2020-03-18	AAM.A-DELISTED	Stock	20.85	20.85	15.845	17.43	145507.0
2020-03-18	AAM.B-DELISTED	Stock	20.56	20.8115	15.82	16.85	159281.0
2020-03-18	AAMC-DELISTED	Stock	4.2353	4.2353	3.2206	3.2206	30943.0
2020-03-18	AAMI	Stock	4.59	4.87	3.61	3.73	790400.0
2020-03-18	AAOI	Stock	5.56	5.81	5.0	5.5	1207400.0
2020-03-18	AAON	Stock	30.02	32.3733	29.42	31.5733	634050.0
2020-03-18	AAP	Stock	92.63	94.46	78.56	88.74	1649400.0
2020-03-18	AAT	Stock	22.79	24.35	21.18	21.77	597200.0
2020-03-18	AAU-DELISTED	Stock	0.38	0.38	0.28	0.2843	355626.0
2020-03-18	AAUAF-DELISTED	Stock	0.38	0.38	0.28	0.2843	380894.0
2020-03-18	AAWW-DELISTED	Stock	21.94	23.95	16.415	19.58	1135016.0
2020-03-18	AAXJ	Stock	54.72	55.95	53.37	54.6	1602643.0
2020-03-18	AAXN-DELISTED	Stock	53.2	55.87	50.051	52.6	709291.0
2020-03-18	AB	Stock	17.36	17.86	14.5	14.66	1756400.0
2020-03-18	ABB-DELISTED	Stock	15.31	15.77	14.91	15.65	3365184.0
2020-03-18	ABBNY-DELISTED	Stock	15.31	15.77	14.91	15.62	3601076.0
2020-03-18	ABBV	Stock	70.0	71.39	64.69	71.03	23712800.0
2020-03-18	ABC-DELISTED	Stock	84.9	90.76	78.14	84.97	2705930.0
2020-03-18	ABCB	Stock	22.82	23.37	19.65	20.34	948800.0
2020-03-18	ABEO	Stock	49.5	49.5	41.25	42.5	59136.0
2020-03-18	ABEV	Stock	2.11	2.18	2.04	2.12	45951600.0
2020-03-18	ABG	Stock	44.59	44.96	41.41	44.62	618400.0
2020-03-18	ABM	Stock	26.55	28.05	24.64	24.72	789700.0
2020-03-18	ABMD-DELISTED	Stock	136.02	146.91	132.5	146.53	696727.0
2020-03-18	ABR	Stock	5.41	5.44	3.54	4.56	7602600.0
2020-03-18	ABR.A-DELISTED	Stock	15.0	15.0	7.6	9.951	36497.0
2020-03-18	ABR.B-DELISTED	Stock	15.07	15.792	9.15	10.0	29787.0
2020-03-18	ABR.C-DELISTED	Stock	14.35	15.73	12.5	12.75	23754.0
2020-03-18	ABT	Stock	74.98	81.99	74.39	79.26	17541100.0
2020-03-18	ABTC	Stock	135000.0	138000.0	112500.0	120000.0	2.546666666666667
2020-03-18	ABTS	Stock	15.21	18.3	15.21	15.75	567.0
2020-03-18	ABTX-DELISTED	Stock	25.78	27.99	23.99	25.38	96310.0
2020-03-18	ABUS	Stock	1.26	1.44	1.18	1.2	413300.0
2020-03-18	ACA	Stock	34.01	34.74	28.82	30.13	385029.0

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

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