PREVIEW / stock_daily / 2020-09-24

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-24.parquet
  size:    226 KB
  rows:    6,878
  symbols: 2,459

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-09-24	AAPL	Stock	105.17	110.25	105.0	108.22	167743300.0
2020-09-24	MSFT	Stock	199.85	205.57	199.2	203.19	31202500.0
2020-09-24	NVDA	Stock	12.0722	12.5695	12.014	12.348	731240000.0
2020-09-24	AMZN	Stock	148.8895	153.465	148.25	150.9895	110588000.0
2020-09-24	GOOGL	Stock	70.134	71.8995	70.1075	71.143	34552220.0
2020-09-24	META	Stock	246.5	252.24	245.62	249.53	20006800.0
2020-09-24	TSLA	Stock	121.2667	133.1667	117.1	129.2633	289683300.0
2020-09-24	TLT	Stock	164.96	165.12	164.62	165.12	8278072.0
2020-09-24	ES	Stock	78.33	80.24	78.2	79.95	1473100.0
2020-09-24	CL	Stock	75.3	76.27	74.96	75.76	2385200.0
2020-09-24	A	Stock	96.57	96.97	95.44	96.34	1157600.0
2020-09-24	AA	Stock	11.66	11.915	11.39	11.7	3919600.0
2020-09-24	AACG	Stock	1.07	1.09	1.06	1.07	22400.0
2020-09-24	AACQ-DELISTED	Stock	9.93	9.9348	9.87	9.87	75532.0
2020-09-24	AACQU-DELISTED	Stock	10.355	10.37	10.17	10.295	105473.0
2020-09-24	AACQW-DELISTED	Stock	1.42	1.44	1.11	1.4127	138134.0
2020-09-24	AAIC-DELISTED	Stock	2.5	2.6784	2.48	2.64	501266.0
2020-09-24	AAIC.C-DELISTED	Stock	18.8	18.8	18.75	18.75	3670.0
2020-09-24	AAL	Stock	11.74	12.0	11.22	11.77	49163200.0
2020-09-24	AAM.A-DELISTED	Stock	25.83	25.96	25.72	25.96	9611.0
2020-09-24	AAM.B-DELISTED	Stock	26.6	26.745	26.39	26.605	15829.0
2020-09-24	AAMC-DELISTED	Stock	5.8824	6.1588	5.8824	5.9824	18316.0
2020-09-24	AAMI	Stock	12.6	12.78	12.35	12.5	398200.0
2020-09-24	AAOI	Stock	10.39	10.73	10.05	10.42	479100.0
2020-09-24	AAON	Stock	37.5133	38.4067	37.2333	38.2267	266250.0
2020-09-24	AAP	Stock	144.52	148.84	142.46	146.71	1115900.0
2020-09-24	AAT	Stock	23.14	23.55	22.72	23.12	243400.0
2020-09-24	AAU-DELISTED	Stock	0.829	0.8864	0.812	0.837	693610.0
2020-09-24	AAUAF-DELISTED	Stock	0.829	0.8864	0.812	0.8367	740474.0
2020-09-24	AAWW-DELISTED	Stock	60.32	61.76	59.58	60.53	320051.0
2020-09-24	AAXJ	Stock	74.31	75.31	74.18	74.86	1582791.0
2020-09-24	AAXN-DELISTED	Stock	86.0	86.73	84.1	85.38	321673.0
2020-09-24	AB	Stock	26.86	27.02	26.33	26.85	467700.0
2020-09-24	ABB-DELISTED	Stock	24.89	25.22	24.76	25.05	1636001.0
2020-09-24	ABBNY-DELISTED	Stock	24.88	25.22	24.76	25.06	1733674.0
2020-09-24	ABBV	Stock	87.0	87.0	85.32	85.91	9980800.0
2020-09-24	ABC-DELISTED	Stock	94.35	95.94	92.0	94.66	796041.0
2020-09-24	ABCB	Stock	21.22	21.96	20.86	21.44	414800.0
2020-09-24	ABEO	Stock	45.0	49.5	43.75	48.75	52568.0
2020-09-24	ABEV	Stock	2.25	2.35	2.21	2.31	21438700.0
2020-09-24	ABG	Stock	94.71	95.81	93.06	93.85	188900.0
2020-09-24	ABM	Stock	36.24	37.24	35.96	36.74	340900.0
2020-09-24	ABMD-DELISTED	Stock	261.04	265.57	256.51	262.33	122410.0
2020-09-24	ABR	Stock	11.06	11.43	10.68	11.17	1171600.0
2020-09-24	ABR.A-DELISTED	Stock	25.19	25.352	24.63	25.1345	20338.0
2020-09-24	ABR.B-DELISTED	Stock	24.85	24.95	24.76	24.95	1800.0
2020-09-24	ABR.C-DELISTED	Stock	25.54	25.54	25.25	25.35	7980.0
2020-09-24	ABT	Stock	102.75	103.53	100.47	100.92	7604000.0
2020-09-24	ABTC	Stock	116100.0	117510.0	104100.0	109200.0	5.133333333333333
2020-09-24	ABTS	Stock	19.35	20.7	18.3	19.5	7600.0

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

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