PREVIEW / stock_daily / 2010-01-04

all stock daily files

  file:    by_date/stock_daily/2010/2010-01-04.parquet
  size:    190 KB
  rows:    5,926
  symbols: 3,508

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-01-04	AAPL	Stock	7.6225	7.6607	7.585	7.6432	493729600.0
2010-01-04	MSFT	Stock	30.62	31.1	30.59	30.95	38409100.0
2010-01-04	NVDA	Stock	0.4628	0.4655	0.4528	0.4622	800204000.0
2010-01-04	AMZN	Stock	6.8125	6.8305	6.657	6.695	151998000.0
2010-01-04	TLT	Stock	89.84	90.1	89.58	89.81	2829018.0
2010-01-04	ES	Stock	25.65	26.0	25.65	25.77	1206800.0
2010-01-04	CL	Stock	41.245	41.44	40.93	41.425	4874200.0
2010-01-04	A	Stock	22.4535	22.6252	22.2675	22.3891	3815561.0
2010-01-04	AABA-DELISTED	Stock	16.94	17.2	16.88	17.1	16322778.0
2010-01-04	AACC-DELISTED	Stock	6.88	7.15	6.83	7.13	20061.0
2010-01-04	AACG	Stock	4.65	4.75	4.65	4.7	1100.0
2010-01-04	AAI-DELISTED	Stock	5.26	5.27	5.08	5.16	3393088.0
2010-01-04	AAIC-DELISTED	Stock	15.2	15.97	15.1	15.76	21871.0
2010-01-04	AAME	Stock	1.32	1.32	1.32	1.32	1500.0
2010-01-04	AAON	Stock	3.9151	3.9506	3.8716	3.9486	368550.0
2010-01-04	AAP	Stock	40.7	41.04	40.36	40.38	1701700.0
2010-01-04	AATI-DELISTED	Stock	3.98	3.98	3.81	3.95	361064.0
2010-01-04	AAU-DELISTED	Stock	1.05	1.13	1.05	1.1	140512.0
2010-01-04	AAUAF-DELISTED	Stock	1.05	1.13	1.05	1.1	144162.0
2010-01-04	AAV-DELISTED	Stock	6.61	6.84	6.61	6.81	833328.0
2010-01-04	AAWW-DELISTED	Stock	37.98	38.66	37.07	38.2	585083.0
2010-01-04	AAXJ	Stock	57.0	57.34	56.77	57.17	273895.0
2010-01-04	AAXN-DELISTED	Stock	4.46	4.66	4.41	4.66	752854.0
2010-01-04	AB	Stock	28.51	28.6	28.18	28.4	556800.0
2010-01-04	ABAX-DELISTED	Stock	25.6	25.6	24.81	24.88	106923.0
2010-01-04	ABB-DELISTED	Stock	19.59	19.7094	19.51	19.66	1844275.0
2010-01-04	ABBC-DELISTED	Stock	6.87	6.94	6.81	6.89	50443.0
2010-01-04	ABBNY-DELISTED	Stock	19.59	19.7094	19.51	19.64	1847102.0
2010-01-04	ABC-DELISTED	Stock	26.29	26.69	26.14	26.63	2438773.0
2010-01-04	ABCB	Stock	7.2198	7.2692	6.884	7.2198	29160.0
2010-01-04	ABCD-DELISTED	Stock	4.1899	4.2	4.01	4.1	26281.0
2010-01-04	ABCO-DELISTED	Stock	16.12	16.455	15.97	16.115	294348.0
2010-01-04	ABCW-DELISTED	Stock	0.6695	0.6695	0.6302	0.64	60660.0
2010-01-04	ABD-DELISTED	Stock	7.49	7.98	7.39	7.9	374430.0
2010-01-04	ABE-DELISTED	Stock	16.73	17.0	16.73	16.99	16142.0
2010-01-04	ABEO	Stock	3937.5	4112.5	3875.0	4000.0	17.0
2010-01-04	ABFS-DELISTED	Stock	29.43	29.77	28.11	28.53	1281595.0
2010-01-04	ABG	Stock	11.68	11.99	11.62	11.83	184800.0
2010-01-04	ABII-DELISTED	Stock	41.73	42.24	40.28	40.47	51973.0
2010-01-04	ABK-DELISTED	Stock	0.82	0.83	0.8	0.82	8726366.0
2010-01-04	ABM	Stock	20.96	21.33	20.95	21.26	169300.0
2010-01-04	ABMD-DELISTED	Stock	8.86	8.92	8.7	8.74	144245.0
2010-01-04	ABR	Stock	1.96	2.0	1.89	1.97	89000.0
2010-01-04	ABT	Stock	26.0004	26.1779	25.8708	26.1299	10829095.0
2010-01-04	ABTL-DELISTED	Stock	4.7425	4.9492	4.2932	4.7575	27566.0
2010-01-04	ABV-DELISTED	Stock	102.5	105.07	101.59	104.83	592308.0
2010-01-04	ABVA-DELISTED	Stock	3.14	3.27	3.14	3.26	1050.0
2010-01-04	ABVT-DELISTED	Stock	65.78	67.0	65.78	66.05	177961.0
2010-01-04	ABX-DELISTED	Stock	40.77	41.18	40.25	40.37	12849305.0
2010-01-04	ACAD	Stock	1.32	1.36	1.3	1.36	300400.0

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

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