PREVIEW / stock_30min / 2015-09-17

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-17.parquet
  size:    1.6 MB
  rows:    81,613
  symbols: 3,443

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-09-17 04:00:00	AAPL	Stock	29.05	29.0975	29.05	29.0975	17376.0
2015-09-17 04:30:00	AAPL	Stock	29.0825	29.0825	29.0575	29.0675	6320.0
2015-09-17 05:00:00	AAPL	Stock	29.0775	29.08	29.0425	29.08	21316.0
2015-09-17 05:30:00	AAPL	Stock	29.0825	29.095	29.0325	29.05	14400.0
2015-09-17 06:00:00	AAPL	Stock	29.06	29.065	29.0425	29.065	8480.0
2015-09-17 06:30:00	AAPL	Stock	29.07	29.0875	28.9775	28.9775	58148.0
2015-09-17 07:00:00	AAPL	Stock	28.975	29.01	28.975	29.0	65012.0
2015-09-17 07:30:00	AAPL	Stock	29.0	29.0	28.89	28.9	144304.0
2015-09-17 08:00:00	AAPL	Stock	28.9	29.0125	28.9	28.915	448848.0
2015-09-17 08:30:00	AAPL	Stock	28.94	28.9475	28.8875	28.915	446124.0
2015-09-17 09:00:00	AAPL	Stock	28.915	28.9625	28.9025	28.9025	314892.0
2015-09-17 09:30:00	AAPL	Stock	28.915	28.95	28.7925	28.83	21566392.0
2015-09-17 10:00:00	AAPL	Stock	28.83	28.9175	28.825	28.835	10940772.0
2015-09-17 10:30:00	AAPL	Stock	28.83	28.875	28.769	28.8662	11009088.0
2015-09-17 11:00:00	AAPL	Stock	28.8672	28.9225	28.8375	28.8972	8059760.0
2015-09-17 11:30:00	AAPL	Stock	28.8975	28.915	28.8275	28.885	7878396.0
2015-09-17 12:00:00	AAPL	Stock	28.8862	28.915	28.8675	28.8975	4658740.0
2015-09-17 12:30:00	AAPL	Stock	28.9	28.935	28.825	28.8625	7068108.0
2015-09-17 13:00:00	AAPL	Stock	28.86	28.9025	28.825	28.861	7819860.0
2015-09-17 13:30:00	AAPL	Stock	28.8625	28.885	28.785	28.8225	10263356.0
2015-09-17 14:00:00	AAPL	Stock	28.825	29.0	28.6675	28.775	35028980.0
2015-09-17 14:30:00	AAPL	Stock	28.7775	29.105	28.77	29.055	27152888.0
2015-09-17 15:00:00	AAPL	Stock	29.0525	29.1225	28.7025	28.7825	29440536.0
2015-09-17 15:30:00	AAPL	Stock	28.78	28.815	28.4288	28.4825	40758488.0
2015-09-17 16:00:00	AAPL	Stock	28.48	28.53	28.475	28.4925	11981492.0
2015-09-17 16:30:00	AAPL	Stock	28.4975	28.5125	28.48	28.5	397828.0
2015-09-17 17:00:00	AAPL	Stock	28.4975	28.52	28.4825	28.4825	188128.0
2015-09-17 17:30:00	AAPL	Stock	28.485	28.4975	28.4775	28.495	117132.0
2015-09-17 18:00:00	AAPL	Stock	28.49	28.495	28.48	28.48	82480.0
2015-09-17 18:30:00	AAPL	Stock	28.49	28.55	28.48	28.54	149228.0
2015-09-17 19:00:00	AAPL	Stock	28.5375	28.5425	28.505	28.525	78696.0
2015-09-17 19:30:00	AAPL	Stock	28.5225	28.5375	28.5025	28.53	84088.0
2015-09-17 05:00:00	MSFT	Stock	44.3	44.3	44.3	44.3	100.0
2015-09-17 06:30:00	MSFT	Stock	44.3	44.3	44.3	44.3	100.0
2015-09-17 07:00:00	MSFT	Stock	44.31	44.31	44.31	44.31	100.0
2015-09-17 07:30:00	MSFT	Stock	44.32	44.32	44.3	44.3	800.0
2015-09-17 08:00:00	MSFT	Stock	44.29	44.29	44.2	44.25	2402.0
2015-09-17 08:30:00	MSFT	Stock	44.3	44.31	44.23	44.31	8185.0
2015-09-17 09:00:00	MSFT	Stock	44.31	44.37	44.27	44.3	5150.0
2015-09-17 09:30:00	MSFT	Stock	44.28	44.49	44.185	44.4	1855843.0
2015-09-17 10:00:00	MSFT	Stock	44.39	44.65	44.35	44.583	1427766.0
2015-09-17 10:30:00	MSFT	Stock	44.59	44.6	44.39	44.435	985244.0
2015-09-17 11:00:00	MSFT	Stock	44.43	44.635	44.4	44.585	1171924.0
2015-09-17 11:30:00	MSFT	Stock	44.58	44.6	44.43	44.43	1147705.0
2015-09-17 12:00:00	MSFT	Stock	44.43	44.61	44.43	44.54	811138.0
2015-09-17 12:30:00	MSFT	Stock	44.53	44.57	44.41	44.55	531817.0
2015-09-17 13:00:00	MSFT	Stock	44.54	44.64	44.48	44.564	706585.0
2015-09-17 13:30:00	MSFT	Stock	44.56	44.64	44.49	44.54	1192630.0
2015-09-17 14:00:00	MSFT	Stock	44.528	44.85	44.08	44.4	2943614.0
2015-09-17 14:30:00	MSFT	Stock	44.41	45.0	44.4	44.85	2886710.0

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

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