PREVIEW / stock_daily / 2010-11-19

all stock daily files

  file:    by_date/stock_daily/2010/2010-11-19.parquet
  size:    195 KB
  rows:    6,047
  symbols: 3,546

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-19	AAPL	Stock	10.9989	11.0143	10.9014	10.9546	384843200.0
2010-11-19	MSFT	Stock	25.8	25.83	25.6	25.69	52423200.0
2010-11-19	NVDA	Stock	0.3322	0.345	0.3318	0.3438	716484000.0
2010-11-19	AMZN	Stock	8.1975	8.2495	8.142	8.241	89296000.0
2010-11-19	TSLA	Stock	2.0107	2.0913	1.98	2.066	17257500.0
2010-11-19	TLT	Stock	96.09	96.59	95.79	96.59	8359478.0
2010-11-19	ES	Stock	31.61	31.7	31.25	31.43	3515200.0
2010-11-19	CL	Stock	39.165	39.295	38.985	39.265	4925600.0
2010-11-19	A	Stock	25.8727	26.0873	25.5937	26.0801	2985289.0
2010-11-19	AABA-DELISTED	Stock	16.95	16.99	16.52	16.57	23705314.0
2010-11-19	AACC-DELISTED	Stock	5.15	5.32	5.02	5.26	16489.0
2010-11-19	AACG	Stock	3.52	3.52	3.35	3.52	2100.0
2010-11-19	AAI-DELISTED	Stock	7.42	7.45	7.41	7.45	780854.0
2010-11-19	AAIC-DELISTED	Stock	24.82	24.92	24.3	24.9	26948.0
2010-11-19	AAME	Stock	1.96	1.96	1.9	1.9	300.0
2010-11-19	AAON	Stock	4.9659	4.9659	4.8731	4.9481	228319.0
2010-11-19	AAP	Stock	65.3	65.5	64.87	65.07	420000.0
2010-11-19	AATI-DELISTED	Stock	3.52	3.65	3.5	3.64	73138.0
2010-11-19	AAU-DELISTED	Stock	2.78	2.9	2.7	2.74	286509.0
2010-11-19	AAUAF-DELISTED	Stock	2.78	2.9	2.7	2.74	289008.0
2010-11-19	AAV-DELISTED	Stock	6.83	6.9	6.78	6.88	235447.0
2010-11-19	AAWW-DELISTED	Stock	57.66	58.0	56.56	57.72	209261.0
2010-11-19	AAXJ	Stock	62.57	62.67	61.88	62.63	2430658.0
2010-11-19	AAXN-DELISTED	Stock	4.22	4.3	4.21	4.27	300329.0
2010-11-19	AB	Stock	23.88	24.27	23.77	24.05	423300.0
2010-11-19	ABAC-DELISTED	Stock	6.0	6.02	5.71	5.78	66432.0
2010-11-19	ABAX-DELISTED	Stock	25.17	26.16	24.82	26.15	144756.0
2010-11-19	ABB-DELISTED	Stock	20.41	20.62	20.34	20.62	1989709.0
2010-11-19	ABBC-DELISTED	Stock	11.9	11.9	11.77	11.82	46786.0
2010-11-19	ABBNY-DELISTED	Stock	20.41	20.62	20.34	20.62	2016149.0
2010-11-19	ABC-DELISTED	Stock	31.42	31.47	30.985	31.01	3524471.0
2010-11-19	ABCB	Stock	9.93	9.95	9.79	9.82	56300.0
2010-11-19	ABCD-DELISTED	Stock	3.05	3.05	2.67	2.89	74522.0
2010-11-19	ABCO-DELISTED	Stock	24.15	24.21	23.33	24.05	94027.0
2010-11-19	ABCW-DELISTED	Stock	0.73	0.8	0.73	0.8	28190.0
2010-11-19	ABD-DELISTED	Stock	7.34	7.38	7.07	7.24	428290.0
2010-11-19	ABE-DELISTED	Stock	18.77	18.85	18.66	18.83	9775.0
2010-11-19	ABEO	Stock	3687.5	3750.0	3687.5	3750.0	4.0
2010-11-19	ABFS-DELISTED	Stock	24.31	24.69	24.02	24.61	142455.0
2010-11-19	ABG	Stock	16.06	16.06	15.6	15.65	275700.0
2010-11-19	ABM	Stock	23.47	23.71	23.44	23.55	136500.0
2010-11-19	ABMD-DELISTED	Stock	11.81	12.0	11.72	11.97	77952.0
2010-11-19	ABR	Stock	5.41	5.43	5.25	5.43	27000.0
2010-11-19	ABT	Stock	22.8577	22.9057	22.6466	22.7425	23808462.0
2010-11-19	ABTL-DELISTED	Stock	3.8987	3.9654	3.8474	3.95	57445.0
2010-11-19	ABUS	Stock	5.63	5.63	5.18	5.2	13800.0
2010-11-19	ABV-DELISTED	Stock	141.15	142.97	140.26	142.81	435726.0
2010-11-19	ABVA-DELISTED	Stock	3.15	3.2	3.15	3.2	1115.0
2010-11-19	ABVT-DELISTED	Stock	61.92	61.92	60.65	60.71	80421.0
2010-11-19	ABX-DELISTED	Stock	49.2	49.89	49.03	49.77	5698827.0

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

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