PREVIEW / stock_daily / 2021-12-22

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-22.parquet
  size:    261 KB
  rows:    8,015
  symbols: 2,634

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-12-22	AAPL	Stock	173.04	175.86	172.15	175.64	92135300.0
2021-12-22	MSFT	Stock	328.3	333.61	325.75	333.2	24831500.0
2021-12-22	NVDA	Stock	28.891	29.555	28.449	29.4	395184000.0
2021-12-22	AMZN	Stock	169.27	172.05	168.5005	171.037	55036000.0
2021-12-22	GOOGL	Stock	143.0675	146.5	143.0675	146.415	26322380.0
2021-12-22	META	Stock	333.8	334.51	328.26	330.45	16764600.0
2021-12-22	TSLA	Stock	321.8867	338.5533	319.0167	336.29	93634200.0
2021-12-22	TLT	Stock	149.73	149.86	149.02	149.82	12253936.0
2021-12-22	ES	Stock	88.81	89.59	88.59	89.35	1091800.0
2021-12-22	CL	Stock	82.18	82.55	81.89	82.46	3373000.0
2021-12-22	A	Stock	154.45	157.16	154.25	156.78	1907900.0
2021-12-22	AA	Stock	56.93	60.554	56.67	59.31	10594800.0
2021-12-22	AAC-DELISTED	Stock	9.76	9.76	9.75	9.75	10954.0
2021-12-22	AACG	Stock	1.18	1.3	1.18	1.22	33300.0
2021-12-22	AACIU	Stock	10.05	10.1499	10.05	10.05	8474.0
2021-12-22	AACIW-DELISTED	Stock	0.5641	0.5641	0.4523	0.564	17494.0
2021-12-22	AAIC-DELISTED	Stock	3.53	3.58	3.48	3.53	269330.0
2021-12-22	AAIC.C-DELISTED	Stock	25.35	25.3597	25.15	25.29	3011.0
2021-12-22	AAL	Stock	18.18	18.5	17.91	18.26	29523000.0
2021-12-22	AAM.A-DELISTED	Stock	25.39	25.58	25.38	25.58	20848.0
2021-12-22	AAM.B-DELISTED	Stock	26.3	26.68	26.3	26.68	21930.0
2021-12-22	AAME	Stock	3.06	3.1	3.04	3.1	14800.0
2021-12-22	AAMI	Stock	25.22	25.601	25.09	25.43	1111000.0
2021-12-22	AAN-DELISTED	Stock	24.2	24.55	23.91	24.53	116100.0
2021-12-22	AAOI	Stock	5.48	5.48	5.32	5.46	484500.0
2021-12-22	AAON	Stock	52.0	52.6333	51.8933	52.4	203850.0
2021-12-22	AAP	Stock	229.9	233.1	228.95	232.79	270100.0
2021-12-22	AAQC-DELISTED	Stock	9.7	9.72	9.7	9.71	38904.0
2021-12-22	AAT	Stock	36.09	36.35	35.59	36.34	159800.0
2021-12-22	AATC	Stock	6.4	6.49	6.37	6.44	10217.0
2021-12-22	AAU-DELISTED	Stock	0.3	0.3215	0.3	0.3101	840142.0
2021-12-22	AAUAF-DELISTED	Stock	0.3	0.3215	0.3	0.3102	847168.0
2021-12-22	AAWW-DELISTED	Stock	89.14	91.9	89.04	91.47	243288.0
2021-12-22	AAXJ	Stock	81.59	82.1	81.35	82.08	1102030.0
2021-12-22	AB	Stock	46.84	47.99	46.53	47.77	276500.0
2021-12-22	ABB-DELISTED	Stock	36.51	37.02	36.49	37.02	829059.0
2021-12-22	ABBNY-DELISTED	Stock	36.51	37.02	36.49	37.01	927335.0
2021-12-22	ABBV	Stock	129.91	132.58	129.78	132.05	7070900.0
2021-12-22	ABC-DELISTED	Stock	127.35	128.655	126.61	127.76	377062.0
2021-12-22	ABCB	Stock	48.18	49.0	47.96	48.85	262300.0
2021-12-22	ABCL	Stock	15.53	15.9	15.14	15.4	1014400.0
2021-12-22	ABCM-DELISTED	Stock	21.83	22.28	21.8	22.14	49722.0
2021-12-22	ABEO	Stock	8.0	8.25	7.75	8.25	180412.0
2021-12-22	ABEV	Stock	2.65	2.73	2.64	2.73	26079700.0
2021-12-22	ABG	Stock	163.93	166.39	162.64	163.61	170100.0
2021-12-22	ABM	Stock	40.33	40.92	39.82	40.89	438600.0
2021-12-22	ABMD-DELISTED	Stock	333.76	344.68	333.61	343.79	134071.0
2021-12-22	ABNB	Stock	165.68	170.68	162.8	169.29	4802500.0
2021-12-22	ABOS	Stock	7.28	7.28	6.9	7.04	87400.0
2021-12-22	ABR	Stock	17.5	18.02	17.45	17.96	1529000.0

> showing 50 of 8,015 rows — these rows as CSV

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