PREVIEW / stock_daily / 2013-09-30

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-30.parquet
  size:    213 KB
  rows:    6,414
  symbols: 3,551

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
2013-09-30	AAPL	Stock	17.0446	17.2021	16.9432	17.0268	260156400.0
2013-09-30	MSFT	Stock	33.0	33.31	32.7	33.28	39839500.0
2013-09-30	NVDA	Stock	0.3855	0.3918	0.3833	0.389	226640000.0
2013-09-30	AMZN	Stock	15.6705	15.7655	15.553	15.632	32472000.0
2013-09-30	META	Stock	50.14	51.6	49.8	50.23	100095000.0
2013-09-30	TSLA	Stock	12.6	12.9667	12.5333	12.8913	133870500.0
2013-09-30	TLT	Stock	106.66	106.9	106.1799	106.4	8439805.0
2013-09-30	ES	Stock	41.22	41.44	41.01	41.25	1528600.0
2013-09-30	CL	Stock	60.16	60.54	59.09	59.3	5172800.0
2013-09-30	A	Stock	36.495	36.9242	36.3019	36.6595	3704700.0
2013-09-30	AABA-DELISTED	Stock	33.02	33.75	32.68	33.17	28274698.0
2013-09-30	AACG	Stock	4.95	4.95	4.81	4.81	1400.0
2013-09-30	AAIC-DELISTED	Stock	24.42	24.45	23.65	23.78	439499.0
2013-09-30	AAMC-DELISTED	Stock	156.7647	156.7647	156.7647	156.7647	884.0
2013-09-30	AAME	Stock	4.03	4.05	3.9	4.05	8300.0
2013-09-30	AAMRQ-DELISTED	Stock	4.115	4.37	4.05	4.11	7182051.0
2013-09-30	AAOI	Stock	10.0	10.18	9.71	10.0	84900.0
2013-09-30	AAON	Stock	11.8222	11.9911	11.6489	11.8044	596925.0
2013-09-30	AAP	Stock	81.34	82.82	81.14	82.68	722700.0
2013-09-30	AAT	Stock	30.79	30.97	30.27	30.51	256600.0
2013-09-30	AAU-DELISTED	Stock	1.4	1.4	1.34	1.37	103656.0
2013-09-30	AAUAF-DELISTED	Stock	1.4	1.4	1.34	1.37	104056.0
2013-09-30	AAV-DELISTED	Stock	3.77	3.88	3.77	3.84	117651.0
2013-09-30	AAWW-DELISTED	Stock	45.4	46.52	45.28	46.1	182759.0
2013-09-30	AAXJ	Stock	58.21	58.335	57.9	58.28	338802.0
2013-09-30	AAXN-DELISTED	Stock	14.61	15.16	14.37	14.91	1225002.0
2013-09-30	AB	Stock	19.52	19.9	19.5	19.86	352000.0
2013-09-30	ABAC-DELISTED	Stock	0.97	1.02	0.9161	0.98	236100.0
2013-09-30	ABAX-DELISTED	Stock	41.08	42.17	40.9	42.15	69843.0
2013-09-30	ABB-DELISTED	Stock	23.48	23.71	23.45	23.58	1130795.0
2013-09-30	ABBNY-DELISTED	Stock	23.48	23.71	23.45	23.59	1160156.0
2013-09-30	ABBV	Stock	44.52	44.95	44.03	44.73	5818400.0
2013-09-30	ABC-DELISTED	Stock	60.9	61.27	60.69	61.12	1019266.0
2013-09-30	ABCB	Stock	18.46	18.51	18.15	18.38	96900.0
2013-09-30	ABCD-DELISTED	Stock	1.56	1.62	1.4802	1.565	17112.0
2013-09-30	ABCO-DELISTED	Stock	58.3	59.67	58.05	59.57	94466.0
2013-09-30	ABE-DELISTED	Stock	19.46	19.5253	19.46	19.47	4392.0
2013-09-30	ABEO	Stock	487.5	562.5	462.5	562.5	30.0
2013-09-30	ABFS-DELISTED	Stock	25.3	25.94	25.05	25.68	303740.0
2013-09-30	ABG	Stock	52.93	53.72	52.53	53.2	379300.0
2013-09-30	ABM	Stock	26.35	26.75	26.32	26.62	179300.0
2013-09-30	ABMD-DELISTED	Stock	18.64	19.14	18.501	19.07	442155.0
2013-09-30	ABR	Stock	6.82	6.85	6.74	6.78	286500.0
2013-09-30	ABR.A-DELISTED	Stock	24.69	24.73	24.02	24.73	2650.0
2013-09-30	ABR.B-DELISTED	Stock	23.5	23.5	23.5	23.5	1300.0
2013-09-30	ABT	Stock	33.05	33.42	33.02	33.19	9418700.0
2013-09-30	ABTL-DELISTED	Stock	7.01	7.23	7.0	7.18	59683.0
2013-09-30	ABUS	Stock	7.35	7.35	6.93	6.95	147800.0
2013-09-30	ABV-DELISTED	Stock	38.65	38.68	38.24	38.35	2103652.0
2013-09-30	ABX-DELISTED	Stock	18.37	18.82	18.3	18.61	10478441.0

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

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