PREVIEW / stock_30min / 2016-06-17

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-17.parquet
  size:    1.6 MB
  rows:    81,735
  symbols: 3,284

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-06-17 04:00:00	AAPL	Stock	24.3675	24.3675	24.3175	24.3175	3600.0
2016-06-17 05:00:00	AAPL	Stock	24.32	24.32	24.25	24.25	18072.0
2016-06-17 05:30:00	AAPL	Stock	24.235	24.3375	24.2125	24.3375	2312.0
2016-06-17 06:00:00	AAPL	Stock	24.3325	24.3325	24.245	24.25	12120.0
2016-06-17 06:30:00	AAPL	Stock	24.2525	24.3125	24.2525	24.2525	13564.0
2016-06-17 07:00:00	AAPL	Stock	24.2575	24.2775	24.255	24.275	30960.0
2016-06-17 07:30:00	AAPL	Stock	24.2525	24.275	24.225	24.225	101292.0
2016-06-17 08:00:00	AAPL	Stock	24.295	24.3375	24.225	24.3275	256556.0
2016-06-17 08:30:00	AAPL	Stock	24.3175	24.325	23.955	23.9875	1420236.0
2016-06-17 09:00:00	AAPL	Stock	23.9875	24.2	23.85	24.1575	7848044.0
2016-06-17 09:30:00	AAPL	Stock	24.155	24.1625	23.9625	24.03	51001612.0
2016-06-17 10:00:00	AAPL	Stock	24.0275	24.045	23.8975	23.905	18703000.0
2016-06-17 10:30:00	AAPL	Stock	23.9038	23.9175	23.8388	23.8975	16705168.0
2016-06-17 11:00:00	AAPL	Stock	23.8975	23.9775	23.8425	23.8925	12387456.0
2016-06-17 11:30:00	AAPL	Stock	23.8925	23.9375	23.8775	23.906	7369224.0
2016-06-17 12:00:00	AAPL	Stock	23.9075	23.975	23.9	23.965	6262580.0
2016-06-17 12:30:00	AAPL	Stock	23.9675	23.9675	23.8938	23.9125	4986592.0
2016-06-17 13:00:00	AAPL	Stock	23.9125	23.995	23.8775	23.9575	6203840.0
2016-06-17 13:30:00	AAPL	Stock	23.96	23.9925	23.94	23.9575	4554404.0
2016-06-17 14:00:00	AAPL	Stock	23.955	23.98	23.915	23.9425	5129820.0
2016-06-17 14:30:00	AAPL	Stock	23.942	23.9775	23.931	23.954	5636460.0
2016-06-17 15:00:00	AAPL	Stock	23.9538	23.9625	23.875	23.895	8245288.0
2016-06-17 15:30:00	AAPL	Stock	23.895	23.9075	23.825	23.83	18450852.0
2016-06-17 16:00:00	AAPL	Stock	23.8325	23.8958	23.805	23.81	43953768.0
2016-06-17 16:30:00	AAPL	Stock	23.805	23.8325	23.795	23.825	502464.0
2016-06-17 17:00:00	AAPL	Stock	23.8125	23.8375	23.8075	23.825	80664.0
2016-06-17 17:30:00	AAPL	Stock	23.8175	23.835	23.81	23.8125	444544.0
2016-06-17 18:00:00	AAPL	Stock	23.8125	23.8175	23.7675	23.7825	148764.0
2016-06-17 18:30:00	AAPL	Stock	23.7875	23.7875	23.775	23.785	18508.0
2016-06-17 19:00:00	AAPL	Stock	23.775	23.775	23.755	23.765	91408.0
2016-06-17 19:30:00	AAPL	Stock	23.765	23.775	23.7525	23.7575	98860.0
2016-06-17 04:00:00	MSFT	Stock	50.25	50.25	50.25	50.25	200.0
2016-06-17 07:30:00	MSFT	Stock	50.39	50.39	50.39	50.39	500.0
2016-06-17 08:00:00	MSFT	Stock	50.31	50.42	50.31	50.41	4812.0
2016-06-17 08:30:00	MSFT	Stock	50.45	50.5	50.39	50.39	1850.0
2016-06-17 09:00:00	MSFT	Stock	50.35	50.45	50.35	50.41	10114.0
2016-06-17 09:30:00	MSFT	Stock	50.41	50.43	49.93	50.055	10939265.0
2016-06-17 10:00:00	MSFT	Stock	50.055	50.23	49.98	50.05	1735727.0
2016-06-17 10:30:00	MSFT	Stock	50.05	50.05	49.9	49.914	1817507.0
2016-06-17 11:00:00	MSFT	Stock	49.91	50.03	49.82	49.92	2519774.0
2016-06-17 11:30:00	MSFT	Stock	49.92	50.05	49.9	49.97	1946578.0
2016-06-17 12:00:00	MSFT	Stock	49.97	50.1	49.965	50.046	1185971.0
2016-06-17 12:30:00	MSFT	Stock	50.04	50.11	50.015	50.045	952406.0
2016-06-17 13:00:00	MSFT	Stock	50.05	50.23	49.96	50.17	1035838.0
2016-06-17 13:30:00	MSFT	Stock	50.165	50.28	50.15	50.245	967179.0
2016-06-17 14:00:00	MSFT	Stock	50.24	50.27	50.11	50.18	1992808.0
2016-06-17 14:30:00	MSFT	Stock	50.17	50.23	50.12	50.16	2675706.0
2016-06-17 15:00:00	MSFT	Stock	50.16	50.18	50.09	50.16	2389220.0
2016-06-17 15:30:00	MSFT	Stock	50.16	50.22	50.1	50.12	4654766.0
2016-06-17 16:00:00	MSFT	Stock	50.13	50.18	50.11	50.13	7331018.0

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

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