PREVIEW / stock_daily / 2020-07-14

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-14.parquet
  size:    222 KB
  rows:    6,742
  symbols: 2,409

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
2020-07-14	AAPL	Stock	94.84	97.255	93.8775	97.0575	170989200.0
2020-07-14	MSFT	Stock	206.13	208.85	202.03	208.35	37591800.0
2020-07-14	NVDA	Stock	10.075	10.4028	9.7855	10.377	542676000.0
2020-07-14	AMZN	Stock	154.45	156.369	147.5	154.2	144638000.0
2020-07-14	GOOGL	Stock	74.6395	76.14	74.2962	76.043	38108000.0
2020-07-14	META	Stock	236.76	240.33	232.03	239.73	23378100.0
2020-07-14	TSLA	Stock	103.7333	106.0	95.4	101.12	351271500.0
2020-07-14	TLT	Stock	167.93	168.14	166.98	167.12	11344635.0
2020-07-14	ES	Stock	86.03	86.89	85.41	86.42	1566600.0
2020-07-14	CL	Stock	73.3	74.92	73.28	74.85	3181600.0
2020-07-14	A	Stock	88.83	90.79	88.07	90.69	1361200.0
2020-07-14	AA	Stock	11.38	12.7	11.24	12.61	11441100.0
2020-07-14	AACG	Stock	1.54	1.59	1.48	1.58	85500.0
2020-07-14	AACQU-DELISTED	Stock	10.42	10.44	10.3	10.35	17017787.0
2020-07-14	AAIC-DELISTED	Stock	2.87	2.96	2.845	2.94	207909.0
2020-07-14	AAIC.C-DELISTED	Stock	19.0502	19.0502	18.76	18.9	940.0
2020-07-14	AAL	Stock	11.32	11.84	11.22	11.57	49888200.0
2020-07-14	AAM.A-DELISTED	Stock	26.11	26.23	26.105	26.19	8439.0
2020-07-14	AAM.B-DELISTED	Stock	26.53	26.6	26.4795	26.55	15159.0
2020-07-14	AAMC-DELISTED	Stock	4.9192	4.9192	4.2941	4.2941	25867.0
2020-07-14	AAME	Stock	1.63	1.69	1.59	1.69	3600.0
2020-07-14	AAMI	Stock	12.25	12.39	11.93	12.11	779700.0
2020-07-14	AAOI	Stock	10.8	10.835	10.12	10.71	645400.0
2020-07-14	AAON	Stock	36.5733	37.5533	36.04	37.4933	359250.0
2020-07-14	AAP	Stock	134.97	139.58	133.54	138.58	1069800.0
2020-07-14	AAT	Stock	26.68	26.95	25.92	26.37	254500.0
2020-07-14	AAU-DELISTED	Stock	0.52	0.52	0.49	0.5197	339231.0
2020-07-14	AAUAF-DELISTED	Stock	0.52	0.52	0.49	0.5155	411310.0
2020-07-14	AAWW-DELISTED	Stock	47.57	47.71	46.13	47.64	185652.0
2020-07-14	AAXJ	Stock	73.9	74.9	73.73	74.72	989262.0
2020-07-14	AAXN-DELISTED	Stock	90.75	92.86	87.75	92.82	492321.0
2020-07-14	AB	Stock	27.34	27.99	27.1	27.87	574200.0
2020-07-14	ABB-DELISTED	Stock	24.18	24.87	24.17	24.83	3706137.0
2020-07-14	ABBNY-DELISTED	Stock	24.18	24.87	24.17	24.83	4520129.0
2020-07-14	ABBV	Stock	96.97	99.1	95.94	98.87	6765600.0
2020-07-14	ABC-DELISTED	Stock	96.85	99.47	96.85	99.35	558325.0
2020-07-14	ABCB	Stock	21.56	21.72	20.71	21.01	392000.0
2020-07-14	ABEO	Stock	71.0	71.5	68.25	70.75	52756.0
2020-07-14	ABEV	Stock	2.58	2.63	2.52	2.62	49673900.0
2020-07-14	ABG	Stock	89.95	97.23	89.95	97.09	251500.0
2020-07-14	ABM	Stock	33.66	34.39	33.21	33.9	293900.0
2020-07-14	ABMD-DELISTED	Stock	262.97	264.56	251.86	264.48	219892.0
2020-07-14	ABR	Stock	7.95	8.06	7.78	8.0	1234500.0
2020-07-14	ABR.A-DELISTED	Stock	24.49	24.78	24.186	24.5097	2700.0
2020-07-14	ABR.B-DELISTED	Stock	23.6201	23.78	23.29	23.4354	9280.0
2020-07-14	ABR.C-DELISTED	Stock	24.6025	24.88	24.6	24.88	828.0
2020-07-14	ABT	Stock	92.64	94.98	91.71	94.82	4122800.0
2020-07-14	ABTC	Stock	213300.0	216000.0	204000.0	210000.0	2.2133333333333334
2020-07-14	ABTS	Stock	15.9	16.35	15.0	16.2	4487.0
2020-07-14	ABTX-DELISTED	Stock	22.94	23.24	22.35	22.86	37586.0

> showing 50 of 6,742 rows — these rows as CSV

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