PREVIEW / stock_daily / 2018-10-05

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-05.parquet
  size:    222 KB
  rows:    6,539
  symbols: 2,731

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-10-05	AAPL	Stock	56.99	57.1025	55.145	56.0725	134322000.0
2018-10-05	MSFT	Stock	112.63	113.17	110.64	112.13	29068900.0
2018-10-05	NVDA	Stock	6.9573	7.02	6.6885	6.7465	426636000.0
2018-10-05	AMZN	Stock	95.8995	96.454	93.1415	94.4825	136446000.0
2018-10-05	GOOGL	Stock	58.8	59.1	57.716	58.3915	31860240.0
2018-10-05	META	Stock	159.21	160.9	156.2	157.33	25744000.0
2018-10-05	TSLA	Stock	18.31	18.3253	17.3333	17.4633	269167500.0
2018-10-05	TLT	Stock	113.39	113.72	112.62	113.04	18096505.0
2018-10-05	ES	Stock	61.54	62.61	61.54	62.4	1493800.0
2018-10-05	CL	Stock	64.77	65.04	64.6	64.71	2972200.0
2018-10-05	A	Stock	70.67	71.18	69.45	70.3	2376800.0
2018-10-05	AA	Stock	42.64	42.65	41.6	42.06	4314200.0
2018-10-05	AABA-DELISTED	Stock	65.15	65.51	63.77	64.55	6303284.0
2018-10-05	AAC-DELISTED	Stock	7.06	7.14	6.91	7.0	92086.0
2018-10-05	AACG	Stock	1.19	1.2	1.05	1.09	99400.0
2018-10-05	AAIC-DELISTED	Stock	9.08	9.09	8.76	8.96	559369.0
2018-10-05	AAL	Stock	37.93	38.13	36.21	36.44	9127000.0
2018-10-05	AAM.A-DELISTED	Stock	24.12	24.2643	24.12	24.19	32950.0
2018-10-05	AAM.B-DELISTED	Stock	24.01	24.19	24.01	24.06	41908.0
2018-10-05	AAMC-DELISTED	Stock	17.5	17.5	17.5	17.5	6939.0
2018-10-05	AAMI	Stock	12.17	12.525	12.11	12.5	2543100.0
2018-10-05	AAOI	Stock	24.47	24.647	23.6	23.99	787600.0
2018-10-05	AAON	Stock	23.34	23.3533	22.6733	22.9	330000.0
2018-10-05	AAP	Stock	165.63	167.45	164.31	165.83	938800.0
2018-10-05	AAT	Stock	36.35	36.78	36.27	36.62	292400.0
2018-10-05	AAU-DELISTED	Stock	0.61	0.61	0.58	0.599	102526.0
2018-10-05	AAUAF-DELISTED	Stock	0.61	0.61	0.58	0.599	106485.0
2018-10-05	AAWW-DELISTED	Stock	60.59	61.08	59.435	59.76	196428.0
2018-10-05	AAXJ	Stock	66.85	66.9	65.9699	66.51	1678979.0
2018-10-05	AAXN-DELISTED	Stock	62.91	64.2399	61.2381	62.67	405716.0
2018-10-05	AB	Stock	30.9	31.24	30.56	30.56	208900.0
2018-10-05	ABAC-DELISTED	Stock	1.8601	1.9511	1.77	1.95	12181.0
2018-10-05	ABB-DELISTED	Stock	22.76	22.795	22.51	22.64	1108562.0
2018-10-05	ABBNY-DELISTED	Stock	22.76	22.795	22.51	22.64	1226944.0
2018-10-05	ABBV	Stock	94.1	95.27	92.91	94.38	4190100.0
2018-10-05	ABC-DELISTED	Stock	91.01	92.1907	89.91	90.58	1023679.0
2018-10-05	ABCB	Stock	46.65	46.65	45.51	45.74	160800.0
2018-10-05	ABCD-DELISTED	Stock	11.36	12.05	11.19	11.495	169824.0
2018-10-05	ABDC-DELISTED	Stock	6.02	6.11	6.0	6.1	56546.0
2018-10-05	ABEO	Stock	286.75	296.25	277.0	288.5	15192.0
2018-10-05	ABEOW-DELISTED	Stock	6.77	6.8	6.6	6.6	2649.0
2018-10-05	ABEV	Stock	4.62	4.63	4.52	4.6	25035600.0
2018-10-05	ABG	Stock	64.18	64.55	62.47	63.18	199000.0
2018-10-05	ABIL-DELISTED	Stock	3.54	3.54	3.31	3.45	37698.0
2018-10-05	ABM	Stock	31.56	31.91	31.39	31.85	449900.0
2018-10-05	ABMD-DELISTED	Stock	418.99	430.9306	405.4761	415.71	394193.0
2018-10-05	ABR	Stock	11.44	11.49	11.38	11.42	394000.0
2018-10-05	ABR.A-DELISTED	Stock	25.37	25.4513	25.35	25.4	4393.0
2018-10-05	ABR.B-DELISTED	Stock	25.32	25.32	25.153	25.1722	3543.0
2018-10-05	ABT	Stock	71.82	72.46	71.05	71.58	5426200.0

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

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