PREVIEW / stock_daily / 2010-07-29

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-29.parquet
  size:    189 KB
  rows:    5,914
  symbols: 3,471

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-07-29	AAPL	Stock	9.3111	9.3804	9.1464	9.2182	643806800.0
2010-07-29	MSFT	Stock	26.13	26.41	25.6	26.03	69446200.0
2010-07-29	NVDA	Stock	0.235	0.24	0.2268	0.2283	2664476000.0
2010-07-29	AMZN	Stock	5.8995	5.9435	5.776	5.843	123516000.0
2010-07-29	TSLA	Stock	1.3847	1.392	1.3333	1.3567	9240000.0
2010-07-29	TLT	Stock	98.1	99.02	97.92	98.94	6306476.0
2010-07-29	ES	Stock	28.61	28.66	27.94	28.05	1139800.0
2010-07-29	CL	Stock	39.5	39.81	38.33	39.06	32939000.0
2010-07-29	A	Stock	20.7225	20.8512	19.8712	20.1359	6163223.0
2010-07-29	AABA-DELISTED	Stock	13.93	13.96	13.75	13.75	16496639.0
2010-07-29	AACC-DELISTED	Stock	4.4001	4.52	4.18	4.35	11585.0
2010-07-29	AACG	Stock	3.01	3.01	3.01	3.01	600.0
2010-07-29	AAI-DELISTED	Stock	4.68	4.79	4.64	4.75	1997390.0
2010-07-29	AAIC-DELISTED	Stock	20.0	20.0399	19.14	19.75	69537.0
2010-07-29	AAME	Stock	1.28	1.3	1.28	1.28	2800.0
2010-07-29	AAON	Stock	4.96	5.0173	4.8178	4.9422	346781.0
2010-07-29	AAP	Stock	53.99	54.49	52.47	53.18	1108500.0
2010-07-29	AATI-DELISTED	Stock	3.28	3.31	3.15	3.22	299813.0
2010-07-29	AAU-DELISTED	Stock	0.9	0.92	0.9	0.92	35580.0
2010-07-29	AAUAF-DELISTED	Stock	0.9	0.92	0.9	0.92	36880.0
2010-07-29	AAV-DELISTED	Stock	6.39	6.49	6.31	6.31	395257.0
2010-07-29	AAWW-DELISTED	Stock	58.91	59.48	58.0	58.74	230135.0
2010-07-29	AAXJ	Stock	56.49	56.65	55.7	56.01	495442.0
2010-07-29	AAXN-DELISTED	Stock	4.13	4.14	3.9	3.91	901413.0
2010-07-29	AB	Stock	27.17	27.99	27.0	27.34	249100.0
2010-07-29	ABAC-DELISTED	Stock	4.18	4.19	3.95	4.03	68450.0
2010-07-29	ABAX-DELISTED	Stock	18.64	18.66	17.76	18.31	178750.0
2010-07-29	ABB-DELISTED	Stock	20.35	20.43	19.96	20.14	2870674.0
2010-07-29	ABBC-DELISTED	Stock	9.08	9.19	9.04	9.19	23221.0
2010-07-29	ABBNY-DELISTED	Stock	20.35	20.43	19.96	20.14	2898880.0
2010-07-29	ABC-DELISTED	Stock	29.31	29.59	28.63	28.98	6346447.0
2010-07-29	ABCB	Stock	9.31	9.41	9.13	9.29	79400.0
2010-07-29	ABCD-DELISTED	Stock	3.312	3.39	3.31	3.37	22036.0
2010-07-29	ABCO-DELISTED	Stock	21.31	22.05	20.8	21.91	200326.0
2010-07-29	ABCW-DELISTED	Stock	0.6418	0.6897	0.6322	0.68	44680.0
2010-07-29	ABD-DELISTED	Stock	5.62	6.06	5.54	5.96	351860.0
2010-07-29	ABE-DELISTED	Stock	17.1	17.14	16.9601	17.08	9413.0
2010-07-29	ABEO	Stock	2375.0	2437.5	2312.5	2437.5	41.0
2010-07-29	ABFS-DELISTED	Stock	22.82	22.95	22.25	22.58	254142.0
2010-07-29	ABG	Stock	13.59	13.76	12.99	13.28	412000.0
2010-07-29	ABII-DELISTED	Stock	74.98	75.22	74.7	74.93	286419.0
2010-07-29	ABK-DELISTED	Stock	0.9177	0.935	0.8335	0.88	18089022.0
2010-07-29	ABM	Stock	21.89	22.16	21.67	21.99	152700.0
2010-07-29	ABMD-DELISTED	Stock	11.54	11.73	11.22	11.25	397739.0
2010-07-29	ABR	Stock	6.04	6.07	5.81	6.0	64800.0
2010-07-29	ABT	Stock	23.7213	23.8796	23.4766	23.5006	18437682.0
2010-07-29	ABTL-DELISTED	Stock	5.1	5.304	5.049	5.1	3191.0
2010-07-29	ABV-DELISTED	Stock	110.68	110.68	107.84	109.3	457516.0
2010-07-29	ABVA-DELISTED	Stock	2.53	2.53	2.5	2.5	1503.0
2010-07-29	ABVT-DELISTED	Stock	52.87	53.22	52.4	52.58	117411.0

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

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