PREVIEW / stock_30min / 2017-03-13

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-13.parquet
  size:    1.6 MB
  rows:    81,706
  symbols: 3,066

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
2017-03-13 05:00:00	AAPL	Stock	34.73	34.73	34.73	34.73	576.0
2017-03-13 06:00:00	AAPL	Stock	34.7	34.7	34.7	34.7	2400.0
2017-03-13 06:30:00	AAPL	Stock	34.7	34.7	34.7	34.7	800.0
2017-03-13 07:00:00	AAPL	Stock	34.69	34.7	34.675	34.7	9600.0
2017-03-13 07:30:00	AAPL	Stock	34.7	34.7	34.68	34.68	17768.0
2017-03-13 08:00:00	AAPL	Stock	34.655	34.7175	34.655	34.6875	41864.0
2017-03-13 08:30:00	AAPL	Stock	34.695	34.7375	34.695	34.715	95324.0
2017-03-13 09:00:00	AAPL	Stock	34.71	34.715	34.6925	34.7075	104312.0
2017-03-13 09:30:00	AAPL	Stock	34.7125	34.85	34.705	34.7775	8955444.0
2017-03-13 10:00:00	AAPL	Stock	34.7775	34.79	34.7225	34.7412	5913188.0
2017-03-13 10:30:00	AAPL	Stock	34.7425	34.7725	34.71	34.7675	3829940.0
2017-03-13 11:00:00	AAPL	Stock	34.7685	34.7725	34.725	34.7325	2300832.0
2017-03-13 11:30:00	AAPL	Stock	34.73	34.7575	34.715	34.745	3532216.0
2017-03-13 12:00:00	AAPL	Stock	34.7475	34.8575	34.735	34.7525	5324584.0
2017-03-13 12:30:00	AAPL	Stock	34.7525	34.79	34.745	34.7788	2766972.0
2017-03-13 13:00:00	AAPL	Stock	34.778	34.8325	34.7738	34.8075	3298920.0
2017-03-13 13:30:00	AAPL	Stock	34.8075	34.8275	34.7825	34.815	2538644.0
2017-03-13 14:00:00	AAPL	Stock	34.8175	34.8425	34.8025	34.835	2497080.0
2017-03-13 14:30:00	AAPL	Stock	34.8325	34.8388	34.805	34.805	1946452.0
2017-03-13 15:00:00	AAPL	Stock	34.8075	34.8175	34.7912	34.8125	2207468.0
2017-03-13 15:30:00	AAPL	Stock	34.8125	34.82	34.78	34.7975	5485016.0
2017-03-13 16:00:00	AAPL	Stock	34.8	34.83	34.8	34.8175	8592884.0
2017-03-13 16:30:00	AAPL	Stock	34.8175	34.8225	34.805	34.805	11932.0
2017-03-13 17:00:00	AAPL	Stock	34.8125	34.825	34.8	34.825	12196.0
2017-03-13 17:30:00	AAPL	Stock	34.8225	34.825	34.8	34.8225	14896.0
2017-03-13 18:00:00	AAPL	Stock	34.8	34.8025	34.8	34.8025	2000.0
2017-03-13 18:30:00	AAPL	Stock	34.825	34.825	34.8175	34.8175	28540.0
2017-03-13 19:00:00	AAPL	Stock	34.8175	34.8175	34.8	34.8175	10400.0
2017-03-13 19:30:00	AAPL	Stock	34.8125	34.8125	34.8025	34.8125	10016.0
2017-03-13 04:00:00	MSFT	Stock	65.2	65.2	65.2	65.2	100.0
2017-03-13 08:00:00	MSFT	Stock	65.0	65.0	64.9	64.9	1165.0
2017-03-13 09:00:00	MSFT	Stock	65.0	65.01	65.0	65.0	3400.0
2017-03-13 09:30:00	MSFT	Stock	65.01	65.195	64.915	64.925	1834814.0
2017-03-13 10:00:00	MSFT	Stock	64.925	64.95	64.7	64.785	1287159.0
2017-03-13 10:30:00	MSFT	Stock	64.79	64.82	64.755	64.78	545595.0
2017-03-13 11:00:00	MSFT	Stock	64.78	64.83	64.76	64.785	693936.0
2017-03-13 11:30:00	MSFT	Stock	64.785	64.785	64.72	64.76	635960.0
2017-03-13 12:00:00	MSFT	Stock	64.76	64.77	64.571	64.585	772061.0
2017-03-13 12:30:00	MSFT	Stock	64.59	64.67	64.57	64.67	553672.0
2017-03-13 13:00:00	MSFT	Stock	64.665	64.75	64.665	64.72	727592.0
2017-03-13 13:30:00	MSFT	Stock	64.72	64.72	64.63	64.685	706601.0
2017-03-13 14:00:00	MSFT	Stock	64.69	64.746	64.68	64.73	696126.0
2017-03-13 14:30:00	MSFT	Stock	64.735	64.79	64.72	64.77	823113.0
2017-03-13 15:00:00	MSFT	Stock	64.775	64.81	64.71	64.79	913749.0
2017-03-13 15:30:00	MSFT	Stock	64.79	64.81	64.67	64.71	2578021.0
2017-03-13 16:00:00	MSFT	Stock	64.715	64.82	64.71	64.76	5136591.0
2017-03-13 16:30:00	MSFT	Stock	64.79	64.79	64.74	64.76	4100.0
2017-03-13 17:00:00	MSFT	Stock	64.77	64.77	64.75	64.77	1850.0
2017-03-13 17:30:00	MSFT	Stock	64.71	64.71	64.71	64.71	100.0
2017-03-13 18:00:00	MSFT	Stock	64.71	64.71	64.71	64.71	100.0

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

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