PREVIEW / stock_daily / 2017-11-24

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-24.parquet
  size:    209 KB
  rows:    6,330
  symbols: 2,805

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-11-24	AAPL	Stock	43.775	43.875	43.6625	43.7425	56106800.0
2017-11-24	MSFT	Stock	83.01	83.43	82.78	83.26	7425600.0
2017-11-24	NVDA	Stock	5.3898	5.425	5.365	5.424	180752000.0
2017-11-24	AMZN	Stock	58.035	59.342	58.035	59.3	70560000.0
2017-11-24	GOOGL	Stock	52.7195	53.0035	52.596	52.826	16507380.0
2017-11-24	META	Stock	180.4	183.15	180.29	182.78	9426300.0
2017-11-24	TSLA	Stock	20.9193	21.094	20.7333	21.0367	48661500.0
2017-11-24	TLT	Stock	126.93	127.03	126.69	126.8	3141388.0
2017-11-24	ES	Stock	64.05	64.33	63.97	64.33	621500.0
2017-11-24	CL	Stock	71.93	72.35	71.93	72.01	988500.0
2017-11-24	A	Stock	68.84	69.39	68.78	69.36	1015400.0
2017-11-24	AA	Stock	42.8	42.9	42.09	42.21	1306100.0
2017-11-24	AAAP-DELISTED	Stock	81.1	81.28	81.1	81.22	153726.0
2017-11-24	AABA-DELISTED	Stock	72.47	73.18	72.31	72.94	2618029.0
2017-11-24	AAC-DELISTED	Stock	9.04	9.21	8.94	9.0	77286.0
2017-11-24	AACG	Stock	4.49	5.23	4.35	5.1	60500.0
2017-11-24	AAIC-DELISTED	Stock	11.84	11.84	11.74	11.75	152495.0
2017-11-24	AAL	Stock	48.66	48.76	48.35	48.56	1352400.0
2017-11-24	AAM.A-DELISTED	Stock	26.41	26.41	26.3554	26.3554	2395.0
2017-11-24	AAMC-DELISTED	Stock	21.5441	23.2301	21.2846	23.2301	3346.0
2017-11-24	AAME	Stock	3.69	3.7	3.6	3.7	1200.0
2017-11-24	AAMI	Stock	16.06	16.08	16.0	16.04	127500.0
2017-11-24	AAOI	Stock	42.0	43.04	42.0	42.22	508800.0
2017-11-24	AAON	Stock	23.8333	23.9	23.5667	23.9	83250.0
2017-11-24	AAP	Stock	89.64	89.9	88.96	89.23	523500.0
2017-11-24	AAT	Stock	39.54	39.64	39.36	39.64	62000.0
2017-11-24	AAU-DELISTED	Stock	0.96	0.96	0.93	0.9401	115502.0
2017-11-24	AAUAF-DELISTED	Stock	0.96	0.96	0.93	0.9401	126247.0
2017-11-24	AAV-DELISTED	Stock	4.95	4.95	4.85	4.85	31484.0
2017-11-24	AAWW-DELISTED	Stock	54.65	54.85	54.3	54.85	65723.0
2017-11-24	AAXJ	Stock	78.12	78.38	78.12	78.28	340386.0
2017-11-24	AAXN-DELISTED	Stock	23.87	24.07	23.72	24.06	222276.0
2017-11-24	AB	Stock	25.55	25.65	25.2	25.3	63900.0
2017-11-24	ABAC-DELISTED	Stock	3.12	3.1834	3.1001	3.16	1600.0
2017-11-24	ABAX-DELISTED	Stock	50.18	50.41	49.08	49.55	35539.0
2017-11-24	ABB-DELISTED	Stock	25.56	25.66	25.55	25.63	977400.0
2017-11-24	ABBNY-DELISTED	Stock	25.56	25.66	25.55	25.63	2616537.0
2017-11-24	ABBV	Stock	94.0	94.97	93.55	94.72	1932900.0
2017-11-24	ABC-DELISTED	Stock	81.9	81.98	80.22	81.22	591693.0
2017-11-24	ABCB	Stock	49.1	49.1	48.25	48.55	120100.0
2017-11-24	ABCD-DELISTED	Stock	5.76	5.79	5.59	5.76	12596.0
2017-11-24	ABDC-DELISTED	Stock	7.88	8.1	7.85	7.93	61798.0
2017-11-24	ABE-DELISTED	Stock	14.3872	14.3872	14.3499	14.3499	2330.0
2017-11-24	ABEO	Stock	407.5	431.25	400.25	418.75	18620.0
2017-11-24	ABEOW-DELISTED	Stock	11.9	12.2052	11.55	12.2052	1400.0
2017-11-24	ABEV	Stock	6.34	6.39	6.33	6.38	6148300.0
2017-11-24	ABG	Stock	64.25	64.5	63.4	63.6	96400.0
2017-11-24	ABIL-DELISTED	Stock	0.549	0.549	0.4313	0.515	124636.0
2017-11-24	ABLX-DELISTED	Stock	23.1	23.15	22.6968	22.8	85510.0
2017-11-24	ABM	Stock	40.96	41.1	40.76	41.09	117100.0

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

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