PREVIEW / etf_1hour / 2017-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-22.parquet
  size:    275 KB
  rows:    8,944

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-22 04:00:00	SPY	ETF	242.6	242.64	242.44	242.49	3779.0
2017-06-22 05:00:00	SPY	ETF	242.56	242.67	242.45	242.64	9510.0
2017-06-22 06:00:00	SPY	ETF	242.68	242.9	242.68	242.86	117200.0
2017-06-22 07:00:00	SPY	ETF	242.85	242.93	242.79	242.88	148546.0
2017-06-22 08:00:00	SPY	ETF	242.93	242.93	242.75	242.78	203674.0
2017-06-22 09:00:00	SPY	ETF	242.77	243.04	242.64	242.9	5629501.0
2017-06-22 10:00:00	SPY	ETF	242.91	243.25	242.65	243.1655	5772984.0
2017-06-22 11:00:00	SPY	ETF	243.17	243.47	243.15	243.37	4693976.0
2017-06-22 12:00:00	SPY	ETF	243.37	243.51	243.155	243.405	3291783.0
2017-06-22 13:00:00	SPY	ETF	243.41	243.53	243.3	243.395	2646216.0
2017-06-22 14:00:00	SPY	ETF	243.4	243.47	243.24	243.37	3471566.0
2017-06-22 15:00:00	SPY	ETF	243.37	243.47	242.8	242.83	10566087.0
2017-06-22 16:00:00	SPY	ETF	242.82	243.0056	242.68	242.76	6661730.0
2017-06-22 17:00:00	SPY	ETF	242.75	242.77	242.7	242.74	35826.0
2017-06-22 18:00:00	SPY	ETF	242.77	242.88	242.76	242.88	45886.0
2017-06-22 19:00:00	SPY	ETF	242.87	242.93	242.87	242.91	28952.0
2017-06-22 04:00:00	QQQ	ETF	140.75	140.88	140.6	140.75	17138.0
2017-06-22 05:00:00	QQQ	ETF	140.64	140.8	140.59	140.79	14000.0
2017-06-22 06:00:00	QQQ	ETF	140.76	140.93	140.75	140.93	17202.0
2017-06-22 07:00:00	QQQ	ETF	140.88	140.98	140.84	140.92	147030.0
2017-06-22 08:00:00	QQQ	ETF	140.89	141.05	140.78	140.91	156910.0
2017-06-22 09:00:00	QQQ	ETF	140.91	141.0	140.42	140.53	4236275.0
2017-06-22 10:00:00	QQQ	ETF	140.54	140.909	140.34	140.79	3306174.0
2017-06-22 11:00:00	QQQ	ETF	140.79	140.89	140.66	140.81	2579513.0
2017-06-22 12:00:00	QQQ	ETF	140.81	141.18	140.6955	141.12	2143564.0
2017-06-22 13:00:00	QQQ	ETF	141.12	141.22	141.045	141.08	1815355.0
2017-06-22 14:00:00	QQQ	ETF	141.08	141.19	140.9	141.03	1427724.0
2017-06-22 15:00:00	QQQ	ETF	141.03	141.09	140.65	140.6815	3530288.0
2017-06-22 16:00:00	QQQ	ETF	140.69	141.1	140.66	140.7	1190616.0
2017-06-22 17:00:00	QQQ	ETF	140.7	140.72	140.67	140.7	64036.0
2017-06-22 18:00:00	QQQ	ETF	140.73	140.79	140.72	140.76	18690.0
2017-06-22 19:00:00	QQQ	ETF	140.78	140.85	140.78	140.82	11138.0
2017-06-22 04:00:00	IWM	ETF	139.0	139.0	138.9	138.9	1695.0
2017-06-22 05:00:00	IWM	ETF	139.0	139.0	138.9	138.9	2400.0
2017-06-22 06:00:00	IWM	ETF	139.13	139.3	139.13	139.3	13472.0
2017-06-22 07:00:00	IWM	ETF	139.26	139.3	139.21	139.22	47949.0
2017-06-22 08:00:00	IWM	ETF	139.18	139.28	139.1	139.24	99104.0
2017-06-22 09:00:00	IWM	ETF	139.19	139.82	139.14	139.61	1851492.0
2017-06-22 10:00:00	IWM	ETF	139.62	139.75	139.01	139.69	3336149.0
2017-06-22 11:00:00	IWM	ETF	139.7	139.92	139.59	139.82	2000119.0
2017-06-22 12:00:00	IWM	ETF	139.815	140.17	139.8	140.05	1429796.0
2017-06-22 13:00:00	IWM	ETF	140.06	140.15	139.92	140.04	1022955.0
2017-06-22 14:00:00	IWM	ETF	140.04	140.34	139.96	140.33	1605970.0
2017-06-22 15:00:00	IWM	ETF	140.3373	140.39	139.88	139.97	4138589.0
2017-06-22 16:00:00	IWM	ETF	139.98	140.05	139.3883	140.02	1069122.0
2017-06-22 17:00:00	IWM	ETF	140.0	140.0	140.0	140.0	284.0
2017-06-22 18:00:00	IWM	ETF	140.0	140.04	139.98	140.03	3014.0
2017-06-22 19:00:00	IWM	ETF	140.0	140.01	140.0	140.01	313.0
2017-06-22 05:00:00	DIA	ETF	213.7	213.7	213.7	213.7	200.0
2017-06-22 06:00:00	DIA	ETF	213.86	213.86	213.86	213.86	100.0

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

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