PREVIEW / stock_daily / 2009-07-17

all stock daily files

  file:    by_date/stock_daily/2009/2009-07-17.parquet
  size:    180 KB
  rows:    5,737
  symbols: 3,424

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
2009-07-17	AAPL	Stock	5.3243	5.4293	5.3082	5.4196	602154000.0
2009-07-17	MSFT	Stock	24.4	24.45	24.1	24.29	52860100.0
2009-07-17	NVDA	Stock	0.2932	0.3028	0.2902	0.3018	850356000.0
2009-07-17	AMZN	Stock	4.29	4.325	4.26	4.2925	101032000.0
2009-07-17	TLT	Stock	91.9	92.36	91.24	91.24	3845658.0
2009-07-17	ES	Stock	22.05	22.29	21.78	22.09	1887600.0
2009-07-17	CL	Stock	36.8	36.995	36.625	36.76	4821400.0
2009-07-17	A	Stock	14.907	15.0286	14.6924	14.9928	2873869.0
2009-07-17	AABA-DELISTED	Stock	16.8	16.91	16.45	16.84	30880523.0
2009-07-17	AACC-DELISTED	Stock	8.34	8.57	7.64	7.92	80205.0
2009-07-17	AACG	Stock	8.28	8.3	8.1	8.1	15200.0
2009-07-17	AAI-DELISTED	Stock	6.41	6.43	6.14	6.19	1335995.0
2009-07-17	AAIC-DELISTED	Stock	8.6	8.6	7.6	7.8	344346.0
2009-07-17	AAME	Stock	0.73	0.73	0.7	0.7	1200.0
2009-07-17	AAON	Stock	3.9565	4.0099	3.9427	3.9822	295144.0
2009-07-17	AAP	Stock	45.37	45.58	44.98	45.26	761500.0
2009-07-17	AATI-DELISTED	Stock	4.5	4.505	4.34	4.49	199996.0
2009-07-17	AAU-DELISTED	Stock	0.64	0.67	0.61	0.6601	7500.0
2009-07-17	AAUAF-DELISTED	Stock	0.64	0.67	0.61	0.6601	8200.0
2009-07-17	AAV-DELISTED	Stock	5.02	5.08	4.89	4.96	762670.0
2009-07-17	AAWW-DELISTED	Stock	22.38	23.49	22.36	23.02	292864.0
2009-07-17	AAXJ	Stock	46.8	46.8	45.94	46.56	66388.0
2009-07-17	AAXN-DELISTED	Stock	5.19	5.25	5.01	5.07	404254.0
2009-07-17	AB	Stock	20.82	21.3	20.71	21.15	266900.0
2009-07-17	ABAX-DELISTED	Stock	20.65	20.79	19.13	20.03	491213.0
2009-07-17	ABB-DELISTED	Stock	16.23	16.38	16.11	16.3	1907106.0
2009-07-17	ABBC-DELISTED	Stock	8.59	8.92	8.53	8.83	86694.0
2009-07-17	ABBNY-DELISTED	Stock	16.23	16.38	16.11	16.34	1910306.0
2009-07-17	ABC-DELISTED	Stock	18.56	18.99	18.5	18.98	3986572.0
2009-07-17	ABCB	Stock	6.9155	6.9155	6.293	6.293	24367.0
2009-07-17	ABCO-DELISTED	Stock	12.55	12.95	12.34	12.455	149662.0
2009-07-17	ABCW-DELISTED	Stock	1.199	1.199	1.0733	1.17	34780.0
2009-07-17	ABD-DELISTED	Stock	2.96	2.96	2.78	2.84	293930.0
2009-07-17	ABE-DELISTED	Stock	15.08	15.62	15.08	15.45	20929.0
2009-07-17	ABEO	Stock	2375.0	2625.0	2150.0	2625.0	17.0
2009-07-17	ABFS-DELISTED	Stock	26.65	26.81	25.64	25.83	526317.0
2009-07-17	ABG	Stock	11.72	12.0	11.36	11.61	271800.0
2009-07-17	ABII-DELISTED	Stock	30.91	32.08	30.46	31.67	25625.0
2009-07-17	ABK-DELISTED	Stock	0.92	0.96	0.87	0.8701	3323647.0
2009-07-17	ABM	Stock	18.79	18.96	18.53	18.91	152200.0
2009-07-17	ABMD-DELISTED	Stock	8.17	8.25	8.06	8.08	148247.0
2009-07-17	ABR	Stock	1.64	1.78	1.64	1.72	99200.0
2009-07-17	ABT	Stock	21.3607	21.495	21.2072	21.3367	25745102.0
2009-07-17	ABTL-DELISTED	Stock	2.2468	2.5532	2.2468	2.4	46243.0
2009-07-17	ABV-DELISTED	Stock	69.01	69.74	68.82	69.34	651194.0
2009-07-17	ABVA-DELISTED	Stock	2.2	2.2	2.2	2.2	1003.0
2009-07-17	ABVT-DELISTED	Stock	76.0	77.06	75.64	76.0	35597.0
2009-07-17	ABX-DELISTED	Stock	34.27	34.62	33.92	34.45	4609845.0
2009-07-17	ACAD	Stock	2.25	2.36	2.21	2.29	313100.0
2009-07-17	ACAP-DELISTED	Stock	39.85	39.85	39.0	39.36	29274.0

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

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