PREVIEW / stock_daily / 2010-04-26

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-26.parquet
  size:    194 KB
  rows:    6,030
  symbols: 3,553

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-04-26	AAPL	Stock	9.71	9.7307	9.5782	9.625	479068800.0
2010-04-26	MSFT	Stock	31.0	31.28	30.86	31.11	63649300.0
2010-04-26	NVDA	Stock	0.4115	0.42	0.4108	0.415	491092000.0
2010-04-26	AMZN	Stock	7.16	7.3865	7.145	7.3555	186366000.0
2010-04-26	TLT	Stock	90.51	90.65	89.94	90.21	4753864.0
2010-04-26	ES	Stock	27.74	27.9	27.56	27.65	1337100.0
2010-04-26	CL	Stock	41.77	42.2	41.66	42.1	4110600.0
2010-04-26	A	Stock	26.2303	26.4592	26.0873	26.3376	3953544.0
2010-04-26	AABA-DELISTED	Stock	17.69	17.72	17.34	17.37	17144771.0
2010-04-26	AACC-DELISTED	Stock	7.3	7.39	7.18	7.34	37689.0
2010-04-26	AACG	Stock	3.53	3.55	3.53	3.55	5600.0
2010-04-26	AAI-DELISTED	Stock	5.38	5.54	5.3	5.5	5176198.0
2010-04-26	AAIC-DELISTED	Stock	20.35	20.7	20.35	20.6	46789.0
2010-04-26	AAME	Stock	1.6	1.65	1.56	1.56	14800.0
2010-04-26	AAON	Stock	4.7072	4.7309	4.6459	4.6598	255150.0
2010-04-26	AAP	Stock	45.92	46.46	45.59	46.32	1024100.0
2010-04-26	AATI-DELISTED	Stock	3.94	4.1	3.92	4.02	230613.0
2010-04-26	AAU-DELISTED	Stock	1.12	1.13	1.1	1.11	58267.0
2010-04-26	AAUAF-DELISTED	Stock	1.12	1.13	1.1	1.11	59667.0
2010-04-26	AAV-DELISTED	Stock	7.41	7.49	7.34	7.48	503881.0
2010-04-26	AAWW-DELISTED	Stock	58.5	59.75	58.39	58.42	121296.0
2010-04-26	AAXJ	Stock	58.7	58.74	58.35	58.44	113570.0
2010-04-26	AAXN-DELISTED	Stock	4.93	4.96	4.74	4.78	2481015.0
2010-04-26	AB	Stock	33.24	33.61	32.92	32.96	228500.0
2010-04-26	ABAX-DELISTED	Stock	27.37	27.68	26.85	26.95	145464.0
2010-04-26	ABB-DELISTED	Stock	20.95	21.06	20.36	20.48	5495561.0
2010-04-26	ABBC-DELISTED	Stock	9.18	9.47	9.11	9.14	58236.0
2010-04-26	ABBNY-DELISTED	Stock	20.95	21.06	20.36	20.5	5767726.0
2010-04-26	ABC-DELISTED	Stock	31.1	31.44	30.83	31.24	4266755.0
2010-04-26	ABCB	Stock	10.9578	11.1967	10.9479	11.0275	314691.0
2010-04-26	ABCD-DELISTED	Stock	5.11	5.59	5.11	5.32	96540.0
2010-04-26	ABCO-DELISTED	Stock	16.992	17.578	16.992	17.213	77042.0
2010-04-26	ABCW-DELISTED	Stock	1.1	1.55	1.1	1.3	2048160.0
2010-04-26	ABD-DELISTED	Stock	8.88	9.35	8.85	9.16	421390.0
2010-04-26	ABE-DELISTED	Stock	16.94	17.16	16.94	17.07	9254.0
2010-04-26	ABEO	Stock	3325.0	3475.0	3325.0	3387.5	13.0
2010-04-26	ABFS-DELISTED	Stock	31.94	32.75	31.79	32.7	766593.0
2010-04-26	ABG	Stock	15.04	15.47	15.04	15.09	229500.0
2010-04-26	ABII-DELISTED	Stock	50.8	52.01	50.75	51.85	152648.0
2010-04-26	ABK-DELISTED	Stock	1.91	1.92	1.8	1.81	33594161.0
2010-04-26	ABM	Stock	21.74	22.05	21.72	21.9	136400.0
2010-04-26	ABMD-DELISTED	Stock	9.63	9.65	9.29	9.37	189770.0
2010-04-26	ABR	Stock	4.4	4.57	4.33	4.49	240200.0
2010-04-26	ABT	Stock	24.5082	24.8392	24.0188	24.1675	19657774.0
2010-04-26	ABTL-DELISTED	Stock	4.2914	4.4352	3.853	3.95	47517.0
2010-04-26	ABV-DELISTED	Stock	99.73	100.45	99.47	99.96	347636.0
2010-04-26	ABVA-DELISTED	Stock	2.83	3.135	2.825	3.1	19836.0
2010-04-26	ABVT-DELISTED	Stock	50.77	50.77	49.27	49.64	205756.0
2010-04-26	ABX-DELISTED	Stock	40.5	40.81	40.18	40.49	4919835.0
2010-04-26	ACAD	Stock	1.72	1.72	1.64	1.65	267300.0

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

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