PREVIEW / stock_daily / 2021-12-14

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-14.parquet
  size:    262 KB
  rows:    8,032
  symbols: 2,667

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-14	AAPL	Stock	175.25	177.74	172.21	174.33	139380400.0
2021-12-14	MSFT	Stock	333.22	334.64	324.11	328.34	44438700.0
2021-12-14	NVDA	Stock	27.699	28.678	27.25	28.337	667035000.0
2021-12-14	AMZN	Stock	167.55	169.499	166.44	169.0915	55976000.0
2021-12-14	GOOGL	Stock	143.968	144.48	141.2148	143.907	38446240.0
2021-12-14	META	Stock	328.05	335.7	327.65	333.74	20461000.0
2021-12-14	TSLA	Stock	315.0	322.1367	310.0	319.5033	70806300.0
2021-12-14	TLT	Stock	150.37	150.93	149.31	150.7	14015451.0
2021-12-14	ES	Stock	89.46	89.89	88.7	89.26	1078200.0
2021-12-14	CL	Stock	81.2	82.34	81.07	82.13	7682500.0
2021-12-14	A	Stock	154.89	155.74	150.1	151.88	1869100.0
2021-12-14	AA	Stock	48.96	51.08	48.41	50.46	14668200.0
2021-12-14	AAC-DELISTED	Stock	9.8	9.8	9.78	9.79	2100997.0
2021-12-14	AACG	Stock	1.42	1.49	1.35	1.42	10700.0
2021-12-14	AACIW-DELISTED	Stock	0.4501	0.5001	0.4501	0.5	21030.0
2021-12-14	AAIC-DELISTED	Stock	3.63	3.67	3.57	3.58	75214.0
2021-12-14	AAL	Stock	16.82	17.47	16.81	16.91	30171300.0
2021-12-14	AAM.A-DELISTED	Stock	25.39	25.43	25.3201	25.42	17936.0
2021-12-14	AAM.B-DELISTED	Stock	26.04	26.24	26.02	26.24	19715.0
2021-12-14	AAME	Stock	3.78	3.78	3.61	3.61	3600.0
2021-12-14	AAMI	Stock	28.08	28.14	27.38	27.41	1638500.0
2021-12-14	AAN-DELISTED	Stock	23.3	24.16	23.25	23.56	349500.0
2021-12-14	AAOI	Stock	5.6	5.71	5.54	5.61	396400.0
2021-12-14	AAON	Stock	53.66	54.1333	52.3867	52.54	199800.0
2021-12-14	AAP	Stock	234.17	236.31	233.15	235.39	791600.0
2021-12-14	AAQC-DELISTED	Stock	9.72	9.74	9.71	9.72	471088.0
2021-12-14	AAT	Stock	35.53	35.88	34.83	35.01	323600.0
2021-12-14	AATC	Stock	6.52	6.6099	6.51	6.6	12071.0
2021-12-14	AAU-DELISTED	Stock	0.29	0.3015	0.29	0.2953	646290.0
2021-12-14	AAUAF-DELISTED	Stock	0.29	0.3015	0.29	0.2953	649397.0
2021-12-14	AAWW-DELISTED	Stock	85.69	87.99	85.195	87.5	294634.0
2021-12-14	AAXJ	Stock	82.05	82.47	81.8901	82.37	1833290.0
2021-12-14	AB	Stock	49.5	49.9	47.7	48.36	545600.0
2021-12-14	ABB-DELISTED	Stock	36.76	36.85	35.96	36.19	1215025.0
2021-12-14	ABBNY-DELISTED	Stock	36.76	36.85	35.96	36.18	1347876.0
2021-12-14	ABBV	Stock	125.7	127.85	125.38	127.29	6381400.0
2021-12-14	ABC-DELISTED	Stock	122.23	125.15	122.23	123.31	779231.0
2021-12-14	ABCB	Stock	49.07	50.68	48.78	49.3	605700.0
2021-12-14	ABCL	Stock	13.53	13.75	13.12	13.16	2010200.0
2021-12-14	ABCM-DELISTED	Stock	21.51	22.83	21.46	22.35	227471.0
2021-12-14	ABEO	Stock	13.25	13.75	12.75	13.0	59288.0
2021-12-14	ABEV	Stock	2.88	2.89	2.8	2.83	18853900.0
2021-12-14	ABG	Stock	165.8	171.3	165.7	167.71	207000.0
2021-12-14	ABGI-DELISTED	Stock	9.74	9.77	9.74	9.77	20100.0
2021-12-14	ABM	Stock	45.52	46.7	45.35	45.94	555900.0
2021-12-14	ABMD-DELISTED	Stock	310.0	313.98	306.6	311.64	136315.0
2021-12-14	ABNB	Stock	168.298	169.91	164.5	167.96	5660400.0
2021-12-14	ABOS	Stock	6.66	6.96	6.4	6.54	101600.0
2021-12-14	ABR	Stock	17.87	18.0	17.46	17.49	1676300.0
2021-12-14	ABR.D	Stock	25.1999	25.205	25.07	25.18	9992.0

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

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