PREVIEW / stock_30min / 2012-07-20

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-20.parquet
  size:    1.4 MB
  rows:    73,717
  symbols: 3,463

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2012-07-20 05:30:00	AAPL	Stock	21.9646	21.9646	21.9643	21.9643	8400.0
2012-07-20 06:00:00	AAPL	Stock	21.9643	21.9871	21.9643	21.9871	8400.0
2012-07-20 06:30:00	AAPL	Stock	21.9821	21.9821	21.9646	21.9646	16800.0
2012-07-20 07:00:00	AAPL	Stock	21.9646	21.9782	21.9307	21.9321	93884.0
2012-07-20 07:30:00	AAPL	Stock	21.9482	21.9482	21.8214	21.8571	408268.0
2012-07-20 08:00:00	AAPL	Stock	21.8739	21.9643	21.8507	21.9071	1145396.0
2012-07-20 08:30:00	AAPL	Stock	21.9107	21.9164	21.8754	21.8829	785512.0
2012-07-20 09:00:00	AAPL	Stock	21.8857	21.9625	21.8839	21.8982	3643836.0
2012-07-20 09:30:00	AAPL	Stock	21.8982	21.9443	21.8432	21.8957	67002488.0
2012-07-20 10:00:00	AAPL	Stock	21.8904	21.9104	21.8089	21.8539	35500668.0
2012-07-20 10:30:00	AAPL	Stock	21.8568	21.8607	21.8004	21.8471	21942480.0
2012-07-20 11:00:00	AAPL	Stock	21.8457	21.8507	21.8071	21.8204	18977112.0
2012-07-20 11:30:00	AAPL	Stock	21.82	21.8221	21.7214	21.7271	28171304.0
2012-07-20 12:00:00	AAPL	Stock	21.7225	21.7232	21.6518	21.6607	27813492.0
2012-07-20 12:30:00	AAPL	Stock	21.6575	21.725	21.6504	21.7196	22209824.0
2012-07-20 13:00:00	AAPL	Stock	21.72	21.7343	21.6611	21.6764	16385012.0
2012-07-20 13:30:00	AAPL	Stock	21.6761	21.7107	21.669	21.6839	9524732.0
2012-07-20 14:00:00	AAPL	Stock	21.683	21.7186	21.675	21.7036	10502520.0
2012-07-20 14:30:00	AAPL	Stock	21.7011	21.705	21.6807	21.6889	8569792.0
2012-07-20 15:00:00	AAPL	Stock	21.687	21.7071	21.6293	21.6339	23812880.0
2012-07-20 15:30:00	AAPL	Stock	21.6339	21.6375	21.5643	21.5643	61978224.0
2012-07-20 16:00:00	AAPL	Stock	21.5607	21.7531	21.5564	21.5643	16822680.0
2012-07-20 16:30:00	AAPL	Stock	21.5646	21.6315	21.5507	21.5782	1509368.0
2012-07-20 17:00:00	AAPL	Stock	21.5768	21.5804	21.5714	21.5746	278684.0
2012-07-20 17:30:00	AAPL	Stock	21.575	21.5775	21.5714	21.5775	79604.0
2012-07-20 18:00:00	AAPL	Stock	21.5768	21.5768	21.5625	21.5704	117908.0
2012-07-20 18:30:00	AAPL	Stock	21.5743	21.575	21.5689	21.5732	83524.0
2012-07-20 19:00:00	AAPL	Stock	21.5743	21.5757	21.5696	21.5714	103348.0
2012-07-20 19:30:00	AAPL	Stock	21.5714	21.5743	21.5696	21.5743	168280.0
2012-07-20 04:30:00	MSFT	Stock	31.22	31.22	31.22	31.22	4200.0
2012-07-20 05:00:00	MSFT	Stock	31.22	31.22	31.22	31.22	500.0
2012-07-20 06:00:00	MSFT	Stock	31.22	31.22	31.22	31.22	262.0
2012-07-20 07:00:00	MSFT	Stock	31.2	31.25	31.1	31.15	5747.0
2012-07-20 07:30:00	MSFT	Stock	31.18	31.2	31.09	31.16	21220.0
2012-07-20 08:00:00	MSFT	Stock	31.16	31.29	31.05	31.08	140969.0
2012-07-20 08:30:00	MSFT	Stock	31.08	31.11	30.665	30.99	241668.0
2012-07-20 09:00:00	MSFT	Stock	30.99	31.12	30.99	31.0	531488.0
2012-07-20 09:30:00	MSFT	Stock	31.01	31.05	30.54	30.793	16571114.0
2012-07-20 10:00:00	MSFT	Stock	30.795	30.84	30.51	30.555	5413701.0
2012-07-20 10:30:00	MSFT	Stock	30.565	30.58	30.14	30.345	6931618.0
2012-07-20 11:00:00	MSFT	Stock	30.348	30.51	30.28	30.384	3461383.0
2012-07-20 11:30:00	MSFT	Stock	30.385	30.4	30.31	30.35	2107005.0
2012-07-20 12:00:00	MSFT	Stock	30.35	30.35	30.22	30.25	1876688.0
2012-07-20 12:30:00	MSFT	Stock	30.24	30.36	30.2	30.35	2066265.0
2012-07-20 13:00:00	MSFT	Stock	30.34	30.36	30.2	30.24	1948260.0
2012-07-20 13:30:00	MSFT	Stock	30.24	30.28	30.2	30.24	1762210.0
2012-07-20 14:00:00	MSFT	Stock	30.245	30.3	30.21	30.222	1627817.0
2012-07-20 14:30:00	MSFT	Stock	30.22	30.23	30.13	30.185	1989533.0
2012-07-20 15:00:00	MSFT	Stock	30.185	30.25	30.18	30.2	2609745.0
2012-07-20 15:30:00	MSFT	Stock	30.2	30.21	30.05	30.08	8278975.0

> showing 50 of 73,717 rows — these rows as CSV

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