PREVIEW / stock_daily / 2010-11-18

all stock daily files

  file:    by_date/stock_daily/2010/2010-11-18.parquet
  size:    194 KB
  rows:    6,028
  symbols: 3,523

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-18	AAPL	Stock	10.9	11.0596	10.8818	11.0154	494491200.0
2010-11-18	MSFT	Stock	25.71	26.08	25.61	25.84	59514000.0
2010-11-18	NVDA	Stock	0.3273	0.3362	0.3273	0.333	993120000.0
2010-11-18	AMZN	Stock	8.037	8.25	8.037	8.2085	124506000.0
2010-11-18	TSLA	Stock	2.0447	2.0493	1.928	1.9927	14341500.0
2010-11-18	TLT	Stock	95.68	96.0	94.8	96.0	12425314.0
2010-11-18	ES	Stock	31.52	31.63	31.34	31.61	3326600.0
2010-11-18	CL	Stock	38.96	39.245	38.91	39.105	4312600.0
2010-11-18	A	Stock	25.4936	26.0372	25.4077	25.9156	4135144.0
2010-11-18	AABA-DELISTED	Stock	16.38	17.17	16.291	17.0	43856822.0
2010-11-18	AACC-DELISTED	Stock	4.97	5.21	4.97	5.15	13738.0
2010-11-18	AACG	Stock	3.54	3.55	3.46	3.55	9500.0
2010-11-18	AAI-DELISTED	Stock	7.44	7.45	7.42	7.42	2210822.0
2010-11-18	AAIC-DELISTED	Stock	23.98	24.92	23.98	24.79	30515.0
2010-11-18	AAME	Stock	1.85	1.96	1.85	1.96	700.0
2010-11-18	AAON	Stock	4.9205	5.0173	4.8573	4.958	225281.0
2010-11-18	AAP	Stock	65.99	66.65	65.36	65.51	631500.0
2010-11-18	AATI-DELISTED	Stock	3.61	3.7	3.5	3.52	178325.0
2010-11-18	AAU-DELISTED	Stock	2.7	2.86	2.7	2.78	206240.0
2010-11-18	AAUAF-DELISTED	Stock	2.7	2.86	2.7	2.78	206940.0
2010-11-18	AAV-DELISTED	Stock	6.55	6.87	6.55	6.84	563217.0
2010-11-18	AAWW-DELISTED	Stock	56.13	57.99	56.1	57.63	190658.0
2010-11-18	AAXJ	Stock	62.52	62.93	62.45	62.68	225147.0
2010-11-18	AAXN-DELISTED	Stock	4.16	4.21	4.125	4.21	518714.0
2010-11-18	AB	Stock	24.07	24.55	23.95	23.96	289600.0
2010-11-18	ABAC-DELISTED	Stock	6.27	6.45	6.0	6.0	81024.0
2010-11-18	ABAX-DELISTED	Stock	24.88	25.45	24.525	25.14	142816.0
2010-11-18	ABB-DELISTED	Stock	20.59	20.66	20.48	20.56	1743713.0
2010-11-18	ABBC-DELISTED	Stock	12.01	12.01	11.88	11.9	60957.0
2010-11-18	ABBNY-DELISTED	Stock	20.59	20.66	20.48	20.55	1776917.0
2010-11-18	ABC-DELISTED	Stock	30.89	31.52	30.7	31.47	4619316.0
2010-11-18	ABCB	Stock	9.58	9.95	9.54	9.91	31400.0
2010-11-18	ABCD-DELISTED	Stock	3.02	3.1	3.0	3.04	30288.0
2010-11-18	ABCO-DELISTED	Stock	24.23	24.47	23.94	24.06	93834.0
2010-11-18	ABCW-DELISTED	Stock	0.79	0.81	0.74	0.74	35680.0
2010-11-18	ABD-DELISTED	Stock	7.12	7.47	7.06	7.39	410570.0
2010-11-18	ABE-DELISTED	Stock	18.43	18.9275	18.43	18.9275	12348.0
2010-11-18	ABEO	Stock	3687.5	3750.0	3687.5	3750.0	7.0
2010-11-18	ABFS-DELISTED	Stock	24.5	25.12	24.27	24.31	197250.0
2010-11-18	ABG	Stock	15.58	16.2	15.58	16.03	233200.0
2010-11-18	ABM	Stock	23.29	23.66	23.26	23.58	188300.0
2010-11-18	ABMD-DELISTED	Stock	11.73	11.88	11.62	11.8	74345.0
2010-11-18	ABR	Stock	5.57	5.66	5.34	5.46	27500.0
2010-11-18	ABT	Stock	22.9968	23.016	22.6466	22.8481	25482701.0
2010-11-18	ABTL-DELISTED	Stock	3.8625	3.8625	3.7622	3.8375	5949.0
2010-11-18	ABUS	Stock	6.0	6.0	5.5	5.51	23800.0
2010-11-18	ABV-DELISTED	Stock	139.63	142.34	139.38	141.66	329834.0
2010-11-18	ABVA-DELISTED	Stock	3.2	3.2	3.15	3.1501	2938.0
2010-11-18	ABVT-DELISTED	Stock	62.08	62.14	61.73	61.91	77415.0
2010-11-18	ABX-DELISTED	Stock	50.2	50.28	49.4	49.54	8461404.0

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

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