PREVIEW / stock_daily / 2010-08-12

all stock daily files

  file:    by_date/stock_daily/2010/2010-08-12.parquet
  size:    188 KB
  rows:    5,935
  symbols: 3,487

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-12	AAPL	Stock	8.8104	9.0393	8.79	8.9925	534920400.0
2010-08-12	MSFT	Stock	24.42	24.68	24.36	24.49	70240500.0
2010-08-12	NVDA	Stock	0.218	0.229	0.2163	0.224	1343584000.0
2010-08-12	AMZN	Stock	6.188	6.35	6.1775	6.328	87358000.0
2010-08-12	TSLA	Stock	1.1867	1.1933	1.1593	1.1733	10365000.0
2010-08-12	TLT	Stock	101.58	101.94	100.87	101.03	7590006.0
2010-08-12	ES	Stock	28.57	28.7	28.31	28.63	1159500.0
2010-08-12	CL	Stock	38.035	38.65	37.95	38.51	5652800.0
2010-08-12	A	Stock	19.7783	19.8712	19.6066	19.6924	4552867.0
2010-08-12	AABA-DELISTED	Stock	13.77	13.99	13.75	13.87	11496516.0
2010-08-12	AACC-DELISTED	Stock	3.93	4.28	3.9001	4.06	129110.0
2010-08-12	AACG	Stock	2.94	2.96	2.9	2.96	1000.0
2010-08-12	AAI-DELISTED	Stock	4.54	4.64	4.5	4.59	1226879.0
2010-08-12	AAIC-DELISTED	Stock	19.64	20.26	19.26	20.25	58363.0
2010-08-12	AAME	Stock	1.22	1.3	1.22	1.3	1800.0
2010-08-12	AAON	Stock	4.4484	4.5096	4.4444	4.4741	130106.0
2010-08-12	AAP	Stock	52.75	55.78	52.72	54.62	3096700.0
2010-08-12	AATI-DELISTED	Stock	3.06	3.13	2.99	3.08	115091.0
2010-08-12	AAU-DELISTED	Stock	1.43	1.87	1.43	1.85	2041987.0
2010-08-12	AAUAF-DELISTED	Stock	1.43	1.86	1.43	1.85	2052622.0
2010-08-12	AAV-DELISTED	Stock	5.82	5.96	5.8	5.85	338070.0
2010-08-12	AAWW-DELISTED	Stock	46.4	46.9	44.82	46.26	509971.0
2010-08-12	AAXJ	Stock	54.35	54.98	54.3401	54.79	356295.0
2010-08-12	AAXN-DELISTED	Stock	3.89	4.03	3.85	4.0	533598.0
2010-08-12	AB	Stock	25.76	26.03	25.59	25.93	255200.0
2010-08-12	ABAC-DELISTED	Stock	3.8	3.8499	3.6501	3.7	27900.0
2010-08-12	ABAX-DELISTED	Stock	19.27	19.76	18.97	19.63	79183.0
2010-08-12	ABB-DELISTED	Stock	18.77	19.09	18.75	18.99	2041969.0
2010-08-12	ABBC-DELISTED	Stock	9.3	9.41	9.3	9.4	75014.0
2010-08-12	ABBNY-DELISTED	Stock	18.77	19.09	18.75	19.02	2053681.0
2010-08-12	ABC-DELISTED	Stock	28.75	29.23	28.59	29.14	2301186.0
2010-08-12	ABCB	Stock	8.59	8.9	8.52	8.82	58700.0
2010-08-12	ABCD-DELISTED	Stock	3.1	3.36	3.1	3.27	50934.0
2010-08-12	ABCO-DELISTED	Stock	21.63	22.02	21.33	21.35	300101.0
2010-08-12	ABCW-DELISTED	Stock	0.6484	0.6484	0.6195	0.6216	86840.0
2010-08-12	ABD-DELISTED	Stock	5.9	6.04	5.82	5.98	336580.0
2010-08-12	ABE-DELISTED	Stock	16.95	17.0299	16.94	17.01	11243.0
2010-08-12	ABEO	Stock	2375.0	2500.0	2375.0	2475.0	11.0
2010-08-12	ABFS-DELISTED	Stock	19.75	20.49	19.51	20.44	377468.0
2010-08-12	ABG	Stock	12.81	13.25	12.76	13.16	146100.0
2010-08-12	ABII-DELISTED	Stock	74.07	75.85	74.0	75.64	104150.0
2010-08-12	ABK-DELISTED	Stock	0.65	0.6921	0.65	0.6827	6443050.0
2010-08-12	ABM	Stock	19.75	20.35	19.75	20.31	207000.0
2010-08-12	ABMD-DELISTED	Stock	9.82	9.92	9.7	9.84	135909.0
2010-08-12	ABR	Stock	4.96	5.3	4.85	5.06	117600.0
2010-08-12	ABT	Stock	23.9468	24.2491	23.8605	24.1771	9210088.0
2010-08-12	ABTL-DELISTED	Stock	4.6478	5.2979	4.6478	4.7	17458.0
2010-08-12	ABV-DELISTED	Stock	102.51	104.95	102.48	104.53	316073.0
2010-08-12	ABVA-DELISTED	Stock	2.96	2.96	2.96	2.96	461.0
2010-08-12	ABVT-DELISTED	Stock	50.8	51.0	50.19	50.42	149389.0

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

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