PREVIEW / stock_daily / 2019-06-13

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-13.parquet
  size:    220 KB
  rows:    6,552
  symbols: 2,554

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-13	AAPL	Stock	48.675	49.1975	48.4	48.5375	86698400.0
2019-06-13	MSFT	Stock	131.98	133.0	131.56	132.32	17200800.0
2019-06-13	NVDA	Stock	3.6772	3.725	3.6595	3.7065	308080000.0
2019-06-13	AMZN	Stock	93.336	94.1545	93.111	93.515	55916000.0
2019-06-13	GOOGL	Stock	54.2355	54.8295	54.1285	54.5505	20813220.0
2019-06-13	META	Stock	175.53	178.03	174.61	177.47	12253600.0
2019-06-13	TSLA	Stock	14.0253	14.3267	13.834	14.2607	122524500.0
2019-06-13	TLT	Stock	130.8	131.25	130.79	131.13	5560844.0
2019-06-13	ES	Stock	76.66	76.8	76.09	76.67	1760200.0
2019-06-13	CL	Stock	73.08	73.2	71.99	72.75	2944600.0
2019-06-13	A	Stock	70.56	70.71	69.89	70.3	1886900.0
2019-06-13	AA	Stock	21.31	21.902	21.1	21.8	2923800.0
2019-06-13	AABA-DELISTED	Stock	66.16	66.92	66.16	66.595	5455643.0
2019-06-13	AAC-DELISTED	Stock	0.75	0.77	0.71	0.75	356064.0
2019-06-13	AACG	Stock	2.11	2.18	2.1	2.16	55700.0
2019-06-13	AAIC-DELISTED	Stock	6.9	6.99	6.89	6.97	278904.0
2019-06-13	AAIC.C-DELISTED	Stock	21.7001	21.85	21.53	21.83	3800.0
2019-06-13	AAL	Stock	31.69	33.32	31.41	33.09	10856500.0
2019-06-13	AAM.A-DELISTED	Stock	25.63	25.7395	25.61	25.66	10662.0
2019-06-13	AAM.B-DELISTED	Stock	25.72	25.8399	25.72	25.81	28969.0
2019-06-13	AAMI	Stock	11.0	11.09	10.94	10.98	339900.0
2019-06-13	AAOI	Stock	9.11	9.18	8.91	8.94	392100.0
2019-06-13	AAON	Stock	31.9933	32.6933	31.9933	32.6533	139800.0
2019-06-13	AAP	Stock	150.66	152.7	150.19	150.61	814800.0
2019-06-13	AAT	Stock	45.15	46.23	45.15	46.18	1172300.0
2019-06-13	AAU-DELISTED	Stock	0.49	0.51	0.4801	0.5099	113937.0
2019-06-13	AAUAF-DELISTED	Stock	0.49	0.51	0.4801	0.5099	114917.0
2019-06-13	AAWW-DELISTED	Stock	40.92	42.11	40.81	42.1	153794.0
2019-06-13	AAXJ	Stock	67.31	67.4	66.92	67.12	962142.0
2019-06-13	AAXN-DELISTED	Stock	70.64	71.13	70.36	71.11	626648.0
2019-06-13	AB	Stock	28.97	29.88	28.9	29.83	540800.0
2019-06-13	ABB-DELISTED	Stock	19.38	19.38	19.24	19.285	1017460.0
2019-06-13	ABBNY-DELISTED	Stock	19.38	19.38	19.24	19.28	1088030.0
2019-06-13	ABBV	Stock	78.93	79.2	78.3	78.95	2924900.0
2019-06-13	ABC-DELISTED	Stock	85.6	86.68	85.31	86.47	734640.0
2019-06-13	ABCB	Stock	37.94	38.18	37.5	38.13	244700.0
2019-06-13	ABDC-DELISTED	Stock	8.05	8.07	8.05	8.07	20695.0
2019-06-13	ABEO	Stock	135.25	137.25	132.0	133.0	23684.0
2019-06-13	ABEV	Stock	4.62	4.67	4.6	4.64	17094000.0
2019-06-13	ABG	Stock	79.87	80.37	78.66	80.36	100600.0
2019-06-13	ABIL-DELISTED	Stock	1.17	1.2	1.14	1.16	44277.0
2019-06-13	ABM	Stock	40.0	40.16	39.78	39.81	482800.0
2019-06-13	ABMD-DELISTED	Stock	253.72	256.98	251.28	255.52	377602.0
2019-06-13	ABR	Stock	12.23	12.27	12.12	12.17	1069900.0
2019-06-13	ABR.B-DELISTED	Stock	25.87	25.87	25.593	25.593	925.0
2019-06-13	ABR.C-DELISTED	Stock	26.05	26.05	25.79	25.88	1220.0
2019-06-13	ABT	Stock	81.98	82.33	81.75	82.29	5220400.0
2019-06-13	ABTC	Stock	306000.0	306900.0	304800.0	305580.0	0.32
2019-06-13	ABTS	Stock	23.22	25.5	23.22	25.2	3693.0
2019-06-13	ABTX-DELISTED	Stock	32.79	33.04	32.5	32.72	63886.0

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

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