PREVIEW / stock_daily / 2021-07-28

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-28.parquet
  size:    256 KB
  rows:    7,851
  symbols: 2,783

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-28	AAPL	Stock	144.81	146.97	142.54	144.98	118931200.0
2021-07-28	MSFT	Stock	288.99	290.15	283.83	286.22	33566900.0
2021-07-28	NVDA	Stock	19.319	19.646	18.995	19.503	202191000.0
2021-07-28	AMZN	Stock	181.689	182.921	180.05	181.516	59988000.0
2021-07-28	GOOGL	Stock	136.312	138.297	135.2775	136.094	95130600.0
2021-07-28	META	Stock	374.56	377.55	366.93	373.28	29676900.0
2021-07-28	TSLA	Stock	215.6667	218.3233	213.1333	215.66	48019800.0
2021-07-28	TLT	Stock	148.67	149.67	148.27	149.65	14346869.0
2021-07-28	ES	Stock	87.28	87.88	85.75	86.38	1465600.0
2021-07-28	CL	Stock	84.01	84.26	83.14	83.18	3110700.0
2021-07-28	A	Stock	150.0	151.97	149.5	151.46	2179700.0
2021-07-28	AA	Stock	38.56	38.92	37.807	38.23	6217500.0
2021-07-28	AAC-DELISTED	Stock	9.76	9.76	9.745	9.76	5070.0
2021-07-28	AACG	Stock	3.26	3.3	3.08	3.3	104500.0
2021-07-28	AAIC-DELISTED	Stock	3.92	4.06	3.87	3.97	775648.0
2021-07-28	AAIC.C-DELISTED	Stock	25.1499	25.16	25.0901	25.16	1143.0
2021-07-28	AAL	Stock	21.61	21.79	21.23	21.63	20077400.0
2021-07-28	AAM.A-DELISTED	Stock	26.5	26.5	26.23	26.34	5734.0
2021-07-28	AAM.B-DELISTED	Stock	27.0576	27.06	26.9235	27.0414	5967.0
2021-07-28	AAMC-DELISTED	Stock	4.5794	4.8068	4.4324	4.45	206910.0
2021-07-28	AAME	Stock	4.09	4.19	3.97	4.17	19700.0
2021-07-28	AAMI	Stock	24.45	24.75	24.07	24.45	417300.0
2021-07-28	AAN-DELISTED	Stock	30.56	30.56	28.54	28.64	408000.0
2021-07-28	AAOI	Stock	7.3	7.61	7.3	7.55	451100.0
2021-07-28	AAON	Stock	40.1667	40.9533	39.6067	40.56	144750.0
2021-07-28	AAP	Stock	215.69	216.55	212.07	212.25	496400.0
2021-07-28	AAQC-DELISTED	Stock	9.68	9.68	9.68	9.68	3200.0
2021-07-28	AAT	Stock	36.92	37.58	36.65	37.15	393600.0
2021-07-28	AATC	Stock	6.41	7.35	6.41	7.0	195632.0
2021-07-28	AAU-DELISTED	Stock	0.4076	0.415	0.404	0.4149	428508.0
2021-07-28	AAUAF-DELISTED	Stock	0.4076	0.42	0.404	0.42	442954.0
2021-07-28	AAWW-DELISTED	Stock	66.38	66.98	65.16	66.45	134664.0
2021-07-28	AAXJ	Stock	86.57	88.13	86.49	87.94	2643112.0
2021-07-28	AB	Stock	46.46	46.81	45.78	46.47	201200.0
2021-07-28	ABB-DELISTED	Stock	36.66	36.9	36.54	36.83	1303289.0
2021-07-28	ABBNY-DELISTED	Stock	36.66	36.9	36.54	36.84	1401140.0
2021-07-28	ABBV	Stock	117.63	118.93	117.3	118.55	5650400.0
2021-07-28	ABC-DELISTED	Stock	121.4	121.66	120.33	121.3	383032.0
2021-07-28	ABCB	Stock	48.45	49.4	47.6	48.92	568700.0
2021-07-28	ABCL	Stock	14.95	16.43	14.93	16.08	1990700.0
2021-07-28	ABCM-DELISTED	Stock	18.18	18.84	18.175	18.78	89497.0
2021-07-28	ABEO	Stock	32.0	33.5	30.75	32.0	77844.0
2021-07-28	ABEV	Stock	3.24	3.33	3.21	3.32	33104300.0
2021-07-28	ABG	Stock	200.0	201.12	192.56	194.61	139100.0
2021-07-28	ABGI-DELISTED	Stock	9.7	9.79	9.7	9.77	107552.0
2021-07-28	ABM	Stock	46.04	47.02	45.62	46.5	306500.0
2021-07-28	ABMD-DELISTED	Stock	320.51	325.125	320.51	323.64	77788.0
2021-07-28	ABNB	Stock	141.31	143.73	141.03	143.3	4466800.0
2021-07-28	ABOS	Stock	14.61	15.76	13.95	14.9	291500.0
2021-07-28	ABR	Stock	17.98	18.19	17.8	18.03	1205600.0

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

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