PREVIEW / etf_1hour / 2017-04-18

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-18.parquet
  size:    276 KB
  rows:    8,984

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-04-18 04:00:00	SPY	ETF	234.21	234.21	234.0	234.05	3070.0
2017-04-18 05:00:00	SPY	ETF	234.1	234.11	233.5	233.5	18685.0
2017-04-18 06:00:00	SPY	ETF	233.56	233.9	233.56	233.9	87591.0
2017-04-18 07:00:00	SPY	ETF	233.91	234.23	233.87	234.0	350241.0
2017-04-18 08:00:00	SPY	ETF	234.02	234.09	233.78	233.88	462783.0
2017-04-18 09:00:00	SPY	ETF	233.88	234.46	233.55	234.45	8042706.0
2017-04-18 10:00:00	SPY	ETF	234.46	234.49	233.7265	233.935	13947937.0
2017-04-18 11:00:00	SPY	ETF	233.94	234.13	233.28	233.29	9727272.0
2017-04-18 12:00:00	SPY	ETF	233.29	233.56	233.08	233.44	9841016.0
2017-04-18 13:00:00	SPY	ETF	233.44	233.85	233.27	233.8	6905139.0
2017-04-18 14:00:00	SPY	ETF	233.8	234.145	233.74	233.87	7271220.0
2017-04-18 15:00:00	SPY	ETF	233.87	234.15	233.68	233.86	17118684.0
2017-04-18 16:00:00	SPY	ETF	233.87	233.89	233.74	233.85	8752029.0
2017-04-18 17:00:00	SPY	ETF	233.84	233.85	233.77	233.8	70198.0
2017-04-18 18:00:00	SPY	ETF	233.8	233.85	233.68	233.75	33908.0
2017-04-18 19:00:00	SPY	ETF	233.78	233.94	233.78	233.91	27483.0
2017-04-18 04:00:00	QQQ	ETF	131.34	131.43	131.23	131.23	3174.0
2017-04-18 05:00:00	QQQ	ETF	131.25	131.25	130.97	131.04	20240.0
2017-04-18 06:00:00	QQQ	ETF	131.04	131.04	131.0	131.0	2550.0
2017-04-18 07:00:00	QQQ	ETF	131.07	131.23	131.04	131.18	15147.0
2017-04-18 08:00:00	QQQ	ETF	131.19	131.22	131.05	131.15	47124.0
2017-04-18 09:00:00	QQQ	ETF	131.1	131.64	130.98	131.63	2878233.0
2017-04-18 10:00:00	QQQ	ETF	131.631	131.66	131.14	131.28	2171391.0
2017-04-18 11:00:00	QQQ	ETF	131.29	131.45	131.07	131.07	1314918.0
2017-04-18 12:00:00	QQQ	ETF	131.06	131.15	130.97	131.075	1358778.0
2017-04-18 13:00:00	QQQ	ETF	131.07	131.239	130.95	131.2	1052074.0
2017-04-18 14:00:00	QQQ	ETF	131.2034	131.391	131.161	131.26	1074948.0
2017-04-18 15:00:00	QQQ	ETF	131.28	131.46	131.14	131.29	1879507.0
2017-04-18 16:00:00	QQQ	ETF	131.29	131.39	131.16	131.34	450550.0
2017-04-18 17:00:00	QQQ	ETF	131.28	131.3	131.28	131.3	2696.0
2017-04-18 18:00:00	QQQ	ETF	131.34	131.34	131.28	131.33	11095.0
2017-04-18 19:00:00	QQQ	ETF	131.33	131.45	131.33	131.41	7849.0
2017-04-18 04:00:00	IWM	ETF	135.03	135.03	134.96	134.96	400.0
2017-04-18 05:00:00	IWM	ETF	134.82	134.86	134.51	134.55	9630.0
2017-04-18 06:00:00	IWM	ETF	134.51	134.8	134.51	134.8	6580.0
2017-04-18 07:00:00	IWM	ETF	134.86	135.14	134.86	134.94	123998.0
2017-04-18 08:00:00	IWM	ETF	134.94	135.11	134.77	134.79	123257.0
2017-04-18 09:00:00	IWM	ETF	134.79	135.24	134.51	135.24	2539635.0
2017-04-18 10:00:00	IWM	ETF	135.25	135.28	134.49	134.88	3062495.0
2017-04-18 11:00:00	IWM	ETF	134.8799	135.13	134.44	134.47	2205267.0
2017-04-18 12:00:00	IWM	ETF	134.45	134.705	134.155	134.56	2322883.0
2017-04-18 13:00:00	IWM	ETF	134.56	135.15	134.475	135.01	2199939.0
2017-04-18 14:00:00	IWM	ETF	135.005	135.31	134.815	134.92	2367153.0
2017-04-18 15:00:00	IWM	ETF	134.93	135.46	134.775	135.32	4842098.0
2017-04-18 16:00:00	IWM	ETF	135.32	135.35	135.13	135.2	1937915.0
2017-04-18 19:00:00	IWM	ETF	135.15	135.28	135.15	135.24	3828.0
2017-04-18 07:00:00	DIA	ETF	205.95	205.95	205.69	205.69	999.0
2017-04-18 08:00:00	DIA	ETF	205.71	205.71	205.42	205.45	2400.0
2017-04-18 09:00:00	DIA	ETF	205.5	205.81	205.05	205.74	398074.0
2017-04-18 10:00:00	DIA	ETF	205.77	205.78	205.06	205.25	288685.0

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

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