PREVIEW / stock_daily / 2010-11-17

all stock daily files

  file:    by_date/stock_daily/2010/2010-11-17.parquet
  size:    194 KB
  rows:    6,017
  symbols: 3,535

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-11-17	AAPL	Stock	10.7571	10.8568	10.6343	10.7321	479449600.0
2010-11-17	MSFT	Stock	25.9	25.91	25.55	25.57	58299700.0
2010-11-17	NVDA	Stock	0.3175	0.3268	0.3145	0.323	551764000.0
2010-11-17	AMZN	Stock	7.892	8.0425	7.8775	7.9175	90498000.0
2010-11-17	TSLA	Stock	2.0133	2.05	1.9073	1.966	11250000.0
2010-11-17	TLT	Stock	95.8	96.76	95.34	95.61	9915562.0
2010-11-17	ES	Stock	31.35	31.39	31.06	31.22	889300.0
2010-11-17	CL	Stock	38.3	38.84	38.21	38.685	6586800.0
2010-11-17	A	Stock	25.0358	25.2861	24.9213	25.186	3886440.0
2010-11-17	AABA-DELISTED	Stock	16.18	16.33	16.11	16.15	9791600.0
2010-11-17	AACC-DELISTED	Stock	4.95	5.01	4.87	4.92	2823.0
2010-11-17	AACG	Stock	3.65	3.65	3.49	3.54	4600.0
2010-11-17	AAI-DELISTED	Stock	7.42	7.44	7.4	7.41	2819113.0
2010-11-17	AAIC-DELISTED	Stock	23.58	23.81	23.38	23.75	19673.0
2010-11-17	AAME	Stock	1.86	1.9	1.86	1.87	1800.0
2010-11-17	AAON	Stock	4.8573	4.8672	4.7921	4.8454	159469.0
2010-11-17	AAP	Stock	65.29	65.91	64.77	65.5	645200.0
2010-11-17	AATI-DELISTED	Stock	3.6	3.64	3.51	3.58	112813.0
2010-11-17	AAU-DELISTED	Stock	2.53	2.69	2.53	2.67	202988.0
2010-11-17	AAUAF-DELISTED	Stock	2.53	2.69	2.53	2.67	203788.0
2010-11-17	AAV-DELISTED	Stock	6.42	6.55	6.3901	6.54	269079.0
2010-11-17	AAWW-DELISTED	Stock	55.01	55.74	53.87	55.2	158986.0
2010-11-17	AAXJ	Stock	61.41	61.72	61.37	61.38	375978.0
2010-11-17	AAXN-DELISTED	Stock	4.03	4.13	4.02	4.11	381232.0
2010-11-17	AB	Stock	23.96	24.16	23.75	23.89	289200.0
2010-11-17	ABAC-DELISTED	Stock	6.58	6.6099	6.0	6.222	138427.0
2010-11-17	ABAX-DELISTED	Stock	24.67	25.02	24.24	24.49	70191.0
2010-11-17	ABB-DELISTED	Stock	20.14	20.25	20.03	20.1	2295887.0
2010-11-17	ABBC-DELISTED	Stock	11.9	11.97	11.81	11.91	59961.0
2010-11-17	ABBNY-DELISTED	Stock	20.14	20.25	20.03	20.08	2653273.0
2010-11-17	ABC-DELISTED	Stock	31.0	31.05	30.7	30.76	1698437.0
2010-11-17	ABCB	Stock	9.66	9.75	9.29	9.43	133100.0
2010-11-17	ABCD-DELISTED	Stock	3.01	3.1	2.95	2.98	23492.0
2010-11-17	ABCO-DELISTED	Stock	23.89	24.06	23.74	23.96	85159.0
2010-11-17	ABCW-DELISTED	Stock	0.7822	0.8231	0.7348	0.7378	93560.0
2010-11-17	ABD-DELISTED	Stock	7.09	7.1	6.95	7.01	147770.0
2010-11-17	ABE-DELISTED	Stock	18.06	18.33	18.0	18.3	87402.0
2010-11-17	ABEO	Stock	3750.0	3750.0	3500.0	3687.5	8.0
2010-11-17	ABFS-DELISTED	Stock	23.78	24.26	23.52	24.16	247283.0
2010-11-17	ABG	Stock	15.46	15.6	15.3	15.38	206000.0
2010-11-17	ABM	Stock	23.47	23.51	22.92	23.04	156500.0
2010-11-17	ABMD-DELISTED	Stock	11.53	11.71	11.37	11.68	62243.0
2010-11-17	ABR	Stock	5.4	5.55	5.4	5.49	27900.0
2010-11-17	ABT	Stock	22.9488	23.0832	22.8913	22.9344	15338474.0
2010-11-17	ABTL-DELISTED	Stock	3.9	3.9	3.555	3.85	38115.0
2010-11-17	ABUS	Stock	5.86	6.26	5.8	6.03	35000.0
2010-11-17	ABV-DELISTED	Stock	135.31	139.47	135.31	138.19	552819.0
2010-11-17	ABVA-DELISTED	Stock	3.15	3.15	3.15	3.15	400.0
2010-11-17	ABVT-DELISTED	Stock	60.52	61.46	60.34	61.24	88533.0
2010-11-17	ABX-DELISTED	Stock	48.79	49.9	48.66	49.18	7972952.0

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

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