PREVIEW / etf_1hour / 2017-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-20.parquet
  size:    275 KB
  rows:    8,992

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-07-20 04:00:00	SPY	ETF	247.1	247.28	247.1	247.26	29154.0
2017-07-20 05:00:00	SPY	ETF	247.11	247.19	247.05	247.12	4427.0
2017-07-20 06:00:00	SPY	ETF	247.12	247.19	247.1	247.1	6501.0
2017-07-20 07:00:00	SPY	ETF	247.08	247.23	247.08	247.23	46593.0
2017-07-20 08:00:00	SPY	ETF	247.1	247.5	247.1	247.19	439593.0
2017-07-20 09:00:00	SPY	ETF	247.2	247.42	247.09	247.28	4251051.0
2017-07-20 10:00:00	SPY	ETF	247.27	247.34	246.47	247.075	9619328.0
2017-07-20 11:00:00	SPY	ETF	247.08	247.26	246.67	246.97	4891193.0
2017-07-20 12:00:00	SPY	ETF	246.96	247.29	246.91	247.245	2371135.0
2017-07-20 13:00:00	SPY	ETF	247.245	247.36	247.06	247.29	2745422.0
2017-07-20 14:00:00	SPY	ETF	247.295	247.295	246.97	247.22	3449711.0
2017-07-20 15:00:00	SPY	ETF	247.22	247.36	246.97	247.07	10044234.0
2017-07-20 16:00:00	SPY	ETF	247.07	247.2	246.95	247.15	7368838.0
2017-07-20 17:00:00	SPY	ETF	247.1	247.18	247.02	247.12	428156.0
2017-07-20 18:00:00	SPY	ETF	247.12	247.16	247.05	247.08	92955.0
2017-07-20 19:00:00	SPY	ETF	247.1	247.12	247.02	247.04	28011.0
2017-07-20 04:00:00	QQQ	ETF	144.06	144.06	144.06	144.06	1699.0
2017-07-20 05:00:00	QQQ	ETF	143.95	144.05	143.95	144.04	6000.0
2017-07-20 06:00:00	QQQ	ETF	144.03	144.08	144.01	144.03	3291.0
2017-07-20 07:00:00	QQQ	ETF	144.09	144.25	144.08	144.21	51479.0
2017-07-20 08:00:00	QQQ	ETF	144.08	144.44	144.08	144.31	262513.0
2017-07-20 09:00:00	QQQ	ETF	144.29	144.5	144.03	144.25	3763242.0
2017-07-20 10:00:00	QQQ	ETF	144.25	144.25	143.52	143.99	6323285.0
2017-07-20 11:00:00	QQQ	ETF	143.99	144.23	143.92	144.14	3193499.0
2017-07-20 12:00:00	QQQ	ETF	144.13	144.33	144.125	144.18	1814753.0
2017-07-20 13:00:00	QQQ	ETF	144.19	144.24	143.98	144.16	1521730.0
2017-07-20 14:00:00	QQQ	ETF	144.16	144.17	143.76	143.99	2080466.0
2017-07-20 15:00:00	QQQ	ETF	143.99	144.29	143.99	144.17	4356512.0
2017-07-20 16:00:00	QQQ	ETF	144.16	144.37	144.14	144.35	3488850.0
2017-07-20 17:00:00	QQQ	ETF	144.26	144.37	144.0	144.29	203674.0
2017-07-20 18:00:00	QQQ	ETF	144.32	144.35	143.9	144.04	166154.0
2017-07-20 19:00:00	QQQ	ETF	144.02	144.06	144.01	144.04	9614.0
2017-07-20 04:00:00	IWM	ETF	143.27	143.27	143.23	143.23	300.0
2017-07-20 05:00:00	IWM	ETF	143.09	143.12	143.08	143.12	1144.0
2017-07-20 06:00:00	IWM	ETF	143.13	143.15	143.13	143.15	5003.0
2017-07-20 07:00:00	IWM	ETF	143.15	143.15	143.15	143.15	3500.0
2017-07-20 08:00:00	IWM	ETF	143.28	143.5	143.05	143.15	112140.0
2017-07-20 09:00:00	IWM	ETF	143.15	143.46	143.01	143.34	1876569.0
2017-07-20 10:00:00	IWM	ETF	143.3473	143.44	142.8	143.25	3576331.0
2017-07-20 11:00:00	IWM	ETF	143.25	143.26	142.84	143.05	2376014.0
2017-07-20 12:00:00	IWM	ETF	143.03	143.35	142.9	143.26	1128519.0
2017-07-20 13:00:00	IWM	ETF	143.26	143.51	143.2	143.48	1564950.0
2017-07-20 14:00:00	IWM	ETF	143.48	143.52	143.33	143.38	1370892.0
2017-07-20 15:00:00	IWM	ETF	143.38	143.47	143.11	143.19	2844860.0
2017-07-20 16:00:00	IWM	ETF	143.2	143.3	143.08	143.3	438784.0
2017-07-20 17:00:00	IWM	ETF	143.23	143.23	143.2	143.2	4440.0
2017-07-20 18:00:00	IWM	ETF	143.2	143.2	143.2	143.2	2375.0
2017-07-20 19:00:00	IWM	ETF	143.19	143.21	143.19	143.2	2382.0
2017-07-20 04:00:00	DIA	ETF	216.48	216.48	216.48	216.48	164.0
2017-07-20 09:00:00	DIA	ETF	216.46	216.59	216.18	216.27	157007.0

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

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