PREVIEW / stock_daily / 2013-01-18

all stock daily files

  file:    by_date/stock_daily/2013/2013-01-18.parquet
  size:    202 KB
  rows:    6,185
  symbols: 3,461

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-01-18	AAPL	Stock	17.8043	17.9364	17.7286	17.8571	472922800.0
2013-01-18	MSFT	Stock	27.1	27.29	27.04	27.25	52167700.0
2013-01-18	NVDA	Stock	0.3062	0.3062	0.3005	0.3042	397088000.0
2013-01-18	AMZN	Stock	13.5415	13.725	13.48	13.606	58840000.0
2013-01-18	META	Stock	30.31	30.44	29.27	29.66	49631500.0
2013-01-18	TSLA	Stock	2.316	2.3187	2.2547	2.3013	53326500.0
2013-01-18	TLT	Stock	119.57	120.21	119.4601	120.04	4659908.0
2013-01-18	ES	Stock	38.8	39.24	38.8	39.21	2840200.0
2013-01-18	CL	Stock	54.38	54.505	54.115	54.505	2743200.0
2013-01-18	A	Stock	31.5093	31.588	31.1803	31.5808	3335069.0
2013-01-18	AABA-DELISTED	Stock	20.07	20.17	19.97	20.01	13450705.0
2013-01-18	AACC-DELISTED	Stock	4.79	4.9	4.75	4.85	18863.0
2013-01-18	AACG	Stock	5.69	5.69	5.69	5.69	100.0
2013-01-18	AAIC-DELISTED	Stock	22.83	22.94	22.65	22.79	126658.0
2013-01-18	AAMC-DELISTED	Stock	30.2941	34.6324	30.0	34.4118	186300.0
2013-01-18	AAME	Stock	3.3	3.3	3.28	3.28	2200.0
2013-01-18	AAMRQ-DELISTED	Stock	1.47	1.49	1.16	1.32	19418222.0
2013-01-18	AAON	Stock	6.563	6.7022	6.5481	6.6756	214988.0
2013-01-18	AAP	Stock	73.43	73.78	73.25	73.75	266400.0
2013-01-18	AAT	Stock	28.68	28.68	28.32	28.43	175600.0
2013-01-18	AAU-DELISTED	Stock	3.23	3.24	3.12	3.15	169635.0
2013-01-18	AAUAF-DELISTED	Stock	3.23	3.24	3.12	3.15	169835.0
2013-01-18	AAV-DELISTED	Stock	3.25	3.28	3.21	3.22	81661.0
2013-01-18	AAWW-DELISTED	Stock	46.11	46.65	45.41	46.16	309117.0
2013-01-18	AAXJ	Stock	61.13	61.19	60.89	61.06	1025244.0
2013-01-18	AAXN-DELISTED	Stock	9.45	9.5	9.16	9.31	630031.0
2013-01-18	AB	Stock	20.0	20.04	19.94	20.04	316700.0
2013-01-18	ABAC-DELISTED	Stock	0.8901	0.8901	0.8901	0.8901	101.0
2013-01-18	ABAX-DELISTED	Stock	38.68	39.15	38.68	39.13	72617.0
2013-01-18	ABB-DELISTED	Stock	20.99	21.17	20.98	21.13	1574809.0
2013-01-18	ABBNY-DELISTED	Stock	20.99	21.17	20.98	21.14	1844425.0
2013-01-18	ABBV	Stock	36.43	37.32	36.04	37.32	17842200.0
2013-01-18	ABC-DELISTED	Stock	45.47	45.85	45.28	45.84	1803366.0
2013-01-18	ABCB	Stock	12.86	13.0	12.74	12.98	37300.0
2013-01-18	ABCD-DELISTED	Stock	1.21	1.28	1.209	1.2725	20832.0
2013-01-18	ABCO-DELISTED	Stock	52.21	52.83	51.5	52.8	155241.0
2013-01-18	ABCW-DELISTED	Stock	0.729	0.85	0.64	0.64	183176.0
2013-01-18	ABE-DELISTED	Stock	22.03	22.42	22.0	22.39	5138.0
2013-01-18	ABEO	Stock	350.0	425.0	350.0	425.0	31.0
2013-01-18	ABFS-DELISTED	Stock	10.4	10.48	10.15	10.27	178729.0
2013-01-18	ABG	Stock	33.5	34.04	33.15	33.94	181600.0
2013-01-18	ABM	Stock	20.75	21.05	20.75	20.97	230100.0
2013-01-18	ABMD-DELISTED	Stock	12.83	12.84	12.22	12.48	873635.0
2013-01-18	ABR	Stock	7.21	7.24	7.11	7.16	249700.0
2013-01-18	ABT	Stock	32.8	32.87	32.61	32.74	14984300.0
2013-01-18	ABTL-DELISTED	Stock	3.99	4.0199	3.9651	4.0199	9348.0
2013-01-18	ABUS	Stock	5.14	5.21	4.81	5.0	57900.0
2013-01-18	ABV-DELISTED	Stock	44.78	45.06	44.66	45.05	2498114.0
2013-01-18	ABX-DELISTED	Stock	34.16	34.21	33.95	34.05	5360680.0
2013-01-18	ACAD	Stock	5.36	5.41	5.13	5.22	1057500.0

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

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