PREVIEW / stock_daily / 2010-06-14

all stock daily files

  file:    by_date/stock_daily/2010/2010-06-14.parquet
  size:    189 KB
  rows:    5,934
  symbols: 3,497

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-06-14	AAPL	Stock	9.1414	9.2554	9.0718	9.0814	602960400.0
2010-06-14	MSFT	Stock	25.86	25.96	25.47	25.5	50972400.0
2010-06-14	NVDA	Stock	0.2945	0.295	0.2832	0.284	375080000.0
2010-06-14	AMZN	Stock	6.212	6.285	6.175	6.1915	78460000.0
2010-06-14	TLT	Stock	96.32	97.04	96.22	96.91	5310307.0
2010-06-14	ES	Stock	26.12	26.28	25.93	26.08	2025400.0
2010-06-14	CL	Stock	39.635	39.95	39.635	39.66	3712200.0
2010-06-14	A	Stock	22.2747	22.8898	22.1459	22.5036	5820992.0
2010-06-14	AABA-DELISTED	Stock	15.44	15.49	15.15	15.17	12212824.0
2010-06-14	AACC-DELISTED	Stock	4.72	5.04	4.57	4.67	158037.0
2010-06-14	AACG	Stock	3.5	3.6	3.5	3.6	200.0
2010-06-14	AAI-DELISTED	Stock	5.97	6.0	5.76	5.79	4224463.0
2010-06-14	AAIC-DELISTED	Stock	19.5	19.9	19.27	19.85	27195.0
2010-06-14	AAON	Stock	4.8138	4.8672	4.7249	4.7546	373106.0
2010-06-14	AAP	Stock	50.85	51.35	50.76	50.8	844200.0
2010-06-14	AATI-DELISTED	Stock	3.59	3.67	3.57	3.63	180460.0
2010-06-14	AAU-DELISTED	Stock	0.94	0.96	0.92	0.93	60561.0
2010-06-14	AAUAF-DELISTED	Stock	0.94	0.96	0.92	0.93	60761.0
2010-06-14	AAV-DELISTED	Stock	6.41	6.45	6.29	6.35	346187.0
2010-06-14	AAWW-DELISTED	Stock	52.21	53.94	51.52	52.21	238142.0
2010-06-14	AAXJ	Stock	53.29	53.8799	53.05	53.09	406184.0
2010-06-14	AAXN-DELISTED	Stock	4.18	4.27	4.18	4.2	395466.0
2010-06-14	AB	Stock	28.79	28.96	28.31	28.53	271500.0
2010-06-14	ABAX-DELISTED	Stock	23.85	24.17	23.09	23.11	123301.0
2010-06-14	ABB-DELISTED	Stock	18.17	18.35	18.0	18.0	3865451.0
2010-06-14	ABBC-DELISTED	Stock	8.95	8.98	8.77	8.78	52440.0
2010-06-14	ABBNY-DELISTED	Stock	18.17	18.35	18.0	18.01	3868301.0
2010-06-14	ABC-DELISTED	Stock	31.97	32.46	31.97	32.24	3509766.0
2010-06-14	ABCB	Stock	10.8185	10.918	10.2611	10.3507	85103.0
2010-06-14	ABCD-DELISTED	Stock	4.5	4.55	4.34	4.39	48853.0
2010-06-14	ABCO-DELISTED	Stock	19.71	19.925	19.515	19.755	192462.0
2010-06-14	ABCW-DELISTED	Stock	0.7495	0.7994	0.6996	0.7005	40820.0
2010-06-14	ABD-DELISTED	Stock	5.53	5.66	5.37	5.4	417050.0
2010-06-14	ABE-DELISTED	Stock	15.8	16.04	15.79	15.79	32215.0
2010-06-14	ABEO	Stock	3062.5	3075.0	2937.5	3075.0	13.0
2010-06-14	ABFS-DELISTED	Stock	22.5	22.68	22.14	22.2	316279.0
2010-06-14	ABG	Stock	12.9	13.15	12.64	12.9	308300.0
2010-06-14	ABII-DELISTED	Stock	59.76	61.41	59.76	60.89	105112.0
2010-06-14	ABK-DELISTED	Stock	0.67	0.99	0.63	0.8231	57087468.0
2010-06-14	ABM	Stock	21.35	21.61	21.26	21.4	331600.0
2010-06-14	ABMD-DELISTED	Stock	9.57	9.73	9.4	9.42	105519.0
2010-06-14	ABR	Stock	4.59	4.66	4.44	4.62	212900.0
2010-06-14	ABT	Stock	22.7617	22.8625	22.6849	22.7089	14164235.0
2010-06-14	ABTL-DELISTED	Stock	6.306	6.306	5.8991	5.95	16283.0
2010-06-14	ABV-DELISTED	Stock	101.4	102.0	100.37	101.12	472322.0
2010-06-14	ABVA-DELISTED	Stock	2.65	2.6501	2.65	2.6501	860.0
2010-06-14	ABVT-DELISTED	Stock	45.51	46.77	45.47	46.53	159301.0
2010-06-14	ABX-DELISTED	Stock	42.91	43.0	41.84	42.0	10272042.0
2010-06-14	ACAD	Stock	1.3	1.3	1.23	1.27	185800.0
2010-06-14	ACAP-DELISTED	Stock	31.25	31.59	30.92	31.0	58711.0

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

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