PREVIEW / stock_daily / 2010-08-04

all stock daily files

  file:    by_date/stock_daily/2010/2010-08-04.parquet
  size:    191 KB
  rows:    5,976
  symbols: 3,516

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-04	AAPL	Stock	9.3871	9.4386	9.2968	9.3921	420375200.0
2010-08-04	MSFT	Stock	26.15	26.24	25.44	25.73	78531900.0
2010-08-04	NVDA	Stock	0.2255	0.2338	0.2245	0.233	855496000.0
2010-08-04	AMZN	Stock	6.153	6.4235	6.15	6.379	185416000.0
2010-08-04	TSLA	Stock	1.4633	1.4787	1.39	1.4173	13695000.0
2010-08-04	TLT	Stock	99.5	99.51	98.56	98.56	3820360.0
2010-08-04	ES	Stock	28.48	29.03	28.35	28.77	2280200.0
2010-08-04	CL	Stock	39.05	39.275	39.0	39.03	4265200.0
2010-08-04	A	Stock	19.9285	20.279	19.8498	20.2361	3288935.0
2010-08-04	AABA-DELISTED	Stock	14.0	14.2	13.92	14.17	13671263.0
2010-08-04	AACC-DELISTED	Stock	4.47	4.66	4.47	4.6	26186.0
2010-08-04	AACG	Stock	3.24	3.24	3.0	3.0	7900.0
2010-08-04	AAI-DELISTED	Stock	4.82	4.88	4.72	4.78	1459215.0
2010-08-04	AAIC-DELISTED	Stock	19.83	20.331	19.825	19.93	58695.0
2010-08-04	AAME	Stock	1.2	1.2	1.2	1.2	400.0
2010-08-04	AAON	Stock	5.0489	5.116	4.8138	5.0746	123019.0
2010-08-04	AAP	Stock	52.75	53.53	52.59	53.36	651600.0
2010-08-04	AATI-DELISTED	Stock	3.25	3.28	3.21	3.27	69305.0
2010-08-04	AAU-DELISTED	Stock	0.92	1.01	0.912	0.9999	163295.0
2010-08-04	AAUAF-DELISTED	Stock	0.92	1.01	0.912	0.9999	164795.0
2010-08-04	AAV-DELISTED	Stock	6.45	6.5	6.31	6.34	282117.0
2010-08-04	AAWW-DELISTED	Stock	50.26	51.12	49.48	50.63	810677.0
2010-08-04	AAXJ	Stock	57.12	57.4	56.9681	57.18	863824.0
2010-08-04	AAXN-DELISTED	Stock	4.07	4.13	4.0	4.05	373754.0
2010-08-04	AB	Stock	26.58	26.84	26.54	26.7	558700.0
2010-08-04	ABAC-DELISTED	Stock	4.0	4.05	3.988	4.0	8950.0
2010-08-04	ABAX-DELISTED	Stock	21.02	21.38	21.01	21.19	96585.0
2010-08-04	ABB-DELISTED	Stock	20.65	20.84	20.41	20.59	1789335.0
2010-08-04	ABBC-DELISTED	Stock	9.43	9.61	9.35	9.4	52742.0
2010-08-04	ABBNY-DELISTED	Stock	20.65	20.84	20.41	20.59	1796638.0
2010-08-04	ABC-DELISTED	Stock	30.03	30.41	29.95	30.37	3183109.0
2010-08-04	ABCB	Stock	9.54	9.63	9.49	9.56	36000.0
2010-08-04	ABCD-DELISTED	Stock	3.57	3.62	3.53	3.61	39636.0
2010-08-04	ABCO-DELISTED	Stock	21.9	22.23	21.81	22.17	129650.0
2010-08-04	ABCW-DELISTED	Stock	0.68	0.68	0.61	0.62	54660.0
2010-08-04	ABD-DELISTED	Stock	6.35	6.51	6.32	6.45	296570.0
2010-08-04	ABE-DELISTED	Stock	17.47	17.47	17.32	17.47	11699.0
2010-08-04	ABEO	Stock	2625.0	2625.0	2500.0	2625.0	26.0
2010-08-04	ABFS-DELISTED	Stock	22.41	23.31	22.32	22.94	267363.0
2010-08-04	ABG	Stock	13.9	14.05	13.65	13.76	219600.0
2010-08-04	ABII-DELISTED	Stock	75.55	76.17	75.55	76.04	73780.0
2010-08-04	ABK-DELISTED	Stock	0.78	0.91	0.7622	0.91	21367969.0
2010-08-04	ABM	Stock	21.78	22.16	21.78	21.96	90600.0
2010-08-04	ABMD-DELISTED	Stock	11.0	11.26	10.44	10.49	345189.0
2010-08-04	ABR	Stock	6.0	6.07	5.96	6.0	46400.0
2010-08-04	ABT	Stock	23.9804	24.1195	23.8892	24.0764	12857232.0
2010-08-04	ABTL-DELISTED	Stock	5.5	5.6	5.35	5.35	72315.0
2010-08-04	ABV-DELISTED	Stock	108.58	109.22	107.72	108.56	645943.0
2010-08-04	ABVA-DELISTED	Stock	2.46	3.42	2.46	3.25	16844.0
2010-08-04	ABVT-DELISTED	Stock	53.12	54.2	52.99	54.06	81487.0

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

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