PREVIEW / stock_daily / 2020-07-06

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-06.parquet
  size:    222 KB
  rows:    6,723
  symbols: 2,399

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-06	AAPL	Stock	92.5	93.945	92.4675	93.4625	118655600.0
2020-07-06	MSFT	Stock	208.83	211.13	208.09	210.7	31897600.0
2020-07-06	NVDA	Stock	9.7418	9.9088	9.7125	9.8392	315892000.0
2020-07-06	AMZN	Stock	146.7485	152.994	146.5	152.852	137612000.0
2020-07-06	GOOGL	Stock	74.4075	75.5	73.8488	74.9825	44712600.0
2020-07-06	META	Stock	233.76	240.4	232.27	240.28	26206200.0
2020-07-06	TSLA	Stock	85.1127	91.8527	84.4027	91.4387	308548500.0
2020-07-06	TLT	Stock	162.33	163.02	161.75	162.92	7972668.0
2020-07-06	ES	Stock	85.71	86.27	83.27	83.86	1534700.0
2020-07-06	CL	Stock	73.72	73.88	72.88	73.45	4026300.0
2020-07-06	A	Stock	89.02	90.64	89.02	89.31	1412200.0
2020-07-06	AA	Stock	11.35	11.575	11.02	11.47	7084300.0
2020-07-06	AACG	Stock	1.3	1.4	1.3	1.36	49200.0
2020-07-06	AAIC-DELISTED	Stock	2.99	2.99	2.865	2.96	347208.0
2020-07-06	AAIC.C-DELISTED	Stock	19.58	19.692	19.555	19.692	1815.0
2020-07-06	AAL	Stock	12.8	12.92	12.21	12.8	79312900.0
2020-07-06	AAM.A-DELISTED	Stock	25.95	26.1	25.91	26.1	22388.0
2020-07-06	AAM.B-DELISTED	Stock	26.38	26.39	26.2	26.37	39986.0
2020-07-06	AAMC-DELISTED	Stock	5.2088	5.3206	5.1089	5.2794	17541.0
2020-07-06	AAME	Stock	1.65	1.67	1.62	1.62	3100.0
2020-07-06	AAMI	Stock	13.04	13.04	12.66	12.81	793100.0
2020-07-06	AAOI	Stock	11.05	12.02	11.05	11.58	1390600.0
2020-07-06	AAON	Stock	36.3733	36.62	36.0467	36.3933	197850.0
2020-07-06	AAP	Stock	144.15	144.31	138.25	138.96	841300.0
2020-07-06	AAT	Stock	28.87	28.9	27.29	27.31	269600.0
2020-07-06	AAU-DELISTED	Stock	0.5	0.52	0.495	0.5084	275272.0
2020-07-06	AAUAF-DELISTED	Stock	0.5	0.52	0.495	0.5047	288747.0
2020-07-06	AAWW-DELISTED	Stock	44.98	45.59	44.705	45.37	220809.0
2020-07-06	AAXJ	Stock	74.51	75.28	74.44	75.27	1651784.0
2020-07-06	AAXN-DELISTED	Stock	101.99	102.4	98.85	99.61	498909.0
2020-07-06	AB	Stock	27.12	27.27	26.73	26.82	165700.0
2020-07-06	ABB-DELISTED	Stock	24.04	24.19	24.0	24.18	1877984.0
2020-07-06	ABBNY-DELISTED	Stock	24.04	24.19	24.0	24.18	2454042.0
2020-07-06	ABBV	Stock	99.64	99.8	97.95	99.01	7039000.0
2020-07-06	ABC-DELISTED	Stock	100.91	101.46	99.91	100.68	773077.0
2020-07-06	ABCB	Stock	22.81	23.22	21.98	22.43	368200.0
2020-07-06	ABEO	Stock	73.5	78.75	72.0	77.75	51584.0
2020-07-06	ABEV	Stock	2.71	2.73	2.67	2.69	23360900.0
2020-07-06	ABG	Stock	78.88	79.95	77.45	78.41	151800.0
2020-07-06	ABM	Stock	36.06	36.06	35.04	35.57	306700.0
2020-07-06	ABMD-DELISTED	Stock	267.57	272.56	263.81	266.22	351390.0
2020-07-06	ABR	Stock	9.09	9.09	8.54	8.66	1940300.0
2020-07-06	ABR.A-DELISTED	Stock	24.91	24.96	24.83	24.84	3067.0
2020-07-06	ABR.B-DELISTED	Stock	23.71	24.192	23.54	23.5695	5046.0
2020-07-06	ABR.C-DELISTED	Stock	25.025	25.114	24.6665	24.94	3398.0
2020-07-06	ABT	Stock	92.76	93.97	92.45	92.97	5919100.0
2020-07-06	ABTC	Stock	257100.0	257100.0	243300.0	246600.0	2.253333333333333
2020-07-06	ABTS	Stock	11.865	13.2	11.7	13.05	7280.0
2020-07-06	ABTX-DELISTED	Stock	24.49	24.63	23.63	23.78	34977.0
2020-07-06	ABUS	Stock	1.94	1.94	1.85	1.87	567700.0

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

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