PREVIEW / stock_30min / 2011-11-22

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-22.parquet
  size:    1.4 MB
  rows:    73,397
  symbols: 3,513

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-11-22 04:00:00	AAPL	Stock	13.2143	13.2143	13.2071	13.2071	44800.0
2011-11-22 04:30:00	AAPL	Stock	13.225	13.225	13.2107	13.2107	44800.0
2011-11-22 05:00:00	AAPL	Stock	13.2482	13.2482	13.2482	13.2482	2800.0
2011-11-22 06:30:00	AAPL	Stock	13.2925	13.2925	13.2786	13.2786	69916.0
2011-11-22 07:00:00	AAPL	Stock	13.2661	13.2857	13.2425	13.2625	278236.0
2011-11-22 07:30:00	AAPL	Stock	13.2439	13.2646	13.2143	13.2482	222656.0
2011-11-22 08:00:00	AAPL	Stock	13.24	13.2582	13.1779	13.1961	1225504.0
2011-11-22 08:30:00	AAPL	Stock	13.1861	13.2196	13.17	13.2143	992096.0
2011-11-22 09:00:00	AAPL	Stock	13.215	13.275	13.2054	13.2514	1077804.0
2011-11-22 09:30:00	AAPL	Stock	13.2518	13.3836	13.2479	13.3439	63178668.0
2011-11-22 10:00:00	AAPL	Stock	13.3446	13.37	13.2914	13.363	35838852.0
2011-11-22 10:30:00	AAPL	Stock	13.3629	13.38	13.2775	13.2961	31414852.0
2011-11-22 11:00:00	AAPL	Stock	13.2957	13.3218	13.2614	13.3057	25695908.0
2011-11-22 11:30:00	AAPL	Stock	13.3057	13.3257	13.2811	13.3068	20369132.0
2011-11-22 12:00:00	AAPL	Stock	13.3071	13.3918	13.3068	13.3511	28014420.0
2011-11-22 12:30:00	AAPL	Stock	13.3514	13.4164	13.3407	13.4161	21303296.0
2011-11-22 13:00:00	AAPL	Stock	13.4162	13.4307	13.3832	13.4136	20331948.0
2011-11-22 13:30:00	AAPL	Stock	13.4146	13.4518	13.4107	13.4278	21618604.0
2011-11-22 14:00:00	AAPL	Stock	13.4263	13.4546	13.4218	13.4411	19802300.0
2011-11-22 14:30:00	AAPL	Stock	13.4414	13.4604	13.4239	13.4411	18969664.0
2011-11-22 15:00:00	AAPL	Stock	13.4411	13.4586	13.3946	13.4525	24871364.0
2011-11-22 15:30:00	AAPL	Stock	13.4518	13.4975	13.4432	13.4471	45695076.0
2011-11-22 16:00:00	AAPL	Stock	13.4518	13.4536	13.3759	13.4314	10257632.0
2011-11-22 16:30:00	AAPL	Stock	13.4286	13.4538	13.3238	13.4304	194096.0
2011-11-22 17:00:00	AAPL	Stock	13.3474	13.4325	13.3474	13.4325	202076.0
2011-11-22 17:30:00	AAPL	Stock	13.4321	13.4468	13.4218	13.4232	90132.0
2011-11-22 18:00:00	AAPL	Stock	13.4225	13.4232	13.4214	13.4232	22120.0
2011-11-22 18:30:00	AAPL	Stock	13.4275	13.4354	13.4268	13.4286	94892.0
2011-11-22 19:00:00	AAPL	Stock	13.4318	13.4468	13.4218	13.4218	66640.0
2011-11-22 19:30:00	AAPL	Stock	13.4271	13.4271	13.4114	13.4132	185696.0
2011-11-22 06:00:00	MSFT	Stock	25.17	25.17	25.17	25.17	100.0
2011-11-22 06:30:00	MSFT	Stock	25.08	25.08	25.07	25.07	1200.0
2011-11-22 07:00:00	MSFT	Stock	25.18	25.18	25.18	25.18	1000.0
2011-11-22 07:30:00	MSFT	Stock	25.15	25.15	25.05	25.05	1300.0
2011-11-22 08:00:00	MSFT	Stock	25.05	25.05	24.92	24.95	13500.0
2011-11-22 08:30:00	MSFT	Stock	24.95	24.95	24.87	24.95	24209.0
2011-11-22 09:00:00	MSFT	Stock	24.95	24.99	24.86	24.91	17287.0
2011-11-22 09:30:00	MSFT	Stock	24.9	24.96	24.81	24.85	6563065.0
2011-11-22 10:00:00	MSFT	Stock	24.85	24.88	24.8	24.87	3465509.0
2011-11-22 10:30:00	MSFT	Stock	24.875	24.88	24.7	24.731	4853415.0
2011-11-22 11:00:00	MSFT	Stock	24.737	24.78	24.67	24.685	3579261.0
2011-11-22 11:30:00	MSFT	Stock	24.685	24.82	24.65	24.795	4129409.0
2011-11-22 12:00:00	MSFT	Stock	24.795	24.88	24.75	24.774	3290657.0
2011-11-22 12:30:00	MSFT	Stock	24.78	24.89	24.76	24.88	1567233.0
2011-11-22 13:00:00	MSFT	Stock	24.885	24.96	24.82	24.901	2150841.0
2011-11-22 13:30:00	MSFT	Stock	24.91	24.92	24.8	24.825	1512228.0
2011-11-22 14:00:00	MSFT	Stock	24.825	24.86	24.76	24.82	2038562.0
2011-11-22 14:30:00	MSFT	Stock	24.82	24.83	24.73	24.745	2514954.0
2011-11-22 15:00:00	MSFT	Stock	24.74	24.82	24.705	24.781	3888662.0
2011-11-22 15:30:00	MSFT	Stock	24.785	24.82	24.72	24.79	7081820.0

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

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