PREVIEW / stock_daily / 2012-03-07

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-07.parquet
  size:    198 KB
  rows:    6,141
  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-03-07	AAPL	Stock	19.1714	19.2064	18.6893	18.9532	798520800.0
2012-03-07	MSFT	Stock	31.67	31.92	31.53	31.84	34340400.0
2012-03-07	NVDA	Stock	0.37	0.3718	0.365	0.3703	441984000.0
2012-03-07	AMZN	Stock	9.1325	9.275	9.12	9.1885	99030000.0
2012-03-07	TSLA	Stock	2.208	2.2207	2.194	2.208	5473500.0
2012-03-07	TLT	Stock	117.46	117.61	116.8099	116.91	5567472.0
2012-03-07	ES	Stock	35.93	36.31	35.72	36.24	1092600.0
2012-03-07	CL	Stock	46.635	46.775	46.25	46.415	4056000.0
2012-03-07	A	Stock	30.3791	31.2375	30.279	31.0873	4884612.0
2012-03-07	AABA-DELISTED	Stock	14.48	14.71	14.44	14.62	10238935.0
2012-03-07	AACC-DELISTED	Stock	4.38	4.57	4.35	4.39	25146.0
2012-03-07	AACG	Stock	5.9	5.94	5.78	5.9	8100.0
2012-03-07	AAIC-DELISTED	Stock	23.01	23.15	22.8	22.96	49970.0
2012-03-07	AAME	Stock	2.8	2.89	2.75	2.76	18500.0
2012-03-07	AAMRQ-DELISTED	Stock	0.46	0.484	0.42	0.472	1878080.0
2012-03-07	AAON	Stock	5.3452	5.3719	5.2593	5.357	182250.0
2012-03-07	AAP	Stock	87.05	87.14	86.27	86.8	1218400.0
2012-03-07	AAT	Stock	21.63	21.67	21.1	21.49	287600.0
2012-03-07	AAU-DELISTED	Stock	2.65	2.76	2.63	2.72	189753.0
2012-03-07	AAUAF-DELISTED	Stock	2.65	2.76	2.63	2.72	189953.0
2012-03-07	AAV-DELISTED	Stock	3.6	3.77	3.55	3.72	291566.0
2012-03-07	AAWW-DELISTED	Stock	41.76	43.36	41.2188	43.04	373739.0
2012-03-07	AAXJ	Stock	56.0	56.26	55.8012	56.17	235018.0
2012-03-07	AAXN-DELISTED	Stock	4.02	4.04	3.98	3.99	308519.0
2012-03-07	AB	Stock	14.5	14.97	14.17	14.88	456400.0
2012-03-07	ABAC-DELISTED	Stock	1.59	1.6	1.5	1.5	18805.0
2012-03-07	ABAX-DELISTED	Stock	27.0	27.06	26.65	26.71	73508.0
2012-03-07	ABB-DELISTED	Stock	19.79	19.9	19.68	19.82	2261725.0
2012-03-07	ABBNY-DELISTED	Stock	19.79	19.9	19.68	19.82	2262625.0
2012-03-07	ABC-DELISTED	Stock	36.4	36.91	36.31	36.82	1630170.0
2012-03-07	ABCB	Stock	11.6	11.8	11.52	11.75	34900.0
2012-03-07	ABCD-DELISTED	Stock	2.96	3.15	2.85	2.92	11953.0
2012-03-07	ABCO-DELISTED	Stock	41.1	41.1	40.57	40.99	177751.0
2012-03-07	ABCW-DELISTED	Stock	0.3916	0.502	0.3916	0.502	4280.0
2012-03-07	ABD-DELISTED	Stock	11.35	11.72	11.2	11.53	292140.0
2012-03-07	ABE-DELISTED	Stock	19.26	19.26	19.02	19.0999	15042.0
2012-03-07	ABEO	Stock	1437.5	1450.0	1425.0	1450.0	29.0
2012-03-07	ABFS-DELISTED	Stock	17.57	17.66	17.18	17.31	409256.0
2012-03-07	ABG	Stock	26.31	26.51	25.73	26.51	329800.0
2012-03-07	ABH-DELISTED	Stock	14.69	14.79	14.62	14.66	117336.0
2012-03-07	ABM	Stock	22.84	22.96	22.15	22.43	2108500.0
2012-03-07	ABMD-DELISTED	Stock	19.69	20.89	19.69	20.76	457999.0
2012-03-07	ABR	Stock	4.93	5.24	4.92	5.24	76000.0
2012-03-07	ABT	Stock	27.0847	27.0847	26.8256	26.9935	15557107.0
2012-03-07	ABTL-DELISTED	Stock	4.8259	5.0714	4.6703	4.8	20187.0
2012-03-07	ABUS	Stock	2.33	2.58	2.3	2.31	25000.0
2012-03-07	ABV-DELISTED	Stock	39.24	40.11	39.2	39.99	1900607.0
2012-03-07	ABVA-DELISTED	Stock	3.99	4.011	3.99	4.01	8500.0
2012-03-07	ABVT-DELISTED	Stock	68.9	69.45	68.835	69.07	93637.0
2012-03-07	ABX-DELISTED	Stock	45.93	45.95	45.2	45.76	5526638.0

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

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