PREVIEW / stock_daily / 2018-03-12

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-12.parquet
  size:    217 KB
  rows:    6,485
  symbols: 2,854

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
2018-03-12	AAPL	Stock	45.0725	45.5975	45.0525	45.43	128828400.0
2018-03-12	MSFT	Stock	96.5	97.21	96.04	96.77	26073700.0
2018-03-12	NVDA	Stock	6.175	6.325	6.1668	6.244	605060000.0
2018-03-12	AMZN	Stock	79.63	80.2665	79.335	79.9195	103484000.0
2018-03-12	GOOGL	Stock	58.2525	58.908	57.96	58.2965	44306080.0
2018-03-12	META	Stock	185.23	186.1	184.22	184.76	15301200.0
2018-03-12	TSLA	Stock	21.9073	23.1473	21.7667	23.034	123960000.0
2018-03-12	TLT	Stock	118.31	118.66	118.19	118.59	5801739.0
2018-03-12	ES	Stock	57.34	58.3	56.85	57.06	3158800.0
2018-03-12	CL	Stock	71.36	71.65	70.89	71.08	2975200.0
2018-03-12	A	Stock	71.2	71.53	70.67	70.71	2049400.0
2018-03-12	AA	Stock	48.01	48.68	47.91	48.36	1495600.0
2018-03-12	AABA-DELISTED	Stock	77.0	77.76	76.54	77.57	9219794.0
2018-03-12	AAC-DELISTED	Stock	12.0	12.42	11.97	12.28	377836.0
2018-03-12	AACG	Stock	5.2	5.25	5.1	5.12	16300.0
2018-03-12	AAIC-DELISTED	Stock	11.6	11.83	11.595	11.7	433661.0
2018-03-12	AAL	Stock	56.26	56.97	55.63	56.5	3256400.0
2018-03-12	AAM.A-DELISTED	Stock	25.54	25.54	25.12	25.1383	177172.0
2018-03-12	AAMC-DELISTED	Stock	19.7059	19.7059	18.7941	18.7941	8163.0
2018-03-12	AAME	Stock	3.43	3.5	3.35	3.43	3300.0
2018-03-12	AAMI	Stock	16.04	16.08	15.86	16.02	544200.0
2018-03-12	AAOI	Stock	30.0	31.97	29.93	30.95	3293500.0
2018-03-12	AAON	Stock	25.3	25.6667	24.7467	25.4667	398550.0
2018-03-12	AAP	Stock	118.56	119.25	117.21	118.41	802800.0
2018-03-12	AAT	Stock	32.39	32.81	32.28	32.68	855400.0
2018-03-12	AAU-DELISTED	Stock	0.85	0.8701	0.8401	0.87	163824.0
2018-03-12	AAUAF-DELISTED	Stock	0.85	0.8701	0.8401	0.87	171679.0
2018-03-12	AAV-DELISTED	Stock	2.9	2.95	2.8	2.9	358634.0
2018-03-12	AAWW-DELISTED	Stock	60.85	62.55	60.7	61.3	172287.0
2018-03-12	AAXJ	Stock	79.71	79.9338	79.4352	79.78	500164.0
2018-03-12	AAXN-DELISTED	Stock	40.34	40.47	39.15	39.415	953307.0
2018-03-12	AB	Stock	27.2	27.3	27.05	27.1	229400.0
2018-03-12	ABAC-DELISTED	Stock	2.45	2.465	2.45	2.465	3016.0
2018-03-12	ABAX-DELISTED	Stock	71.7	74.375	71.7	74.08	96150.0
2018-03-12	ABB-DELISTED	Stock	24.42	24.51	24.31	24.46	2095103.0
2018-03-12	ABBNY-DELISTED	Stock	24.42	24.51	24.31	24.46	2169102.0
2018-03-12	ABBV	Stock	119.4	119.59	117.93	118.3	4892900.0
2018-03-12	ABC-DELISTED	Stock	99.21	101.02	98.9698	100.35	1414765.0
2018-03-12	ABCB	Stock	58.0	59.05	56.83	57.4	210000.0
2018-03-12	ABCD-DELISTED	Stock	9.18	9.32	8.5	9.15	357319.0
2018-03-12	ABDC-DELISTED	Stock	7.69	7.84	7.61	7.72	84411.0
2018-03-12	ABE-DELISTED	Stock	15.2902	15.2902	15.27	15.29	1490.0
2018-03-12	ABEO	Stock	381.25	401.25	380.25	395.0	33924.0
2018-03-12	ABEOW-DELISTED	Stock	10.945	11.42	10.831	10.9	4200.0
2018-03-12	ABEV	Stock	7.18	7.35	7.16	7.3	29105700.0
2018-03-12	ABG	Stock	69.75	70.0	68.5	68.75	174000.0
2018-03-12	ABIL-DELISTED	Stock	0.4263	0.4263	0.4	0.41	50815.0
2018-03-12	ABLX-DELISTED	Stock	54.07	54.105	53.98	54.1	42313.0
2018-03-12	ABM	Stock	37.67	38.36	37.67	38.02	655800.0
2018-03-12	ABMD-DELISTED	Stock	295.65	304.2802	290.5301	294.75	228536.0

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

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