PREVIEW / etf_1hour / 2017-12-05

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-05.parquet
  size:    295 KB
  rows:    9,680

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-12-05 04:00:00	SPY	ETF	264.3	264.46	264.3	264.46	3200.0
2017-12-05 05:00:00	SPY	ETF	264.46	264.46	263.83	263.83	2304.0
2017-12-05 06:00:00	SPY	ETF	263.97	264.31	263.95	264.26	22833.0
2017-12-05 07:00:00	SPY	ETF	264.3	264.69	264.24	264.62	288991.0
2017-12-05 08:00:00	SPY	ETF	264.14	264.74	264.14	264.33	445863.0
2017-12-05 09:00:00	SPY	ETF	264.35	264.65	264.09	264.17	6228950.0
2017-12-05 10:00:00	SPY	ETF	264.17	264.89	264.14	264.8	13838727.0
2017-12-05 11:00:00	SPY	ETF	264.805	265.15	264.57	264.63	6244086.0
2017-12-05 12:00:00	SPY	ETF	264.63	264.66	264.16	264.2345	7392290.0
2017-12-05 13:00:00	SPY	ETF	264.2375	264.515	264.11	264.35	3506173.0
2017-12-05 14:00:00	SPY	ETF	264.35	264.42	263.35	263.495	10111872.0
2017-12-05 15:00:00	SPY	ETF	263.5	263.66	263.04	263.2	23157961.0
2017-12-05 16:00:00	SPY	ETF	263.2	263.57	263.01	263.05	4896993.0
2017-12-05 17:00:00	SPY	ETF	263.05	263.08	262.93	262.97	134595.0
2017-12-05 18:00:00	SPY	ETF	263.0	263.25	263.0	263.22	92380.0
2017-12-05 19:00:00	SPY	ETF	263.24	263.43	263.18	263.38	18791.0
2017-12-05 04:00:00	QQQ	ETF	152.75	152.75	152.44	152.55	17284.0
2017-12-05 05:00:00	QQQ	ETF	152.54	152.54	152.09	152.09	8120.0
2017-12-05 06:00:00	QQQ	ETF	152.08	152.29	151.94	152.28	69076.0
2017-12-05 07:00:00	QQQ	ETF	152.3	152.92	152.2	152.8	165154.0
2017-12-05 08:00:00	QQQ	ETF	152.82	152.97	152.22	152.76	257371.0
2017-12-05 09:00:00	QQQ	ETF	152.77	153.94	152.1	153.68	6454967.0
2017-12-05 10:00:00	QQQ	ETF	153.685	154.1	153.57	154.06	5539544.0
2017-12-05 11:00:00	QQQ	ETF	154.0725	154.55	153.8817	153.96	5127365.0
2017-12-05 12:00:00	QQQ	ETF	153.95	154.04	153.47	153.58	3489466.0
2017-12-05 13:00:00	QQQ	ETF	153.5701	153.89	153.36	153.71	2825424.0
2017-12-05 14:00:00	QQQ	ETF	153.71	153.74	152.74	152.88	3522283.0
2017-12-05 15:00:00	QQQ	ETF	152.87	153.2	152.665	152.78	5740583.0
2017-12-05 16:00:00	QQQ	ETF	152.78	153.8761	152.78	152.81	4608829.0
2017-12-05 17:00:00	QQQ	ETF	152.8	152.89	152.8	152.85	24571.0
2017-12-05 18:00:00	QQQ	ETF	152.87	152.97	152.87	152.97	23728.0
2017-12-05 19:00:00	QQQ	ETF	152.95	153.05	152.94	153.0	14209.0
2017-12-05 04:00:00	IWM	ETF	152.7	152.79	152.7	152.79	800.0
2017-12-05 05:00:00	IWM	ETF	152.71	152.71	152.46	152.48	5706.0
2017-12-05 06:00:00	IWM	ETF	152.44	152.74	152.44	152.72	17895.0
2017-12-05 07:00:00	IWM	ETF	152.7	153.02	152.64	153.01	38942.0
2017-12-05 08:00:00	IWM	ETF	153.0	153.08	152.75	152.82	68823.0
2017-12-05 09:00:00	IWM	ETF	152.85	153.16	152.16	152.31	2507184.0
2017-12-05 10:00:00	IWM	ETF	152.3	152.83	151.73	151.93	4092960.0
2017-12-05 11:00:00	IWM	ETF	151.94	152.73	151.94	152.135	2337202.0
2017-12-05 12:00:00	IWM	ETF	152.14	152.28	151.785	151.87	1578985.0
2017-12-05 13:00:00	IWM	ETF	151.87	152.3	151.79	152.01	2353162.0
2017-12-05 14:00:00	IWM	ETF	152.01	152.15	151.11	151.33	3353456.0
2017-12-05 15:00:00	IWM	ETF	151.33	151.57	150.93	150.93	5642464.0
2017-12-05 16:00:00	IWM	ETF	150.93	151.5744	150.77	150.93	4008034.0
2017-12-05 17:00:00	IWM	ETF	150.89	150.89	150.89	150.89	1800.0
2017-12-05 18:00:00	IWM	ETF	151.0	151.05	150.93	151.04	5376.0
2017-12-05 19:00:00	IWM	ETF	151.08	151.19	151.03	151.13	9661.0
2017-12-05 05:00:00	DIA	ETF	243.95	243.95	243.3	243.3	2700.0
2017-12-05 06:00:00	DIA	ETF	243.38	243.89	243.38	243.88	1488.0

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

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