PREVIEW / stock_daily / 2020-06-26

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-26.parquet
  size:    223 KB
  rows:    6,717
  symbols: 2,405

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-06-26	AAPL	Stock	91.1025	91.33	88.255	88.4075	205256800.0
2020-06-26	MSFT	Stock	199.73	199.89	194.88	196.33	54675800.0
2020-06-26	NVDA	Stock	9.5	9.5	9.125	9.155	592084000.0
2020-06-26	AMZN	Stock	138.753	139.1285	134.4	134.6435	130016000.0
2020-06-26	GOOGL	Stock	71.6315	71.851	67.75	68.127	97640280.0
2020-06-26	META	Stock	232.64	233.09	215.4	216.08	76343900.0
2020-06-26	TSLA	Stock	66.3187	66.3333	63.658	63.9827	132823500.0
2020-06-26	TLT	Stock	164.25	165.32	164.18	165.25	12119310.0
2020-06-26	ES	Stock	82.04	83.5	81.21	81.85	2895300.0
2020-06-26	CL	Stock	72.66	72.92	71.21	71.52	5402400.0
2020-06-26	A	Stock	87.23	87.56	85.52	85.9	2225800.0
2020-06-26	AA	Stock	11.61	11.7	10.87	10.93	25817600.0
2020-06-26	AACG	Stock	1.12	1.18	1.12	1.15	43700.0
2020-06-26	AAIC-DELISTED	Stock	2.84	2.87	2.78	2.85	990833.0
2020-06-26	AAIC.C-DELISTED	Stock	19.65	19.85	19.65	19.85	5459.0
2020-06-26	AAL	Stock	13.2	13.29	12.13	12.38	108813000.0
2020-06-26	AAM.A-DELISTED	Stock	26.08	26.08	25.53	25.55	12172.0
2020-06-26	AAM.B-DELISTED	Stock	25.9	25.94	25.58	25.69	24055.0
2020-06-26	AAMC-DELISTED	Stock	4.8765	4.9971	4.6559	4.6559	16327.0
2020-06-26	AAME	Stock	1.84	1.84	1.67	1.67	16000.0
2020-06-26	AAMI	Stock	9.93	12.94	9.65	11.88	8466300.0
2020-06-26	AAOI	Stock	9.35	9.41	9.14	9.31	473300.0
2020-06-26	AAON	Stock	35.2267	35.2267	33.6933	33.82	577500.0
2020-06-26	AAP	Stock	142.97	143.87	139.59	139.99	1079400.0
2020-06-26	AAT	Stock	27.61	28.12	27.21	27.89	1626700.0
2020-06-26	AAU-DELISTED	Stock	0.4853	0.492	0.46	0.474	289176.0
2020-06-26	AAUAF-DELISTED	Stock	0.4853	0.492	0.46	0.4691	293821.0
2020-06-26	AAWW-DELISTED	Stock	40.05	40.11	38.36	39.06	459404.0
2020-06-26	AAXJ	Stock	69.78	69.78	68.86	69.2	492938.0
2020-06-26	AAXN-DELISTED	Stock	95.88	97.72	94.17	95.9	5981014.0
2020-06-26	AB	Stock	25.53	25.65	24.88	25.31	261500.0
2020-06-26	ABB-DELISTED	Stock	22.17	22.17	21.665	21.72	4244710.0
2020-06-26	ABBNY-DELISTED	Stock	22.15	22.17	21.665	21.71	4408618.0
2020-06-26	ABBV	Stock	96.89	97.03	95.04	96.13	14568400.0
2020-06-26	ABC-DELISTED	Stock	100.47	100.949	98.2	99.18	2013958.0
2020-06-26	ABCB	Stock	23.05	23.05	21.23	21.28	1492000.0
2020-06-26	ABEO	Stock	73.5	75.25	69.25	70.25	68800.0
2020-06-26	ABEV	Stock	2.64	2.65	2.55	2.55	24721100.0
2020-06-26	ABG	Stock	73.75	75.16	72.34	73.09	481100.0
2020-06-26	ABM	Stock	35.64	35.68	34.88	34.97	721100.0
2020-06-26	ABMD-DELISTED	Stock	243.34	243.34	237.6	239.53	340243.0
2020-06-26	ABR	Stock	10.0	10.08	9.21	9.26	14021500.0
2020-06-26	ABR.A-DELISTED	Stock	24.28	24.28	24.28	24.28	199.0
2020-06-26	ABR.B-DELISTED	Stock	23.96	23.98	23.32	23.39	4000.0
2020-06-26	ABR.C-DELISTED	Stock	25.15	25.248	25.15	25.248	300.0
2020-06-26	ABT	Stock	89.82	89.95	87.94	88.71	8522500.0
2020-06-26	ABTC	Stock	282000.0	295500.0	264000.0	267300.0	32.4
2020-06-26	ABTS	Stock	13.095	14.25	12.525	12.525	5873.0
2020-06-26	ABTX-DELISTED	Stock	24.14	24.28	23.14	23.31	74208.0
2020-06-26	ABUS	Stock	2.1	2.15	1.91	1.93	1416900.0

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

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