PREVIEW / stock_daily / 2021-07-08

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-08.parquet
  size:    257 KB
  rows:    7,843
  symbols: 2,837

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-07-08	AAPL	Stock	141.58	144.06	140.67	143.24	105575500.0
2021-07-08	MSFT	Stock	276.9	278.73	274.87	277.42	24618600.0
2021-07-08	NVDA	Stock	19.8565	20.133	19.7008	19.9028	503300000.0
2021-07-08	AMZN	Stock	182.178	187.9995	181.056	186.5705	103612000.0
2021-07-08	GOOGL	Stock	124.026	125.5955	124.022	125.044	23789340.0
2021-07-08	META	Stock	345.73	348.33	342.56	345.65	14406500.0
2021-07-08	TSLA	Stock	209.4567	218.1433	206.82	217.6033	68319900.0
2021-07-08	TLT	Stock	148.88	149.44	148.17	148.62	17487838.0
2021-07-08	ES	Stock	82.47	83.44	82.26	82.61	1779600.0
2021-07-08	CL	Stock	82.58	83.0	82.05	82.34	3514800.0
2021-07-08	A	Stock	148.07	148.96	147.28	148.83	1891700.0
2021-07-08	AA	Stock	35.0	36.09	34.08	35.36	6245400.0
2021-07-08	AAC-DELISTED	Stock	9.7406	9.79	9.74	9.76	72484.0
2021-07-08	AACG	Stock	2.66	2.8	2.58	2.66	50700.0
2021-07-08	AAIC-DELISTED	Stock	3.75	3.85	3.65	3.83	330970.0
2021-07-08	AAIC.C-DELISTED	Stock	24.86	25.25	24.86	25.2499	2950.0
2021-07-08	AAL	Stock	19.88	20.64	19.66	20.35	28539300.0
2021-07-08	AAM.A-DELISTED	Stock	26.54	26.59	26.38	26.55	20472.0
2021-07-08	AAM.B-DELISTED	Stock	26.95	27.16	26.95	27.04	8904.0
2021-07-08	AAMC-DELISTED	Stock	5.3441	5.65	5.1441	5.2441	186752.0
2021-07-08	AAME	Stock	4.46	4.46	4.22	4.38	105300.0
2021-07-08	AAMI	Stock	23.61	24.01	23.321	23.68	379000.0
2021-07-08	AAN-DELISTED	Stock	30.01	30.9	28.97	29.83	544200.0
2021-07-08	AAOI	Stock	7.66	7.862	7.56	7.76	561800.0
2021-07-08	AAON	Stock	41.4533	42.48	41.28	41.82	231150.0
2021-07-08	AAP	Stock	206.87	209.7	205.46	207.51	661100.0
2021-07-08	AAQC-DELISTED	Stock	9.65	9.68	9.65	9.68	27707.0
2021-07-08	AAT	Stock	36.55	36.99	36.0	36.59	444300.0
2021-07-08	AAU-DELISTED	Stock	0.467	0.4718	0.455	0.4571	643427.0
2021-07-08	AAUAF-DELISTED	Stock	0.467	0.4718	0.455	0.4571	692683.0
2021-07-08	AAWW-DELISTED	Stock	65.14	66.58	63.665	65.67	195738.0
2021-07-08	AAXJ	Stock	89.97	90.33	89.75	90.09	1058453.0
2021-07-08	AB	Stock	45.03	45.27	44.34	44.88	456700.0
2021-07-08	ABB-DELISTED	Stock	34.92	35.41	34.81	35.17	1366596.0
2021-07-08	ABBNY-DELISTED	Stock	34.92	35.41	34.81	35.17	1475137.0
2021-07-08	ABBV	Stock	115.76	116.81	115.68	116.35	3948800.0
2021-07-08	ABC-DELISTED	Stock	114.16	114.84	113.255	114.51	432412.0
2021-07-08	ABCB	Stock	47.15	47.94	46.38	47.64	622300.0
2021-07-08	ABCL	Stock	18.49	18.77	17.88	18.52	1897200.0
2021-07-08	ABCM-DELISTED	Stock	18.99	19.08	18.9	19.01	110839.0
2021-07-08	ABEO	Stock	34.5	37.25	34.5	36.75	22088.0
2021-07-08	ABEV	Stock	3.32	3.34	3.26	3.32	12701100.0
2021-07-08	ABG	Stock	171.22	181.13	169.94	177.45	214500.0
2021-07-08	ABM	Stock	42.34	42.84	41.96	42.57	562400.0
2021-07-08	ABMD-DELISTED	Stock	331.86	331.86	322.0	325.4	145124.0
2021-07-08	ABNB	Stock	140.43	143.73	139.53	142.53	4827200.0
2021-07-08	ABOS	Stock	18.55	18.62	17.03	17.78	120800.0
2021-07-08	ABR	Stock	17.43	17.7	17.07	17.45	1429100.0
2021-07-08	ABR.D	Stock	25.38	25.4994	25.38	25.46	274453.0
2021-07-08	ABST-DELISTED	Stock	14.05	14.17	13.81	14.03	75315.0

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

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