PREVIEW / stock_daily / 2010-01-28

all stock daily files

  file:    by_date/stock_daily/2010/2010-01-28.parquet
  size:    188 KB
  rows:    5,878
  symbols: 3,470

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-28	AAPL	Stock	7.3189	7.3393	7.0964	7.1175	1173502400.0
2010-01-28	MSFT	Stock	29.84	29.87	28.89	29.16	117513700.0
2010-01-28	NVDA	Stock	0.4195	0.421	0.3965	0.4022	687764000.0
2010-01-28	AMZN	Stock	6.2215	6.36	6.14	6.3015	545862000.0
2010-01-28	TLT	Stock	91.13	91.7	91.06	91.51	3058736.0
2010-01-28	ES	Stock	25.61	25.68	25.3	25.46	1336300.0
2010-01-28	CL	Stock	40.355	40.865	39.835	39.995	8153400.0
2010-01-28	A	Stock	20.8369	21.0086	20.3791	20.5222	4937177.0
2010-01-28	AABA-DELISTED	Stock	15.93	15.98	15.44	15.45	29182550.0
2010-01-28	AACC-DELISTED	Stock	6.04	6.15	5.9	5.92	22748.0
2010-01-28	AACG	Stock	3.91	3.91	3.67	3.67	10700.0
2010-01-28	AAI-DELISTED	Stock	5.35	5.37	5.02	5.12	7332346.0
2010-01-28	AAIC-DELISTED	Stock	14.96	15.505	14.88	15.25	17732.0
2010-01-28	AAME	Stock	1.36	1.4	1.36	1.4	400.0
2010-01-28	AAON	Stock	4.1481	4.1481	4.0435	4.1007	490050.0
2010-01-28	AAP	Stock	40.5	40.5	39.67	39.77	1206000.0
2010-01-28	AATI-DELISTED	Stock	3.56	3.56	3.35	3.39	237875.0
2010-01-28	AAU-DELISTED	Stock	0.9	0.92	0.85	0.88	265365.0
2010-01-28	AAUAF-DELISTED	Stock	0.9	0.92	0.85	0.88	273605.0
2010-01-28	AAV-DELISTED	Stock	6.34	6.44	6.3	6.33	621305.0
2010-01-28	AAWW-DELISTED	Stock	37.43	37.6	35.67	36.48	245610.0
2010-01-28	AAXJ	Stock	53.46	53.46	52.069	52.49	205468.0
2010-01-28	AAXN-DELISTED	Stock	5.96	5.96	5.8	5.9	565765.0
2010-01-28	AB	Stock	27.41	27.41	26.06	27.01	569200.0
2010-01-28	ABAX-DELISTED	Stock	23.66	23.66	22.375	22.54	275145.0
2010-01-28	ABB-DELISTED	Stock	18.61	18.63	18.1	18.2	6986785.0
2010-01-28	ABBC-DELISTED	Stock	7.25	7.25	7.03	7.03	34733.0
2010-01-28	ABBNY-DELISTED	Stock	18.61	18.63	18.1	18.19	6988585.0
2010-01-28	ABC-DELISTED	Stock	27.24	27.76	27.24	27.29	3350092.0
2010-01-28	ABCB	Stock	9.3334	9.3631	8.7803	9.0964	91732.0
2010-01-28	ABCD-DELISTED	Stock	3.95	4.0	3.95	3.99	1000.0
2010-01-28	ABCO-DELISTED	Stock	16.267	16.327	15.993	16.203	128583.0
2010-01-28	ABCW-DELISTED	Stock	1.3	1.3	1.25	1.25	114140.0
2010-01-28	ABD-DELISTED	Stock	8.02	8.02	7.56	7.75	564840.0
2010-01-28	ABE-DELISTED	Stock	16.08	16.13	15.89	15.99	13115.0
2010-01-28	ABEO	Stock	3475.0	3562.5	3250.0	3562.5	14.0
2010-01-28	ABFS-DELISTED	Stock	24.13	25.01	23.13	23.56	1873470.0
2010-01-28	ABG	Stock	11.84	11.91	11.05	11.24	258500.0
2010-01-28	ABII-DELISTED	Stock	41.58	41.58	40.72	41.0	299028.0
2010-01-28	ABK-DELISTED	Stock	0.7289	0.7289	0.68	0.7	4244407.0
2010-01-28	ABM	Stock	19.63	19.64	19.31	19.51	138900.0
2010-01-28	ABMD-DELISTED	Stock	8.28	8.4955	7.95	8.18	305047.0
2010-01-28	ABR	Stock	2.06	2.09	1.97	2.01	118800.0
2010-01-28	ABT	Stock	25.9572	26.1251	25.7365	25.8852	13856398.0
2010-01-28	ABTL-DELISTED	Stock	5.0909	5.8545	5.041	5.6	29516.0
2010-01-28	ABV-DELISTED	Stock	96.38	96.42	95.1	95.54	456269.0
2010-01-28	ABVT-DELISTED	Stock	62.05	63.45	60.415	60.75	85973.0
2010-01-28	ABX-DELISTED	Stock	36.28	36.32	34.84	35.89	15216460.0
2010-01-28	ACAD	Stock	1.24	1.3	1.21	1.3	572900.0
2010-01-28	ACAP-DELISTED	Stock	28.55	28.74	28.02	28.25	29657.0

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

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