PREVIEW / etf_1hour / 2017-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-23.parquet
  size:    275 KB
  rows:    8,938

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-23 04:00:00	SPY	ETF	245.21	245.21	244.8	244.99	12223.0
2017-08-23 05:00:00	SPY	ETF	245.03	245.05	244.97	244.98	20100.0
2017-08-23 06:00:00	SPY	ETF	244.95	244.98	244.82	244.98	47342.0
2017-08-23 07:00:00	SPY	ETF	245.0	245.05	244.58	244.71	319686.0
2017-08-23 08:00:00	SPY	ETF	244.7	245.3745	244.5	244.56	875375.0
2017-08-23 09:00:00	SPY	ETF	244.55	244.83	244.16	244.79	7355236.0
2017-08-23 10:00:00	SPY	ETF	244.79	244.94	244.3959	244.65	6230870.0
2017-08-23 11:00:00	SPY	ETF	244.656	245.05	244.53	244.94	4651367.0
2017-08-23 12:00:00	SPY	ETF	244.93	245.04	244.64	244.76	4355598.0
2017-08-23 13:00:00	SPY	ETF	244.76	244.8	244.43	244.555	3229165.0
2017-08-23 14:00:00	SPY	ETF	244.56	244.86	244.49	244.78	3742398.0
2017-08-23 15:00:00	SPY	ETF	244.78	245.03	244.52	244.538	9499141.0
2017-08-23 16:00:00	SPY	ETF	244.54	244.61	244.22	244.26	6812071.0
2017-08-23 17:00:00	SPY	ETF	244.26	244.27	244.17	244.24	112432.0
2017-08-23 18:00:00	SPY	ETF	244.25	244.29	243.81	244.02	153352.0
2017-08-23 19:00:00	SPY	ETF	243.99	244.05	243.89	243.89	46486.0
2017-08-23 04:00:00	QQQ	ETF	143.1	143.1	143.0	143.0	1751.0
2017-08-23 05:00:00	QQQ	ETF	143.0	143.01	142.97	142.98	6316.0
2017-08-23 06:00:00	QQQ	ETF	142.9	142.91	142.85	142.89	1850.0
2017-08-23 07:00:00	QQQ	ETF	143.01	143.02	142.73	142.76	159743.0
2017-08-23 08:00:00	QQQ	ETF	142.97	142.97	142.59	142.65	357446.0
2017-08-23 09:00:00	QQQ	ETF	142.6	142.88	142.38	142.84	3542471.0
2017-08-23 10:00:00	QQQ	ETF	142.84	142.84	142.42	142.54	3223194.0
2017-08-23 11:00:00	QQQ	ETF	142.53	142.97	142.51	142.85	3722821.0
2017-08-23 12:00:00	QQQ	ETF	142.85	142.925	142.55	142.699	1992384.0
2017-08-23 13:00:00	QQQ	ETF	142.7	142.72	142.4	142.52	1558954.0
2017-08-23 14:00:00	QQQ	ETF	142.529	142.87	142.5053	142.805	1972530.0
2017-08-23 15:00:00	QQQ	ETF	142.81	143.01	142.67	142.69	3282476.0
2017-08-23 16:00:00	QQQ	ETF	142.69	142.73	142.39	142.44	1559139.0
2017-08-23 17:00:00	QQQ	ETF	142.4	142.48	142.36	142.47	16544.0
2017-08-23 18:00:00	QQQ	ETF	142.41	142.5	142.1	142.18	55756.0
2017-08-23 19:00:00	QQQ	ETF	142.19	142.27	142.13	142.15	41372.0
2017-08-23 04:00:00	IWM	ETF	136.06	136.06	136.0	136.0	400.0
2017-08-23 06:00:00	IWM	ETF	135.73	135.84	135.72	135.84	1506.0
2017-08-23 07:00:00	IWM	ETF	135.85	135.85	135.46	135.57	39810.0
2017-08-23 08:00:00	IWM	ETF	135.56	135.59	135.39	135.42	115621.0
2017-08-23 09:00:00	IWM	ETF	135.44	136.13	135.207	136.0	2970923.0
2017-08-23 10:00:00	IWM	ETF	136.0	136.33	135.73	136.0301	2608096.0
2017-08-23 11:00:00	IWM	ETF	136.0275	136.57	135.98	136.39	2009426.0
2017-08-23 12:00:00	IWM	ETF	136.38	136.53	136.25	136.3699	1568523.0
2017-08-23 13:00:00	IWM	ETF	136.3699	136.42	135.9444	136.11	1569888.0
2017-08-23 14:00:00	IWM	ETF	136.1	136.33	136.0568	136.25	1041883.0
2017-08-23 15:00:00	IWM	ETF	136.251	136.41	136.05	136.05	3388439.0
2017-08-23 16:00:00	IWM	ETF	136.06	136.203	135.85	135.85	619843.0
2017-08-23 17:00:00	IWM	ETF	135.88	135.88	135.8	135.8	7656.0
2017-08-23 18:00:00	IWM	ETF	135.78	135.78	135.62	135.62	4684.0
2017-08-23 19:00:00	IWM	ETF	135.75	135.75	135.62	135.62	2695.0
2017-08-23 04:00:00	DIA	ETF	218.6	218.6	218.6	218.6	100.0
2017-08-23 07:00:00	DIA	ETF	218.39	218.39	218.18	218.18	600.0
2017-08-23 08:00:00	DIA	ETF	218.35	218.35	218.03	218.27	1760.0

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

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