PREVIEW / stock_daily / 2019-06-10

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-10.parquet
  size:    219 KB
  rows:    6,564
  symbols: 2,560

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-06-10	AAPL	Stock	47.9525	48.8425	47.905	48.145	104883600.0
2019-06-10	MSFT	Stock	132.4	134.08	132.0	132.6	26477100.0
2019-06-10	NVDA	Stock	3.694	3.7798	3.694	3.7108	402780000.0
2019-06-10	AMZN	Stock	91.1	94.2435	90.9	93.0315	107420000.0
2019-06-10	GOOGL	Stock	53.85	54.742	53.7641	54.138	28509280.0
2019-06-10	META	Stock	174.75	177.86	173.8	174.82	14767900.0
2019-06-10	TSLA	Stock	14.0167	14.4627	13.934	14.192	158775000.0
2019-06-10	TLT	Stock	130.68	130.704	130.32	130.5	8289092.0
2019-06-10	ES	Stock	76.12	76.3	75.36	76.02	1095900.0
2019-06-10	CL	Stock	73.86	74.09	72.87	73.03	3191000.0
2019-06-10	A	Stock	69.68	70.55	69.36	70.29	1477100.0
2019-06-10	AA	Stock	21.59	22.113	21.56	21.58	3989900.0
2019-06-10	AABA-DELISTED	Stock	65.64	66.685	65.03	65.94	15748113.0
2019-06-10	AAC-DELISTED	Stock	0.92	0.9499	0.7843	0.8206	679284.0
2019-06-10	AACG	Stock	2.02	2.2	2.01	2.19	115400.0
2019-06-10	AAIC-DELISTED	Stock	6.78	6.93	6.76	6.9	290391.0
2019-06-10	AAIC.C-DELISTED	Stock	21.65	22.0	21.6	21.99	11343.0
2019-06-10	AAL	Stock	31.15	31.72	30.72	30.76	5449400.0
2019-06-10	AAM.A-DELISTED	Stock	25.7784	25.7784	25.65	25.72	18416.0
2019-06-10	AAM.B-DELISTED	Stock	25.8245	25.84	25.7501	25.84	14997.0
2019-06-10	AAMC-DELISTED	Stock	4.1176	4.1176	3.6265	3.8235	24837.0
2019-06-10	AAME	Stock	2.32	2.45	2.32	2.45	600.0
2019-06-10	AAMI	Stock	11.06	11.27	11.06	11.11	282000.0
2019-06-10	AAOI	Stock	9.68	9.89	9.44	9.6	533000.0
2019-06-10	AAON	Stock	32.7267	33.2067	31.8533	32.4267	137100.0
2019-06-10	AAP	Stock	156.36	157.7	152.13	153.52	1046900.0
2019-06-10	AAT	Stock	46.6	46.6	46.2	46.51	226100.0
2019-06-10	AAU-DELISTED	Stock	0.57	0.57	0.4717	0.49	274532.0
2019-06-10	AAUAF-DELISTED	Stock	0.57	0.57	0.4717	0.49	313407.0
2019-06-10	AAWW-DELISTED	Stock	40.27	41.42	40.11	40.29	194019.0
2019-06-10	AAXJ	Stock	67.31	67.71	67.21	67.35	938590.0
2019-06-10	AAXN-DELISTED	Stock	69.76	72.29	69.5001	71.93	738322.0
2019-06-10	AB	Stock	28.1	28.57	28.06	28.28	237000.0
2019-06-10	ABB-DELISTED	Stock	19.4	19.5	19.33	19.345	1378438.0
2019-06-10	ABBNY-DELISTED	Stock	19.4	19.5	19.33	19.34	1449265.0
2019-06-10	ABBV	Stock	77.46	77.75	76.6	76.95	3969400.0
2019-06-10	ABC-DELISTED	Stock	83.63	85.48	83.58	84.77	1107422.0
2019-06-10	ABCB	Stock	36.91	37.77	36.64	37.2	260000.0
2019-06-10	ABDC-DELISTED	Stock	8.13	8.16	8.09	8.14	12454.0
2019-06-10	ABEO	Stock	134.0	138.25	132.5	135.75	19212.0
2019-06-10	ABEOW-DELISTED	Stock	1.74	1.74	1.06	1.06	1108.0
2019-06-10	ABEV	Stock	4.55	4.62	4.54	4.56	15307100.0
2019-06-10	ABG	Stock	78.43	79.5	78.32	78.88	79400.0
2019-06-10	ABIL-DELISTED	Stock	1.19	1.24	1.12	1.15	74869.0
2019-06-10	ABM	Stock	39.46	39.54	39.0	39.47	665000.0
2019-06-10	ABMD-DELISTED	Stock	269.61	275.9558	269.2	272.25	890518.0
2019-06-10	ABR	Stock	12.55	12.59	12.07	12.15	3394800.0
2019-06-10	ABR.A-DELISTED	Stock	25.88	25.92	25.88	25.92	300.0
2019-06-10	ABR.B-DELISTED	Stock	25.78	25.78	25.53	25.53	5050.0
2019-06-10	ABR.C-DELISTED	Stock	25.93	26.28	25.93	26.25	2430.0

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

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