PREVIEW / stock_daily / 2017-02-27

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-27.parquet
  size:    216 KB
  rows:    6,502
  symbols: 3,085

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-02-27	AAPL	Stock	34.285	34.36	34.07	34.2325	81029600.0
2017-02-27	MSFT	Stock	64.54	64.54	64.05	64.23	15871500.0
2017-02-27	NVDA	Stock	2.555	2.6255	2.539	2.6102	715400000.0
2017-02-27	AMZN	Stock	42.119	42.625	41.9835	42.432	54272000.0
2017-02-27	GOOGL	Stock	42.2475	42.5335	42.1505	42.4835	20206660.0
2017-02-27	META	Stock	135.26	137.18	135.02	136.41	14306700.0
2017-02-27	TSLA	Stock	16.5447	16.5573	16.134	16.4153	171912000.0
2017-02-27	TLT	Stock	121.81	121.9	121.225	121.29	11039831.0
2017-02-27	ES	Stock	58.98	59.1	58.67	58.72	1333600.0
2017-02-27	CL	Stock	72.69	73.02	72.18	72.65	5201400.0
2017-02-27	A	Stock	51.74	51.94	51.46	51.66	1195100.0
2017-02-27	AA	Stock	34.52	35.38	34.19	34.78	3898400.0
2017-02-27	AAAP-DELISTED	Stock	37.0	37.45	36.76	37.23	233789.0
2017-02-27	AABA-DELISTED	Stock	45.45	45.74	45.24	45.7	3824282.0
2017-02-27	AAC-DELISTED	Stock	7.55	7.68	7.45	7.59	157455.0
2017-02-27	AACG	Stock	3.82	3.91	3.82	3.91	10200.0
2017-02-27	AAIC-DELISTED	Stock	14.86	14.96	14.72	14.82	270562.0
2017-02-27	AAL	Stock	46.18	46.36	45.68	46.32	4130500.0
2017-02-27	AAMC-DELISTED	Stock	20.4412	21.3971	20.4412	20.9118	13141.0
2017-02-27	AAME	Stock	4.1	4.1	3.95	4.0	6600.0
2017-02-27	AAMI	Stock	15.14	15.21	14.99	15.03	302200.0
2017-02-27	AAOI	Stock	46.05	47.78	44.42	47.46	1876200.0
2017-02-27	AAON	Stock	22.9667	23.0	22.5333	22.7667	278250.0
2017-02-27	AAP	Stock	156.85	157.39	155.36	156.94	1443300.0
2017-02-27	AAT	Stock	44.31	44.56	44.12	44.33	240900.0
2017-02-27	AAU-DELISTED	Stock	1.18	1.2194	1.11	1.11	220578.0
2017-02-27	AAUAF-DELISTED	Stock	1.18	1.2194	1.11	1.11	222957.0
2017-02-27	AAV-DELISTED	Stock	6.15	6.15	6.0226	6.05	102678.0
2017-02-27	AAWW-DELISTED	Stock	55.6	58.0	55.5	57.45	199844.0
2017-02-27	AAXJ	Stock	60.79	60.93	60.7	60.83	538032.0
2017-02-27	AAXN-DELISTED	Stock	25.67	26.23	25.63	26.08	999731.0
2017-02-27	AB	Stock	23.7	23.8	23.4	23.65	396800.0
2017-02-27	ABAC-DELISTED	Stock	2.86	2.97	2.8584	2.92	6488.0
2017-02-27	ABAX-DELISTED	Stock	49.6	51.28	49.305	51.05	147351.0
2017-02-27	ABB-DELISTED	Stock	22.44	22.56	22.4	22.5	1906407.0
2017-02-27	ABBNY-DELISTED	Stock	22.44	22.56	22.4	22.5	1951613.0
2017-02-27	ABBV	Stock	62.02	62.37	61.68	62.22	5214100.0
2017-02-27	ABC-DELISTED	Stock	92.31	92.74	91.3	91.73	946476.0
2017-02-27	ABCB	Stock	48.65	49.1	48.55	48.95	113800.0
2017-02-27	ABCD-DELISTED	Stock	4.95	5.0	4.8901	4.94	22859.0
2017-02-27	ABCO-DELISTED	Stock	45.4	46.625	45.2	46.6	1892856.0
2017-02-27	ABDC-DELISTED	Stock	12.58	12.629	12.21	12.51	52015.0
2017-02-27	ABE-DELISTED	Stock	12.15	12.21	12.11	12.1617	44001.0
2017-02-27	ABEO	Stock	136.25	138.75	130.0	138.75	10952.0
2017-02-27	ABEOW-DELISTED	Stock	3.0	3.0	3.0	3.0	500.0
2017-02-27	ABEV	Stock	5.73	5.76	5.67	5.74	4580700.0
2017-02-27	ABG	Stock	66.45	67.39	65.85	66.95	312900.0
2017-02-27	ABIL-DELISTED	Stock	2.7	2.75	2.63	2.65	18317.0
2017-02-27	ABM	Stock	41.06	41.58	41.05	41.58	241000.0
2017-02-27	ABMD-DELISTED	Stock	117.36	118.84	116.545	117.94	673965.0

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

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