PREVIEW / stock_daily / 2017-01-26

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-26.parquet
  size:    216 KB
  rows:    6,495
  symbols: 3,100

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-01-26	AAPL	Stock	30.4175	30.61	30.4	30.485	105350400.0
2017-01-26	MSFT	Stock	64.12	64.54	63.55	64.27	43554600.0
2017-01-26	NVDA	Stock	2.6975	2.7488	2.6675	2.7413	458800000.0
2017-01-26	AMZN	Stock	41.7765	42.192	41.65	41.9575	71726000.0
2017-01-26	GOOGL	Stock	42.9525	43.05	42.526	42.849	69865020.0
2017-01-26	META	Stock	131.63	133.14	131.44	132.78	20020100.0
2017-01-26	TSLA	Stock	16.9527	17.0493	16.7167	16.834	47281500.0
2017-01-26	TLT	Stock	118.91	119.255	118.325	119.2	7827932.0
2017-01-26	ES	Stock	54.3	54.69	54.12	54.53	1541600.0
2017-01-26	CL	Stock	68.35	68.5	67.78	68.24	4655900.0
2017-01-26	A	Stock	48.42	48.43	47.92	48.17	1895400.0
2017-01-26	AA	Stock	36.22	37.07	35.51	36.3	5735400.0
2017-01-26	AAAP-DELISTED	Stock	30.51	31.16	30.37	30.73	64008.0
2017-01-26	AABA-DELISTED	Stock	44.83	45.08	44.4	44.53	8985652.0
2017-01-26	AAC-DELISTED	Stock	8.18	8.205	8.035	8.09	63304.0
2017-01-26	AACG	Stock	3.05	3.14	3.05	3.06	2500.0
2017-01-26	AAIC-DELISTED	Stock	15.32	15.375	15.19	15.26	169062.0
2017-01-26	AAL	Stock	48.43	49.71	48.33	49.59	10332800.0
2017-01-26	AAMC-DELISTED	Stock	18.3088	18.5148	17.3529	17.5441	36122.0
2017-01-26	AAME	Stock	3.75	3.75	3.61	3.65	9500.0
2017-01-26	AAMI	Stock	14.7	14.747	14.22	14.24	179700.0
2017-01-26	AAOI	Stock	31.88	32.16	31.26	31.28	364400.0
2017-01-26	AAON	Stock	23.0333	23.3	22.8333	23.2333	175350.0
2017-01-26	AAP	Stock	167.75	169.42	165.34	165.5	1301600.0
2017-01-26	AAT	Stock	43.45	43.68	42.93	43.03	97400.0
2017-01-26	AAU-DELISTED	Stock	1.01	1.03	1.0	1.01	144749.0
2017-01-26	AAUAF-DELISTED	Stock	1.01	1.03	1.0	1.02	149479.0
2017-01-26	AAV-DELISTED	Stock	6.7	6.7	6.5	6.55	83337.0
2017-01-26	AAWW-DELISTED	Stock	54.4	54.9	53.5	53.95	138169.0
2017-01-26	AAXJ	Stock	59.05	59.17	58.91	58.91	938185.0
2017-01-26	AAXN-DELISTED	Stock	25.11	25.26	24.73	24.89	227566.0
2017-01-26	AB	Stock	23.45	23.58	23.3	23.35	254700.0
2017-01-26	ABAC-DELISTED	Stock	3.84	3.84	3.75	3.75	780.0
2017-01-26	ABAX-DELISTED	Stock	48.05	48.13	46.92	47.21	204936.0
2017-01-26	ABB-DELISTED	Stock	23.85	23.9	23.68	23.79	2443140.0
2017-01-26	ABBNY-DELISTED	Stock	23.85	23.9	23.68	23.8	5785526.0
2017-01-26	ABBV	Stock	61.16	61.9	61.07	61.27	7765300.0
2017-01-26	ABC-DELISTED	Stock	82.0	85.195	81.04	83.39	3110644.0
2017-01-26	ABCB	Stock	46.0	46.0	45.35	45.65	183800.0
2017-01-26	ABCD-DELISTED	Stock	5.19	5.32	5.18	5.23	11160.0
2017-01-26	ABCO-DELISTED	Stock	44.05	45.05	43.8	44.75	776002.0
2017-01-26	ABDC-DELISTED	Stock	12.34	12.34	12.04	12.12	23507.0
2017-01-26	ABE-DELISTED	Stock	11.76	11.83	11.71	11.8	7420.0
2017-01-26	ABEO	Stock	121.25	123.75	120.0	122.5	2772.0
2017-01-26	ABEV	Stock	5.44	5.45	5.38	5.44	9924500.0
2017-01-26	ABG	Stock	67.1	67.7	64.95	65.15	236700.0
2017-01-26	ABIL-DELISTED	Stock	3.28	3.28	3.17	3.2	11605.0
2017-01-26	ABM	Stock	40.82	41.32	40.68	40.96	771300.0
2017-01-26	ABMD-DELISTED	Stock	116.49	116.49	105.13	106.07	1109402.0
2017-01-26	ABR	Stock	7.46	7.53	7.44	7.51	76100.0

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

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