PREVIEW / stock_daily / 2019-02-07

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-07.parquet
  size:    219 KB
  rows:    6,503
  symbols: 2,613

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
2019-02-07	AAPL	Stock	43.1	43.485	42.585	42.735	126966800.0
2019-02-07	MSFT	Stock	105.19	105.59	104.29	105.27	29760700.0
2019-02-07	NVDA	Stock	3.7782	3.7805	3.6422	3.6855	637120000.0
2019-02-07	AMZN	Stock	81.25	81.277	79.6455	80.7185	92532000.0
2019-02-07	GOOGL	Stock	55.591	55.5995	54.6795	55.2955	38297540.0
2019-02-07	META	Stock	168.2	169.24	165.25	166.38	17517600.0
2019-02-07	TSLA	Stock	20.8867	20.98	20.2	20.5007	97809000.0
2019-02-07	TLT	Stock	121.46	121.91	121.23	121.83	8781040.0
2019-02-07	ES	Stock	69.08	70.02	68.75	70.02	1597200.0
2019-02-07	CL	Stock	64.84	65.38	64.55	65.05	3145300.0
2019-02-07	A	Stock	75.72	76.12	74.87	75.33	1660600.0
2019-02-07	AA	Stock	28.38	28.49	27.062	27.29	4955700.0
2019-02-07	AABA-DELISTED	Stock	69.02	69.37	67.43	68.52	4813151.0
2019-02-07	AAC-DELISTED	Stock	2.68	2.78	2.51	2.76	178257.0
2019-02-07	AACG	Stock	1.06	1.08	1.02	1.04	29600.0
2019-02-07	AAIC-DELISTED	Stock	8.78	8.78	8.61	8.7	445457.0
2019-02-07	AAL	Stock	36.46	36.7	35.94	36.17	5857300.0
2019-02-07	AAM.A-DELISTED	Stock	24.55	24.56	24.4668	24.52	16473.0
2019-02-07	AAM.B-DELISTED	Stock	24.43	24.43	24.274	24.35	30261.0
2019-02-07	AAMC-DELISTED	Stock	8.9412	8.9412	8.6176	8.6176	2349.0
2019-02-07	AAME	Stock	2.56	2.8	2.56	2.68	12700.0
2019-02-07	AAMI	Stock	12.2	13.23	12.01	12.86	1121500.0
2019-02-07	AAOI	Stock	17.25	17.31	15.65	15.825	1334400.0
2019-02-07	AAON	Stock	24.76	25.1067	24.4467	24.8533	155850.0
2019-02-07	AAP	Stock	160.0	163.26	158.0	163.13	1375900.0
2019-02-07	AAT	Stock	42.94	43.98	42.72	43.9	140100.0
2019-02-07	AAU-DELISTED	Stock	0.73	0.73	0.7131	0.7161	90178.0
2019-02-07	AAUAF-DELISTED	Stock	0.73	0.73	0.7131	0.7161	91260.0
2019-02-07	AAWW-DELISTED	Stock	52.47	52.54	50.87	51.21	258556.0
2019-02-07	AAXJ	Stock	68.63	68.91	67.89	68.49	701670.0
2019-02-07	AAXN-DELISTED	Stock	51.84	52.41	51.14	51.97	288034.0
2019-02-07	AB	Stock	29.91	30.13	29.66	30.1	242000.0
2019-02-07	ABB-DELISTED	Stock	19.44	19.47	19.25	19.36	3030915.0
2019-02-07	ABBNY-DELISTED	Stock	19.44	19.47	19.25	19.36	3251099.0
2019-02-07	ABBV	Stock	78.35	79.22	77.81	79.17	5877500.0
2019-02-07	ABC-DELISTED	Stock	86.8	87.525	85.48	85.81	1207382.0
2019-02-07	ABCB	Stock	38.04	38.38	37.68	38.26	465800.0
2019-02-07	ABDC-DELISTED	Stock	7.66	7.66	7.31	7.36	50921.0
2019-02-07	ABEO	Stock	178.25	178.25	162.5	165.5	19460.0
2019-02-07	ABEV	Stock	4.92	5.04	4.88	5.02	80236600.0
2019-02-07	ABG	Stock	73.62	73.62	68.58	69.18	223400.0
2019-02-07	ABIL-DELISTED	Stock	1.95	1.96	1.85	1.9	192324.0
2019-02-07	ABM	Stock	34.48	34.85	34.26	34.68	388100.0
2019-02-07	ABMD-DELISTED	Stock	340.26	344.02	335.52	341.69	205377.0
2019-02-07	ABR	Stock	11.9	11.91	11.75	11.85	539700.0
2019-02-07	ABR.A-DELISTED	Stock	25.7	25.7	25.6	25.6	500.0
2019-02-07	ABR.B-DELISTED	Stock	25.69	25.69	25.5646	25.5646	700.0
2019-02-07	ABR.C-DELISTED	Stock	25.91	25.95	25.61	25.74	7745.0
2019-02-07	ABT	Stock	72.99	73.06	71.5	72.74	6863600.0
2019-02-07	ABTC	Stock	304800.0	304800.0	303000.0	303300.0	0.4533333333333333

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

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