PREVIEW / stock_daily / 2010-08-23

all stock daily files

  file:    by_date/stock_daily/2010/2010-08-23.parquet
  size:    189 KB
  rows:    5,943
  symbols: 3,484

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-08-23	AAPL	Stock	8.9925	9.0	8.7589	8.7786	414041600.0
2010-08-23	MSFT	Stock	24.44	24.64	24.24	24.28	51643000.0
2010-08-23	NVDA	Stock	0.25	0.2563	0.2448	0.2455	748620000.0
2010-08-23	AMZN	Stock	6.393	6.461	6.325	6.33	77226000.0
2010-08-23	TSLA	Stock	1.2727	1.3593	1.2667	1.342	16321500.0
2010-08-23	TLT	Stock	105.65	106.19	105.25	106.06	6360209.0
2010-08-23	ES	Stock	28.71	28.92	28.58	28.65	640800.0
2010-08-23	CL	Stock	38.09	38.29	37.72	37.76	4743600.0
2010-08-23	A	Stock	20.5579	20.5937	19.9714	20.0	4365674.0
2010-08-23	AABA-DELISTED	Stock	13.81	13.87	13.54	13.64	12198627.0
2010-08-23	AACC-DELISTED	Stock	4.17	4.17	3.97	4.0	24362.0
2010-08-23	AACG	Stock	2.9	3.05	2.9	2.9	26400.0
2010-08-23	AAI-DELISTED	Stock	4.65	4.77	4.59	4.59	1166727.0
2010-08-23	AAIC-DELISTED	Stock	20.11	20.33	19.54	19.58	55515.0
2010-08-23	AAME	Stock	1.22	1.27	1.2	1.2	6800.0
2010-08-23	AAON	Stock	4.3022	4.3022	4.162	4.164	153394.0
2010-08-23	AAP	Stock	55.9	56.21	54.74	54.75	1312600.0
2010-08-23	AATI-DELISTED	Stock	3.3	3.57	3.3	3.5	237171.0
2010-08-23	AAU-DELISTED	Stock	2.08	2.35	1.9957	2.34	1548361.0
2010-08-23	AAUAF-DELISTED	Stock	2.05	2.34	1.9701	2.34	1572376.0
2010-08-23	AAV-DELISTED	Stock	5.87	5.89	5.78	5.79	198733.0
2010-08-23	AAWW-DELISTED	Stock	45.1	46.62	44.76	45.3	279583.0
2010-08-23	AAXJ	Stock	55.65	55.73	55.1	55.1	47773.0
2010-08-23	AAXN-DELISTED	Stock	3.87	3.93	3.82	3.86	356878.0
2010-08-23	AB	Stock	24.97	25.26	24.87	25.05	246900.0
2010-08-23	ABAC-DELISTED	Stock	3.9	4.0	3.82	3.85	23930.0
2010-08-23	ABAX-DELISTED	Stock	18.96	19.27	18.69	18.85	82304.0
2010-08-23	ABB-DELISTED	Stock	19.17	19.31	18.99	19.03	1769615.0
2010-08-23	ABBC-DELISTED	Stock	9.86	10.15	9.82	10.0	132932.0
2010-08-23	ABBNY-DELISTED	Stock	19.17	19.31	18.99	19.02	1825126.0
2010-08-23	ABC-DELISTED	Stock	29.0	29.23	28.52	28.56	2899139.0
2010-08-23	ABCB	Stock	8.19	8.24	8.02	8.15	82400.0
2010-08-23	ABCD-DELISTED	Stock	3.02	3.06	2.9	2.9	30520.0
2010-08-23	ABCO-DELISTED	Stock	21.25	21.91	20.71	20.72	77382.0
2010-08-23	ABCW-DELISTED	Stock	0.66	0.66	0.63	0.63	14040.0
2010-08-23	ABD-DELISTED	Stock	5.94	6.05	5.76	5.77	400860.0
2010-08-23	ABE-DELISTED	Stock	17.19	17.32	17.19	17.213	6657.0
2010-08-23	ABEO	Stock	2625.0	2750.0	2625.0	2687.5	17.0
2010-08-23	ABFS-DELISTED	Stock	20.0	20.31	19.59	19.62	191484.0
2010-08-23	ABG	Stock	12.85	13.01	12.12	12.17	144800.0
2010-08-23	ABII-DELISTED	Stock	74.44	74.9785	74.4	74.68	81193.0
2010-08-23	ABK-DELISTED	Stock	0.5	0.51	0.4502	0.486	13318952.0
2010-08-23	ABM	Stock	19.59	19.64	19.08	19.08	206000.0
2010-08-23	ABMD-DELISTED	Stock	9.18	9.36	8.84	8.87	145700.0
2010-08-23	ABR	Stock	4.96	4.99	4.88	4.9	38600.0
2010-08-23	ABT	Stock	23.7741	24.0764	23.7741	23.8844	15039600.0
2010-08-23	ABTL-DELISTED	Stock	4.4049	4.4948	4.2451	4.2951	8155.0
2010-08-23	ABV-DELISTED	Stock	110.43	111.28	108.31	109.02	918337.0
2010-08-23	ABVA-DELISTED	Stock	2.95	2.95	2.9	2.9	1250.0
2010-08-23	ABVT-DELISTED	Stock	51.4	51.49	49.05	49.12	105787.0

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

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