PREVIEW / stock_daily / 2010-08-03

all stock daily files

  file:    by_date/stock_daily/2010/2010-08-03.parquet
  size:    191 KB
  rows:    5,961
  symbols: 3,507

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-08-03	AAPL	Stock	9.3218	9.4021	9.265	9.3546	417653600.0
2010-08-03	MSFT	Stock	26.2	26.35	25.97	26.16	56877700.0
2010-08-03	NVDA	Stock	0.2278	0.228	0.2218	0.2235	955444000.0
2010-08-03	AMZN	Stock	6.0	6.1435	5.984	6.121	119076000.0
2010-08-03	TSLA	Stock	1.4	1.4633	1.388	1.4633	18457500.0
2010-08-03	TLT	Stock	99.2	99.66	98.93	99.32	4363423.0
2010-08-03	ES	Stock	28.38	28.46	28.23	28.3	1089900.0
2010-08-03	CL	Stock	38.95	39.17	38.815	39.07	7014800.0
2010-08-03	A	Stock	20.4649	20.5508	19.8856	19.9142	5927800.0
2010-08-03	AABA-DELISTED	Stock	13.95	14.07	13.91	13.93	13791531.0
2010-08-03	AACC-DELISTED	Stock	4.55	4.64	4.43	4.43	160544.0
2010-08-03	AACG	Stock	3.1	3.14	2.98	2.98	8800.0
2010-08-03	AAI-DELISTED	Stock	4.92	4.92	4.8	4.81	1276194.0
2010-08-03	AAIC-DELISTED	Stock	19.83	19.94	19.73	19.85	35665.0
2010-08-03	AAME	Stock	1.25	1.25	1.2	1.2	9100.0
2010-08-03	AAON	Stock	5.0212	5.1299	4.9481	5.0114	199462.0
2010-08-03	AAP	Stock	53.21	53.28	52.15	52.61	924500.0
2010-08-03	AATI-DELISTED	Stock	3.22	3.29	3.2	3.24	88787.0
2010-08-03	AAU-DELISTED	Stock	0.9	0.93	0.89	0.92	23200.0
2010-08-03	AAUAF-DELISTED	Stock	0.9	0.93	0.89	0.92	23500.0
2010-08-03	AAV-DELISTED	Stock	6.38	6.5	6.36	6.49	316891.0
2010-08-03	AAWW-DELISTED	Stock	59.9	60.0	47.27	50.27	3616208.0
2010-08-03	AAXJ	Stock	57.25	57.43	56.88	57.27	1637865.0
2010-08-03	AAXN-DELISTED	Stock	4.07	4.11	4.01	4.04	384791.0
2010-08-03	AB	Stock	26.96	26.98	26.26	26.3	492400.0
2010-08-03	ABAC-DELISTED	Stock	4.02	4.05	3.95	3.9881	18900.0
2010-08-03	ABAX-DELISTED	Stock	20.54	21.26	20.5	20.97	189532.0
2010-08-03	ABB-DELISTED	Stock	20.63	20.72	20.4401	20.66	2278587.0
2010-08-03	ABBC-DELISTED	Stock	9.55	9.63	9.4	9.42	55437.0
2010-08-03	ABBNY-DELISTED	Stock	20.63	20.72	20.4401	20.66	2362250.0
2010-08-03	ABC-DELISTED	Stock	30.6	30.6	29.93	29.99	3740570.0
2010-08-03	ABCB	Stock	9.66	9.9	9.51	9.54	85200.0
2010-08-03	ABCD-DELISTED	Stock	3.49	3.62	3.49	3.55	38079.0
2010-08-03	ABCO-DELISTED	Stock	22.06	22.21	21.78	21.88	154606.0
2010-08-03	ABCW-DELISTED	Stock	0.72	0.75	0.63	0.66	85720.0
2010-08-03	ABD-DELISTED	Stock	6.3	6.51	6.15	6.35	343310.0
2010-08-03	ABE-DELISTED	Stock	17.31	17.4161	17.2	17.39	6400.0
2010-08-03	ABEO	Stock	2475.0	2500.0	2437.5	2500.0	50.0
2010-08-03	ABFS-DELISTED	Stock	23.11	23.11	22.25	22.4	287745.0
2010-08-03	ABG	Stock	13.91	13.94	13.53	13.78	228700.0
2010-08-03	ABII-DELISTED	Stock	75.3	75.68	75.3	75.59	772874.0
2010-08-03	ABK-DELISTED	Stock	0.81	0.844	0.7735	0.78	10994607.0
2010-08-03	ABM	Stock	21.85	21.97	21.48	21.71	137300.0
2010-08-03	ABMD-DELISTED	Stock	11.1	11.26	10.95	10.97	195496.0
2010-08-03	ABR	Stock	5.84	5.94	5.57	5.94	87200.0
2010-08-03	ABT	Stock	23.9468	24.2827	23.8748	23.99	18921217.0
2010-08-03	ABTL-DELISTED	Stock	5.05	5.5	5.05	5.5	111217.0
2010-08-03	ABV-DELISTED	Stock	109.49	109.49	107.87	108.74	792220.0
2010-08-03	ABVT-DELISTED	Stock	54.13	54.16	52.88	52.94	100036.0
2010-08-03	ABX-DELISTED	Stock	41.17	41.89	41.09	41.4	6703370.0

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

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