PREVIEW / stock_daily / 2012-03-01

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-01.parquet
  size:    198 KB
  rows:    6,152
  symbols: 3,540

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-03-01	AAPL	Stock	19.5775	19.5789	19.2418	19.4454	683270000.0
2012-03-01	MSFT	Stock	31.93	32.39	31.85	32.29	77344100.0
2012-03-01	NVDA	Stock	0.3803	0.3858	0.3788	0.3813	449944000.0
2012-03-01	AMZN	Stock	8.9945	9.0245	8.829	9.002	98720000.0
2012-03-01	TSLA	Stock	2.234	2.3	2.2207	2.294	10552500.0
2012-03-01	TLT	Stock	116.17	116.68	115.54	116.06	12265622.0
2012-03-01	ES	Stock	35.94	36.29	35.83	36.04	2241500.0
2012-03-01	CL	Stock	46.5	46.75	46.305	46.425	4123600.0
2012-03-01	A	Stock	31.2876	31.6738	31.1159	31.588	3324863.0
2012-03-01	AABA-DELISTED	Stock	14.89	14.96	14.79	14.94	11920175.0
2012-03-01	AACC-DELISTED	Stock	4.77	4.89	4.5	4.645	20934.0
2012-03-01	AACG	Stock	6.2	6.2	5.84	5.91	12800.0
2012-03-01	AAIC-DELISTED	Stock	23.25	23.3	22.94	22.94	37280.0
2012-03-01	AAME	Stock	2.8	2.8	2.64	2.7	11300.0
2012-03-01	AAMRQ-DELISTED	Stock	0.5025	0.508	0.49	0.504	3659142.0
2012-03-01	AAON	Stock	5.5437	5.6444	5.4637	5.4815	191363.0
2012-03-01	AAP	Stock	85.73	86.39	85.25	85.98	1159500.0
2012-03-01	AAT	Stock	21.52	21.88	21.06	21.26	249000.0
2012-03-01	AAU-DELISTED	Stock	3.01	3.12	3.0	3.01	257885.0
2012-03-01	AAUAF-DELISTED	Stock	3.01	3.12	3.0	3.01	258085.0
2012-03-01	AAV-DELISTED	Stock	3.86	3.98	3.83	3.93	555772.0
2012-03-01	AAWW-DELISTED	Stock	42.77	44.82	42.44	43.49	348157.0
2012-03-01	AAXJ	Stock	58.08	58.61	58.08	58.44	339298.0
2012-03-01	AAXN-DELISTED	Stock	4.17	4.35	4.12	4.22	1108747.0
2012-03-01	AB	Stock	14.0	14.37	13.96	14.3	373800.0
2012-03-01	ABAC-DELISTED	Stock	1.63	1.68	1.63	1.63	14465.0
2012-03-01	ABAX-DELISTED	Stock	26.59	26.9	26.4	26.46	75465.0
2012-03-01	ABB-DELISTED	Stock	20.69	20.77	20.52	20.71	1914844.0
2012-03-01	ABBNY-DELISTED	Stock	20.69	20.77	20.52	20.7	2118834.0
2012-03-01	ABC-DELISTED	Stock	37.19	37.6199	37.19	37.3	2715096.0
2012-03-01	ABCB	Stock	11.55	11.94	11.52	11.52	135900.0
2012-03-01	ABCD-DELISTED	Stock	2.91	3.01	2.87	2.91	21662.0
2012-03-01	ABCO-DELISTED	Stock	40.78	41.49	40.26	41.08	292978.0
2012-03-01	ABCW-DELISTED	Stock	0.4016	0.4317	0.4016	0.4317	16190.0
2012-03-01	ABD-DELISTED	Stock	11.8	12.121	11.77	12.03	789580.0
2012-03-01	ABE-DELISTED	Stock	19.4	19.57	19.36	19.57	11629.0
2012-03-01	ABEO	Stock	1725.0	1737.5	1637.5	1687.5	34.0
2012-03-01	ABFS-DELISTED	Stock	17.95	18.4	17.84	18.14	216777.0
2012-03-01	ABG	Stock	26.21	27.13	26.07	26.51	1001900.0
2012-03-01	ABH-DELISTED	Stock	15.34	15.46	15.11	15.38	245149.0
2012-03-01	ABM	Stock	22.79	23.37	22.72	23.0	365200.0
2012-03-01	ABMD-DELISTED	Stock	21.07	21.25	20.64	21.1	414746.0
2012-03-01	ABR	Stock	4.74	4.8	4.7	4.75	28000.0
2012-03-01	ABT	Stock	27.1567	27.5501	27.1471	27.5021	13641100.0
2012-03-01	ABTL-DELISTED	Stock	4.75	5.0505	4.75	5.05	45025.0
2012-03-01	ABUS	Stock	2.8	2.91	2.66	2.77	12900.0
2012-03-01	ABV-DELISTED	Stock	39.95	40.02	39.5	39.93	2644400.0
2012-03-01	ABVA-DELISTED	Stock	3.75	4.5	3.6	3.81	25250.0
2012-03-01	ABVT-DELISTED	Stock	69.47	70.5	69.21	70.16	209674.0
2012-03-01	ABX-DELISTED	Stock	47.9	48.59	47.44	47.98	6146883.0

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

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