PREVIEW / etf_1hour / 2017-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-05.parquet
  size:    273 KB
  rows:    8,880

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-05-05 04:00:00	SPY	ETF	238.6	238.81	238.57	238.79	6720.0
2017-05-05 05:00:00	SPY	ETF	238.81	238.84	238.76	238.79	5718.0
2017-05-05 06:00:00	SPY	ETF	238.79	238.86	238.75	238.86	12607.0
2017-05-05 07:00:00	SPY	ETF	238.83	238.89	238.79	238.8	106754.0
2017-05-05 08:00:00	SPY	ETF	238.84	239.23	238.69	239.05	925388.0
2017-05-05 09:00:00	SPY	ETF	239.05	239.31	238.84	238.86	5449063.0
2017-05-05 10:00:00	SPY	ETF	238.84	239.06	238.68	238.895	5423555.0
2017-05-05 11:00:00	SPY	ETF	238.89	239.09	238.78	239.05	4838566.0
2017-05-05 12:00:00	SPY	ETF	239.06	239.12	238.71	238.95	6028646.0
2017-05-05 13:00:00	SPY	ETF	238.95	239.12	238.85	239.1	4160188.0
2017-05-05 14:00:00	SPY	ETF	239.11	239.39	239.05	239.24	5342994.0
2017-05-05 15:00:00	SPY	ETF	239.24	239.72	239.15	239.72	17238914.0
2017-05-05 16:00:00	SPY	ETF	239.72	240.04	239.6	240.04	8710821.0
2017-05-05 17:00:00	SPY	ETF	240.02	240.05	239.52	239.98	1581525.0
2017-05-05 18:00:00	SPY	ETF	239.98	240.06	239.69	239.7	245651.0
2017-05-05 19:00:00	SPY	ETF	239.7	239.95	239.65	239.95	164596.0
2017-05-05 04:00:00	QQQ	ETF	137.0	137.12	137.0	137.12	1199.0
2017-05-05 05:00:00	QQQ	ETF	137.12	137.13	137.07	137.07	6999.0
2017-05-05 06:00:00	QQQ	ETF	137.16	137.16	137.16	137.16	200.0
2017-05-05 07:00:00	QQQ	ETF	137.15	137.16	137.12	137.15	27780.0
2017-05-05 08:00:00	QQQ	ETF	137.12	137.41	137.09	137.32	152078.0
2017-05-05 09:00:00	QQQ	ETF	137.36	137.41	137.09	137.1	1373266.0
2017-05-05 10:00:00	QQQ	ETF	137.095	137.15	136.88	136.98	1381269.0
2017-05-05 11:00:00	QQQ	ETF	136.98	137.14	136.9	137.12	1089225.0
2017-05-05 12:00:00	QQQ	ETF	137.125	137.19	136.98	137.12	1179755.0
2017-05-05 13:00:00	QQQ	ETF	137.115	137.2775	137.1	137.253	1114014.0
2017-05-05 14:00:00	QQQ	ETF	137.25	137.33	137.15	137.25	1466536.0
2017-05-05 15:00:00	QQQ	ETF	137.25	137.54	137.19	137.54	4493901.0
2017-05-05 16:00:00	QQQ	ETF	137.54	137.67	137.51	137.53	3524391.0
2017-05-05 17:00:00	QQQ	ETF	137.68	137.68	137.6	137.61	4300.0
2017-05-05 18:00:00	QQQ	ETF	137.57	137.66	137.56	137.56	4306.0
2017-05-05 19:00:00	QQQ	ETF	137.56	137.69	137.54	137.68	31577.0
2017-05-05 04:00:00	IWM	ETF	137.94	137.94	137.94	137.94	333.0
2017-05-05 05:00:00	IWM	ETF	138.17	138.22	138.17	138.22	7300.0
2017-05-05 06:00:00	IWM	ETF	138.15	138.15	138.15	138.15	300.0
2017-05-05 07:00:00	IWM	ETF	138.25	138.27	138.19	138.19	7700.0
2017-05-05 08:00:00	IWM	ETF	138.18	138.65	138.0	138.55	102526.0
2017-05-05 09:00:00	IWM	ETF	138.58	138.74	137.95	137.96	2115557.0
2017-05-05 10:00:00	IWM	ETF	137.97	138.3	137.53	138.08	3640595.0
2017-05-05 11:00:00	IWM	ETF	138.09	138.54	138.09	138.49	2071437.0
2017-05-05 12:00:00	IWM	ETF	138.49	138.57	137.82	138.2	2058328.0
2017-05-05 13:00:00	IWM	ETF	138.2	138.51	138.17	138.44	1012216.0
2017-05-05 14:00:00	IWM	ETF	138.44	138.6	138.369	138.44	1444998.0
2017-05-05 15:00:00	IWM	ETF	138.45	138.99	138.45	138.97	3583859.0
2017-05-05 16:00:00	IWM	ETF	138.97	139.03	138.892	138.99	2316275.0
2017-05-05 17:00:00	IWM	ETF	138.99	139.06	138.9	138.99	123002.0
2017-05-05 18:00:00	IWM	ETF	139.05	139.05	138.92	138.92	3387.0
2017-05-05 19:00:00	IWM	ETF	138.9	138.99	138.8	138.99	9090.0
2017-05-05 04:00:00	DIA	ETF	208.91	209.06	208.91	209.06	400.0
2017-05-05 07:00:00	DIA	ETF	209.0	209.0	208.98	208.98	200.0

> showing 50 of 8,880 rows — these rows as CSV

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