PREVIEW / stock_daily / 2010-10-27

all stock daily files

  file:    by_date/stock_daily/2010/2010-10-27.parquet
  size:    193 KB
  rows:    6,004
  symbols: 3,524

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-10-27	AAPL	Stock	10.9875	11.0679	10.9143	10.9939	399002800.0
2010-10-27	MSFT	Stock	25.79	26.11	25.62	26.05	64805500.0
2010-10-27	NVDA	Stock	0.294	0.302	0.2932	0.301	496796000.0
2010-10-27	AMZN	Stock	8.4455	8.4875	8.327	8.3755	114436000.0
2010-10-27	TSLA	Stock	1.4167	1.4253	1.3767	1.4	5347500.0
2010-10-27	TLT	Stock	99.6801	100.17	99.22	99.22	9245390.0
2010-10-27	ES	Stock	30.84	31.06	30.64	31.04	1710200.0
2010-10-27	CL	Stock	37.96	38.06	37.585	37.75	5880600.0
2010-10-27	A	Stock	24.6638	24.8641	24.4421	24.7425	2316206.0
2010-10-27	AABA-DELISTED	Stock	16.41	16.43	16.2	16.43	13556765.0
2010-10-27	AACC-DELISTED	Stock	5.75	5.75	5.43	5.6	12957.0
2010-10-27	AACG	Stock	3.5	3.5	3.22	3.48	2100.0
2010-10-27	AAI-DELISTED	Stock	7.45	7.47	7.4	7.44	13733142.0
2010-10-27	AAIC-DELISTED	Stock	23.43	23.44	22.76	23.03	50472.0
2010-10-27	AAME	Stock	1.68	1.71	1.68	1.71	1100.0
2010-10-27	AAON	Stock	4.8217	4.8751	4.8119	4.8474	208575.0
2010-10-27	AAP	Stock	61.54	61.75	60.79	61.42	798000.0
2010-10-27	AATI-DELISTED	Stock	3.7	3.89	3.7	3.78	321658.0
2010-10-27	AAU-DELISTED	Stock	2.93	2.93	2.77	2.83	261863.0
2010-10-27	AAUAF-DELISTED	Stock	2.93	2.93	2.77	2.83	261964.0
2010-10-27	AAV-DELISTED	Stock	6.01	6.09	5.95	6.06	307458.0
2010-10-27	AAWW-DELISTED	Stock	54.85	55.4	53.9	55.26	183940.0
2010-10-27	AAXJ	Stock	61.92	61.95	61.26	61.81	542680.0
2010-10-27	AAXN-DELISTED	Stock	4.27	4.2848	3.99	4.13	932887.0
2010-10-27	AB	Stock	26.3	26.55	25.91	26.36	232100.0
2010-10-27	ABAC-DELISTED	Stock	5.91	5.91	5.61	5.79	42119.0
2010-10-27	ABAX-DELISTED	Stock	23.1	23.39	22.41	23.35	91465.0
2010-10-27	ABB-DELISTED	Stock	22.01	22.07	21.69	21.85	2406617.0
2010-10-27	ABBC-DELISTED	Stock	10.67	10.71	10.6	10.68	27258.0
2010-10-27	ABBNY-DELISTED	Stock	22.01	22.07	21.69	21.84	2519375.0
2010-10-27	ABC-DELISTED	Stock	32.95	33.44	32.63	33.24	4263111.0
2010-10-27	ABCB	Stock	9.39	9.53	9.21	9.26	161700.0
2010-10-27	ABCD-DELISTED	Stock	3.2	3.2	3.06	3.09	14064.0
2010-10-27	ABCO-DELISTED	Stock	23.84	23.84	23.22	23.51	67146.0
2010-10-27	ABCW-DELISTED	Stock	0.66	0.6697	0.66	0.66	17480.0
2010-10-27	ABD-DELISTED	Stock	5.82	6.35	5.82	6.26	1029800.0
2010-10-27	ABE-DELISTED	Stock	19.12	19.12	18.7044	18.8	21350.0
2010-10-27	ABEO	Stock	3787.5	3787.5	3700.0	3750.0	36.0
2010-10-27	ABFS-DELISTED	Stock	25.33	25.54	24.935	25.37	231638.0
2010-10-27	ABG	Stock	14.2	14.49	14.05	14.4	150200.0
2010-10-27	ABK-DELISTED	Stock	0.92	0.95	0.9052	0.94	6758501.0
2010-10-27	ABM	Stock	22.52	22.67	22.32	22.61	136500.0
2010-10-27	ABMD-DELISTED	Stock	10.61	10.65	10.5	10.54	108901.0
2010-10-27	ABR	Stock	5.28	5.34	5.15	5.26	60200.0
2010-10-27	ABT	Stock	25.1127	25.1127	24.4842	24.7769	20438933.0
2010-10-27	ABTL-DELISTED	Stock	4.0	4.125	3.9505	4.0	41680.0
2010-10-27	ABV-DELISTED	Stock	136.22	136.58	133.38	133.65	1144298.0
2010-10-27	ABVA-DELISTED	Stock	2.7	2.7	2.7	2.7	1000.0
2010-10-27	ABVT-DELISTED	Stock	55.79	55.89	54.53	55.72	110864.0
2010-10-27	ABX-DELISTED	Stock	45.98	46.06	44.98	45.61	10669161.0

> showing 50 of 6,004 rows — these rows as CSV

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