PREVIEW / stock_30min / 2015-10-22

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-10-22.parquet
  size:    1.6 MB
  rows:    81,849
  symbols: 3,416

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-10-22 06:00:00	AAPL	Stock	28.525	28.5475	28.525	28.525	8600.0
2015-10-22 06:30:00	AAPL	Stock	28.4775	28.4775	28.4775	28.4775	400.0
2015-10-22 07:00:00	AAPL	Stock	28.5125	28.525	28.5	28.5	7820.0
2015-10-22 07:30:00	AAPL	Stock	28.5	28.5	28.4725	28.495	36900.0
2015-10-22 08:00:00	AAPL	Stock	28.49	28.58	28.3875	28.555	200000.0
2015-10-22 08:30:00	AAPL	Stock	28.5375	28.6225	28.515	28.62	252372.0
2015-10-22 09:00:00	AAPL	Stock	28.6075	28.63	28.5575	28.6025	504368.0
2015-10-22 09:30:00	AAPL	Stock	28.5825	28.745	28.535	28.6725	18460976.0
2015-10-22 10:00:00	AAPL	Stock	28.6725	28.7	28.587	28.64	10354536.0
2015-10-22 10:30:00	AAPL	Stock	28.6425	28.795	28.6325	28.765	12157280.0
2015-10-22 11:00:00	AAPL	Stock	28.7625	28.7975	28.6425	28.645	9509812.0
2015-10-22 11:30:00	AAPL	Stock	28.645	28.73	28.525	28.6775	15663996.0
2015-10-22 12:00:00	AAPL	Stock	28.68	28.7625	28.68	28.7598	8705980.0
2015-10-22 12:30:00	AAPL	Stock	28.76	28.78	28.7325	28.7548	8191572.0
2015-10-22 13:00:00	AAPL	Stock	28.755	28.7775	28.6625	28.6925	8235464.0
2015-10-22 13:30:00	AAPL	Stock	28.6925	28.7425	28.6862	28.715	6703660.0
2015-10-22 14:00:00	AAPL	Stock	28.715	28.7275	28.635	28.7012	8836352.0
2015-10-22 14:30:00	AAPL	Stock	28.7025	28.86	28.685	28.86	11586240.0
2015-10-22 15:00:00	AAPL	Stock	28.86	28.8725	28.8002	28.8625	9976116.0
2015-10-22 15:30:00	AAPL	Stock	28.8625	28.875	28.81	28.8725	16058712.0
2015-10-22 16:00:00	AAPL	Stock	28.875	29.04	28.84	29.0125	9373840.0
2015-10-22 16:30:00	AAPL	Stock	29.0125	29.035	28.9725	28.9825	292056.0
2015-10-22 17:00:00	AAPL	Stock	29.0	29.0	28.9625	28.9875	175036.0
2015-10-22 17:30:00	AAPL	Stock	28.9875	29.035	28.975	29.02	190780.0
2015-10-22 18:00:00	AAPL	Stock	29.015	29.05	29.0	29.05	114204.0
2015-10-22 18:30:00	AAPL	Stock	29.055	29.07	29.05	29.07	66388.0
2015-10-22 19:00:00	AAPL	Stock	29.0725	29.085	29.04	29.045	138332.0
2015-10-22 19:30:00	AAPL	Stock	29.0475	29.1375	29.0475	29.125	137164.0
2015-10-22 07:30:00	MSFT	Stock	47.4	47.4	47.39	47.39	200.0
2015-10-22 08:00:00	MSFT	Stock	47.3	47.34	47.3	47.34	8325.0
2015-10-22 08:30:00	MSFT	Stock	47.34	47.45	47.32	47.44	6092.0
2015-10-22 09:00:00	MSFT	Stock	47.4	47.53	47.4	47.53	60804.0
2015-10-22 09:30:00	MSFT	Stock	47.52	47.975	47.09	47.965	5222912.0
2015-10-22 10:00:00	MSFT	Stock	47.94	48.18	47.876	48.06	3716808.0
2015-10-22 10:30:00	MSFT	Stock	48.06	48.64	47.9	48.54	4406902.0
2015-10-22 11:00:00	MSFT	Stock	48.54	48.68	48.383	48.484	2410319.0
2015-10-22 11:30:00	MSFT	Stock	48.49	48.705	48.48	48.575	2164693.0
2015-10-22 12:00:00	MSFT	Stock	48.58	48.75	48.474	48.715	2416571.0
2015-10-22 12:30:00	MSFT	Stock	48.72	48.77	48.625	48.69	2073902.0
2015-10-22 13:00:00	MSFT	Stock	48.7	48.95	48.63	48.69	2627507.0
2015-10-22 13:30:00	MSFT	Stock	48.688	48.78	48.62	48.735	2109003.0
2015-10-22 14:00:00	MSFT	Stock	48.73	48.79	48.63	48.76	2086237.0
2015-10-22 14:30:00	MSFT	Stock	48.76	48.77	48.39	48.59	3382993.0
2015-10-22 15:00:00	MSFT	Stock	48.6	48.61	48.09	48.29	5043918.0
2015-10-22 15:30:00	MSFT	Stock	48.3	48.75	47.57	48.03	10879983.0
2015-10-22 16:00:00	MSFT	Stock	48.01	51.09	46.4	50.82	3771654.0
2015-10-22 16:30:00	MSFT	Stock	50.79	51.9	50.64	51.0	1118679.0
2015-10-22 17:00:00	MSFT	Stock	51.0	51.75	51.0	51.5	252725.0
2015-10-22 17:30:00	MSFT	Stock	51.51	51.6	51.2	51.4	114737.0
2015-10-22 18:00:00	MSFT	Stock	51.37	52.7	51.11	51.95	280376.0

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

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