PREVIEW / stock_daily / 2020-12-09

all stock daily files

  file:    by_date/stock_daily/2020/2020-12-09.parquet
  size:    238 KB
  rows:    7,213
  symbols: 2,625

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-12-09	AAPL	Stock	124.53	125.95	121.0	121.78	115089200.0
2020-12-09	MSFT	Stock	215.16	215.23	211.21	211.8	32440600.0
2020-12-09	NVDA	Stock	13.3005	13.414	12.8683	12.9308	401300000.0
2020-12-09	AMZN	Stock	158.3945	158.7215	154.4	155.21	82016000.0
2020-12-09	GOOGL	Stock	90.518	91.4185	88.1	88.893	31728520.0
2020-12-09	META	Stock	283.66	287.63	271.75	277.92	25189700.0
2020-12-09	TSLA	Stock	217.8967	218.1067	196.0	201.4933	213873600.0
2020-12-09	TLT	Stock	156.55	157.32	156.015	156.82	7750059.0
2020-12-09	ES	Stock	86.38	86.56	85.32	86.02	945500.0
2020-12-09	CL	Stock	85.16	85.34	84.39	84.75	2582900.0
2020-12-09	A	Stock	116.38	116.96	114.48	116.4	1717600.0
2020-12-09	AA	Stock	23.665	24.0	22.0	22.71	7021400.0
2020-12-09	AACG	Stock	1.19	1.21	1.13	1.15	54900.0
2020-12-09	AACQ-DELISTED	Stock	10.4	10.5	10.27	10.3	1042851.0
2020-12-09	AACQU-DELISTED	Stock	11.07	11.175	10.95	10.95	46508.0
2020-12-09	AACQW-DELISTED	Stock	2.0703	2.2	1.95	1.99	320284.0
2020-12-09	AAIC-DELISTED	Stock	4.02	4.09	3.67	3.73	495476.0
2020-12-09	AAIC.C-DELISTED	Stock	21.0	21.7	21.0	21.7	3249.0
2020-12-09	AAL	Stock	18.37	18.63	16.63	17.16	138508300.0
2020-12-09	AAM.A-DELISTED	Stock	26.44	26.44	26.29	26.34	8771.0
2020-12-09	AAM.B-DELISTED	Stock	27.15	27.16	27.0	27.15	14688.0
2020-12-09	AAMC-DELISTED	Stock	6.5176	6.7941	6.5176	6.6868	2978.0
2020-12-09	AAME	Stock	2.14	2.21	2.12	2.15	5800.0
2020-12-09	AAMI	Stock	19.59	19.78	18.98	19.45	817500.0
2020-12-09	AAN-DELISTED	Stock	17.45	17.7	16.95	17.29	1793400.0
2020-12-09	AAOI	Stock	8.4	8.45	7.81	7.88	781500.0
2020-12-09	AAON	Stock	41.66	42.5	41.3733	42.2533	258300.0
2020-12-09	AAP	Stock	152.99	158.42	152.51	157.95	1275300.0
2020-12-09	AAT	Stock	29.57	29.65	29.1	29.42	253000.0
2020-12-09	AAU-DELISTED	Stock	0.7101	0.72	0.67	0.689	1295579.0
2020-12-09	AAUAF-DELISTED	Stock	0.7101	0.72	0.67	0.6982	1405350.0
2020-12-09	AAWW-DELISTED	Stock	55.5854	56.71	54.64	55.76	328518.0
2020-12-09	AAXJ	Stock	88.38	88.38	86.88	87.26	1507648.0
2020-12-09	AAXN-DELISTED	Stock	125.22	128.88	121.68	123.01	294502.0
2020-12-09	AB	Stock	32.68	32.87	31.22	31.36	1326800.0
2020-12-09	ABB-DELISTED	Stock	27.14	27.16	26.77	26.92	1878847.0
2020-12-09	ABBNY-DELISTED	Stock	27.14	27.16	26.77	26.93	2070346.0
2020-12-09	ABBV	Stock	107.9	109.15	107.63	108.67	7350700.0
2020-12-09	ABC-DELISTED	Stock	100.48	101.47	100.01	101.1	661277.0
2020-12-09	ABCB	Stock	37.54	37.91	37.04	37.75	473000.0
2020-12-09	ABCM-DELISTED	Stock	18.92	19.12	18.5001	18.76	80066.0
2020-12-09	ABEO	Stock	38.25	38.25	35.5	36.5	101776.0
2020-12-09	ABEV	Stock	2.98	3.03	2.93	2.99	20343400.0
2020-12-09	ABG	Stock	140.38	144.69	140.38	143.97	155200.0
2020-12-09	ABM	Stock	41.0	41.79	40.39	40.65	398900.0
2020-12-09	ABMD-DELISTED	Stock	272.13	272.54	261.23	266.15	151375.0
2020-12-09	ABR	Stock	14.41	14.54	13.99	14.07	1839900.0
2020-12-09	ABR.A-DELISTED	Stock	25.57	25.59	25.4	25.4566	4450.0
2020-12-09	ABR.C-DELISTED	Stock	25.75	25.75	25.75	25.75	100.0
2020-12-09	ABST-DELISTED	Stock	10.55	10.55	10.16	10.21	219128.0

> showing 50 of 7,213 rows — these rows as CSV

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