PREVIEW / stock_daily / 2010-09-20

all stock daily files

  file:    by_date/stock_daily/2010/2010-09-20.parquet
  size:    192 KB
  rows:    5,992
  symbols: 3,525

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-09-20	AAPL	Stock	9.86	10.135	9.8518	10.1154	658677600.0
2010-09-20	MSFT	Stock	25.28	25.52	25.11	25.43	49838700.0
2010-09-20	NVDA	Stock	0.2638	0.2688	0.2612	0.2678	443168000.0
2010-09-20	AMZN	Stock	7.435	7.5975	7.3675	7.565	128988000.0
2010-09-20	TSLA	Stock	1.378	1.4233	1.344	1.404	14212500.0
2010-09-20	TLT	Stock	102.15	102.45	101.6899	102.26	5277734.0
2010-09-20	ES	Stock	29.24	29.53	29.13	29.48	1160300.0
2010-09-20	CL	Stock	38.59	39.225	38.575	39.125	6515400.0
2010-09-20	A	Stock	22.0172	22.2747	21.867	22.196	5145479.0
2010-09-20	AABA-DELISTED	Stock	13.98	14.06	13.84	13.86	26403559.0
2010-09-20	AACC-DELISTED	Stock	3.69	4.21	3.65	4.11	48108.0
2010-09-20	AACG	Stock	2.86	3.0	2.85	2.85	10800.0
2010-09-20	AAI-DELISTED	Stock	4.4	4.48	4.34	4.47	1927224.0
2010-09-20	AAIC-DELISTED	Stock	21.88	22.95	21.235	22.88	59504.0
2010-09-20	AAME	Stock	1.58	1.92	1.58	1.88	43100.0
2010-09-20	AAON	Stock	4.6558	4.804	4.6499	4.796	252112.0
2010-09-20	AAP	Stock	58.35	59.7	58.26	59.16	1230400.0
2010-09-20	AATI-DELISTED	Stock	3.41	3.48	3.3799	3.47	148665.0
2010-09-20	AAU-DELISTED	Stock	2.71	2.74	2.6	2.66	337801.0
2010-09-20	AAUAF-DELISTED	Stock	2.66	2.69	2.58	2.66	343505.0
2010-09-20	AAV-DELISTED	Stock	6.28	6.34	6.22	6.27	333740.0
2010-09-20	AAWW-DELISTED	Stock	48.52	49.67	48.25	49.5	283921.0
2010-09-20	AAXJ	Stock	58.83	59.3	58.7	59.18	188482.0
2010-09-20	AAXN-DELISTED	Stock	3.9	4.01	3.86	4.0	468150.0
2010-09-20	AB	Stock	25.67	26.5	25.64	26.36	273400.0
2010-09-20	ABAC-DELISTED	Stock	3.97	3.97	3.97	3.97	100.0
2010-09-20	ABAX-DELISTED	Stock	20.85	22.25	20.65	21.85	158593.0
2010-09-20	ABB-DELISTED	Stock	20.5	20.86	20.43	20.85	2387878.0
2010-09-20	ABBC-DELISTED	Stock	10.4	10.5	10.4	10.5	50489.0
2010-09-20	ABBNY-DELISTED	Stock	20.5	20.86	20.43	20.82	2399854.0
2010-09-20	ABC-DELISTED	Stock	30.2	30.69	30.14	30.63	2026678.0
2010-09-20	ABCB	Stock	8.65	8.99	8.55	8.96	64500.0
2010-09-20	ABCD-DELISTED	Stock	3.18	3.32	3.16	3.3	47977.0
2010-09-20	ABCO-DELISTED	Stock	21.22	21.75	21.01	21.71	125372.0
2010-09-20	ABCW-DELISTED	Stock	0.7	0.73	0.68	0.68	146480.0
2010-09-20	ABD-DELISTED	Stock	6.05	6.3525	5.93	6.3	1325270.0
2010-09-20	ABE-DELISTED	Stock	17.67	17.94	17.63	17.93	16275.0
2010-09-20	ABEO	Stock	2737.5	2800.0	2562.5	2700.0	52.0
2010-09-20	ABFS-DELISTED	Stock	23.66	24.53	23.45	24.35	394031.0
2010-09-20	ABG	Stock	12.35	13.05	12.06	13.0	217700.0
2010-09-20	ABII-DELISTED	Stock	74.95	75.76	74.95	75.69	53991.0
2010-09-20	ABK-DELISTED	Stock	0.5635	0.5778	0.5518	0.564	2959232.0
2010-09-20	ABM	Stock	21.58	21.94	21.33	21.92	356000.0
2010-09-20	ABMD-DELISTED	Stock	10.0	10.85	9.83	10.79	321586.0
2010-09-20	ABR	Stock	4.81	5.12	4.81	5.11	70500.0
2010-09-20	ABT	Stock	24.7577	25.1367	24.7241	25.0743	11174031.0
2010-09-20	ABTL-DELISTED	Stock	4.2933	4.6	4.2714	4.6	35628.0
2010-09-20	ABV-DELISTED	Stock	120.72	122.49	119.92	121.3	421108.0
2010-09-20	ABVA-DELISTED	Stock	3.15	3.15	3.1	3.1	200.0
2010-09-20	ABVT-DELISTED	Stock	52.07	52.59	52.07	52.48	171888.0

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

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