PREVIEW / stock_30min / 2017-08-08

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-08.parquet
  size:    1.6 MB
  rows:    81,314
  symbols: 2,999

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-08-08 06:00:00	AAPL	Stock	39.6875	39.6875	39.63	39.63	6928.0
2017-08-08 06:30:00	AAPL	Stock	39.695	39.695	39.65	39.65	800.0
2017-08-08 07:00:00	AAPL	Stock	39.675	39.675	39.625	39.625	19884.0
2017-08-08 07:30:00	AAPL	Stock	39.625	39.625	39.5875	39.625	24268.0
2017-08-08 08:00:00	AAPL	Stock	39.65	39.6825	39.6125	39.6575	97928.0
2017-08-08 08:30:00	AAPL	Stock	39.6575	39.6575	39.6175	39.6425	60768.0
2017-08-08 09:00:00	AAPL	Stock	39.65	39.675	39.6325	39.6425	94320.0
2017-08-08 09:30:00	AAPL	Stock	39.6525	39.8888	39.5675	39.8575	13947644.0
2017-08-08 10:00:00	AAPL	Stock	39.86	40.0825	39.8475	40.05	15576620.0
2017-08-08 10:30:00	AAPL	Stock	40.0375	40.295	40.005	40.2912	15837672.0
2017-08-08 11:00:00	AAPL	Stock	40.2875	40.355	40.26	40.2925	11056820.0
2017-08-08 11:30:00	AAPL	Stock	40.2925	40.4575	40.2875	40.3612	10790664.0
2017-08-08 12:00:00	AAPL	Stock	40.36	40.4378	40.3125	40.36	6958732.0
2017-08-08 12:30:00	AAPL	Stock	40.3615	40.365	40.2375	40.3	6830004.0
2017-08-08 13:00:00	AAPL	Stock	40.2983	40.33	40.155	40.215	7166792.0
2017-08-08 13:30:00	AAPL	Stock	40.215	40.3073	40.1625	40.294	4652636.0
2017-08-08 14:00:00	AAPL	Stock	40.295	40.325	40.2472	40.2735	3314628.0
2017-08-08 14:30:00	AAPL	Stock	40.275	40.32	40.2625	40.305	3841316.0
2017-08-08 15:00:00	AAPL	Stock	40.305	40.3095	40.035	40.1075	8153092.0
2017-08-08 15:30:00	AAPL	Stock	40.1075	40.115	39.8775	40.025	17506756.0
2017-08-08 16:00:00	AAPL	Stock	40.02	40.1355	39.8825	39.9275	4926024.0
2017-08-08 16:30:00	AAPL	Stock	39.9275	40.02	39.925	40.0	231744.0
2017-08-08 17:00:00	AAPL	Stock	39.9775	40.0	39.9475	39.95	35216.0
2017-08-08 17:30:00	AAPL	Stock	39.94	39.99	39.94	39.98	46628.0
2017-08-08 18:00:00	AAPL	Stock	39.975	39.98	39.925	39.925	71572.0
2017-08-08 18:30:00	AAPL	Stock	39.9275	39.9375	39.9175	39.9175	61764.0
2017-08-08 19:00:00	AAPL	Stock	39.925	39.9425	39.9125	39.9125	38312.0
2017-08-08 19:30:00	AAPL	Stock	39.9	39.9125	39.845	39.885	66960.0
2017-08-08 07:30:00	MSFT	Stock	72.4	72.4	72.4	72.4	100.0
2017-08-08 08:00:00	MSFT	Stock	72.3	72.3	72.25	72.28	6712.0
2017-08-08 08:30:00	MSFT	Stock	72.28	72.3	72.22	72.25	17673.0
2017-08-08 09:00:00	MSFT	Stock	72.25	72.29	72.09	72.09	5216.0
2017-08-08 09:30:00	MSFT	Stock	72.09	72.41	71.75	72.335	3041467.0
2017-08-08 10:00:00	MSFT	Stock	72.34	72.49	72.23	72.3	946610.0
2017-08-08 10:30:00	MSFT	Stock	72.305	72.55	72.23	72.54	1017119.0
2017-08-08 11:00:00	MSFT	Stock	72.531	72.58	72.44	72.565	810376.0
2017-08-08 11:30:00	MSFT	Stock	72.56	72.985	72.56	72.943	1121785.0
2017-08-08 12:00:00	MSFT	Stock	72.945	73.09	72.9	73.05	1166585.0
2017-08-08 12:30:00	MSFT	Stock	73.045	73.13	72.94	72.94	785981.0
2017-08-08 13:00:00	MSFT	Stock	72.94	73.08	72.93	72.95	809343.0
2017-08-08 13:30:00	MSFT	Stock	72.945	73.09	72.9	73.02	807014.0
2017-08-08 14:00:00	MSFT	Stock	73.02	73.06	72.98	73.02	712581.0
2017-08-08 14:30:00	MSFT	Stock	73.02	73.06	72.895	72.955	803724.0
2017-08-08 15:00:00	MSFT	Stock	72.955	73.01	72.69	72.79	1486213.0
2017-08-08 15:30:00	MSFT	Stock	72.79	72.82	72.53	72.78	3449438.0
2017-08-08 16:00:00	MSFT	Stock	72.79	72.85	72.65	72.65	3249777.0
2017-08-08 16:30:00	MSFT	Stock	72.79	72.79	72.61	72.61	2310.0
2017-08-08 17:00:00	MSFT	Stock	72.65	72.75	72.65	72.75	1085.0
2017-08-08 17:30:00	MSFT	Stock	72.66	72.66	72.66	72.66	2371.0
2017-08-08 18:00:00	MSFT	Stock	72.65	72.65	72.65	72.65	254.0

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

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