PREVIEW / stock_30min / 2012-05-01

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-01.parquet
  size:    1.5 MB
  rows:    78,659
  symbols: 3,561

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-05-01 04:00:00	AAPL	Stock	20.8564	20.8571	20.8286	20.8286	18200.0
2012-05-01 04:30:00	AAPL	Stock	20.8214	20.8214	20.8214	20.8214	10612.0
2012-05-01 05:00:00	AAPL	Stock	20.8214	20.8214	20.8214	20.8214	14000.0
2012-05-01 06:00:00	AAPL	Stock	20.8214	20.8214	20.7929	20.7929	12348.0
2012-05-01 06:30:00	AAPL	Stock	20.7946	20.8	20.7946	20.7946	19432.0
2012-05-01 07:00:00	AAPL	Stock	20.8482	20.9368	20.8482	20.9368	115752.0
2012-05-01 07:30:00	AAPL	Stock	20.9429	21.02	20.915	20.9782	566328.0
2012-05-01 08:00:00	AAPL	Stock	20.9761	20.9979	20.8214	20.9636	1415316.0
2012-05-01 08:30:00	AAPL	Stock	20.9504	20.9504	20.8657	20.9068	1152424.0
2012-05-01 09:00:00	AAPL	Stock	20.8982	20.9107	20.8657	20.8911	1554084.0
2012-05-01 09:30:00	AAPL	Stock	20.8839	21.1586	20.7582	21.075	112175308.0
2012-05-01 10:00:00	AAPL	Stock	21.0875	21.3129	21.0778	21.2679	76858012.0
2012-05-01 10:30:00	AAPL	Stock	21.2679	21.3093	21.2021	21.2296	41776784.0
2012-05-01 11:00:00	AAPL	Stock	21.23	21.2832	21.2246	21.2504	21483420.0
2012-05-01 11:30:00	AAPL	Stock	21.2504	21.2732	21.2021	21.2354	21417060.0
2012-05-01 12:00:00	AAPL	Stock	21.2352	21.2396	21.0893	21.0937	33704776.0
2012-05-01 12:30:00	AAPL	Stock	21.0937	21.1954	21.0482	21.1804	31405696.0
2012-05-01 13:00:00	AAPL	Stock	21.1808	21.185	21.0714	21.096	17561376.0
2012-05-01 13:30:00	AAPL	Stock	21.0957	21.1032	20.9121	20.9354	44155972.0
2012-05-01 14:00:00	AAPL	Stock	20.9396	20.9439	20.7704	20.8886	61201476.0
2012-05-01 14:30:00	AAPL	Stock	20.8854	20.9796	20.84	20.8907	43180032.0
2012-05-01 15:00:00	AAPL	Stock	20.8886	20.9482	20.8171	20.8325	30921268.0
2012-05-01 15:30:00	AAPL	Stock	20.8296	20.8703	20.7886	20.7914	49570528.0
2012-05-01 16:00:00	AAPL	Stock	20.7904	21.0645	20.7536	20.7904	7838824.0
2012-05-01 16:30:00	AAPL	Stock	20.7875	21.2519	20.7721	20.7825	1354220.0
2012-05-01 17:00:00	AAPL	Stock	20.7814	20.7904	20.7696	20.7768	336560.0
2012-05-01 17:30:00	AAPL	Stock	20.775	20.7804	20.775	20.7775	187040.0
2012-05-01 18:00:00	AAPL	Stock	20.7786	20.7979	20.7786	20.7971	206080.0
2012-05-01 18:30:00	AAPL	Stock	20.8	20.8154	20.7982	20.8118	270424.0
2012-05-01 19:00:00	AAPL	Stock	20.8125	20.8179	20.7957	20.8057	160160.0
2012-05-01 19:30:00	AAPL	Stock	20.8054	20.8175	20.7986	20.8075	176148.0
2012-05-01 08:00:00	MSFT	Stock	32.04	32.04	31.96	32.03	900.0
2012-05-01 08:30:00	MSFT	Stock	31.99	32.02	31.99	32.02	28396.0
2012-05-01 09:00:00	MSFT	Stock	32.02	32.09	32.02	32.05	14293.0
2012-05-01 09:30:00	MSFT	Stock	32.05	32.11	31.96	32.01	3261933.0
2012-05-01 10:00:00	MSFT	Stock	32.02	32.2	32.01	32.18	5082395.0
2012-05-01 10:30:00	MSFT	Stock	32.172	32.23	32.17	32.177	2585993.0
2012-05-01 11:00:00	MSFT	Stock	32.17	32.21	32.16	32.17	2170561.0
2012-05-01 11:30:00	MSFT	Stock	32.18	32.335	32.17	32.282	2970281.0
2012-05-01 12:00:00	MSFT	Stock	32.285	32.31	32.27	32.275	1235419.0
2012-05-01 12:30:00	MSFT	Stock	32.275	32.3	32.24	32.25	1346788.0
2012-05-01 13:00:00	MSFT	Stock	32.24	32.25	32.11	32.187	1388717.0
2012-05-01 13:30:00	MSFT	Stock	32.184	32.22	32.165	32.2	1186676.0
2012-05-01 14:00:00	MSFT	Stock	32.19	32.21	32.14	32.17	1404137.0
2012-05-01 14:30:00	MSFT	Stock	32.17	32.17	32.09	32.135	1993409.0
2012-05-01 15:00:00	MSFT	Stock	32.14	32.15	32.08	32.1	2746062.0
2012-05-01 15:30:00	MSFT	Stock	32.095	32.11	31.95	32.02	9760819.0
2012-05-01 16:00:00	MSFT	Stock	32.02	32.113	31.98	32.01	5564763.0
2012-05-01 16:30:00	MSFT	Stock	32.01	32.01	31.99	31.99	13000.0
2012-05-01 17:00:00	MSFT	Stock	31.99	32.0	31.99	32.0	2311.0

> showing 50 of 78,659 rows — these rows as CSV

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