PREVIEW / stock_daily / 2010-07-07

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-07.parquet
  size:    189 KB
  rows:    5,924
  symbols: 3,484

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-07	AAPL	Stock	8.9461	9.2418	8.9196	9.2382	654556000.0
2010-07-07	MSFT	Stock	23.82	24.32	23.61	24.3	79965300.0
2010-07-07	NVDA	Stock	0.2545	0.2672	0.254	0.2658	608412000.0
2010-07-07	AMZN	Stock	5.492	5.6815	5.4905	5.6715	98820000.0
2010-07-07	TSLA	Stock	1.0933	1.1087	0.9987	1.0533	103825500.0
2010-07-07	TLT	Stock	101.46	101.51	100.34	100.43	5727793.0
2010-07-07	ES	Stock	25.99	26.77	25.9	26.76	1145700.0
2010-07-07	CL	Stock	39.57	40.495	39.335	40.49	5472000.0
2010-07-07	A	Stock	19.8784	20.4864	19.8283	20.4363	4614518.0
2010-07-07	AABA-DELISTED	Stock	14.09	14.42	14.09	14.41	17232493.0
2010-07-07	AACC-DELISTED	Stock	3.86	4.04	3.86	4.04	74691.0
2010-07-07	AACG	Stock	2.76	2.95	2.76	2.94	600.0
2010-07-07	AAI-DELISTED	Stock	4.64	4.84	4.63	4.83	2997916.0
2010-07-07	AAIC-DELISTED	Stock	18.4	18.83	18.25	18.83	34718.0
2010-07-07	AAME	Stock	1.31	1.31	1.21	1.21	1100.0
2010-07-07	AAON	Stock	4.5116	4.6301	4.5116	4.6183	246544.0
2010-07-07	AAP	Stock	50.67	50.98	50.12	50.89	1423600.0
2010-07-07	AATI-DELISTED	Stock	2.99	3.09	2.94	3.07	114970.0
2010-07-07	AAU-DELISTED	Stock	0.88	0.9	0.85	0.9	55270.0
2010-07-07	AAUAF-DELISTED	Stock	0.88	0.9	0.85	0.9	55970.0
2010-07-07	AAV-DELISTED	Stock	5.73	5.94	5.73	5.94	467648.0
2010-07-07	AAWW-DELISTED	Stock	47.08	47.98	46.54	47.94	395923.0
2010-07-07	AAXJ	Stock	53.06	53.91	52.85	53.88	300965.0
2010-07-07	AAXN-DELISTED	Stock	3.76	3.84	3.7	3.79	469627.0
2010-07-07	AB	Stock	25.05	26.16	25.0	25.97	330900.0
2010-07-07	ABAX-DELISTED	Stock	20.89	21.285	20.7	21.2	111986.0
2010-07-07	ABB-DELISTED	Stock	17.75	18.37	17.73	18.37	2157109.0
2010-07-07	ABBC-DELISTED	Stock	8.78	8.98	8.75	8.94	103942.0
2010-07-07	ABBNY-DELISTED	Stock	17.75	18.37	17.73	18.36	2202068.0
2010-07-07	ABC-DELISTED	Stock	31.38	31.83	31.02	31.8	4297024.0
2010-07-07	ABCB	Stock	9.83	10.08	9.7	10.03	104500.0
2010-07-07	ABCD-DELISTED	Stock	3.5	3.63	3.43	3.55	85364.0
2010-07-07	ABCO-DELISTED	Stock	21.11	21.18	20.76	21.13	119760.0
2010-07-07	ABCW-DELISTED	Stock	0.4596	0.4883	0.4372	0.45	43890.0
2010-07-07	ABD-DELISTED	Stock	4.86	5.14	4.63	5.03	562350.0
2010-07-07	ABE-DELISTED	Stock	16.08	16.437	16.08	16.43	15640.0
2010-07-07	ABEO	Stock	2375.0	2375.0	2275.0	2375.0	7.0
2010-07-07	ABFS-DELISTED	Stock	19.04	20.475	18.9901	20.39	593373.0
2010-07-07	ABG	Stock	9.98	10.29	9.8	10.27	375100.0
2010-07-07	ABII-DELISTED	Stock	73.76	74.22	73.53	74.02	103433.0
2010-07-07	ABK-DELISTED	Stock	0.65	0.67	0.63	0.6473	6371374.0
2010-07-07	ABM	Stock	20.33	20.81	20.32	20.79	248500.0
2010-07-07	ABMD-DELISTED	Stock	9.98	10.54	9.93	10.49	290298.0
2010-07-07	ABR	Stock	4.49	5.08	4.46	4.97	222700.0
2010-07-07	ABT	Stock	22.4259	22.92	22.3539	22.8913	19011255.0
2010-07-07	ABTL-DELISTED	Stock	6.1022	6.1543	5.9457	6.05	17458.0
2010-07-07	ABV-DELISTED	Stock	104.46	105.28	104.12	105.18	350884.0
2010-07-07	ABVA-DELISTED	Stock	2.79	2.79	2.79	2.79	100.0
2010-07-07	ABVT-DELISTED	Stock	46.67	47.98	46.67	47.91	86851.0
2010-07-07	ABX-DELISTED	Stock	42.86	43.88	42.43	43.87	8237205.0

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

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