PREVIEW / stock_30min / 2014-09-11

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-11.parquet
  size:    1.6 MB
  rows:    83,985
  symbols: 3,588

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
2014-09-11 04:00:00	AAPL	Stock	25.3	25.3	25.2075	25.26	21052.0
2014-09-11 04:30:00	AAPL	Stock	25.25	25.25	25.2225	25.2225	17200.0
2014-09-11 05:00:00	AAPL	Stock	25.215	25.215	25.2075	25.2125	3400.0
2014-09-11 05:30:00	AAPL	Stock	25.205	25.21	25.175	25.175	17600.0
2014-09-11 06:00:00	AAPL	Stock	25.175	25.195	25.175	25.1925	54204.0
2014-09-11 06:30:00	AAPL	Stock	25.2	25.2	25.175	25.1875	32976.0
2014-09-11 07:00:00	AAPL	Stock	25.1875	25.2175	25.175	25.18	87632.0
2014-09-11 07:30:00	AAPL	Stock	25.1775	25.19	25.115	25.125	182920.0
2014-09-11 08:00:00	AAPL	Stock	25.1175	25.25	25.0925	25.135	981464.0
2014-09-11 08:30:00	AAPL	Stock	25.1475	25.15	25.065	25.065	668724.0
2014-09-11 09:00:00	AAPL	Stock	25.065	25.135	25.0625	25.105	744644.0
2014-09-11 09:30:00	AAPL	Stock	25.1025	25.2112	25.0275	25.1272	34090620.0
2014-09-11 10:00:00	AAPL	Stock	25.125	25.14	25.01	25.0415	21226376.0
2014-09-11 10:30:00	AAPL	Stock	25.04	25.045	24.905	24.9652	23200668.0
2014-09-11 11:00:00	AAPL	Stock	24.9675	25.035	24.9325	24.9925	17244260.0
2014-09-11 11:30:00	AAPL	Stock	24.9932	25.0125	24.9625	24.9865	8533768.0
2014-09-11 12:00:00	AAPL	Stock	24.986	25.0625	24.9725	25.055	8135452.0
2014-09-11 12:30:00	AAPL	Stock	25.0525	25.055	24.99	25.0275	6651292.0
2014-09-11 13:00:00	AAPL	Stock	25.0258	25.0425	24.9525	24.987	8219756.0
2014-09-11 13:30:00	AAPL	Stock	24.985	25.0	24.9275	24.97	8413492.0
2014-09-11 14:00:00	AAPL	Stock	24.9675	25.0375	24.9625	25.025	8984980.0
2014-09-11 14:30:00	AAPL	Stock	25.025	25.195	25.0182	25.1838	19828188.0
2014-09-11 15:00:00	AAPL	Stock	25.1835	25.285	25.1825	25.2675	22565700.0
2014-09-11 15:30:00	AAPL	Stock	25.2675	25.36	25.2575	25.355	35863712.0
2014-09-11 16:00:00	AAPL	Stock	25.3575	25.3925	24.9995	25.3725	6121944.0
2014-09-11 16:30:00	AAPL	Stock	25.3575	25.3975	24.95	25.385	1235948.0
2014-09-11 17:00:00	AAPL	Stock	25.3875	25.4	25.3775	25.3875	140992.0
2014-09-11 17:30:00	AAPL	Stock	25.3875	25.3875	25.33	25.3425	846504.0
2014-09-11 18:00:00	AAPL	Stock	25.345	25.3475	25.3175	25.3175	183536.0
2014-09-11 18:30:00	AAPL	Stock	25.33	25.3575	25.315	25.32	93956.0
2014-09-11 19:00:00	AAPL	Stock	25.325	25.335	25.32	25.32	66640.0
2014-09-11 19:30:00	AAPL	Stock	25.32	25.34	25.315	25.33	61588.0
2014-09-11 04:00:00	MSFT	Stock	46.78	46.78	46.78	46.78	200.0
2014-09-11 04:30:00	MSFT	Stock	46.78	46.78	46.78	46.78	300.0
2014-09-11 07:00:00	MSFT	Stock	46.81	46.81	46.81	46.81	100.0
2014-09-11 07:30:00	MSFT	Stock	46.81	46.81	46.81	46.81	200.0
2014-09-11 08:00:00	MSFT	Stock	46.7	46.75	46.7	46.75	1010.0
2014-09-11 08:30:00	MSFT	Stock	46.69	46.69	46.67	46.67	1899.0
2014-09-11 09:00:00	MSFT	Stock	46.67	46.74	46.57	46.73	15941.0
2014-09-11 09:30:00	MSFT	Stock	46.74	46.77	46.58	46.73	2928388.0
2014-09-11 10:00:00	MSFT	Stock	46.725	46.74	46.57	46.593	1930814.0
2014-09-11 10:30:00	MSFT	Stock	46.59	46.61	46.47	46.51	2127708.0
2014-09-11 11:00:00	MSFT	Stock	46.511	46.66	46.51	46.6	2240144.0
2014-09-11 11:30:00	MSFT	Stock	46.61	46.65	46.52	46.6	2135751.0
2014-09-11 12:00:00	MSFT	Stock	46.595	46.64	46.48	46.63	1577906.0
2014-09-11 12:30:00	MSFT	Stock	46.63	46.65	46.535	46.569	1047649.0
2014-09-11 13:00:00	MSFT	Stock	46.57	46.62	46.49	46.556	1560233.0
2014-09-11 13:30:00	MSFT	Stock	46.556	46.6	46.49	46.6	2634717.0
2014-09-11 14:00:00	MSFT	Stock	46.59	46.83	46.59	46.83	1288814.0
2014-09-11 14:30:00	MSFT	Stock	46.825	46.85	46.75	46.76	945362.0

> showing 50 of 83,985 rows — these rows as CSV

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