PREVIEW / etf_1hour / 2017-03-24

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-24.parquet
  size:    266 KB
  rows:    8,716

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-03-24 04:00:00	SPY	ETF	234.2	234.23	234.0	234.21	1614.0
2017-03-24 05:00:00	SPY	ETF	234.12	234.19	234.04	234.04	8699.0
2017-03-24 06:00:00	SPY	ETF	234.06	234.06	233.88	233.92	31128.0
2017-03-24 07:00:00	SPY	ETF	233.95	234.22	233.94	234.01	89422.0
2017-03-24 08:00:00	SPY	ETF	234.04	234.31	234.01	234.18	668808.0
2017-03-24 09:00:00	SPY	ETF	234.18	234.81	234.14	234.62	7788009.0
2017-03-24 10:00:00	SPY	ETF	234.62	234.97	234.46	234.9189	6849699.0
2017-03-24 11:00:00	SPY	ETF	234.92	235.04	234.64	234.835	5350349.0
2017-03-24 12:00:00	SPY	ETF	234.84	234.905	234.14	234.52	11044250.0
2017-03-24 13:00:00	SPY	ETF	234.52	234.62	233.91	233.98	8935052.0
2017-03-24 14:00:00	SPY	ETF	233.98	234.23	233.48	233.54	10203522.0
2017-03-24 15:00:00	SPY	ETF	233.545	234.49	232.96	233.9	41594652.0
2017-03-24 16:00:00	SPY	ETF	233.9	234.26	233.8087	234.02	18157723.0
2017-03-24 17:00:00	SPY	ETF	234.01	234.02	233.85	233.89	197346.0
2017-03-24 18:00:00	SPY	ETF	233.9	233.96	233.88	233.91	21010.0
2017-03-24 19:00:00	SPY	ETF	233.8067	233.96	233.8067	233.94	139424.0
2017-03-24 04:00:00	QQQ	ETF	130.57	130.7	130.57	130.7	900.0
2017-03-24 05:00:00	QQQ	ETF	130.63	130.65	130.59	130.59	2849.0
2017-03-24 06:00:00	QQQ	ETF	130.57	130.57	130.48	130.48	15900.0
2017-03-24 07:00:00	QQQ	ETF	130.5	130.6	130.5	130.54	22368.0
2017-03-24 08:00:00	QQQ	ETF	130.55	130.69	130.54	130.64	43575.0
2017-03-24 09:00:00	QQQ	ETF	130.68	131.24	130.67	131.11	1899151.0
2017-03-24 10:00:00	QQQ	ETF	131.11	131.22	131.0	131.18	1572542.0
2017-03-24 11:00:00	QQQ	ETF	131.19	131.29	131.09	131.25	1090073.0
2017-03-24 12:00:00	QQQ	ETF	131.25	131.27	130.824	131.075	2623716.0
2017-03-24 13:00:00	QQQ	ETF	131.08	131.115	130.68	130.73	2150746.0
2017-03-24 14:00:00	QQQ	ETF	130.73	130.86	130.33	130.35	2426987.0
2017-03-24 15:00:00	QQQ	ETF	130.35	130.99	130.13	130.63	7023568.0
2017-03-24 16:00:00	QQQ	ETF	130.62	130.93	130.59	130.77	705809.0
2017-03-24 17:00:00	QQQ	ETF	130.74	130.8	130.7	130.78	13624.0
2017-03-24 18:00:00	QQQ	ETF	130.8	130.81	130.79	130.79	750.0
2017-03-24 19:00:00	QQQ	ETF	130.78	130.79	130.74	130.79	2174.0
2017-03-24 04:00:00	IWM	ETF	134.7	134.7	134.64	134.64	300.0
2017-03-24 05:00:00	IWM	ETF	134.55	134.55	134.55	134.55	100.0
2017-03-24 06:00:00	IWM	ETF	134.55	134.55	134.35	134.38	903.0
2017-03-24 07:00:00	IWM	ETF	134.42	134.74	134.42	134.58	92618.0
2017-03-24 08:00:00	IWM	ETF	134.57	134.82	134.54	134.7	47788.0
2017-03-24 09:00:00	IWM	ETF	134.72	135.3	134.72	135.06	2933945.0
2017-03-24 10:00:00	IWM	ETF	135.06	135.47	135.02	135.33	2975879.0
2017-03-24 11:00:00	IWM	ETF	135.34	135.39	134.88	135.29	1770799.0
2017-03-24 12:00:00	IWM	ETF	135.27	135.38	134.66	134.9143	3450631.0
2017-03-24 13:00:00	IWM	ETF	134.92	134.98	134.41	134.515	2574229.0
2017-03-24 14:00:00	IWM	ETF	134.51	134.78	134.18	134.23	2243567.0
2017-03-24 15:00:00	IWM	ETF	134.23	134.98	133.86	134.5	10481697.0
2017-03-24 16:00:00	IWM	ETF	134.5	135.4333	134.49	134.5	1813431.0
2017-03-24 17:00:00	IWM	ETF	134.5	134.6	134.49	134.6	8440.0
2017-03-24 18:00:00	IWM	ETF	134.56	134.68	134.55	134.68	842.0
2017-03-24 19:00:00	IWM	ETF	134.67	134.67	134.6	134.6	1020.0
2017-03-24 08:00:00	DIA	ETF	206.67	206.67	206.4	206.4	600.0
2017-03-24 09:00:00	DIA	ETF	206.58	206.8	206.47	206.58	177734.0

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

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