PREVIEW / stock_daily / 2017-12-28

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-28.parquet
  size:    217 KB
  rows:    6,509
  symbols: 2,893

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
2017-12-28	AAPL	Stock	42.75	42.9625	42.62	42.77	65920800.0
2017-12-28	MSFT	Stock	85.9	85.93	85.55	85.72	10594300.0
2017-12-28	NVDA	Stock	4.9533	4.9845	4.9288	4.935	240248000.0
2017-12-28	AMZN	Stock	59.45	59.505	59.219	59.305	36834000.0
2017-12-28	GOOGL	Stock	53.1125	53.242	52.669	52.7975	19884980.0
2017-12-28	META	Stock	177.95	178.94	177.68	177.92	12220800.0
2017-12-28	TSLA	Stock	20.7833	21.0547	20.636	21.024	64744500.0
2017-12-28	TLT	Stock	126.53	126.83	126.37	126.66	5297264.0
2017-12-28	ES	Stock	62.79	63.0	62.53	62.95	1033900.0
2017-12-28	CL	Stock	75.39	75.54	74.98	75.14	1506100.0
2017-12-28	A	Stock	67.44	67.48	67.02	67.45	607000.0
2017-12-28	AA	Stock	52.05	54.2	52.021	54.14	5702000.0
2017-12-28	AAAP-DELISTED	Stock	81.6	81.63	81.59	81.6	572220.0
2017-12-28	AABA-DELISTED	Stock	70.12	70.32	69.51	69.82	6074255.0
2017-12-28	AAC-DELISTED	Stock	9.05	9.2692	8.98	9.01	83393.0
2017-12-28	AACG	Stock	5.12	5.12	4.95	4.96	4500.0
2017-12-28	AAIC-DELISTED	Stock	11.84	11.9828	11.7	11.88	813792.0
2017-12-28	AAL	Stock	52.45	52.63	52.22	52.46	1845300.0
2017-12-28	AAM.A-DELISTED	Stock	26.3099	26.34	26.192	26.29	27645.0
2017-12-28	AAME	Stock	3.55	3.55	3.25	3.25	9900.0
2017-12-28	AAMI	Stock	16.85	16.87	16.75	16.85	187700.0
2017-12-28	AAOI	Stock	38.76	39.4	38.34	38.86	848500.0
2017-12-28	AAON	Stock	24.4667	24.5667	23.8667	24.5333	184800.0
2017-12-28	AAP	Stock	99.86	99.91	98.17	99.71	604600.0
2017-12-28	AAT	Stock	37.89	38.45	37.7	38.41	156100.0
2017-12-28	AAU-DELISTED	Stock	1.02	1.04	1.01	1.01	182035.0
2017-12-28	AAUAF-DELISTED	Stock	1.02	1.04	1.01	1.01	190241.0
2017-12-28	AAV-DELISTED	Stock	4.2	4.35	4.15	4.275	139933.0
2017-12-28	AAWW-DELISTED	Stock	59.3	59.4	58.5	59.15	90552.0
2017-12-28	AAXJ	Stock	76.15	76.22	75.85	76.0	569511.0
2017-12-28	AAXN-DELISTED	Stock	26.7	26.96	26.5968	26.94	218585.0
2017-12-28	AB	Stock	25.2	25.3	25.0	25.1	174900.0
2017-12-28	ABAC-DELISTED	Stock	3.1	3.1716	2.96	3.0146	21088.0
2017-12-28	ABAX-DELISTED	Stock	49.1	49.86	48.85	49.8	136518.0
2017-12-28	ABB-DELISTED	Stock	26.8	26.91	26.775	26.81	1224317.0
2017-12-28	ABBNY-DELISTED	Stock	26.8	26.91	26.775	26.81	1407495.0
2017-12-28	ABBV	Stock	98.19	98.39	97.52	97.79	1870400.0
2017-12-28	ABC-DELISTED	Stock	92.88	92.93	91.745	92.58	1022304.0
2017-12-28	ABCB	Stock	48.5	49.0	48.2	48.75	112600.0
2017-12-28	ABCD-DELISTED	Stock	5.62	5.65	5.54	5.64	39699.0
2017-12-28	ABDC-DELISTED	Stock	8.47	8.52	8.25	8.29	155269.0
2017-12-28	ABE-DELISTED	Stock	14.64	14.71	14.49	14.49	6733.0
2017-12-28	ABEO	Stock	402.5	406.25	395.75	402.5	16300.0
2017-12-28	ABEOW-DELISTED	Stock	10.93	10.93	10.93	10.93	100.0
2017-12-28	ABEV	Stock	6.44	6.44	6.34	6.42	9815000.0
2017-12-28	ABG	Stock	64.75	65.65	64.5	65.5	236500.0
2017-12-28	ABIL-DELISTED	Stock	0.4914	0.5982	0.425	0.425	1596632.0
2017-12-28	ABLX-DELISTED	Stock	24.39	24.83	24.13	24.28	116078.0
2017-12-28	ABM	Stock	38.24	38.24	37.75	37.88	569200.0
2017-12-28	ABMD-DELISTED	Stock	190.5	190.8299	189.62	190.36	99682.0

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

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