PREVIEW / etf_1hour / 2017-09-13

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-13.parquet
  size:    274 KB
  rows:    9,060

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-09-13 04:00:00	SPY	ETF	249.8	249.8	249.7	249.73	2355.0
2017-09-13 05:00:00	SPY	ETF	249.78	249.8	249.7	249.71	16100.0
2017-09-13 06:00:00	SPY	ETF	249.72	249.76	249.67	249.67	6800.0
2017-09-13 07:00:00	SPY	ETF	249.67	249.84	249.65	249.82	76258.0
2017-09-13 08:00:00	SPY	ETF	249.69	249.83	249.63	249.77	418057.0
2017-09-13 09:00:00	SPY	ETF	249.78	249.965	249.59	249.96	4672898.0
2017-09-13 10:00:00	SPY	ETF	249.955	250.06	249.84	249.95	7113701.0
2017-09-13 11:00:00	SPY	ETF	249.96	250.1	249.73	249.855	7131192.0
2017-09-13 12:00:00	SPY	ETF	249.86	250.12	249.84	250.03	5225787.0
2017-09-13 13:00:00	SPY	ETF	250.035	250.07	249.86	249.955	4141118.0
2017-09-13 14:00:00	SPY	ETF	249.9535	250.11	249.91	250.03	2847506.0
2017-09-13 15:00:00	SPY	ETF	250.04	250.21	249.94	250.18	10567925.0
2017-09-13 16:00:00	SPY	ETF	250.17	250.2353	250.01	250.14	15882897.0
2017-09-13 17:00:00	SPY	ETF	250.13	250.13	250.07	250.07	131525.0
2017-09-13 18:00:00	SPY	ETF	250.08	250.1	249.83	249.92	156857.0
2017-09-13 19:00:00	SPY	ETF	249.94	250.227	249.9	249.93	353897.0
2017-09-13 04:00:00	QQQ	ETF	146.06	146.06	145.95	145.95	13249.0
2017-09-13 05:00:00	QQQ	ETF	145.96	145.96	145.92	145.95	7100.0
2017-09-13 06:00:00	QQQ	ETF	145.99	145.99	145.88	145.89	4800.0
2017-09-13 07:00:00	QQQ	ETF	145.89	146.0	145.89	146.0	23281.0
2017-09-13 08:00:00	QQQ	ETF	145.97	145.99	145.86	145.98	63303.0
2017-09-13 09:00:00	QQQ	ETF	145.99	146.19	145.73	146.18	4101600.0
2017-09-13 10:00:00	QQQ	ETF	146.18	146.26	145.98	146.08	3296626.0
2017-09-13 11:00:00	QQQ	ETF	146.09	146.22	145.8	145.88	1986107.0
2017-09-13 12:00:00	QQQ	ETF	145.89	146.3	145.87	146.15	1281893.0
2017-09-13 13:00:00	QQQ	ETF	146.15	146.27	146.04	146.2	2171020.0
2017-09-13 14:00:00	QQQ	ETF	146.205	146.275	146.15	146.185	1209749.0
2017-09-13 15:00:00	QQQ	ETF	146.18	146.44	146.09	146.41	4787777.0
2017-09-13 16:00:00	QQQ	ETF	146.41	146.45	146.28	146.42	2516971.0
2017-09-13 17:00:00	QQQ	ETF	146.38	146.44	146.0936	146.43	40958.0
2017-09-13 18:00:00	QQQ	ETF	146.39	146.39	146.22	146.25	25977.0
2017-09-13 19:00:00	QQQ	ETF	146.25	146.28	146.23	146.25	19600.0
2017-09-13 04:00:00	IWM	ETF	141.4	141.4	141.4	141.4	4100.0
2017-09-13 06:00:00	IWM	ETF	141.36	141.41	141.35	141.41	5315.0
2017-09-13 07:00:00	IWM	ETF	141.45	141.51	141.45	141.49	20139.0
2017-09-13 08:00:00	IWM	ETF	141.45	141.46	141.3	141.39	27778.0
2017-09-13 09:00:00	IWM	ETF	141.38	141.79	141.3	141.78	1939215.0
2017-09-13 10:00:00	IWM	ETF	141.78	142.09	141.73	141.98	3437164.0
2017-09-13 11:00:00	IWM	ETF	141.99	142.12	141.89	141.93	2872227.0
2017-09-13 12:00:00	IWM	ETF	141.94	142.22	141.92	142.105	1450866.0
2017-09-13 13:00:00	IWM	ETF	142.11	142.16	141.965	142.0456	1556052.0
2017-09-13 14:00:00	IWM	ETF	142.045	142.19	141.96	142.1	1451494.0
2017-09-13 15:00:00	IWM	ETF	142.1	142.12	141.76	141.97	4714162.0
2017-09-13 16:00:00	IWM	ETF	141.96	141.9963	141.83	141.96	1453354.0
2017-09-13 17:00:00	IWM	ETF	142.038	142.038	141.9	141.94	21656.0
2017-09-13 18:00:00	IWM	ETF	141.88	141.88	141.88	141.88	2500.0
2017-09-13 19:00:00	IWM	ETF	141.76	141.79	141.76	141.79	918.0
2017-09-13 09:00:00	DIA	ETF	221.23	221.5298	221.22	221.33	299211.0
2017-09-13 10:00:00	DIA	ETF	221.38	221.48	221.29	221.39	242567.0
2017-09-13 11:00:00	DIA	ETF	221.41	221.52	221.2	221.41	191887.0

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

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