PREVIEW / stock_daily / 2021-09-22

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-22.parquet
  size:    257 KB
  rows:    7,851
  symbols: 2,679

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-09-22	AAPL	Stock	144.45	146.43	143.7	145.85	76404300.0
2021-09-22	MSFT	Stock	296.73	300.22	294.51	298.58	26626300.0
2021-09-22	NVDA	Stock	21.366	21.96	21.196	21.941	268726000.0
2021-09-22	AMZN	Stock	167.55	169.45	167.0525	169.0025	48228000.0
2021-09-22	GOOGL	Stock	139.304	140.887	138.5515	140.2835	25055560.0
2021-09-22	META	Stock	347.23	349.84	340.69	343.21	43692900.0
2021-09-22	TSLA	Stock	247.8433	251.2233	246.3733	250.6467	45378900.0
2021-09-22	TLT	Stock	150.79	151.79	150.44	151.79	22277765.0
2021-09-22	ES	Stock	83.81	83.81	82.53	82.95	886000.0
2021-09-22	CL	Stock	76.76	77.04	76.25	76.43	2811500.0
2021-09-22	A	Stock	172.18	173.32	170.91	172.44	981000.0
2021-09-22	AA	Stock	47.3	49.37	47.1	47.95	10983800.0
2021-09-22	AAC-DELISTED	Stock	9.71	9.76	9.71	9.76	229121.0
2021-09-22	AACG	Stock	2.43	2.49	2.41	2.44	32400.0
2021-09-22	AACIU	Stock	9.96	9.96	9.96	9.96	1102.0
2021-09-22	AAIC-DELISTED	Stock	3.75	3.78	3.73	3.77	186349.0
2021-09-22	AAIC.C-DELISTED	Stock	25.11	25.2593	25.11	25.24	5000.0
2021-09-22	AAL	Stock	19.93	20.75	19.93	20.52	39344300.0
2021-09-22	AAM.A-DELISTED	Stock	25.72	25.85	25.72	25.84	34883.0
2021-09-22	AAM.B-DELISTED	Stock	26.81	26.91	26.72	26.89	25710.0
2021-09-22	AAMC-DELISTED	Stock	7.5882	7.5882	7.1059	7.2088	79737.0
2021-09-22	AAME	Stock	3.83	3.93	3.73	3.8	20000.0
2021-09-22	AAMI	Stock	26.41	26.83	26.36	26.59	269400.0
2021-09-22	AAN-DELISTED	Stock	26.94	27.675	26.78	27.5	166000.0
2021-09-22	AAOI	Stock	6.87	7.13	6.8	6.98	448200.0
2021-09-22	AAON	Stock	43.7733	44.3467	43.6267	43.92	154200.0
2021-09-22	AAP	Stock	206.33	212.43	206.23	211.21	881400.0
2021-09-22	AAQC-DELISTED	Stock	9.69	9.69	9.69	9.69	280.0
2021-09-22	AAT	Stock	38.25	39.01	38.24	38.61	216100.0
2021-09-22	AATC	Stock	7.49	7.85	7.49	7.71	23590.0
2021-09-22	AAU-DELISTED	Stock	0.3988	0.41	0.3966	0.407	481060.0
2021-09-22	AAUAF-DELISTED	Stock	0.3988	0.41	0.3966	0.4065	489118.0
2021-09-22	AAWW-DELISTED	Stock	73.29	76.66	72.43	73.96	389130.0
2021-09-22	AAXJ	Stock	85.7	86.67	85.7	86.17	1685512.0
2021-09-22	AB	Stock	50.1	51.18	50.1	50.82	219200.0
2021-09-22	ABB-DELISTED	Stock	35.16	35.45	35.13	35.2	1201734.0
2021-09-22	ABBNY-DELISTED	Stock	35.16	35.45	35.13	35.2	1329946.0
2021-09-22	ABBV	Stock	107.01	107.58	105.93	106.41	6319100.0
2021-09-22	ABC-DELISTED	Stock	122.16	123.33	121.73	122.1	657012.0
2021-09-22	ABCB	Stock	47.44	48.05	46.86	47.44	229100.0
2021-09-22	ABCL	Stock	21.21	21.62	20.62	21.34	3220900.0
2021-09-22	ABCM-DELISTED	Stock	20.97	21.28	20.82	21.06	39917.0
2021-09-22	ABEO	Stock	29.75	31.0	29.25	29.75	21572.0
2021-09-22	ABEV	Stock	2.95	2.97	2.91	2.92	17721000.0
2021-09-22	ABG	Stock	183.5	188.36	182.17	185.71	181900.0
2021-09-22	ABGI-DELISTED	Stock	9.73	9.75	9.705	9.72	84895.0
2021-09-22	ABM	Stock	44.33	44.82	44.32	44.44	200200.0
2021-09-22	ABMD-DELISTED	Stock	345.88	349.63	342.58	348.52	101376.0
2021-09-22	ABNB	Stock	170.029	171.81	167.371	169.96	4353600.0
2021-09-22	ABOS	Stock	15.01	15.88	15.01	15.53	105700.0

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

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