PREVIEW / stock_daily / 2012-04-13

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-13.parquet
  size:    197 KB
  rows:    6,137
  symbols: 3,525

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
2012-04-13	AAPL	Stock	22.2896	22.3107	21.5539	21.6154	859644800.0
2012-04-13	MSFT	Stock	30.89	31.16	30.72	30.81	39749200.0
2012-04-13	NVDA	Stock	0.3638	0.3658	0.3538	0.354	311324000.0
2012-04-13	AMZN	Stock	9.495	9.497	9.313	9.423	68636000.0
2012-04-13	TSLA	Stock	2.2627	2.2693	2.19	2.2393	9744000.0
2012-04-13	TLT	Stock	116.15	116.9	116.12	116.84	8607985.0
2012-04-13	ES	Stock	35.94	36.31	35.75	35.8	3145400.0
2012-04-13	CL	Stock	48.73	48.97	48.37	48.605	12762000.0
2012-04-13	A	Stock	30.9084	30.98	30.1788	30.2146	3344156.0
2012-04-13	AABA-DELISTED	Stock	14.99	15.18	14.86	14.86	15027157.0
2012-04-13	AACC-DELISTED	Stock	4.9	5.0	4.86	5.0	10850.0
2012-04-13	AACG	Stock	6.9	6.92	6.9	6.91	700.0
2012-04-13	AAIC-DELISTED	Stock	22.63	22.63	22.34	22.44	71319.0
2012-04-13	AAME	Stock	2.83	2.92	2.63	2.92	4100.0
2012-04-13	AAMRQ-DELISTED	Stock	0.49	0.5	0.48	0.5	2573573.0
2012-04-13	AAON	Stock	5.7156	5.757	5.6711	5.7481	243000.0
2012-04-13	AAP	Stock	89.85	90.85	89.84	90.15	713900.0
2012-04-13	AAT	Stock	22.66	22.75	22.42	22.45	102700.0
2012-04-13	AAU-DELISTED	Stock	2.43	2.43	2.28	2.36	72879.0
2012-04-13	AAUAF-DELISTED	Stock	2.43	2.43	2.28	2.36	73179.0
2012-04-13	AAV-DELISTED	Stock	3.0	3.02	2.93	2.93	177370.0
2012-04-13	AAWW-DELISTED	Stock	47.18	47.48	46.61	46.98	200768.0
2012-04-13	AAXJ	Stock	56.5	56.5	55.72	55.8	7285952.0
2012-04-13	AAXN-DELISTED	Stock	4.2	4.2	4.06	4.09	606225.0
2012-04-13	AB	Stock	14.45	15.04	14.06	14.79	318800.0
2012-04-13	ABAC-DELISTED	Stock	1.65	1.71	1.65	1.65	1960.0
2012-04-13	ABAX-DELISTED	Stock	27.55	27.7	26.21	26.47	184745.0
2012-04-13	ABB-DELISTED	Stock	19.65	19.66	19.36	19.37	1662603.0
2012-04-13	ABBNY-DELISTED	Stock	19.65	19.66	19.35	19.35	1846727.0
2012-04-13	ABC-DELISTED	Stock	38.03	38.34	37.49	37.52	3775876.0
2012-04-13	ABCB	Stock	13.07	13.07	12.79	12.8	42500.0
2012-04-13	ABCD-DELISTED	Stock	2.56	2.56	2.4	2.41	33720.0
2012-04-13	ABCO-DELISTED	Stock	42.52	43.06	42.42	42.95	305965.0
2012-04-13	ABCW-DELISTED	Stock	0.8836	0.9539	0.8836	0.8836	5020.0
2012-04-13	ABD-DELISTED	Stock	11.75	11.77	11.44	11.53	786550.0
2012-04-13	ABE-DELISTED	Stock	19.27	19.27	19.09	19.09	6700.0
2012-04-13	ABEO	Stock	1412.5	1437.5	1375.0	1437.5	19.0
2012-04-13	ABFS-DELISTED	Stock	18.5	18.54	17.87	17.9	397614.0
2012-04-13	ABG	Stock	27.55	27.98	27.12	27.39	300100.0
2012-04-13	ABH-DELISTED	Stock	13.41	13.5	13.26	13.45	133781.0
2012-04-13	ABM	Stock	23.46	23.64	23.2	23.27	156600.0
2012-04-13	ABMD-DELISTED	Stock	21.0	21.06	20.55	20.61	219694.0
2012-04-13	ABR	Stock	5.53	5.59	5.38	5.56	14300.0
2012-04-13	ABT	Stock	28.6824	28.74	28.4905	28.5913	11921634.0
2012-04-13	ABTL-DELISTED	Stock	4.6129	4.7227	4.4123	4.5371	22868.0
2012-04-13	ABUS	Stock	2.35	2.42	2.26	2.3	10600.0
2012-04-13	ABV-DELISTED	Stock	42.45	42.91	42.2	42.73	2318296.0
2012-04-13	ABVA-DELISTED	Stock	4.42	4.42	4.18	4.18	430.0
2012-04-13	ABVT-DELISTED	Stock	83.08	83.2	83.08	83.2	447273.0
2012-04-13	ABX-DELISTED	Stock	42.13	42.14	41.32	41.6	5733276.0

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

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