PREVIEW / etf_1hour / 2017-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-22.parquet
  size:    279 KB
  rows:    9,032

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-08-22 04:00:00	SPY	ETF	243.51	243.88	243.45	243.47	20761.0
2017-08-22 05:00:00	SPY	ETF	243.55	243.55	243.19	243.33	2250.0
2017-08-22 06:00:00	SPY	ETF	243.42	243.45	243.22	243.22	30334.0
2017-08-22 07:00:00	SPY	ETF	243.27	243.56	243.27	243.51	314692.0
2017-08-22 08:00:00	SPY	ETF	243.51	243.86	243.3	243.67	414328.0
2017-08-22 09:00:00	SPY	ETF	243.67	244.47	243.53	244.2601	7268374.0
2017-08-22 10:00:00	SPY	ETF	244.26	244.64	244.26	244.5941	8251463.0
2017-08-22 11:00:00	SPY	ETF	244.59	244.93	244.44	244.86	6369065.0
2017-08-22 12:00:00	SPY	ETF	244.86	245.0801	244.82	244.975	6775699.0
2017-08-22 13:00:00	SPY	ETF	244.98	245.09	244.91	244.96	4354928.0
2017-08-22 14:00:00	SPY	ETF	244.95	245.39	244.89	245.295	5745008.0
2017-08-22 15:00:00	SPY	ETF	245.29	245.62	245.255	245.4	15645323.0
2017-08-22 16:00:00	SPY	ETF	245.39	245.64	245.26	245.56	4815035.0
2017-08-22 17:00:00	SPY	ETF	245.56	245.6	245.44	245.55	627743.0
2017-08-22 18:00:00	SPY	ETF	245.55	245.65	245.47	245.59	77504.0
2017-08-22 19:00:00	SPY	ETF	245.57	245.68	245.47	245.53	75808.0
2017-08-22 04:00:00	QQQ	ETF	141.76	141.76	141.64	141.76	11200.0
2017-08-22 05:00:00	QQQ	ETF	141.63	141.67	141.55	141.67	5133.0
2017-08-22 06:00:00	QQQ	ETF	141.67	141.7	141.6	141.6	7800.0
2017-08-22 07:00:00	QQQ	ETF	141.6	141.81	141.6	141.77	173397.0
2017-08-22 08:00:00	QQQ	ETF	141.66	142.02	141.66	141.91	398453.0
2017-08-22 09:00:00	QQQ	ETF	141.89	142.5	141.76	142.2951	6304189.0
2017-08-22 10:00:00	QQQ	ETF	142.3	142.78	142.2953	142.7501	3914708.0
2017-08-22 11:00:00	QQQ	ETF	142.75	143.01	142.715	142.95	2973985.0
2017-08-22 12:00:00	QQQ	ETF	142.95	143.18	142.94	143.03	2172727.0
2017-08-22 13:00:00	QQQ	ETF	143.04	143.09	142.89	142.94	1522110.0
2017-08-22 14:00:00	QQQ	ETF	142.93	143.2812	142.91	143.16	2787084.0
2017-08-22 15:00:00	QQQ	ETF	143.16	143.35	143.11	143.2	6935967.0
2017-08-22 16:00:00	QQQ	ETF	143.2	143.34	142.2274	143.32	1722312.0
2017-08-22 17:00:00	QQQ	ETF	143.28	143.34	143.28	143.28	7753.0
2017-08-22 18:00:00	QQQ	ETF	143.28	143.32	143.22	143.32	54753.0
2017-08-22 19:00:00	QQQ	ETF	143.32	143.38	143.2	143.28	12144.0
2017-08-22 04:00:00	IWM	ETF	135.19	135.29	135.15	135.25	2048.0
2017-08-22 05:00:00	IWM	ETF	135.1	135.1	134.98	135.04	4050.0
2017-08-22 06:00:00	IWM	ETF	135.1	135.15	135.04	135.05	8447.0
2017-08-22 07:00:00	IWM	ETF	135.06	135.3	135.06	135.26	65251.0
2017-08-22 08:00:00	IWM	ETF	135.26	135.52	135.26	135.32	119364.0
2017-08-22 09:00:00	IWM	ETF	135.34	135.815	135.14	135.66	3616974.0
2017-08-22 10:00:00	IWM	ETF	135.65	135.92	135.575	135.84	3896907.0
2017-08-22 11:00:00	IWM	ETF	135.85	136.02	135.66	135.865	3093127.0
2017-08-22 12:00:00	IWM	ETF	135.86	136.17	135.835	136.03	2286035.0
2017-08-22 13:00:00	IWM	ETF	136.03	136.16	135.985	136.01	1777427.0
2017-08-22 14:00:00	IWM	ETF	136.0	136.3	135.9	136.2334	1901706.0
2017-08-22 15:00:00	IWM	ETF	136.24	136.445	136.18	136.29	4001807.0
2017-08-22 16:00:00	IWM	ETF	136.29	136.39	135.946	136.33	1602802.0
2017-08-22 17:00:00	IWM	ETF	136.29	136.3	136.29	136.3	497.0
2017-08-22 18:00:00	IWM	ETF	136.29	136.3	136.29	136.3	2810.0
2017-08-22 19:00:00	IWM	ETF	136.3	136.39	136.25	136.25	6724.0
2017-08-22 04:00:00	DIA	ETF	217.46	217.46	217.46	217.46	100.0
2017-08-22 05:00:00	DIA	ETF	217.04	217.04	217.04	217.04	100.0

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

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