PREVIEW / stock_daily / 2018-10-03

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-03.parquet
  size:    223 KB
  rows:    6,566
  symbols: 2,752

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-03	AAPL	Stock	57.5125	58.3675	57.445	58.0175	114619200.0
2018-10-03	MSFT	Stock	115.42	116.18	114.93	115.17	16648000.0
2018-10-03	NVDA	Stock	7.233	7.2405	7.0632	7.1682	320552000.0
2018-10-03	AMZN	Stock	99.085	99.485	97.4905	97.638	105062000.0
2018-10-03	GOOGL	Stock	60.6	60.709	60.1075	60.5765	26253720.0
2018-10-03	META	Stock	160.0	163.66	159.53	162.43	23109500.0
2018-10-03	TSLA	Stock	20.222	20.3067	19.438	19.6533	119925000.0
2018-10-03	TLT	Stock	116.27	116.36	114.24	114.83	20829180.0
2018-10-03	ES	Stock	62.1	62.31	60.56	61.09	1473000.0
2018-10-03	CL	Stock	67.53	67.58	65.83	65.92	3764500.0
2018-10-03	A	Stock	71.68	72.37	71.6	72.12	3203100.0
2018-10-03	AA	Stock	44.7	45.45	42.51	42.89	14417700.0
2018-10-03	AABA-DELISTED	Stock	67.51	68.03	67.13	67.28	3167465.0
2018-10-03	AAC-DELISTED	Stock	6.94	7.34	6.8	7.31	113378.0
2018-10-03	AACG	Stock	0.94	1.85	0.89	1.29	2061600.0
2018-10-03	AAIC-DELISTED	Stock	9.03	9.1	8.7	8.82	1305885.0
2018-10-03	AAL	Stock	38.7	39.26	38.42	38.8	6370300.0
2018-10-03	AAM.A-DELISTED	Stock	24.89	24.952	24.2624	24.31	42240.0
2018-10-03	AAM.B-DELISTED	Stock	24.73	24.75	24.1601	24.24	63695.0
2018-10-03	AAMC-DELISTED	Stock	17.3529	17.3529	17.3529	17.3529	4352.0
2018-10-03	AAME	Stock	2.57	2.7	2.57	2.61	1500.0
2018-10-03	AAMI	Stock	12.21	12.39	12.17	12.28	337600.0
2018-10-03	AAOI	Stock	23.28	25.264	22.15	24.91	2168600.0
2018-10-03	AAON	Stock	23.66	24.04	23.58	23.9067	252600.0
2018-10-03	AAP	Stock	168.68	168.91	167.21	167.6	535500.0
2018-10-03	AAT	Stock	36.83	36.99	36.14	36.44	139300.0
2018-10-03	AAU-DELISTED	Stock	0.6	0.6	0.57	0.5888	172220.0
2018-10-03	AAUAF-DELISTED	Stock	0.6	0.6	0.57	0.5888	174940.0
2018-10-03	AAWW-DELISTED	Stock	62.37	63.23	61.92	63.02	113991.0
2018-10-03	AAXJ	Stock	69.31	69.51	68.52	68.64	968819.0
2018-10-03	AAXN-DELISTED	Stock	64.59	65.83	63.6501	64.76	267957.0
2018-10-03	AB	Stock	30.5	30.69	30.43	30.48	164400.0
2018-10-03	ABAC-DELISTED	Stock	1.9375	1.9864	1.9	1.98	8175.0
2018-10-03	ABB-DELISTED	Stock	23.25	23.305	23.13	23.195	1210284.0
2018-10-03	ABBNY-DELISTED	Stock	23.26	23.305	23.13	23.2	1367543.0
2018-10-03	ABBV	Stock	94.64	96.6	94.6	96.01	4796800.0
2018-10-03	ABC-DELISTED	Stock	92.05	92.71	90.83	90.98	1103666.0
2018-10-03	ABCB	Stock	44.88	46.84	44.03	46.75	293200.0
2018-10-03	ABCD-DELISTED	Stock	11.46	11.64	11.4	11.41	36002.0
2018-10-03	ABDC-DELISTED	Stock	6.01	6.14	6.01	6.06	101442.0
2018-10-03	ABEO	Stock	292.5	299.5	284.5	297.5	20864.0
2018-10-03	ABEOW-DELISTED	Stock	6.88	6.88	6.8	6.85	6500.0
2018-10-03	ABEV	Stock	4.79	4.81	4.62	4.66	35781900.0
2018-10-03	ABG	Stock	65.9	67.05	65.7	65.83	274200.0
2018-10-03	ABIL-DELISTED	Stock	3.42	3.5699	3.31	3.35	128934.0
2018-10-03	ABM	Stock	32.34	32.45	31.79	31.89	544000.0
2018-10-03	ABMD-DELISTED	Stock	429.59	431.0	418.4118	426.41	340246.0
2018-10-03	ABR	Stock	11.45	11.64	11.44	11.52	880800.0
2018-10-03	ABR.A-DELISTED	Stock	25.64	25.64	25.53	25.53	1500.0
2018-10-03	ABR.B-DELISTED	Stock	25.3462	25.3462	25.3462	25.3462	200.0

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

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