PREVIEW / etf_1hour / 2017-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-06.parquet
  size:    282 KB
  rows:    9,246

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-10-06 04:00:00	SPY	ETF	254.6	254.6	254.54	254.54	3100.0
2017-10-06 05:00:00	SPY	ETF	254.52	254.59	254.52	254.56	2710.0
2017-10-06 06:00:00	SPY	ETF	254.63	254.63	254.58	254.6	7200.0
2017-10-06 07:00:00	SPY	ETF	254.62	254.66	254.55	254.55	85724.0
2017-10-06 08:00:00	SPY	ETF	254.57	254.57	254.05	254.05	1658176.0
2017-10-06 09:00:00	SPY	ETF	254.05	254.36	254.04	254.305	6074502.0
2017-10-06 10:00:00	SPY	ETF	254.305	254.46	253.88	254.0	12831845.0
2017-10-06 11:00:00	SPY	ETF	253.9987	254.16	253.87	253.97	7370768.0
2017-10-06 12:00:00	SPY	ETF	253.97	254.19	253.85	254.075	5691694.0
2017-10-06 13:00:00	SPY	ETF	254.08	254.11	253.91	254.0725	5520145.0
2017-10-06 14:00:00	SPY	ETF	254.07	254.7008	254.045	254.29	12386527.0
2017-10-06 15:00:00	SPY	ETF	254.29	254.42	254.145	254.4	12242817.0
2017-10-06 16:00:00	SPY	ETF	254.41	254.44	254.15	254.22	15270896.0
2017-10-06 17:00:00	SPY	ETF	254.23	254.29	254.18	254.29	148358.0
2017-10-06 18:00:00	SPY	ETF	254.25	254.29	254.25	254.28	3835.0
2017-10-06 19:00:00	SPY	ETF	254.28	254.29	254.24	254.26	18502.0
2017-10-06 04:00:00	QQQ	ETF	147.6	147.6	147.52	147.52	11303.0
2017-10-06 05:00:00	QQQ	ETF	147.49	147.61	147.49	147.61	500.0
2017-10-06 06:00:00	QQQ	ETF	147.66	147.69	147.66	147.68	6000.0
2017-10-06 07:00:00	QQQ	ETF	147.65	147.67	147.59	147.62	11500.0
2017-10-06 08:00:00	QQQ	ETF	147.64	147.66	147.0	147.04	642310.0
2017-10-06 09:00:00	QQQ	ETF	147.03	147.4	146.9	147.3066	4295794.0
2017-10-06 10:00:00	QQQ	ETF	147.3	147.52	146.99	147.13	4252717.0
2017-10-06 11:00:00	QQQ	ETF	147.14	147.42	147.13	147.38	1244784.0
2017-10-06 12:00:00	QQQ	ETF	147.375	147.64	147.26	147.509	1848822.0
2017-10-06 13:00:00	QQQ	ETF	147.505	147.54	147.38	147.49	1033236.0
2017-10-06 14:00:00	QQQ	ETF	147.48	147.56	147.4112	147.5	1161860.0
2017-10-06 15:00:00	QQQ	ETF	147.5	147.65	147.3525	147.62	3293257.0
2017-10-06 16:00:00	QQQ	ETF	147.66	147.66	147.5	147.58	1288383.0
2017-10-06 17:00:00	QQQ	ETF	147.58	147.59	147.56	147.56	1236.0
2017-10-06 18:00:00	QQQ	ETF	147.6	147.6	147.6	147.6	200.0
2017-10-06 19:00:00	QQQ	ETF	147.55	147.58	147.55	147.56	1331.0
2017-10-06 05:00:00	IWM	ETF	150.28	150.28	150.28	150.28	503.0
2017-10-06 06:00:00	IWM	ETF	150.27	150.32	150.26	150.32	8006.0
2017-10-06 07:00:00	IWM	ETF	150.34	150.34	150.26	150.26	16256.0
2017-10-06 08:00:00	IWM	ETF	150.34	150.34	149.77	149.8	69514.0
2017-10-06 09:00:00	IWM	ETF	149.78	150.34	149.67	150.15	3399076.0
2017-10-06 10:00:00	IWM	ETF	150.14	150.27	149.75	149.7885	2236082.0
2017-10-06 11:00:00	IWM	ETF	149.78	149.95	149.63	149.72	1496197.0
2017-10-06 12:00:00	IWM	ETF	149.72	150.01	149.57	149.91	1211301.0
2017-10-06 13:00:00	IWM	ETF	149.92	149.96	149.605	149.87	1401944.0
2017-10-06 14:00:00	IWM	ETF	149.87	150.04	149.82	150.0	676799.0
2017-10-06 15:00:00	IWM	ETF	149.99	150.1399	149.9	150.06	3173050.0
2017-10-06 16:00:00	IWM	ETF	150.05	150.16	149.79	149.97	1639659.0
2017-10-06 17:00:00	IWM	ETF	149.97	149.97	149.94	149.94	920.0
2017-10-06 18:00:00	IWM	ETF	149.94	150.05	149.93	150.05	5665.0
2017-10-06 19:00:00	IWM	ETF	150.05	150.05	150.0	150.02	4435.0
2017-10-06 07:00:00	DIA	ETF	227.74	227.74	227.66	227.68	1776.0
2017-10-06 08:00:00	DIA	ETF	227.64	227.66	227.37	227.37	9256.0
2017-10-06 09:00:00	DIA	ETF	227.35	227.56	227.3	227.51	265234.0

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

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