PREVIEW / etf_1hour / 2017-05-11

all etf 1-hour files

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

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-11 04:00:00	SPY	ETF	239.65	239.65	239.51	239.52	7222.0
2017-05-11 05:00:00	SPY	ETF	239.49	239.51	239.34	239.34	26900.0
2017-05-11 06:00:00	SPY	ETF	239.37	239.41	239.32	239.38	29407.0
2017-05-11 07:00:00	SPY	ETF	239.38	239.46	239.07	239.2	199985.0
2017-05-11 08:00:00	SPY	ETF	239.15	239.4	239.04	239.3	523946.0
2017-05-11 09:00:00	SPY	ETF	239.32	239.46	238.31	238.5601	8399416.0
2017-05-11 10:00:00	SPY	ETF	238.56	238.687	238.13	238.5768	14184925.0
2017-05-11 11:00:00	SPY	ETF	238.58	239.3	238.56	238.6787	8639251.0
2017-05-11 12:00:00	SPY	ETF	238.68	239.13	238.66	238.96	5118198.0
2017-05-11 13:00:00	SPY	ETF	238.965	239.31	238.93	239.3	3003816.0
2017-05-11 14:00:00	SPY	ETF	239.31	239.57	239.09	239.29	5912074.0
2017-05-11 15:00:00	SPY	ETF	239.29	239.51	239.23	239.41	8291686.0
2017-05-11 16:00:00	SPY	ETF	239.41	239.53	238.4683	239.26	6970988.0
2017-05-11 17:00:00	SPY	ETF	239.26	239.31	239.26	239.31	43527.0
2017-05-11 18:00:00	SPY	ETF	239.28	239.33	239.22	239.29	68798.0
2017-05-11 19:00:00	SPY	ETF	239.28	239.29	239.23	239.27	31113.0
2017-05-11 05:00:00	QQQ	ETF	138.2	138.2	138.1	138.1	7570.0
2017-05-11 06:00:00	QQQ	ETF	138.08	138.09	138.06	138.08	18100.0
2017-05-11 07:00:00	QQQ	ETF	138.08	138.09	137.86	137.87	121697.0
2017-05-11 08:00:00	QQQ	ETF	137.89	138.09	137.85	138.02	74485.0
2017-05-11 09:00:00	QQQ	ETF	138.0	138.16	137.51	137.65	3811431.0
2017-05-11 10:00:00	QQQ	ETF	137.64	137.69	137.38	137.5254	5362973.0
2017-05-11 11:00:00	QQQ	ETF	137.53	137.7899	137.5	137.68	1737015.0
2017-05-11 12:00:00	QQQ	ETF	137.68	137.91	137.6696	137.84	1976707.0
2017-05-11 13:00:00	QQQ	ETF	137.8374	138.2	137.82	138.19	1491953.0
2017-05-11 14:00:00	QQQ	ETF	138.2	138.31	138.08	138.14	2484054.0
2017-05-11 15:00:00	QQQ	ETF	138.14	138.33	138.11	138.29	2388977.0
2017-05-11 16:00:00	QQQ	ETF	138.3	138.32	138.21	138.23	3102835.0
2017-05-11 17:00:00	QQQ	ETF	138.24	138.27	138.24	138.27	856.0
2017-05-11 18:00:00	QQQ	ETF	138.23	138.26	138.21	138.26	6623.0
2017-05-11 19:00:00	QQQ	ETF	138.22	138.25	138.21	138.23	5900.0
2017-05-11 04:00:00	IWM	ETF	138.88	138.97	138.88	138.9	550.0
2017-05-11 05:00:00	IWM	ETF	138.8	138.8	138.76	138.76	1500.0
2017-05-11 06:00:00	IWM	ETF	138.74	138.74	138.74	138.74	5000.0
2017-05-11 07:00:00	IWM	ETF	138.74	138.74	138.5	138.58	53282.0
2017-05-11 08:00:00	IWM	ETF	138.53	138.67	138.46	138.55	124548.0
2017-05-11 09:00:00	IWM	ETF	138.58	138.83	137.38	137.58	4315875.0
2017-05-11 10:00:00	IWM	ETF	137.58	137.72	136.98	137.69	5468559.0
2017-05-11 11:00:00	IWM	ETF	137.7	138.34	137.68	138.275	3566648.0
2017-05-11 12:00:00	IWM	ETF	138.28	138.48	138.1	138.21	1498044.0
2017-05-11 13:00:00	IWM	ETF	138.21	138.57	138.19	138.5618	1272692.0
2017-05-11 14:00:00	IWM	ETF	138.57	138.71	138.34	138.4	1546797.0
2017-05-11 15:00:00	IWM	ETF	138.4	138.5	138.16	138.26	3449642.0
2017-05-11 16:00:00	IWM	ETF	138.28	138.3	137.653	138.0	553558.0
2017-05-11 17:00:00	IWM	ETF	138.06	138.13	138.05	138.05	1204.0
2017-05-11 18:00:00	IWM	ETF	138.1	138.17	138.1	138.17	2836.0
2017-05-11 19:00:00	IWM	ETF	138.11	138.11	138.09	138.09	700.0
2017-05-11 04:00:00	DIA	ETF	209.33	209.33	209.33	209.33	100.0
2017-05-11 05:00:00	DIA	ETF	209.28	209.28	209.28	209.28	100.0
2017-05-11 07:00:00	DIA	ETF	209.12	209.12	209.04	209.04	300.0

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

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