PREVIEW / stock_30min / 2011-08-23

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-23.parquet
  size:    1.4 MB
  rows:    77,655
  symbols: 3,537

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
2011-08-23 04:00:00	AAPL	Stock	12.8443	12.9804	12.8443	12.9782	93100.0
2011-08-23 04:30:00	AAPL	Stock	12.9679	12.9679	12.9	12.9286	85400.0
2011-08-23 05:00:00	AAPL	Stock	12.9179	12.9464	12.9179	12.9464	36400.0
2011-08-23 05:30:00	AAPL	Stock	12.9786	12.9804	12.9768	12.9768	8400.0
2011-08-23 06:00:00	AAPL	Stock	12.9714	12.9714	12.9196	12.9486	150080.0
2011-08-23 06:30:00	AAPL	Stock	12.9579	12.9607	12.9286	12.9286	36148.0
2011-08-23 07:00:00	AAPL	Stock	12.9111	12.9714	12.8614	12.9304	1238580.0
2011-08-23 07:30:00	AAPL	Stock	12.9307	12.9554	12.8843	12.8911	855708.0
2011-08-23 08:00:00	AAPL	Stock	12.8911	12.9321	12.8286	12.8857	1702064.0
2011-08-23 08:30:00	AAPL	Stock	12.8789	12.8821	12.8254	12.8261	1611176.0
2011-08-23 09:00:00	AAPL	Stock	12.825	12.875	12.825	12.8729	1907724.0
2011-08-23 09:30:00	AAPL	Stock	12.8629	12.9214	12.75	12.8882	71801240.0
2011-08-23 10:00:00	AAPL	Stock	12.8882	12.99	12.875	12.9843	54323108.0
2011-08-23 10:30:00	AAPL	Stock	12.9868	13.0186	12.9343	12.9453	43537536.0
2011-08-23 11:00:00	AAPL	Stock	12.9425	12.9986	12.9264	12.9979	31382064.0
2011-08-23 11:30:00	AAPL	Stock	12.9979	13.0929	12.9815	13.0921	45762024.0
2011-08-23 12:00:00	AAPL	Stock	13.0895	13.0925	13.0461	13.0764	30596692.0
2011-08-23 12:30:00	AAPL	Stock	13.0764	13.1775	13.0754	13.1564	42384272.0
2011-08-23 13:00:00	AAPL	Stock	13.1568	13.1964	13.1289	13.137	38961412.0
2011-08-23 13:30:00	AAPL	Stock	13.1389	13.156	13.0411	13.1021	45208856.0
2011-08-23 14:00:00	AAPL	Stock	13.1025	13.1607	13.0571	13.1562	40821340.0
2011-08-23 14:30:00	AAPL	Stock	13.1561	13.2275	13.1421	13.2071	48115060.0
2011-08-23 15:00:00	AAPL	Stock	13.2084	13.2832	13.205	13.2414	53706184.0
2011-08-23 15:30:00	AAPL	Stock	13.2418	13.3443	13.2393	13.3425	82806584.0
2011-08-23 16:00:00	AAPL	Stock	13.3293	13.3482	13.0919	13.3357	14558180.0
2011-08-23 16:30:00	AAPL	Stock	13.3357	13.3464	12.7269	13.3382	543508.0
2011-08-23 17:00:00	AAPL	Stock	13.3375	13.3482	13.3357	13.3357	858424.0
2011-08-23 17:30:00	AAPL	Stock	13.3361	13.3429	13.3279	13.3357	334376.0
2011-08-23 18:00:00	AAPL	Stock	13.3393	13.3429	13.3346	13.3393	271264.0
2011-08-23 18:30:00	AAPL	Stock	13.3386	13.3425	13.3357	13.3375	125496.0
2011-08-23 19:00:00	AAPL	Stock	13.3325	13.3325	13.29	13.3036	191520.0
2011-08-23 19:30:00	AAPL	Stock	13.2982	13.3136	13.2968	13.3071	86940.0
2011-08-23 07:00:00	MSFT	Stock	24.25	24.38	24.25	24.38	4425.0
2011-08-23 07:30:00	MSFT	Stock	24.39	24.39	24.29	24.29	2652.0
2011-08-23 08:00:00	MSFT	Stock	24.29	24.29	24.2	24.23	25430.0
2011-08-23 08:30:00	MSFT	Stock	24.21	24.24	24.15	24.15	9916.0
2011-08-23 09:00:00	MSFT	Stock	24.12	24.16	24.08	24.08	10534.0
2011-08-23 09:30:00	MSFT	Stock	24.05	24.46	24.03	24.415	5858131.0
2011-08-23 10:00:00	MSFT	Stock	24.42	24.59	24.38	24.5	4498078.0
2011-08-23 10:30:00	MSFT	Stock	24.5	24.64	24.4	24.4	3325672.0
2011-08-23 11:00:00	MSFT	Stock	24.405	24.45	24.331	24.427	2654663.0
2011-08-23 11:30:00	MSFT	Stock	24.43	24.68	24.42	24.655	3102949.0
2011-08-23 12:00:00	MSFT	Stock	24.655	24.67	24.58	24.61	1671164.0
2011-08-23 12:30:00	MSFT	Stock	24.61	24.75	24.6	24.63	2937279.0
2011-08-23 13:00:00	MSFT	Stock	24.635	24.68	24.54	24.595	2273523.0
2011-08-23 13:30:00	MSFT	Stock	24.595	24.62	24.4	24.51	3049573.0
2011-08-23 14:00:00	MSFT	Stock	24.51	24.59	24.4	24.54	3195968.0
2011-08-23 14:30:00	MSFT	Stock	24.535	24.605	24.5	24.57	2695731.0
2011-08-23 15:00:00	MSFT	Stock	24.575	24.75	24.565	24.621	3831452.0
2011-08-23 15:30:00	MSFT	Stock	24.63	24.75	24.53	24.71	11169663.0

> showing 50 of 77,655 rows — these rows as CSV

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