PREVIEW / stock_daily / 2010-09-03

all stock daily files

  file:    by_date/stock_daily/2010/2010-09-03.parquet
  size:    190 KB
  rows:    5,947
  symbols: 3,489

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-09-03	AAPL	Stock	9.1104	9.2421	9.0893	9.2418	520788800.0
2010-09-03	MSFT	Stock	24.24	24.45	24.2	24.29	64189100.0
2010-09-03	NVDA	Stock	0.245	0.2482	0.242	0.2475	566484000.0
2010-09-03	AMZN	Stock	6.8445	6.975	6.8315	6.9395	131624000.0
2010-09-03	TSLA	Stock	1.3913	1.42	1.3773	1.4033	6519000.0
2010-09-03	TLT	Stock	102.72	103.94	102.7	103.58	9210650.0
2010-09-03	ES	Stock	29.42	29.61	29.26	29.48	1390300.0
2010-09-03	CL	Stock	37.505	37.62	37.06	37.425	7356800.0
2010-09-03	A	Stock	21.0944	21.4521	21.0944	21.3519	3164932.0
2010-09-03	AABA-DELISTED	Stock	13.7	13.75	13.56	13.63	12435494.0
2010-09-03	AACC-DELISTED	Stock	3.91	4.02	3.815	4.02	21234.0
2010-09-03	AACG	Stock	2.95	3.03	2.9	2.95	22300.0
2010-09-03	AAI-DELISTED	Stock	4.7	4.75	4.66	4.74	948530.0
2010-09-03	AAIC-DELISTED	Stock	20.6	21.24	20.38	21.23	34635.0
2010-09-03	AAME	Stock	1.39	1.45	1.39	1.44	10000.0
2010-09-03	AAON	Stock	4.4919	4.4919	4.4148	4.4721	121500.0
2010-09-03	AAP	Stock	56.72	57.63	55.85	56.54	916100.0
2010-09-03	AATI-DELISTED	Stock	3.44	3.44	3.34	3.4	144424.0
2010-09-03	AAU-DELISTED	Stock	2.49	2.9396	2.36	2.62	3100032.0
2010-09-03	AAUAF-DELISTED	Stock	2.49	2.9396	2.36	2.61	3117091.0
2010-09-03	AAV-DELISTED	Stock	6.3	6.45	6.3	6.37	403977.0
2010-09-03	AAWW-DELISTED	Stock	47.95	49.63	47.95	49.36	436975.0
2010-09-03	AAXJ	Stock	56.66	56.66	56.17	56.46	320898.0
2010-09-03	AAXN-DELISTED	Stock	4.0	4.01	3.93	3.98	352229.0
2010-09-03	AB	Stock	24.76	25.03	24.69	24.99	486500.0
2010-09-03	ABAC-DELISTED	Stock	3.97	3.97	3.75	3.75	18274.0
2010-09-03	ABAX-DELISTED	Stock	19.39	19.5	19.044	19.45	58103.0
2010-09-03	ABB-DELISTED	Stock	20.34	20.45	20.18	20.37	2664597.0
2010-09-03	ABBC-DELISTED	Stock	10.2	10.49	10.18	10.28	80258.0
2010-09-03	ABBNY-DELISTED	Stock	20.37	20.45	20.18	20.39	2669585.0
2010-09-03	ABC-DELISTED	Stock	28.18	28.76	27.91	28.09	3634735.0
2010-09-03	ABCB	Stock	8.47	8.6	8.33	8.59	46800.0
2010-09-03	ABCD-DELISTED	Stock	3.1	3.1	2.93	3.09	74186.0
2010-09-03	ABCO-DELISTED	Stock	21.18	21.59	20.61	21.49	71026.0
2010-09-03	ABCW-DELISTED	Stock	0.67	0.67	0.63	0.63	69770.0
2010-09-03	ABD-DELISTED	Stock	6.35	6.4	6.17	6.23	522180.0
2010-09-03	ABE-DELISTED	Stock	17.33	17.42	17.25	17.37	9067.0
2010-09-03	ABEO	Stock	2500.0	2625.0	2400.0	2437.5	19.0
2010-09-03	ABFS-DELISTED	Stock	22.26	22.64	21.28	21.67	353836.0
2010-09-03	ABG	Stock	13.38	13.6	13.24	13.6	147200.0
2010-09-03	ABII-DELISTED	Stock	74.27	74.36	73.97	74.22	45202.0
2010-09-03	ABK-DELISTED	Stock	0.58	0.588	0.55	0.5551	6895165.0
2010-09-03	ABM	Stock	21.3	21.46	21.01	21.38	253100.0
2010-09-03	ABMD-DELISTED	Stock	9.61	9.8	9.43	9.66	100488.0
2010-09-03	ABR	Stock	4.79	4.8	4.7	4.73	23100.0
2010-09-03	ABT	Stock	24.441	24.465	24.11	24.3451	9947478.0
2010-09-03	ABTL-DELISTED	Stock	4.35	4.35	4.225	4.25	23740.0
2010-09-03	ABV-DELISTED	Stock	113.31	114.0545	112.18	112.63	492548.0
2010-09-03	ABVT-DELISTED	Stock	53.68	54.0	52.69	53.07	119630.0
2010-09-03	ABX-DELISTED	Stock	45.02	45.37	44.62	45.3	7872615.0

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

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