PREVIEW / stock_30min / 2016-10-04

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-04.parquet
  size:    1.6 MB
  rows:    81,028
  symbols: 3,206

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-10-04 04:00:00	AAPL	Stock	28.1875	28.1875	28.1875	28.1875	400.0
2016-10-04 05:00:00	AAPL	Stock	28.235	28.2375	28.235	28.2375	3924.0
2016-10-04 06:00:00	AAPL	Stock	28.205	28.205	28.1875	28.1875	816.0
2016-10-04 06:30:00	AAPL	Stock	28.175	28.175	28.175	28.175	400.0
2016-10-04 07:00:00	AAPL	Stock	28.155	28.17	28.15	28.1525	9536.0
2016-10-04 07:30:00	AAPL	Stock	28.1525	28.1525	28.11	28.11	36948.0
2016-10-04 08:00:00	AAPL	Stock	28.1875	28.1875	28.075	28.1475	70644.0
2016-10-04 08:30:00	AAPL	Stock	28.1475	28.18	28.1125	28.175	73040.0
2016-10-04 09:00:00	AAPL	Stock	28.1775	28.275	28.175	28.2525	437752.0
2016-10-04 09:30:00	AAPL	Stock	28.2525	28.5775	28.25	28.5582	23064660.0
2016-10-04 10:00:00	AAPL	Stock	28.5595	28.5625	28.4275	28.535	11833848.0
2016-10-04 10:30:00	AAPL	Stock	28.5348	28.575	28.505	28.51	8066388.0
2016-10-04 11:00:00	AAPL	Stock	28.5125	28.52	28.3372	28.42	10818520.0
2016-10-04 11:30:00	AAPL	Stock	28.42	28.4725	28.3275	28.3445	6716932.0
2016-10-04 12:00:00	AAPL	Stock	28.3438	28.3675	28.3075	28.3388	5129288.0
2016-10-04 12:30:00	AAPL	Stock	28.34	28.3825	28.2725	28.275	5576624.0
2016-10-04 13:00:00	AAPL	Stock	28.275	28.3025	28.1775	28.23	6208360.0
2016-10-04 13:30:00	AAPL	Stock	28.23	28.25	28.185	28.1962	4208416.0
2016-10-04 14:00:00	AAPL	Stock	28.195	28.3	28.1875	28.26	5448164.0
2016-10-04 14:30:00	AAPL	Stock	28.2625	28.275	28.165	28.165	4266660.0
2016-10-04 15:00:00	AAPL	Stock	28.165	28.2675	28.1575	28.2658	5796460.0
2016-10-04 15:30:00	AAPL	Stock	28.2675	28.285	28.2325	28.255	8941264.0
2016-10-04 16:00:00	AAPL	Stock	28.25	28.3905	28.2325	28.25	4608636.0
2016-10-04 16:30:00	AAPL	Stock	28.25	28.2625	28.235	28.25	104316.0
2016-10-04 17:00:00	AAPL	Stock	28.25	28.26	28.2425	28.25	59448.0
2016-10-04 17:30:00	AAPL	Stock	28.26	28.26	28.25	28.25	8580.0
2016-10-04 18:00:00	AAPL	Stock	28.2575	28.2575	28.245	28.245	10696.0
2016-10-04 18:30:00	AAPL	Stock	28.245	28.2575	28.2175	28.23	62020.0
2016-10-04 19:00:00	AAPL	Stock	28.2475	28.2475	28.22	28.23	18520.0
2016-10-04 19:30:00	AAPL	Stock	28.25	28.25	28.2225	28.2475	14900.0
2016-10-04 06:00:00	MSFT	Stock	57.42	57.42	57.4	57.4	400.0
2016-10-04 07:00:00	MSFT	Stock	57.58	57.58	57.41	57.41	1100.0
2016-10-04 07:30:00	MSFT	Stock	57.45	57.46	57.45	57.46	368.0
2016-10-04 08:30:00	MSFT	Stock	57.46	57.5	57.43	57.48	919.0
2016-10-04 09:00:00	MSFT	Stock	57.48	57.54	57.27	57.33	24825.0
2016-10-04 09:30:00	MSFT	Stock	57.32	57.595	57.27	57.56	2255913.0
2016-10-04 10:00:00	MSFT	Stock	57.55	57.56	57.205	57.295	1271079.0
2016-10-04 10:30:00	MSFT	Stock	57.29	57.55	57.274	57.46	1136247.0
2016-10-04 11:00:00	MSFT	Stock	57.47	57.49	57.11	57.245	1385147.0
2016-10-04 11:30:00	MSFT	Stock	57.25	57.45	57.18	57.265	1476596.0
2016-10-04 12:00:00	MSFT	Stock	57.26	57.4	57.24	57.271	1165754.0
2016-10-04 12:30:00	MSFT	Stock	57.28	57.374	57.2	57.228	999633.0
2016-10-04 13:00:00	MSFT	Stock	57.22	57.294	57.0	57.08	855817.0
2016-10-04 13:30:00	MSFT	Stock	57.08	57.12	57.04	57.095	773202.0
2016-10-04 14:00:00	MSFT	Stock	57.09	57.14	56.98	57.01	1277958.0
2016-10-04 14:30:00	MSFT	Stock	57.004	57.13	56.97	56.99	874645.0
2016-10-04 15:00:00	MSFT	Stock	56.99	57.155	56.97	57.15	930385.0
2016-10-04 15:30:00	MSFT	Stock	57.15	57.27	57.14	57.24	2659082.0
2016-10-04 16:00:00	MSFT	Stock	57.24	57.24	57.19	57.24	1656127.0
2016-10-04 16:30:00	MSFT	Stock	57.2	57.3	57.2	57.24	206207.0

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

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