PREVIEW / stock_daily / 2017-05-10

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-10.parquet
  size:    215 KB
  rows:    6,421
  symbols: 3,001

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-05-10	AAPL	Stock	38.4075	38.485	38.0275	38.315	103222800.0
2017-05-10	MSFT	Stock	68.99	69.56	68.92	69.31	17977800.0
2017-05-10	NVDA	Stock	2.8573	3.0455	2.8505	3.0323	2129096000.0
2017-05-10	AMZN	Stock	47.675	47.6875	47.25	47.4475	41930000.0
2017-05-10	GOOGL	Stock	47.811	47.8355	47.492	47.742	22919380.0
2017-05-10	META	Stock	150.23	150.52	148.86	150.29	12080700.0
2017-05-10	TSLA	Stock	21.4373	21.7	21.208	21.6813	86124000.0
2017-05-10	TLT	Stock	120.91	121.06	120.16	120.48	6517131.0
2017-05-10	ES	Stock	59.38	59.5	58.97	59.23	1168200.0
2017-05-10	CL	Stock	71.47	71.9	71.27	71.8	3240200.0
2017-05-10	A	Stock	56.85	56.94	56.08	56.27	1566300.0
2017-05-10	AA	Stock	30.95	31.46	30.7	31.08	3487500.0
2017-05-10	AAAP-DELISTED	Stock	36.88	36.88	36.14	36.6	22076.0
2017-05-10	AABA-DELISTED	Stock	49.47	49.6	49.14	49.405	7856888.0
2017-05-10	AAC-DELISTED	Stock	7.03	7.36	7.0	7.19	90198.0
2017-05-10	AACG	Stock	3.66	3.67	3.47	3.6	41800.0
2017-05-10	AAIC-DELISTED	Stock	14.13	14.32	14.1	14.23	329937.0
2017-05-10	AAL	Stock	47.03	47.78	46.67	47.3	7379800.0
2017-05-10	AAM.A-DELISTED	Stock	25.75	25.82	25.73	25.8	72388.0
2017-05-10	AAMC-DELISTED	Stock	22.2647	22.2647	21.6618	21.7647	79234.0
2017-05-10	AAMI	Stock	15.64	15.73	15.47	15.59	267800.0
2017-05-10	AAOI	Stock	61.81	65.0	61.36	64.97	3932300.0
2017-05-10	AAON	Stock	24.6	24.7333	24.3	24.3667	135750.0
2017-05-10	AAP	Stock	145.83	146.26	145.15	146.16	383800.0
2017-05-10	AAT	Stock	40.04	40.48	39.76	40.14	194900.0
2017-05-10	AAU-DELISTED	Stock	1.31	1.32	1.26	1.29	518309.0
2017-05-10	AAUAF-DELISTED	Stock	1.31	1.32	1.26	1.29	520776.0
2017-05-10	AAV-DELISTED	Stock	6.15	6.55	6.15	6.5	195359.0
2017-05-10	AAWW-DELISTED	Stock	52.2	52.65	51.3	51.3	164723.0
2017-05-10	AAXJ	Stock	65.32	65.54	65.2	65.54	1241306.0
2017-05-10	AAXN-DELISTED	Stock	26.97	28.17	25.66	26.25	3291694.0
2017-05-10	AB	Stock	21.0	21.05	20.75	20.85	823900.0
2017-05-10	ABAC-DELISTED	Stock	1.7902	1.7902	1.7	1.74	17985.0
2017-05-10	ABAX-DELISTED	Stock	47.92	49.0	47.92	48.81	87359.0
2017-05-10	ABB-DELISTED	Stock	24.59	24.68	24.54	24.67	3103787.0
2017-05-10	ABBNY-DELISTED	Stock	24.59	24.68	24.54	24.67	3156585.0
2017-05-10	ABBV	Stock	66.16	66.23	65.36	65.98	5140200.0
2017-05-10	ABC-DELISTED	Stock	87.57	88.71	87.56	88.15	1096382.0
2017-05-10	ABCB	Stock	46.4	47.03	46.3	46.6	93800.0
2017-05-10	ABCD-DELISTED	Stock	5.12	5.23	5.07	5.22	43974.0
2017-05-10	ABCO-DELISTED	Stock	51.9	52.3	51.6	51.95	233317.0
2017-05-10	ABDC-DELISTED	Stock	14.26	14.5	14.11	14.34	41951.0
2017-05-10	ABE-DELISTED	Stock	13.81	13.84	13.7665	13.79	5520.0
2017-05-10	ABEO	Stock	145.0	148.75	140.0	147.5	4884.0
2017-05-10	ABEV	Stock	6.01	6.07	5.98	6.02	24760100.0
2017-05-10	ABG	Stock	58.15	58.65	57.4	57.9	221700.0
2017-05-10	ABIL-DELISTED	Stock	0.75	0.88	0.75	0.75	18877.0
2017-05-10	ABM	Stock	43.1	43.15	42.75	43.03	382600.0
2017-05-10	ABMD-DELISTED	Stock	130.63	131.825	129.83	131.77	129374.0
2017-05-10	ABR	Stock	8.68	8.75	8.63	8.74	265500.0

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

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