PREVIEW / stock_daily / 2011-02-03

all stock daily files

  file:    by_date/stock_daily/2011/2011-02-03.parquet
  size:    196 KB
  rows:    6,060
  symbols: 3,539

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-03	AAPL	Stock	12.2786	12.2943	12.0911	12.2657	393797600.0
2011-02-03	MSFT	Stock	27.97	27.97	27.54	27.65	60340100.0
2011-02-03	NVDA	Stock	0.6405	0.6405	0.6138	0.6275	1030776000.0
2011-02-03	AMZN	Stock	8.675	8.7335	8.5975	8.6855	73578000.0
2011-02-03	TSLA	Stock	1.588	1.5933	1.5433	1.5753	7680000.0
2011-02-03	TLT	Stock	89.96	90.57	89.71	89.72	12793464.0
2011-02-03	ES	Stock	33.7	33.86	33.46	33.75	2211600.0
2011-02-03	CL	Stock	38.025	38.195	37.89	37.965	7590800.0
2011-02-03	A	Stock	29.2775	29.4564	28.7768	29.3205	4924874.0
2011-02-03	AABA-DELISTED	Stock	16.47	16.91	16.4	16.7	32049287.0
2011-02-03	AACC-DELISTED	Stock	6.12	6.22	6.12	6.135	2657.0
2011-02-03	AACG	Stock	4.16	4.25	4.16	4.18	10000.0
2011-02-03	AAI-DELISTED	Stock	7.36	7.39	7.35	7.38	2015660.0
2011-02-03	AAIC-DELISTED	Stock	25.29	25.499	25.29	25.48	19902.0
2011-02-03	AAME	Stock	2.22	2.22	2.22	2.22	200.0
2011-02-03	AAON	Stock	5.2662	5.3926	5.2365	5.3096	58725.0
2011-02-03	AAP	Stock	61.61	62.83	61.4	62.48	694500.0
2011-02-03	AAT	Stock	21.02	21.28	21.02	21.18	549400.0
2011-02-03	AATI-DELISTED	Stock	4.17	4.19	4.08	4.14	97559.0
2011-02-03	AAU-DELISTED	Stock	3.68	3.98	3.68	3.91	584367.0
2011-02-03	AAUAF-DELISTED	Stock	3.68	3.98	3.68	3.89	584967.0
2011-02-03	AAV-DELISTED	Stock	7.65	7.71	7.55	7.67	253125.0
2011-02-03	AAWW-DELISTED	Stock	52.44	54.34	52.44	53.61	164914.0
2011-02-03	AAXJ	Stock	62.5	62.67	62.218	62.49	315804.0
2011-02-03	AAXN-DELISTED	Stock	4.22	4.26	4.12	4.12	534182.0
2011-02-03	AB	Stock	21.0	21.09	20.48	20.71	696300.0
2011-02-03	ABAC-DELISTED	Stock	5.05	5.11	4.84	4.86	87547.0
2011-02-03	ABAX-DELISTED	Stock	25.94	26.31	25.52	26.17	118693.0
2011-02-03	ABB-DELISTED	Stock	23.34	23.5	23.12	23.47	2899768.0
2011-02-03	ABBC-DELISTED	Stock	12.49	12.6	12.28	12.56	78260.0
2011-02-03	ABBNY-DELISTED	Stock	23.34	23.5	23.12	23.45	2920168.0
2011-02-03	ABC-DELISTED	Stock	35.72	35.86	34.57	35.39	4796401.0
2011-02-03	ABCB	Stock	9.73	10.27	9.63	10.21	49300.0
2011-02-03	ABCD-DELISTED	Stock	3.3	3.33	3.2	3.2	15481.0
2011-02-03	ABCO-DELISTED	Stock	25.06	25.23	24.88	25.02	27351.0
2011-02-03	ABCW-DELISTED	Stock	1.7497	1.8676	1.671	1.73	517450.0
2011-02-03	ABD-DELISTED	Stock	8.485	8.605	8.38	8.455	189950.0
2011-02-03	ABE-DELISTED	Stock	18.5	18.6	18.23	18.52	15769.0
2011-02-03	ABEO	Stock	3062.5	3062.5	3000.0	3025.0	12.0
2011-02-03	ABFS-DELISTED	Stock	24.78	26.12	24.59	25.06	326657.0
2011-02-03	ABG	Stock	18.45	18.93	18.45	18.68	145800.0
2011-02-03	ABH-DELISTED	Stock	26.5	27.09	26.44	26.54	317221.0
2011-02-03	ABM	Stock	26.31	26.31	25.9	26.14	129200.0
2011-02-03	ABMD-DELISTED	Stock	10.85	12.5891	10.85	12.3	1268041.0
2011-02-03	ABR	Stock	6.09	6.2	6.07	6.1	25000.0
2011-02-03	ABT	Stock	21.9556	22.138	21.8885	22.0708	17199250.0
2011-02-03	ABTL-DELISTED	Stock	4.75	4.75	4.7	4.75	8497.0
2011-02-03	ABUS	Stock	5.88	5.88	5.52	5.57	18300.0
2011-02-03	ABV-DELISTED	Stock	27.03	27.08	26.52	26.9281	2096601.0
2011-02-03	ABVA-DELISTED	Stock	4.84	5.87	4.84	5.201	7688.0

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

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