PREVIEW / stock_daily / 2011-01-03

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-03.parquet
  size:    197 KB
  rows:    6,072
  symbols: 3,550

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-01-03	AAPL	Stock	11.63	11.795	11.6014	11.7704	445138400.0
2011-01-03	MSFT	Stock	28.05	28.18	27.92	27.98	53443800.0
2011-01-03	NVDA	Stock	0.388	0.3993	0.3875	0.3955	817448000.0
2011-01-03	AMZN	Stock	9.0685	9.3	9.0605	9.211	106628000.0
2011-01-03	TSLA	Stock	1.7893	1.8	1.7267	1.7747	19245000.0
2011-01-03	TLT	Stock	93.2	94.31	92.95	93.41	13799678.0
2011-01-03	ES	Stock	32.05	32.21	31.9	31.95	1362400.0
2011-01-03	CL	Stock	40.17	40.31	39.575	39.895	6693400.0
2011-01-03	A	Stock	29.7282	30.1431	29.6209	29.9571	4994075.0
2011-01-03	AABA-DELISTED	Stock	16.81	16.94	16.67	16.75	15517096.0
2011-01-03	AACC-DELISTED	Stock	5.99	6.25	5.99	6.14	20347.0
2011-01-03	AACG	Stock	3.67	3.76	3.67	3.7	2400.0
2011-01-03	AAI-DELISTED	Stock	7.4	7.5	7.39	7.46	5886852.0
2011-01-03	AAIC-DELISTED	Stock	24.22	24.74	24.22	24.6	37908.0
2011-01-03	AAME	Stock	2.06	2.06	2.06	2.06	1400.0
2011-01-03	AAON	Stock	5.6415	5.7442	5.6336	5.7304	521944.0
2011-01-03	AAP	Stock	66.5	66.74	65.47	65.5	826400.0
2011-01-03	AATI-DELISTED	Stock	4.02	4.06	3.96	4.04	107381.0
2011-01-03	AAU-DELISTED	Stock	4.85	5.24	4.66	5.08	1184395.0
2011-01-03	AAUAF-DELISTED	Stock	4.85	5.24	4.66	5.08	1184795.0
2011-01-03	AAV-DELISTED	Stock	6.84	6.85	6.71	6.82	289876.0
2011-01-03	AAWW-DELISTED	Stock	56.42	57.09	55.79	55.82	249695.0
2011-01-03	AAXJ	Stock	64.6	64.82	64.5	64.58	181660.0
2011-01-03	AAXN-DELISTED	Stock	4.75	5.02	4.75	5.0	807805.0
2011-01-03	AB	Stock	23.5	24.18	23.47	23.87	589100.0
2011-01-03	ABAC-DELISTED	Stock	6.3355	6.3499	6.05	6.05	57698.0
2011-01-03	ABAX-DELISTED	Stock	27.02	27.46	26.9	27.12	86444.0
2011-01-03	ABB-DELISTED	Stock	22.62	22.75	22.62	22.7	2393627.0
2011-01-03	ABBC-DELISTED	Stock	11.96	12.05	11.651	11.89	48297.0
2011-01-03	ABBNY-DELISTED	Stock	22.62	22.75	22.62	22.72	2394570.0
2011-01-03	ABC-DELISTED	Stock	34.26	34.88	34.25	34.3	2604357.0
2011-01-03	ABCB	Stock	10.65	11.06	10.65	10.85	128800.0
2011-01-03	ABCD-DELISTED	Stock	3.47	3.47	3.38	3.43	15324.0
2011-01-03	ABCO-DELISTED	Stock	24.07	24.22	23.89	23.94	110310.0
2011-01-03	ABCW-DELISTED	Stock	1.1806	1.2397	1.1806	1.22	95660.0
2011-01-03	ABD-DELISTED	Stock	8.62	8.901	8.59	8.83	272360.0
2011-01-03	ABE-DELISTED	Stock	19.31	19.659	19.16	19.41	11018.0
2011-01-03	ABEO	Stock	3100.0	3187.5	3012.5	3087.5	10.0
2011-01-03	ABFS-DELISTED	Stock	27.91	28.53	27.57	27.93	229574.0
2011-01-03	ABG	Stock	18.79	18.9	18.52	18.76	298100.0
2011-01-03	ABH-DELISTED	Stock	23.67	24.0	23.37	23.49	475735.0
2011-01-03	ABM	Stock	26.53	27.0	26.53	26.81	277500.0
2011-01-03	ABMD-DELISTED	Stock	9.72	9.87	9.59	9.78	189620.0
2011-01-03	ABR	Stock	6.03	6.03	5.75	5.82	79500.0
2011-01-03	ABT	Stock	23.1695	23.1695	22.92	22.944	19050229.0
2011-01-03	ABTL-DELISTED	Stock	4.3	4.4	4.1	4.4	17378.0
2011-01-03	ABUS	Stock	4.58	4.63	4.5	4.63	500.0
2011-01-03	ABV-DELISTED	Stock	31.51	31.89	31.5	31.74	2373996.0
2011-01-03	ABVA-DELISTED	Stock	4.0	4.2	4.0	4.2	1312.0
2011-01-03	ABVT-DELISTED	Stock	58.83	60.3	58.83	60.09	127602.0

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

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