PREVIEW / etf_1hour / 2016-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-07.parquet
  size:    255 KB
  rows:    8,155

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-07-07 04:00:00	SPY	ETF	209.92	210.27	209.86	210.06	22650.0
2016-07-07 05:00:00	SPY	ETF	210.0	210.0	209.66	209.9	24236.0
2016-07-07 06:00:00	SPY	ETF	209.84	209.94	209.56	209.56	23190.0
2016-07-07 07:00:00	SPY	ETF	209.6	209.69	209.43	209.5	353689.0
2016-07-07 08:00:00	SPY	ETF	209.5	209.9	209.45	209.77	710827.0
2016-07-07 09:00:00	SPY	ETF	209.77	210.6495	209.67	210.56	9101474.0
2016-07-07 10:00:00	SPY	ETF	210.56	210.595	209.91	210.0	9100452.0
2016-07-07 11:00:00	SPY	ETF	209.99	210.03	209.4	209.69	12603887.0
2016-07-07 12:00:00	SPY	ETF	209.7	209.79	209.06	209.11	8187095.0
2016-07-07 13:00:00	SPY	ETF	209.11	209.45	208.96	209.2207	9629941.0
2016-07-07 14:00:00	SPY	ETF	209.22	209.35	208.65	208.74	10337569.0
2016-07-07 15:00:00	SPY	ETF	208.73	209.62	208.63	209.53	17060016.0
2016-07-07 16:00:00	SPY	ETF	209.54	209.67	209.44	209.66	7424445.0
2016-07-07 17:00:00	SPY	ETF	209.66	209.67	209.58	209.63	119043.0
2016-07-07 18:00:00	SPY	ETF	209.58	209.68	209.52	209.59	83596.0
2016-07-07 19:00:00	SPY	ETF	209.6	209.71	209.59	209.61	75184.0
2016-07-07 04:00:00	QQQ	ETF	108.47	108.5	108.47	108.5	997.0
2016-07-07 06:00:00	QQQ	ETF	108.43	108.43	108.41	108.42	1100.0
2016-07-07 07:00:00	QQQ	ETF	108.25	108.3	108.19	108.23	90227.0
2016-07-07 08:00:00	QQQ	ETF	108.19	108.4	108.19	108.37	362665.0
2016-07-07 09:00:00	QQQ	ETF	108.37	108.86	108.33	108.79	2702486.0
2016-07-07 10:00:00	QQQ	ETF	108.79	108.81	108.42	108.45	1684844.0
2016-07-07 11:00:00	QQQ	ETF	108.44	108.58	108.27	108.415	2021514.0
2016-07-07 12:00:00	QQQ	ETF	108.41	108.57	108.17	108.18	2423365.0
2016-07-07 13:00:00	QQQ	ETF	108.18	108.47	108.11	108.3801	1766186.0
2016-07-07 14:00:00	QQQ	ETF	108.385	108.5	108.16	108.21	2159907.0
2016-07-07 15:00:00	QQQ	ETF	108.2	108.7	108.16	108.62	3427186.0
2016-07-07 16:00:00	QQQ	ETF	108.59	108.66	108.58	108.65	714748.0
2016-07-07 17:00:00	QQQ	ETF	108.65	108.68	108.62	108.62	6621.0
2016-07-07 18:00:00	QQQ	ETF	108.62	108.62	108.59	108.6	35436.0
2016-07-07 19:00:00	QQQ	ETF	108.62	108.71	108.62	108.66	7737.0
2016-07-07 05:00:00	IWM	ETF	113.92	113.92	113.91	113.91	500.0
2016-07-07 06:00:00	IWM	ETF	114.05	114.06	114.05	114.06	900.0
2016-07-07 07:00:00	IWM	ETF	113.87	113.93	113.82	113.83	80050.0
2016-07-07 08:00:00	IWM	ETF	113.9	114.19	113.9	114.16	105566.0
2016-07-07 09:00:00	IWM	ETF	114.13	114.97	114.1	114.85	2825306.0
2016-07-07 10:00:00	IWM	ETF	114.85	114.99	114.32	114.35	2633016.0
2016-07-07 11:00:00	IWM	ETF	114.33	114.59	113.84	114.16	2595596.0
2016-07-07 12:00:00	IWM	ETF	114.17	114.24	113.51	113.53	2201073.0
2016-07-07 13:00:00	IWM	ETF	113.51	113.95	113.41	113.88	1585950.0
2016-07-07 14:00:00	IWM	ETF	113.875	113.96	113.51	113.62	2244217.0
2016-07-07 15:00:00	IWM	ETF	113.62	114.31	113.57	114.2	3546509.0
2016-07-07 16:00:00	IWM	ETF	114.2	114.22	114.06	114.2	944449.0
2016-07-07 17:00:00	IWM	ETF	114.2	114.2	114.19	114.2	18100.0
2016-07-07 18:00:00	IWM	ETF	114.2	114.2	114.2	114.2	1500.0
2016-07-07 19:00:00	IWM	ETF	114.2	114.2	114.13	114.15	2450.0
2016-07-07 07:00:00	DIA	ETF	178.99	178.99	178.99	178.99	556.0
2016-07-07 08:00:00	DIA	ETF	178.77	178.99	178.77	178.99	1000.0
2016-07-07 09:00:00	DIA	ETF	179.11	179.7233	179.11	179.62	276119.0
2016-07-07 10:00:00	DIA	ETF	179.66	179.7	179.1188	179.18	228681.0

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

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