PREVIEW / stock_daily / 2017-05-25

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-25.parquet
  size:    215 KB
  rows:    6,461
  symbols: 3,011

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-25	AAPL	Stock	38.4325	38.5875	38.2575	38.4675	76942400.0
2017-05-25	MSFT	Stock	68.97	69.88	68.91	69.62	21854100.0
2017-05-25	NVDA	Stock	3.5	3.5008	3.411	3.4565	608228000.0
2017-05-25	AMZN	Stock	49.2425	49.95	49.1055	49.669	96440000.0
2017-05-25	GOOGL	Stock	48.95	49.789	48.891	49.593	39082980.0
2017-05-25	META	Stock	150.3	152.59	149.95	151.96	19891400.0
2017-05-25	TSLA	Stock	20.7347	21.1313	20.5207	21.122	75210000.0
2017-05-25	TLT	Stock	123.02	123.28	122.76	123.27	6464812.0
2017-05-25	ES	Stock	61.4	61.94	61.19	61.84	909800.0
2017-05-25	CL	Stock	74.75	75.58	74.65	75.37	3410500.0
2017-05-25	A	Stock	59.53	59.7	58.92	59.3	2772200.0
2017-05-25	AA	Stock	33.68	34.09	33.03	33.09	2324900.0
2017-05-25	AAAP-DELISTED	Stock	38.75	39.6	38.61	39.39	129353.0
2017-05-25	AABA-DELISTED	Stock	50.48	50.75	50.05	50.6	9842199.0
2017-05-25	AAC-DELISTED	Stock	7.01	7.12	6.51	6.6	258198.0
2017-05-25	AACG	Stock	3.54	3.56	3.5	3.54	5700.0
2017-05-25	AAIC-DELISTED	Stock	14.51	14.76	14.51	14.61	362111.0
2017-05-25	AAL	Stock	46.99	48.12	46.82	48.02	5441800.0
2017-05-25	AAM.A-DELISTED	Stock	25.71	25.78	25.6505	25.7786	72258.0
2017-05-25	AAMC-DELISTED	Stock	26.3529	27.1618	25.7353	27.0441	52183.0
2017-05-25	AAME	Stock	3.75	3.75	3.65	3.75	2100.0
2017-05-25	AAMI	Stock	13.89	14.05	13.79	13.91	571700.0
2017-05-25	AAOI	Stock	68.8	69.89	66.3	67.88	2555900.0
2017-05-25	AAON	Stock	24.7	24.7	24.1667	24.3	123900.0
2017-05-25	AAP	Stock	133.0	134.07	129.4	131.97	3933600.0
2017-05-25	AAT	Stock	39.81	39.94	39.51	39.54	205500.0
2017-05-25	AAU-DELISTED	Stock	1.26	1.42	1.26	1.4189	664120.0
2017-05-25	AAUAF-DELISTED	Stock	1.26	1.42	1.26	1.42	683776.0
2017-05-25	AAV-DELISTED	Stock	6.55	6.7	6.35	6.35	95148.0
2017-05-25	AAWW-DELISTED	Stock	48.85	50.25	48.8	50.1	246374.0
2017-05-25	AAXJ	Stock	66.98	67.145	66.96	67.1	329976.0
2017-05-25	AAXN-DELISTED	Stock	24.96	25.15	24.765	24.98	480588.0
2017-05-25	AB	Stock	20.9	21.45	20.9	21.25	484700.0
2017-05-25	ABAC-DELISTED	Stock	1.94	2.25	1.9	2.02	26865.0
2017-05-25	ABAX-DELISTED	Stock	48.89	49.22	48.19	48.97	72209.0
2017-05-25	ABB-DELISTED	Stock	25.05	25.1	24.98	25.065	631398.0
2017-05-25	ABBNY-DELISTED	Stock	25.05	25.1	24.98	25.07	662378.0
2017-05-25	ABBV	Stock	66.06	66.57	65.8	66.32	4058300.0
2017-05-25	ABC-DELISTED	Stock	90.0	91.43	89.83	91.11	905856.0
2017-05-25	ABCB	Stock	45.45	45.65	44.85	45.1	109500.0
2017-05-25	ABCD-DELISTED	Stock	4.99	5.04	4.99	5.02	10128.0
2017-05-25	ABCO-DELISTED	Stock	50.95	51.85	50.5	51.4	236131.0
2017-05-25	ABDC-DELISTED	Stock	13.43	13.56	13.4	13.4	68330.0
2017-05-25	ABE-DELISTED	Stock	13.71	14.0	13.71	14.0	15539.0
2017-05-25	ABEO	Stock	151.25	153.25	142.5	142.5	5028.0
2017-05-25	ABEV	Stock	5.75	5.78	5.67	5.72	20308700.0
2017-05-25	ABG	Stock	56.95	57.1	55.25	55.8	272800.0
2017-05-25	ABIL-DELISTED	Stock	0.672	0.6807	0.6	0.6081	40040.0
2017-05-25	ABM	Stock	42.38	42.44	41.99	42.3	314700.0
2017-05-25	ABMD-DELISTED	Stock	135.33	136.735	134.39	135.82	207058.0

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

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