PREVIEW / etf_30min / 2016-06-09

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-09.parquet
  size:    387 KB
  rows:    13,246

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-09 04:00:00	SPY	ETF	211.66	211.66	211.51	211.54	5829.0
2016-06-09 04:30:00	SPY	ETF	211.53	211.69	211.53	211.68	3703.0
2016-06-09 05:00:00	SPY	ETF	211.69	211.73	211.64	211.64	14278.0
2016-06-09 05:30:00	SPY	ETF	211.63	211.69	211.6	211.67	7721.0
2016-06-09 06:00:00	SPY	ETF	211.6	211.6	211.56	211.56	3301.0
2016-06-09 06:30:00	SPY	ETF	211.59	211.72	211.59	211.72	50783.0
2016-06-09 07:00:00	SPY	ETF	211.71	211.74	211.66	211.66	26852.0
2016-06-09 07:30:00	SPY	ETF	211.68	211.68	211.52	211.6	187095.0
2016-06-09 08:00:00	SPY	ETF	211.6	211.971	211.41	211.5	559577.0
2016-06-09 08:30:00	SPY	ETF	211.51	211.6	211.4	211.49	266639.0
2016-06-09 09:00:00	SPY	ETF	211.49	211.55	211.37	211.51	562748.0
2016-06-09 09:30:00	SPY	ETF	211.51	211.8	211.37	211.71	9463978.0
2016-06-09 10:00:00	SPY	ETF	211.7	211.7001	211.31	211.39	5733770.0
2016-06-09 10:30:00	SPY	ETF	211.4	211.68	211.27	211.515	4999721.0
2016-06-09 11:00:00	SPY	ETF	211.515	211.76	211.4	211.429	4960483.0
2016-06-09 11:30:00	SPY	ETF	211.425	211.49	211.24	211.35	5466738.0
2016-06-09 12:00:00	SPY	ETF	211.35	211.46	211.19	211.45	5730940.0
2016-06-09 12:30:00	SPY	ETF	211.45	211.74	211.41	211.7	4252616.0
2016-06-09 13:00:00	SPY	ETF	211.7	211.98	211.62	211.91	3039584.0
2016-06-09 13:30:00	SPY	ETF	211.9	211.98	211.53	211.73	2902908.0
2016-06-09 14:00:00	SPY	ETF	211.72	211.93	211.6	211.76	6435844.0
2016-06-09 14:30:00	SPY	ETF	211.76	212.1	211.75	212.005	4074832.0
2016-06-09 15:00:00	SPY	ETF	212.005	212.14	211.9	212.03	3386556.0
2016-06-09 15:30:00	SPY	ETF	212.035	212.22	212.0	212.01	7004016.0
2016-06-09 16:00:00	SPY	ETF	212.01	212.14	211.863	211.9973	2971039.0
2016-06-09 16:30:00	SPY	ETF	211.98	211.98	211.9	211.94	196092.0
2016-06-09 17:00:00	SPY	ETF	211.94	211.98	211.92	211.93	152086.0
2016-06-09 17:30:00	SPY	ETF	211.93	211.96	211.91	211.92	21652.0
2016-06-09 18:00:00	SPY	ETF	211.91	211.92	211.77	211.77	50090.0
2016-06-09 18:30:00	SPY	ETF	211.76	211.79	211.73	211.79	20431.0
2016-06-09 19:00:00	SPY	ETF	211.8	211.87	211.8	211.87	11555.0
2016-06-09 19:30:00	SPY	ETF	211.87	211.89	211.77	211.85	17455.0
2016-06-09 04:00:00	QQQ	ETF	110.1	110.1	109.96	109.96	643.0
2016-06-09 04:30:00	QQQ	ETF	109.93	109.96	109.93	109.96	400.0
2016-06-09 05:00:00	QQQ	ETF	110.01	110.01	110.01	110.01	143.0
2016-06-09 05:30:00	QQQ	ETF	109.98	109.98	109.98	109.98	100.0
2016-06-09 07:00:00	QQQ	ETF	110.03	110.04	110.03	110.04	999.0
2016-06-09 07:30:00	QQQ	ETF	110.03	110.03	109.98	110.01	4202.0
2016-06-09 08:00:00	QQQ	ETF	110.03	110.04	109.91	109.93	78643.0
2016-06-09 08:30:00	QQQ	ETF	109.93	110.01	109.91	109.93	42039.0
2016-06-09 09:00:00	QQQ	ETF	109.93	109.96	109.88	109.93	93739.0
2016-06-09 09:30:00	QQQ	ETF	109.93	110.3097	109.86	110.24	2247945.0
2016-06-09 10:00:00	QQQ	ETF	110.24	110.24	110.04	110.08	1110096.0
2016-06-09 10:30:00	QQQ	ETF	110.08	110.29	109.95	110.17	1146454.0
2016-06-09 11:00:00	QQQ	ETF	110.16	110.27	110.05	110.08	817805.0
2016-06-09 11:30:00	QQQ	ETF	110.07	110.1338	109.91	109.97	1740722.0
2016-06-09 12:00:00	QQQ	ETF	109.97	109.97	109.71	109.83	1692392.0
2016-06-09 12:30:00	QQQ	ETF	109.836	110.09	109.82	110.065	838388.0
2016-06-09 13:00:00	QQQ	ETF	110.07	110.28	110.02	110.22	1187542.0
2016-06-09 13:30:00	QQQ	ETF	110.21	110.27	109.8989	110.0501	941015.0

> showing 50 of 13,246 rows — these rows as CSV

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