PREVIEW / stock_daily / 2015-06-23

all stock daily files

  file:    by_date/stock_daily/2015/2015-06-23.parquet
  size:    225 KB
  rows:    6,673
  symbols: 3,509

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
2015-06-23	AAPL	Stock	31.87	31.9025	31.72	31.7575	121075600.0
2015-06-23	MSFT	Stock	46.13	46.28	45.62	45.91	25896500.0
2015-06-23	NVDA	Stock	0.5455	0.5498	0.5262	0.5305	414064000.0
2015-06-23	AMZN	Stock	21.7795	22.352	21.6845	22.2995	64900000.0
2015-06-23	GOOGL	Stock	27.9895	28.245	27.8575	28.1695	31396160.0
2015-06-23	META	Stock	84.96	87.97	84.76	87.88	50667900.0
2015-06-23	TSLA	Stock	17.3547	17.8667	17.238	17.8447	58062000.0
2015-06-23	TLT	Stock	115.73	116.96	115.69	115.95	8945108.0
2015-06-23	ES	Stock	46.44	46.55	45.78	45.85	1153400.0
2015-06-23	CL	Stock	67.07	67.27	66.84	67.01	1727500.0
2015-06-23	A	Stock	39.89	39.95	39.42	39.6	2053600.0
2015-06-23	AA.B-DELISTED	Stock	41.75	41.95	41.6	41.83	37367.0
2015-06-23	AABA-DELISTED	Stock	40.74	40.8	40.51	40.655	6205355.0
2015-06-23	AAC-DELISTED	Stock	44.17	45.24	43.88	44.25	216850.0
2015-06-23	AACG	Stock	5.29	5.43	5.05	5.36	14600.0
2015-06-23	AAIC-DELISTED	Stock	20.98	20.9937	20.82	20.87	401565.0
2015-06-23	AAL	Stock	42.98	43.42	42.35	42.73	10702000.0
2015-06-23	AAMC-DELISTED	Stock	46.3824	46.3999	45.5882	45.5971	11155.0
2015-06-23	AAME	Stock	3.55	3.71	3.55	3.69	3900.0
2015-06-23	AAMI	Stock	18.36	18.55	18.1	18.47	711300.0
2015-06-23	AAOI	Stock	18.07	18.47	17.93	17.99	104900.0
2015-06-23	AAON	Stock	15.5533	15.5733	15.3133	15.4	198150.0
2015-06-23	AAP	Stock	163.71	165.0	163.04	163.89	560300.0
2015-06-23	AAT	Stock	40.29	40.43	39.9	39.96	275400.0
2015-06-23	AAU-DELISTED	Stock	0.84	0.8479	0.807	0.8169	128272.0
2015-06-23	AAUAF-DELISTED	Stock	0.84	0.8447	0.804	0.82	129227.0
2015-06-23	AAV-DELISTED	Stock	6.38	6.48	6.34	6.4299	64831.0
2015-06-23	AAVL-DELISTED	Stock	16.76	17.0	16.0	16.37	1202796.0
2015-06-23	AAWW-DELISTED	Stock	55.54	56.54	55.29	56.11	581398.0
2015-06-23	AAXJ	Stock	65.36	65.64	65.35	65.62	1960997.0
2015-06-23	AAXN-DELISTED	Stock	33.77	34.8	33.42	34.64	2051142.0
2015-06-23	AB	Stock	30.35	30.35	29.91	30.0	214600.0
2015-06-23	ABAC-DELISTED	Stock	1.48	1.51	1.48	1.48	5473.0
2015-06-23	ABAX-DELISTED	Stock	53.01	53.45	52.43	52.44	111660.0
2015-06-23	ABB-DELISTED	Stock	22.27	22.35	22.18	22.28	1653604.0
2015-06-23	ABBNY-DELISTED	Stock	22.27	22.35	22.18	22.28	1709663.0
2015-06-23	ABBV	Stock	70.01	70.49	69.57	70.02	8720000.0
2015-06-23	ABC-DELISTED	Stock	112.18	112.47	111.58	111.8	919081.0
2015-06-23	ABCB	Stock	25.75	25.99	25.64	25.88	84900.0
2015-06-23	ABCD-DELISTED	Stock	4.16	4.25	4.16	4.24	40726.0
2015-06-23	ABCO-DELISTED	Stock	53.76	54.15	53.05	54.09	257311.0
2015-06-23	ABCW-DELISTED	Stock	37.3	37.3	37.05	37.16	25920.0
2015-06-23	ABDC-DELISTED	Stock	13.787	13.95	13.41	13.69	77456.0
2015-06-23	ABE-DELISTED	Stock	12.87	12.97	12.87	12.97	4187.0
2015-06-23	ABEO	Stock	162.75	178.75	162.75	171.0	25448.0
2015-06-23	ABEOW-DELISTED	Stock	2.9	2.9899	2.142	2.6	14512.0
2015-06-23	ABEV	Stock	6.16	6.17	6.11	6.15	5608400.0
2015-06-23	ABG	Stock	89.84	92.18	89.61	92.14	471400.0
2015-06-23	ABGB-DELISTED	Stock	17.09	17.18	17.07	17.13	4693.0
2015-06-23	ABIL-DELISTED	Stock	9.999	9.999	9.999	9.999	164.0

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

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