PREVIEW / etf_1hour / 2018-11-09

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-09.parquet
  size:    314 KB
  rows:    10,322

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
2018-11-09 04:00:00	SPY	ETF	279.38	279.63	279.08	279.5	50830.0
2018-11-09 05:00:00	SPY	ETF	279.5	279.54	278.82	278.98	103711.0
2018-11-09 06:00:00	SPY	ETF	278.93	279.19	278.69	279.05	132823.0
2018-11-09 07:00:00	SPY	ETF	279.04	279.32	278.85	279.31	187757.0
2018-11-09 08:00:00	SPY	ETF	279.31	280.55	278.91	279.19	576292.0
2018-11-09 09:00:00	SPY	ETF	279.18	279.3	278.11	278.43	8474243.0
2018-11-09 10:00:00	SPY	ETF	278.4301	278.66	277.53	277.96	11341087.0
2018-11-09 11:00:00	SPY	ETF	277.97	278.31	276.98	277.14	9629988.0
2018-11-09 12:00:00	SPY	ETF	277.14	277.76	276.81	277.285	8492266.0
2018-11-09 13:00:00	SPY	ETF	277.29	277.445	276.52	276.74	7541441.0
2018-11-09 14:00:00	SPY	ETF	276.73	277.99	276.18	277.5699	12711427.0
2018-11-09 15:00:00	SPY	ETF	277.565	278.83	277.41	277.83	24291005.0
2018-11-09 16:00:00	SPY	ETF	277.82	277.95	277.4	277.59	12905136.0
2018-11-09 17:00:00	SPY	ETF	277.5	277.58	277.3	277.5	236265.0
2018-11-09 18:00:00	SPY	ETF	277.44	277.48	277.21	277.35	25530.0
2018-11-09 19:00:00	SPY	ETF	277.33	277.33	277.1	277.14	19247.0
2018-11-09 04:00:00	QQQ	ETF	173.34	173.53	173.22	173.46	8403.0
2018-11-09 05:00:00	QQQ	ETF	173.46	173.5	172.99	173.03	38425.0
2018-11-09 06:00:00	QQQ	ETF	173.03	173.18	172.73	173.0	73486.0
2018-11-09 07:00:00	QQQ	ETF	173.0	173.16	172.8	173.12	195363.0
2018-11-09 08:00:00	QQQ	ETF	173.05	173.3	172.81	173.07	272910.0
2018-11-09 09:00:00	QQQ	ETF	173.05	173.25	172.1	172.47	5612994.0
2018-11-09 10:00:00	QQQ	ETF	172.47	172.729	171.57	171.83	6793964.0
2018-11-09 11:00:00	QQQ	ETF	171.83	172.0901	170.93	171.02	5024015.0
2018-11-09 12:00:00	QQQ	ETF	171.0198	171.4	170.7999	171.065	3847666.0
2018-11-09 13:00:00	QQQ	ETF	171.07	171.29	170.46	170.58	3391157.0
2018-11-09 14:00:00	QQQ	ETF	170.57	171.57	170.16	171.27	5518261.0
2018-11-09 15:00:00	QQQ	ETF	171.28	172.08	171.2	171.55	8560724.0
2018-11-09 16:00:00	QQQ	ETF	171.54	171.6	171.0	171.15	1727545.0
2018-11-09 17:00:00	QQQ	ETF	171.24	171.25	171.03	171.03	45081.0
2018-11-09 18:00:00	QQQ	ETF	171.13	171.13	171.03	171.07	10303.0
2018-11-09 19:00:00	QQQ	ETF	171.07	171.08	170.92	170.95	11655.0
2018-11-09 04:00:00	IWM	ETF	156.22	156.23	156.14	156.14	6000.0
2018-11-09 05:00:00	IWM	ETF	156.2	156.2	155.98	156.02	10658.0
2018-11-09 06:00:00	IWM	ETF	156.04	156.1	155.84	155.96	5800.0
2018-11-09 07:00:00	IWM	ETF	156.13	156.13	155.85	155.98	5809.0
2018-11-09 08:00:00	IWM	ETF	156.04	156.98	155.94	156.07	25388.0
2018-11-09 09:00:00	IWM	ETF	156.05	156.18	155.075	155.23	1643056.0
2018-11-09 10:00:00	IWM	ETF	155.23	155.27	154.38	154.82	2172898.0
2018-11-09 11:00:00	IWM	ETF	154.86	155.14	153.92	154.03	1707046.0
2018-11-09 12:00:00	IWM	ETF	154.03	154.25	153.625	153.93	1726652.0
2018-11-09 13:00:00	IWM	ETF	153.92	154.06	153.08	153.28	1946534.0
2018-11-09 14:00:00	IWM	ETF	153.27	154.06	152.9501	153.81	2728116.0
2018-11-09 15:00:00	IWM	ETF	153.81	154.51	153.64	154.12	4041494.0
2018-11-09 16:00:00	IWM	ETF	154.12	154.2	153.98	154.19	1053517.0
2018-11-09 17:00:00	IWM	ETF	154.13	154.15	154.01	154.02	7474.0
2018-11-09 18:00:00	IWM	ETF	154.04	154.04	153.99	153.99	3250.0
2018-11-09 19:00:00	IWM	ETF	153.99	153.99	153.99	153.99	300.0
2018-11-09 04:00:00	DIA	ETF	261.35	261.51	261.35	261.5	900.0
2018-11-09 05:00:00	DIA	ETF	261.0	261.0	261.0	261.0	200.0

> showing 50 of 10,322 rows — these rows as CSV

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