PREVIEW / stock_30min / 2015-02-10

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-02-10.parquet
  size:    1.6 MB
  rows:    83,024
  symbols: 3,522

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
2015-02-10 04:00:00	AAPL	Stock	29.9125	29.95	29.9125	29.95	6400.0
2015-02-10 04:30:00	AAPL	Stock	29.95	29.95	29.95	29.95	2748.0
2015-02-10 05:00:00	AAPL	Stock	29.9175	29.97	29.9175	29.97	2048.0
2015-02-10 05:30:00	AAPL	Stock	29.97	29.97	29.97	29.97	400.0
2015-02-10 06:00:00	AAPL	Stock	29.97	29.9975	29.97	29.9975	9700.0
2015-02-10 06:30:00	AAPL	Stock	29.9875	29.9875	29.95	29.95	2320.0
2015-02-10 07:00:00	AAPL	Stock	29.9975	30.1	29.9975	30.095	120660.0
2015-02-10 07:30:00	AAPL	Stock	30.0925	30.105	30.035	30.0575	109804.0
2015-02-10 08:00:00	AAPL	Stock	30.065	30.1075	29.9525	30.105	528852.0
2015-02-10 08:30:00	AAPL	Stock	30.105	30.145	30.08	30.135	669868.0
2015-02-10 09:00:00	AAPL	Stock	30.135	30.1875	30.04	30.0775	1452644.0
2015-02-10 09:30:00	AAPL	Stock	30.0425	30.3175	30.04	30.22	43701748.0
2015-02-10 10:00:00	AAPL	Stock	30.22	30.2775	30.165	30.1975	19741920.0
2015-02-10 10:30:00	AAPL	Stock	30.195	30.215	30.105	30.19	15406252.0
2015-02-10 11:00:00	AAPL	Stock	30.19	30.3	30.18	30.2962	15389640.0
2015-02-10 11:30:00	AAPL	Stock	30.2975	30.3075	30.2625	30.295	10424232.0
2015-02-10 12:00:00	AAPL	Stock	30.2962	30.3638	30.275	30.35	13392928.0
2015-02-10 12:30:00	AAPL	Stock	30.3475	30.43	30.3375	30.4275	14020672.0
2015-02-10 13:00:00	AAPL	Stock	30.4275	30.4612	30.3675	30.3875	12614064.0
2015-02-10 13:30:00	AAPL	Stock	30.39	30.4325	30.3675	30.39	8374232.0
2015-02-10 14:00:00	AAPL	Stock	30.3875	30.435	30.385	30.43	7231460.0
2015-02-10 14:30:00	AAPL	Stock	30.43	30.5175	30.4225	30.5162	15525908.0
2015-02-10 15:00:00	AAPL	Stock	30.5162	30.535	30.475	30.52	12898520.0
2015-02-10 15:30:00	AAPL	Stock	30.5225	30.5375	30.4825	30.505	22523284.0
2015-02-10 16:00:00	AAPL	Stock	30.505	30.5375	29.8582	30.535	19404524.0
2015-02-10 16:30:00	AAPL	Stock	30.535	30.545	30.348	30.5425	343676.0
2015-02-10 17:00:00	AAPL	Stock	30.54	30.555	30.505	30.5525	259656.0
2015-02-10 17:30:00	AAPL	Stock	30.5525	30.555	30.505	30.5475	139976.0
2015-02-10 18:00:00	AAPL	Stock	30.545	30.545	30.5375	30.545	79272.0
2015-02-10 18:30:00	AAPL	Stock	30.545	30.5475	30.5425	30.545	70568.0
2015-02-10 19:00:00	AAPL	Stock	30.5475	30.555	30.545	30.5525	56852.0
2015-02-10 19:30:00	AAPL	Stock	30.5525	30.555	30.55	30.555	263316.0
2015-02-10 05:00:00	MSFT	Stock	42.37	42.37	42.37	42.37	100.0
2015-02-10 06:30:00	MSFT	Stock	42.5	42.5	42.5	42.5	100.0
2015-02-10 07:00:00	MSFT	Stock	42.6	42.72	42.6	42.7	1999.0
2015-02-10 07:30:00	MSFT	Stock	42.71	42.71	42.65	42.65	2850.0
2015-02-10 08:00:00	MSFT	Stock	42.7	42.72	42.69	42.71	1900.0
2015-02-10 08:30:00	MSFT	Stock	42.75	42.75	42.71	42.71	1725.0
2015-02-10 09:00:00	MSFT	Stock	42.74	42.83	42.66	42.73	29079.0
2015-02-10 09:30:00	MSFT	Stock	42.74	42.77	42.31	42.34	4822344.0
2015-02-10 10:00:00	MSFT	Stock	42.34	42.39	42.18	42.302	2262874.0
2015-02-10 10:30:00	MSFT	Stock	42.3	42.45	42.28	42.315	1765139.0
2015-02-10 11:00:00	MSFT	Stock	42.315	42.44	42.28	42.415	1506280.0
2015-02-10 11:30:00	MSFT	Stock	42.42	42.58	42.38	42.566	1300580.0
2015-02-10 12:00:00	MSFT	Stock	42.57	42.725	42.54	42.68	1681850.0
2015-02-10 12:30:00	MSFT	Stock	42.67	42.67	42.53	42.575	1309687.0
2015-02-10 13:00:00	MSFT	Stock	42.575	42.6	42.48	42.56	918346.0
2015-02-10 13:30:00	MSFT	Stock	42.555	42.63	42.55	42.556	887287.0
2015-02-10 14:00:00	MSFT	Stock	42.55	42.605	42.54	42.57	1147533.0
2015-02-10 14:30:00	MSFT	Stock	42.57	42.59	42.53	42.585	2207863.0

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

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