PREVIEW / stock_daily / 2013-08-09

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-09.parquet
  size:    212 KB
  rows:    6,377
  symbols: 3,531

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
2013-08-09	AAPL	Stock	16.38	16.445	16.2018	16.2304	266865200.0
2013-08-09	MSFT	Stock	32.77	32.9	32.47	32.7	26800700.0
2013-08-09	NVDA	Stock	0.353	0.3678	0.3528	0.3622	906224000.0
2013-08-09	AMZN	Stock	14.784	14.9635	14.715	14.863	39006000.0
2013-08-09	META	Stock	38.59	38.74	38.01	38.5	43532300.0
2013-08-09	TSLA	Stock	10.16	10.3967	10.0833	10.2	133915500.0
2013-08-09	TLT	Stock	106.6	107.265	106.48	107.26	3623454.0
2013-08-09	ES	Stock	44.21	44.29	43.69	43.77	1332600.0
2013-08-09	CL	Stock	60.83	61.05	60.47	60.68	1656000.0
2013-08-09	A	Stock	32.7969	33.2332	32.7682	33.0615	2737843.0
2013-08-09	AABA-DELISTED	Stock	27.41	27.695	27.2	27.67	12668801.0
2013-08-09	AACG	Stock	5.18	5.4	5.18	5.24	5600.0
2013-08-09	AAIC-DELISTED	Stock	23.95	24.24	23.83	24.14	101681.0
2013-08-09	AAME	Stock	3.85	3.88	3.85	3.88	1000.0
2013-08-09	AAMRQ-DELISTED	Stock	5.87	5.93	5.7	5.8	1949133.0
2013-08-09	AAON	Stock	10.6667	11.0222	10.5867	10.9156	321975.0
2013-08-09	AAP	Stock	81.34	83.24	81.06	83.17	1403600.0
2013-08-09	AAT	Stock	32.2	32.66	32.2	32.33	80500.0
2013-08-09	AAU-DELISTED	Stock	1.6301	1.7	1.63	1.66	49130.0
2013-08-09	AAUAF-DELISTED	Stock	1.6301	1.7	1.63	1.66	49330.0
2013-08-09	AAV-DELISTED	Stock	3.53	3.68	3.53	3.64	194829.0
2013-08-09	AAWW-DELISTED	Stock	42.41	43.22	42.21	43.18	372340.0
2013-08-09	AAXJ	Stock	55.8	55.99	55.71	55.73	179894.0
2013-08-09	AAXN-DELISTED	Stock	8.74	8.83	8.66	8.66	255903.0
2013-08-09	AB	Stock	22.15	22.2	21.29	21.93	241800.0
2013-08-09	ABAC-DELISTED	Stock	0.5801	0.608	0.57	0.608	13497.0
2013-08-09	ABAX-DELISTED	Stock	40.51	40.93	39.89	39.98	41848.0
2013-08-09	ABB-DELISTED	Stock	22.47	22.62	22.42	22.48	991712.0
2013-08-09	ABBNY-DELISTED	Stock	22.47	22.62	22.42	22.47	1001660.0
2013-08-09	ABBV	Stock	44.9	45.0	44.47	44.71	3290800.0
2013-08-09	ABC-DELISTED	Stock	59.46	59.75	59.24	59.5	1202474.0
2013-08-09	ABCB	Stock	19.27	19.27	18.83	18.87	104500.0
2013-08-09	ABCD-DELISTED	Stock	1.22	1.259	1.17	1.17	24019.0
2013-08-09	ABCO-DELISTED	Stock	58.6	58.6	57.27	57.77	98170.0
2013-08-09	ABCW-DELISTED	Stock	0.36	0.415	0.36	0.38	18317.0
2013-08-09	ABE-DELISTED	Stock	19.7	20.05	19.7	19.962	11403.0
2013-08-09	ABEO	Stock	537.5	550.0	462.5	550.0	10.0
2013-08-09	ABFS-DELISTED	Stock	20.0	23.735	20.0	22.88	1874189.0
2013-08-09	ABG	Stock	51.58	51.92	51.33	51.43	197100.0
2013-08-09	ABM	Stock	25.71	25.95	25.51	25.82	69000.0
2013-08-09	ABMD-DELISTED	Stock	22.32	22.43	22.08	22.28	194832.0
2013-08-09	ABR	Stock	7.49	7.56	7.37	7.55	103600.0
2013-08-09	ABR.A-DELISTED	Stock	25.24	25.25	25.2	25.2	1100.0
2013-08-09	ABR.B-DELISTED	Stock	24.16	24.2927	24.16	24.2927	2760.0
2013-08-09	ABT	Stock	35.8	36.04	35.75	35.89	5030400.0
2013-08-09	ABTL-DELISTED	Stock	6.2	6.2	5.8401	6.09	78430.0
2013-08-09	ABUS	Stock	5.59	5.66	5.48	5.57	24800.0
2013-08-09	ABV-DELISTED	Stock	37.68	37.86	37.45	37.52	1636758.0
2013-08-09	ABX-DELISTED	Stock	17.06	17.72	16.79	17.41	18337137.0
2013-08-09	ACAD	Stock	19.61	20.89	19.58	20.76	2409800.0

> showing 50 of 6,377 rows — these rows as CSV

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