PREVIEW / stock_30min / 2013-01-02

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-02.parquet
  size:    1.5 MB
  rows:    81,901
  symbols: 3,517

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
2013-01-02 04:00:00	AAPL	Stock	19.2854	19.3536	19.2504	19.3536	66052.0
2013-01-02 04:30:00	AAPL	Stock	19.3357	19.375	19.3357	19.375	21308.0
2013-01-02 05:00:00	AAPL	Stock	19.3929	19.4643	19.3607	19.4446	110348.0
2013-01-02 05:30:00	AAPL	Stock	19.4464	19.4929	19.4464	19.4554	110068.0
2013-01-02 06:00:00	AAPL	Stock	19.4443	19.5161	19.4443	19.5	288428.0
2013-01-02 06:30:00	AAPL	Stock	19.4989	19.5321	19.4636	19.4643	248276.0
2013-01-02 07:00:00	AAPL	Stock	19.4543	19.5357	19.4411	19.5236	1638952.0
2013-01-02 07:30:00	AAPL	Stock	19.5225	19.5939	19.5071	19.5439	1757896.0
2013-01-02 08:00:00	AAPL	Stock	19.5439	19.5807	19.4607	19.5357	4395636.0
2013-01-02 08:30:00	AAPL	Stock	19.5368	19.6339	19.5357	19.6243	4352264.0
2013-01-02 09:00:00	AAPL	Stock	19.6293	19.7857	19.5954	19.7854	10329424.0
2013-01-02 09:30:00	AAPL	Stock	19.7793	19.8214	19.6611	19.7143	128634856.0
2013-01-02 10:00:00	AAPL	Stock	19.7143	19.7168	19.5464	19.6304	65074968.0
2013-01-02 10:30:00	AAPL	Stock	19.625	19.6657	19.5407	19.5768	32967424.0
2013-01-02 11:00:00	AAPL	Stock	19.5754	19.6041	19.4757	19.5357	38733128.0
2013-01-02 11:30:00	AAPL	Stock	19.5357	19.5371	19.3757	19.395	40018496.0
2013-01-02 12:00:00	AAPL	Stock	19.3939	19.455	19.3439	19.4212	32001928.0
2013-01-02 12:30:00	AAPL	Stock	19.4212	19.4821	19.4014	19.4821	18664464.0
2013-01-02 13:00:00	AAPL	Stock	19.4821	19.5571	19.4689	19.5357	20993532.0
2013-01-02 13:30:00	AAPL	Stock	19.535	19.5625	19.4321	19.4539	17699584.0
2013-01-02 14:00:00	AAPL	Stock	19.4539	19.5411	19.4443	19.5196	15095752.0
2013-01-02 14:30:00	AAPL	Stock	19.5204	19.5446	19.4682	19.5354	16999696.0
2013-01-02 15:00:00	AAPL	Stock	19.5357	19.6104	19.5325	19.585	30279004.0
2013-01-02 15:30:00	AAPL	Stock	19.5818	19.7143	19.5193	19.5968	56316652.0
2013-01-02 16:00:00	AAPL	Stock	19.5968	19.6179	19.4047	19.6018	14355600.0
2013-01-02 16:30:00	AAPL	Stock	19.5986	19.6161	19.5804	19.605	1126692.0
2013-01-02 17:00:00	AAPL	Stock	19.6089	19.6143	19.6039	19.6093	335608.0
2013-01-02 17:30:00	AAPL	Stock	19.6071	19.6075	19.6014	19.6054	119924.0
2013-01-02 18:00:00	AAPL	Stock	19.6036	19.6118	19.6021	19.6039	152208.0
2013-01-02 18:30:00	AAPL	Stock	19.6039	19.6071	19.5964	19.6018	253008.0
2013-01-02 19:00:00	AAPL	Stock	19.5993	19.6018	19.5929	19.5954	61628.0
2013-01-02 19:30:00	AAPL	Stock	19.5954	19.5982	19.5832	19.5836	237244.0
2013-01-02 04:30:00	MSFT	Stock	26.99	26.99	26.99	26.99	2000.0
2013-01-02 06:30:00	MSFT	Stock	27.23	27.26	27.23	27.26	899.0
2013-01-02 07:00:00	MSFT	Stock	27.16	27.16	27.05	27.12	6300.0
2013-01-02 07:30:00	MSFT	Stock	27.11	27.15	27.11	27.15	2138.0
2013-01-02 08:00:00	MSFT	Stock	27.14	27.19	27.08	27.15	37073.0
2013-01-02 08:30:00	MSFT	Stock	27.16	27.2	27.14	27.17	79006.0
2013-01-02 09:00:00	MSFT	Stock	27.17	27.26	26.73	27.26	387121.0
2013-01-02 09:30:00	MSFT	Stock	27.26	27.4	27.15	27.324	8913446.0
2013-01-02 10:00:00	MSFT	Stock	27.325	27.335	27.23	27.31	4970425.0
2013-01-02 10:30:00	MSFT	Stock	27.308	27.315	27.21	27.215	3116156.0
2013-01-02 11:00:00	MSFT	Stock	27.215	27.25	27.15	27.23	3546970.0
2013-01-02 11:30:00	MSFT	Stock	27.225	27.27	27.18	27.205	2353509.0
2013-01-02 12:00:00	MSFT	Stock	27.21	27.23	27.17	27.22	1987827.0
2013-01-02 12:30:00	MSFT	Stock	27.225	27.24	27.16	27.182	1913270.0
2013-01-02 13:00:00	MSFT	Stock	27.185	27.24	27.17	27.205	1687533.0
2013-01-02 13:30:00	MSFT	Stock	27.21	27.25	27.19	27.24	2008005.0
2013-01-02 14:00:00	MSFT	Stock	27.235	27.32	27.22	27.305	2920174.0
2013-01-02 14:30:00	MSFT	Stock	27.305	27.35	27.27	27.305	2727611.0

> showing 50 of 81,901 rows — these rows as CSV

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