PREVIEW / stock_daily / 2020-07-10

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-10.parquet
  size:    222 KB
  rows:    6,731
  symbols: 2,400

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-10	AAPL	Stock	95.335	95.98	94.705	95.92	90257200.0
2020-07-10	MSFT	Stock	213.62	214.08	211.08	213.67	26177600.0
2020-07-10	NVDA	Stock	10.5888	10.6552	10.3788	10.4792	497676000.0
2020-07-10	AMZN	Stock	159.588	160.75	156.785	160.0	109720000.0
2020-07-10	GOOGL	Stock	75.6625	77.067	75.036	76.9505	35921260.0
2020-07-10	META	Stock	243.69	245.49	239.32	245.07	22982700.0
2020-07-10	TSLA	Stock	93.0667	103.2613	91.734	102.9767	350064000.0
2020-07-10	TLT	Stock	167.95	168.21	166.16	166.33	8478375.0
2020-07-10	ES	Stock	84.57	85.71	84.06	85.44	724700.0
2020-07-10	CL	Stock	73.27	73.96	72.69	73.68	4418600.0
2020-07-10	A	Stock	89.85	89.87	88.57	89.42	938100.0
2020-07-10	AA	Stock	10.49	11.42	10.431	11.41	7890300.0
2020-07-10	AACG	Stock	1.49	1.6	1.43	1.44	179800.0
2020-07-10	AAIC-DELISTED	Stock	2.73	2.89	2.73	2.83	502654.0
2020-07-10	AAIC.C-DELISTED	Stock	19.63	19.63	19.52	19.54	3849.0
2020-07-10	AAL	Stock	11.0	11.95	10.98	11.94	90450800.0
2020-07-10	AAM.A-DELISTED	Stock	26.01	26.224	26.01	26.11	15422.0
2020-07-10	AAM.B-DELISTED	Stock	26.17	26.42	26.135	26.42	7975.0
2020-07-10	AAMC-DELISTED	Stock	4.8314	4.9941	4.8314	4.9912	6355.0
2020-07-10	AAME	Stock	1.64	1.69	1.63	1.68	2200.0
2020-07-10	AAMI	Stock	12.37	12.8	12.232	12.74	600300.0
2020-07-10	AAOI	Stock	12.0	12.06	11.22	11.51	884600.0
2020-07-10	AAON	Stock	35.6467	36.3133	35.2467	36.12	172950.0
2020-07-10	AAP	Stock	133.31	134.78	131.9	134.45	614900.0
2020-07-10	AAT	Stock	26.47	27.18	26.42	27.18	309700.0
2020-07-10	AAU-DELISTED	Stock	0.5	0.5199	0.49	0.5169	305443.0
2020-07-10	AAUAF-DELISTED	Stock	0.5	0.5199	0.49	0.5195	312696.0
2020-07-10	AAWW-DELISTED	Stock	46.36	47.45	46.12	47.19	238301.0
2020-07-10	AAXJ	Stock	75.25	75.3	74.65	75.09	2988004.0
2020-07-10	AAXN-DELISTED	Stock	96.14	97.85	95.34	95.74	319773.0
2020-07-10	AB	Stock	26.8	27.39	26.68	26.91	142400.0
2020-07-10	ABB-DELISTED	Stock	24.33	24.505	24.21	24.5	1786921.0
2020-07-10	ABBNY-DELISTED	Stock	24.33	24.505	24.21	24.49	1867965.0
2020-07-10	ABBV	Stock	98.06	98.33	96.36	96.83	6202500.0
2020-07-10	ABC-DELISTED	Stock	95.98	97.58	95.475	97.05	641996.0
2020-07-10	ABCB	Stock	20.46	21.63	20.39	21.55	403800.0
2020-07-10	ABEO	Stock	80.75	81.75	72.5	75.25	73640.0
2020-07-10	ABEV	Stock	2.75	2.84	2.74	2.83	27799300.0
2020-07-10	ABG	Stock	88.74	92.1	87.56	92.0	246000.0
2020-07-10	ABM	Stock	32.05	33.31	31.98	33.03	399500.0
2020-07-10	ABMD-DELISTED	Stock	265.45	266.3	261.47	264.58	81035.0
2020-07-10	ABR	Stock	7.54	7.94	7.4	7.94	1762300.0
2020-07-10	ABR.A-DELISTED	Stock	24.7399	24.74	24.412	24.55	5805.0
2020-07-10	ABR.B-DELISTED	Stock	23.33	23.8	23.31	23.6109	2363.0
2020-07-10	ABR.C-DELISTED	Stock	24.92	25.0987	24.64	25.0987	1374.0
2020-07-10	ABT	Stock	93.47	93.8	92.32	93.04	2923200.0
2020-07-10	ABTC	Stock	216300.0	229800.0	213000.0	225300.0	2.7733333333333334
2020-07-10	ABTS	Stock	15.75	16.2	14.58	15.75	3887.0
2020-07-10	ABTX-DELISTED	Stock	21.77	22.66	21.75	22.66	24743.0
2020-07-10	ABUS	Stock	1.85	1.91	1.83	1.86	363700.0

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

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