PREVIEW / stock_daily / 2017-12-22

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-22.parquet
  size:    216 KB
  rows:    6,469
  symbols: 2,875

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-22	AAPL	Stock	43.67	43.855	43.625	43.7525	65397600.0
2017-12-22	MSFT	Stock	85.4	85.63	84.92	85.51	14145800.0
2017-12-22	NVDA	Stock	4.86	4.8912	4.7812	4.8818	466276000.0
2017-12-22	AMZN	Stock	58.604	58.731	58.3915	58.418	31702000.0
2017-12-22	GOOGL	Stock	53.5	53.586	53.382	53.443	17788920.0
2017-12-22	META	Stock	177.14	177.53	176.23	177.2	8509500.0
2017-12-22	TSLA	Stock	21.9673	22.0613	21.6547	21.68	63237000.0
2017-12-22	TLT	Stock	124.7	124.84	124.53	124.77	3974571.0
2017-12-22	ES	Stock	62.22	62.53	61.99	62.37	1231500.0
2017-12-22	CL	Stock	74.99	75.29	74.74	75.15	2186200.0
2017-12-22	A	Stock	67.41	67.54	66.86	67.35	1221300.0
2017-12-22	AA	Stock	49.27	50.04	48.81	49.99	2427500.0
2017-12-22	AAAP-DELISTED	Stock	81.56	81.63	81.56	81.6	233068.0
2017-12-22	AABA-DELISTED	Stock	71.42	71.87	71.22	71.59	7863797.0
2017-12-22	AAC-DELISTED	Stock	8.7	9.1	8.54	9.07	196461.0
2017-12-22	AACG	Stock	5.27	5.35	5.25	5.25	1500.0
2017-12-22	AAIC-DELISTED	Stock	12.53	12.53	12.44	12.48	277268.0
2017-12-22	AAL	Stock	52.72	52.88	52.42	52.59	2425100.0
2017-12-22	AAM.A-DELISTED	Stock	26.39	26.4	26.2107	26.27	8514.0
2017-12-22	AAMC-DELISTED	Stock	22.8824	22.8824	22.8824	22.8824	877.0
2017-12-22	AAME	Stock	3.85	3.85	3.6	3.85	5700.0
2017-12-22	AAMI	Stock	16.98	16.98	16.74	16.83	231900.0
2017-12-22	AAOI	Stock	40.02	40.26	39.59	39.96	597500.0
2017-12-22	AAON	Stock	24.3333	24.5667	24.2	24.5	228150.0
2017-12-22	AAP	Stock	100.64	100.83	99.71	100.55	1257600.0
2017-12-22	AAT	Stock	37.67	38.03	36.95	37.74	181600.0
2017-12-22	AAU-DELISTED	Stock	1.04	1.05	1.02	1.03	258839.0
2017-12-22	AAUAF-DELISTED	Stock	1.04	1.05	1.02	1.04	261550.0
2017-12-22	AAV-DELISTED	Stock	4.3	4.3	4.1	4.125	193481.0
2017-12-22	AAWW-DELISTED	Stock	59.8	60.55	59.6	60.15	160239.0
2017-12-22	AAXJ	Stock	75.25	75.57	75.18	75.57	673386.0
2017-12-22	AAXN-DELISTED	Stock	26.41	26.52	26.05	26.45	239417.0
2017-12-22	AB	Stock	25.35	25.5	25.35	25.4	94200.0
2017-12-22	ABAC-DELISTED	Stock	2.91	3.0687	2.85	3.02	6751.0
2017-12-22	ABAX-DELISTED	Stock	48.79	49.7	48.465	49.62	95333.0
2017-12-22	ABB-DELISTED	Stock	26.62	26.62	26.53	26.6	801148.0
2017-12-22	ABBNY-DELISTED	Stock	26.62	26.62	26.53	26.6	851406.0
2017-12-22	ABBV	Stock	97.86	98.69	97.71	98.21	2835600.0
2017-12-22	ABC-DELISTED	Stock	93.41	93.41	91.5	92.47	1162578.0
2017-12-22	ABCB	Stock	49.45	49.45	48.85	49.15	110700.0
2017-12-22	ABCD-DELISTED	Stock	5.8	5.82	5.67	5.68	35572.0
2017-12-22	ABDC-DELISTED	Stock	8.6	8.749	8.6	8.7	99326.0
2017-12-22	ABE-DELISTED	Stock	14.42	14.5228	14.4	14.5	4009.0
2017-12-22	ABEO	Stock	375.0	401.25	368.75	396.25	29616.0
2017-12-22	ABEV	Stock	6.23	6.31	6.23	6.27	9291200.0
2017-12-22	ABG	Stock	64.9	65.0	63.85	64.45	554600.0
2017-12-22	ABIL-DELISTED	Stock	0.47	0.481	0.4	0.4399	312954.0
2017-12-22	ABLX-DELISTED	Stock	24.14	24.18	23.33	23.72	67551.0
2017-12-22	ABM	Stock	38.56	38.61	38.11	38.23	385900.0
2017-12-22	ABMD-DELISTED	Stock	190.92	191.8	190.06	191.69	115056.0

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

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