PREVIEW / etf_1hour / 2017-04-11

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-11.parquet
  size:    272 KB
  rows:    8,797

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-04-11 04:00:00	SPY	ETF	235.19	235.25	234.86	234.9	7308.0
2017-04-11 05:00:00	SPY	ETF	235.03	235.12	234.89	235.12	3600.0
2017-04-11 06:00:00	SPY	ETF	235.15	235.34	235.13	235.15	57316.0
2017-04-11 07:00:00	SPY	ETF	235.24	235.25	234.96	234.98	126575.0
2017-04-11 08:00:00	SPY	ETF	235.0	235.22	234.9	235.07	264654.0
2017-04-11 09:00:00	SPY	ETF	235.07	235.18	234.09	234.5	11159096.0
2017-04-11 10:00:00	SPY	ETF	234.495	234.731	233.34	233.66	16853616.0
2017-04-11 11:00:00	SPY	ETF	233.66	234.05	233.48	233.93	12883709.0
2017-04-11 12:00:00	SPY	ETF	233.93	234.65	233.75	234.56	9419031.0
2017-04-11 13:00:00	SPY	ETF	234.56	234.94	234.43	234.62	8066399.0
2017-04-11 14:00:00	SPY	ETF	234.62	235.015	234.3	234.8099	7060015.0
2017-04-11 15:00:00	SPY	ETF	234.8	235.06	234.24	235.04	13244069.0
2017-04-11 16:00:00	SPY	ETF	235.03	235.34	234.93	235.17	7675906.0
2017-04-11 17:00:00	SPY	ETF	235.18	235.22	235.14	235.19	185024.0
2017-04-11 18:00:00	SPY	ETF	235.18	235.22	235.03	235.08	136032.0
2017-04-11 19:00:00	SPY	ETF	235.09	235.12	235.0	235.03	71012.0
2017-04-11 04:00:00	QQQ	ETF	131.91	131.91	131.91	131.91	400.0
2017-04-11 05:00:00	QQQ	ETF	131.93	132.03	131.93	132.03	14455.0
2017-04-11 06:00:00	QQQ	ETF	132.01	132.05	132.01	132.04	10825.0
2017-04-11 07:00:00	QQQ	ETF	132.02	132.02	131.99	131.99	2800.0
2017-04-11 08:00:00	QQQ	ETF	131.83	132.02	131.83	131.99	101724.0
2017-04-11 09:00:00	QQQ	ETF	131.96	132.095	131.08	131.31	4160050.0
2017-04-11 10:00:00	QQQ	ETF	131.31	131.45	130.5	130.76	7652140.0
2017-04-11 11:00:00	QQQ	ETF	130.76	131.02	130.57	130.905	2852698.0
2017-04-11 12:00:00	QQQ	ETF	130.91	131.46	130.8208	131.375	2404385.0
2017-04-11 13:00:00	QQQ	ETF	131.38	131.62	131.245	131.3264	1835601.0
2017-04-11 14:00:00	QQQ	ETF	131.33	131.51	131.17	131.407	1822757.0
2017-04-11 15:00:00	QQQ	ETF	131.4099	131.5	131.01	131.49	5139423.0
2017-04-11 16:00:00	QQQ	ETF	131.49	131.62	131.41	131.62	676942.0
2017-04-11 17:00:00	QQQ	ETF	131.62	131.67	131.58	131.6	14998.0
2017-04-11 18:00:00	QQQ	ETF	131.58	131.58	131.49	131.51	8752.0
2017-04-11 19:00:00	QQQ	ETF	131.51	131.51	131.45	131.46	14415.0
2017-04-11 04:00:00	IWM	ETF	135.52	135.55	135.31	135.44	1364.0
2017-04-11 05:00:00	IWM	ETF	135.45	135.54	135.45	135.54	631.0
2017-04-11 06:00:00	IWM	ETF	135.59	135.59	135.59	135.59	100.0
2017-04-11 07:00:00	IWM	ETF	135.52	135.56	135.38	135.4	37348.0
2017-04-11 08:00:00	IWM	ETF	135.4	135.52	135.28	135.45	45111.0
2017-04-11 09:00:00	IWM	ETF	135.46	135.97	135.17	135.96	3591110.0
2017-04-11 10:00:00	IWM	ETF	135.97	136.235	135.08	135.36	5656789.0
2017-04-11 11:00:00	IWM	ETF	135.36	136.07	135.18	135.97	3505024.0
2017-04-11 12:00:00	IWM	ETF	135.97	136.41	135.7701	136.2699	2505622.0
2017-04-11 13:00:00	IWM	ETF	136.29	136.66	136.28	136.4157	2120659.0
2017-04-11 14:00:00	IWM	ETF	136.41	136.85	136.34	136.65	2075053.0
2017-04-11 15:00:00	IWM	ETF	136.65	136.92	136.42	136.92	4200061.0
2017-04-11 16:00:00	IWM	ETF	136.9	137.12	136.9	137.1	1280970.0
2017-04-11 17:00:00	IWM	ETF	137.1	137.12	137.05	137.05	23538.0
2017-04-11 18:00:00	IWM	ETF	137.05	137.06	137.05	137.05	4882.0
2017-04-11 19:00:00	IWM	ETF	137.05	137.06	137.05	137.05	18045.0
2017-04-11 04:00:00	DIA	ETF	206.17	206.17	206.17	206.17	100.0
2017-04-11 09:00:00	DIA	ETF	206.22	206.41	205.66	206.07	588036.0

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

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