PREVIEW / stock_daily / 2020-04-09

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-09.parquet
  size:    217 KB
  rows:    6,626
  symbols: 2,372

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-04-09	AAPL	Stock	67.175	67.5175	66.175	66.9975	161834800.0
2020-04-09	MSFT	Stock	166.36	167.37	163.33	165.14	51385100.0
2020-04-09	NVDA	Stock	6.8	6.823	6.5105	6.5738	525564000.0
2020-04-09	AMZN	Stock	102.215	102.65	100.883	102.138	92930000.0
2020-04-09	GOOGL	Stock	60.909	61.0995	59.6208	60.3285	54028460.0
2020-04-09	META	Stock	175.9	177.08	171.57	175.19	23534300.0
2020-04-09	TSLA	Stock	37.4727	38.3453	37.1407	38.2	204750000.0
2020-04-09	TLT	Stock	164.28	165.79	163.78	165.39	14260806.0
2020-04-09	ES	Stock	84.45	91.0	84.14	90.1	2348700.0
2020-04-09	CL	Stock	70.66	71.47	69.76	69.91	3582500.0
2020-04-09	A	Stock	76.43	78.72	76.23	78.33	2399900.0
2020-04-09	AA	Stock	7.65	8.02	7.22	7.41	13298800.0
2020-04-09	AACG	Stock	0.88	0.91	0.8	0.85	22300.0
2020-04-09	AAIC-DELISTED	Stock	2.75	3.1	2.75	3.07	2113735.0
2020-04-09	AAIC.C-DELISTED	Stock	17.1	17.5	16.415	17.1	13028.0
2020-04-09	AAL	Stock	12.64	13.4	11.82	12.51	117592800.0
2020-04-09	AAM.A-DELISTED	Stock	24.05	24.85	24.05	24.5	47040.0
2020-04-09	AAM.B-DELISTED	Stock	24.3699	24.7	24.2	24.5	58307.0
2020-04-09	AAMC-DELISTED	Stock	3.9412	4.0059	3.8588	3.9412	9904.0
2020-04-09	AAME	Stock	2.15	2.15	1.98	2.07	2700.0
2020-04-09	AAMI	Stock	6.06	6.73	6.025	6.19	572100.0
2020-04-09	AAOI	Stock	8.13	8.191	7.585	7.76	710700.0
2020-04-09	AAON	Stock	32.9933	33.62	31.76	31.94	404250.0
2020-04-09	AAP	Stock	104.62	108.81	103.34	106.86	1137200.0
2020-04-09	AAT	Stock	26.93	29.76	26.88	29.59	673400.0
2020-04-09	AAU-DELISTED	Stock	0.2995	0.3247	0.2928	0.3231	564802.0
2020-04-09	AAUAF-DELISTED	Stock	0.2995	0.3247	0.2928	0.3231	570226.0
2020-04-09	AAWW-DELISTED	Stock	24.8	26.65	24.32	25.27	654928.0
2020-04-09	AAXJ	Stock	62.04	62.492	61.345	61.35	1119748.0
2020-04-09	AAXN-DELISTED	Stock	73.74	76.25	72.6	74.7	333434.0
2020-04-09	AB	Stock	21.17	23.07	21.01	21.96	866600.0
2020-04-09	ABB-DELISTED	Stock	18.21	18.33	17.88	18.1	1740765.0
2020-04-09	ABBNY-DELISTED	Stock	18.21	18.33	17.88	18.1	1927744.0
2020-04-09	ABBV	Stock	78.56	80.08	78.56	79.75	9425900.0
2020-04-09	ABC-DELISTED	Stock	88.18	89.41	86.6621	87.8	1011051.0
2020-04-09	ABCB	Stock	25.14	27.06	24.85	26.6	417000.0
2020-04-09	ABEO	Stock	60.0	60.25	56.25	58.75	51068.0
2020-04-09	ABEV	Stock	2.46	2.48	2.4	2.4	23992800.0
2020-04-09	ABG	Stock	56.16	62.28	56.16	60.43	414500.0
2020-04-09	ABM	Stock	28.4	29.85	27.86	28.93	555900.0
2020-04-09	ABMD-DELISTED	Stock	156.25	160.69	154.6	159.92	326506.0
2020-04-09	ABR	Stock	7.24	8.39	7.24	7.81	5589500.0
2020-04-09	ABR.A-DELISTED	Stock	20.88	22.4	20.52	20.52	6736.0
2020-04-09	ABR.B-DELISTED	Stock	22.28	22.28	20.14	20.25	5381.0
2020-04-09	ABR.C-DELISTED	Stock	20.71	20.85	19.8	20.1	9607.0
2020-04-09	ABT	Stock	85.0	86.5	82.95	86.04	10466800.0
2020-04-09	ABTC	Stock	215400.0	228000.0	207420.0	217200.0	2.7333333333333334
2020-04-09	ABTS	Stock	12.0	15.9	11.25	14.055	27540.0
2020-04-09	ABTX-DELISTED	Stock	24.88	27.35	22.96	27.13	64364.0
2020-04-09	ABUS	Stock	1.03	1.09	1.0	1.03	315100.0

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

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