PREVIEW / stock_daily / 2011-02-18

all stock daily files

  file:    by_date/stock_daily/2011/2011-02-18.parquet
  size:    198 KB
  rows:    6,100
  symbols: 3,559

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
2011-02-18	AAPL	Stock	12.8111	12.8393	12.4829	12.52	816057200.0
2011-02-18	MSFT	Stock	27.13	27.21	26.99	27.06	68667800.0
2011-02-18	NVDA	Stock	0.6385	0.6488	0.6308	0.6408	1394412000.0
2011-02-18	AMZN	Stock	9.377	9.425	9.2565	9.325	83572000.0
2011-02-18	TSLA	Stock	1.5553	1.566	1.5307	1.5453	35560500.0
2011-02-18	TLT	Stock	89.42	89.55	89.08	89.49	6082607.0
2011-02-18	ES	Stock	33.45	33.59	33.29	33.44	1260400.0
2011-02-18	CL	Stock	39.295	39.4	39.145	39.21	5642400.0
2011-02-18	A	Stock	31.3662	31.681	31.2232	31.4163	6137639.0
2011-02-18	AABA-DELISTED	Stock	17.69	17.8432	17.57	17.67	13496984.0
2011-02-18	AACC-DELISTED	Stock	5.7	5.83	5.67	5.76	31407.0
2011-02-18	AACG	Stock	4.49	4.54	4.47	4.54	15900.0
2011-02-18	AAI-DELISTED	Stock	7.43	7.43	7.4	7.41	892069.0
2011-02-18	AAIC-DELISTED	Stock	28.56	28.89	28.15	28.28	58715.0
2011-02-18	AAME	Stock	2.08	2.12	2.05	2.1	3800.0
2011-02-18	AAON	Stock	6.0622	6.1827	5.9101	6.1096	201994.0
2011-02-18	AAP	Stock	62.78	63.07	62.32	62.39	865400.0
2011-02-18	AAT	Stock	21.54	21.59	21.31	21.51	223300.0
2011-02-18	AATI-DELISTED	Stock	4.3	4.39	4.27	4.38	215273.0
2011-02-18	AAU-DELISTED	Stock	4.57	4.67	4.21	4.36	581250.0
2011-02-18	AAUAF-DELISTED	Stock	4.57	4.67	4.21	4.35	581924.0
2011-02-18	AAV-DELISTED	Stock	7.84	7.88	7.65	7.78	332908.0
2011-02-18	AAWW-DELISTED	Stock	71.0	73.19	70.8	72.26	578241.0
2011-02-18	AAXJ	Stock	61.75	61.76	61.43	61.59	252611.0
2011-02-18	AAXN-DELISTED	Stock	4.29	4.3	4.17	4.29	365131.0
2011-02-18	AB	Stock	22.9	23.55	22.76	23.16	1120100.0
2011-02-18	ABAC-DELISTED	Stock	4.0401	4.12	4.0401	4.12	69733.0
2011-02-18	ABAX-DELISTED	Stock	26.99	26.99	26.48	26.54	239483.0
2011-02-18	ABB-DELISTED	Stock	24.17	24.19	23.93	24.13	2120060.0
2011-02-18	ABBC-DELISTED	Stock	13.1	13.18	12.98	13.16	192613.0
2011-02-18	ABBNY-DELISTED	Stock	24.16	24.19	23.93	24.15	2135895.0
2011-02-18	ABC-DELISTED	Stock	37.35	37.8	37.26	37.77	2326189.0
2011-02-18	ABCB	Stock	9.93	10.0	9.87	9.98	48300.0
2011-02-18	ABCD-DELISTED	Stock	3.94	3.94	3.83	3.84	417512.0
2011-02-18	ABCO-DELISTED	Stock	26.17	26.34	25.93	26.11	175070.0
2011-02-18	ABCW-DELISTED	Stock	1.1	1.22	1.1	1.2	211140.0
2011-02-18	ABD-DELISTED	Stock	9.17	9.23	8.92	9.08	197000.0
2011-02-18	ABE-DELISTED	Stock	18.16	18.45	18.16	18.45	19228.0
2011-02-18	ABEO	Stock	2875.0	2937.5	2775.0	2937.5	49.0
2011-02-18	ABFS-DELISTED	Stock	25.45	25.64	25.18	25.42	140868.0
2011-02-18	ABG	Stock	18.47	18.92	18.25	18.3	557400.0
2011-02-18	ABH-DELISTED	Stock	29.55	29.58	29.0	29.52	629381.0
2011-02-18	ABM	Stock	26.84	27.06	26.64	27.0	136800.0
2011-02-18	ABMD-DELISTED	Stock	13.31	13.324	13.136	13.25	112086.0
2011-02-18	ABR	Stock	6.6	6.62	6.43	6.52	40600.0
2011-02-18	ABT	Stock	22.2435	22.4978	22.2051	22.493	20295540.0
2011-02-18	ABTL-DELISTED	Stock	5.7591	6.0095	5.6089	5.8909	183409.0
2011-02-18	ABUS	Stock	5.19	5.25	5.14	5.25	27100.0
2011-02-18	ABV-DELISTED	Stock	27.44	28.07	27.43	28.01	2157421.0
2011-02-18	ABVA-DELISTED	Stock	4.85	5.0	4.71	4.72	1800.0

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

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