PREVIEW / stock_daily / 2021-07-14

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-14.parquet
  size:    258 KB
  rows:    7,893
  symbols: 2,853

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-14	AAPL	Stock	148.1	149.57	147.68	149.15	127050800.0
2021-07-14	MSFT	Stock	282.35	283.66	280.55	282.51	23113700.0
2021-07-14	NVDA	Stock	20.3578	20.4178	19.7528	19.8415	380100000.0
2021-07-14	AMZN	Stock	185.4425	185.883	183.0415	184.084	65932000.0
2021-07-14	GOOGL	Stock	127.958	129.3263	127.9145	128.237	23745660.0
2021-07-14	META	Stock	354.56	355.2	346.73	347.63	13894200.0
2021-07-14	TSLA	Stock	223.5833	226.2033	217.6133	217.7933	64923600.0
2021-07-14	TLT	Stock	146.01	146.92	145.81	146.87	16038556.0
2021-07-14	ES	Stock	82.77	84.46	82.36	84.04	1661200.0
2021-07-14	CL	Stock	82.63	83.38	82.28	83.23	2959200.0
2021-07-14	A	Stock	149.86	149.87	148.46	148.63	1218500.0
2021-07-14	AA	Stock	36.25	36.9	34.94	35.14	6964600.0
2021-07-14	AAC-DELISTED	Stock	9.82	9.82	9.76	9.76	11002.0
2021-07-14	AACG	Stock	2.84	3.25	2.8	2.98	438700.0
2021-07-14	AAIC-DELISTED	Stock	3.82	3.85	3.77	3.78	128885.0
2021-07-14	AAIC.C-DELISTED	Stock	25.2702	25.2702	25.2702	25.2702	200.0
2021-07-14	AAL	Stock	20.87	21.57	20.43	20.62	55139500.0
2021-07-14	AAM.A-DELISTED	Stock	26.63	26.63	26.5	26.63	10180.0
2021-07-14	AAM.B-DELISTED	Stock	26.9	27.06	26.87	27.06	9598.0
2021-07-14	AAME	Stock	4.38	4.38	4.23	4.32	24900.0
2021-07-14	AAMI	Stock	23.94	24.2	23.48	23.51	474200.0
2021-07-14	AAN-DELISTED	Stock	29.37	29.899	28.63	28.73	249100.0
2021-07-14	AAOI	Stock	7.87	7.96	7.62	7.62	425900.0
2021-07-14	AAON	Stock	41.1333	41.3133	40.58	40.8133	122400.0
2021-07-14	AAP	Stock	210.05	210.83	208.5	210.16	619500.0
2021-07-14	AAQC-DELISTED	Stock	9.67	9.72	9.67	9.71	11870.0
2021-07-14	AAT	Stock	37.11	37.56	36.9	37.25	284100.0
2021-07-14	AAU-DELISTED	Stock	0.48	0.481	0.4501	0.452	665500.0
2021-07-14	AAUAF-DELISTED	Stock	0.48	0.481	0.4501	0.4522	690043.0
2021-07-14	AAWW-DELISTED	Stock	67.18	67.85	66.2	66.53	129848.0
2021-07-14	AAXJ	Stock	92.61	92.67	91.945	92.25	364745.0
2021-07-14	AB	Stock	46.01	46.17	45.18	45.74	113900.0
2021-07-14	ABB-DELISTED	Stock	35.72	35.795	35.61	35.76	842276.0
2021-07-14	ABBNY-DELISTED	Stock	35.72	35.795	35.61	35.75	1160301.0
2021-07-14	ABBV	Stock	116.87	117.55	116.39	117.36	6543400.0
2021-07-14	ABC-DELISTED	Stock	114.02	114.33	113.28	113.555	435741.0
2021-07-14	ABCB	Stock	48.77	49.4	47.52	47.82	290900.0
2021-07-14	ABCL	Stock	17.83	18.07	16.75	16.88	2871600.0
2021-07-14	ABCM-DELISTED	Stock	18.87	18.87	18.27	18.3	96398.0
2021-07-14	ABEO	Stock	34.0	34.75	33.25	33.75	20164.0
2021-07-14	ABEV	Stock	3.53	3.55	3.47	3.47	21860300.0
2021-07-14	ABG	Stock	190.88	194.98	188.58	188.8	197800.0
2021-07-14	ABGI-DELISTED	Stock	9.8	9.88	9.79	9.88	4237.0
2021-07-14	ABM	Stock	44.46	45.32	44.15	45.06	754900.0
2021-07-14	ABMD-DELISTED	Stock	319.5	321.12	311.59	312.32	76973.0
2021-07-14	ABNB	Stock	143.86	144.2	139.04	139.09	8545500.0
2021-07-14	ABOS	Stock	18.6	19.1	18.001	18.34	120300.0
2021-07-14	ABR	Stock	18.06	18.24	17.67	17.71	1245500.0
2021-07-14	ABR.D	Stock	25.38	25.45	25.33	25.43	34167.0
2021-07-14	ABST-DELISTED	Stock	14.07	14.12	13.71	13.735	55402.0

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

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