PREVIEW / stock_daily / 2010-07-16

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-16.parquet
  size:    188 KB
  rows:    5,896
  symbols: 3,458

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
2010-07-16	AAPL	Stock	9.0421	9.1061	8.8718	8.925	1039858400.0
2010-07-16	MSFT	Stock	25.51	25.64	24.88	24.89	65064800.0
2010-07-16	NVDA	Stock	0.268	0.2688	0.2503	0.2513	1288604000.0
2010-07-16	AMZN	Stock	6.064	6.096	5.9005	5.9245	124558000.0
2010-07-16	TSLA	Stock	1.38	1.42	1.3367	1.376	39319500.0
2010-07-16	TLT	Stock	100.31	101.13	100.27	100.8	7512361.0
2010-07-16	ES	Stock	27.5	27.59	26.91	26.97	1236300.0
2010-07-16	CL	Stock	41.44	41.615	41.1	41.415	4734600.0
2010-07-16	A	Stock	20.1717	20.2361	19.2918	19.3348	8874364.0
2010-07-16	AABA-DELISTED	Stock	15.37	15.37	13.86	14.87	16547704.0
2010-07-16	AACC-DELISTED	Stock	4.02	4.02	3.8	3.82	44825.0
2010-07-16	AAI-DELISTED	Stock	4.89	4.93	4.76	4.76	1713223.0
2010-07-16	AAIC-DELISTED	Stock	18.06	18.22	17.72	17.79	62988.0
2010-07-16	AAME	Stock	1.32	1.35	1.28	1.28	34000.0
2010-07-16	AAON	Stock	4.6104	4.6558	4.4958	4.5077	225787.0
2010-07-16	AAP	Stock	52.96	52.99	51.23	51.34	1202000.0
2010-07-16	AATI-DELISTED	Stock	3.4	3.44	3.375	3.39	203556.0
2010-07-16	AAU-DELISTED	Stock	0.87	0.895	0.87	0.88	58253.0
2010-07-16	AAUAF-DELISTED	Stock	0.87	0.895	0.87	0.88	60153.0
2010-07-16	AAV-DELISTED	Stock	6.3	6.37	6.08	6.08	289433.0
2010-07-16	AAWW-DELISTED	Stock	56.3	56.44	53.5	53.66	278322.0
2010-07-16	AAXJ	Stock	54.08	54.12	53.2	53.28	129598.0
2010-07-16	AAXN-DELISTED	Stock	3.75	3.78	3.62	3.73	604631.0
2010-07-16	AB	Stock	27.92	28.12	27.37	27.74	162000.0
2010-07-16	ABAX-DELISTED	Stock	18.83	18.99	18.15	18.16	144411.0
2010-07-16	ABB-DELISTED	Stock	18.65	18.65	18.11	18.17	2038342.0
2010-07-16	ABBC-DELISTED	Stock	8.93	9.03	8.77	8.81	100002.0
2010-07-16	ABBNY-DELISTED	Stock	18.65	18.65	18.11	18.1425	2070146.0
2010-07-16	ABC-DELISTED	Stock	32.57	32.74	32.1	32.14	2665157.0
2010-07-16	ABCB	Stock	10.06	10.21	9.74	9.75	97700.0
2010-07-16	ABCD-DELISTED	Stock	3.46	3.47	3.33	3.35	59522.0
2010-07-16	ABCO-DELISTED	Stock	20.77	20.79	20.27	20.31	110024.0
2010-07-16	ABCW-DELISTED	Stock	0.4798	0.519	0.4614	0.47	51960.0
2010-07-16	ABD-DELISTED	Stock	5.18	5.22	4.84	4.93	531580.0
2010-07-16	ABE-DELISTED	Stock	16.74	16.74	16.4	16.46	145698.0
2010-07-16	ABEO	Stock	2562.5	2687.5	2500.0	2687.5	16.0
2010-07-16	ABFS-DELISTED	Stock	21.55	22.08	20.8	20.88	419399.0
2010-07-16	ABG	Stock	10.95	11.05	10.38	10.41	305400.0
2010-07-16	ABII-DELISTED	Stock	74.85	75.0	74.41	74.72	39507.0
2010-07-16	ABK-DELISTED	Stock	0.71	0.71	0.67	0.6799	5129774.0
2010-07-16	ABM	Stock	20.96	21.04	20.34	20.42	303900.0
2010-07-16	ABMD-DELISTED	Stock	11.19	11.39	11.1	11.12	413898.0
2010-07-16	ABR	Stock	5.78	6.01	5.5	5.66	156100.0
2010-07-16	ABT	Stock	22.9872	23.0976	22.5602	22.5842	19046269.0
2010-07-16	ABTL-DELISTED	Stock	6.0017	6.2035	5.8	5.8	15548.0
2010-07-16	ABV-DELISTED	Stock	105.71	107.0	105.71	106.56	888436.0
2010-07-16	ABVA-DELISTED	Stock	2.515	2.515	2.515	2.515	822.0
2010-07-16	ABVT-DELISTED	Stock	48.26	48.32	47.57	48.0	206882.0
2010-07-16	ABX-DELISTED	Stock	42.22	42.27	41.59	41.76	9188344.0
2010-07-16	ACAD	Stock	1.05	1.06	1.04	1.05	41400.0

> showing 50 of 5,896 rows — these rows as CSV

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