PREVIEW / stock_daily / 2010-04-12

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-12.parquet
  size:    192 KB
  rows:    5,980
  symbols: 3,531

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-12	AAPL	Stock	8.65	8.6811	8.6361	8.6532	333026400.0
2010-04-12	MSFT	Stock	30.25	30.49	30.21	30.32	37068800.0
2010-04-12	NVDA	Stock	0.4253	0.4342	0.4245	0.4325	546460000.0
2010-04-12	AMZN	Stock	7.0	7.1455	6.984	7.06	108906000.0
2010-04-12	TLT	Stock	89.17	89.56	89.09	89.45	2939571.0
2010-04-12	ES	Stock	27.85	27.99	27.66	27.8	1485700.0
2010-04-12	CL	Stock	42.245	42.42	42.085	42.395	3557000.0
2010-04-12	A	Stock	24.4707	24.5565	24.3491	24.4707	4134585.0
2010-04-12	AABA-DELISTED	Stock	17.52	17.88	17.41	17.64	21997709.0
2010-04-12	AACC-DELISTED	Stock	6.52	6.53	6.5	6.51	13671.0
2010-04-12	AACG	Stock	3.9	3.9	3.55	3.62	39400.0
2010-04-12	AAI-DELISTED	Stock	5.31	5.5	5.31	5.49	3441280.0
2010-04-12	AAIC-DELISTED	Stock	19.06	19.309	19.06	19.27	15161.0
2010-04-12	AAME	Stock	1.44	1.44	1.44	1.44	700.0
2010-04-12	AAON	Stock	4.48	4.5926	4.4602	4.5827	405000.0
2010-04-12	AAP	Stock	42.31	42.52	42.09	42.41	799000.0
2010-04-12	AATI-DELISTED	Stock	3.81	3.82	3.78	3.79	249693.0
2010-04-12	AAU-DELISTED	Stock	1.18	1.241	1.18	1.18	304256.0
2010-04-12	AAUAF-DELISTED	Stock	1.16	1.22	1.16	1.18	310402.0
2010-04-12	AAV-DELISTED	Stock	6.95	7.09	6.9	6.91	346802.0
2010-04-12	AAWW-DELISTED	Stock	54.54	56.0	54.54	55.94	305350.0
2010-04-12	AAXJ	Stock	58.52	58.61	58.3701	58.39	125231.0
2010-04-12	AAXN-DELISTED	Stock	5.49	5.57	5.4	5.47	1006666.0
2010-04-12	AB	Stock	32.35	32.35	31.86	31.99	274200.0
2010-04-12	ABAX-DELISTED	Stock	26.12	26.87	26.12	26.78	155974.0
2010-04-12	ABB-DELISTED	Stock	22.36	22.57	22.35	22.44	1657554.0
2010-04-12	ABBC-DELISTED	Stock	8.21	8.26	8.03	8.05	21082.0
2010-04-12	ABBNY-DELISTED	Stock	22.36	22.57	22.35	22.44	2025724.0
2010-04-12	ABC-DELISTED	Stock	29.49	29.51	29.27	29.35	1781792.0
2010-04-12	ABCB	Stock	9.7038	9.7038	9.3654	9.455	51042.0
2010-04-12	ABCD-DELISTED	Stock	5.09	5.09	5.04	5.06	20692.0
2010-04-12	ABCO-DELISTED	Stock	16.435	16.605	16.275	16.33	46370.0
2010-04-12	ABCW-DELISTED	Stock	0.89	0.95	0.87	0.91	137860.0
2010-04-12	ABD-DELISTED	Stock	7.7	7.7	7.45	7.61	204910.0
2010-04-12	ABE-DELISTED	Stock	17.47	17.47	17.25	17.3199	16198.0
2010-04-12	ABEO	Stock	3050.0	3312.5	3000.0	3250.0	39.0
2010-04-12	ABFS-DELISTED	Stock	29.77	30.16	29.3825	29.99	531800.0
2010-04-12	ABG	Stock	13.56	13.65	13.4	13.51	183800.0
2010-04-12	ABII-DELISTED	Stock	52.25	53.44	51.97	52.5	290958.0
2010-04-12	ABK-DELISTED	Stock	1.29	2.3	1.28	2.26	416902990.0
2010-04-12	ABM	Stock	20.88	21.03	20.6	20.91	350400.0
2010-04-12	ABMD-DELISTED	Stock	9.35	9.46	9.24	9.44	170759.0
2010-04-12	ABR	Stock	4.5	4.66	4.3	4.39	255800.0
2010-04-12	ABT	Stock	25.4294	25.4294	25.1367	25.2711	13458108.0
2010-04-12	ABTL-DELISTED	Stock	4.9005	4.95	4.75	4.7995	13809.0
2010-04-12	ABV-DELISTED	Stock	94.83	96.21	94.34	95.87	619944.0
2010-04-12	ABVA-DELISTED	Stock	2.7	2.7001	2.54	2.6	3000.0
2010-04-12	ABVT-DELISTED	Stock	49.24	49.855	48.89	49.66	181018.0
2010-04-12	ABX-DELISTED	Stock	40.97	41.72	40.59	40.8	10681982.0
2010-04-12	ACAD	Stock	1.55	1.59	1.48	1.53	434100.0

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

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