PREVIEW / stock_30min / 2011-10-31

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-31.parquet
  size:    1.4 MB
  rows:    76,387
  symbols: 3,524

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-10-31 04:30:00	AAPL	Stock	14.3929	14.4046	14.3818	14.3818	15400.0
2011-10-31 05:00:00	AAPL	Stock	14.3571	14.3571	14.3571	14.3571	5600.0
2011-10-31 05:30:00	AAPL	Stock	14.3393	14.3393	14.3268	14.3275	36400.0
2011-10-31 06:00:00	AAPL	Stock	14.3143	14.3143	14.3125	14.3132	35700.0
2011-10-31 06:30:00	AAPL	Stock	14.3321	14.3321	14.3321	14.3321	5404.0
2011-10-31 07:00:00	AAPL	Stock	14.3318	14.3571	14.3318	14.3489	101444.0
2011-10-31 07:30:00	AAPL	Stock	14.3414	14.3661	14.3411	14.3618	92120.0
2011-10-31 08:00:00	AAPL	Stock	14.3636	14.4061	14.3571	14.3768	606200.0
2011-10-31 08:30:00	AAPL	Stock	14.3721	14.3746	14.3529	14.3746	424592.0
2011-10-31 09:00:00	AAPL	Stock	14.3714	14.3814	14.3407	14.3707	898996.0
2011-10-31 09:30:00	AAPL	Stock	14.3714	14.4286	14.3232	14.4271	47137552.0
2011-10-31 10:00:00	AAPL	Stock	14.4284	14.5268	14.4114	14.5018	41401108.0
2011-10-31 10:30:00	AAPL	Stock	14.505	14.6189	14.5032	14.5575	48835136.0
2011-10-31 11:00:00	AAPL	Stock	14.5621	14.5761	14.5121	14.5346	24738560.0
2011-10-31 11:30:00	AAPL	Stock	14.5336	14.5832	14.5296	14.5471	20472564.0
2011-10-31 12:00:00	AAPL	Stock	14.5464	14.5607	14.465	14.4782	20012944.0
2011-10-31 12:30:00	AAPL	Stock	14.4804	14.5275	14.4779	14.52	15278284.0
2011-10-31 13:00:00	AAPL	Stock	14.5182	14.5414	14.5171	14.5211	11591160.0
2011-10-31 13:30:00	AAPL	Stock	14.5196	14.5636	14.5179	14.5611	13624688.0
2011-10-31 14:00:00	AAPL	Stock	14.56	14.5689	14.5286	14.5521	16061360.0
2011-10-31 14:30:00	AAPL	Stock	14.5546	14.5589	14.5	14.5339	17540460.0
2011-10-31 15:00:00	AAPL	Stock	14.5307	14.5332	14.4368	14.4468	32504640.0
2011-10-31 15:30:00	AAPL	Stock	14.4486	14.5	14.4375	14.4571	48573000.0
2011-10-31 16:00:00	AAPL	Stock	14.4771	14.4992	14.3934	14.4564	18618600.0
2011-10-31 16:30:00	AAPL	Stock	14.4604	14.5338	14.4343	14.4464	1017492.0
2011-10-31 17:00:00	AAPL	Stock	14.4446	14.4464	14.435	14.4464	107352.0
2011-10-31 17:30:00	AAPL	Stock	14.4464	14.4464	14.4343	14.4389	58380.0
2011-10-31 18:00:00	AAPL	Stock	14.4343	14.4564	14.4321	14.4321	49224.0
2011-10-31 18:30:00	AAPL	Stock	14.4357	14.4357	14.4286	14.4354	34720.0
2011-10-31 19:00:00	AAPL	Stock	14.4389	14.4389	14.4357	14.4357	30800.0
2011-10-31 19:30:00	AAPL	Stock	14.4339	14.4457	14.4339	14.4414	74200.0
2011-10-31 04:00:00	MSFT	Stock	26.9	26.9	26.9	26.9	10000.0
2011-10-31 08:00:00	MSFT	Stock	26.86	26.86	26.83	26.85	4660.0
2011-10-31 08:30:00	MSFT	Stock	26.83	26.84	26.72	26.84	6755.0
2011-10-31 09:00:00	MSFT	Stock	26.83	26.88	26.72	26.755	89278.0
2011-10-31 09:30:00	MSFT	Stock	26.79	26.87	26.74	26.8	2363908.0
2011-10-31 10:00:00	MSFT	Stock	26.8	26.95	26.79	26.93	2010155.0
2011-10-31 10:30:00	MSFT	Stock	26.93	27.0	26.89	26.955	2550956.0
2011-10-31 11:00:00	MSFT	Stock	26.95	26.955	26.84	26.896	2434548.0
2011-10-31 11:30:00	MSFT	Stock	26.89	26.94	26.81	26.81	3055162.0
2011-10-31 12:00:00	MSFT	Stock	26.81	26.83	26.76	26.775	2884024.0
2011-10-31 12:30:00	MSFT	Stock	26.78	26.82	26.72	26.805	3049896.0
2011-10-31 13:00:00	MSFT	Stock	26.81	26.83	26.74	26.75	1344728.0
2011-10-31 13:30:00	MSFT	Stock	26.75	26.86	26.746	26.85	2525536.0
2011-10-31 14:00:00	MSFT	Stock	26.844	26.86	26.76	26.79	1662919.0
2011-10-31 14:30:00	MSFT	Stock	26.8	26.81	26.735	26.767	1975439.0
2011-10-31 15:00:00	MSFT	Stock	26.77	26.77	26.65	26.66	3583324.0
2011-10-31 15:30:00	MSFT	Stock	26.66	26.82	26.62	26.65	8767596.0
2011-10-31 16:00:00	MSFT	Stock	26.65	26.952	26.59	26.623	5950529.0
2011-10-31 16:30:00	MSFT	Stock	26.64	26.886	26.6	26.63	332818.0

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

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