PREVIEW / stock_30min / 2015-04-13

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-13.parquet
  size:    1.6 MB
  rows:    81,602
  symbols: 3,513

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-13 04:00:00	AAPL	Stock	31.775	31.775	31.76	31.76	13364.0
2015-04-13 04:30:00	AAPL	Stock	31.7525	31.7575	31.7525	31.7575	3692.0
2015-04-13 05:00:00	AAPL	Stock	31.7575	31.7575	31.745	31.75	17876.0
2015-04-13 05:30:00	AAPL	Stock	31.75	31.7675	31.75	31.765	4800.0
2015-04-13 06:00:00	AAPL	Stock	31.7675	31.805	31.7625	31.805	59244.0
2015-04-13 06:30:00	AAPL	Stock	31.81	31.8475	31.8	31.8475	67872.0
2015-04-13 07:00:00	AAPL	Stock	31.8475	31.925	31.8375	31.885	107676.0
2015-04-13 07:30:00	AAPL	Stock	31.8875	31.9125	31.875	31.9125	109644.0
2015-04-13 08:00:00	AAPL	Stock	31.905	32.0325	31.8475	31.96	1038388.0
2015-04-13 08:30:00	AAPL	Stock	31.9525	31.9825	31.925	31.975	489520.0
2015-04-13 09:00:00	AAPL	Stock	31.9675	32.0875	31.9575	31.995	701064.0
2015-04-13 09:30:00	AAPL	Stock	32.0925	32.1425	31.9375	32.015	30340984.0
2015-04-13 10:00:00	AAPL	Stock	32.0125	32.0575	31.9625	32.0162	11388632.0
2015-04-13 10:30:00	AAPL	Stock	32.0175	32.0475	31.9525	31.9675	8394084.0
2015-04-13 11:00:00	AAPL	Stock	31.97	32.025	31.8625	31.8675	8254280.0
2015-04-13 11:30:00	AAPL	Stock	31.865	31.9088	31.8125	31.8625	9400700.0
2015-04-13 12:00:00	AAPL	Stock	31.8612	31.8925	31.7825	31.86	6981900.0
2015-04-13 12:30:00	AAPL	Stock	31.86	31.87	31.8	31.83	5290728.0
2015-04-13 13:00:00	AAPL	Stock	31.83	31.83	31.725	31.7675	8208372.0
2015-04-13 13:30:00	AAPL	Stock	31.7675	31.785	31.69	31.725	7222996.0
2015-04-13 14:00:00	AAPL	Stock	31.7275	31.745	31.6825	31.7325	5383416.0
2015-04-13 14:30:00	AAPL	Stock	31.735	31.775	31.695	31.75	6254016.0
2015-04-13 15:00:00	AAPL	Stock	31.7475	31.8275	31.6925	31.7175	8156428.0
2015-04-13 15:30:00	AAPL	Stock	31.72	31.7525	31.6525	31.7125	12901868.0
2015-04-13 16:00:00	AAPL	Stock	31.72	31.7625	31.7125	31.735	4737676.0
2015-04-13 16:30:00	AAPL	Stock	31.735	31.74	31.6975	31.7125	78896.0
2015-04-13 17:00:00	AAPL	Stock	31.7125	31.7375	31.705	31.7375	109084.0
2015-04-13 17:30:00	AAPL	Stock	31.7375	31.7375	31.73	31.735	13600.0
2015-04-13 18:00:00	AAPL	Stock	31.735	31.75	31.7325	31.75	109212.0
2015-04-13 18:30:00	AAPL	Stock	31.755	31.755	31.7225	31.7225	22040.0
2015-04-13 19:00:00	AAPL	Stock	31.7225	31.7425	31.72	31.74	44812.0
2015-04-13 19:30:00	AAPL	Stock	31.7375	31.7425	31.73	31.7375	60996.0
2015-04-13 07:30:00	MSFT	Stock	41.71	41.72	41.71	41.72	1000.0
2015-04-13 08:00:00	MSFT	Stock	41.7	41.7	41.5	41.5	330.0
2015-04-13 08:30:00	MSFT	Stock	41.72	41.72	41.58	41.58	4588.0
2015-04-13 09:00:00	MSFT	Stock	41.54	41.59	41.39	41.43	34876.0
2015-04-13 09:30:00	MSFT	Stock	41.39	41.9	41.39	41.86	4330186.0
2015-04-13 10:00:00	MSFT	Stock	41.855	41.9	41.81	41.87	1873619.0
2015-04-13 10:30:00	MSFT	Stock	41.876	41.935	41.85	41.885	1422971.0
2015-04-13 11:00:00	MSFT	Stock	41.88	41.98	41.88	41.938	1149516.0
2015-04-13 11:30:00	MSFT	Stock	41.935	42.06	41.93	41.95	1566879.0
2015-04-13 12:00:00	MSFT	Stock	41.95	41.98	41.86	41.963	995399.0
2015-04-13 12:30:00	MSFT	Stock	41.97	42.03	41.91	41.94	890253.0
2015-04-13 13:00:00	MSFT	Stock	41.945	41.95	41.8	41.8	701607.0
2015-04-13 13:30:00	MSFT	Stock	41.8	41.82	41.69	41.79	1533688.0
2015-04-13 14:00:00	MSFT	Stock	41.79	41.84	41.77	41.81	911890.0
2015-04-13 14:30:00	MSFT	Stock	41.81	41.87	41.74	41.78	1262281.0
2015-04-13 15:00:00	MSFT	Stock	41.79	41.84	41.75	41.81	2220620.0
2015-04-13 15:30:00	MSFT	Stock	41.81	41.89	41.72	41.77	5229969.0
2015-04-13 16:00:00	MSFT	Stock	41.76	41.82	41.76	41.77	4342753.0

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

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