PREVIEW / etf_1hour / 2017-12-26

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-26.parquet
  size:    279 KB
  rows:    9,283

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-26 04:00:00	SPY	ETF	267.26	267.26	267.26	267.26	261.0
2017-12-26 05:00:00	SPY	ETF	267.29	267.29	267.26	267.26	1046.0
2017-12-26 06:00:00	SPY	ETF	267.25	267.25	267.1	267.1	9290.0
2017-12-26 07:00:00	SPY	ETF	267.09	267.11	266.94	266.98	22834.0
2017-12-26 08:00:00	SPY	ETF	267.02	267.14	266.85	267.03	583350.0
2017-12-26 09:00:00	SPY	ETF	267.03	267.35	266.9	267.21	4008793.0
2017-12-26 10:00:00	SPY	ETF	267.22	267.39	267.06	267.069	5468610.0
2017-12-26 11:00:00	SPY	ETF	267.07	267.25	267.03	267.18	3295452.0
2017-12-26 12:00:00	SPY	ETF	267.185	267.24	267.06	267.13	4621158.0
2017-12-26 13:00:00	SPY	ETF	267.125	267.185	267.01	267.08	3251197.0
2017-12-26 14:00:00	SPY	ETF	267.08	267.4377	267.02	267.155	5381503.0
2017-12-26 15:00:00	SPY	ETF	267.155	267.18	266.885	267.17	10461071.0
2017-12-26 16:00:00	SPY	ETF	267.16	267.24	267.07	267.22	6452240.0
2017-12-26 17:00:00	SPY	ETF	267.18	267.25	267.18	267.25	8073.0
2017-12-26 18:00:00	SPY	ETF	267.24	267.32	267.19	267.29	124047.0
2017-12-26 19:00:00	SPY	ETF	267.31	267.36	267.31	267.32	9580.0
2017-12-26 04:00:00	QQQ	ETF	157.02	157.02	156.98	156.98	2950.0
2017-12-26 05:00:00	QQQ	ETF	156.95	157.06	156.95	157.06	7958.0
2017-12-26 06:00:00	QQQ	ETF	156.94	156.94	156.73	156.73	5220.0
2017-12-26 07:00:00	QQQ	ETF	156.77	156.77	156.31	156.33	31167.0
2017-12-26 08:00:00	QQQ	ETF	156.37	156.56	156.28	156.5	112310.0
2017-12-26 09:00:00	QQQ	ETF	156.47	156.63	155.95	156.205	4440207.0
2017-12-26 10:00:00	QQQ	ETF	156.201	156.5599	156.17	156.26	1491090.0
2017-12-26 11:00:00	QQQ	ETF	156.24	156.4855	156.19	156.45	1076164.0
2017-12-26 12:00:00	QQQ	ETF	156.46	156.72	156.415	156.64	1019535.0
2017-12-26 13:00:00	QQQ	ETF	156.64	156.675	156.48	156.555	889421.0
2017-12-26 14:00:00	QQQ	ETF	156.555	156.59	156.47	156.5	1759850.0
2017-12-26 15:00:00	QQQ	ETF	156.5	156.57	156.35	156.55	3431563.0
2017-12-26 16:00:00	QQQ	ETF	156.54	156.66	156.45	156.53	931882.0
2017-12-26 17:00:00	QQQ	ETF	156.53	156.54	156.53	156.54	3362.0
2017-12-26 18:00:00	QQQ	ETF	156.54	156.6	156.53	156.59	10260.0
2017-12-26 19:00:00	QQQ	ETF	156.58	156.64	156.56	156.64	5582.0
2017-12-26 05:00:00	IWM	ETF	153.2	153.2	153.2	153.2	244.0
2017-12-26 07:00:00	IWM	ETF	152.91	152.91	152.9	152.9	500.0
2017-12-26 08:00:00	IWM	ETF	152.98	153.11	152.85	153.05	78959.0
2017-12-26 09:00:00	IWM	ETF	153.04	153.37	152.97	153.25	1198985.0
2017-12-26 10:00:00	IWM	ETF	153.24	153.36	152.9	152.935	1472487.0
2017-12-26 11:00:00	IWM	ETF	152.94	153.3	152.91	153.225	889021.0
2017-12-26 12:00:00	IWM	ETF	153.23	153.43	153.21	153.25	850157.0
2017-12-26 13:00:00	IWM	ETF	153.24	153.39	153.24	153.245	1147458.0
2017-12-26 14:00:00	IWM	ETF	153.245	153.36	153.18	153.29	1009187.0
2017-12-26 15:00:00	IWM	ETF	153.29	153.36	153.115	153.28	2606614.0
2017-12-26 16:00:00	IWM	ETF	153.28	153.28	153.14	153.16	1253189.0
2017-12-26 17:00:00	IWM	ETF	153.25	153.27	153.2	153.2	1697.0
2017-12-26 18:00:00	IWM	ETF	153.2	153.27	153.18	153.27	4979.0
2017-12-26 19:00:00	IWM	ETF	153.28	153.3	153.28	153.3	1100.0
2017-12-26 07:00:00	DIA	ETF	247.0	247.0	246.7	246.7	2020.0
2017-12-26 09:00:00	DIA	ETF	246.92	247.585	246.86	247.36	312864.0
2017-12-26 10:00:00	DIA	ETF	247.36	247.52	247.22	247.24	302968.0
2017-12-26 11:00:00	DIA	ETF	247.2158	247.37	247.14	247.19	226068.0

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

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