PREVIEW / stock_daily / 2021-01-06

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-06.parquet
  size:    242 KB
  rows:    7,295
  symbols: 2,640

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
2021-01-06	AAPL	Stock	127.72	131.05	126.38	126.6	155088000.0
2021-01-06	MSFT	Stock	212.17	216.49	211.94	212.25	35930700.0
2021-01-06	NVDA	Stock	13.2225	13.245	12.586	12.6145	580424000.0
2021-01-06	AMZN	Stock	157.324	159.8755	156.558	156.919	87896000.0
2021-01-06	GOOGL	Stock	85.0128	87.1982	84.8051	86.144	46588020.0
2021-01-06	META	Stock	262.0	267.75	260.01	263.31	24354100.0
2021-01-06	TSLA	Stock	252.83	258.0	249.7	251.9933	134100000.0
2021-01-06	TLT	Stock	153.82	153.85	152.29	153.16	22827290.0
2021-01-06	ES	Stock	85.36	89.76	85.21	89.13	2920400.0
2021-01-06	CL	Stock	84.16	84.79	81.87	82.25	9053900.0
2021-01-06	A	Stock	118.69	123.88	118.21	122.89	2428500.0
2021-01-06	AA	Stock	24.5	25.66	24.4	25.21	5656900.0
2021-01-06	AACG	Stock	1.23	1.3	1.22	1.22	41400.0
2021-01-06	AACQ-DELISTED	Stock	10.59	10.85	10.52	10.64	1600484.0
2021-01-06	AACQU-DELISTED	Stock	11.25	11.48	11.2	11.26	215887.0
2021-01-06	AACQW-DELISTED	Stock	2.11	2.1499	2.0	2.06	314315.0
2021-01-06	AAIC-DELISTED	Stock	3.82	3.935	3.82	3.88	147152.0
2021-01-06	AAIC.C-DELISTED	Stock	21.05	21.05	20.895	21.0	1953.0
2021-01-06	AAL	Stock	15.45	15.8	15.17	15.52	63708000.0
2021-01-06	AAM.A-DELISTED	Stock	26.51	26.51	26.0	26.25	11541.0
2021-01-06	AAM.B-DELISTED	Stock	27.24	27.24	26.51	26.77	25150.0
2021-01-06	AAMC-DELISTED	Stock	6.7647	7.0143	6.6765	6.7206	23820.0
2021-01-06	AAME	Stock	2.37	2.52	2.28	2.3	84100.0
2021-01-06	AAMI	Stock	18.93	19.785	18.798	19.52	661600.0
2021-01-06	AAN-DELISTED	Stock	19.65	20.93	19.65	20.85	1230900.0
2021-01-06	AAOI	Stock	8.92	9.7	8.8	9.58	1487800.0
2021-01-06	AAON	Stock	44.2	46.44	42.8067	45.92	588450.0
2021-01-06	AAP	Stock	157.21	166.79	157.21	166.25	1584000.0
2021-01-06	AAT	Stock	27.98	29.06	27.98	28.72	348600.0
2021-01-06	AAU-DELISTED	Stock	0.52	0.5532	0.5101	0.5225	2635039.0
2021-01-06	AAUAF-DELISTED	Stock	0.52	0.5532	0.5101	0.5236	2678929.0
2021-01-06	AAWW-DELISTED	Stock	54.09	54.8	52.4227	53.16	532839.0
2021-01-06	AAXJ	Stock	92.01	92.7398	91.39	91.64	1613044.0
2021-01-06	AAXN-DELISTED	Stock	122.41	123.07	118.44	121.79	489497.0
2021-01-06	AB	Stock	33.36	35.0	33.36	34.34	609800.0
2021-01-06	ABB-DELISTED	Stock	29.26	29.9469	29.24	29.67	3665569.0
2021-01-06	ABBNY-DELISTED	Stock	29.26	29.9469	29.24	29.67	4522359.0
2021-01-06	ABBV	Stock	104.75	107.19	104.18	105.58	11017500.0
2021-01-06	ABC-DELISTED	Stock	100.16	107.15	100.16	106.15	2166901.0
2021-01-06	ABCB	Stock	40.22	43.03	40.17	42.13	856500.0
2021-01-06	ABCL	Stock	38.75	40.05	36.82	39.61	2752800.0
2021-01-06	ABCM-DELISTED	Stock	20.14	20.33	19.5	19.93	143819.0
2021-01-06	ABEO	Stock	44.25	45.75	42.5	42.75	84332.0
2021-01-06	ABEV	Stock	2.98	3.09	2.97	3.07	46496100.0
2021-01-06	ABG	Stock	148.49	159.96	147.2	158.62	281200.0
2021-01-06	ABM	Stock	38.44	41.67	38.22	41.11	499500.0
2021-01-06	ABMD-DELISTED	Stock	316.66	324.66	315.7226	321.81	201664.0
2021-01-06	ABNB	Stock	145.75	148.35	141.11	142.77	4213900.0
2021-01-06	ABR	Stock	14.1	14.69	14.1	14.35	1771600.0
2021-01-06	ABR.A-DELISTED	Stock	25.47	25.47	25.4	25.4498	7136.0

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

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