PREVIEW / stock_30min / 2011-09-23

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-23.parquet
  size:    1.4 MB
  rows:    76,233
  symbols: 3,512

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-09-23 04:00:00	AAPL	Stock	14.4286	14.4286	14.4286	14.4286	2800.0
2011-09-23 04:30:00	AAPL	Stock	14.4986	14.5	14.4464	14.4464	78120.0
2011-09-23 05:00:00	AAPL	Stock	14.4464	14.4521	14.4286	14.4518	36400.0
2011-09-23 05:30:00	AAPL	Stock	14.4393	14.4393	14.3929	14.3929	30800.0
2011-09-23 06:00:00	AAPL	Stock	14.3939	14.3939	14.3036	14.3036	44800.0
2011-09-23 06:30:00	AAPL	Stock	14.2807	14.2807	14.2146	14.25	56728.0
2011-09-23 07:00:00	AAPL	Stock	14.2857	14.2996	14.2168	14.25	784224.0
2011-09-23 07:30:00	AAPL	Stock	14.2479	14.25	14.1786	14.2018	679672.0
2011-09-23 08:00:00	AAPL	Stock	14.2071	14.3507	14.1271	14.2518	3673068.0
2011-09-23 08:30:00	AAPL	Stock	14.2561	14.2814	14.2143	14.25	2685480.0
2011-09-23 09:00:00	AAPL	Stock	14.25	14.3929	14.25	14.2961	4354504.0
2011-09-23 09:30:00	AAPL	Stock	14.2961	14.5	14.2804	14.4337	110769708.0
2011-09-23 10:00:00	AAPL	Stock	14.4332	14.4482	14.3586	14.4256	58678648.0
2011-09-23 10:30:00	AAPL	Stock	14.4221	14.4782	14.3929	14.4738	43916096.0
2011-09-23 11:00:00	AAPL	Stock	14.4711	14.5221	14.4554	14.5168	46881800.0
2011-09-23 11:30:00	AAPL	Stock	14.5214	14.5218	14.4018	14.4479	28034496.0
2011-09-23 12:00:00	AAPL	Stock	14.4444	14.4821	14.4107	14.4311	17240076.0
2011-09-23 12:30:00	AAPL	Stock	14.4336	14.4811	14.4018	14.4318	26246192.0
2011-09-23 13:00:00	AAPL	Stock	14.4321	14.4718	14.4146	14.4382	20275780.0
2011-09-23 13:30:00	AAPL	Stock	14.4343	14.5086	14.4325	14.5077	31031224.0
2011-09-23 14:00:00	AAPL	Stock	14.5082	14.5264	14.4511	14.4675	26713960.0
2011-09-23 14:30:00	AAPL	Stock	14.4686	14.4929	14.4289	14.4354	21359856.0
2011-09-23 15:00:00	AAPL	Stock	14.4371	14.4861	14.4157	14.4839	29213492.0
2011-09-23 15:30:00	AAPL	Stock	14.4824	14.4879	14.4259	14.4332	49159404.0
2011-09-23 16:00:00	AAPL	Stock	14.4332	14.4586	14.2861	14.4429	18871020.0
2011-09-23 16:30:00	AAPL	Stock	14.4396	14.4815	14.4346	14.4361	2192848.0
2011-09-23 17:00:00	AAPL	Stock	14.4389	14.4389	14.4186	14.4321	61572.0
2011-09-23 17:30:00	AAPL	Stock	14.435	14.4536	14.4346	14.4536	193900.0
2011-09-23 18:00:00	AAPL	Stock	14.4507	14.4518	14.4393	14.4464	113260.0
2011-09-23 18:30:00	AAPL	Stock	14.4432	14.4482	14.4432	14.4439	13440.0
2011-09-23 19:00:00	AAPL	Stock	14.4421	14.4425	14.4357	14.4375	117880.0
2011-09-23 19:30:00	AAPL	Stock	14.4375	14.4461	14.4286	14.4321	84840.0
2011-09-23 04:30:00	MSFT	Stock	25.33	25.33	25.33	25.33	700.0
2011-09-23 05:30:00	MSFT	Stock	25.18	25.18	25.1	25.1	338.0
2011-09-23 06:00:00	MSFT	Stock	25.05	25.05	24.93	24.93	200.0
2011-09-23 06:30:00	MSFT	Stock	24.9	24.9	24.8	24.8	2200.0
2011-09-23 07:00:00	MSFT	Stock	24.7	24.85	24.7	24.83	3603.0
2011-09-23 07:30:00	MSFT	Stock	24.85	24.85	24.7	24.72	27507.0
2011-09-23 08:00:00	MSFT	Stock	24.74	25.06	24.63	24.88	19651.0
2011-09-23 08:30:00	MSFT	Stock	24.9	24.9	24.77	24.85	18854.0
2011-09-23 09:00:00	MSFT	Stock	24.81	25.13	24.81	24.9	173147.0
2011-09-23 09:30:00	MSFT	Stock	24.97	25.04	24.78	24.91	7374229.0
2011-09-23 10:00:00	MSFT	Stock	24.91	24.94	24.69	24.8	5418749.0
2011-09-23 10:30:00	MSFT	Stock	24.8	25.06	24.78	25.02	3796901.0
2011-09-23 11:00:00	MSFT	Stock	25.025	25.13	24.95	25.125	4151046.0
2011-09-23 11:30:00	MSFT	Stock	25.13	25.14	24.9	24.97	3180212.0
2011-09-23 12:00:00	MSFT	Stock	24.97	25.052	24.92	24.934	3394100.0
2011-09-23 12:30:00	MSFT	Stock	24.935	25.01	24.83	24.84	3657814.0
2011-09-23 13:00:00	MSFT	Stock	24.85	24.93	24.77	24.9	3124642.0
2011-09-23 13:30:00	MSFT	Stock	24.89	25.05	24.89	25.03	3647320.0

> showing 50 of 76,233 rows — these rows as CSV

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