PREVIEW / stock_daily / 2020-07-07

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-07.parquet
  size:    222 KB
  rows:    6,706
  symbols: 2,381

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-07	AAPL	Stock	93.8525	94.655	93.0575	93.1725	112424400.0
2020-07-07	MSFT	Stock	210.45	214.67	207.99	208.25	33600700.0
2020-07-07	NVDA	Stock	9.9463	10.07	9.8508	9.8718	357800000.0
2020-07-07	AMZN	Stock	152.9275	153.4775	149.5	150.006	105150000.0
2020-07-07	GOOGL	Stock	74.8065	76.066	74.485	74.496	42363880.0
2020-07-07	META	Stock	239.41	247.65	238.82	240.86	27887800.0
2020-07-07	TSLA	Stock	93.6673	95.3	89.114	92.6573	322345500.0
2020-07-07	TLT	Stock	163.42	165.34	163.2	165.21	12791945.0
2020-07-07	ES	Stock	83.17	84.63	82.42	84.33	1351300.0
2020-07-07	CL	Stock	73.19	74.22	73.18	73.97	4043800.0
2020-07-07	A	Stock	88.84	90.04	88.67	89.21	1441700.0
2020-07-07	AA	Stock	11.23	11.64	11.11	11.23	4613900.0
2020-07-07	AACG	Stock	1.36	1.42	1.35	1.37	48100.0
2020-07-07	AAIC-DELISTED	Stock	2.91	2.92	2.82	2.83	244751.0
2020-07-07	AAIC.C-DELISTED	Stock	19.65	19.9015	19.65	19.8001	3754.0
2020-07-07	AAL	Stock	12.51	12.54	11.91	11.91	77998100.0
2020-07-07	AAM.A-DELISTED	Stock	26.1	26.214	26.0	26.0	20060.0
2020-07-07	AAM.B-DELISTED	Stock	26.38	26.42	26.2	26.2	18244.0
2020-07-07	AAMC-DELISTED	Stock	5.0941	5.3235	5.0882	5.3235	4678.0
2020-07-07	AAME	Stock	1.62	1.71	1.61	1.68	5800.0
2020-07-07	AAMI	Stock	12.68	12.77	12.29	12.74	1637500.0
2020-07-07	AAOI	Stock	11.47	11.52	11.06	11.15	697700.0
2020-07-07	AAON	Stock	36.2667	38.2067	36.2667	36.8067	637950.0
2020-07-07	AAP	Stock	137.92	138.96	136.47	136.68	799000.0
2020-07-07	AAT	Stock	26.87	27.01	26.47	26.54	282800.0
2020-07-07	AAU-DELISTED	Stock	0.51	0.5146	0.48	0.501	393426.0
2020-07-07	AAUAF-DELISTED	Stock	0.51	0.5146	0.48	0.5024	399587.0
2020-07-07	AAWW-DELISTED	Stock	44.94	46.11	44.62	45.9	385796.0
2020-07-07	AAXJ	Stock	74.11	74.5	73.79	73.84	961803.0
2020-07-07	AAXN-DELISTED	Stock	99.04	101.05	95.61	96.05	860705.0
2020-07-07	AB	Stock	26.75	27.05	26.33	26.5	179200.0
2020-07-07	ABB-DELISTED	Stock	24.32	24.32	24.0	24.0	1752572.0
2020-07-07	ABBNY-DELISTED	Stock	24.32	24.32	24.0	24.0	1830060.0
2020-07-07	ABBV	Stock	98.68	100.69	98.56	99.35	6345600.0
2020-07-07	ABC-DELISTED	Stock	99.91	100.43	97.91	98.32	765803.0
2020-07-07	ABCB	Stock	22.2	22.21	21.59	21.79	401600.0
2020-07-07	ABEO	Stock	79.5	87.25	79.0	85.0	69548.0
2020-07-07	ABEV	Stock	2.7	2.76	2.67	2.71	41491100.0
2020-07-07	ABG	Stock	82.0	85.95	81.13	85.73	534600.0
2020-07-07	ABM	Stock	35.21	35.25	33.8	33.82	502100.0
2020-07-07	ABMD-DELISTED	Stock	266.07	271.11	261.73	264.73	260606.0
2020-07-07	ABR	Stock	8.56	8.61	8.1	8.14	2216600.0
2020-07-07	ABR.A-DELISTED	Stock	24.8702	24.8841	24.77	24.85	2163.0
2020-07-07	ABR.B-DELISTED	Stock	23.6701	23.9788	23.64	23.6401	2333.0
2020-07-07	ABR.C-DELISTED	Stock	25.05	25.11	24.8901	25.0099	4963.0
2020-07-07	ABT	Stock	92.46	93.4	92.09	92.46	3389200.0
2020-07-07	ABTC	Stock	244500.0	244800.0	227700.0	229500.0	3.48
2020-07-07	ABTS	Stock	12.3	13.65	12.3	13.38	3707.0
2020-07-07	ABTX-DELISTED	Stock	23.45	23.6847	23.03	23.1	56818.0
2020-07-07	ABUS	Stock	1.85	1.96	1.84	1.86	1011200.0

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

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