PREVIEW / stock_30min / 2015-12-17

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-12-17.parquet
  size:    1.6 MB
  rows:    84,530
  symbols: 3,436

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-12-17 04:00:00	AAPL	Stock	27.92	27.92	27.92	27.92	800.0
2015-12-17 04:30:00	AAPL	Stock	27.9075	27.95	27.9075	27.95	22732.0
2015-12-17 05:00:00	AAPL	Stock	27.9625	27.9625	27.9425	27.95	6800.0
2015-12-17 05:30:00	AAPL	Stock	27.96	27.9725	27.96	27.9725	12588.0
2015-12-17 06:00:00	AAPL	Stock	27.9525	27.995	27.95	27.9775	15128.0
2015-12-17 06:30:00	AAPL	Stock	27.985	28.0375	27.985	28.0125	22396.0
2015-12-17 07:00:00	AAPL	Stock	28.02	28.06	28.0075	28.05	76680.0
2015-12-17 07:30:00	AAPL	Stock	28.0275	28.1125	28.0275	28.075	156836.0
2015-12-17 08:00:00	AAPL	Stock	28.065	28.1	28.0125	28.055	306548.0
2015-12-17 08:30:00	AAPL	Stock	28.0625	28.1125	28.0375	28.07	529428.0
2015-12-17 09:00:00	AAPL	Stock	28.085	28.11	27.835	28.0375	374592.0
2015-12-17 09:30:00	AAPL	Stock	28.005	28.0425	27.695	27.7938	20529336.0
2015-12-17 10:00:00	AAPL	Stock	27.7975	27.83	27.655	27.68	13063780.0
2015-12-17 10:30:00	AAPL	Stock	27.6825	27.7075	27.4825	27.53	13546412.0
2015-12-17 11:00:00	AAPL	Stock	27.5275	27.5975	27.3675	27.43	14478940.0
2015-12-17 11:30:00	AAPL	Stock	27.43	27.5825	27.375	27.51	11423268.0
2015-12-17 12:00:00	AAPL	Stock	27.5125	27.555	27.4625	27.495	7322536.0
2015-12-17 12:30:00	AAPL	Stock	27.495	27.5675	27.4475	27.5525	6301260.0
2015-12-17 13:00:00	AAPL	Stock	27.55	27.6375	27.52	27.5825	5927120.0
2015-12-17 13:30:00	AAPL	Stock	27.578	27.58	27.5	27.5175	6855104.0
2015-12-17 14:00:00	AAPL	Stock	27.518	27.5475	27.4	27.4215	11330060.0
2015-12-17 14:30:00	AAPL	Stock	27.42	27.45	27.28	27.365	11724172.0
2015-12-17 15:00:00	AAPL	Stock	27.367	27.3875	27.2875	27.355	11366528.0
2015-12-17 15:30:00	AAPL	Stock	27.355	27.4575	27.2475	27.25	22339512.0
2015-12-17 16:00:00	AAPL	Stock	27.2488	27.3425	27.175	27.1875	8513956.0
2015-12-17 16:30:00	AAPL	Stock	27.1875	27.245	27.1875	27.2125	213340.0
2015-12-17 17:00:00	AAPL	Stock	27.2125	27.2325	27.1875	27.2075	59916.0
2015-12-17 17:30:00	AAPL	Stock	27.215	27.235	27.2125	27.2225	40620.0
2015-12-17 18:00:00	AAPL	Stock	27.2225	27.225	27.2075	27.21	17580.0
2015-12-17 18:30:00	AAPL	Stock	27.205	27.2125	27.1875	27.1875	45464.0
2015-12-17 19:00:00	AAPL	Stock	27.185	27.2	27.15	27.1775	140276.0
2015-12-17 19:30:00	AAPL	Stock	27.175	27.175	27.1525	27.1575	143928.0
2015-12-17 05:00:00	MSFT	Stock	56.29	56.29	56.29	56.29	100.0
2015-12-17 06:00:00	MSFT	Stock	56.48	56.48	56.48	56.48	200.0
2015-12-17 07:00:00	MSFT	Stock	56.44	56.44	56.34	56.35	1700.0
2015-12-17 07:30:00	MSFT	Stock	56.35	56.37	56.29	56.29	2067.0
2015-12-17 08:00:00	MSFT	Stock	56.34	56.38	56.29	56.36	19892.0
2015-12-17 08:30:00	MSFT	Stock	56.36	56.4	56.36	56.36	5550.0
2015-12-17 09:00:00	MSFT	Stock	56.38	56.4	56.33	56.37	11507.0
2015-12-17 09:30:00	MSFT	Stock	56.36	56.79	56.2	56.6	5932777.0
2015-12-17 10:00:00	MSFT	Stock	56.61	56.62	56.155	56.205	4650135.0
2015-12-17 10:30:00	MSFT	Stock	56.2	56.26	55.74	55.87	2747037.0
2015-12-17 11:00:00	MSFT	Stock	55.86	56.015	55.62	55.822	2066898.0
2015-12-17 11:30:00	MSFT	Stock	55.82	55.89	55.66	55.74	1787252.0
2015-12-17 12:00:00	MSFT	Stock	55.74	55.85	55.535	55.82	1525278.0
2015-12-17 12:30:00	MSFT	Stock	55.82	55.99	55.75	55.92	1718590.0
2015-12-17 13:00:00	MSFT	Stock	55.92	56.33	55.9	56.29	1706056.0
2015-12-17 13:30:00	MSFT	Stock	56.28	56.4	56.09	56.29	2011924.0
2015-12-17 14:00:00	MSFT	Stock	56.29	56.355	56.19	56.27	2187234.0
2015-12-17 14:30:00	MSFT	Stock	56.26	56.315	56.01	56.078	1672926.0

> showing 50 of 84,530 rows — these rows as CSV

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