PREVIEW / stock_30min / 2011-08-24

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-24.parquet
  size:    1.4 MB
  rows:    76,180
  symbols: 3,501

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-24 04:00:00	AAPL	Stock	13.2075	13.2714	13.2075	13.2714	28000.0
2011-08-24 04:30:00	AAPL	Stock	13.2714	13.2714	13.2714	13.2714	2800.0
2011-08-24 05:00:00	AAPL	Stock	13.2857	13.3214	13.2857	13.3214	8400.0
2011-08-24 05:30:00	AAPL	Stock	13.3304	13.3304	13.3304	13.3304	2800.0
2011-08-24 06:00:00	AAPL	Stock	13.3214	13.3214	13.2839	13.2857	28000.0
2011-08-24 06:30:00	AAPL	Stock	13.2857	13.3032	13.2536	13.2536	55496.0
2011-08-24 07:00:00	AAPL	Stock	13.255	13.3293	13.2264	13.3179	446712.0
2011-08-24 07:30:00	AAPL	Stock	13.3071	13.3357	13.2857	13.2857	318248.0
2011-08-24 08:00:00	AAPL	Stock	13.2868	13.2964	13.2239	13.2357	1961960.0
2011-08-24 08:30:00	AAPL	Stock	13.2425	13.3411	13.2425	13.3361	3253768.0
2011-08-24 09:00:00	AAPL	Stock	13.3386	13.3439	13.3218	13.3282	1791916.0
2011-08-24 09:30:00	AAPL	Stock	13.333	13.5111	13.3043	13.5016	89784184.0
2011-08-24 10:00:00	AAPL	Stock	13.4979	13.5343	13.4071	13.4232	61942272.0
2011-08-24 10:30:00	AAPL	Stock	13.4264	13.4339	13.2896	13.2993	55280484.0
2011-08-24 11:00:00	AAPL	Stock	13.3004	13.3675	13.2582	13.355	54491780.0
2011-08-24 11:30:00	AAPL	Stock	13.3564	13.3675	13.2875	13.2979	34734364.0
2011-08-24 12:00:00	AAPL	Stock	13.2993	13.2993	13.2357	13.2889	33122124.0
2011-08-24 12:30:00	AAPL	Stock	13.2889	13.3529	13.2689	13.3436	24659180.0
2011-08-24 13:00:00	AAPL	Stock	13.3452	13.3857	13.3114	13.3632	28345240.0
2011-08-24 13:30:00	AAPL	Stock	13.3639	13.3736	13.315	13.3689	21387772.0
2011-08-24 14:00:00	AAPL	Stock	13.3676	13.3693	13.32	13.3411	20906200.0
2011-08-24 14:30:00	AAPL	Stock	13.3411	13.3843	13.3336	13.3836	27471360.0
2011-08-24 15:00:00	AAPL	Stock	13.3843	13.4586	13.3789	13.4446	49687204.0
2011-08-24 15:30:00	AAPL	Stock	13.4446	13.4875	13.4225	13.4339	57784132.0
2011-08-24 16:00:00	AAPL	Stock	13.4343	13.4393	13.2725	13.4029	10157924.0
2011-08-24 16:30:00	AAPL	Stock	13.3996	13.4086	13.3427	13.4007	221200.0
2011-08-24 17:00:00	AAPL	Stock	13.3429	13.4161	13.3429	13.4161	247716.0
2011-08-24 17:30:00	AAPL	Stock	13.4107	13.435	13.4054	13.4107	34216.0
2011-08-24 18:00:00	AAPL	Stock	13.4107	13.435	13.4082	13.4107	318388.0
2011-08-24 18:30:00	AAPL	Stock	12.6429	13.0018	12.5	12.75	7834036.0
2011-08-24 19:00:00	AAPL	Stock	12.75	12.7857	12.6786	12.7321	22194312.0
2011-08-24 19:30:00	AAPL	Stock	12.7289	12.8229	12.7143	12.7536	10560592.0
2011-08-24 07:30:00	MSFT	Stock	24.47	24.47	24.47	24.47	100.0
2011-08-24 08:00:00	MSFT	Stock	24.54	24.54	24.47	24.54	5425.0
2011-08-24 08:30:00	MSFT	Stock	24.56	24.72	24.54	24.65	11200.0
2011-08-24 09:00:00	MSFT	Stock	24.65	24.69	24.61	24.62	6200.0
2011-08-24 09:30:00	MSFT	Stock	24.6	24.84	24.45	24.81	4805589.0
2011-08-24 10:00:00	MSFT	Stock	24.81	24.84	24.6	24.61	4002669.0
2011-08-24 10:30:00	MSFT	Stock	24.61	24.72	24.57	24.59	3360214.0
2011-08-24 11:00:00	MSFT	Stock	24.585	24.61	24.45	24.49	3041808.0
2011-08-24 11:30:00	MSFT	Stock	24.49	24.575	24.42	24.53	3043121.0
2011-08-24 12:00:00	MSFT	Stock	24.525	24.6	24.45	24.57	2815384.0
2011-08-24 12:30:00	MSFT	Stock	24.57	24.68	24.545	24.67	1544159.0
2011-08-24 13:00:00	MSFT	Stock	24.67	24.77	24.62	24.725	2048136.0
2011-08-24 13:30:00	MSFT	Stock	24.73	24.74	24.615	24.74	2035900.0
2011-08-24 14:00:00	MSFT	Stock	24.74	24.78	24.66	24.703	1825281.0
2011-08-24 14:30:00	MSFT	Stock	24.702	24.815	24.7	24.805	2332714.0
2011-08-24 15:00:00	MSFT	Stock	24.81	24.85	24.76	24.79	2663547.0
2011-08-24 15:30:00	MSFT	Stock	24.79	24.93	24.78	24.9	7806667.0
2011-08-24 16:00:00	MSFT	Stock	24.91	24.91	24.583	24.88	3576704.0

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

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