PREVIEW / stock_daily / 2010-01-21

all stock daily files

  file:    by_date/stock_daily/2010/2010-01-21.parquet
  size:    190 KB
  rows:    5,907
  symbols: 3,487

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-21	AAPL	Stock	7.5743	7.6182	7.4004	7.4311	608154400.0
2010-01-21	MSFT	Stock	30.61	30.72	30.0	30.01	73086700.0
2010-01-21	NVDA	Stock	0.4338	0.4415	0.4222	0.4262	608632000.0
2010-01-21	AMZN	Stock	6.363	6.4075	6.25	6.331	199412000.0
2010-01-21	TLT	Stock	91.55	92.39	91.46	92.16	4363028.0
2010-01-21	ES	Stock	26.38	26.62	25.83	25.96	1639600.0
2010-01-21	CL	Stock	40.12	40.48	39.13	39.535	9020200.0
2010-01-21	A	Stock	22.1745	22.2532	21.588	21.8312	6081440.0
2010-01-21	AABA-DELISTED	Stock	16.39	16.58	16.1	16.2	21258724.0
2010-01-21	AACC-DELISTED	Stock	5.85	5.96	5.57	5.57	34337.0
2010-01-21	AACG	Stock	4.33	4.33	4.2	4.2	1400.0
2010-01-21	AAI-DELISTED	Stock	5.65	5.94	5.5	5.53	6674504.0
2010-01-21	AAIC-DELISTED	Stock	16.1	16.19	15.6872	16.06	32075.0
2010-01-21	AAME	Stock	1.4	1.46	1.4	1.46	3400.0
2010-01-21	AAON	Stock	3.7788	3.838	3.7333	3.7827	310331.0
2010-01-21	AAP	Stock	39.34	39.65	38.95	39.23	1297400.0
2010-01-21	AATI-DELISTED	Stock	3.93	3.99	3.93	3.98	219643.0
2010-01-21	AAU-DELISTED	Stock	1.02	1.0417	0.97	1.01	328233.0
2010-01-21	AAUAF-DELISTED	Stock	1.02	1.0417	0.97	1.01	330683.0
2010-01-21	AAV-DELISTED	Stock	6.75	6.87	6.64	6.69	567903.0
2010-01-21	AAWW-DELISTED	Stock	39.05	39.4	37.36	38.02	360614.0
2010-01-21	AAXJ	Stock	56.21	56.27	54.89	55.02	503224.0
2010-01-21	AAXN-DELISTED	Stock	6.25	6.28	5.86	5.88	1270546.0
2010-01-21	AB	Stock	29.92	29.96	28.5	28.76	417600.0
2010-01-21	ABAX-DELISTED	Stock	25.04	25.29	23.79	24.09	262991.0
2010-01-21	ABB-DELISTED	Stock	18.9	18.97	18.29	18.65	8108966.0
2010-01-21	ABBC-DELISTED	Stock	7.11	7.12	6.95	7.02	43390.0
2010-01-21	ABBNY-DELISTED	Stock	18.9	18.97	18.29	18.66	8110716.0
2010-01-21	ABC-DELISTED	Stock	27.11	27.18	26.25	26.56	3936050.0
2010-01-21	ABCB	Stock	8.7803	9.0371	8.4248	8.8889	61863.0
2010-01-21	ABCD-DELISTED	Stock	4.03	4.05	4.0	4.0499	3408.0
2010-01-21	ABCO-DELISTED	Stock	16.345	16.435	15.88	15.9	239354.0
2010-01-21	ABCW-DELISTED	Stock	1.25	1.37	1.04	1.17	631480.0
2010-01-21	ABD-DELISTED	Stock	8.243	8.332	8.018	8.247	435930.0
2010-01-21	ABE-DELISTED	Stock	16.73	16.73	16.4	16.46	12850.0
2010-01-21	ABEO	Stock	3812.5	3812.5	3625.0	3687.5	30.0
2010-01-21	ABFS-DELISTED	Stock	26.86	27.48	26.35	26.4	689718.0
2010-01-21	ABG	Stock	13.0	13.14	12.53	12.6	244500.0
2010-01-21	ABII-DELISTED	Stock	41.58	42.67	41.26	41.5	36316.0
2010-01-21	ABK-DELISTED	Stock	0.77	0.79	0.7391	0.7456	8015738.0
2010-01-21	ABM	Stock	20.29	20.34	19.59	19.61	230800.0
2010-01-21	ABMD-DELISTED	Stock	8.47	8.57	8.36	8.5	196936.0
2010-01-21	ABR	Stock	2.45	2.45	2.35	2.39	96900.0
2010-01-21	ABT	Stock	26.9696	27.1087	26.389	26.6577	17317216.0
2010-01-21	ABTL-DELISTED	Stock	4.7515	5.0984	4.6986	4.9985	9646.0
2010-01-21	ABV-DELISTED	Stock	103.04	103.88	98.0	99.41	684348.0
2010-01-21	ABVT-DELISTED	Stock	62.7	64.13	62.23	62.91	123739.0
2010-01-21	ABX-DELISTED	Stock	37.75	37.78	36.35	36.54	21170363.0
2010-01-21	ACAD	Stock	1.39	1.39	1.33	1.38	338000.0
2010-01-21	ACAP-DELISTED	Stock	29.0	29.0	28.04	28.04	57303.0

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

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