PREVIEW / etf_1hour / 2016-04-14

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-14.parquet
  size:    249 KB
  rows:    8,043

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
2016-04-14 04:00:00	SPY	ETF	207.62	207.67	207.34	207.51	16761.0
2016-04-14 05:00:00	SPY	ETF	207.66	207.94	207.52	207.87	45124.0
2016-04-14 06:00:00	SPY	ETF	207.87	208.03	207.76	207.9	24933.0
2016-04-14 07:00:00	SPY	ETF	207.95	208.04	207.75	207.96	104220.0
2016-04-14 08:00:00	SPY	ETF	207.95	208.35	207.67	208.25	803646.0
2016-04-14 09:00:00	SPY	ETF	208.27	208.27	207.6	207.7192	9789585.0
2016-04-14 10:00:00	SPY	ETF	207.69	208.18	207.62	208.04	9552802.0
2016-04-14 11:00:00	SPY	ETF	208.03	208.375	207.905	208.31	8066575.0
2016-04-14 12:00:00	SPY	ETF	208.31	208.53	208.17	208.45	6032260.0
2016-04-14 13:00:00	SPY	ETF	208.45	208.6	208.06	208.08	6332993.0
2016-04-14 14:00:00	SPY	ETF	208.08	208.31	207.9	208.09	7755151.0
2016-04-14 15:00:00	SPY	ETF	208.09	208.27	207.94	208.01	9868589.0
2016-04-14 16:00:00	SPY	ETF	208.02	208.22	207.97	208.21	6172841.0
2016-04-14 17:00:00	SPY	ETF	208.2	208.24	208.17	208.21	75249.0
2016-04-14 18:00:00	SPY	ETF	208.19	208.2	208.02	208.05	118479.0
2016-04-14 19:00:00	SPY	ETF	208.1	208.13	208.06	208.07	31940.0
2016-04-14 06:00:00	QQQ	ETF	110.85	110.85	110.85	110.85	999.0
2016-04-14 07:00:00	QQQ	ETF	110.87	110.93	110.81	110.9	8431.0
2016-04-14 08:00:00	QQQ	ETF	110.91	111.06	110.85	110.98	77996.0
2016-04-14 09:00:00	QQQ	ETF	110.97	111.0	110.0	110.73	2383077.0
2016-04-14 10:00:00	QQQ	ETF	110.729	111.04	110.66	110.96	2968010.0
2016-04-14 11:00:00	QQQ	ETF	110.95	111.155	110.75	111.15	1699984.0
2016-04-14 12:00:00	QQQ	ETF	111.15	111.23	110.99	111.22	1390143.0
2016-04-14 13:00:00	QQQ	ETF	111.22	111.33	110.89	110.89	1369168.0
2016-04-14 14:00:00	QQQ	ETF	110.89	111.03	110.765	110.93	2774101.0
2016-04-14 15:00:00	QQQ	ETF	110.93	111.065	110.88	110.92	2131375.0
2016-04-14 16:00:00	QQQ	ETF	110.91	110.96	110.89	110.95	310077.0
2016-04-14 17:00:00	QQQ	ETF	110.98	111.0	110.92	110.94	5324.0
2016-04-14 18:00:00	QQQ	ETF	110.99	110.99	110.89	110.9	3115.0
2016-04-14 19:00:00	QQQ	ETF	110.93	110.93	110.91	110.92	13281.0
2016-04-14 06:00:00	IWM	ETF	112.38	112.38	112.24	112.24	1200.0
2016-04-14 07:00:00	IWM	ETF	112.3	112.34	112.23	112.28	10874.0
2016-04-14 08:00:00	IWM	ETF	112.27	112.44	112.21	112.41	35243.0
2016-04-14 09:00:00	IWM	ETF	112.39	112.4	111.91	111.99	2696452.0
2016-04-14 10:00:00	IWM	ETF	112.0	112.37	111.88	112.06	3101398.0
2016-04-14 11:00:00	IWM	ETF	112.05	112.7	112.01	112.42	2845648.0
2016-04-14 12:00:00	IWM	ETF	112.425	112.55	112.25	112.44	1861054.0
2016-04-14 13:00:00	IWM	ETF	112.44	112.505	112.14	112.2	1950902.0
2016-04-14 14:00:00	IWM	ETF	112.2	112.46	112.15	112.4	2708981.0
2016-04-14 15:00:00	IWM	ETF	112.4	112.48	112.09	112.2	3679939.0
2016-04-14 16:00:00	IWM	ETF	112.2	112.23	112.1	112.2	867455.0
2016-04-14 17:00:00	IWM	ETF	112.17	112.22	112.17	112.17	726.0
2016-04-14 18:00:00	IWM	ETF	112.17	112.17	112.17	112.17	18226.0
2016-04-14 19:00:00	IWM	ETF	112.17	112.17	112.17	112.17	100.0
2016-04-14 08:00:00	DIA	ETF	179.11	179.3	179.0	179.25	813.0
2016-04-14 09:00:00	DIA	ETF	179.25	179.27	178.7499	178.82	437007.0
2016-04-14 10:00:00	DIA	ETF	178.84	179.19	178.748	179.09	430970.0
2016-04-14 11:00:00	DIA	ETF	179.06	179.33	179.04	179.31	293137.0
2016-04-14 12:00:00	DIA	ETF	179.32	179.4399	179.15	179.37	330816.0
2016-04-14 13:00:00	DIA	ETF	179.37	179.5	179.13	179.1499	272736.0

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

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