PREVIEW / stock_daily / 2010-08-19

all stock daily files

  file:    by_date/stock_daily/2010/2010-08-19.parquet
  size:    189 KB
  rows:    5,964
  symbols: 3,499

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-19	AAPL	Stock	9.03	9.0529	8.8814	8.9243	426706000.0
2010-08-19	MSFT	Stock	24.62	24.74	24.21	24.44	54064600.0
2010-08-19	NVDA	Stock	0.2355	0.2478	0.2342	0.247	1615100000.0
2010-08-19	AMZN	Stock	6.461	6.501	6.341	6.3785	111650000.0
2010-08-19	TSLA	Stock	1.236	1.2833	1.222	1.2527	8686500.0
2010-08-19	TLT	Stock	104.79	106.61	104.64	106.16	13128468.0
2010-08-19	ES	Stock	28.84	28.87	28.29	28.6	1307700.0
2010-08-19	CL	Stock	38.325	38.465	38.065	38.375	5859000.0
2010-08-19	A	Stock	20.9227	20.9299	20.186	20.4149	4729853.0
2010-08-19	AABA-DELISTED	Stock	13.88	14.0	13.8	13.85	14067529.0
2010-08-19	AACC-DELISTED	Stock	4.05	4.17	3.9	4.03	336582.0
2010-08-19	AACG	Stock	2.9	2.98	2.89	2.98	8300.0
2010-08-19	AAI-DELISTED	Stock	4.76	4.79	4.61	4.69	1738814.0
2010-08-19	AAIC-DELISTED	Stock	20.39	20.39	19.53	20.01	74530.0
2010-08-19	AAME	Stock	1.25	1.25	1.2	1.25	6100.0
2010-08-19	AAON	Stock	4.4207	4.4247	4.2469	4.2627	262744.0
2010-08-19	AAP	Stock	55.08	55.52	54.75	55.28	1166700.0
2010-08-19	AATI-DELISTED	Stock	3.26	3.32	3.16	3.28	229706.0
2010-08-19	AAU-DELISTED	Stock	1.69	1.8399	1.65	1.8198	344156.0
2010-08-19	AAUAF-DELISTED	Stock	1.69	1.8399	1.65	1.8198	353256.0
2010-08-19	AAV-DELISTED	Stock	6.03	6.12	5.93	5.95	229498.0
2010-08-19	AAWW-DELISTED	Stock	47.79	48.27	45.58	45.62	331266.0
2010-08-19	AAXJ	Stock	56.04	56.05	55.33	55.57	212432.0
2010-08-19	AAXN-DELISTED	Stock	4.0	4.02	3.82	3.82	452786.0
2010-08-19	AB	Stock	25.74	25.74	25.16	25.19	317800.0
2010-08-19	ABAC-DELISTED	Stock	4.28	4.28	4.0	4.0	17837.0
2010-08-19	ABAX-DELISTED	Stock	19.74	20.02	19.09	19.41	100555.0
2010-08-19	ABB-DELISTED	Stock	19.95	19.98	19.4	19.57	2021561.0
2010-08-19	ABBC-DELISTED	Stock	9.6	9.62	9.52	9.54	64171.0
2010-08-19	ABBNY-DELISTED	Stock	19.94	19.98	19.4	19.56	2205002.0
2010-08-19	ABC-DELISTED	Stock	29.3	29.41	28.75	29.16	2632953.0
2010-08-19	ABCB	Stock	8.45	8.59	8.13	8.15	112700.0
2010-08-19	ABCD-DELISTED	Stock	3.11	3.12	2.93	2.96	49954.0
2010-08-19	ABCO-DELISTED	Stock	21.89	22.0	21.23	21.23	198834.0
2010-08-19	ABCW-DELISTED	Stock	0.6186	0.6285	0.6186	0.6214	51700.0
2010-08-19	ABD-DELISTED	Stock	6.37	6.41	6.05	6.08	422020.0
2010-08-19	ABE-DELISTED	Stock	17.28	17.46	17.28	17.35	12049.0
2010-08-19	ABEO	Stock	2300.0	2500.0	2300.0	2500.0	12.0
2010-08-19	ABFS-DELISTED	Stock	20.25	20.43	19.5	19.5	277831.0
2010-08-19	ABG	Stock	13.27	13.42	12.68	12.72	164300.0
2010-08-19	ABII-DELISTED	Stock	74.92	74.94	74.31	74.62	115502.0
2010-08-19	ABK-DELISTED	Stock	0.553	0.56	0.48	0.5261	21131038.0
2010-08-19	ABM	Stock	20.37	20.47	19.36	19.52	502900.0
2010-08-19	ABMD-DELISTED	Stock	9.71	9.88	9.22	9.22	165640.0
2010-08-19	ABR	Stock	4.94	5.08	4.76	4.84	119400.0
2010-08-19	ABT	Stock	24.0668	24.0908	23.5294	23.6637	21298041.0
2010-08-19	ABTL-DELISTED	Stock	4.7604	4.7604	4.2097	4.35	9764.0
2010-08-19	ABV-DELISTED	Stock	109.15	111.11	108.95	110.8	1078411.0
2010-08-19	ABVA-DELISTED	Stock	3.14	3.15	2.93	3.0	3404.0
2010-08-19	ABVT-DELISTED	Stock	51.88	52.03	51.155	51.33	106977.0

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

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