PREVIEW / stock_daily / 2010-07-09

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-09.parquet
  size:    188 KB
  rows:    5,908
  symbols: 3,479

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-07-09	AAPL	Stock	9.1746	9.2821	9.1129	9.2721	433322400.0
2010-07-09	MSFT	Stock	24.33	24.41	24.15	24.27	53806100.0
2010-07-09	NVDA	Stock	0.259	0.2605	0.2555	0.2588	571516000.0
2010-07-09	AMZN	Stock	5.8275	5.87	5.7325	5.863	81302000.0
2010-07-09	TSLA	Stock	1.172	1.1933	1.1033	1.16	60759000.0
2010-07-09	TLT	Stock	99.4	99.64	99.18	99.22	4286009.0
2010-07-09	ES	Stock	27.04	27.04	26.64	26.88	1472600.0
2010-07-09	CL	Stock	40.88	41.225	40.845	41.075	4259400.0
2010-07-09	A	Stock	20.6581	20.7082	20.3505	20.4936	3316615.0
2010-07-09	AABA-DELISTED	Stock	14.6	14.93	14.59	14.89	11262784.0
2010-07-09	AACC-DELISTED	Stock	3.9	4.01	3.88	3.99	30180.0
2010-07-09	AACG	Stock	3.0	3.01	2.88	2.91	600.0
2010-07-09	AAI-DELISTED	Stock	4.85	4.99	4.85	4.98	2138531.0
2010-07-09	AAIC-DELISTED	Stock	19.07	19.5	18.83	19.49	60776.0
2010-07-09	AAME	Stock	1.3	1.4	1.29	1.3	2800.0
2010-07-09	AAON	Stock	4.6617	4.7309	4.6459	4.723	96187.0
2010-07-09	AAP	Stock	50.93	51.51	50.77	51.27	1050400.0
2010-07-09	AATI-DELISTED	Stock	3.05	3.19	3.04	3.18	108578.0
2010-07-09	AAU-DELISTED	Stock	0.94	0.9599	0.89	0.913	125566.0
2010-07-09	AAUAF-DELISTED	Stock	0.94	0.9599	0.89	0.913	125766.0
2010-07-09	AAV-DELISTED	Stock	6.12	6.39	6.12	6.36	461561.0
2010-07-09	AAWW-DELISTED	Stock	50.25	51.44	49.24	51.07	249889.0
2010-07-09	AAXJ	Stock	54.41	55.03	54.27	54.98	132304.0
2010-07-09	AAXN-DELISTED	Stock	3.75	3.87	3.66	3.86	694533.0
2010-07-09	AB	Stock	26.9	27.62	26.7	27.62	319900.0
2010-07-09	ABAX-DELISTED	Stock	20.55	20.93	20.29	20.59	211645.0
2010-07-09	ABB-DELISTED	Stock	18.61	18.88	18.54	18.86	2108494.0
2010-07-09	ABBC-DELISTED	Stock	9.0401	9.12	9.02	9.1	16112.0
2010-07-09	ABBNY-DELISTED	Stock	18.61	18.88	18.54	18.86	2119421.0
2010-07-09	ABC-DELISTED	Stock	31.99	32.01	31.72	31.84	1957478.0
2010-07-09	ABCB	Stock	9.99	10.35	9.99	10.3	34600.0
2010-07-09	ABCD-DELISTED	Stock	3.74	3.75	3.73	3.73	21732.0
2010-07-09	ABCO-DELISTED	Stock	20.93	21.12	20.59	21.06	133834.0
2010-07-09	ABCW-DELISTED	Stock	0.4707	0.49	0.442	0.49	88200.0
2010-07-09	ABD-DELISTED	Stock	5.3049	5.5851	5.2548	5.5751	257110.0
2010-07-09	ABE-DELISTED	Stock	16.36	16.71	16.36	16.71	27716.0
2010-07-09	ABEO	Stock	2362.5	2437.5	2250.0	2375.0	11.0
2010-07-09	ABFS-DELISTED	Stock	21.15	21.59	20.79	21.52	382700.0
2010-07-09	ABG	Stock	10.27	10.45	10.15	10.29	520100.0
2010-07-09	ABII-DELISTED	Stock	73.96	74.9	73.96	74.2	241165.0
2010-07-09	ABK-DELISTED	Stock	0.66	0.68	0.642	0.661	5035525.0
2010-07-09	ABM	Stock	21.54	21.73	21.31	21.57	217500.0
2010-07-09	ABMD-DELISTED	Stock	10.61	10.7657	10.44	10.73	284982.0
2010-07-09	ABR	Stock	4.94	5.35	4.94	5.25	136500.0
2010-07-09	ABT	Stock	23.1072	23.1072	22.8001	23.0448	10837849.0
2010-07-09	ABTL-DELISTED	Stock	6.1525	6.1525	5.8962	6.05	6829.0
2010-07-09	ABV-DELISTED	Stock	106.03	107.0	105.71	106.95	450417.0
2010-07-09	ABVA-DELISTED	Stock	2.76	2.77	2.51	2.6	800.0
2010-07-09	ABVT-DELISTED	Stock	48.11	49.74	47.99	49.44	139269.0
2010-07-09	ABX-DELISTED	Stock	43.38	44.135	43.19	43.55	8874642.0

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

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