PREVIEW / stock_30min / 2017-04-19

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-19.parquet
  size:    1.6 MB
  rows:    81,153
  symbols: 3,060

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-04-19 04:30:00	AAPL	Stock	35.35	35.38	35.35	35.38	3304.0
2017-04-19 05:00:00	AAPL	Stock	35.35	35.35	35.35	35.35	560.0
2017-04-19 06:30:00	AAPL	Stock	35.4	35.4	35.375	35.4	1860.0
2017-04-19 07:00:00	AAPL	Stock	35.3875	35.3875	35.3875	35.3875	5160.0
2017-04-19 07:30:00	AAPL	Stock	35.3975	35.405	35.39	35.4	11200.0
2017-04-19 08:00:00	AAPL	Stock	35.395	35.4875	35.395	35.485	60072.0
2017-04-19 08:30:00	AAPL	Stock	35.485	35.4875	35.455	35.4725	110112.0
2017-04-19 09:00:00	AAPL	Stock	35.4725	35.4725	35.435	35.455	97152.0
2017-04-19 09:30:00	AAPL	Stock	35.47	35.5	35.38	35.45	9348512.0
2017-04-19 10:00:00	AAPL	Stock	35.45	35.475	35.4	35.4062	3670064.0
2017-04-19 10:30:00	AAPL	Stock	35.4075	35.4325	35.38	35.4125	3741628.0
2017-04-19 11:00:00	AAPL	Stock	35.4125	35.4825	35.4088	35.4825	3175552.0
2017-04-19 11:30:00	AAPL	Stock	35.4825	35.4825	35.44	35.45	2253412.0
2017-04-19 12:00:00	AAPL	Stock	35.4475	35.451	35.3275	35.3625	3372912.0
2017-04-19 12:30:00	AAPL	Stock	35.3625	35.3862	35.35	35.365	1668084.0
2017-04-19 13:00:00	AAPL	Stock	35.3675	35.3725	35.275	35.3022	3841920.0
2017-04-19 13:30:00	AAPL	Stock	35.3	35.3038	35.2525	35.255	2601288.0
2017-04-19 14:00:00	AAPL	Stock	35.255	35.2725	35.17	35.23	4654784.0
2017-04-19 14:30:00	AAPL	Stock	35.2288	35.25	35.165	35.18	3011244.0
2017-04-19 15:00:00	AAPL	Stock	35.18	35.21	35.135	35.14	3722216.0
2017-04-19 15:30:00	AAPL	Stock	35.14	35.195	35.1125	35.165	9240308.0
2017-04-19 16:00:00	AAPL	Stock	35.17	35.185	35.1575	35.175	4618580.0
2017-04-19 16:30:00	AAPL	Stock	35.1725	35.1925	35.1725	35.19	25460.0
2017-04-19 17:00:00	AAPL	Stock	35.185	35.185	35.17	35.17	19240.0
2017-04-19 17:30:00	AAPL	Stock	35.185	35.185	35.17	35.175	10740.0
2017-04-19 18:00:00	AAPL	Stock	35.185	35.1875	35.185	35.1875	13600.0
2017-04-19 18:30:00	AAPL	Stock	35.1875	35.1875	35.1725	35.175	2720.0
2017-04-19 19:00:00	AAPL	Stock	35.1925	35.21	35.1875	35.21	44200.0
2017-04-19 19:30:00	AAPL	Stock	35.215	35.235	35.1975	35.23	23228.0
2017-04-19 06:30:00	MSFT	Stock	65.6	65.6	65.55	65.55	404.0
2017-04-19 07:00:00	MSFT	Stock	65.55	65.55	65.55	65.55	900.0
2017-04-19 08:00:00	MSFT	Stock	65.5	65.5	65.5	65.5	300.0
2017-04-19 08:30:00	MSFT	Stock	65.53	65.53	65.53	65.53	532.0
2017-04-19 09:00:00	MSFT	Stock	65.57	65.68	65.57	65.67	42605.0
2017-04-19 09:30:00	MSFT	Stock	65.65	65.75	65.5	65.55	2527171.0
2017-04-19 10:00:00	MSFT	Stock	65.55	65.58	65.435	65.47	1266831.0
2017-04-19 10:30:00	MSFT	Stock	65.48	65.49	65.37	65.435	1146741.0
2017-04-19 11:00:00	MSFT	Stock	65.43	65.53	65.38	65.505	1420702.0
2017-04-19 11:30:00	MSFT	Stock	65.51	65.51	65.45	65.46	785597.0
2017-04-19 12:00:00	MSFT	Stock	65.455	65.465	65.31	65.381	958144.0
2017-04-19 12:30:00	MSFT	Stock	65.38	65.41	65.3	65.3	620631.0
2017-04-19 13:00:00	MSFT	Stock	65.3	65.32	65.2	65.246	1006007.0
2017-04-19 13:30:00	MSFT	Stock	65.25	65.28	65.16	65.24	979005.0
2017-04-19 14:00:00	MSFT	Stock	65.235	65.25	65.09	65.16	967286.0
2017-04-19 14:30:00	MSFT	Stock	65.15	65.19	64.98	65.015	1437453.0
2017-04-19 15:00:00	MSFT	Stock	65.01	65.11	64.96	64.96	1393350.0
2017-04-19 15:30:00	MSFT	Stock	64.965	65.05	64.89	65.03	3482062.0
2017-04-19 16:00:00	MSFT	Stock	65.04	65.04	65.04	65.04	1701387.0
2017-04-19 16:30:00	MSFT	Stock	65.06	65.09	65.06	65.07	3060.0
2017-04-19 17:00:00	MSFT	Stock	65.06	65.09	65.04	65.09	4206998.0

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

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