PREVIEW / stock_daily / 2017-12-11

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-11.parquet
  size:    218 KB
  rows:    6,530
  symbols: 2,927

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-11	AAPL	Stock	42.3	43.2225	42.1975	43.1675	141095200.0
2017-12-11	MSFT	Stock	84.29	85.37	84.12	85.23	22857900.0
2017-12-11	NVDA	Stock	4.8015	4.8695	4.7855	4.8665	372748000.0
2017-12-11	AMZN	Stock	58.23	58.495	57.85	58.446	47270000.0
2017-12-11	GOOGL	Stock	52.5555	52.8	52.206	52.5985	23253880.0
2017-12-11	META	Stock	179.3	180.22	178.8	179.04	13168600.0
2017-12-11	TSLA	Stock	20.9753	21.934	20.9167	21.9273	119070000.0
2017-12-11	TLT	Stock	126.86	127.085	126.41	126.43	3863802.0
2017-12-11	ES	Stock	65.22	65.79	64.96	65.7	1545000.0
2017-12-11	CL	Stock	73.14	73.28	72.49	73.17	4432500.0
2017-12-11	A	Stock	67.43	67.75	66.48	67.0	2438600.0
2017-12-11	AA	Stock	41.54	42.98	41.54	42.24	4053000.0
2017-12-11	AAAP-DELISTED	Stock	81.64	81.74	81.57	81.62	514914.0
2017-12-11	AABA-DELISTED	Stock	71.7	72.089	71.15	71.57	6478313.0
2017-12-11	AAC-DELISTED	Stock	8.8	8.91	8.715	8.81	119502.0
2017-12-11	AACG	Stock	5.2	6.62	5.19	5.66	89600.0
2017-12-11	AAIC-DELISTED	Stock	12.09	12.22	12.09	12.18	317175.0
2017-12-11	AAL	Stock	50.78	51.59	50.76	51.3	2835600.0
2017-12-11	AAM.A-DELISTED	Stock	26.28	26.28	26.2	26.2	9150.0
2017-12-11	AAMC-DELISTED	Stock	21.4706	21.4706	21.4706	21.4706	2509.0
2017-12-11	AAME	Stock	3.4	3.45	3.2	3.35	10000.0
2017-12-11	AAMI	Stock	16.1	16.26	16.05	16.1	589500.0
2017-12-11	AAOI	Stock	38.78	40.565	38.75	40.52	1000300.0
2017-12-11	AAON	Stock	23.8333	23.8667	23.2333	23.3667	220800.0
2017-12-11	AAP	Stock	100.15	101.67	99.11	100.85	1490300.0
2017-12-11	AAT	Stock	38.72	39.12	38.56	38.85	240600.0
2017-12-11	AAU-DELISTED	Stock	0.7612	0.93	0.7612	0.89	958337.0
2017-12-11	AAUAF-DELISTED	Stock	0.7612	0.93	0.7612	0.87	1037364.0
2017-12-11	AAV-DELISTED	Stock	4.0	4.1	3.955	4.0	426753.0
2017-12-11	AAWW-DELISTED	Stock	57.1	57.3	56.1	56.75	157056.0
2017-12-11	AAXJ	Stock	75.69	75.87	75.62	75.76	906388.0
2017-12-11	AAXN-DELISTED	Stock	24.53	24.79	24.16	24.59	436931.0
2017-12-11	AB	Stock	24.9	25.3	24.45	25.1	1090900.0
2017-12-11	ABAC-DELISTED	Stock	2.92	3.03	2.81	2.84	7652.0
2017-12-11	ABAX-DELISTED	Stock	47.75	47.76	47.08	47.3601	68292.0
2017-12-11	ABB-DELISTED	Stock	25.93	26.1	25.93	26.01	1160277.0
2017-12-11	ABBNY-DELISTED	Stock	25.93	26.1	25.93	26.0	1209575.0
2017-12-11	ABBV	Stock	96.39	97.31	95.77	96.47	4181100.0
2017-12-11	ABC-DELISTED	Stock	87.05	87.5	86.29	86.76	1124105.0
2017-12-11	ABCB	Stock	47.1	47.2	46.4	46.55	141200.0
2017-12-11	ABCD-DELISTED	Stock	5.46	5.54	5.31	5.51	55082.0
2017-12-11	ABDC-DELISTED	Stock	8.34	8.35	8.25	8.32	232874.0
2017-12-11	ABE-DELISTED	Stock	14.22	14.2475	14.205	14.22	5490.0
2017-12-11	ABEO	Stock	407.5	408.25	385.0	388.75	27268.0
2017-12-11	ABEOW-DELISTED	Stock	10.7499	10.7499	10.7499	10.7499	174.0
2017-12-11	ABEV	Stock	6.33	6.38	6.33	6.34	10404400.0
2017-12-11	ABG	Stock	67.7	68.05	66.75	67.55	356000.0
2017-12-11	ABIL-DELISTED	Stock	0.44	0.44	0.395	0.4046	96857.0
2017-12-11	ABLX-DELISTED	Stock	24.16	24.25	23.88	23.95	282184.0
2017-12-11	ABM	Stock	43.47	43.95	43.29	43.78	361700.0

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

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