PREVIEW / stock_daily / 2020-08-06

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-06.parquet
  size:    223 KB
  rows:    6,737
  symbols: 2,383

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-08-06	AAPL	Stock	110.405	114.4125	109.7975	113.9025	202428800.0
2020-08-06	MSFT	Stock	212.34	216.37	211.55	216.35	32656800.0
2020-08-06	NVDA	Stock	11.3498	11.358	11.1788	11.3355	244316000.0
2020-08-06	AMZN	Stock	159.718	162.3735	158.2715	161.25	78812000.0
2020-08-06	GOOGL	Stock	73.8075	75.3135	73.595	75.2475	33305220.0
2020-08-06	META	Stock	249.04	266.6	248.67	265.28	45241600.0
2020-08-06	TSLA	Stock	99.3887	101.154	98.484	99.3053	89884500.0
2020-08-06	TLT	Stock	171.38	172.25	170.62	171.02	9481800.0
2020-08-06	ES	Stock	87.95	88.51	87.08	88.1	1320800.0
2020-08-06	CL	Stock	75.92	76.1	75.6	75.86	3156100.0
2020-08-06	A	Stock	97.72	98.25	95.81	97.45	1075300.0
2020-08-06	AA	Stock	14.73	15.5	14.32	14.9	10031600.0
2020-08-06	AACG	Stock	1.26	1.31	1.24	1.27	34500.0
2020-08-06	AACQU-DELISTED	Stock	10.1	10.16	10.05	10.1	213337.0
2020-08-06	AAIC-DELISTED	Stock	2.8	2.82	2.725	2.73	203614.0
2020-08-06	AAL	Stock	13.04	13.29	12.47	13.04	131280100.0
2020-08-06	AAM.A-DELISTED	Stock	26.95	26.99	26.9	26.9125	3784.0
2020-08-06	AAM.B-DELISTED	Stock	27.4001	27.55	27.35	27.43	8747.0
2020-08-06	AAMC-DELISTED	Stock	3.9265	4.0	3.8403	3.9147	7065.0
2020-08-06	AAME	Stock	1.93	1.93	1.84	1.86	2200.0
2020-08-06	AAMI	Stock	13.75	13.78	13.33	13.69	583700.0
2020-08-06	AAOI	Stock	16.04	16.04	14.922	15.05	1921100.0
2020-08-06	AAON	Stock	38.0	38.3267	36.0067	37.9467	722100.0
2020-08-06	AAP	Stock	150.95	152.79	150.6	151.83	396400.0
2020-08-06	AAT	Stock	26.84	27.4	26.79	27.12	177400.0
2020-08-06	AAU-DELISTED	Stock	0.78	0.7898	0.725	0.7589	749492.0
2020-08-06	AAUAF-DELISTED	Stock	0.78	0.7898	0.725	0.7722	768276.0
2020-08-06	AAWW-DELISTED	Stock	60.0	61.19	53.05	56.15	1209437.0
2020-08-06	AAXJ	Stock	77.13	77.59	76.86	77.59	1477977.0
2020-08-06	AAXN-DELISTED	Stock	92.55	93.71	91.06	91.52	703109.0
2020-08-06	AB	Stock	27.81	27.95	27.31	27.41	229500.0
2020-08-06	ABB-DELISTED	Stock	25.82	26.03	25.765	26.025	1051997.0
2020-08-06	ABBNY-DELISTED	Stock	25.82	26.03	25.765	26.03	1122580.0
2020-08-06	ABBV	Stock	93.32	93.65	91.78	92.57	7269300.0
2020-08-06	ABC-DELISTED	Stock	103.71	103.81	100.95	101.6	580769.0
2020-08-06	ABCB	Stock	24.23	24.64	24.01	24.38	342500.0
2020-08-06	ABEO	Stock	74.25	74.5	71.0	71.5	13828.0
2020-08-06	ABEV	Stock	2.46	2.52	2.44	2.49	40796500.0
2020-08-06	ABG	Stock	105.76	106.04	103.57	103.91	174700.0
2020-08-06	ABM	Stock	37.13	37.91	37.13	37.88	247100.0
2020-08-06	ABMD-DELISTED	Stock	317.09	318.46	308.4844	314.76	267938.0
2020-08-06	ABR	Stock	10.65	10.9	10.65	10.68	1491100.0
2020-08-06	ABR.A-DELISTED	Stock	25.36	25.45	25.277	25.42	1897.0
2020-08-06	ABR.B-DELISTED	Stock	24.6393	24.76	24.6	24.6	5280.0
2020-08-06	ABR.C-DELISTED	Stock	25.69	25.86	25.4823	25.6	3165.0
2020-08-06	ABT	Stock	101.52	101.8	99.92	101.75	3943000.0
2020-08-06	ABTC	Stock	197700.0	206100.0	192900.0	199800.0	1.8133333333333332
2020-08-06	ABTS	Stock	17.55	17.85	16.65	17.7	12673.0
2020-08-06	ABTX-DELISTED	Stock	24.99	25.21	24.405	24.85	70360.0
2020-08-06	ABUS	Stock	4.44	4.89	4.25	4.37	8859000.0

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

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