PREVIEW / stock_daily / 2010-04-21

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-21.parquet
  size:    192 KB
  rows:    5,942
  symbols: 3,499

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-21	AAPL	Stock	9.2429	9.2946	9.1332	9.2579	982391200.0
2010-04-21	MSFT	Stock	31.33	31.5	31.23	31.33	55343100.0
2010-04-21	NVDA	Stock	0.4282	0.4288	0.41	0.415	895908000.0
2010-04-21	AMZN	Stock	7.2585	7.45	7.176	7.3215	147488000.0
2010-04-21	TLT	Stock	90.27	90.83	90.26	90.7	4162429.0
2010-04-21	ES	Stock	27.58	27.66	27.44	27.65	846300.0
2010-04-21	CL	Stock	42.31	42.46	42.105	42.35	4145000.0
2010-04-21	A	Stock	25.8798	26.03	25.6009	25.8441	3142424.0
2010-04-21	AABA-DELISTED	Stock	17.58	17.78	17.3	17.45	70812410.0
2010-04-21	AACC-DELISTED	Stock	6.89	6.95	6.76	6.95	6708.0
2010-04-21	AACG	Stock	3.53	3.53	3.5	3.5	1800.0
2010-04-21	AAI-DELISTED	Stock	5.72	5.84	5.27	5.32	11343399.0
2010-04-21	AAIC-DELISTED	Stock	20.1501	20.3	20.1501	20.27	14333.0
2010-04-21	AAON	Stock	4.6044	4.6044	4.4602	4.5096	783675.0
2010-04-21	AAP	Stock	44.52	45.16	43.8	44.97	1020400.0
2010-04-21	AATI-DELISTED	Stock	4.04	4.07	3.92	3.96	138633.0
2010-04-21	AAU-DELISTED	Stock	1.12	1.12	1.05	1.0999	40652.0
2010-04-21	AAUAF-DELISTED	Stock	1.12	1.12	1.05	1.0999	41252.0
2010-04-21	AAV-DELISTED	Stock	7.25	7.39	7.17	7.24	463709.0
2010-04-21	AAWW-DELISTED	Stock	55.18	57.71	54.635	57.7	262169.0
2010-04-21	AAXJ	Stock	58.05	58.05	57.4005	57.82	94678.0
2010-04-21	AAXN-DELISTED	Stock	5.39	5.43	5.31	5.37	621329.0
2010-04-21	AB	Stock	33.56	34.0	33.09	33.52	354700.0
2010-04-21	ABAX-DELISTED	Stock	26.52	26.52	26.02	26.19	61951.0
2010-04-21	ABB-DELISTED	Stock	22.12	22.3	22.07	22.29	1864355.0
2010-04-21	ABBC-DELISTED	Stock	8.3215	8.47	8.26	8.43	34368.0
2010-04-21	ABBNY-DELISTED	Stock	22.12	22.3	22.07	22.28	1870771.0
2010-04-21	ABC-DELISTED	Stock	30.43	30.59	29.98	30.34	5894184.0
2010-04-21	ABCB	Stock	10.709	10.8981	10.5995	10.6791	153327.0
2010-04-21	ABCD-DELISTED	Stock	5.0501	5.16	4.9703	5.1	26827.0
2010-04-21	ABCO-DELISTED	Stock	17.0	17.475	17.0	17.36	83813.0
2010-04-21	ABCW-DELISTED	Stock	1.0391	1.0391	0.9809	1.01	95970.0
2010-04-21	ABD-DELISTED	Stock	7.995	8.135	7.905	8.105	270190.0
2010-04-21	ABE-DELISTED	Stock	17.1	17.1	16.8501	16.8501	3595.0
2010-04-21	ABEO	Stock	3312.5	3375.0	3262.5	3262.5	13.0
2010-04-21	ABFS-DELISTED	Stock	30.335	31.88	30.21	31.72	1494987.0
2010-04-21	ABG	Stock	13.57	14.05	13.55	13.99	386400.0
2010-04-21	ABII-DELISTED	Stock	51.9	52.3	50.79	50.85	46424.0
2010-04-21	ABK-DELISTED	Stock	2.21	2.22	2.0	2.01	79777227.0
2010-04-21	ABM	Stock	21.56	21.71	21.45	21.63	180000.0
2010-04-21	ABMD-DELISTED	Stock	9.58	9.75	9.35	9.7	296097.0
2010-04-21	ABR	Stock	3.89	4.03	3.8	3.98	191200.0
2010-04-21	ABT	Stock	25.3334	25.4054	24.6953	24.844	26172572.0
2010-04-21	ABTL-DELISTED	Stock	4.8	5.15	4.7525	5.15	19528.0
2010-04-21	ABV-DELISTED	Stock	97.06	97.34	95.02	96.14	395700.0
2010-04-21	ABVA-DELISTED	Stock	3.01	3.01	3.01	3.01	1900.0
2010-04-21	ABVT-DELISTED	Stock	52.55	52.79	50.41	51.23	304936.0
2010-04-21	ABX-DELISTED	Stock	39.33	39.87	39.02	39.49	6660938.0
2010-04-21	ACAD	Stock	1.75	1.79	1.67	1.69	392900.0
2010-04-21	ACAP-DELISTED	Stock	32.41	32.51	32.16	32.4	29793.0

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

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