PREVIEW / stock_30min / 2015-04-21

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-21.parquet
  size:    1.6 MB
  rows:    81,959
  symbols: 3,495

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-04-21 04:00:00	AAPL	Stock	32.0	32.2	32.0	32.08	16712.0
2015-04-21 04:30:00	AAPL	Stock	32.065	32.1	32.0625	32.0625	20204.0
2015-04-21 05:00:00	AAPL	Stock	32.0875	32.0875	32.025	32.05	41440.0
2015-04-21 05:30:00	AAPL	Stock	32.06	32.06	32.0175	32.05	25672.0
2015-04-21 06:00:00	AAPL	Stock	32.07	32.0725	32.05	32.05	23800.0
2015-04-21 06:30:00	AAPL	Stock	32.035	32.05	32.0225	32.045	38572.0
2015-04-21 07:00:00	AAPL	Stock	32.025	32.075	32.01	32.03	98744.0
2015-04-21 07:30:00	AAPL	Stock	32.035	32.045	32.015	32.015	93632.0
2015-04-21 08:00:00	AAPL	Stock	32.0125	32.0625	31.975	32.0175	446260.0
2015-04-21 08:30:00	AAPL	Stock	32.015	32.035	32.0075	32.03	171844.0
2015-04-21 09:00:00	AAPL	Stock	32.035	32.0525	31.99	32.005	546064.0
2015-04-21 09:30:00	AAPL	Stock	32.015	32.05	31.7525	31.7542	25500980.0
2015-04-21 10:00:00	AAPL	Stock	31.755	31.81	31.7025	31.7828	15832476.0
2015-04-21 10:30:00	AAPL	Stock	31.785	31.79	31.6675	31.7025	12056604.0
2015-04-21 11:00:00	AAPL	Stock	31.7025	31.7725	31.6868	31.755	6643644.0
2015-04-21 11:30:00	AAPL	Stock	31.755	31.7825	31.715	31.741	6095020.0
2015-04-21 12:00:00	AAPL	Stock	31.74	31.8425	31.7375	31.8275	5236276.0
2015-04-21 12:30:00	AAPL	Stock	31.825	31.8325	31.78	31.7818	3902852.0
2015-04-21 13:00:00	AAPL	Stock	31.78	31.87	31.78	31.8615	4916580.0
2015-04-21 13:30:00	AAPL	Stock	31.86	31.875	31.78	31.7835	5351024.0
2015-04-21 14:00:00	AAPL	Stock	31.785	31.81	31.725	31.7975	7785932.0
2015-04-21 14:30:00	AAPL	Stock	31.798	31.815	31.7225	31.75	5256216.0
2015-04-21 15:00:00	AAPL	Stock	31.7525	31.765	31.695	31.7075	6525868.0
2015-04-21 15:30:00	AAPL	Stock	31.71	31.7475	31.6875	31.7225	10570136.0
2015-04-21 16:00:00	AAPL	Stock	31.7275	31.7338	31.6775	31.6875	3218276.0
2015-04-21 16:30:00	AAPL	Stock	31.6778	31.715	31.6775	31.705	65184.0
2015-04-21 17:00:00	AAPL	Stock	31.7075	31.7078	31.6825	31.705	59404.0
2015-04-21 17:30:00	AAPL	Stock	31.71	31.72	31.705	31.72	89184.0
2015-04-21 18:00:00	AAPL	Stock	31.72	31.7275	31.7125	31.7248	97444.0
2015-04-21 18:30:00	AAPL	Stock	31.7125	31.725	31.7125	31.7225	41112.0
2015-04-21 19:00:00	AAPL	Stock	31.7275	31.73	31.7125	31.725	53472.0
2015-04-21 19:30:00	AAPL	Stock	31.72	31.725	31.715	31.725	71876.0
2015-04-21 04:00:00	MSFT	Stock	43.07	43.07	43.07	43.07	100.0
2015-04-21 05:30:00	MSFT	Stock	43.01	43.01	43.0	43.0	334.0
2015-04-21 06:30:00	MSFT	Stock	42.91	42.91	42.88	42.88	661.0
2015-04-21 07:00:00	MSFT	Stock	43.0	43.0	42.97	42.97	700.0
2015-04-21 08:00:00	MSFT	Stock	43.09	43.18	42.95	42.999	5600.0
2015-04-21 08:30:00	MSFT	Stock	43.0	43.0	42.91	42.92	4925.0
2015-04-21 09:00:00	MSFT	Stock	42.96	43.03	42.96	43.03	16221.0
2015-04-21 09:30:00	MSFT	Stock	43.03	43.15	42.78	42.78	4538705.0
2015-04-21 10:00:00	MSFT	Stock	42.79	42.85	42.68	42.805	2510473.0
2015-04-21 10:30:00	MSFT	Stock	42.805	42.82	42.68	42.714	1755774.0
2015-04-21 11:00:00	MSFT	Stock	42.71	42.77	42.64	42.645	1320904.0
2015-04-21 11:30:00	MSFT	Stock	42.64	42.69	42.54	42.62	1460714.0
2015-04-21 12:00:00	MSFT	Stock	42.615	42.76	42.6	42.75	1207865.0
2015-04-21 12:30:00	MSFT	Stock	42.75	42.8	42.64	42.67	1049909.0
2015-04-21 13:00:00	MSFT	Stock	42.66	42.8	42.65	42.77	1289196.0
2015-04-21 13:30:00	MSFT	Stock	42.765	42.765	42.594	42.6	1130693.0
2015-04-21 14:00:00	MSFT	Stock	42.6	42.66	42.53	42.65	1285944.0
2015-04-21 14:30:00	MSFT	Stock	42.657	42.66	42.56	42.62	988221.0

> showing 50 of 81,959 rows — these rows as CSV

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