PREVIEW / stock_30min / 2013-09-26

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-26.parquet
  size:    1.5 MB
  rows:    79,720
  symbols: 3,529

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
2013-09-26 05:30:00	AAPL	Stock	17.2343	17.2343	17.2343	17.2343	3976.0
2013-09-26 06:30:00	AAPL	Stock	17.2686	17.2946	17.2686	17.2857	44800.0
2013-09-26 07:00:00	AAPL	Stock	17.3125	17.3393	17.2607	17.3071	641004.0
2013-09-26 07:30:00	AAPL	Stock	17.3079	17.3571	17.3021	17.3529	746200.0
2013-09-26 08:00:00	AAPL	Stock	17.3446	17.3536	17.2875	17.325	1878492.0
2013-09-26 08:30:00	AAPL	Stock	17.3261	17.3518	17.3136	17.3389	1105748.0
2013-09-26 09:00:00	AAPL	Stock	17.3221	17.4107	17.3125	17.3611	3496164.0
2013-09-26 09:30:00	AAPL	Stock	17.3593	17.4	17.3036	17.3636	46925284.0
2013-09-26 10:00:00	AAPL	Stock	17.3643	17.4486	17.3621	17.42	36399552.0
2013-09-26 10:30:00	AAPL	Stock	17.4207	17.4243	17.3371	17.3429	18536560.0
2013-09-26 11:00:00	AAPL	Stock	17.3421	17.3518	17.3125	17.3357	14500444.0
2013-09-26 11:30:00	AAPL	Stock	17.3375	17.35	17.2821	17.3277	11439232.0
2013-09-26 12:00:00	AAPL	Stock	17.3257	17.3414	17.3025	17.3379	8769544.0
2013-09-26 12:30:00	AAPL	Stock	17.3375	17.3489	17.3245	17.3288	6232856.0
2013-09-26 13:00:00	AAPL	Stock	17.3266	17.35	17.3132	17.3334	6466012.0
2013-09-26 13:30:00	AAPL	Stock	17.3336	17.3339	17.2993	17.3157	9083760.0
2013-09-26 14:00:00	AAPL	Stock	17.3139	17.3232	17.29	17.3118	8138172.0
2013-09-26 14:30:00	AAPL	Stock	17.3132	17.3175	17.2871	17.3096	8099084.0
2013-09-26 15:00:00	AAPL	Stock	17.3096	17.3161	17.2871	17.31	8995756.0
2013-09-26 15:30:00	AAPL	Stock	17.3082	17.375	17.2989	17.365	27989388.0
2013-09-26 16:00:00	AAPL	Stock	17.365	17.3964	17.3202	17.3857	8949416.0
2013-09-26 16:30:00	AAPL	Stock	17.3893	17.3921	17.3093	17.3786	346164.0
2013-09-26 17:00:00	AAPL	Stock	17.3804	17.3804	17.365	17.3718	319564.0
2013-09-26 17:30:00	AAPL	Stock	17.3714	17.3854	17.365	17.3832	109564.0
2013-09-26 18:00:00	AAPL	Stock	17.3814	17.4046	17.3814	17.3864	205632.0
2013-09-26 18:30:00	AAPL	Stock	17.3789	17.3989	17.3789	17.3857	190736.0
2013-09-26 19:00:00	AAPL	Stock	17.3836	17.3918	17.3793	17.3893	66780.0
2013-09-26 19:30:00	AAPL	Stock	17.3893	17.3982	17.3857	17.3893	411348.0
2013-09-26 07:00:00	MSFT	Stock	32.42	32.42	32.42	32.42	200.0
2013-09-26 08:00:00	MSFT	Stock	32.51	32.59	32.49	32.5	178858.0
2013-09-26 08:30:00	MSFT	Stock	32.5	32.59	32.5	32.59	3400.0
2013-09-26 09:00:00	MSFT	Stock	32.58	32.64	32.58	32.59	7878.0
2013-09-26 09:30:00	MSFT	Stock	32.64	32.94	32.59	32.92	3185649.0
2013-09-26 10:00:00	MSFT	Stock	32.919	33.0	32.86	32.959	2480890.0
2013-09-26 10:30:00	MSFT	Stock	32.955	32.995	32.76	32.775	2604851.0
2013-09-26 11:00:00	MSFT	Stock	32.772	32.8	32.71	32.755	2861356.0
2013-09-26 11:30:00	MSFT	Stock	32.755	32.81	32.74	32.74	1756741.0
2013-09-26 12:00:00	MSFT	Stock	32.75	32.83	32.74	32.83	1098784.0
2013-09-26 12:30:00	MSFT	Stock	32.83	32.97	32.825	32.95	1871488.0
2013-09-26 13:00:00	MSFT	Stock	32.95	32.96	32.87	32.89	963982.0
2013-09-26 13:30:00	MSFT	Stock	32.89	32.909	32.83	32.87	760051.0
2013-09-26 14:00:00	MSFT	Stock	32.875	32.88	32.8	32.83	783022.0
2013-09-26 14:30:00	MSFT	Stock	32.83	32.86	32.78	32.813	971854.0
2013-09-26 15:00:00	MSFT	Stock	32.81	32.86	32.8	32.83	1240092.0
2013-09-26 15:30:00	MSFT	Stock	32.82	32.86	32.77	32.77	3767364.0
2013-09-26 16:00:00	MSFT	Stock	32.78	32.834	32.76	32.79	1957902.0
2013-09-26 16:30:00	MSFT	Stock	32.76	32.9	32.76	32.77	90782.0
2013-09-26 17:00:00	MSFT	Stock	32.77	32.77	32.77	32.77	51620.0
2013-09-26 17:30:00	MSFT	Stock	32.78	32.9	32.76	32.9	25291.0
2013-09-26 18:00:00	MSFT	Stock	32.95	33.08	32.94	33.08	11500.0

> showing 50 of 79,720 rows — these rows as CSV

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