PREVIEW / stock_daily / 2020-07-01

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-01.parquet
  size:    222 KB
  rows:    6,709
  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-01	AAPL	Stock	91.28	91.84	90.9775	91.0275	110737200.0
2020-07-01	MSFT	Stock	203.14	206.35	201.77	204.7	32061200.0
2020-07-01	NVDA	Stock	9.5208	9.5758	9.413	9.53	326648000.0
2020-07-01	AMZN	Stock	137.8995	144.75	137.7	143.935	127268000.0
2020-07-01	GOOGL	Stock	70.9585	72.424	70.709	72.1	42182480.0
2020-07-01	META	Stock	228.5	239.0	227.56	237.55	43399700.0
2020-07-01	TSLA	Stock	72.2	75.6887	72.0333	74.642	199903500.0
2020-07-01	TLT	Stock	162.81	163.56	162.15	163.42	13181262.0
2020-07-01	ES	Stock	83.22	85.47	83.16	85.11	1528000.0
2020-07-01	CL	Stock	73.26	73.58	72.97	73.03	3286300.0
2020-07-01	A	Stock	88.89	88.89	87.3	88.11	1137000.0
2020-07-01	AA	Stock	11.18	11.66	10.9	10.95	7706500.0
2020-07-01	AACG	Stock	1.25	1.4	1.18	1.31	95400.0
2020-07-01	AAIC-DELISTED	Stock	2.96	2.98	2.84	2.91	326488.0
2020-07-01	AAIC.C-DELISTED	Stock	19.6319	19.65	19.52	19.65	2204.0
2020-07-01	AAL	Stock	13.48	14.29	12.63	12.81	116661700.0
2020-07-01	AAM.A-DELISTED	Stock	25.71	25.91	25.71	25.83	10759.0
2020-07-01	AAM.B-DELISTED	Stock	26.07	26.07	25.93	25.99	10094.0
2020-07-01	AAMC-DELISTED	Stock	4.9971	4.9971	4.9706	4.9853	5899.0
2020-07-01	AAME	Stock	1.64	1.71	1.62	1.65	12400.0
2020-07-01	AAMI	Stock	12.51	12.6	12.05	12.31	1300900.0
2020-07-01	AAOI	Stock	10.67	10.719	9.9	10.19	1267900.0
2020-07-01	AAON	Stock	36.2067	36.3867	35.04	35.1267	262500.0
2020-07-01	AAP	Stock	142.36	143.67	139.67	141.95	709500.0
2020-07-01	AAT	Stock	27.92	28.58	27.83	28.13	190400.0
2020-07-01	AAU-DELISTED	Stock	0.49	0.5	0.4808	0.498	269184.0
2020-07-01	AAUAF-DELISTED	Stock	0.49	0.5	0.4808	0.4986	274217.0
2020-07-01	AAWW-DELISTED	Stock	43.63	45.2899	43.44	43.91	421966.0
2020-07-01	AAXJ	Stock	69.64	70.18	69.56	69.88	743390.0
2020-07-01	AAXN-DELISTED	Stock	98.64	100.14	97.54	99.27	417284.0
2020-07-01	AB	Stock	27.04	27.1	26.22	26.62	203700.0
2020-07-01	ABB-DELISTED	Stock	23.15	23.3	23.06	23.26	3245789.0
2020-07-01	ABBNY-DELISTED	Stock	23.15	23.3	23.06	23.26	3649055.0
2020-07-01	ABBV	Stock	98.5	99.66	97.5	99.14	6522900.0
2020-07-01	ABC-DELISTED	Stock	100.95	101.47	99.125	99.44	732900.0
2020-07-01	ABCB	Stock	23.65	23.8	22.33	22.39	282500.0
2020-07-01	ABEO	Stock	72.5	74.75	70.75	71.25	35708.0
2020-07-01	ABEV	Stock	2.66	2.77	2.66	2.73	25199700.0
2020-07-01	ABG	Stock	77.72	79.08	75.22	75.35	147400.0
2020-07-01	ABM	Stock	36.18	36.72	35.69	35.94	452200.0
2020-07-01	ABMD-DELISTED	Stock	242.96	257.492	242.68	255.44	445696.0
2020-07-01	ABR	Stock	9.22	9.45	8.98	9.03	1535300.0
2020-07-01	ABR.A-DELISTED	Stock	24.83	24.95	24.586	24.81	4004.0
2020-07-01	ABR.B-DELISTED	Stock	23.6	23.78	23.33	23.6956	1790.0
2020-07-01	ABR.C-DELISTED	Stock	24.9	25.08	24.83	25.08	1500.0
2020-07-01	ABT	Stock	91.98	91.98	90.43	91.64	3389600.0
2020-07-01	ABTC	Stock	263100.0	268500.0	247500.0	259200.0	3.1866666666666665
2020-07-01	ABTS	Stock	12.3	12.345	11.265	11.565	9460.0
2020-07-01	ABTX-DELISTED	Stock	25.52	25.9	23.86	23.9	43234.0
2020-07-01	ABUS	Stock	1.82	1.91	1.78	1.83	817400.0

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

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