PREVIEW / etf_1hour / 2015-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-05-18.parquet
  size:    239 KB
  rows:    7,616

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
2015-05-18 04:00:00	SPY	ETF	212.3	212.46	212.2	212.45	59636.0
2015-05-18 05:00:00	SPY	ETF	212.51	212.51	212.26	212.26	13069.0
2015-05-18 06:00:00	SPY	ETF	212.27	212.27	211.94	212.24	27441.0
2015-05-18 07:00:00	SPY	ETF	212.19	212.25	211.87	212.03	296244.0
2015-05-18 08:00:00	SPY	ETF	212.03	212.2	211.93	212.12	479549.0
2015-05-18 09:00:00	SPY	ETF	212.15	212.6	212.02	212.5499	8754321.0
2015-05-18 10:00:00	SPY	ETF	212.55	212.604	212.25	212.425	12605314.0
2015-05-18 11:00:00	SPY	ETF	212.43	212.99	212.43	212.898	9811514.0
2015-05-18 12:00:00	SPY	ETF	212.8901	212.99	212.561	212.895	3907211.0
2015-05-18 13:00:00	SPY	ETF	212.89	213.2	212.885	213.14	5446688.0
2015-05-18 14:00:00	SPY	ETF	213.15	213.28	213.09	213.235	6989799.0
2015-05-18 15:00:00	SPY	ETF	213.235	213.4	213.06	213.09	14179574.0
2015-05-18 16:00:00	SPY	ETF	213.08	213.22	212.22	213.21	5648856.0
2015-05-18 17:00:00	SPY	ETF	213.2	213.24	213.18	213.23	193494.0
2015-05-18 18:00:00	SPY	ETF	213.22	213.24	213.18	213.21	72515.0
2015-05-18 19:00:00	SPY	ETF	213.2	213.25	213.16	213.25	74930.0
2015-05-18 04:00:00	QQQ	ETF	109.45	109.45	109.4	109.4	49100.0
2015-05-18 06:00:00	QQQ	ETF	109.38	109.39	109.24	109.33	16300.0
2015-05-18 07:00:00	QQQ	ETF	109.38	109.38	109.13	109.23	163799.0
2015-05-18 08:00:00	QQQ	ETF	109.24	109.32	109.2	109.3	75616.0
2015-05-18 09:00:00	QQQ	ETF	109.3	109.64	109.25	109.6	2435876.0
2015-05-18 10:00:00	QQQ	ETF	109.6	109.6801	109.42	109.475	2066192.0
2015-05-18 11:00:00	QQQ	ETF	109.48	109.98	109.48	109.89	2286315.0
2015-05-18 12:00:00	QQQ	ETF	109.8855	109.94	109.82	109.92	1026099.0
2015-05-18 13:00:00	QQQ	ETF	109.92	110.15	109.915	110.13	1607852.0
2015-05-18 14:00:00	QQQ	ETF	110.12	110.22	110.06	110.1599	1141032.0
2015-05-18 15:00:00	QQQ	ETF	110.16	110.28	110.04	110.06	3575326.0
2015-05-18 16:00:00	QQQ	ETF	110.04	110.07	110.01	110.05	377245.0
2015-05-18 17:00:00	QQQ	ETF	110.06	110.06	110.06	110.06	255.0
2015-05-18 18:00:00	QQQ	ETF	110.07	110.07	110.06	110.07	5370.0
2015-05-18 19:00:00	QQQ	ETF	110.07	110.08	110.05	110.07	17470.0
2015-05-18 06:00:00	IWM	ETF	123.54	123.54	123.5	123.5	500.0
2015-05-18 07:00:00	IWM	ETF	123.25	123.26	123.25	123.25	27000.0
2015-05-18 08:00:00	IWM	ETF	123.29	123.34	123.25	123.31	50958.0
2015-05-18 09:00:00	IWM	ETF	123.3	123.94	123.17	123.92	2211927.0
2015-05-18 10:00:00	IWM	ETF	123.92	124.12	123.49	123.635	3562931.0
2015-05-18 11:00:00	IWM	ETF	123.64	124.6	123.61	124.58	4191718.0
2015-05-18 12:00:00	IWM	ETF	124.58	124.8	124.45	124.475	2033238.0
2015-05-18 13:00:00	IWM	ETF	124.475	124.85	124.475	124.824	1993601.0
2015-05-18 14:00:00	IWM	ETF	124.81	125.16	124.81	124.95	2950056.0
2015-05-18 15:00:00	IWM	ETF	124.95	125.14	124.9	125.02	5015721.0
2015-05-18 16:00:00	IWM	ETF	125.02	125.12	124.96	125.08	1696360.0
2015-05-18 17:00:00	IWM	ETF	125.08	125.08	125.05	125.08	15600.0
2015-05-18 18:00:00	IWM	ETF	125.06	125.06	125.06	125.06	100.0
2015-05-18 19:00:00	IWM	ETF	125.1	125.1	125.1	125.1	100.0
2015-05-18 06:00:00	DIA	ETF	182.25	182.3	182.15	182.3	11500.0
2015-05-18 07:00:00	DIA	ETF	182.17	182.27	182.05	182.05	13623.0
2015-05-18 09:00:00	DIA	ETF	182.34	182.65	182.31	182.52	460735.0
2015-05-18 10:00:00	DIA	ETF	182.54	182.61	182.19	182.27	426193.0
2015-05-18 11:00:00	DIA	ETF	182.27	182.73	182.27	182.56	455364.0

> showing 50 of 7,616 rows — these rows as CSV

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