PREVIEW / stock_30min / 2016-11-17

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-17.parquet
  size:    1.6 MB
  rows:    82,997
  symbols: 3,189

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
2016-11-17 04:00:00	AAPL	Stock	27.4975	27.4975	27.4975	27.4975	2612.0
2016-11-17 04:30:00	AAPL	Stock	27.4975	27.4975	27.4975	27.4975	1420.0
2016-11-17 05:00:00	AAPL	Stock	27.46	27.46	27.46	27.46	3988.0
2016-11-17 06:00:00	AAPL	Stock	27.45	27.45	27.45	27.45	3988.0
2016-11-17 06:30:00	AAPL	Stock	27.44	27.44	27.44	27.44	1080.0
2016-11-17 07:00:00	AAPL	Stock	27.465	27.465	27.46	27.465	3840.0
2016-11-17 07:30:00	AAPL	Stock	27.5	27.5325	27.48	27.48	13616.0
2016-11-17 08:00:00	AAPL	Stock	27.475	27.5425	27.4425	27.5	114044.0
2016-11-17 08:30:00	AAPL	Stock	27.48	27.5	27.45	27.45	113184.0
2016-11-17 09:00:00	AAPL	Stock	27.47	27.47	27.43	27.44	317228.0
2016-11-17 09:30:00	AAPL	Stock	27.455	27.5875	27.3312	27.4175	16890456.0
2016-11-17 10:00:00	AAPL	Stock	27.4175	27.4275	27.275	27.2988	9508112.0
2016-11-17 10:30:00	AAPL	Stock	27.2975	27.3675	27.2075	27.2328	10352572.0
2016-11-17 11:00:00	AAPL	Stock	27.2325	27.3375	27.2125	27.295	7546772.0
2016-11-17 11:30:00	AAPL	Stock	27.2975	27.38	27.265	27.375	6355084.0
2016-11-17 12:00:00	AAPL	Stock	27.375	27.445	27.365	27.405	6540244.0
2016-11-17 12:30:00	AAPL	Stock	27.4075	27.435	27.375	27.42	4533620.0
2016-11-17 13:00:00	AAPL	Stock	27.42	27.47	27.4075	27.445	4669048.0
2016-11-17 13:30:00	AAPL	Stock	27.4475	27.4725	27.415	27.42	4051876.0
2016-11-17 14:00:00	AAPL	Stock	27.42	27.4325	27.351	27.392	4954860.0
2016-11-17 14:30:00	AAPL	Stock	27.3928	27.4325	27.38	27.415	4191060.0
2016-11-17 15:00:00	AAPL	Stock	27.415	27.45	27.3975	27.43	4967640.0
2016-11-17 15:30:00	AAPL	Stock	27.4312	27.49	27.425	27.485	9624156.0
2016-11-17 16:00:00	AAPL	Stock	27.485	27.4975	27.3025	27.4675	8755464.0
2016-11-17 16:30:00	AAPL	Stock	27.48	27.4875	27.46	27.46	2548112.0
2016-11-17 17:00:00	AAPL	Stock	27.48	27.5	27.475	27.5	33260.0
2016-11-17 17:30:00	AAPL	Stock	27.5	27.51	27.5	27.5025	5032.0
2016-11-17 18:00:00	AAPL	Stock	27.5025	27.51	27.5	27.5	4100.0
2016-11-17 18:30:00	AAPL	Stock	27.5	27.5025	27.5	27.5025	3460.0
2016-11-17 19:00:00	AAPL	Stock	27.5	27.5	27.48	27.48	4772.0
2016-11-17 19:30:00	AAPL	Stock	27.48	27.48	27.4575	27.4625	11060.0
2016-11-17 04:00:00	MSFT	Stock	60.04	60.07	60.0	60.0	21505.0
2016-11-17 05:30:00	MSFT	Stock	60.18	60.35	60.18	60.21	1780.0
2016-11-17 06:00:00	MSFT	Stock	60.3	60.4	60.3	60.4	2200.0
2016-11-17 06:30:00	MSFT	Stock	60.35	60.35	60.34	60.35	2305.0
2016-11-17 07:00:00	MSFT	Stock	60.3	60.55	60.3	60.55	17656.0
2016-11-17 07:30:00	MSFT	Stock	60.55	60.61	60.43	60.59	23629.0
2016-11-17 08:00:00	MSFT	Stock	60.51	60.6	60.43	60.49	21062.0
2016-11-17 08:30:00	MSFT	Stock	60.56	60.58	60.33	60.33	36042.0
2016-11-17 09:00:00	MSFT	Stock	60.33	60.45	60.27	60.41	24732.0
2016-11-17 09:30:00	MSFT	Stock	60.41	60.45	59.965	60.329	4743582.0
2016-11-17 10:00:00	MSFT	Stock	60.34	60.41	60.25	60.283	2128241.0
2016-11-17 10:30:00	MSFT	Stock	60.28	60.37	60.25	60.3	1288620.0
2016-11-17 11:00:00	MSFT	Stock	60.3	60.52	60.28	60.505	1939653.0
2016-11-17 11:30:00	MSFT	Stock	60.51	60.57	60.43	60.55	1719688.0
2016-11-17 12:00:00	MSFT	Stock	60.555	60.72	60.46	60.695	2092610.0
2016-11-17 12:30:00	MSFT	Stock	60.685	60.75	60.623	60.705	1650317.0
2016-11-17 13:00:00	MSFT	Stock	60.7	60.8	60.7	60.77	1179477.0
2016-11-17 13:30:00	MSFT	Stock	60.77	60.95	60.77	60.83	1487403.0
2016-11-17 14:00:00	MSFT	Stock	60.83	60.855	60.55	60.565	2073439.0

> showing 50 of 82,997 rows — these rows as CSV

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