PREVIEW / etf_1hour / 2017-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-12.parquet
  size:    276 KB
  rows:    9,087

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-06-12 04:00:00	SPY	ETF	243.28	243.28	242.76	242.77	28360.0
2017-06-12 05:00:00	SPY	ETF	242.75	243.0	242.7	242.88	48470.0
2017-06-12 06:00:00	SPY	ETF	242.8	243.04	242.78	242.98	220449.0
2017-06-12 07:00:00	SPY	ETF	242.98	243.06	242.79	242.86	437164.0
2017-06-12 08:00:00	SPY	ETF	242.91	243.25	242.8	243.14	603054.0
2017-06-12 09:00:00	SPY	ETF	243.12	243.42	242.46	242.62	12248560.0
2017-06-12 10:00:00	SPY	ETF	242.62	243.14	242.38	243.08	15061857.0
2017-06-12 11:00:00	SPY	ETF	243.075	243.25	242.79	242.95	10145243.0
2017-06-12 12:00:00	SPY	ETF	242.95	243.0	242.47	242.48	7186904.0
2017-06-12 13:00:00	SPY	ETF	242.48	242.935	242.45	242.515	7082519.0
2017-06-12 14:00:00	SPY	ETF	242.5101	243.06	242.49	242.965	6586019.0
2017-06-12 15:00:00	SPY	ETF	242.96	243.39	242.81	243.34	15263237.0
2017-06-12 16:00:00	SPY	ETF	243.33	243.5718	242.9914	243.38	9821743.0
2017-06-12 17:00:00	SPY	ETF	243.37	243.46	242.8955	243.36	194944.0
2017-06-12 18:00:00	SPY	ETF	243.35	243.37	243.23	243.34	142753.0
2017-06-12 19:00:00	SPY	ETF	243.34	243.4	243.28	243.4	24860.0
2017-06-12 04:00:00	QQQ	ETF	139.28	139.28	138.38	138.47	39282.0
2017-06-12 05:00:00	QQQ	ETF	138.45	138.98	138.45	138.9	123430.0
2017-06-12 06:00:00	QQQ	ETF	138.92	139.21	138.92	139.15	34159.0
2017-06-12 07:00:00	QQQ	ETF	139.13	139.17	138.55	138.64	612300.0
2017-06-12 08:00:00	QQQ	ETF	138.8	139.22	138.5	139.01	885423.0
2017-06-12 09:00:00	QQQ	ETF	139.0	139.08	137.47	137.94	26238264.0
2017-06-12 10:00:00	QQQ	ETF	137.94	138.96	137.73	138.76	19378381.0
2017-06-12 11:00:00	QQQ	ETF	138.76	139.48	138.65	138.92	10213211.0
2017-06-12 12:00:00	QQQ	ETF	138.92	139.0152	138.35	138.4	5462273.0
2017-06-12 13:00:00	QQQ	ETF	138.4	138.9	138.27	138.45	3873481.0
2017-06-12 14:00:00	QQQ	ETF	138.45	139.2	138.42	138.86	6540091.0
2017-06-12 15:00:00	QQQ	ETF	138.86	139.28	138.65	139.25	10056364.0
2017-06-12 16:00:00	QQQ	ETF	139.25	139.41	138.68	139.41	3491628.0
2017-06-12 17:00:00	QQQ	ETF	139.37	139.38	138.7221	139.36	532336.0
2017-06-12 18:00:00	QQQ	ETF	139.38	139.39	139.28	139.33	59112.0
2017-06-12 19:00:00	QQQ	ETF	139.33	139.41	139.32	139.4	5163.0
2017-06-12 04:00:00	IWM	ETF	141.44	141.44	141.11	141.11	4205.0
2017-06-12 05:00:00	IWM	ETF	141.27	141.42	141.14	141.29	3500.0
2017-06-12 06:00:00	IWM	ETF	141.3	141.47	141.23	141.43	6800.0
2017-06-12 07:00:00	IWM	ETF	141.35	141.39	141.26	141.34	39779.0
2017-06-12 08:00:00	IWM	ETF	141.38	141.73	141.38	141.64	67099.0
2017-06-12 09:00:00	IWM	ETF	141.63	141.99	141.14	141.21	3797048.0
2017-06-12 10:00:00	IWM	ETF	141.25	142.15	140.8901	142.01	7029924.0
2017-06-12 11:00:00	IWM	ETF	142.0173	142.09	141.11	141.5526	5013260.0
2017-06-12 12:00:00	IWM	ETF	141.56	141.58	141.19	141.29	2446497.0
2017-06-12 13:00:00	IWM	ETF	141.29	141.445	141.11	141.18	2398152.0
2017-06-12 14:00:00	IWM	ETF	141.17	141.33	140.96	141.075	1953963.0
2017-06-12 15:00:00	IWM	ETF	141.07	141.4	141.02	141.37	4181708.0
2017-06-12 16:00:00	IWM	ETF	141.37	141.58	141.36	141.56	2267751.0
2017-06-12 17:00:00	IWM	ETF	141.1829	141.51	141.09	141.51	188971.0
2017-06-12 18:00:00	IWM	ETF	141.5	141.54	141.5	141.54	2050.0
2017-06-12 19:00:00	IWM	ETF	141.54	141.54	141.51	141.54	800.0
2017-06-12 07:00:00	DIA	ETF	212.32	212.32	212.18	212.18	1246.0
2017-06-12 08:00:00	DIA	ETF	212.31	212.33	212.14	212.33	2005.0

> showing 50 of 9,087 rows — these rows as CSV

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