PREVIEW / stock_30min / 2016-09-07

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-07.parquet
  size:    1.6 MB
  rows:    83,729
  symbols: 3,264

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-09-07 04:00:00	AAPL	Stock	26.9875	26.995	26.9875	26.995	2400.0
2016-09-07 04:30:00	AAPL	Stock	26.995	26.995	26.995	26.995	800.0
2016-09-07 05:00:00	AAPL	Stock	26.995	26.995	26.995	26.995	1600.0
2016-09-07 05:30:00	AAPL	Stock	27.0175	27.0525	27.0175	27.0475	4800.0
2016-09-07 06:00:00	AAPL	Stock	27.0325	27.0525	27.02	27.0525	39184.0
2016-09-07 06:30:00	AAPL	Stock	27.055	27.07	27.055	27.0675	10016.0
2016-09-07 07:00:00	AAPL	Stock	27.0675	27.0675	26.975	26.975	94168.0
2016-09-07 07:30:00	AAPL	Stock	26.995	27.0125	26.9775	26.9775	63412.0
2016-09-07 08:00:00	AAPL	Stock	27.0625	27.0625	26.965	26.98	167416.0
2016-09-07 08:30:00	AAPL	Stock	26.9675	26.985	26.95	26.97	162964.0
2016-09-07 09:00:00	AAPL	Stock	26.97	26.97	26.9425	26.97	189952.0
2016-09-07 09:30:00	AAPL	Stock	26.9625	27.0	26.8725	26.8825	14065696.0
2016-09-07 10:00:00	AAPL	Stock	26.885	26.953	26.885	26.9125	8337780.0
2016-09-07 10:30:00	AAPL	Stock	26.91	26.925	26.8275	26.831	6695560.0
2016-09-07 11:00:00	AAPL	Stock	26.8302	26.89	26.82	26.8552	7132268.0
2016-09-07 11:30:00	AAPL	Stock	26.8575	26.8612	26.82	26.8385	3737408.0
2016-09-07 12:00:00	AAPL	Stock	26.84	26.845	26.775	26.81	5624164.0
2016-09-07 12:30:00	AAPL	Stock	26.808	26.855	26.7675	26.8525	6555376.0
2016-09-07 13:00:00	AAPL	Stock	26.8512	26.94	26.8275	26.8502	14132404.0
2016-09-07 13:30:00	AAPL	Stock	26.85	26.89	26.8062	26.8898	8507744.0
2016-09-07 14:00:00	AAPL	Stock	26.8898	26.91	26.8325	26.8875	7841424.0
2016-09-07 14:30:00	AAPL	Stock	26.89	26.9	26.78	26.8075	11295336.0
2016-09-07 15:00:00	AAPL	Stock	26.8052	27.1225	26.805	27.0838	28044384.0
2016-09-07 15:30:00	AAPL	Stock	27.083	27.19	27.0425	27.0925	28919952.0
2016-09-07 16:00:00	AAPL	Stock	27.09	27.1025	26.8505	27.095	5446068.0
2016-09-07 16:30:00	AAPL	Stock	27.0975	27.1	27.085	27.095	123636.0
2016-09-07 17:00:00	AAPL	Stock	27.0875	27.1025	27.0875	27.1	106612.0
2016-09-07 17:30:00	AAPL	Stock	27.1	27.1	27.085	27.0875	82560.0
2016-09-07 18:00:00	AAPL	Stock	27.0875	27.0875	27.0825	27.0825	56384.0
2016-09-07 18:30:00	AAPL	Stock	27.0825	27.09	27.075	27.0775	26100.0
2016-09-07 19:00:00	AAPL	Stock	27.075	27.075	27.0475	27.065	73308.0
2016-09-07 19:30:00	AAPL	Stock	27.0675	27.0725	27.0375	27.0375	67704.0
2016-09-07 05:30:00	MSFT	Stock	57.63	57.65	57.63	57.65	250.0
2016-09-07 07:00:00	MSFT	Stock	57.62	57.62	57.62	57.62	500.0
2016-09-07 08:00:00	MSFT	Stock	57.6	57.6	57.6	57.6	410.0
2016-09-07 09:00:00	MSFT	Stock	57.62	57.65	57.5	57.5	14647.0
2016-09-07 09:30:00	MSFT	Stock	57.47	57.59	57.405	57.585	1813732.0
2016-09-07 10:00:00	MSFT	Stock	57.58	57.84	57.53	57.77	1630810.0
2016-09-07 10:30:00	MSFT	Stock	57.77	57.79	57.62	57.62	1470945.0
2016-09-07 11:00:00	MSFT	Stock	57.62	57.678	57.55	57.6	890874.0
2016-09-07 11:30:00	MSFT	Stock	57.6	57.61	57.53	57.57	647394.0
2016-09-07 12:00:00	MSFT	Stock	57.57	57.58	57.5	57.57	795338.0
2016-09-07 12:30:00	MSFT	Stock	57.56	57.62	57.55	57.575	587880.0
2016-09-07 13:00:00	MSFT	Stock	57.58	57.625	57.56	57.6	612132.0
2016-09-07 13:30:00	MSFT	Stock	57.595	57.64	57.58	57.586	558165.0
2016-09-07 14:00:00	MSFT	Stock	57.58	57.65	57.56	57.6	639383.0
2016-09-07 14:30:00	MSFT	Stock	57.6	57.62	57.55	57.57	800030.0
2016-09-07 15:00:00	MSFT	Stock	57.56	57.59	57.505	57.55	997599.0
2016-09-07 15:30:00	MSFT	Stock	57.55	57.65	57.53	57.65	3200149.0
2016-09-07 16:00:00	MSFT	Stock	57.66	57.66	57.6	57.66	1742646.0

> showing 50 of 83,729 rows — these rows as CSV

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