PREVIEW / stock_30min / 2017-07-26

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-26.parquet
  size:    1.6 MB
  rows:    80,611
  symbols: 2,991

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-07-26 04:00:00	AAPL	Stock	38.26	38.3225	38.26	38.3225	2400.0
2017-07-26 06:00:00	AAPL	Stock	38.2875	38.2875	38.2875	38.2875	400.0
2017-07-26 07:00:00	AAPL	Stock	38.3025	38.34	38.3025	38.325	4128.0
2017-07-26 07:30:00	AAPL	Stock	38.3125	38.325	38.2875	38.31	10736.0
2017-07-26 08:00:00	AAPL	Stock	38.325	38.335	38.3	38.33	105900.0
2017-07-26 08:30:00	AAPL	Stock	38.3425	38.355	38.3	38.335	39964.0
2017-07-26 09:00:00	AAPL	Stock	38.335	38.37	38.3125	38.3375	152348.0
2017-07-26 09:30:00	AAPL	Stock	38.3375	38.4825	38.265	38.3575	8469492.0
2017-07-26 10:00:00	AAPL	Stock	38.3572	38.4825	38.3475	38.405	6473392.0
2017-07-26 10:30:00	AAPL	Stock	38.405	38.44	38.2875	38.2968	4209336.0
2017-07-26 11:00:00	AAPL	Stock	38.2972	38.41	38.295	38.3575	3701812.0
2017-07-26 11:30:00	AAPL	Stock	38.3555	38.375	38.325	38.365	2672448.0
2017-07-26 12:00:00	AAPL	Stock	38.3688	38.445	38.3525	38.4162	2866912.0
2017-07-26 12:30:00	AAPL	Stock	38.4165	38.4375	38.3768	38.4	1993904.0
2017-07-26 13:00:00	AAPL	Stock	38.4	38.4075	38.355	38.37	1497224.0
2017-07-26 13:30:00	AAPL	Stock	38.37	38.3975	38.34	38.3575	1440600.0
2017-07-26 14:00:00	AAPL	Stock	38.3525	38.45	38.3275	38.4425	2876076.0
2017-07-26 14:30:00	AAPL	Stock	38.4425	38.45	38.385	38.39	2380936.0
2017-07-26 15:00:00	AAPL	Stock	38.3875	38.4255	38.37	38.3738	1970472.0
2017-07-26 15:30:00	AAPL	Stock	38.375	38.3875	38.3062	38.375	5544724.0
2017-07-26 16:00:00	AAPL	Stock	38.375	38.425	38.3	38.3725	10106816.0
2017-07-26 16:30:00	AAPL	Stock	38.3875	38.4175	38.375	38.4125	41352.0
2017-07-26 17:00:00	AAPL	Stock	38.4125	38.425	38.365	38.425	323436.0
2017-07-26 17:30:00	AAPL	Stock	38.4325	38.45	38.4325	38.45	64920.0
2017-07-26 18:00:00	AAPL	Stock	38.445	38.4625	38.4375	38.4625	47192.0
2017-07-26 18:30:00	AAPL	Stock	38.4625	38.48	38.4525	38.455	15740.0
2017-07-26 19:00:00	AAPL	Stock	38.455	38.4625	38.45	38.45	4644.0
2017-07-26 19:30:00	AAPL	Stock	38.4625	38.48	38.445	38.4575	56000.0
2017-07-26 04:00:00	MSFT	Stock	74.2	74.2	74.2	74.2	100.0
2017-07-26 05:30:00	MSFT	Stock	74.28	74.28	74.28	74.28	100.0
2017-07-26 08:00:00	MSFT	Stock	74.2	74.33	74.2	74.31	11165.0
2017-07-26 08:30:00	MSFT	Stock	74.31	74.33	74.29	74.33	2363.0
2017-07-26 09:00:00	MSFT	Stock	74.33	74.33	74.2	74.2	17413.0
2017-07-26 09:30:00	MSFT	Stock	74.34	74.38	74.06	74.19	1905411.0
2017-07-26 10:00:00	MSFT	Stock	74.195	74.3	74.16	74.23	1182446.0
2017-07-26 10:30:00	MSFT	Stock	74.23	74.27	74.07	74.075	940118.0
2017-07-26 11:00:00	MSFT	Stock	74.08	74.17	74.01	74.06	938867.0
2017-07-26 11:30:00	MSFT	Stock	74.051	74.07	73.95	73.98	837042.0
2017-07-26 12:00:00	MSFT	Stock	73.985	74.15	73.975	74.09	811491.0
2017-07-26 12:30:00	MSFT	Stock	74.09	74.1	73.95	73.96	866885.0
2017-07-26 13:00:00	MSFT	Stock	73.96	73.98	73.86	73.92	421401.0
2017-07-26 13:30:00	MSFT	Stock	73.91	74.045	73.9	73.9	521552.0
2017-07-26 14:00:00	MSFT	Stock	73.905	74.03	73.81	73.996	847212.0
2017-07-26 14:30:00	MSFT	Stock	73.99	74.0	73.86	73.895	739130.0
2017-07-26 15:00:00	MSFT	Stock	73.89	73.99	73.87	73.95	797337.0
2017-07-26 15:30:00	MSFT	Stock	73.94	74.05	73.84	74.05	1854438.0
2017-07-26 16:00:00	MSFT	Stock	74.05	74.06	73.89	74.05	1912212.0
2017-07-26 16:30:00	MSFT	Stock	73.91	74.0	73.91	74.0	2307.0
2017-07-26 17:00:00	MSFT	Stock	73.95	74.05	73.94	74.05	159205.0
2017-07-26 17:30:00	MSFT	Stock	73.98	73.98	73.93	73.93	594.0

> showing 50 of 80,611 rows — these rows as CSV

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