PREVIEW / stock_daily / 2010-08-20

all stock daily files

  file:    by_date/stock_daily/2010/2010-08-20.parquet
  size:    189 KB
  rows:    5,944
  symbols: 3,482

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-08-20	AAPL	Stock	8.9068	9.0686	8.8929	8.9157	384230000.0
2010-08-20	MSFT	Stock	24.31	24.4	24.2	24.23	49560100.0
2010-08-20	NVDA	Stock	0.2453	0.2553	0.245	0.2493	1305308000.0
2010-08-20	AMZN	Stock	6.36	6.402	6.301	6.388	83402000.0
2010-08-20	TSLA	Stock	1.2433	1.274	1.234	1.2733	4440000.0
2010-08-20	TLT	Stock	106.41	106.83	105.84	106.04	7040203.0
2010-08-20	ES	Stock	28.41	28.6	28.33	28.54	1045200.0
2010-08-20	CL	Stock	38.21	38.37	37.945	38.015	5389200.0
2010-08-20	A	Stock	20.2146	20.5007	20.0215	20.4292	4716712.0
2010-08-20	AABA-DELISTED	Stock	13.85	13.95	13.74	13.77	17163150.0
2010-08-20	AACC-DELISTED	Stock	4.0	4.19	3.72	4.14	66966.0
2010-08-20	AACG	Stock	2.87	2.97	2.86	2.92	4600.0
2010-08-20	AAI-DELISTED	Stock	4.65	4.7	4.6	4.67	1091445.0
2010-08-20	AAIC-DELISTED	Stock	19.88	19.98	19.54	19.91	50443.0
2010-08-20	AAME	Stock	1.25	1.25	1.2	1.2	8100.0
2010-08-20	AAON	Stock	4.2331	4.3042	4.16	4.2884	231862.0
2010-08-20	AAP	Stock	55.28	55.92	54.76	55.89	784900.0
2010-08-20	AATI-DELISTED	Stock	3.26	3.45	3.25	3.43	199451.0
2010-08-20	AAU-DELISTED	Stock	1.86	2.0	1.7701	1.99	471353.0
2010-08-20	AAUAF-DELISTED	Stock	1.86	2.0	1.7701	1.99	472653.0
2010-08-20	AAV-DELISTED	Stock	5.85	5.8925	5.8	5.86	247794.0
2010-08-20	AAWW-DELISTED	Stock	45.38	45.99	44.25	44.79	341035.0
2010-08-20	AAXJ	Stock	55.67	55.67	55.23	55.59	122730.0
2010-08-20	AAXN-DELISTED	Stock	3.82	3.9	3.8	3.86	241400.0
2010-08-20	AB	Stock	25.18	25.35	24.69	25.0	394600.0
2010-08-20	ABAC-DELISTED	Stock	4.01	4.05	3.89	3.92	14100.0
2010-08-20	ABAX-DELISTED	Stock	19.3	19.3	18.75	18.9	112075.0
2010-08-20	ABB-DELISTED	Stock	19.12	19.17	18.98	19.15	1198598.0
2010-08-20	ABBC-DELISTED	Stock	9.54	9.86	9.54	9.84	79663.0
2010-08-20	ABBNY-DELISTED	Stock	19.13	19.17	18.98	19.17	1203946.0
2010-08-20	ABC-DELISTED	Stock	28.87	29.06	28.72	28.9	2513897.0
2010-08-20	ABCB	Stock	8.08	8.35	7.95	8.15	78800.0
2010-08-20	ABCD-DELISTED	Stock	2.94	3.15	2.94	3.04	62970.0
2010-08-20	ABCO-DELISTED	Stock	21.15	21.38	20.94	21.19	206934.0
2010-08-20	ABCW-DELISTED	Stock	0.61	0.64	0.61	0.62	44810.0
2010-08-20	ABD-DELISTED	Stock	6.02	6.04	5.86	5.88	527200.0
2010-08-20	ABE-DELISTED	Stock	17.27	17.27	17.19	17.26	5631.0
2010-08-20	ABEO	Stock	2500.0	2625.0	2450.0	2625.0	15.0
2010-08-20	ABFS-DELISTED	Stock	19.48	19.97	19.2	19.89	216645.0
2010-08-20	ABG	Stock	12.62	12.81	12.3	12.76	239400.0
2010-08-20	ABII-DELISTED	Stock	74.77	74.77	74.38	74.55	30337.0
2010-08-20	ABK-DELISTED	Stock	0.4451	0.526	0.4	0.51	29375476.0
2010-08-20	ABM	Stock	19.37	19.5	19.02	19.41	257600.0
2010-08-20	ABMD-DELISTED	Stock	9.2	9.37	8.98	9.12	204118.0
2010-08-20	ABR	Stock	4.83	5.05	4.78	4.94	46900.0
2010-08-20	ABT	Stock	23.5294	23.7165	23.4766	23.6733	13354314.0
2010-08-20	ABTL-DELISTED	Stock	4.405	4.405	4.1952	4.345	4965.0
2010-08-20	ABV-DELISTED	Stock	110.43	110.43	108.57	109.93	599386.0
2010-08-20	ABVT-DELISTED	Stock	50.95	51.15	49.77	51.02	136327.0
2010-08-20	ABX-DELISTED	Stock	44.31	44.83	44.04	44.74	4736126.0

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

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