PREVIEW / stock_daily / 2010-08-02

all stock daily files

  file:    by_date/stock_daily/2010/2010-08-02.parquet
  size:    191 KB
  rows:    5,980
  symbols: 3,512

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-02	AAPL	Stock	9.3014	9.3782	9.2721	9.3518	428055600.0
2010-08-02	MSFT	Stock	25.99	26.38	25.75	26.33	55044600.0
2010-08-02	NVDA	Stock	0.2338	0.2348	0.2285	0.2295	917020000.0
2010-08-02	AMZN	Stock	5.9575	6.019	5.8785	6.0035	108874000.0
2010-08-02	TSLA	Stock	1.3667	1.398	1.3553	1.3947	10771500.0
2010-08-02	TLT	Stock	99.24	99.33	98.75	98.75	5769206.0
2010-08-02	ES	Stock	28.17	28.59	28.17	28.5	1251100.0
2010-08-02	CL	Stock	39.785	39.785	39.05	39.125	11233600.0
2010-08-02	A	Stock	20.279	20.7225	20.1717	20.6152	4052383.0
2010-08-02	AABA-DELISTED	Stock	14.01	14.08	13.96	13.97	14094327.0
2010-08-02	AACC-DELISTED	Stock	4.58	4.8	4.48	4.58	25171.0
2010-08-02	AACG	Stock	2.99	3.23	2.98	2.98	2900.0
2010-08-02	AAI-DELISTED	Stock	4.87	4.93	4.85	4.93	2050781.0
2010-08-02	AAIC-DELISTED	Stock	20.21	20.32	19.74	19.94	47069.0
2010-08-02	AAON	Stock	4.9719	5.0568	4.9363	5.0449	295650.0
2010-08-02	AAP	Stock	54.13	54.15	52.96	53.43	1102100.0
2010-08-02	AATI-DELISTED	Stock	3.25	3.26	3.18	3.22	71597.0
2010-08-02	AAU-DELISTED	Stock	0.97	0.97	0.9002	0.9002	76940.0
2010-08-02	AAUAF-DELISTED	Stock	0.97	0.97	0.9002	0.9002	77540.0
2010-08-02	AAV-DELISTED	Stock	6.35	6.45	6.35	6.38	226485.0
2010-08-02	AAWW-DELISTED	Stock	59.86	59.98	58.05	59.25	392148.0
2010-08-02	AAXJ	Stock	57.24	57.59	57.04	57.45	2418795.0
2010-08-02	AAXN-DELISTED	Stock	4.18	4.18	4.01	4.1	456210.0
2010-08-02	AB	Stock	26.6	27.35	26.02	26.84	696100.0
2010-08-02	ABAC-DELISTED	Stock	4.15	4.15	4.02	4.03	16140.0
2010-08-02	ABAX-DELISTED	Stock	20.41	20.83	20.18	20.69	241281.0
2010-08-02	ABB-DELISTED	Stock	20.58	20.868	20.53	20.7	3131003.0
2010-08-02	ABBC-DELISTED	Stock	9.65	9.84	9.53	9.58	42266.0
2010-08-02	ABBNY-DELISTED	Stock	20.58	20.868	20.53	20.73	3142751.0
2010-08-02	ABC-DELISTED	Stock	30.28	30.79	30.19	30.57	5894745.0
2010-08-02	ABCB	Stock	9.95	10.06	9.55	9.7	63700.0
2010-08-02	ABCD-DELISTED	Stock	3.51	3.52	3.44	3.5	43686.0
2010-08-02	ABCO-DELISTED	Stock	22.21	22.48	21.97	22.19	175898.0
2010-08-02	ABCW-DELISTED	Stock	0.72	0.75	0.72	0.73	35060.0
2010-08-02	ABD-DELISTED	Stock	6.07	6.41	6.02	6.33	321110.0
2010-08-02	ABE-DELISTED	Stock	17.21	17.45	17.02	17.45	14165.0
2010-08-02	ABEO	Stock	2462.5	2500.0	2375.0	2475.0	51.0
2010-08-02	ABFS-DELISTED	Stock	22.92	23.5796	22.92	23.16	284896.0
2010-08-02	ABG	Stock	13.8	14.16	13.78	14.05	356900.0
2010-08-02	ABII-DELISTED	Stock	75.51	75.85	75.3	75.48	553281.0
2010-08-02	ABK-DELISTED	Stock	0.86	0.8768	0.82	0.8449	11159256.0
2010-08-02	ABM	Stock	22.01	22.21	21.63	21.96	122700.0
2010-08-02	ABMD-DELISTED	Stock	11.28	11.48	11.0805	11.19	340251.0
2010-08-02	ABR	Stock	6.2	6.2	5.94	5.98	89200.0
2010-08-02	ABT	Stock	23.8509	23.99	23.8077	23.9084	15648187.0
2010-08-02	ABTL-DELISTED	Stock	5.1	5.1925	4.99	5.15	12087.0
2010-08-02	ABV-DELISTED	Stock	111.0	112.6	104.95	109.34	1903039.0
2010-08-02	ABVA-DELISTED	Stock	2.55	2.55	2.54	2.54	2762.0
2010-08-02	ABVT-DELISTED	Stock	53.88	55.24	53.69	54.11	201964.0
2010-08-02	ABX-DELISTED	Stock	41.77	41.98	40.66	40.95	6199413.0

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

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