PREVIEW / stock_daily / 2013-04-29

all stock daily files

  file:    by_date/stock_daily/2013/2013-04-29.parquet
  size:    208 KB
  rows:    6,332
  symbols: 3,524

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-04-29	AAPL	Stock	15.0161	15.4864	15.0	15.3614	640326400.0
2013-04-29	MSFT	Stock	31.8	32.68	31.77	32.61	59116400.0
2013-04-29	NVDA	Stock	0.3358	0.3405	0.3342	0.3393	269712000.0
2013-04-29	AMZN	Stock	12.745	12.8505	12.4575	12.487	142340000.0
2013-04-29	META	Stock	27.16	27.41	26.86	26.98	29201100.0
2013-04-29	TSLA	Stock	3.4507	3.666	3.4133	3.6627	54595500.0
2013-04-29	TLT	Stock	123.58	123.7301	122.76	122.94	4915923.0
2013-04-29	ES	Stock	44.95	45.22	44.82	45.06	1174000.0
2013-04-29	CL	Stock	59.625	59.965	59.53	59.685	2610600.0
2013-04-29	A	Stock	29.7854	29.814	29.3634	29.6567	3552178.0
2013-04-29	AABA-DELISTED	Stock	24.85	24.91	24.35	24.42	12348023.0
2013-04-29	AACC-DELISTED	Stock	6.49	6.5	6.47	6.48	613223.0
2013-04-29	AAIC-DELISTED	Stock	27.04	27.59	27.0	27.32	328280.0
2013-04-29	AAMC-DELISTED	Stock	64.1176	64.6912	56.4706	58.8235	45448.0
2013-04-29	AAME	Stock	3.52	3.62	3.52	3.55	10100.0
2013-04-29	AAMRQ-DELISTED	Stock	4.01	4.23	3.99	4.2	7286743.0
2013-04-29	AAON	Stock	8.3911	8.4741	8.3259	8.3526	115088.0
2013-04-29	AAP	Stock	83.0	83.58	82.76	83.02	764800.0
2013-04-29	AAT	Stock	32.77	33.42	32.52	33.13	143500.0
2013-04-29	AAU-DELISTED	Stock	1.77	1.77	1.68	1.68	107813.0
2013-04-29	AAUAF-DELISTED	Stock	1.77	1.77	1.68	1.68	108115.0
2013-04-29	AAV-DELISTED	Stock	3.86	4.02	3.85	3.94	755759.0
2013-04-29	AAWW-DELISTED	Stock	37.79	38.57	37.5	37.84	209370.0
2013-04-29	AAXJ	Stock	59.55	59.85	59.37	59.68	405589.0
2013-04-29	AAXN-DELISTED	Stock	8.99	8.99	8.7	8.71	656986.0
2013-04-29	AB	Stock	23.79	23.91	23.5	23.85	264300.0
2013-04-29	ABAC-DELISTED	Stock	0.7	0.72	0.7	0.719	20291.0
2013-04-29	ABAX-DELISTED	Stock	41.4	42.67	41.4	42.43	319530.0
2013-04-29	ABB-DELISTED	Stock	23.14	23.3	23.11	23.24	1100358.0
2013-04-29	ABBNY-DELISTED	Stock	23.12	23.3	23.11	23.23	1158733.0
2013-04-29	ABBV	Stock	45.83	45.93	45.05	45.23	6024700.0
2013-04-29	ABC-DELISTED	Stock	53.33	54.28	53.25	54.059	3077519.0
2013-04-29	ABCB	Stock	13.89	13.99	13.58	13.78	18700.0
2013-04-29	ABCD-DELISTED	Stock	0.9512	0.98	0.95	0.9699	8396.0
2013-04-29	ABCO-DELISTED	Stock	47.21	48.51	46.9	48.45	159120.0
2013-04-29	ABCW-DELISTED	Stock	0.64	0.67	0.64	0.66	14252.0
2013-04-29	ABE-DELISTED	Stock	21.38	21.42	21.25	21.34	2574.0
2013-04-29	ABEO	Stock	475.0	525.0	462.5	525.0	70.0
2013-04-29	ABFS-DELISTED	Stock	11.63	11.89	11.51	11.54	205851.0
2013-04-29	ABG	Stock	39.88	40.17	39.45	39.84	227300.0
2013-04-29	ABM	Stock	21.92	22.57	21.83	22.54	352500.0
2013-04-29	ABMD-DELISTED	Stock	18.0	18.21	17.74	18.12	102179.0
2013-04-29	ABR	Stock	7.58	7.7	7.54	7.67	111500.0
2013-04-29	ABR.A-DELISTED	Stock	25.93	25.96	25.89	25.9	13752.0
2013-04-29	ABT	Stock	36.49	36.79	36.4	36.73	3111800.0
2013-04-29	ABTL-DELISTED	Stock	4.24	4.32	4.24	4.3001	11695.0
2013-04-29	ABUS	Stock	4.82	4.92	4.78	4.84	50600.0
2013-04-29	ABV-DELISTED	Stock	39.21	39.21	38.49	39.02	2662453.0
2013-04-29	ABX-DELISTED	Stock	18.97	19.35	18.81	19.26	15928491.0
2013-04-29	ACAD	Stock	13.4	13.92	13.07	13.19	3558600.0

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

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