PREVIEW / stock_30min / 2016-03-31

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-31.parquet
  size:    1.6 MB
  rows:    81,698
  symbols: 3,381

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-03-31 05:30:00	AAPL	Stock	27.355	27.355	27.355	27.355	400.0
2016-03-31 06:00:00	AAPL	Stock	27.355	27.355	27.3	27.32	18032.0
2016-03-31 06:30:00	AAPL	Stock	27.3125	27.3125	27.2225	27.245	87704.0
2016-03-31 07:00:00	AAPL	Stock	27.2625	27.325	27.25	27.305	28400.0
2016-03-31 07:30:00	AAPL	Stock	27.3225	27.3525	27.3	27.3525	91848.0
2016-03-31 08:00:00	AAPL	Stock	27.335	27.375	27.3	27.355	206840.0
2016-03-31 08:30:00	AAPL	Stock	27.35	27.3675	27.33	27.3375	70812.0
2016-03-31 09:00:00	AAPL	Stock	27.3475	27.435	27.3325	27.425	340132.0
2016-03-31 09:30:00	AAPL	Stock	27.43	27.475	27.2725	27.2875	13787148.0
2016-03-31 10:00:00	AAPL	Stock	27.29	27.4225	27.2375	27.3912	10358492.0
2016-03-31 10:30:00	AAPL	Stock	27.3912	27.4575	27.3675	27.435	4811708.0
2016-03-31 11:00:00	AAPL	Stock	27.435	27.45	27.2625	27.2725	6501912.0
2016-03-31 11:30:00	AAPL	Stock	27.2725	27.41	27.2725	27.3788	6645800.0
2016-03-31 12:00:00	AAPL	Stock	27.38	27.3938	27.33	27.3425	4058236.0
2016-03-31 12:30:00	AAPL	Stock	27.34	27.345	27.305	27.3088	2688052.0
2016-03-31 13:00:00	AAPL	Stock	27.3088	27.345	27.2875	27.295	3730976.0
2016-03-31 13:30:00	AAPL	Stock	27.295	27.325	27.2625	27.2902	4281156.0
2016-03-31 14:00:00	AAPL	Stock	27.29	27.32	27.2675	27.295	3516228.0
2016-03-31 14:30:00	AAPL	Stock	27.2975	27.3185	27.275	27.3125	3587496.0
2016-03-31 15:00:00	AAPL	Stock	27.3128	27.3462	27.29	27.32	3874380.0
2016-03-31 15:30:00	AAPL	Stock	27.32	27.3475	27.22	27.24	11603368.0
2016-03-31 16:00:00	AAPL	Stock	27.2475	27.2625	27.23	27.25	13907040.0
2016-03-31 16:30:00	AAPL	Stock	27.25	27.265	27.24	27.2625	55580.0
2016-03-31 17:00:00	AAPL	Stock	27.255	27.2625	27.2475	27.25	13900.0
2016-03-31 17:30:00	AAPL	Stock	27.2475	27.26	27.2475	27.26	13620.0
2016-03-31 18:00:00	AAPL	Stock	27.26	27.27	27.26	27.27	9836.0
2016-03-31 18:30:00	AAPL	Stock	27.2625	27.2675	27.2475	27.2675	18176.0
2016-03-31 19:00:00	AAPL	Stock	27.2675	27.27	27.2575	27.2575	11164.0
2016-03-31 19:30:00	AAPL	Stock	27.2575	27.285	27.2575	27.2575	16124.0
2016-03-31 06:30:00	MSFT	Stock	54.85	54.98	54.55	54.98	1647.0
2016-03-31 07:00:00	MSFT	Stock	55.03	55.12	54.98	55.12	700.0
2016-03-31 07:30:00	MSFT	Stock	54.94	54.94	54.9	54.9	500.0
2016-03-31 08:00:00	MSFT	Stock	54.55	55.25	54.55	55.25	8606.0
2016-03-31 08:30:00	MSFT	Stock	55.18	55.28	55.18	55.28	2100.0
2016-03-31 09:00:00	MSFT	Stock	55.2	55.23	54.82	54.83	16602.0
2016-03-31 09:30:00	MSFT	Stock	54.83	55.18	54.83	55.13	4204425.0
2016-03-31 10:00:00	MSFT	Stock	55.136	55.4	55.06	55.27	1272122.0
2016-03-31 10:30:00	MSFT	Stock	55.26	55.5	55.25	55.495	940125.0
2016-03-31 11:00:00	MSFT	Stock	55.5	55.59	55.365	55.43	1598097.0
2016-03-31 11:30:00	MSFT	Stock	55.435	55.46	55.29	55.309	1057334.0
2016-03-31 12:00:00	MSFT	Stock	55.31	55.47	55.29	55.45	1146382.0
2016-03-31 12:30:00	MSFT	Stock	55.45	55.48	55.33	55.339	676797.0
2016-03-31 13:00:00	MSFT	Stock	55.335	55.34	55.25	55.285	596958.0
2016-03-31 13:30:00	MSFT	Stock	55.285	55.36	55.25	55.265	811962.0
2016-03-31 14:00:00	MSFT	Stock	55.26	55.3	55.1	55.1	1153130.0
2016-03-31 14:30:00	MSFT	Stock	55.11	55.19	55.075	55.17	923445.0
2016-03-31 15:00:00	MSFT	Stock	55.17	55.27	55.14	55.23	1359253.0
2016-03-31 15:30:00	MSFT	Stock	55.235	55.4	55.18	55.23	3906287.0
2016-03-31 16:00:00	MSFT	Stock	55.23	55.32	55.225	55.23	4508473.0
2016-03-31 16:30:00	MSFT	Stock	55.23	55.3	55.23	55.3	36800.0

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

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