PREVIEW / etf_1hour / 2016-07-05

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-05.parquet
  size:    256 KB
  rows:    8,216

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-05 04:00:00	SPY	ETF	209.21	209.21	208.64	208.67	100611.0
2016-07-05 05:00:00	SPY	ETF	208.75	208.93	208.68	208.88	27565.0
2016-07-05 06:00:00	SPY	ETF	208.84	209.18	208.83	209.15	46941.0
2016-07-05 07:00:00	SPY	ETF	209.15	209.2	208.61	208.63	339051.0
2016-07-05 08:00:00	SPY	ETF	208.63	209.15	208.55	208.98	618009.0
2016-07-05 09:00:00	SPY	ETF	208.99	209.08	208.2	208.4	14272000.0
2016-07-05 10:00:00	SPY	ETF	208.41	208.77	208.13	208.375	14269790.0
2016-07-05 11:00:00	SPY	ETF	208.38	208.63	207.92	208.19	15615144.0
2016-07-05 12:00:00	SPY	ETF	208.19	208.46	208.06	208.2	9060932.0
2016-07-05 13:00:00	SPY	ETF	208.2	208.2816	207.71	207.865	8974763.0
2016-07-05 14:00:00	SPY	ETF	207.87	208.35	207.72	208.0	13590134.0
2016-07-05 15:00:00	SPY	ETF	208.0	208.8	207.92	208.43	22176958.0
2016-07-05 16:00:00	SPY	ETF	208.44	208.87	208.39	208.86	7581408.0
2016-07-05 17:00:00	SPY	ETF	208.83	208.85	208.41	208.8	243171.0
2016-07-05 18:00:00	SPY	ETF	208.8	208.84	208.52	208.58	147392.0
2016-07-05 19:00:00	SPY	ETF	208.6	208.7	208.33	208.45	176781.0
2016-07-05 04:00:00	QQQ	ETF	107.82	107.82	107.45	107.45	25632.0
2016-07-05 05:00:00	QQQ	ETF	107.54	107.54	107.5	107.51	2335.0
2016-07-05 06:00:00	QQQ	ETF	107.52	107.67	107.52	107.65	1500.0
2016-07-05 07:00:00	QQQ	ETF	107.67	107.7	107.38	107.41	37899.0
2016-07-05 08:00:00	QQQ	ETF	107.44	107.6	107.41	107.59	56026.0
2016-07-05 09:00:00	QQQ	ETF	107.59	107.66	107.1	107.301	3033777.0
2016-07-05 10:00:00	QQQ	ETF	107.31	107.53	107.05	107.24	2926426.0
2016-07-05 11:00:00	QQQ	ETF	107.23	107.43	107.015	107.13	2898435.0
2016-07-05 12:00:00	QQQ	ETF	107.14	107.35	107.1	107.19	972378.0
2016-07-05 13:00:00	QQQ	ETF	107.19	107.255	106.84	106.95	1984509.0
2016-07-05 14:00:00	QQQ	ETF	106.95	107.23	106.84	107.05	1762526.0
2016-07-05 15:00:00	QQQ	ETF	107.04	107.5556	107.0	107.43	5034800.0
2016-07-05 16:00:00	QQQ	ETF	107.42	107.57	107.39	107.57	1875757.0
2016-07-05 17:00:00	QQQ	ETF	107.6	107.6	107.44	107.5	14217.0
2016-07-05 18:00:00	QQQ	ETF	107.54	107.54	107.38	107.38	8745.0
2016-07-05 19:00:00	QQQ	ETF	107.41	107.42	107.27	107.33	12295.0
2016-07-05 04:00:00	IWM	ETF	114.75	114.75	114.66	114.66	11700.0
2016-07-05 05:00:00	IWM	ETF	114.75	114.75	114.73	114.73	200.0
2016-07-05 06:00:00	IWM	ETF	114.86	115.0	114.86	115.0	200.0
2016-07-05 07:00:00	IWM	ETF	115.02	115.02	114.65	114.65	32784.0
2016-07-05 08:00:00	IWM	ETF	115.07	115.07	114.59	115.0	80403.0
2016-07-05 09:00:00	IWM	ETF	115.02	115.26	113.94	114.02	5029200.0
2016-07-05 10:00:00	IWM	ETF	114.01	114.2199	113.55	113.65	4400585.0
2016-07-05 11:00:00	IWM	ETF	113.66	113.75	113.14	113.32	4733536.0
2016-07-05 12:00:00	IWM	ETF	113.32	113.72	113.23	113.46	2274869.0
2016-07-05 13:00:00	IWM	ETF	113.45	113.5199	113.065	113.24	2258338.0
2016-07-05 14:00:00	IWM	ETF	113.24	113.74	113.21	113.56	1998211.0
2016-07-05 15:00:00	IWM	ETF	113.55	114.03	113.48	113.7	4358029.0
2016-07-05 16:00:00	IWM	ETF	113.7	113.82	113.64	113.8	954371.0
2016-07-05 17:00:00	IWM	ETF	113.82	113.82	113.69	113.69	2762.0
2016-07-05 18:00:00	IWM	ETF	113.7	113.7	113.65	113.65	1550.0
2016-07-05 19:00:00	IWM	ETF	113.72	113.78	113.64	113.64	4600.0
2016-07-05 04:00:00	DIA	ETF	178.61	178.61	178.39	178.42	46800.0
2016-07-05 05:00:00	DIA	ETF	178.52	179.0	178.52	179.0	200.0

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

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